Thread

Another regression test failure.

Keith Parks <emkxp01@mtcc.demon.co.uk> — 1998-01-07T00:39:57Z

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)