Re: regressin failure on latest CVS - Mailing list pgsql-hackers

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

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@postgresql.org so that your
>        message can get through to the mailing list cleanly
> 

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