diff options
Diffstat (limited to 'mysql-test/t/myisam_icp.test')
-rw-r--r-- | mysql-test/t/myisam_icp.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/myisam_icp.test b/mysql-test/t/myisam_icp.test index 30a8b208230..7cc35a25e91 100644 --- a/mysql-test/t/myisam_icp.test +++ b/mysql-test/t/myisam_icp.test @@ -4,6 +4,9 @@ --source include/icp_tests.inc +set @myisam_icp_tmp=@@optimizer_switch; +set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; + --disable_warnings drop table if exists t0, t1, t1i, t1m; --enable_warnings @@ -192,3 +195,4 @@ drop table if exists t0, t1, t1i, t1m; drop table t0, t1, t1i, t1m; --enable_parsing +set optimizer_switch=@myisam_icp_tmp; |