#
# Run subquery_sj_xengine.inc with all of the so-called 6.0 features.
#


set optimizer_switch='semijoin=on,materialization=on,firstmatch=on,loosescan=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=off';

--source suite/xengine_main/include/subquery_sj_xengine.inc

set optimizer_switch=default;


--source suite/xengine/include/check_xengine_log_error.inc