Re: regressin failure on latest CVS

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