We pass all tests except for the Join test now.  the join test seems to 
just be row-ordering from qsort():

test union                ... ok
test case                 ... ok
test join                 ... FAILED
test aggregates           ... ok


=======================
 1 of 93 tests failed.
=======================

	$ cd src/test/regress
$ cat regression.diffs
*** ./expected/join.out Thu Oct  9 20:49:31 2003
--- ./results/join.out  Mon Nov  3 00:34:26 2003
***************
*** 1732,1739 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   | null  |
       |   | 0 | zero  |
  (13 rows)

  SELECT '' AS "xxx", *
--- 1732,1739 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   | 0 | zero  |
+      |   |   | null  |
  (13 rows)

  SELECT '' AS "xxx", *
***************
*** 1752,1759 ****
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
-      |   |   | null  |
       |   | 0 | zero  |
  (13 rows)

  SELECT '' AS "xxx", *
--- 1752,1759 ----
       | 6 | 6 | six   |
       | 7 | 7 | seven |
       | 8 | 8 | eight |
       |   | 0 | zero  |
+      |   |   | null  |
  (13 rows)

  SELECT '' AS "xxx", *
***************
*** 1793,1800 ****
  -----+---+---+-------+----
       | 0 |   | zero  |
       | 1 | 4 | one   | -1
-      | 2 | 3 | two   |  2
       | 2 | 3 | two   |  4
       | 3 | 2 | three | -3
       | 4 | 1 | four  |
       | 5 | 0 | five  | -5
--- 1793,1800 ----
  -----+---+---+-------+----
       | 0 |   | zero  |
       | 1 | 4 | one   | -1
       | 2 | 3 | two   |  4
+      | 2 | 3 | two   |  2
       | 3 | 2 | three | -3
       | 4 | 1 | four  |
       | 5 | 0 | five  | -5
***************
*** 1815,1822 ****
  -----+---+---+-------+----
       | 0 |   | zero  |
       | 1 | 4 | one   | -1
-      | 2 | 3 | two   |  2
       | 2 | 3 | two   |  4
       | 3 | 2 | three | -3
       | 4 | 1 | four  |
       | 5 | 0 | five  | -5
--- 1815,1822 ----
  -----+---+---+-------+----
       | 0 |   | zero  |
       | 1 | 4 | one   | -1
       | 2 | 3 | two   |  4
+      | 2 | 3 | two   |  2
       | 3 | 2 | three | -3
       | 4 | 1 | four  |
       | 5 | 0 | five  | -5

======================================================================

$

Can we mark UnixWare ok for 7.4 with these?  Or re-write the test to NOT
fail?

LER


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
Mon, 03 Nov 2003 00:36:41 -0600
Larry Rosenman <ler@lerctr.org>
Port Report: UnixWare
--On Monday, November 03, 2003 00:36:41 -0600 Larry Rosenman 
<ler@lerctr.org> wrote:

> We pass all tests except for the Join test now.  the join test seems to
> just be row-ordering from qsort():
>
> test union                ... ok
> test case                 ... ok
> test join                 ... FAILED
> test aggregates           ... ok
>
>
> =======================
>  1 of 93 tests failed.
> =======================
>
> 	$ cd src/test/regress
> $ cat regression.diffs
> *** ./expected/join.out Thu Oct  9 20:49:31 2003
> --- ./results/join.out  Mon Nov  3 00:34:26 2003
> ***************
> *** 1732,1739 ****
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
> -      |   |   | null  |
>        |   | 0 | zero  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> --- 1732,1739 ----
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
>        |   | 0 | zero  |
> +      |   |   | null  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> ***************
> *** 1752,1759 ****
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
> -      |   |   | null  |
>        |   | 0 | zero  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> --- 1752,1759 ----
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
>        |   | 0 | zero  |
> +      |   |   | null  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> ***************
> *** 1793,1800 ****
>   -----+---+---+-------+----
>        | 0 |   | zero  |
>        | 1 | 4 | one   | -1
> -      | 2 | 3 | two   |  2
>        | 2 | 3 | two   |  4
>        | 3 | 2 | three | -3
>        | 4 | 1 | four  |
>        | 5 | 0 | five  | -5
> --- 1793,1800 ----
>   -----+---+---+-------+----
>        | 0 |   | zero  |
>        | 1 | 4 | one   | -1
>        | 2 | 3 | two   |  4
> +      | 2 | 3 | two   |  2
>        | 3 | 2 | three | -3
>        | 4 | 1 | four  |
>        | 5 | 0 | five  | -5
> ***************
> *** 1815,1822 ****
>   -----+---+---+-------+----
>        | 0 |   | zero  |
>        | 1 | 4 | one   | -1
> -      | 2 | 3 | two   |  2
>        | 2 | 3 | two   |  4
>        | 3 | 2 | three | -3
>        | 4 | 1 | four  |
>        | 5 | 0 | five  | -5
> --- 1815,1822 ----
>   -----+---+---+-------+----
>        | 0 |   | zero  |
>        | 1 | 4 | one   | -1
>        | 2 | 3 | two   |  4
> +      | 2 | 3 | two   |  2
>        | 3 | 2 | three | -3
>        | 4 | 1 | four  |
>        | 5 | 0 | five  | -5
>
> ======================================================================
>
> $
>
> Can we mark UnixWare ok for 7.4 with these?  Or re-write the test to NOT
> fail?
>
Oh, uname:

$ uname -a
UnixWare lerami 5 7.1.3 i386 x86at SCO UNIX_SVR5
$
> LER
>
>
> --
> Larry Rosenman                     http://www.lerctr.org/~ler
> Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
Mon, 03 Nov 2003 00:37:28 -0600
Larry Rosenman <ler@lerctr.org>
Re: Port Report: UnixWare