Here ya go:
test union ... FAILED
test case ... ok
test join ... FAILED
*** ./expected/union.out Thu Oct 9 20:49:31 2003
--- ./results/union.out Fri Oct 31 15:15:50 2003
***************
*** 106,112 **** two ----- 1.1
! 2 (2 rows)
SELECT 1.1 AS three UNION SELECT 2 UNION ALL SELECT 2;
--- 106,112 ---- two ----- 1.1
! 2.0 (2 rows)
SELECT 1.1 AS three UNION SELECT 2 UNION ALL SELECT 2;
======================================================================
*** ./expected/join.out Thu Oct 9 20:49:31 2003
--- ./results/join.out Fri Oct 31 15:15:51 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
======================================================================
--
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