Re: regressin failure on latest CVS

On Jul 22, 2005, at 6:28 PM, ohp(at)pyrenet(dot)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