Thread: Horology regress test changed?

Horology regress test changed?

From

Tom Lane

Date:

06 November 2000, 16:22:00

I'm seeing a whole bunch of miscompares in the horology test today.
Is this stuff supposed to have changed behavior?
        regards, tom lane

*** ./expected/horology-no-DST-before-1970.out    Fri Sep 15 15:36:24 2000
--- ./results/horology.out    Mon Nov  6 13:14:35 2000
***************
*** 109,116 ****      | epoch                        | @ 1 day 2 hours 3 mins 4 secs | Thu Jan 01 18:03:04 1970 PST
| epoch                        | @ 10 days                     | Sat Jan 10 16:00:00 1970 PST      | epoch
         | @ 3 mons                      | Tue Mar 31 16:00:00 1970 PST
 
!      | epoch                        | @ 5 mons                      | Sun May 31 17:00:00 1970 PDT
!      | epoch                        | @ 5 mons 12 hours             | Mon Jun 01 05:00:00 1970 PDT      | epoch
                | @ 6 years                     | Wed Dec 31 16:00:00 1975 PST      | Wed Feb 28 17:32:01 1996 PST | @
14secs ago                 | Wed Feb 28 17:31:47 1996 PST      | Wed Feb 28 17:32:01 1996 PST | @ 1 min
     | Wed Feb 28 17:33:01 1996 PST
 
--- 109,116 ----      | epoch                        | @ 1 day 2 hours 3 mins 4 secs | Thu Jan 01 18:03:04 1970 PST
| epoch                        | @ 10 days                     | Sat Jan 10 16:00:00 1970 PST      | epoch
         | @ 3 mons                      | Tue Mar 31 16:00:00 1970 PST
 
!      | epoch                        | @ 5 mons                      | Sun May 31 16:00:00 1970 PDT
!      | epoch                        | @ 5 mons 12 hours             | Mon Jun 01 04:00:00 1970 PDT      | epoch
                | @ 6 years                     | Wed Dec 31 16:00:00 1975 PST      | Wed Feb 28 17:32:01 1996 PST | @
14secs ago                 | Wed Feb 28 17:31:47 1996 PST      | Wed Feb 28 17:32:01 1996 PST | @ 1 min
     | Wed Feb 28 17:33:01 1996 PST
 
***************
*** 127,141 ****      | Wed Feb 28 17:32:01 1996 PST | @ 10 days                     | Sat Mar 09 17:32:01 1996 PST
| Thu Feb 29 17:32:01 1996 PST | @ 10 days                     | Sun Mar 10 17:32:01 1996 PST      | Fri Mar 01
17:32:011996 PST | @ 10 days                     | Mon Mar 11 17:32:01 1996 PST
 
!      | Wed Feb 28 17:32:01 1996 PST | @ 3 mons                      | Tue May 28 18:32:01 1996 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 3 mons                      | Wed May 29 18:32:01 1996 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 3 mons                      | Sat Jun 01 18:32:01 1996 PDT
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons                      | Sun Jul 28 18:32:01 1996 PDT
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours             | Mon Jul 29 06:32:01 1996 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons                      | Mon Jul 29 18:32:01 1996 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours             | Tue Jul 30 06:32:01 1996 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons                      | Thu Aug 01 18:32:01 1996 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours             | Fri Aug 02 06:32:01 1996 PDT      | Mon Dec 30
17:32:011996 PST | @ 14 secs ago                 | Mon Dec 30 17:31:47 1996 PST      | Mon Dec 30 17:32:01 1996 PST | @
1min                       | Mon Dec 30 17:33:01 1996 PST      | Mon Dec 30 17:32:01 1996 PST | @ 5 hours
     | Mon Dec 30 22:32:01 1996 PST
 
--- 127,141 ----      | Wed Feb 28 17:32:01 1996 PST | @ 10 days                     | Sat Mar 09 17:32:01 1996 PST
| Thu Feb 29 17:32:01 1996 PST | @ 10 days                     | Sun Mar 10 17:32:01 1996 PST      | Fri Mar 01
17:32:011996 PST | @ 10 days                     | Mon Mar 11 17:32:01 1996 PST
 
