Regression tests failing on abstime due to test date being before 'current'

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Regression tests failing on abstime due to test date being before 'current'
Date: 2001-07-16 03:08:51
Message-ID: 3.0.5.32.20010716110851.00915360@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-07-16 03:43:13 Re: Regression tests failing on abstime due to test date being before 'current'
Previous Message Tom Lane 2001-07-15 23:09:06 Re: Translators wanted