Commit8994cc6

committed

Add ORDER BY to more ICU regression test cases.

Commitc77e122 didn't fully fix the problem. Per buildfarmand local testing.

1 parent7c366ac commit8994cc6Copy full SHA for 8994cc6

File tree

-6

lines changed

-6

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1490,18 +1490,18 @@ SELECT x FROM test2bpci UNION SELECT x FROM test1bpci ORDER BY x;`
`1490`	`1490`	`ghi`
`1491`	`1491`	`(3 rows)`
`1492`	`1492`
`1493`		`-SELECT x FROM test1bpci INTERSECT SELECT x FROM test2bpci;`
	`1493`	`+SELECT x FROM test1bpci INTERSECT SELECT x FROM test2bpci ORDER BY x;`
`1494`	`1494`	`x`
`1495`	`1495`	`-----`
`1496`		`- ghi`
`1497`	`1496`	`abc`
	`1497`	`+ ghi`
`1498`	`1498`	`(2 rows)`
`1499`	`1499`
`1500`		`-SELECT x FROM test2bpci INTERSECT SELECT x FROM test1bpci;`
	`1500`	`+SELECT x FROM test2bpci INTERSECT SELECT x FROM test1bpci ORDER BY x;`
`1501`	`1501`	`x`
`1502`	`1502`	`-----`
`1503`		`- ghi`
`1504`	`1503`	`ABC`
	`1504`	`+ ghi`
`1505`	`1505`	`(2 rows)`
`1506`	`1506`
`1507`	`1507`	`SELECT x FROM test1bpci EXCEPT SELECT x FROM test2bpci;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -548,8 +548,8 @@ SELECT x FROM test3bpci WHERE x SIMILAR TO 'a%';`
`548`	`548`	`SELECT xFROM test3bpciWHERE x ~'a';`
`549`	`549`	`SELECT xFROM test1bpciUNIONSELECT xFROM test2bpciORDER BY x;`
`550`	`550`	`SELECT xFROM test2bpciUNIONSELECT xFROM test1bpciORDER BY x;`
`551`		`-SELECT xFROM test1bpci INTERSECTSELECT xFROM test2bpci;`
`552`		`-SELECT xFROM test2bpci INTERSECTSELECT xFROM test1bpci;`
	`551`	`+SELECT xFROM test1bpci INTERSECTSELECT xFROM test2bpciORDER BY x;`
	`552`	`+SELECT xFROM test2bpci INTERSECTSELECT xFROM test1bpciORDER BY x;`
`553`	`553`	`SELECT xFROM test1bpci EXCEPTSELECT xFROM test2bpci;`
`554`	`554`	`SELECT xFROM test2bpci EXCEPTSELECT xFROM test1bpci;`
`555`	`555`	`SELECT DISTINCT xFROM test3bpciORDER BY x;`

Comments

(0)