• Tom Lane's avatar
    Keep the planner from failing on "WHERE false AND something IN (SELECT ...)". · 89db887b
    Tom Lane authored
    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.
    89db887b
planmain.c 13.9 KB