]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f4fea44) | patch
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)
commitf01313bc0d4c293d88c2619084b1fc41825f2cf8
treea9561b6091bd29df593f8e57f2e1dac9bf3ed9f9tree | snapshot
parentf4fea44ce15ce8a036faf8594c140dc02825dc0ccommit | diff
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 diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.