!      | Wed Feb 28 17:32:01 1996 PST | @ 3 mons                      | Tue May 28 17:32:01 1996 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 3 mons                      | Wed May 29 17:32:01 1996 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 3 mons                      | Sat Jun 01 17:32:01 1996 PDT
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons                      | Sun Jul 28 17:32:01 1996 PDT
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours             | Mon Jul 29 05:32:01 1996 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons                      | Mon Jul 29 17:32:01 1996 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours             | Tue Jul 30 05:32:01 1996 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons                      | Thu Aug 01 17:32:01 1996 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours             | Fri Aug 02 05:32:01 1996 PDT      | Mon Dec 30
17:32:011996 PST | @ 14 secs ago                 | Mon Dec 30 17:31:47 1996 PST      | Mon Dec 30 17:32:01 1996 PST | @
1min                       | Mon Dec 30 17:33:01 1996 PST      | Mon Dec 30 17:32:01 1996 PST | @ 5 hours
     | Mon Dec 30 22:32:01 1996 PST
 
***************
*** 148,157 ****      | Tue Dec 31 17:32:01 1996 PST | @ 10 days                     | Fri Jan 10 17:32:01 1997 PST
| Mon Dec 30 17:32:01 1996 PST | @ 3 mons                      | Sun Mar 30 17:32:01 1997 PST      | Tue Dec 31
17:32:011996 PST | @ 3 mons                      | Mon Mar 31 17:32:01 1997 PST
 
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons                      | Fri May 30 18:32:01 1997 PDT
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours             | Sat May 31 06:32:01 1997 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons                      | Sat May 31 18:32:01 1997 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours             | Sun Jun 01 06:32:01 1997 PDT      | Fri Dec 31
17:32:011999 PST | @ 14 secs ago                 | Fri Dec 31 17:31:47 1999 PST      | Fri Dec 31 17:32:01 1999 PST | @
1min                       | Fri Dec 31 17:33:01 1999 PST      | Fri Dec 31 17:32:01 1999 PST | @ 5 hours
     | Fri Dec 31 22:32:01 1999 PST
 
--- 148,157 ----      | Tue Dec 31 17:32:01 1996 PST | @ 10 days                     | Fri Jan 10 17:32:01 1997 PST
| Mon Dec 30 17:32:01 1996 PST | @ 3 mons                      | Sun Mar 30 17:32:01 1997 PST      | Tue Dec 31
17:32:011996 PST | @ 3 mons                      | Mon Mar 31 17:32:01 1997 PST
 
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons                      | Fri May 30 17:32:01 1997 PDT
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours             | Sat May 31 05:32:01 1997 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons                      | Sat May 31 17:32:01 1997 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours             | Sun Jun 01 05:32:01 1997 PDT      | Fri Dec 31
17:32:011999 PST | @ 14 secs ago                 | Fri Dec 31 17:31:47 1999 PST      | Fri Dec 31 17:32:01 1999 PST | @
1min                       | Fri Dec 31 17:33:01 1999 PST      | Fri Dec 31 17:32:01 1999 PST | @ 5 hours
     | Fri Dec 31 22:32:01 1999 PST
 
***************
*** 189,213 ****      | Wed Mar 15 08:14:01 2000 PST | @ 10 days                     | Sat Mar 25 08:14:01 2000 PST
| Fri Dec 31 17:32:01 1999 PST | @ 3 mons                      | Fri Mar 31 17:32:01 2000 PST      | Sat Jan 01
17:32:012000 PST | @ 3 mons                      | Sat Apr 01 17:32:01 2000 PST
 
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons                      | Wed May 31 18:32:01 2000 PDT
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours             | Thu Jun 01 06:32:01 2000 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons                      | Thu Jun 01 18:32:01 2000 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours             | Fri Jun 02 06:32:01 2000 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 3 mons                      | Thu Jun 15 02:14:05 2000 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 3 mons                      | Thu Jun 15 03:14:03 2000 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 3 mons                      | Thu Jun 15 04:14:04 2000 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 3 mons                      | Thu Jun 15 05:14:02 2000 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 3 mons                      | Thu Jun 15 09:14:01 2000 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons                      | Tue Aug 15 02:14:05 2000 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons                      | Tue Aug 15 03:14:03 2000 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons                      | Tue Aug 15 04:14:04 2000 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons                      | Tue Aug 15 05:14:02 2000 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons                      | Tue Aug 15 09:14:01 2000 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 14:14:05 2000 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 15:14:03 2000 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 16:14:04 2000 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 17:14:02 2000 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 21:14:01 2000 PDT      | Sun Dec 31
17:32:012000 PST | @ 14 secs ago                 | Sun Dec 31 17:31:47 2000 PST      | Sun Dec 31 17:32:01 2000 PST | @
1min                       | Sun Dec 31 17:33:01 2000 PST      | Sun Dec 31 17:32:01 2000 PST | @ 5 hours
     | Sun Dec 31 22:32:01 2000 PST
 
