• Tom Lane's avatar
    Fix handling of PlaceHolderVars in nestloop parameter management. · 7e3bf99b
    Tom Lane authored
    If we use a PlaceHolderVar from the outer relation in an inner indexscan,
    we need to reference the PlaceHolderVar as such as the value to be passed
    in from the outer relation.  The previous code effectively tried to
    reconstruct the PHV from its component expression, which doesn't work since
    (a) the Vars therein aren't necessarily bubbled up far enough, and (b) it
    would be the wrong semantics anyway because of the possibility that the PHV
    is supposed to have gone to null at some point before the current join.
    Point (a) led to "variable not found in subplan target list" planner
    errors, but point (b) would have led to silently wrong answers.
    Per report from Roger Niederland.
    7e3bf99b
setrefs.c 55.8 KB