Commit5d0e8bc

committed

Prevent platform-dependent output row ordering in a new test query.

Buildfarm indicates this is necessary.

1 parent2c698f4 commit5d0e8bcCopy full SHA for 5d0e8bc

File tree

+19

-11

lines changed

+19

-11

lines changed

Lines changed: 13 additions & 9 deletions

Original file line number	Diff line number	Diff line change
`@@ -2899,12 +2899,14 @@ SELECT row_security_active('current_check');`
`2899`	`2899`	`f`
`2900`	`2900`	`(1 row)`
`2901`	`2901`
`2902`		`-SELECT most_common_vals FROM pg_stats where tablename = 'current_check';`
`2903`		`- most_common_vals`
`2904`		`----------------------`
`2905`		`-`
`2906`		`-`
`2907`		`- {rls_regress_user1}`
	`2902`	`+SELECT attname, most_common_vals FROM pg_stats`
	`2903`	`+ WHERE tablename = 'current_check'`
	`2904`	`+ ORDER BY 1;`
	`2905`	`+ attname \| most_common_vals`
	`2906`	`+-----------+---------------------`
	`2907`	`+ currentid \|`
	`2908`	`+ payload \|`
	`2909`	`+ rlsuser \| {rls_regress_user1}`
`2908`	`2910`	`(3 rows)`
`2909`	`2911`
`2910`	`2912`	`SET SESSION AUTHORIZATION rls_regress_user1;`
`@@ -2915,9 +2917,11 @@ SELECT row_security_active('current_check');`
`2915`	`2917`	`t`
`2916`	`2918`	`(1 row)`
`2917`	`2919`
`2918`		`-SELECT most_common_vals FROM pg_stats where tablename = 'current_check';`
`2919`		`- most_common_vals`
`2920`		`-------------------`
	`2920`	`+SELECT attname, most_common_vals FROM pg_stats`
	`2921`	`+ WHERE tablename = 'current_check'`
	`2922`	`+ ORDER BY 1;`
	`2923`	`+ attname \| most_common_vals`
	`2924`	`+---------+------------------`
`2921`	`2925`	`(0 rows)`
`2922`	`2926`
`2923`	`2927`	`--`

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1197,12 +1197,16 @@ SET SESSION AUTHORIZATION rls_regress_user0;`
`1197`	`1197`	`ANALYZE current_check;`
`1198`	`1198`	`-- Stats visible`
`1199`	`1199`	`SELECT row_security_active('current_check');`
`1200`		`-SELECT most_common_valsFROM pg_statswhere tablename='current_check';`
	`1200`	`+SELECT attname, most_common_valsFROM pg_stats`
	`1201`	`+WHERE tablename='current_check'`
	`1202`	`+ORDER BY1;`
`1201`	`1203`
`1202`	`1204`	`SET SESSION AUTHORIZATION rls_regress_user1;`
`1203`	`1205`	`-- Stats not visible`
`1204`	`1206`	`SELECT row_security_active('current_check');`
`1205`		`-SELECT most_common_valsFROM pg_statswhere tablename='current_check';`
	`1207`	`+SELECT attname, most_common_valsFROM pg_stats`
	`1208`	`+WHERE tablename='current_check'`
	`1209`	`+ORDER BY1;`
`1206`	`1210`
`1207`	`1211`	`--`
`1208`	`1212`	`-- Collation support`

Comments

(0)