diff options
Diffstat (limited to 'mysql-test/t/subselect_sj2.test')
| -rw-r--r-- | mysql-test/t/subselect_sj2.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj2.test b/mysql-test/t/subselect_sj2.test index f4573a94407..7caf5da7b8b 100644 --- a/mysql-test/t/subselect_sj2.test +++ b/mysql-test/t/subselect_sj2.test @@ -2,6 +2,9 @@ # DuplicateElimination strategy test # --source include/have_innodb.inc + +set @subselect_sj2_tmp= @@optimizer_switch; +set optimizer_switch='semijoin=on,firstmatch=on,loosescan=on'; --disable_warnings drop table if exists t0, t1, t2, t3; drop view if exists v1; @@ -939,3 +942,5 @@ WHERE alias2.f11 IN ( ) GROUP BY field2; drop table t1, t2, t3; + +set optimizer_switch=@subselect_sj2_tmp; |