Commit23b65b8

committed

Hm, seems my hack on rowtypes regression test has made its output row

order platform-specific. Add an ORDER BY clause to stop buildfarmfailures.

1 parentfc7de7c commit23b65b8Copy full SHA for 23b65b8

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -207,11 +207,12 @@ HINT: Row comparison operators must be associated with btree operator families.`
`207`	`207`	`-- Check row comparison with a subselect`
`208`	`208`	`select unique1, unique2 from tenk1`
`209`	`209`	`where (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3)`
`210`		`- and unique1 <= 20;`
	`210`	`+ and unique1 <= 20`
	`211`	`+order by 1;`
`211`	`212`	`unique1 \| unique2`
`212`	`213`	`---------+---------`
`213`		`- 1 \| 2838`
`214`	`214`	`0 \| 9998`
	`215`	`+ 1 \| 2838`
`215`	`216`	`(2 rows)`
`216`	`217`
`217`	`218`	`-- Also check row comparison with an indexable condition`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -101,7 +101,8 @@ select ROW('ABC','DEF') ~~ ROW('DEF','ABC') as fail;`
`101`	`101`	`-- Check row comparison with a subselect`
`102`	`102`	`select unique1, unique2from tenk1`
`103`	`103`	`where (unique1, unique2)< any (select ten, tenfrom tenk1where hundred<3)`
`104`		`-and unique1<=20;`
	`104`	`+and unique1<=20`
	`105`	`+order by1;`
`105`	`106`
`106`	`107`	`-- Also check row comparison with an indexable condition`
`107`	`108`	`select thousand, tenthousfrom tenk1`

Comments

(0)