• Igor Babaev's avatar
    Fixed bug #54539. · 4bc234f3
    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. 
    
    ******
    Fixed bug #54539.
    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. 
    4bc234f3
sql_select.h 80.4 KB