--- 189,213 ----      | Wed Mar 15 08:14:01 2000 PST | @ 10 days                     | Sat Mar 25 08:14:01 2000 PST
| Fri Dec 31 17:32:01 1999 PST | @ 3 mons                      | Fri Mar 31 17:32:01 2000 PST      | Sat Jan 01
17:32:012000 PST | @ 3 mons                      | Sat Apr 01 17:32:01 2000 PST
 
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons                      | Wed May 31 17:32:01 2000 PDT
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours             | Thu Jun 01 05:32:01 2000 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons                      | Thu Jun 01 17:32:01 2000 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours             | Fri Jun 02 05:32:01 2000 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 3 mons                      | Thu Jun 15 01:14:05 2000 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 3 mons                      | Thu Jun 15 02:14:03 2000 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 3 mons                      | Thu Jun 15 03:14:04 2000 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 3 mons                      | Thu Jun 15 04:14:02 2000 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 3 mons                      | Thu Jun 15 08:14:01 2000 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons                      | Tue Aug 15 01:14:05 2000 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons                      | Tue Aug 15 02:14:03 2000 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons                      | Tue Aug 15 03:14:04 2000 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons                      | Tue Aug 15 04:14:02 2000 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons                      | Tue Aug 15 08:14:01 2000 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 13:14:05 2000 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 14:14:03 2000 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 15:14:04 2000 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 16:14:02 2000 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 20:14:01 2000 PDT      | Sun Dec 31
17:32:012000 PST | @ 14 secs ago                 | Sun Dec 31 17:31:47 2000 PST      | Sun Dec 31 17:32:01 2000 PST | @
1min                       | Sun Dec 31 17:33:01 2000 PST      | Sun Dec 31 17:32:01 2000 PST | @ 5 hours
     | Sun Dec 31 22:32:01 2000 PST
 
***************
*** 219,229 ****      | Sun Dec 31 17:32:01 2000 PST | @ 10 days                     | Wed Jan 10 17:32:01 2001 PST
| Mon Jan 01 17:32:01 2001 PST | @ 10 days                     | Thu Jan 11 17:32:01 2001 PST      | Sun Dec 31
17:32:012000 PST | @ 3 mons                      | Sat Mar 31 17:32:01 2001 PST
 
!      | Mon Jan 01 17:32:01 2001 PST | @ 3 mons                      | Sun Apr 01 18:32:01 2001 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons                      | Thu May 31 18:32:01 2001 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours             | Fri Jun 01 06:32:01 2001 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons                      | Fri Jun 01 18:32:01 2001 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours             | Sat Jun 02 06:32:01 2001 PDT      | Wed Feb 28
17:32:011996 PST | @ 6 years                     | Thu Feb 28 17:32:01 2002 PST      | Thu Feb 29 17:32:01 1996 PST | @
6years                     | Thu Feb 28 17:32:01 2002 PST      | Fri Mar 01 17:32:01 1996 PST | @ 6 years
     | Fri Mar 01 17:32:01 2002 PST
 
--- 219,229 ----      | Sun Dec 31 17:32:01 2000 PST | @ 10 days                     | Wed Jan 10 17:32:01 2001 PST
| Mon Jan 01 17:32:01 2001 PST | @ 10 days                     | Thu Jan 11 17:32:01 2001 PST      | Sun Dec 31
17:32:012000 PST | @ 3 mons                      | Sat Mar 31 17:32:01 2001 PST
 
!      | Mon Jan 01 17:32:01 2001 PST | @ 3 mons                      | Sun Apr 01 17:32:01 2001 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons                      | Thu May 31 17:32:01 2001 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours             | Fri Jun 01 05:32:01 2001 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons                      | Fri Jun 01 17:32:01 2001 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours             | Sat Jun 02 05:32:01 2001 PDT      | Wed Feb 28
17:32:011996 PST | @ 6 years                     | Thu Feb 28 17:32:01 2002 PST      | Thu Feb 29 17:32:01 1996 PST | @
6years                     | Thu Feb 28 17:32:01 2002 PST      | Fri Mar 01 17:32:01 1996 PST | @ 6 years
     | Fri Mar 01 17:32:01 2002 PST
 
