subselect_no_mat.test 365 Bytes
Newer Older
1 2 3
# 
# Run subselect.test without semi-join optimization (test materialize)
#
4
select @@optimizer_switch like '%materialization=on%';
5
set optimizer_switch='materialization=off';
6
set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';
7 8 9 10

--source t/subselect.test

set optimizer_switch=default;
11
select @@optimizer_switch like '%materialization=on%';
12