Re: regression failure - horology

Tom Lane wrote:
> Joe Conway <mail@joeconway.com> 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

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