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

The following bug has been logged online:

Bug reference: 1128
Logged by: J 6M

Email address: j6m(at)adm(dot)estp(dot)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";

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

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(at)adm(dot)estp(dot)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(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us>
To: "J 6M" <j6m(at)adm(dot)estp(dot)fr>
Cc: <pgsql-bugs(at)postgresql(dot)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(at)adm(dot)estp(dot)fr
> >
> > PostgreSQL version: 7.4
> >
> > Operating system: powerpc-ibm-aix4.3.3.0
> >
> > Description: horology tests fails while make check (7.4.2)
> >

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(at)candle(dot)pha(dot)pa(dot)us>
> To: "J 6M" <j6m(at)adm(dot)estp(dot)fr>
> Cc: <pgsql-bugs(at)postgresql(dot)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(at)adm(dot)estp(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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