Regression Testing on REL6_5_PATCHES

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

Browse pgsql-hackers by date

  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