2
# Run subquery_sj.inc with subquery materialization and without semijoin
5
--source include/have_materialization.inc
6
set optimizer_switch='materialization=on';
9
if (`select locate('semijoin', @@optimizer_switch) > 0`)
11
set optimizer_switch='semijoin=off';
13
if (`select locate('index_condition_pushdown', @@optimizer_switch) > 0`)
15
set optimizer_switch='index_condition_pushdown=off';
17
if (`select locate('mrr', @@optimizer_switch) > 0`)
19
set optimizer_switch='mrr=off';
23
--source include/subquery_sj.inc
25
set optimizer_switch=default;