float8 regression test
Started by The Hermit Hackeralmost 28 years ago2 messages
*** 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
Re: [HACKERS] float8 regression test
The Hermit Hacker wrote:
*** 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?
Bug. On my 980112 snapshot, I get
postgres=> select '-10e400'::float8;
ERROR: Bad float8 input format '-10e400'
Hope it hasn't changed.
- Tom