Skip site navigation (1) Skip section navigation (2)

timetz regression test is showing several DST-related failures

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 (view raw or flat)
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

======================================================================


Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2001-10-30 18:58:01
Subject: Postings from Bruce and Olivier rejected ...
Previous:From: Masaru SugawaraDate: 2001-10-30 17:49:42
Subject: Re: Odd error in complex query (7.2): Sub-SELECT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group