============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Pete Forman
Your email address : pete.forman@westgeo.com
System Configuration
---------------------
Architecture (example: Intel Pentium) : RS6000 POWER3
Operating System (example: Linux 2.0.26 ELF) : AIX 4.3.2
PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1
Compiler used (example: gcc 2.8.0) : xlc 3.6.6
Please enter a FULL description of your problem:
------------------------------------------------
Regression tests failed on geometry.
The file geometry-powerpc-aix4.out works for my rs6000-ibm-aix4.3.2.0
host as well.
Note that on one occasion running the geometry test I got results that
were nearly the same. The rows returned from three of the select
statements were sorted in a different order, but otherwise were
identical. I've repeated the test a further five times and always
passed (with the new resultmap).
Those three select statements were
SELECT '' AS twentyfour, b.f1 + p.f1 AS translation
FROM BOX_TBL b, POINT_TBL p;
SELECT '' AS twentyfour, b.f1 - p.f1 AS translation
FROM BOX_TBL b, POINT_TBL p;
SELECT '' AS twentyfour, b.f1 * p.f1 AS rotation
FROM BOX_TBL b, POINT_TBL p;
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
gmake runtest
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
This patch is for version 1.37 of resultmap. It might be an idea to
rename the results file to geometry-aix4.out and amend resultmap.
*** src/test/regress/resultmap.orig Wed Nov 1 17:16:13 2000
--- src/test/regress/resultmap Tue Nov 7 13:51:36 2000
***************
*** 22,28 ****
geometry/i.86-.*-gnulibc=geometry-i86-gnulibc
geometry/i.86-pc-cygwin=geometry-solaris-precision
geometry/powerpc-unknown-linux-gnu=geometry-powerpc-linux-gnulibc1
! geometry/powerpc.*-aix4=geometry-powerpc-aix4
geometry/sparc-sun-solaris=geometry-solaris-precision
geometry/alpha.*-linux-gnu=geometry-solaris-precision
geometry/.*-beos=geometry-intel-beos
--- 22,28 ----
geometry/i.86-.*-gnulibc=geometry-i86-gnulibc
geometry/i.86-pc-cygwin=geometry-solaris-precision
geometry/powerpc-unknown-linux-gnu=geometry-powerpc-linux-gnulibc1
! geometry/.*-aix4=geometry-powerpc-aix4
geometry/sparc-sun-solaris=geometry-solaris-precision
geometry/alpha.*-linux-gnu=geometry-solaris-precision
geometry/.*-beos=geometry-intel-beos
--
Pete Forman -./\.- Disclaimer: This post is originated
Western Geophysical -./\.- by myself and does not represent
pete.forman@westgeo.com -./\.- the opinion of Baker Hughes or
http://www.crosswinds.net/~petef -./\.- its divisions.
