Horton

float8 regression test

Marc G. Fournier <scrappy@hub.org>

View thread
From: The Hermit Hacker <scrappy@hub.org>
To: pgsql-hackers@postgresql.org
Date: 1998-02-02T02:17:31Z
Lists: pgsql-hackers 
*** expected/float8.out Wed Jan 28 22:05:29 1998
--- results/float8.out  Sun Feb  1 21:30:39 1998
***************
*** 9,17 ****
  QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  ERROR:  Bad float8 input format '-10e400'
  QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
- ERROR:  Bad float8 input format '10e-400'
  QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
- ERROR:  Bad float8 input format '-10e-400'
  QUERY: SELECT '' AS five, FLOAT8_TBL.*;
  five|f1                  
  ----+--------------------

If I try this manually, teh 10e-400 and -10e-400 produce a value of
"0"...are we considering this to be correct?  Or is this a bug?  

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org