pgsql: Fix an oversight I made in a cleanup patch over a year ago:

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Fix an oversight I made in a cleanup patch over a year ago:
Дата
Msg-id 20080401004833.9A5D57558E7@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Fix an oversight I made in a cleanup patch over a year ago:
eval_const_expressions needs to be passed the PlannerInfo ("root") structure,
because in some cases we want it to substitute values for Param nodes.
(So "constant" is not so constant as all that ...)  This mistake partially
disabled optimization of unnamed extended-Query statements in 8.3: in
particular the LIKE-to-indexscan optimization would never be applied if the
LIKE pattern was passed as a parameter, and constraint exclusion depending
on a parameter value didn't work either.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        allpaths.c (r1.169 -> r1.170)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/allpaths.c?r1=1.169&r2=1.170)
    pgsql/src/backend/optimizer/plan:
        initsplan.c (r1.138 -> r1.139)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/initsplan.c?r1=1.138&r2=1.139)
        planner.c (r1.230 -> r1.231)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.230&r2=1.231)
    pgsql/src/backend/optimizer/util:
        clauses.c (r1.256 -> r1.257)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c?r1=1.256&r2=1.257)
        plancat.c (r1.144 -> r1.145)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/plancat.c?r1=1.144&r2=1.145)
    pgsql/src/backend/utils/cache:
        relcache.c (r1.269 -> r1.270)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/relcache.c?r1=1.269&r2=1.270)
    pgsql/src/include/optimizer:
        clauses.h (r1.89 -> r1.90)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/clauses.h?r1=1.89&r2=1.90)
        plancat.h (r1.48 -> r1.49)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/plancat.h?r1=1.48&r2=1.49)

В списке pgsql-committers по дате отправления:

Предыдущее
От: carvalho@pgfoundry.org (User Carvalho)
Дата:
Сообщение: pllua - pllua: Bug fix on luaP_totuple, added _PLVERSION
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Fix an oversight I made in a cleanup patch over a year ago: