Commit1f27fac

committed

Add ORDER BY to ensure platform-independent results in rules test.

1 parent571d121 commit1f27facCopy full SHA for 1f27fac

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -311,12 +311,12 @@ bm \|pluto`
`311`	`311`	`(3 rows)`
`312`	`312`
`313`	`313`	`QUERY: update rtest_person set pname = 'jwieck' where pdesc = 'Jan Wieck';`
`314`		`-QUERY: select * from rtest_admin;`
	`314`	`+QUERY: select * from rtest_admin order by pname, sysname;`
`315`	`315`	`pname \|sysname`
`316`	`316`	`------+-------`
`317`	`317`	`bm \|pluto`
`318`		`-jwieck\|orion`
`319`	`318`	`jwieck\|notjw`
	`319`	`+jwieck\|orion`
`320`	`320`	`(3 rows)`
`321`	`321`
`322`	`322`	`QUERY: delete from rtest_system where sysname = 'orion';`

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -251,7 +251,11 @@ select * from rtest_admin;`
`251`	`251`
`252`	`252`	`update rtest_personset pname='jwieck'where pdesc='Jan Wieck';`
`253`	`253`
`254`		`-select*from rtest_admin;`
	`254`	`+-- Note: use ORDER BY here to ensure consistent output across all systems.`
	`255`	`+-- The above UPDATE affects two rows with equal keys, so they could be`
	`256`	`+-- updated in either order depending on the whim of the local qsort().`
	`257`	`+`
	`258`	`+select*from rtest_adminorder by pname, sysname;`
`255`	`259`
`256`	`260`	`deletefrom rtest_systemwhere sysname='orion';`
`257`	`261`

Comments

(0)