Another regression test failure.

From: Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk>
To: hackers(at)postgresql(dot)org
Subject: Another regression test failure.
Date: 1998-01-07 00:39:57
Message-ID: 199801070039.AAA16523@mtcc.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Anyone have any ideas about this error in the horology regression test?

The platform is SPARC-Linux running the latest CVS build.

Keith.

QUERY: CREATE TABLE TEMP_DATETIME (f1 datetime);
QUERY: INSERT INTO TEMP_DATETIME (f1)
SELECT d1 FROM DATETIME_TBL
WHERE d1 BETWEEN '13-jun-1957' AND '1-jan-1997'
OR d1 BETWEEN '1-jan-1999' AND '1-jan-2010';
ABORT: floating point exception! The last floating point operation either
exceeded legal ranges or was a divide by zero
QUERY: SELECT '' AS ten, f1 AS datetime
FROM TEMP_DATETIME
ORDER BY datetime;
ten|datetime
---+--------
(0 rows)

Browse pgsql-hackers by date

  From Date Subject
Next Message Darren King 1998-01-07 00:52:42 Tape files and MAXBLCKSZ vs. BLCKSZ
Previous Message Keith Parks 1998-01-07 00:35:20 VACUUM error on CVS build 07-JAN-98