--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