***************
*** 299,310 ****      | Wed Mar 15 08:14:01 2000 PST | @ 6 years                     | Tue Mar 15 08:14:01 1994 PST
| Sun Dec 31 17:32:01 2000 PST | @ 6 years                     | Sat Dec 31 17:32:01 1994 PST      | Mon Jan 01
17:32:012001 PST | @ 6 years                     | Sun Jan 01 17:32:01 1995 PST
 
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours             | Thu Sep 28 06:32:01 1995 PDT
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons                      | Thu Sep 28 18:32:01 1995 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours             | Fri Sep 29 06:32:01 1995 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons                      | Fri Sep 29 18:32:01 1995 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours             | Sun Oct 01 06:32:01 1995 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons                      | Sun Oct 01 18:32:01 1995 PDT      | Wed Feb 28
17:32:011996 PST | @ 3 mons                      | Tue Nov 28 17:32:01 1995 PST      | Thu Feb 29 17:32:01 1996 PST | @
3mons                      | Wed Nov 29 17:32:01 1995 PST      | Fri Mar 01 17:32:01 1996 PST | @ 3 mons
     | Fri Dec 01 17:32:01 1995 PST
 
--- 299,310 ----      | Wed Mar 15 08:14:01 2000 PST | @ 6 years                     | Tue Mar 15 08:14:01 1994 PST
| Sun Dec 31 17:32:01 2000 PST | @ 6 years                     | Sat Dec 31 17:32:01 1994 PST      | Mon Jan 01
17:32:012001 PST | @ 6 years                     | Sun Jan 01 17:32:01 1995 PST
 
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours             | Thu Sep 28 05:32:01 1995 PDT
!      | Wed Feb 28 17:32:01 1996 PST | @ 5 mons                      | Thu Sep 28 17:32:01 1995 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours             | Fri Sep 29 05:32:01 1995 PDT
!      | Thu Feb 29 17:32:01 1996 PST | @ 5 mons                      | Fri Sep 29 17:32:01 1995 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours             | Sun Oct 01 05:32:01 1995 PDT
!      | Fri Mar 01 17:32:01 1996 PST | @ 5 mons                      | Sun Oct 01 17:32:01 1995 PDT      | Wed Feb 28
17:32:011996 PST | @ 3 mons                      | Tue Nov 28 17:32:01 1995 PST      | Thu Feb 29 17:32:01 1996 PST | @
3mons                      | Wed Nov 29 17:32:01 1995 PST      | Fri Mar 01 17:32:01 1996 PST | @ 3 mons
     | Fri Dec 01 17:32:01 1995 PST
 
***************
*** 323,334 ****      | Fri Mar 01 17:32:01 1996 PST | @ 5 hours                     | Fri Mar 01 12:32:01 1996 PST
| Fri Mar 01 17:32:01 1996 PST | @ 1 min                       | Fri Mar 01 17:31:01 1996 PST      | Fri Mar 01
17:32:011996 PST | @ 14 secs ago                 | Fri Mar 01 17:32:15 1996 PST
 
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours             | Tue Jul 30 06:32:01 1996 PDT
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons                      | Tue Jul 30 18:32:01 1996 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours             | Wed Jul 31 06:32:01 1996 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons                      | Wed Jul 31 18:32:01 1996 PDT
!      | Mon Dec 30 17:32:01 1996 PST | @ 3 mons                      | Mon Sep 30 18:32:01 1996 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 3 mons                      | Mon Sep 30 18:32:01 1996 PDT      | Mon Dec 30
17:32:011996 PST | @ 10 days                     | Fri Dec 20 17:32:01 1996 PST      | Tue Dec 31 17:32:01 1996 PST | @
10days                     | Sat Dec 21 17:32:01 1996 PST      | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins
4secs | Sun Dec 29 15:28:57 1996 PST
 
--- 323,334 ----      | Fri Mar 01 17:32:01 1996 PST | @ 5 hours                     | Fri Mar 01 12:32:01 1996 PST
| Fri Mar 01 17:32:01 1996 PST | @ 1 min                       | Fri Mar 01 17:31:01 1996 PST      | Fri Mar 01
17:32:011996 PST | @ 14 secs ago                 | Fri Mar 01 17:32:15 1996 PST
 
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours             | Tue Jul 30 05:32:01 1996 PDT
!      | Mon Dec 30 17:32:01 1996 PST | @ 5 mons                      | Tue Jul 30 17:32:01 1996 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours             | Wed Jul 31 05:32:01 1996 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 5 mons                      | Wed Jul 31 17:32:01 1996 PDT
!      | Mon Dec 30 17:32:01 1996 PST | @ 3 mons                      | Mon Sep 30 17:32:01 1996 PDT
!      | Tue Dec 31 17:32:01 1996 PST | @ 3 mons                      | Mon Sep 30 17:32:01 1996 PDT      | Mon Dec 30
17:32:011996 PST | @ 10 days                     | Fri Dec 20 17:32:01 1996 PST      | Tue Dec 31 17:32:01 1996 PST | @
10days                     | Sat Dec 21 17:32:01 1996 PST      | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins
4secs | Sun Dec 29 15:28:57 1996 PST
 
