2
# Run select.test with BKA enabled
5
set @save_optimizer_switch_jcl6=@@optimizer_switch;
6
set @@optimizer_switch='optimize_join_buffer_size=on';
7
set @@optimizer_switch='semijoin_with_cache=on';
8
set @@optimizer_switch='outer_join_with_cache=on';
9
set @@optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';
11
set join_cache_level=6;
12
show variables like 'join_cache_level';
14
set @optimizer_switch_for_select_test=@@optimizer_switch;
15
set @join_cache_level_for_select_test=@@join_cache_level;
17
--source t/select.test
19
set join_cache_level=default;
20
show variables like 'join_cache_level';
22
set @@optimizer_switch=@save_optimizer_switch_jcl6;
23
set @optimizer_switch_for_select_test=NULL;
24
set @join_cache_level_for_select_test=NULL;