• Igor Babaev's avatar
    BNL and BNLH algorithms scan the join table and for each its record they · c3fb76db
    Igor Babaev authored
    try to find a match in the join buffer. It makes sense to check for a match
    only those records satisfying WHERE/ON conditions that can be pushed to
    the scanned table. It allows us to discard early some join candidates.
    
    Such pushdown conditions were built when BNL join algorithm was employed,
    but for they were not built when BNLH algorithm was used.
    The patch removes this shortcoming. 
    c3fb76db
sql_select.cc 634 KB