set @subselect_extra_no_sj_tmp=@@optimizer_switch; set optimizer_switch='semijoin=off,firstmatch=off,loosescan=off'; --source t/subselect_extra.test set optimizer_switch= @subselect_extra_no_sj_tmp;