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/r/ps_2myisam.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/r/ps_2myisam.result') diff --git a/mysql-test/r/ps_2myisam.result b/mysql-test/r/ps_2myisam.result index e99c5b9942b..2a9d08a70f4 100644 --- a/mysql-test/r/ps_2myisam.result +++ b/mysql-test/r/ps_2myisam.result @@ -1509,8 +1509,8 @@ prepare stmt1 from 'insert into t1 values(?,?),(?,?)'; execute stmt1 using @arg00, @arg01, @arg02, @arg03 ; select a,b from t1 where a in (@arg00,@arg02) ; a b -82 8-2 81 8-1 +82 8-2 set @arg00=9 ; set @arg01='nine' ; prepare stmt1 from 'insert into t1 set a=?, b=? '; -- cgit v1.2.1