Re: [HACKERS] Regression Testing on REL6_5_PATCHES

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Regression Testing on REL6_5_PATCHES
Date: 1999-11-02 05:43:21
Message-ID: 10664.941521401@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> writes:
> I have hit an unexpected error in regression testing the
> REL6_5_PATCHES branch in preparing for 6.5.3. For the first time, a
> test other than float or geometry failed -- with a weird result.
> Datetime failed.

Yup, it's the biannual daylight-savings-time transition weirdness.
If you look closely, all those tests assume that today midnight to
tomorrow midnight is 24 hours. Guess what: at this time of year it
ain't. In another day or so the results will be back to normal, at
least in the US of A. We'll likely see another gripe or two from
overseas before the DST-switch season is over.

I've been around this project for a year and a half now, and we've
heard complaints like this at each of the three DST transitions that
I remember. (I sent in some alarmed reports myself, first time I
saw it.) I've tried to interest Thomas in DST-proofing the regress
tests, but he doesn't seem to think it's worth fixing.

There should be something about this in the "expected failures"
section of the regress test docs, but right at the moment I don't
see anything there.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message nicks.emails 1999-11-02 06:18:34 Backend terminated abnormally
Previous Message Tom Lane 1999-11-02 05:31:04 Re: [HACKERS] sort on huge table