Re: regressin failure on latest CVS

Michael Glaesemann wrote:
>
> 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.

Interesting. I don't see the error with our without
--enable-integer-datetimes. I even tried changing my timezone to Paris
time and still could not reproduce the failure.

On the AIX problem below, we are going to get rounding issues.

---------------------------------------------------------------------------

> 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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073