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@pyrenet.fr wrote:
> Date: Fri, 22 Jul 2005 11:28:52 +0200 (MET DST)
> From: ohp@pyrenet.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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)