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