• Igor Babaev's avatar
    Fixed LP bug #817360. · 103c4461
    Igor Babaev authored
    This problem could be observed for queries with nested outer joins
    for which the not_exist optimization were applicable. 
    The problem was caused by the code of the patch for bug #49322
    that erroneously forced the return to the previous nested loop
    level when the join algorithm successfully builds a partial record
    for an embedded outer to which the not_exist optimization could be
    applied.
    Actually the immediate return to the previous nested loops level
    is correct only if this partial record is rejected by a predicate
    pushed down to one of the inner tables of this outer join. Otherwise
    attempts to find extensions of this record must be made.
    103c4461
join_nested.result 63.9 KB