• Igor Babaev's avatar
    Fixed LP #bug 660963. · 0a3922fc
    Igor Babaev authored
    The condition that was supposed to check whether a join table
    is an inner table of a nested outer join or semi-join was not
    quite correct in the code of the function check_join_cache_usage.
    That's why some queries with nested outer joins triggered 
    an assertion failure.
    Encapsulated this condition in the new method called
    JOIN_TAB::is_nested_inner and provided a proper code for it.
    
    Also corrected a bug in the code of check_join_cache_usage()
    that caused a downgrade of not first join buffers of the
    level 5 and 7 to level 4 and 6 correspondingly.
    0a3922fc
join_cache.test 92.5 KB