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