diff options
| author | Andres Freund <andres@anarazel.de> | 2017-02-08 16:58:21 -0800 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2017-02-08 16:58:21 -0800 |
| commit | 7c5d8c16e12e56c1043ff4a28e07a306a15c2b85 (patch) | |
| tree | 26d8586f60614ad0dee4b09459d5b5c51954dca1 /src/test/regress/expected/rowsecurity.out | |
| parent | 8f93bd8512466c9b6c4dbc1e5efd0f72b8e2be9a (diff) | |
| download | postgresql-7c5d8c16e12e56c1043ff4a28e07a306a15c2b85.tar.gz | |
Add explicit ORDER BY to a few tests that exercise hash-join code.
A proposed patch, also by Thomas and in the same thread, would change
the output order of these. Independent of the follow-up patches
getting committed, nailing down the order in these specific tests at
worst seems harmless.
Author: Thomas Munro
Discussion: https://postgr.es/m/CAEepm=1D4-tP7j7UAgT_j4ZX2j4Ehe1qgZQWFKBMb8F76UW5Rg@mail.gmail.com
Diffstat (limited to 'src/test/regress/expected/rowsecurity.out')
| -rw-r--r-- | src/test/regress/expected/rowsecurity.out | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/test/regress/expected/rowsecurity.out b/src/test/regress/expected/rowsecurity.out index 25407bf9dd..7bf29368d0 100644 --- a/src/test/regress/expected/rowsecurity.out +++ b/src/test/regress/expected/rowsecurity.out @@ -448,15 +448,15 @@ CREATE POLICY p2 ON category ALTER TABLE category ENABLE ROW LEVEL SECURITY; -- cannot delete PK referenced by invisible FK SET SESSION AUTHORIZATION regress_rls_bob; -SELECT * FROM document d FULL OUTER JOIN category c on d.cid = c.cid; +SELECT * FROM document d FULL OUTER JOIN category c on d.cid = c.cid ORDER BY d.did, c.cid; did | cid | dlevel | dauthor | dtitle | cid | cname -----+-----+--------+-----------------+--------------------+-----+------------ - 2 | 11 | 2 | regress_rls_bob | my second novel | 11 | novel 1 | 11 | 1 | regress_rls_bob | my first novel | 11 | novel - | | | | | 33 | technology - 5 | 44 | 2 | regress_rls_bob | my second manga | | - 4 | 44 | 1 | regress_rls_bob | my first manga | | + 2 | 11 | 2 | regress_rls_bob | my second novel | 11 | novel 3 | 22 | 2 | regress_rls_bob | my science fiction | | + 4 | 44 | 1 | regress_rls_bob | my first manga | | + 5 | 44 | 2 | regress_rls_bob | my second manga | | + | | | | | 33 | technology (6 rows) DELETE FROM category WHERE cid = 33; -- fails with FK violation @@ -464,12 +464,12 @@ ERROR: update or delete on table "category" violates foreign key constraint "do DETAIL: Key is still referenced from table "document". -- can insert FK referencing invisible PK SET SESSION AUTHORIZATION regress_rls_carol; -SELECT * FROM document d FULL OUTER JOIN category c on d.cid = c.cid; +SELECT * FROM document d FULL OUTER JOIN category c on d.cid = c.cid ORDER BY d.did, c.cid; did | cid | dlevel | dauthor | dtitle | cid | cname -----+-----+--------+-------------------+-----------------------+-----+----------------- 6 | 22 | 1 | regress_rls_carol | great science fiction | 22 | science fiction - 8 | 44 | 1 | regress_rls_carol | great manga | 44 | manga 7 | 33 | 2 | regress_rls_carol | great technology book | | + 8 | 44 | 1 | regress_rls_carol | great manga | 44 | manga (3 rows) INSERT INTO document VALUES (11, 33, 1, current_user, 'hoge'); |