1
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
2
DROP TABLE IF EXISTS t1,t2;
3
create table t1 (a int, b int, c int, key(a), key(b));
5
create table t1 (a int, b int, c int, primary key(a), key(b));
7
create table t1 (a int, b int, c int, key(a), key(b));
8
insert into t1 values (1,10,100);
13
create table t1 (a int, b int, c int, primary key(a), key(b));
14
insert into t1 values (1,10,100);
19
create table t1 (a int, b int, c int, key(a), key(b));
20
rename table t1 to t2;
22
create table t1 (a int, b int, c int, primary key(a), key(b));
23
rename table t1 to t2;
25
create table t1 (a int, b int, c int, key(a), key(b));
26
insert into t1 values (1,10,100);
30
rename table t1 to t2;
35
create table t1 (a int, b int, c int, primary key(a), key(b));
36
insert into t1 values (1,10,100);
40
rename table t1 to t2;
45
create table t1 (a int, b int, c int, key(a), key(b));
46
rename table t1 to t2;
47
insert into t2 values (1,10,100);
52
create table t1 (a int, b int, c int, primary key(a), key(b));
53
rename table t1 to t2;
54
insert into t2 values (1,10,100);
59
create table t1 (a int, b int, c int, key(a), key(b));
60
alter table t1 add index (c), add index (a,b);
62
create table t1 (a int, b int, c int, primary key(a), key(b));
63
alter table t1 add index (c), add index (a,b);
65
create table t1 (a int, b int, c int, key(a), key(b));
66
alter table t1 drop index b;
68
create table t1 (a int, b int, c int, primary key(a), key(b));
69
alter table t1 drop index b;
71
create table t1 (a int, b int, c int, key(a), key(b));
72
insert into t1 values (1,10,100);
73
alter table t1 add index (c), add index (a,b);
81
create table t1 (a int, b int, c int, primary key(a), key(b));
82
insert into t1 values (1,10,100);
83
alter table t1 add index (c), add index (a,b);
91
create table t1 (a int, b int, c int, key(a), key(b));
92
alter table t1 add index (c), add index (a,b), drop index b;
94
create table t1 (a int, b int, c int, primary key(a), key(b));
95
alter table t1 add index (c), add index (a,b), drop index b;
97
create table t1 (a int, b int, c int, key(a), key(b));
98
insert into t1 values (1,10,100);
99
alter table t1 add index (c), add index foo (a,b), drop index b;
103
select a,b from t1 use index (foo);
107
create table t1 (a int, b int, c int, primary key(a), key(b));
108
insert into t1 values (1,10,100);
109
alter table t1 add index (c), add index foo (a,b), drop index b;
113
select a,b from t1 use index (foo);
117
create table t1 (a int, b int, c int, key(a), key(b));
118
insert into t1 values (1,10,100);
123
insert into t1 values (2,20,200);
128
create table t1 (a int, b int, c int, primary key(a), key(b));
129
insert into t1 values (1,10,100);
134
insert into t1 values (2,20,200);
139
create table t1 (a int, b int, c int, key(a), key(b));
140
insert into t1 values (1,10,100);
144
alter table t1 add index (c), drop index b;
148
rename table t1 to t2;
152
alter table t2 add index (b), drop index c;
157
insert into t2 values (2,20,200);