diff options
| author | Tom Lane | 2000-05-12 01:33:56 +0000 |
|---|---|---|
| committer | Tom Lane | 2000-05-12 01:33:56 +0000 |
| commit | 01911c98db504902eac08abe71c96d592dae4bd5 (patch) | |
| tree | c22ce5800154f5f91d6d0b26f7a58faff91be9f9 /src/test | |
| parent | 4624b84cf2ced3948bb6d5612130c11559192f48 (diff) | |
Repair list-vs-node confusion that resulted in failure for INNER JOIN ON.
Make it behave correctly when there are more than two tables being
joined, also. Update regression test expected outputs.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/join.out | 27 |
1 files changed, 24 insertions, 3 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out index 4e7ca30a5a9..2b4f1b655aa 100644 --- a/src/test/regress/expected/join.out +++ b/src/test/regress/expected/join.out @@ -274,10 +274,22 @@ SELECT '' AS "xxx", * -- SELECT '' AS "xxx", * FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.i); -ERROR: transformExpr: does not know how to transform node 501 (internal error) + xxx | i | j | t | i | k +-----+---+---+-------+---+---- + | 1 | 3 | one | 1 | -1 + | 2 | 2 | two | 2 | 2 + | 2 | 2 | two | 2 | 4 + | 3 | 1 | three | 3 | -3 +(4 rows) + SELECT '' AS "xxx", * FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.k); -ERROR: transformExpr: does not know how to transform node 501 (internal error) + xxx | i | j | t | i | k +-----+---+---+------+---+--- + | 2 | 2 | two | 2 | 2 + | 4 | 0 | four | 2 | 4 +(2 rows) + SELECT '' AS "xxx", * FROM J1_TBL CROSS JOIN J2_TBL; xxx | i | j | t | i | k @@ -305,7 +317,16 @@ SELECT '' AS "xxx", * -- SELECT '' AS "xxx", * FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i <= J2_TBL.k); -ERROR: transformExpr: does not know how to transform node 501 (internal error) + xxx | i | j | t | i | k +-----+---+---+-------+---+--- + | 1 | 3 | one | 2 | 2 + | 2 | 2 | two | 2 | 2 + | 1 | 3 | one | 2 | 4 + | 2 | 2 | two | 2 | 4 + | 3 | 1 | three | 2 | 4 + | 4 | 0 | four | 2 | 4 +(6 rows) + -- -- Outer joins -- |