Port Report: UnixWare

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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

--On Monday, November 03, 2003 00:36:41 -0600 Larry Rosenman
<ler(at)lerctr(dot)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(at)lerctr(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749