]> granicus.if.org Git - postgresql/commit
Temporarily (I hope) disable flattening of IN/EXISTS sublinks that are within
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Feb 2009 23:30:29 +0000 (23:30 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Feb 2009 23:30:29 +0000 (23:30 +0000)
commit07b9936a0f10d746e5076239813a5e938f2f16be
tree1fc324d34a76b5ad6418617dd66789965cdb2d60
parent75c85bd1997f6fba1cb9cdf0fa48fab220b0e745
Temporarily (I hope) disable flattening of IN/EXISTS sublinks that are within
the ON clause of an outer join.  Doing so is semantically correct but results
in de-optimizing queries that were structured to take advantage of the sublink
style of execution, as seen in recent complaint from Kevin Grittner.  Since
the user can get the other behavior by reorganizing his query, having the
flattening happen automatically is just a convenience, and that doesn't
justify breaking existing applications.  Eventually it would be nice to
re-enable this, but that seems to require a significantly different approach
to outer joins in the executor.
src/backend/optimizer/prep/prepjointree.c