From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Regression Testing on REL6_5_PATCHES |
Date: | 1999-11-02 03:56:14 |
Message-ID: | 99110123021602.07347@lorc.wgcr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-11-02 04:04:35 | Re: [HACKERS] Backend terminated abnormally |
Previous Message | Lamar Owen | 1999-11-02 03:49:38 | Re: [HACKERS] pgaccess 0.98 |