Fix an old thinko in SS_make_initplan_from_plan, which is used when optimizing
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 18 Jul 2007 21:40:57 +0000 (21:40 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 18 Jul 2007 21:40:57 +0000 (21:40 +0000)
commitd514ea3fda5b5d89cc5a9386f10ac315c4e18486
tree87569e5141bd855d8bc4773178e17a7e25e62bb0
parentcdedfe6af1c426b28b2e0ff522d5d88f195a5d47
Fix an old thinko in SS_make_initplan_from_plan, which is used when optimizing
a MIN or MAX aggregate call into an indexscan: the initplan is being made at
the current query nesting level and so we shouldn't increment query_level.
Though usually harmless, this mistake could lead to bogus "plan should not
reference subplan's variable" failures on complex queries.  Per bug report
from David Sanchez i Gregori.
src/backend/optimizer/plan/subselect.c
src/test/regress/expected/subselect.out
src/test/regress/sql/subselect.sql