The following bug has been logged online:

Bug reference: 1128
Logged by: J 6M

Email address: j6m (AT) adm (DOT) 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 (AT) postgresql (DOT) org

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


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

PostgreSQL Bugs List wrote:
--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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

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

j 6m wrote:
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.


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


--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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.pa.us>
To: "J 6M" <j6m (AT) adm (DOT) estp.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)



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Bruce Momjian <pgman (AT) candle (DOT) pha.pa.us> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match