Обсуждение: 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 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
> 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
"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