Thread

float8 regression test

Marc G. Fournier <scrappy@hub.org> — 1998-02-02T02:17:31Z

*** 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

Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-02-02T05:48:46Z

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