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

Commit13d7a68

Browse files
committed
Add ORDER BY to join regression test.
1 parentc215902 commit13d7a68

File tree

2 files changed

+18
-10
lines changed

2 files changed

+18
-10
lines changed

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

Lines changed: 10 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1717,7 +1717,8 @@ SELECT '' AS "xxx", *
17171717
-- Note that OUTER is a noise word
17181718
--
17191719
SELECT '' AS "xxx", *
1720-
FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i);
1720+
FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i)
1721+
ORDER BY i;
17211722
xxx | i | j | t | k
17221723
-----+---+---+-------+----
17231724
| 0 | | zero |
@@ -1736,7 +1737,8 @@ SELECT '' AS "xxx", *
17361737
(13 rows)
17371738

17381739
SELECT '' AS "xxx", *
1739-
FROM J1_TBL LEFT JOIN J2_TBL USING (i);
1740+
FROM J1_TBL LEFT JOIN J2_TBL USING (i)
1741+
ORDER BY i;
17401742
xxx | i | j | t | k
17411743
-----+---+---+-------+----
17421744
| 0 | | zero |
@@ -1785,7 +1787,8 @@ SELECT '' AS "xxx", *
17851787
(9 rows)
17861788

17871789
SELECT '' AS "xxx", *
1788-
FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i);
1790+
FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i)
1791+
ORDER BY i;
17891792
xxx | i | j | t | k
17901793
-----+---+---+-------+----
17911794
| 0 | | zero |
@@ -1799,14 +1802,15 @@ SELECT '' AS "xxx", *
17991802
| 6 | 6 | six |
18001803
| 7 | 7 | seven |
18011804
| 8 | 8 | eight |
1805+
| | | | 0
18021806
| | | null |
18031807
| | 0 | zero |
18041808
| | | |
1805-
| | | | 0
18061809
(15 rows)
18071810

18081811
SELECT '' AS "xxx", *
1809-
FROM J1_TBL FULL JOIN J2_TBL USING (i);
1812+
FROM J1_TBL FULL JOIN J2_TBL USING (i)
1813+
ORDER BY i;
18101814
xxx | i | j | t | k
18111815
-----+---+---+-------+----
18121816
| 0 | | zero |
@@ -1820,10 +1824,10 @@ SELECT '' AS "xxx", *
18201824
| 6 | 6 | six |
18211825
| 7 | 7 | seven |
18221826
| 8 | 8 | eight |
1827+
| | | | 0
18231828
| | | null |
18241829
| | 0 | zero |
18251830
| | | |
1826-
| | | | 0
18271831
(15 rows)
18281832

18291833
SELECT '' AS "xxx", *

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

Lines changed: 8 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -166,10 +166,12 @@ SELECT '' AS "xxx", *
166166
--
167167

168168
SELECT''AS"xxx",*
169-
FROM J1_TBLLEFT OUTER JOIN J2_TBL USING (i);
169+
FROM J1_TBLLEFT OUTER JOIN J2_TBL USING (i)
170+
ORDER BY i;
170171

171172
SELECT''AS"xxx",*
172-
FROM J1_TBLLEFT JOIN J2_TBL USING (i);
173+
FROM J1_TBLLEFT JOIN J2_TBL USING (i)
174+
ORDER BY i;
173175

174176
SELECT''AS"xxx",*
175177
FROM J1_TBLRIGHT OUTER JOIN J2_TBL USING (i);
@@ -178,10 +180,12 @@ SELECT '' AS "xxx", *
178180
FROM J1_TBLRIGHT JOIN J2_TBL USING (i);
179181

180182
SELECT''AS"xxx",*
181-
FROM J1_TBL FULL OUTERJOIN J2_TBL USING (i);
183+
FROM J1_TBL FULL OUTERJOIN J2_TBL USING (i)
184+
ORDER BY i;
182185

183186
SELECT''AS"xxx",*
184-
FROM J1_TBL FULLJOIN J2_TBL USING (i);
187+
FROM J1_TBL FULLJOIN J2_TBL USING (i)
188+
ORDER BY i;
185189

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

0 commit comments

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