Wrong order of rows in result during regression test.

From: Magnus Enbom <dot(at)rockstorm(dot)se>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Wrong order of rows in result during regression test.
Date: 2002-10-29 15:41:42
Message-ID: 20021029154142.GA11006@ford.rockstorm.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Your name : Magnus Enbom
Your email address : magnus(dot)enbom(at)rockstorm(dot)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:
---------------------------------------------------------------------

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2002-10-29 16:23:50 Re: Bug #807: Sequence currupted on recovery after kill -9
Previous Message pgsql-bugs 2002-10-29 15:36:20 Bug #807: Sequence currupted on recovery after kill -9