diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2015-07-28 20:00:13 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2015-07-28 20:00:20 -0400 |
| commit | d7f0bb8cc7f4b43830499e89384befc3690b1560 (patch) | |
| tree | b9f2730542f5caa35adc332c838f1211dbc3d399 | |
| parent | cab23771eb0250fe8e2ad179cf10ef965658f3e7 (diff) | |
| download | postgresql-d7f0bb8cc7f4b43830499e89384befc3690b1560.tar.gz postgresql-d7f0bb8cc7f4b43830499e89384befc3690b1560.zip | |
Prevent platform-dependent output row ordering in a new test query.
Buildfarm indicates this is necessary.
| -rw-r--r-- | src/test/regress/expected/rowsecurity.out | 22 | ||||
| -rw-r--r-- | src/test/regress/sql/rowsecurity.sql | 8 |
2 files changed, 19 insertions, 11 deletions
diff --git a/src/test/regress/expected/rowsecurity.out b/src/test/regress/expected/rowsecurity.out index b0f2565b60a..b146da373c3 100644 --- a/src/test/regress/expected/rowsecurity.out +++ b/src/test/regress/expected/rowsecurity.out @@ -2899,12 +2899,14 @@ SELECT row_security_active('current_check'); f (1 row) -SELECT most_common_vals FROM pg_stats where tablename = 'current_check'; - most_common_vals ---------------------- - - - {rls_regress_user1} +SELECT attname, most_common_vals FROM pg_stats + WHERE tablename = 'current_check' + ORDER BY 1; + attname | most_common_vals +-----------+--------------------- + currentid | + payload | + rlsuser | {rls_regress_user1} (3 rows) SET SESSION AUTHORIZATION rls_regress_user1; @@ -2915,9 +2917,11 @@ SELECT row_security_active('current_check'); t (1 row) -SELECT most_common_vals FROM pg_stats where tablename = 'current_check'; - most_common_vals ------------------- +SELECT attname, most_common_vals FROM pg_stats + WHERE tablename = 'current_check' + ORDER BY 1; + attname | most_common_vals +---------+------------------ (0 rows) -- diff --git a/src/test/regress/sql/rowsecurity.sql b/src/test/regress/sql/rowsecurity.sql index 03f82987c47..54f2c89eda3 100644 --- a/src/test/regress/sql/rowsecurity.sql +++ b/src/test/regress/sql/rowsecurity.sql @@ -1197,12 +1197,16 @@ SET SESSION AUTHORIZATION rls_regress_user0; ANALYZE current_check; -- Stats visible SELECT row_security_active('current_check'); -SELECT most_common_vals FROM pg_stats where tablename = 'current_check'; +SELECT attname, most_common_vals FROM pg_stats + WHERE tablename = 'current_check' + ORDER BY 1; SET SESSION AUTHORIZATION rls_regress_user1; -- Stats not visible SELECT row_security_active('current_check'); -SELECT most_common_vals FROM pg_stats where tablename = 'current_check'; +SELECT attname, most_common_vals FROM pg_stats + WHERE tablename = 'current_check' + ORDER BY 1; -- -- Collation support |