--source include/have_tokudb.inc SET DEFAULT_STORAGE_ENGINE='tokudb'; --echo *** Bug #22169 *** --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings 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"; alter table t1 drop key b; alter table t1 add key b(b(2)) clustering=yes; select b from t1 where b > "10"; DROP TABLE t1;