From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | timetz regression test is showing several DST-related failures |
Date: | 2001-10-30 18:00:18 |
Message-ID: | 29303.1004464818@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I am seeing the attached regression diffs on timetz, which passed
last week. It looks like all of these are related to the fact that
unmarked timetz values are now presumed to be PST (-8) not PST (-7).
regards, tom lane
*** ./expected/timetz.out Wed Oct 3 01:29:26 2001
--- ./results/timetz.out Tue Oct 30 12:51:38 2001
***************
*** 33,62 ****
00:01:00-07
01:00:00-07
02:03:00-07
! (3 rows)
SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';
Seven
----------------
07:07:00-08
- 08:08:00-04
11:59:00-07
12:00:00-07
12:01:00-07
23:59:00-07
23:59:59.99-07
! (7 rows)
SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00';
None
! ------
! (0 rows)
SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00';
Ten
----------------
- 00:01:00-07
- 01:00:00-07
02:03:00-07
07:07:00-08
08:08:00-04
--- 33,62 ----
00:01:00-07
01:00:00-07
02:03:00-07
! 08:08:00-04
! (4 rows)
SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';
Seven
----------------
07:07:00-08
11:59:00-07
12:00:00-07
12:01:00-07
23:59:00-07
23:59:59.99-07
! (6 rows)
SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00';
None
! -------------
! 00:01:00-07
! 01:00:00-07
! (2 rows)
SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00';
Ten
----------------
02:03:00-07
07:07:00-08
08:08:00-04
***************
*** 65,71 ****
12:01:00-07
23:59:00-07
23:59:59.99-07
! (10 rows)
--
-- TIME simple math
--- 65,71 ----
12:01:00-07
23:59:00-07
23:59:59.99-07
! (8 rows)
--
-- TIME simple math
======================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2001-10-30 18:58:01 | Postings from Bruce and Olivier rejected ... |
Previous Message | Masaru Sugawara | 2001-10-30 17:49:42 | Re: Odd error in complex query (7.2): Sub-SELECT |