]> granicus.if.org Git - postgresql/commit
Collect the global OR of hasRowSecurity flags for plancache
authorStephen Frost <sfrost@snowman.net>
Tue, 15 Dec 2015 01:05:55 +0000 (20:05 -0500)
committerStephen Frost <sfrost@snowman.net>
Tue, 15 Dec 2015 01:05:55 +0000 (20:05 -0500)
commit651e2ba74af997c2952672397828636dc6c6d017
tree043a05574617e2c26d1f6ab91da3a8d84bfa9293
parent2c24f0f092acb59184c3a3ace4b6cea4ff308328
Collect the global OR of hasRowSecurity flags for plancache

We carry around information about if a given query has row security or
not to allow the plancache to use that information to invalidate a
planned query in the event that the environment changes.

Previously, the flag of one of the subqueries was simply being copied
into place to indicate if the query overall included RLS components.
That's wrong as we need the global OR of all subqueries.  Fix by
changing the code to match how fireRIRules works, which is results
in OR'ing all of the flags.

Noted by Tom.

Back-patch to 9.5 where RLS was introduced.
src/backend/optimizer/plan/planner.c
src/backend/optimizer/plan/setrefs.c
src/test/regress/expected/rowsecurity.out
src/test/regress/sql/rowsecurity.sql