]> granicus.if.org Git - postgresql/commit
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:41:22 +0000 (21:41 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 18 Jul 2007 21:41:22 +0000 (21:41 +0000)
commit429870e33e97d2e7748e5dd146adcbd5058e218e
treee96e626a0b8a68656fcfb785ed9e768e06fad491
parentb1def736b00595c8983cee5d513762f084ce444b
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