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 17:56:31 +0000 (17:56 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 31 Jul 2001 17:56:31 +0000 (17:56 +0000)
commit421467cdc8231a9da7ae6116ce6030d7d756f137
tree5d091f3ee3f29c17427bfdc33d86613d1e219504
parent6fbf442d5a5bba97333a6b0e7358599472bcd52d
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.
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/util/clauses.c
src/backend/utils/adt/ruleutils.c
src/include/optimizer/clauses.h