aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/test/regress/expected/join.out6
-rw-r--r--src/test/regress/sql/join.sql6
2 files changed, 8 insertions, 4 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out
index 1849297f757..53a7ef49302 100644
--- a/src/test/regress/expected/join.out
+++ b/src/test/regress/expected/join.out
@@ -1591,7 +1591,8 @@ SELECT '' AS "xxx", *
(7 rows)
SELECT '' AS "xxx", *
- FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, d) USING (a);
+ FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, d) USING (a)
+ ORDER BY a, d;
xxx | a | b | c | d
-----+---+---+-------+----
| 0 | | zero |
@@ -1604,7 +1605,8 @@ SELECT '' AS "xxx", *
(7 rows)
SELECT '' AS "xxx", *
- FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, b) USING (b);
+ FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, b) USING (b)
+ ORDER BY b, t1.a;
xxx | b | a | c | a
-----+---+---+-------+---
| 0 | 5 | five |
diff --git a/src/test/regress/sql/join.sql b/src/test/regress/sql/join.sql
index 3126b58ea13..ae63a61c01f 100644
--- a/src/test/regress/sql/join.sql
+++ b/src/test/regress/sql/join.sql
@@ -113,10 +113,12 @@ SELECT '' AS "xxx", *
FROM J1_TBL JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
- FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, d) USING (a);
+ FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, d) USING (a)
+ ORDER BY a, d;
SELECT '' AS "xxx", *
- FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, b) USING (b);
+ FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, b) USING (b)
+ ORDER BY b, t1.a;
--