Sorry, Ian, here is the patch I applied. You can apply this to whatever
version you are using and test Irix with that, rather than having to
grab CVS.
---------------------------------------------------------------------------
Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Ports list updated:
>
> Shouldn't the "join" regression test failure be fixed?
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
? config.log
? GNUmakefile
? config.status
? autom4te.cache
? configure.lineno
? contrib/retep/build
? contrib/retep/jars
? src/log
? src/Makefile.custom
? src/Makefile.global
? src/backend/postgres
? src/backend/catalog/postgres.bki
? src/backend/catalog/postgres.description
? src/backend/utils/mb/conversion_procs/conversion_create.sql
? src/backend/utils/mb/conversion_procs/ascii_and_mic/libascii_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/cyrillic_and_mic/libcyrillic_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/euc_cn_and_mic/libeuc_cn_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/euc_jp_and_sjis/libeuc_jp_and_sjis.so.0.0
? src/backend/utils/mb/conversion_procs/euc_kr_and_mic/libeuc_kr_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/euc_tw_and_big5/libeuc_tw_and_big5.so.0.0
? src/backend/utils/mb/conversion_procs/latin2_and_win1250/liblatin2_and_win1250.so.0.0
? src/backend/utils/mb/conversion_procs/latin_and_mic/liblatin_and_mic.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_ascii/libutf8_and_ascii.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_big5/libutf8_and_big5.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_cyrillic/libutf8_and_cyrillic.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_cn/libutf8_and_euc_cn.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_jp/libutf8_and_euc_jp.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_kr/libutf8_and_euc_kr.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_euc_tw/libutf8_and_euc_tw.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_gb18030/libutf8_and_gb18030.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_gbk/libutf8_and_gbk.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_iso8859/libutf8_and_iso8859.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_iso8859_1/libutf8_and_iso8859_1.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_johab/libutf8_and_johab.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_sjis/libutf8_and_sjis.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_tcvn/libutf8_and_tcvn.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_uhc/libutf8_and_uhc.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_win1250/libutf8_and_win1250.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_win1256/libutf8_and_win1256.so.0.0
? src/backend/utils/mb/conversion_procs/utf8_and_win874/libutf8_and_win874.so.0.0
? src/bin/initdb/initdb
? src/bin/initlocation/initlocation
? src/bin/ipcclean/ipcclean
? src/bin/pg_config/pg_config
? src/bin/pg_controldata/pg_controldata
? src/bin/pg_ctl/pg_ctl
? src/bin/pg_dump/pg_dump
? src/bin/pg_dump/pg_restore
? src/bin/pg_dump/pg_dumpall
? src/bin/pg_encoding/pg_encoding
? src/bin/pg_id/pg_id
? src/bin/pg_resetxlog/pg_resetxlog
? src/bin/psql/psql
? src/bin/psql/i
? src/bin/scripts/createlang
? src/include/pg_config.h
? src/include/stamp-h
? src/interfaces/ecpg/lib/libecpg.so.3.4.0
? src/interfaces/ecpg/preproc/ecpg
? src/interfaces/jdbc/build
? src/interfaces/jdbc/jars
? src/interfaces/libpq/libpq.so.2.2
? src/pl/plpgsql/src/libplpgsql.so.1.0
? src/test/regress/pg_regress
? src/test/regress/results
? src/test/regress/regression.out
? src/test/regress/regression.diffs
? src/test/regress/expected/copy.out
? src/test/regress/expected/create_function_1.out
? src/test/regress/expected/create_function_2.out
? src/test/regress/expected/misc.out
? src/test/regress/expected/constraints.out
? src/test/regress/sql/copy.sql
? src/test/regress/sql/create_function_1.sql
? src/test/regress/sql/create_function_2.sql
? src/test/regress/sql/misc.sql
? src/test/regress/sql/constraints.sql
Index: src/test/regress/expected/join.out
===================================================================
RCS file: /cvsroot/pgsql-server/src/test/regress/expected/join.out,v
retrieving revision 1.11
retrieving revision 1.12
diff -c -c -r1.11 -r1.12
*** src/test/regress/expected/join.out 28 Apr 2002 19:54:29 -0000 1.11
--- src/test/regress/expected/join.out 28 Oct 2002 22:54:45 -0000 1.12
***************
*** 1717,1723 ****
-- Note that OUTER is a noise word
--
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i);
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
--- 1717,1724 ----
-- Note that OUTER is a noise word
--
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i)
! ORDER BY i;
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
***************
*** 1736,1742 ****
(13 rows)
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT JOIN J2_TBL USING (i);
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
--- 1737,1744 ----
(13 rows)
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT JOIN J2_TBL USING (i)
! ORDER BY i;
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
***************
*** 1785,1791 ****
(9 rows)
SELECT '' AS "xxx", *
! FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i);
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
--- 1787,1794 ----
(9 rows)
SELECT '' AS "xxx", *
! FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i)
! ORDER BY i;
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
***************
*** 1799,1812 ****
| 6 | 6 | six |
| 7 | 7 | seven |
| 8 | 8 | eight |
| | | null |
| | 0 | zero |
| | | |
- | | | | 0
(15 rows)
SELECT '' AS "xxx", *
! FROM J1_TBL FULL JOIN J2_TBL USING (i);
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
--- 1802,1816 ----
| 6 | 6 | six |
| 7 | 7 | seven |
| 8 | 8 | eight |
+ | | | | 0
| | | null |
| | 0 | zero |
| | | |
(15 rows)
SELECT '' AS "xxx", *
! FROM J1_TBL FULL JOIN J2_TBL USING (i)
! ORDER BY i;
xxx | i | j | t | k
-----+---+---+-------+----
| 0 | | zero |
***************
*** 1820,1829 ****
| 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", *
Index: src/test/regress/sql/join.sql
===================================================================
RCS file: /cvsroot/pgsql-server/src/test/regress/sql/join.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -c -c -r1.9 -r1.10
*** src/test/regress/sql/join.sql 28 Apr 2002 19:54:29 -0000 1.9
--- src/test/regress/sql/join.sql 28 Oct 2002 22:54:45 -0000 1.10
***************
*** 166,175 ****
--
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL RIGHT OUTER JOIN J2_TBL USING (i);
--- 166,177 ----
--
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i)
! ORDER BY i;
SELECT '' AS "xxx", *
! FROM J1_TBL LEFT JOIN J2_TBL USING (i)
! ORDER BY i;
SELECT '' AS "xxx", *
FROM J1_TBL RIGHT OUTER JOIN J2_TBL USING (i);
***************
*** 178,187 ****
FROM J1_TBL RIGHT JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
! FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
! FROM J1_TBL FULL JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (k = 1);
--- 180,191 ----
FROM J1_TBL RIGHT JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
! FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i)
! ORDER BY i;
SELECT '' AS "xxx", *
! FROM J1_TBL FULL JOIN J2_TBL USING (i)
! ORDER BY i;
SELECT '' AS "xxx", *
FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (k = 1);
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
