Обсуждение: pgsql/src backend/optimizer/path/Tag: backend/ ...

Поиск
Список
Период
Сортировка

pgsql/src backend/optimizer/path/Tag: backend/ ...

От
Tom Lane
Дата:
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.