• T
    Fix bogus handling of "postponed" lateral quals. · 043f6ff0
    Tom Lane 提交于
    When pulling a "postponed" qual from a LATERAL subquery up into the quals
    of an outer join, we must make sure that the postponed qual is included
    in those seen by make_outerjoininfo().  Otherwise we might compute a
    too-small min_lefthand or min_righthand for the outer join, leading to
    "JOIN qualification cannot refer to other relations" failures from
    distribute_qual_to_rels.  Subtler errors in the created plan seem possible,
    too, if the extra qual would only affect join ordering constraints.
    
    Per bug #9041 from David Leverton.  Back-patch to 9.3.
    043f6ff0
join.out 140.6 KB