OSDN Git Service

Fix an oversight in join-removal optimization: we have to check not only for
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 22 Mar 2010 13:57:16 +0000 (13:57 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 22 Mar 2010 13:57:16 +0000 (13:57 +0000)
commit8d3c4aa614e20375daeff0bb1b9f640b115f363e
treeb455eb7bb9acd7510dfb51a6931de638596d0111
parentecac5e6bfc3b236b41ea282f5625203d5ee90b55
Fix an oversight in join-removal optimization: we have to check not only for
plain Vars that are generated in the inner rel and used above the join, but
also for PlaceHolderVars.  Per report from Oleg K.
src/backend/optimizer/path/joinpath.c
src/test/regress/expected/join.out
src/test/regress/sql/join.sql