Commitdb631de

committed

Add explicit ORDER BYs in a couple of cases --- seems to be necessary

to get platform-independent results.

1 parente8f1340 commitdb631deCopy full SHA for db631de

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1591,7 +1591,8 @@ SELECT '' AS "xxx", *`
`1591`	`1591`	`(7 rows)`
`1592`	`1592`
`1593`	`1593`	`SELECT '' AS "xxx", *`
`1594`		`- FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, d) USING (a);`
	`1594`	`+ FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, d) USING (a)`
	`1595`	`+ ORDER BY a, d;`
`1595`	`1596`	`xxx \| a \| b \| c \| d`
`1596`	`1597`	`-----+---+---+-------+----`
`1597`	`1598`	`\| 0 \| \| zero \|`
`@@ -1604,7 +1605,8 @@ SELECT '' AS "xxx", *`
`1604`	`1605`	`(7 rows)`
`1605`	`1606`
`1606`	`1607`	`SELECT '' AS "xxx", *`
`1607`		`- FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, b) USING (b);`
	`1608`	`+ FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, b) USING (b)`
	`1609`	`+ ORDER BY b, t1.a;`
`1608`	`1610`	`xxx \| b \| a \| c \| a`
`1609`	`1611`	`-----+---+---+-------+---`
`1610`	`1612`	`\| 0 \| 5 \| five \|`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -113,10 +113,12 @@ SELECT '' AS "xxx", *`
`113`	`113`	`FROM J1_TBLJOIN J2_TBL USING (i);`
`114`	`114`
`115`	`115`	`SELECT''AS"xxx",*`
`116`		`-FROM J1_TBL t1 (a, b, c)JOIN J2_TBL t2 (a, d) USING (a);`
	`116`	`+FROM J1_TBL t1 (a, b, c)JOIN J2_TBL t2 (a, d) USING (a)`
	`117`	`+ORDER BY a, d;`
`117`	`118`
`118`	`119`	`SELECT''AS"xxx",*`
`119`		`-FROM J1_TBL t1 (a, b, c)JOIN J2_TBL t2 (a, b) USING (b);`
	`120`	`+FROM J1_TBL t1 (a, b, c)JOIN J2_TBL t2 (a, b) USING (b)`
	`121`	`+ORDER BY b,t1.a;`
`120`	`122`
`121`	`123`
`122`	`124`	`--`

Comments

(0)