Using both PostgreSQL 8.1.0 and CVS current of Nov 7, 9:00 am CET I get
a regression failure in the interval tests. I am no export for the
interval type, but the expected "9 days 28 hours" seem wrong, don't
they? The actual value seems to be the same.
Is it possible that this is broken on the platform where the expected
results were generated?
*** ./expected/interval.out Tue Oct 25 19:13:07 2005
--- ./results/interval.out Mon Nov 7 09:11:27 2005
***************
*** 218,224 ****
select avg(f1) from interval_tbl;
avg
-------------------------------------------------
! @ 4 years 1 mon 9 days 28 hours 18 mins 23 secs
(1 row)
-- test long interval input
--- 218,224 ----
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
The last commit to interval.out seems to be this one, and it changed
exactly this line.
revision 1.14
date: 2005/10/25 17:13:07; author: tgl; state: Exp; lines: +1 -1
Well, this is CVS tip, so there is a chance this is fixed in
REL_8_1_STABLE which has a 1.14.0.2. At least the release tarball should
be rebuilt, no?
Sorry, if this is just noise. Just wanted to be sure you know about it.
Best Regards,
Michael
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
