• timour@askmonty.org's avatar
    MDEV-5123 Remove duplicated conditions pushed both to join_tab->select_cond... · afed8092
    timour@askmonty.org authored
    MDEV-5123 Remove duplicated conditions pushed both to join_tab->select_cond and join_tab->cache_select->cond for blocked joins.
        
    BNL and BNLH joins pre-filter the records from a joined table via JOIN_TAB::cache_select->cond.
    There is no need to re-evaluate the same conditions via JOIN_TAB::select_cond. This patch removes
    the duplicated conditions from the top-level conjuncts of each pushed condition.
    
    The added "Using where" in few EXPLAINs is due to taking into account tab->cache_select->cond
    in addition to tab->select_cond in JOIN::save_explain_data_intern.
    afed8092
limit_rows_examined.result 35.5 KB