summaryrefslogtreecommitdiff
path: root/mysql-test/main/range_innodb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/range_innodb.result')
-rw-r--r--mysql-test/main/range_innodb.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/range_innodb.result b/mysql-test/main/range_innodb.result
index e7792fec0ff..eddfbfd0d62 100644
--- a/mysql-test/main/range_innodb.result
+++ b/mysql-test/main/range_innodb.result
@@ -40,13 +40,13 @@ drop table t0,t2;
create table t1 (
pk int, a int, b int,
primary key (pk), index idx1(b), index idx2(b)
-) engine=innodb;
+) engine=innodb STATS_AUTO_RECALC=0;
Warnings:
Note 1831 Duplicate index `idx2`. This is deprecated and will be disallowed in a future release
insert into t1 values (1,6,0),(2,1,0),(3,5,2),(4,8,0);
-create table t2 (c int) engine=innodb;
+create table t2 (c int) engine=innodb STATS_AUTO_RECALC=0;
insert into t2 values (1),(2);
-create table t3 (d int) engine=innodb;
+create table t3 (d int) engine=innodb STATS_AUTO_RECALC=0;
insert into t3 values (3),(-1),(4);
set @save_optimizer_switch=@@optimizer_switch;
set optimizer_switch='extended_keys=on';