Regression tests - geometry results for AIX/RS6000

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Pete Forman
Your email address : pete(dot)forman(at)westgeo(dot)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(dot)forman(at)westgeo(dot)com -./\.- the opinion of Baker Hughes or
http://www.crosswinds.net/~petef -./\.- its divisions.