regression test failure on abstime

Started by Thalis A. Kalfigopoulosover 24 years ago3 messagesgeneral
Jump to latest
#1Thalis A. Kalfigopoulos
thalis@cs.pitt.edu

Trying a new 7.1.2 installation when running gmake check I get a failure at the abstime test. The regression.diffs file contains the following:

*** ./expected/abstime.out      Thu May  3 15:00:37 2001
--- ./results/abstime.out       Fri Jul 20 11:12:54 2001
***************
*** 47,56 ****
       | 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)
  SELECT '' AS six, ABSTIME_TBL.*
     WHERE ABSTIME_TBL.f1 > abstime '-infinity';
--- 47,55 ----
       | Sun Jan 14 03:14:21 1973 PST
       | Mon May 01 00:30:30 1995 PDT
       | epoch
       | -infinity
       | Sat May 10 23:59:12 1947 PST
! (5 rows)

SELECT '' AS six, ABSTIME_TBL.*
WHERE ABSTIME_TBL.f1 > abstime '-infinity';

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

Hints what's wrong?

TIA,
thalis

#2Thomas Lockhart
lockhart@fourpalms.org
In reply to: Thalis A. Kalfigopoulos (#1)
Re: regression test failure on abstime

Trying a new 7.1.2 installation when running gmake check I get a failure at the abstime test. The regression.diffs file contains the following:

...

- | current

...

Hints what's wrong?

Yes. When that regression test was written, July 20, 2001 was far in the
future, and there was concern about Y2K issues etc. There is an explicit
test for dates before a time on or around that date, and "current"
suddenly no longer passes that test!

No problem with your installation, and this is already fixed in current
sources.

btw, we are likely to drop support for "current" in the date/time types
in the next release for several reasons, not the least of which is that
it is a little- or never-used feature.

- Thomas

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Thalis A. Kalfigopoulos (#1)
Re: regression test failure on abstime

"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:

Hints what's wrong?

Nothing. If you look closely, the abstime test is comparing 'current'
against '30 June 2001'. This Y2K+18months bogosity escaped notice until
this month :-(

regards, tom lane