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 по дате отправления: