Обсуждение: regression test failure on abstime

Поиск
Список
Период
Сортировка

regression test failure on abstime

От
"Thalis A. Kalfigopoulos"
Дата:
Trying a new 7.1.2 installation when running gmake check I get a failure at the abstime test. The regression.diffs file
containsthe 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



Re: regression test failure on abstime

От
Thomas Lockhart
Дата:
> Trying a new 7.1.2 installation when running gmake check I get a failure at the abstime test. The regression.diffs
filecontains 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

Re: regression test failure on abstime

От
Tom Lane
Дата:
"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