EVOLUTION-MANAGER

Edit File: ext_key_2_innodb.test

source include/have_tokudb.inc; source include/have_innodb.inc; disable_warnings; drop table if exists t; enable_warnings; select @@optimizer_switch; create table t (a int not null, b int not null, c int not null, d int not null, primary key(a,b), key(c,a)) engine=innodb; insert into t values (0,0,0,0),(0,1,0,1); explain select c,a,b from t where c=0 and a=0 and b=1; flush status; select c,a,b from t where c=0 and a=0 and b=1; show status like 'handler_read%'; explain select c,a,b from t force index (c) where c=0 and a=0 and b=1; flush status; select c,a,b from t force index (c) where c=0 and a=0 and b=1; show status like 'handler_read%'; drop table t;