]> granicus.if.org Git - postgresql/commit
Fix some planner issues with degenerate outer join clauses.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 2 Aug 2015 00:57:41 +0000 (20:57 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 2 Aug 2015 00:57:41 +0000 (20:57 -0400)
commit44618f92bb3f287124c616cc9d25cce5592c3d2b
treebcebf9718560032c35c1a3ee783ac0cb1be5d00c
parentc7d1712519085b46b084412631ab3a0c27a7a1a6
Fix some planner issues with degenerate outer join clauses.

An outer join clause that didn't actually reference the RHS (perhaps only
after constant-folding) could confuse the join order enforcement logic,
leading to wrong query results.  Also, nested occurrences of such things
could trigger an Assertion that on reflection seems incorrect.

Per fuzz testing by Andreas Seltenreich.  The practical use of such cases
seems thin enough that it's not too surprising we've not heard field
reports about it.

This has been broken for a long time, so back-patch to all active branches.
src/backend/optimizer/path/joinrels.c
src/backend/optimizer/plan/initsplan.c
src/test/regress/expected/join.out
src/test/regress/sql/join.sql