From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | 7.3 beta3 regression failure |
Date: | 2002-10-28 04:48:39 |
Message-ID: | 20021028.134839.95889965.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm seeing this on my Linux box (kernel 2.4.18, glibc 2.2.4):
*** ./expected/horology.out Thu Sep 19 06:35:25 2002
--- ./results/horology.out Mon Oct 28 13:42:39 2002
***************
*** 537,549 ****
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
True
------
! t
(1 row)
SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
True
------
! t
(1 row)
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 537,549 ----
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
True
------
! f
(1 row)
SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
True
------
! f
(1 row)
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
***************
*** 790,796 ****
+ interval '02:01' AS time with time zone) AS time) AS "03:31:00";
03:31:00
----------
! 03:31:00
(1 row)
SELECT CAST(cast(date 'today' + time with time zone '03:30'
--- 790,796 ----
+ interval '02:01' AS time with time zone) AS time) AS "03:31:00";
03:31:00
----------
! 02:31:00
(1 row)
SELECT CAST(cast(date 'today' + time with time zone '03:30'
======================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2002-10-28 06:05:17 | Re: 7.3 beta3 regression failure |
Previous Message | Marc G. Fournier | 2002-10-28 03:59:48 | PostgreSQL v7.3beta3 Released |