diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2000-11-06 18:11:46 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2000-11-06 18:11:46 +0000 |
| commit | db631de531dd13f3aef01782d5440284b8473d81 (patch) | |
| tree | 8e1e3a995eef0eb9d24eecb8390ab8978b00d58d | |
| parent | e8f1340fe02198ba62b3a524e7562e57702d14ad (diff) | |
| download | postgresql-db631de531dd13f3aef01782d5440284b8473d81.tar.gz postgresql-db631de531dd13f3aef01782d5440284b8473d81.zip | |
Add explicit ORDER BYs in a couple of cases --- seems to be necessary
to get platform-independent results.
| -rw-r--r-- | src/test/regress/expected/join.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/join.sql | 6 |
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; -- |