Regression tests failing on abstime due to test date being before 'current' - Mailing list pgsql-general

From Lincoln Yeoh
Subject Regression tests failing on abstime due to test date being before 'current'
Date
Msg-id 3.0.5.32.20010716110851.00915360@192.228.128.13
Whole thread Raw
Responses Re: Regression tests failing on abstime due to test date being before 'current'  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
From: expected/abstime.out

SELECT '' AS six, ABSTIME_TBL.*
   WHERE ABSTIME_TBL.f1 < abstime 'Jun 30, 2001';
 six |              f1
-----+------------------------------
     | Sun Jan 14 03:14:21 1973 PST
     | Mon May 01 00:30:30 1995 PDT
     | epoch
     | current
     | -infinity
     | Sat May 10 23:59:12 1947 PST
(6 rows)

---
In my system current is now after Jun 30 and so doesn't appear. If the test
passes it's actually a huge problem ;).

Is it necessary to pick dates so close in the "future" when setting up the
test? How about setting such dates to some date when the next version is
likely to be out :). Then at least if it fails it's a convenient time to
ask newbies to upgrade to 7.X or even 8.

It's just a very minor issue, but this has happened before - one release
had the testdate < Y2K.

Cheerio,
Link.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Translators wanted
Next
From: Bruce Momjian
Date:
Subject: Re: Regression tests failing on abstime due to test date being before 'current'