From 1492de8563ac6032481fe69189f4f1f1e14fe73b Mon Sep 17 00:00:00 2001 From: Sergey Petrunya Date: Fri, 8 Jul 2011 18:46:47 +0400 Subject: Set the default to be mrr=off,mrr_sort_keys=off: - Set the default - Adjust the testcases so that 'new' tests are run with optimizations turned on. - Pull out relevant tests from "irrelevant" tests and run them with optimizations on. - Run range.test and innodb.test with both mrr=on and mrr=off --- mysql-test/t/subselect4.test | 1 + 1 file changed, 1 insertion(+) (limited to 'mysql-test/t/subselect4.test') diff --git a/mysql-test/t/subselect4.test b/mysql-test/t/subselect4.test index 1cc3a7314a3..a745d74e56c 100644 --- a/mysql-test/t/subselect4.test +++ b/mysql-test/t/subselect4.test @@ -6,6 +6,7 @@ drop table if exists t1,t2,t3,t4,t5,t6; set @subselect4_tmp= @@optimizer_switch; set optimizer_switch='semijoin=on,firstmatch=on,loosescan=on'; +set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; --echo # --echo # Bug #46791: Assertion failed:(table->key_read==0),function unknown -- cgit v1.2.1