[HACKERS] Regression Failure: CURRENT SOURCES/union&join

[Larry Rosenman]

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: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgp00000.pgp
Description: PGP signature