Re: Interval aggregate regression failure (expected seems wrong)

On Nov 7, 2005, at 17:24 , Michael Paesold wrote:

> 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?

What platform are you testing on? With or without integer-datetimes?

I just ran make check on for PostgreSQL 8.1.0 on Mac OS X 10.4.3

test=# select version();

version
------------------------------------------------------------------------
----------------------------------------------------------------------
PostgreSQL 8.1.0 on powerpc-apple-darwin8.3.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer, Inc.
build 5026)

I didn't have any regression failures. I'd also expect we'd see a lot
more failures on the build farm if it were the case that it was
broken just on the platform that the expected results were generated
on. From a quick look at the current build farm failures on HEAD and
REL8_1_STABLE, it doesn't look like any of the failures are failing
here.

Michael Glaesemann
grzm myrealbox com