Re: [HACKERS] regression failure - horology

[Joe Conway]

Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
I'm seeing a regression failure on the horology test on two different 
machines.
Uh ... what machines, and what failure exactly?

Sorry -- one is Red Hat 8.0/Intel P3 and one is Red Hat 7.3/AMD Athlon. 
Regression diff attached.

Joe
*** ./expected/horology.out     Fri Feb 21 16:28:17 2003
--- ./results/horology.out      Fri Feb 21 21:54:15 2003
***************
*** 329,355 ****
  (1 row)
  
  SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '1000000000 days' AS 
"Nov 27, 2733194";
!        Nov 27, 2733194       
! -----------------------------
!  Sun Nov 27 00:00:00 2733194
! (1 row)
! 
  SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '2000000000 days' AS 
"Nov 30, 5471101";
         Nov 30, 5471101       
! -----------------------------
!  Sat Nov 30 00:00:00 5471101
  (1 row)
  
  SELECT timestamp without time zone 'Nov 25, 4714 BC' + interval '2147483492 days' AS 
"Dec 31, 5874897";
         Dec 31, 5874897       
! -----------------------------
!  Tue Dec 31 00:00:00 5874897
  (1 row)
  
  SELECT timestamp without time zone '12/31/5874897' - timestamp without time zone 
'Nov 24, 4714 BC' AS "2147483493 Days";
    2147483493 Days  
! -------------------
!  @ 2147483493 days
  (1 row)
  
  -- Shorthand values
--- 329,351 ----
  (1 row)
  
  SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '1000000000 days' AS 
"Nov 27, 2733194";
! ERROR:  Unable to format timestamp; internal coding error
  SELECT timestamp without time zone 'Nov 24, 4714 BC' + interval '2000000000 days' AS 
"Nov 30, 5471101";
            Nov 30, 5471101          
! -----------------------------------
!  Thu Jun 20 23:43:34.035456 210115
  (1 row)
  
  SELECT timestamp without time zone 'Nov 25, 4714 BC' + interval '2147483492 days' AS 
"Dec 31, 5874897";
           Dec 31, 5874897         
! ---------------------------------
!  Mon Jul 04 15:41:44.48384 29357
  (1 row)
  
  SELECT timestamp without time zone '12/31/5874897' - timestamp without time zone 
'Nov 24, 4714 BC' AS "2147483493 Days";
                 2147483493 Days               
! ---------------------------------------------
!  @ 12443669 days 15 hours 41 mins 44.48 secs
  (1 row)
  
  -- Shorthand values
======================================================================

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly