Another regression test failure.
Keith Parks <emkxp01@mtcc.demon.co.uk>
From: Keith Parks <emkxp01@mtcc.demon.co.uk>
To: hackers@postgresql.org
Date: 1998-01-07T00:39:57Z
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)