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