I have hit an unexpected error in regression testing the REL6_5_PATCHES branch
in preparing for 6.5.3. For the first time, a test other than float or
geometry failed -- with a weird result. Datetime failed. Here is the section
of regression.diffs for datetime:
----------------------------
*** expected/datetime.out Wed Apr 14 22:19:01 1999
--- results/datetime.out Mon Nov 1 22:40:45 1999
***************
*** 1,7 **** QUERY: SELECT ('today'::datetime = ('yesterday'::datetime + '1 day'::timespan)) as "True"; True ----
! t (1 row) QUERY: SELECT ('today'::datetime = ('tomorrow'::datetime - '1 day'::timespan)) as "True";
--- 1,7 ---- QUERY: SELECT ('today'::datetime = ('yesterday'::datetime + '1 day'::timespan)) as "True"; True ----
! f (1 row) QUERY: SELECT ('today'::datetime = ('tomorrow'::datetime - '1 day'::timespan)) as "True";
***************
*** 13,19 **** QUERY: SELECT ('tomorrow'::datetime = ('yesterday'::datetime + '2 days'::timespan)) as "True"; True
----
! t (1 row) QUERY: SELECT ('current'::datetime = 'now'::datetime) as "True";
--- 13,19 ---- QUERY: SELECT ('tomorrow'::datetime = ('yesterday'::datetime + '2 days'::timespan)) as "True"; True
----
! f (1 row) QUERY: SELECT ('current'::datetime = 'now'::datetime) as "True";
***************
*** 69,75 **** QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'today'::datetime - '1 day'::timespan; one
---
! 1 (1 row) QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'now'::datetime;
--- 69,75 ---- QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'today'::datetime - '1 day'::timespan; one
---
! 0 (1 row) QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'now'::datetime;
-------------------------------
Misc also failed -- but that was due to the pgaccess relations from my pgaccess
testing.
System: RedHat Linux 6.1 -- kernel 2.2.12 w/ glibc 2.1.2.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
