• Igor Babaev's avatar
    Fixed bug #54539. · d48bec7b
    Igor Babaev authored
    Added a possibility not to factor out the condition pushed to
    the access index out of the condition pushed to a joined table.
    This is useful for the condition pushed to the index when a hashed
    join buffer for BKA is employed. In this case the index condition
    may be false for some, but for all records with the same key.
    So the condition must be checked not only after index lookup,
    but after fetching row data as well, and it makes sense not to 
    factor out the condition from the condition checked after reading
    row data,
    The bug happened because the condition pushed to an index always
    was factor out from the condition pushed to the accessed table. 
    d48bec7b
opt_index_cond_pushdown.cc 12.1 KB