***************
*** 339,360 ****      | Tue Dec 31 17:32:01 1996 PST | @ 5 hours                     | Tue Dec 31 12:32:01 1996 PST
| Tue Dec 31 17:32:01 1996 PST | @ 1 min                       | Tue Dec 31 17:31:01 1996 PST      | Tue Dec 31
17:32:011996 PST | @ 14 secs ago                 | Tue Dec 31 17:32:15 1996 PST
 
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours             | Sat Jul 31 06:32:01 1999 PDT
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons                      | Sat Jul 31 18:32:01 1999 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours             | Sun Aug 01 06:32:01 1999 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons                      | Sun Aug 01 18:32:01 1999 PDT
!      | Fri Dec 31 17:32:01 1999 PST | @ 3 mons                      | Thu Sep 30 18:32:01 1999 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 3 mons                      | Fri Oct 01 18:32:01 1999 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 14:14:05 1999 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 15:14:03 1999 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 16:14:04 1999 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 17:14:02 1999 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 21:14:01 1999 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons                      | Fri Oct 15 02:14:05 1999 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons                      | Fri Oct 15 03:14:03 1999 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons                      | Fri Oct 15 04:14:04 1999 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons                      | Fri Oct 15 05:14:02 1999 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons                      | Fri Oct 15 09:14:01 1999 PDT      | Wed Mar 15
01:14:052000 PST | @ 3 mons                      | Wed Dec 15 01:14:05 1999 PST      | Wed Mar 15 02:14:03 2000 PST | @
3mons                      | Wed Dec 15 02:14:03 1999 PST      | Wed Mar 15 03:14:04 2000 PST | @ 3 mons
     | Wed Dec 15 03:14:04 1999 PST
 
--- 339,360 ----      | Tue Dec 31 17:32:01 1996 PST | @ 5 hours                     | Tue Dec 31 12:32:01 1996 PST
| Tue Dec 31 17:32:01 1996 PST | @ 1 min                       | Tue Dec 31 17:31:01 1996 PST      | Tue Dec 31
17:32:011996 PST | @ 14 secs ago                 | Tue Dec 31 17:32:15 1996 PST
 
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours             | Sat Jul 31 05:32:01 1999 PDT
!      | Fri Dec 31 17:32:01 1999 PST | @ 5 mons                      | Sat Jul 31 17:32:01 1999 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours             | Sun Aug 01 05:32:01 1999 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 5 mons                      | Sun Aug 01 17:32:01 1999 PDT
!      | Fri Dec 31 17:32:01 1999 PST | @ 3 mons                      | Thu Sep 30 17:32:01 1999 PDT
!      | Sat Jan 01 17:32:01 2000 PST | @ 3 mons                      | Fri Oct 01 17:32:01 1999 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 13:14:05 1999 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 14:14:03 1999 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 15:14:04 1999 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 16:14:02 1999 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 20:14:01 1999 PDT
!      | Wed Mar 15 01:14:05 2000 PST | @ 5 mons                      | Fri Oct 15 01:14:05 1999 PDT
!      | Wed Mar 15 02:14:03 2000 PST | @ 5 mons                      | Fri Oct 15 02:14:03 1999 PDT
!      | Wed Mar 15 03:14:04 2000 PST | @ 5 mons                      | Fri Oct 15 03:14:04 1999 PDT
!      | Wed Mar 15 04:14:02 2000 PST | @ 5 mons                      | Fri Oct 15 04:14:02 1999 PDT
!      | Wed Mar 15 08:14:01 2000 PST | @ 5 mons                      | Fri Oct 15 08:14:01 1999 PDT      | Wed Mar 15
01:14:052000 PST | @ 3 mons                      | Wed Dec 15 01:14:05 1999 PST      | Wed Mar 15 02:14:03 2000 PST | @
3mons                      | Wed Dec 15 02:14:03 1999 PST      | Wed Mar 15 03:14:04 2000 PST | @ 3 mons
     | Wed Dec 15 03:14:04 1999 PST
 
