Re: Request for supported platforms - Mailing list pgsql-hackers

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 <pgman@candle.pha.pa.us> writes:
> > Ports list updated:
>
> Shouldn't the "join" regression test failure be fixed?
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilc@samurai.com> || 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
  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
? 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);