Skip site navigation (1) Skip section navigation (2)

Re: regressin failure on latest CVS

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: ohp(at)pyrenet(dot)fr, pgsql-hackers(at)postgresql(dot)org
Subject: Re: regressin failure on latest CVS
Date: 2005-07-22 14:40:45
Message-ID: 200507221440.j6MEej603387@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Stephen FrostDate: 2005-07-22 14:43:05
Subject: Re: [PATCHES] Roles - SET ROLE Updated
Previous:From: Tom LaneDate: 2005-07-22 14:39:57
Subject: Re: Planner doesn't look at LIMIT?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group