***************
*** 395,406 ****      | Wed Mar 15 04:14:02 2000 PST | @ 14 secs ago                 | Wed Mar 15 04:14:16 2000 PST
| Wed Mar 15 08:14:01 2000 PST | @ 1 min                       | Wed Mar 15 08:13:01 2000 PST      | Wed Mar 15
08:14:012000 PST | @ 14 secs ago                 | Wed Mar 15 08:14:15 2000 PST
 
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours             | Mon Jul 31 06:32:01 2000 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons                      | Mon Jul 31 18:32:01 2000 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours             | Tue Aug 01 06:32:01 2000 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons                      | Tue Aug 01 18:32:01 2000 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 3 mons                      | Sat Sep 30 18:32:01 2000 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 3 mons                      | Sun Oct 01 18:32:01 2000 PDT      | Sun Dec 31
17:32:012000 PST | @ 10 days                     | Thu Dec 21 17:32:01 2000 PST      | Mon Jan 01 17:32:01 2001 PST | @
10days                     | Fri Dec 22 17:32:01 2000 PST      | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins
4secs | Sat Dec 30 15:28:57 2000 PST
 
--- 395,406 ----      | Wed Mar 15 04:14:02 2000 PST | @ 14 secs ago                 | Wed Mar 15 04:14:16 2000 PST
| Wed Mar 15 08:14:01 2000 PST | @ 1 min                       | Wed Mar 15 08:13:01 2000 PST      | Wed Mar 15
08:14:012000 PST | @ 14 secs ago                 | Wed Mar 15 08:14:15 2000 PST
 
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours             | Mon Jul 31 05:32:01 2000 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 5 mons                      | Mon Jul 31 17:32:01 2000 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours             | Tue Aug 01 05:32:01 2000 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 5 mons                      | Tue Aug 01 17:32:01 2000 PDT
!      | Sun Dec 31 17:32:01 2000 PST | @ 3 mons                      | Sat Sep 30 17:32:01 2000 PDT
!      | Mon Jan 01 17:32:01 2001 PST | @ 3 mons                      | Sun Oct 01 17:32:01 2000 PDT      | Sun Dec 31
17:32:012000 PST | @ 10 days                     | Thu Dec 21 17:32:01 2000 PST      | Mon Jan 01 17:32:01 2001 PST | @
10days                     | Fri Dec 22 17:32:01 2000 PST      | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins
4secs | Sat Dec 30 15:28:57 2000 PST
 

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

Re: Horology regress test changed?

From

Tom Lane

Date:

07 November 2000, 04:53:35

Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>> I'm seeing a whole bunch of miscompares in the horology test today.
>> Is this stuff supposed to have changed behavior?

> Yup. RTFCVSL :)

I did, but the log didn't say anything about unfixed regression test
cases.  If you're going to leave some platform-specific comparison
files un-updated, I think it'd be polite to warn people about that
explicitly... probably on pghackers, not just committers...

I have updated horology-no-DST-before-1970.out, but that still leaves
us needing updates for horology-1947-PDT.out and
horology-solaris-1947.out.
        regards, tom lane

Re: Horology regress test changed?

From

Thomas Lockhart

Date:

07 November 2000, 23:53:36

> I'm seeing a whole bunch of miscompares in the horology test today.
> Is this stuff supposed to have changed behavior?

Yup. RTFCVSL :)

It is a result of fixing the date/time math across daylight savings time
boundaries. You will find that there is no longer an artifical one hour
offset in results when you add days, months, or years to a date or
timestamp.

I looked fairly carefully in the regression results before committing
the changes, but another pair of eyes always helps so let me know if you
notice anything funny...
                     - Thomas

Re: Horology regress test changed?

From

Thomas Lockhart

Date:

09 November 2000, 04:31:33

> I did, but the log didn't say anything about unfixed regression test
> cases.  If you're going to leave some platform-specific comparison
> files un-updated, I think it'd be polite to warn people about that
> explicitly... probably on pghackers, not just committers...

*sigh*

I'll probably always leave some platform-specific comparison files
unupdated, and I would expect others to have to do that also. I
apparently did not meet your expectations on this, but it is quite in
line with our accepted practices.

Sorry for the heart stoppage when you saw your regression tests suddenly
failing...

> I have updated horology-no-DST-before-1970.out, but that still leaves
> us needing updates for horology-1947-PDT.out and
> horology-solaris-1947.out.

I guess that we have already heard from someone on one of those, and the
others will come with time.

Regards.
                      - Thomas