• Oleg Smirnov's avatar
    MDEV-33281 Make BNL() hint work for join_cache_levels from 0 to 3 · 824c20ae
    Oleg Smirnov authored
    BNL() hint effectively increases join_cache_level up to 4 if it is
    set to value less than 4.
    This commit also makes the BKA() hint override not only
    `join_cache_bka` optimizer switch but `join_cache_level` as well.
    I.e., BKA() hint enables BKA and BKAH join buffers both flat and
    incremental despite `join_cache_level` and `join_cache_bka` setting.
    824c20ae
opt_hints.test 34.8 KB