Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit59b3b80

Browse files
committed
As long as we're forcing an ORDER BY in these four join queries, we had
better make sure the sort order is totally specified; else we get burntby platform-specific behavior of qsort() with equal keys. Per buildfarmresults.
1 parent8090616 commit59b3b80

File tree

2 files changed

+8
-8
lines changed

2 files changed

+8
-8
lines changed

‎src/test/regress/expected/join.out‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1718,7 +1718,7 @@ SELECT '' AS "xxx", *
17181718
--
17191719
SELECT '' AS "xxx", *
17201720
FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i)
1721-
ORDER BY i, k;
1721+
ORDER BY i, k, t;
17221722
xxx | i | j | t | k
17231723
-----+---+---+-------+----
17241724
| 0 | | zero |
@@ -1738,7 +1738,7 @@ SELECT '' AS "xxx", *
17381738

17391739
SELECT '' AS "xxx", *
17401740
FROM J1_TBL LEFT JOIN J2_TBL USING (i)
1741-
ORDER BY i, k;
1741+
ORDER BY i, k, t;
17421742
xxx | i | j | t | k
17431743
-----+---+---+-------+----
17441744
| 0 | | zero |
@@ -1788,7 +1788,7 @@ SELECT '' AS "xxx", *
17881788

17891789
SELECT '' AS "xxx", *
17901790
FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i)
1791-
ORDER BY i, k;
1791+
ORDER BY i, k, t;
17921792
xxx | i | j | t | k
17931793
-----+---+---+-------+----
17941794
| 0 | | zero |
@@ -1810,7 +1810,7 @@ SELECT '' AS "xxx", *
18101810

18111811
SELECT '' AS "xxx", *
18121812
FROM J1_TBL FULL JOIN J2_TBL USING (i)
1813-
ORDER BY i, k;
1813+
ORDER BY i, k, t;
18141814
xxx | i | j | t | k
18151815
-----+---+---+-------+----
18161816
| 0 | | zero |

‎src/test/regress/sql/join.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -167,11 +167,11 @@ SELECT '' AS "xxx", *
167167

168168
SELECT''AS"xxx",*
169169
FROM J1_TBLLEFT OUTER JOIN J2_TBL USING (i)
170-
ORDER BY i, k;
170+
ORDER BY i, k, t;
171171

172172
SELECT''AS"xxx",*
173173
FROM J1_TBLLEFT JOIN J2_TBL USING (i)
174-
ORDER BY i, k;
174+
ORDER BY i, k, t;
175175

176176
SELECT''AS"xxx",*
177177
FROM J1_TBLRIGHT OUTER JOIN J2_TBL USING (i);
@@ -181,11 +181,11 @@ SELECT '' AS "xxx", *
181181

182182
SELECT''AS"xxx",*
183183
FROM J1_TBL FULL OUTERJOIN J2_TBL USING (i)
184-
ORDER BY i, k;
184+
ORDER BY i, k, t;
185185

186186
SELECT''AS"xxx",*
187187
FROM J1_TBL FULLJOIN J2_TBL USING (i)
188-
ORDER BY i, k;
188+
ORDER BY i, k, t;
189189

190190
SELECT''AS"xxx",*
191191
FROM J1_TBLLEFT JOIN J2_TBL USING (i)WHERE (k=1);

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp