]> granicus.if.org Git - postgresql/commit
Fix optimizer to not try to push WHERE clauses down into a sub-SELECT that
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 31 Jul 2001 18:39:13 +0000 (18:39 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 31 Jul 2001 18:39:13 +0000 (18:39 +0000)
commita1e17cd5c5807f905cb324399455eba32d43dd1e
tree7e799d9204218ef870c9105bb0d840c0de9bc4db
parentd6b1a407f4c544c438f0bf6067b70e864719bb46
Fix optimizer to not try to push WHERE clauses down into a sub-SELECT that
has a DISTINCT ON clause, per bug report from Anthony Wood.  While at it,
improve the DISTINCT-ON-clause recognizer routine to not be fooled by out-
of-order DISTINCT lists.
Also, back-patch earlier fix to not push down into sub-SELECT with LIMIT.
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/util/clauses.c
src/backend/utils/adt/ruleutils.c
src/include/optimizer/clauses.h