diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-10-29 12:58:40 +0530 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-10-29 13:14:37 +0530 |
| commit | f74f871b80a13ef72b19e3d829a109f8df0df792 (patch) | |
| tree | 4977690000538348b2192c1428659adb8a47d2fa /src/test/regress/sql/select_parallel.sql | |
| parent | 21daada10ebf444fb1fc06a705fb22b890867083 (diff) | |
Fix problems with the "role" GUC and parallel query.
Without this fix, dropping a role can sometimes result in parallel
query failures in sessions that have used "SET ROLE" to assume the
dropped role, even if that setting isn't active any more.
Report by Pavan Deolasee. Patch by Amit Kapila, reviewed by me.
Discussion: http://postgr.es/m/CABOikdOomRcZsLsLK+Z+qENM1zxyaWnAvFh3MJZzZnnKiF+REg@mail.gmail.com
Diffstat (limited to 'src/test/regress/sql/select_parallel.sql')
| -rw-r--r-- | src/test/regress/sql/select_parallel.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/regress/sql/select_parallel.sql b/src/test/regress/sql/select_parallel.sql index 38d3166742c..e310c096811 100644 --- a/src/test/regress/sql/select_parallel.sql +++ b/src/test/regress/sql/select_parallel.sql @@ -39,7 +39,15 @@ explain (costs off) select sum(parallel_restricted(unique1)) from tenk1 group by(parallel_restricted(unique1)); +-- test the sanity of parallel query after the active role is dropped. set force_parallel_mode=1; +drop role if exists regress_parallel_worker; +create role regress_parallel_worker; +set role regress_parallel_worker; +reset session authorization; +drop role regress_parallel_worker; +select count(*) from tenk1; +reset role; explain (costs off) select stringu1::int2 from tenk1 where unique1 = 1; |