regressin failure on latest CVS

Hi,

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

======================================================================

Regards
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

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.

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

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

Sorry to follow up my own post but this is weird.

I've tested again and more closely.
And intervall check is ok when configured with --enable-debug and fails
(with the same error) otherwise.

It could be a compiler optimizer bug or the way the code is written.
Could someone point me to the source file so that I have a look?

BTW this is still on UnixWare 714

Regards,
On Fri, 22 Jul 2005 ohp(at)pyrenet(dot)fr wrote:

> Date: Fri, 22 Jul 2005 11:28:52 +0200 (MET DST)
> From: ohp(at)pyrenet(dot)fr
> Newsgroups: pgsql.hackers
> Subject: regressin failure on latest CVS
>
> Hi,
>
> 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
>
> ======================================================================
>
> Regards
>

--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)