Hi,

The regression test fails on 'polymorphism' on three different computers with
various architectures.

(I hope this point was not raised before, but I did not find any relevant mail
about it with '[BUGS]'in the subject line and 'polymorphism' in message body)

Besides the configure options stated below, BLCKSZ was redefined from 8192 to
16384 before running configure. With default vakue (8192) make check runs
smoothly.

Machine 1 : (SuSE 8.2 i386)
-----------

uname -m = i686
uname -r = 2.4.20-64GB-SMP
uname -s = Linux
uname -v = #1 SMP Wed Nov 17 20:29:59 UTC 2004
gcc 3.3.1

./configure '--prefix=/usr' '--libdir=/usr/lib' '--bindir=/usr/bin' '--
includedir=/usr/include/pgsql' '--datadir=/usr/share/postgresql' '--
mandir=/usr/share/man' '--with-docdir=/usr/share/doc/packages' '--with-
includes=/usr/include/heimdal /usr/include/et' '--disable-rpath' '--enable-
nls' '--enable-thread-safety' '--enable-integer-datetimes' '--with-python' '--
with-perl' '--with-tcl' '--without-tk' '--with-openssl' '--with-pam' 'CFLAGS=-
O3 -march=pentium3 -mcpu=pentium3 -fmessage-length=0 -Wall'

Machine 2 : (SuSE 9.1 i386)
-----------

uname -m = i686
uname -r = 2.6.5-7.111.5-default
uname -s = Linux
uname -v = #1 Wed Nov 17 11:08:17 UTC 2004

gcc 3.3.3

../configure '--prefix=/usr' '--libdir=/usr/lib' '--bindir=/usr/bin' '--
includedir=/usr/include/pgsql' '--datadir=/usr/share/postgresql' '--
mandir=/usr/share/man' '--with-docdir=/usr/share/doc/packages' '--with-
includes=/usr/include/heimdal /usr/include/et' '--disable-rpath' '--enable-
nls' '--enable-thread-safety' '--enable-integer-datetimes' '--with-python' '--
with-perl' '--with-tcl' '--without-tk' '--with-openssl' '--with-pam' '--with-
krb5' 'CFLAGS=-O3 -march=pentium3 -mcpu=pentium3 -fmessage-length=0 -Wall'

Machine 3 : (IBM R/S 6000 - powerpc-ibm-aix4.3.3.0)
-----------

uname -m = 0057C2BA4C00
uname -r = 3
uname -s = AIX
uname -v = 4

xlc C for AIX Compiler, Version 5

../configure --without-readline --without-zlib

------------




---------------------------(end of broadcast)---------------------------
TIP 3: 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

j6m (AT) cvni (DOT) net writes:
Define "fails" (regression diffs output would be nice).

If it's just a change in output row order then it's not a bug ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

It appears to be just that.

Great, It works!

*** ./expected/polymorphism.out Wed Dec 1 20:00:56 2004
--- ./results/polymorphism.out Tue Dec 21 19:06:12 2004
***************
*** 349,532 ****
select f3, myaggp01a(*) from t group by f3;
f3 | myaggp01a
----+-----------
c | {}
a | {}
- b | {}
(3 rows)

select f3, myaggp03a(*) from t group by f3;
f3 | myaggp03a
----+-----------
c | {}
a | {}
- b | {}
(3 rows)

select f3, myaggp03b(*) from t group by f3;
f3 | myaggp03b
----+-----------
c | {}
a | {}
- b | {}
(3 rows)

select f3, myaggp05a(f1) from t group by f3;
f3 | myaggp05a
----+-----------
c | {1,2}
a | {1,2,3}
- b | {1,2,3}
(3 rows)

select f3, myaggp06a(f1) from t group by f3;
f3 | myaggp06a
----+-----------
c | {}
a | {}
- b | {}
(3 rows)

---8<--- SNIP ---


--- 349,532 ----
select f3, myaggp01a(*) from t group by f3;
f3 | myaggp01a
----+-----------
+ b | {}
c | {}
a | {}
(3 rows)

select f3, myaggp03a(*) from t group by f3;
f3 | myaggp03a
----+-----------
+ b | {}
c | {}
a | {}
(3 rows)

select f3, myaggp03b(*) from t group by f3;
f3 | myaggp03b
----+-----------
+ b | {}
c | {}
a | {}
(3 rows)



----- Original Message -----
From: "Tom Lane" <tgl (AT) sss (DOT) pgh.pa.us>
To: <j6m (AT) cvni (DOT) net>
Cc: <pgsql-bugs (AT) postgresql (DOT) org>
Sent: Tuesday, December 21, 2004 6:58 PM
Subject: Re: [BUGS] Polymorphism resgression test fails when BLCKSZ changed


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html