Commitc77e122

committed

Add ORDER BY to regression test case

Apparently, the output order is different on different endianness, perbuild farm member snapper.

1 parent919e48b commitc77e122Copy full SHA for c77e122

File tree

-6

lines changed

-6

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1372,18 +1372,18 @@ SELECT x FROM test2ci UNION SELECT x FROM test1ci ORDER BY x;`
`1372`	`1372`	`ghi`
`1373`	`1373`	`(3 rows)`
`1374`	`1374`
`1375`		`-SELECT x FROM test1ci INTERSECT SELECT x FROM test2ci;`
	`1375`	`+SELECT x FROM test1ci INTERSECT SELECT x FROM test2ci ORDER BY x;`
`1376`	`1376`	`x`
`1377`	`1377`	`-----`
`1378`		`- ghi`
`1379`	`1378`	`abc`
	`1379`	`+ ghi`
`1380`	`1380`	`(2 rows)`
`1381`	`1381`
`1382`		`-SELECT x FROM test2ci INTERSECT SELECT x FROM test1ci;`
	`1382`	`+SELECT x FROM test2ci INTERSECT SELECT x FROM test1ci ORDER BY x;`
`1383`	`1383`	`x`
`1384`	`1384`	`-----`
`1385`		`- ghi`
`1386`	`1385`	`ABC`
	`1386`	`+ ghi`
`1387`	`1387`	`(2 rows)`
`1388`	`1388`
`1389`	`1389`	`SELECT x FROM test1ci EXCEPT SELECT x FROM test2ci;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -517,8 +517,8 @@ SELECT x FROM test3ci WHERE x SIMILAR TO 'a%';`
`517`	`517`	`SELECT xFROM test3ciWHERE x ~'a';`
`518`	`518`	`SELECT xFROM test1ciUNIONSELECT xFROM test2ciORDER BY x;`
`519`	`519`	`SELECT xFROM test2ciUNIONSELECT xFROM test1ciORDER BY x;`
`520`		`-SELECT xFROM test1ci INTERSECTSELECT xFROM test2ci;`
`521`		`-SELECT xFROM test2ci INTERSECTSELECT xFROM test1ci;`
	`520`	`+SELECT xFROM test1ci INTERSECTSELECT xFROM test2ciORDER BY x;`
	`521`	`+SELECT xFROM test2ci INTERSECTSELECT xFROM test1ciORDER BY x;`
`522`	`522`	`SELECT xFROM test1ci EXCEPTSELECT xFROM test2ci;`
`523`	`523`	`SELECT xFROM test2ci EXCEPTSELECT xFROM test1ci;`
`524`	`524`	`SELECT DISTINCT xFROM test3ciORDER BY x;`

Comments

(0)