tokudb/r/cluster_filter_varchar_prefix.result

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