aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/basics.source
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2007-10-04 20:45:17 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2007-10-04 20:45:17 +0000
commitd9e961d52737823b30549d5c130790d62a79731f (patch)
tree0e9aae2019168d1ce7add6d39ab0a0af80852f4b /src/tutorial/basics.source
parent45cd13c8ab05aef5a334bca8a2d1e9a1b9b8815e (diff)
downloadpostgresql-d9e961d52737823b30549d5c130790d62a79731f.tar.gz
postgresql-d9e961d52737823b30549d5c130790d62a79731f.zip
Keep the planner from failing on "WHERE false AND something IN (SELECT ...)".
eval_const_expressions simplifies this to just "WHERE false", but we have already done pull_up_IN_clauses so the IN join will be done, or at least planned, anyway. The trouble case comes when the sub-SELECT is itself a join and we decide to implement the IN by unique-ifying the sub-SELECT outputs: with no remaining reference to the output Vars in WHERE, we won't have propagated the Vars up to the upper join point, leading to "variable not found in subplan target lists" error. Fix by adding an extra scan of in_info_list and forcing all Vars mentioned therein to be propagated up to the IN join point. Per bug report from Miroslav Sulc.
Diffstat (limited to 'src/tutorial/basics.source')
0 files changed, 0 insertions, 0 deletions