Regression tests - geometry results for AIX/RS6000 - Mailing list pgsql-patches

============================================================================
                        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.