blob: fbd00551045693fea0e7dffffdfe24d4bdd46edd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
SET DEFAULT_STORAGE_ENGINE='tokudb';
*** Bug #22169 ***
DROP TABLE IF EXISTS t1;
create table t1 (a int, b varchar(20), c int, clustering key (b(3)));
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 clustering key b(b(2));
select b from t1 where b > "10";
b
100000
200000
300000
400000
500000
DROP TABLE t1;
|
