• Igor Babaev's avatar
    Fixed LP bug #934342. · cd81f578
    Igor Babaev authored
    An outer join query with a semi-join subquery could return a wrong result
    if the optimizer chose to materialize the subquery.
    It happened because when substituting for the best field into a ref item
    used to build access keys not all COND_EQUAL objects that could be employed
    at substitution were checked.
    
    Also refined some code in the function check_join_cache_usage to make it
    safer. 
    cd81f578
subselect_sj_jcl6.test 5.17 KB