BUG #1128: horology tests fails while make check (7.4.2)

Yea, this is because of daylight savings time --- it will be OK
tomorrow.

---------------------------------------------------------------------------

PostgreSQL Bugs List wrote:

The following bug has been logged online:

Bug reference: 1128
Logged by: J 6M

Email address: j6m@adm.estp.fr

PostgreSQL version: 7.4

Operating system: powerpc-ibm-aix4.3.3.0

Description: horology tests fails while make check (7.4.2)

Details:

On a powerpc-ibm-aix4.3.3.0, while doing make check with 7.4.2,
horlogy test failed. (Was correct with 7.4.1.)
---

*** ./expected/horology-solaris-1947.out        Thu Sep 25 18:16:35 2003
--- ./results/horology.out      Mon Apr  5 13:09:38 2004
***************
*** 577,583 ****
SELECT (timestamp with time zone 'today' = (timestamp with time zone 
'yesterday' + interval '1 day')) as "True"; 
True
------
!  t
(1 row)

SELECT (timestamp with time zone 'today' = (timestamp with time zone 
'tomorrow' - interval '1 day')) as "True"; 
--- 577,583 ----
SELECT (timestamp with time zone 'today' = (timestamp with time zone 
'yesterday' + interval '1 day')) as "True"; 
True
------
!  f
(1 row)

SELECT (timestamp with time zone 'today' = (timestamp with time zone
'tomorrow' - interval '1 day')) as "True";
***************
*** 589,595 ****
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";
--- 589,595 ----
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";

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Sorry, but ST to DT change occured on the last Sunday of March here. So it
is not related to that. Moreover, I checked both 7.4.2 and 7.4.1 on the same
day, and 7.4.1 was correct.
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "J 6M" <j6m@adm.estp.fr>
Cc: <pgsql-bugs@postgresql.org>
Sent: Tuesday, April 06, 2004 3:37 PM
Subject: Re: [BUGS] BUG #1128: horology tests fails while make check (7.4.2)

Yea, this is because of daylight savings time --- it will be OK
tomorrow.

--------------------------------------------------------------------------

-

j 6m wrote:

Sorry, but ST to DT change occured on the last Sunday of March here. So it
is not related to that. Moreover, I checked both 7.4.2 and 7.4.1 on the same
day, and 7.4.1 was correct.

Wow, that is bizarre. However, I think the tests are run with US
timezones. Those errors are very similar to the ones I saw during
daylight savings time here, and they went away the next day.

I can't imagine anything that changed between 7.4.1 and 7.4.2 that would
cause this. However, it is possible the US day changed during your
tests.

---------------------------------------------------------------------------

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "J 6M" <j6m@adm.estp.fr>
Cc: <pgsql-bugs@postgresql.org>
Sent: Tuesday, April 06, 2004 3:37 PM
Subject: Re: [BUGS] BUG #1128: horology tests fails while make check (7.4.2)

Yea, this is because of daylight savings time --- it will be OK
tomorrow.

--------------------------------------------------------------------------

-

PostgreSQL Bugs List wrote:

The following bug has been logged online:

Bug reference: 1128
Logged by: J 6M

Email address: j6m@adm.estp.fr

PostgreSQL version: 7.4

Operating system: powerpc-ibm-aix4.3.3.0

Description: horology tests fails while make check (7.4.2)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bruce Momjian <pgman@candle.pha.pa.us> writes:

Wow, that is bizarre. However, I think the tests are run with US
timezones.

The regression tests run in PST8PDT zone, and therefore the US
transition days are the ones that count, not your local ones.
This is even documented ;-) ... see section 26.2.3 in the 7.4 docs.

regards, tom lane