Wrong order of rows in result during regression test.

I have since fixed this in CVS. Would you please retest?

---------------------------------------------------------------------------

Magnus Enbom wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Fri, Nov 01, 2002 at 05:00:04PM -0500, Bruce Momjian wrote:

I have since fixed this in CVS. Would you please retest?

Yes, works. Thanks.

-- M