Horton

Re: [HACKERS] float8 regression test

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-hackers@postgresql.org
Date: 1998-02-02T05:48:46Z
Lists: pgsql-hackers 
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