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
