]> granicus.if.org Git - postgresql/commit
Fix a bug in the original implementation of redundant-join-clause removal:
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 31 Jul 2007 19:54:27 +0000 (19:54 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 31 Jul 2007 19:54:27 +0000 (19:54 +0000)
commitc14066aa7049bac14cadc18d0c48bcf6ea81ff52
treee1643d93294f4b79c71b10c54c3eae79f8280b59
parentfab6a867fd38cb4abe326a9cb68f924d093f3dcf
Fix a bug in the original implementation of redundant-join-clause removal:
clauses in which one side or the other references both sides of the join
cannot be removed as redundant, because that expression won't have been
constrained below the join.  Per report from Sergey Burladyan.
src/backend/optimizer/path/indxpath.c
src/backend/optimizer/plan/createplan.c
src/backend/optimizer/util/relnode.c
src/backend/optimizer/util/restrictinfo.c
src/include/optimizer/restrictinfo.h
src/test/regress/expected/join.out
src/test/regress/sql/join.sql