Thread: 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@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"; ======================================================================
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
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
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. > > > -------------------------------------------------------------------------- - > > 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 <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