? 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);