1
SET DEFAULT_STORAGE_ENGINE='tokudb';
3
DROP TABLE IF EXISTS t1;
4
create table t1 (a int, b varchar(20), c int, key (b(3)) clustering=yes);
5
insert into t1 values (1,"100000",100);
6
insert into t1 values (2,"200000",200);
7
insert into t1 values (3,"300000",300);
8
insert into t1 values (4,"400000",400);
9
insert into t1 values (5,"500000",500);
10
select b from t1 where b > "10";
17
alter table t1 drop key b;
18
alter table t1 add key b(b(2)) clustering=yes;
19
select b from t1 where b > "10";