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
