Postgres Pro
Downloads
Home   >   mailing lists

pgsql/src backend/optimizer/path/Tag: backend/ ... - Mailing list pgsql-committers

From Tom Lane
Subject pgsql/src backend/optimizer/path/Tag: backend/ ...
Date
Msg-id 200107311839.f6VIdDA03292@hub.org
Whole thread Raw
List pgsql-committers
Tree view 
CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    tgl@hub.org    01/07/31 14:39:13

Modified files:
    src/backend/optimizer/path: Tag: REL7_1_STABLE allpaths.c
    src/backend/optimizer/util: Tag: REL7_1_STABLE clauses.c
    src/backend/utils/adt: Tag: REL7_1_STABLE ruleutils.c
    src/include/optimizer: Tag: REL7_1_STABLE clauses.h

Log message:
    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.

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql/src backend/optimizer/path/allpaths.c ba ...
Next
From: Tom Lane
Date:
Subject: pgsql/src/backend/optimizer/util clauses.c