I have seen following regression failure with current(I cvs up'ed 10
minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
2.2.4.
--
Tatsuo Ishii

*** ./expected/horology.out	Mon Sep 29 17:53:48 2003
--- ./results/horology.out	Sun Oct 26 20:21:59 2003
***************
*** 583,595 ****
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
   True 
  ------
!  t
  (1 row)
  
  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";
--- 583,595 ----
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
   True 
  ------
!  f
  (1 row)
  
  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";
***************
*** 836,842 ****
              + interval '02:01' AS time with time zone) AS time) AS "03:31:00";
   03:31:00 
  ----------
!  03:31:00
  (1 row)
  
  SELECT CAST(cast(date 'today' + time with time zone '03:30'
--- 836,842 ----
              + interval '02:01' AS time with time zone) AS time) AS "03:31:00";
   03:31:00 
  ----------
!  02:31:00
  (1 row)
  
  SELECT CAST(cast(date 'today' + time with time zone '03:30'

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



Sun, 26 Oct 2003 20:27:52 +0900 (JST)
Tatsuo Ishii <t-ishii@sra.co.jp>
regression failure with current
On Sun, Oct 26, 2003 at 08:27:52PM +0900, Tatsuo Ishii wrote:
> I have seen following regression failure with current(I cvs up'ed 10
> minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
> 2.2.4.

Maybe the change of TZ (summer to winter time) tonight caused
this.


Kurt


Sun, 26 Oct 2003 12:35:35 +0100
Kurt Roeckx <Q@ping.be>
Re: regression failure with current
Kurt Roeckx wrote:
> On Sun, Oct 26, 2003 at 08:27:52PM +0900, Tatsuo Ishii wrote:
> > I have seen following regression failure with current(I cvs up'ed 10
> > minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
> > 2.2.4.
> 
> Maybe the change of TZ (summer to winter time) tonight caused
> this.

Yes, I saw identical failures --- must be timezone.

-- 
  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

Sun, 26 Oct 2003 08:54:20 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: regression failure with current
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Kurt Roeckx wrote:
>> On Sun, Oct 26, 2003 at 08:27:52PM +0900, Tatsuo Ishii wrote:
>>> I have seen following regression failure with current(I cvs up'ed 10
>>> minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
>>> 2.2.4.
>> 
>> Maybe the change of TZ (summer to winter time) tonight caused
>> this.

> Yes, I saw identical failures --- must be timezone.

Sheesh guys, "the horology tests fail at DST boundaries" is not only
ancient project folklore, but is well documented:
http://www.postgresql.org/docs/7.3/static/regress-evaluation.html#AEN23380
saith

: Some of the queries in the horology test will fail if you run the test
: on the day of a daylight-saving time changeover, or the day before or
: after one. These queries assume that the intervals between midnight
: yesterday, midnight today and midnight tomorrow are exactly
: twenty-four hours -- which is wrong if daylight-saving time went into
: or out of effect meanwhile.

I could understand some newbie making these complaints, but y'all have
little excuse...

			regards, tom lane

Mon, 27 Oct 2003 01:21:56 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: regression failure with current 