1#
2# Run subselect3.test with BKA enabled
3#
4
5--source include/default_optimizer_switch.inc
6
7set @@optimizer_switch='optimize_join_buffer_size=on';
8set @@optimizer_switch='semijoin_with_cache=on';
9set @@optimizer_switch='outer_join_with_cache=on';
10set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';
11set join_cache_level=6;
12
13--source subselect3.inc
14
15--echo # end of 10.2 test
16