diff options
Diffstat (limited to 'mysql-test/r/innodb_mrr_cpk.result')
| -rw-r--r-- | mysql-test/r/innodb_mrr_cpk.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_mrr_cpk.result b/mysql-test/r/innodb_mrr_cpk.result index 138bef49cea..81536f2a43b 100644 --- a/mysql-test/r/innodb_mrr_cpk.result +++ b/mysql-test/r/innodb_mrr_cpk.result @@ -1,4 +1,6 @@ drop table if exists t0,t1,t2,t3; +set @innodb_mrr_cpk_tmp=@@optimizer_switch; +set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; set @save_join_cache_level=@@join_cache_level; set join_cache_level=6; set @save_storage_engine=@@storage_engine; @@ -145,4 +147,5 @@ set optimizer_switch='index_condition_pushdown=on'; drop table t1,t2; set @@join_cache_level= @save_join_cache_level; set storage_engine=@save_storage_engine; +set optimizer_switch=@innodb_mrr_cpk_tmp; drop table t0; |