float8 regression test

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: float8 regression test
Date: 1998-02-02 02:17:31
Message-ID: Pine.BSF.3.96.980201221541.12562j-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-02-02 02:24:04 What is ##?
Previous Message The Hermit Hacker 1998-02-02 01:58:08 Re: [HACKERS] Variable block size...