From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] float8 regression test |
Date: | 1998-02-02 05:48:46 |
Message-ID: | 34D55E3E.ED8393ED@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-02-02 05:56:43 | Re: [HACKERS] What is ##? |
Previous Message | Bruce Momjian | 1998-02-02 05:08:37 | Re: [HACKERS] VACUUM ANALYZE Problem (debugging output) |