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)