Polymorphism resgression test fails when BLCKSZ changed
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
------------
j6m@cvni.net writes:
The regression test fails on 'polymorphism' on three different computers with
various architectures.
Define "fails" (regression diffs output would be nice).
Besides the configure options stated below, BLCKSZ was redefined from 8192 to
16384 before running configure.
If it's just a change in output row order then it's not a bug ...
regards, tom lane
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@sss.pgh.pa.us>
To: <j6m@cvni.net>
Cc: <pgsql-bugs@postgresql.org>
Sent: Tuesday, December 21, 2004 6:58 PM
Subject: Re: [BUGS] Polymorphism resgression test fails when BLCKSZ changed
j6m@cvni.net writes:
The regression test fails on 'polymorphism' on three different computers
with
various architectures.
Define "fails" (regression diffs output would be nice).
Besides the configure options stated below, BLCKSZ was redefined from 8192
to
Show quoted text
16384 before running configure.
If it's just a change in output row order then it's not a bug ...
regards, tom lane
Import Notes
Resolved by subject fallback