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;