On Jul 22, 2005, at 6:28 PM, ohp@pyrenet.fr wrote:

I tried the latest cvs this morning (07/22 11:00 CET)
and interval test fails.
Here's the regression.diffs.


*** ./expected/interval.out    Fri Jul 22 10:32:21 2005
--- ./results/interval.out    Fri Jul 22 11:07:54 2005
***************
*** 217,224 ****
  -- updating pg_aggregate.agginitval
  select avg(f1) from interval_tbl;
                         avg
! -------------------------------------------------
!  @ 4 years 1 mon 10 days 4 hours 18 mins 23 secs
  (1 row)

  -- test long interval input
--- 217,224 ----
  -- updating pg_aggregate.agginitval
  select avg(f1) from interval_tbl;
                        avg
! ------------------------------------------------
!  @ 4 years 1 mon 9 days 4 hours 18 mins 23 secs
  (1 row)

  -- test long interval input

Could you provide platform information? Did you build with --enable- integer-datetimes? Looking at the buildfarm, kookaburra (AIX 5.2) is also failing the interval test at the same point, but the result is different.

http://pgbuildfarm.org/cgi-bin/show_history.pl?nm=kookaburra&br=HEAD

================== pgsql.36852/src/test/regress/regression.diffs ===================
*** ./expected/interval.out     Fri Jul 22 01:25:05 2005
--- ./results/interval.out      Fri Jul 22 01:34:20 2005
***************
*** 217,224 ****
  -- updating pg_aggregate.agginitval
  select avg(f1) from interval_tbl;
                         avg
! -------------------------------------------------
!  @ 4 years 1 mon 10 days 4 hours 18 mins 23 secs
  (1 row)

  -- test long interval input
--- 217,224 ----
  -- updating pg_aggregate.agginitval
  select avg(f1) from interval_tbl;
                          avg
! ----------------------------------------------------
!  @ 4 years 1 mon 10 days 4 hours 18 mins 22.99 secs
  (1 row)


Michael Glaesemann
grzm myrealbox com



---------------------------(end of broadcast)---------------------------
TIP 1: 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

Reply via email to