Wrong order of rows in result during regression test. - Mailing list pgsql-bugs

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


Your name       :   Magnus Enbom
Your email address  : magnus.enbom@rockstorm.se


System Configuration
---------------------
  Architecture (example: Intel Pentium)     : x86

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.4.19-gentoo-r7,
                                                  glibc-2.2.5

  PostgreSQL version (example: PostgreSQL-7.3):  PostgreSQL-7.3, cvs from today

  Compiler used (example:  gcc 2.95.2)      : gcc-2.95.3


Please enter a FULL description of your problem:
------------------------------------------------
During "make installcheck":
...
test case                 ... ok
test join                 ... FAILED
test aggregates           ... ok
...


regression.diffs contains:

*** ./expected/join.out Mon Oct 28 23:54:45 2002
--- ./results/join.out  Tue Oct 29 16:29:18 2002
***************
*** 1802,1811 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   |       |  0
       |   |   | null  |
       |   | 0 | zero  |
       |   |   |       |
  (15 rows)

  SELECT '' AS "xxx", *
--- 1802,1811 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   |   | null  |
       |   | 0 | zero  |
       |   |   |       |
+      |   |   |       |  0
  (15 rows)

  SELECT '' AS "xxx", *
***************
*** 1824,1833 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   |       |  0
       |   |   | null  |
       |   | 0 | zero  |
       |   |   |       |
  (15 rows)

  SELECT '' AS "xxx", *
--- 1824,1833 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   |   | null  |
       |   | 0 | zero  |
       |   |   |       |
+      |   |   |       |  0
  (15 rows)

  SELECT '' AS "xxx", *

======================================================================








Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
./configure --with-pam --with-openssl=/usr --with-java --with-python --with-
perl --with-tcl --enable-debug --enable-depend --enable-cassert --enable-nls --e
nable-recode --prefix=/usr/local/pgsql.current

make installcheck




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------