File tree Expand file tree Collapse file tree 4 files changed +4
-130
lines changed Expand file tree Collapse file tree 4 files changed +4
-130
lines changed Original file line number Diff line number Diff line change @@ -1788,7 +1788,7 @@ SELECT '' AS "xxx", *
1788
1788
1789
1789
SELECT '' AS "xxx", *
1790
1790
FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i)
1791
- ORDER BY i;
1791
+ ORDER BY i, t ;
1792
1792
xxx | i | j | t | k
1793
1793
-----+---+---+-------+----
1794
1794
| 0 | | zero |
@@ -1810,7 +1810,7 @@ SELECT '' AS "xxx", *
1810
1810
1811
1811
SELECT '' AS "xxx", *
1812
1812
FROM J1_TBL FULL JOIN J2_TBL USING (i)
1813
- ORDER BY i;
1813
+ ORDER BY i, t ;
1814
1814
xxx | i | j | t | k
1815
1815
-----+---+---+-------+----
1816
1816
| 0 | | zero |
Original file line number Diff line number Diff line change @@ -181,11 +181,11 @@ SELECT '' AS "xxx", *
181
181
182
182
SELECT ' ' AS " xxx" , *
183
183
FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i)
184
- ORDER BY i;
184
+ ORDER BY i, t ;
185
185
186
186
SELECT ' ' AS " xxx" , *
187
187
FROM J1_TBL FULL JOIN J2_TBL USING (i)
188
- ORDER BY i;
188
+ ORDER BY i, t ;
189
189
190
190
SELECT ' ' AS " xxx" , *
191
191
FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (k = 1 );
Load Diff This file was deleted.
Load Diff This file was deleted.
You can’t perform that action at this time.
0 commit comments