Lists: | pgsql-hackers |
---|
From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | regressin failure on latest CVS |
Date: | 2005-07-22 09:28:52 |
Message-ID: | Pine.UW2.4.53.0507221125570.3047@sun.pyrenet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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)
From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
---|---|
To: | ohp(at)pyrenet(dot)fr |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: regressin failure on latest CVS |
Date: | 2005-07-22 09:45:58 |
Message-ID: | C39E567A-6F2F-4F80-81D7-4CBE8546617C@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: regression failure on latest CVS |
Date: | 2005-07-25 12:27:19 |
Message-ID: | Pine.UW2.4.53.0507251422001.24649@sun.pyrenet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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)