Improve create_unique_path to not be fooled by unrelated clauses that happen
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Feb 2009 00:06:27 +0000 (00:06 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Feb 2009 00:06:27 +0000 (00:06 +0000)
commit5f42d204f8570ea1fd505675c5671aa6a3bcaf90
tree5c275566fd6e36ae2e5abe1ff1d09d4192eb9136
parent7c8795d9f27a02890c1d20fb34f11aee0763d35d
Improve create_unique_path to not be fooled by unrelated clauses that happen
to be syntactically part of a semijoin clause.  For example given
WHERE EXISTS(SELECT ... WHERE upper.var = lower.var AND some-condition)
where some-condition is just a restriction on the lower relation, we can
use unique-ification on lower.var after having applied some-condition within
the scan on lower.
src/backend/optimizer/util/pathnode.c