pgsql: Fix an oversight I made in a cleanup patch over a year ago: - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix an oversight I made in a cleanup patch over a year ago:
Date
Msg-id 20080401004833.9A5D57558E7@cvs.postgresql.org
Whole thread Raw
List 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 by date:

Previous
From: carvalho@pgfoundry.org (User Carvalho)
Date:
Subject: pllua - pllua: Bug fix on luaP_totuple, added _PLVERSION
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix an oversight I made in a cleanup patch over a year ago: