1
#--source include/have_tokudb.inc
2
SET DEFAULT_STORAGE_ENGINE='tokudb';
5
DROP TABLE IF EXISTS foo,bar;
8
set session tokudb_disable_slow_alter=ON;
10
let $diff_tables= test.foo, test.bar;
12
create table foo (a int NOT NULL, b bigint NOT NULL, c mediumint NOT NULL, primary key (a), key (b) clustering=yes)engine=TokuDB;
13
create table bar like foo;
14
alter table bar engine=MyISAM;
16
insert into foo values (1,10,100),(-1,-1,-1),(2,20,200);
17
insert into bar select * from foo;
19
alter table foo add column d int default 20;
20
alter table bar add column d int default 20;
21
source include/diff_tables.inc;
23
select * from foo order by b desc;
24
insert into foo values (3,30,300,3000);
25
insert into bar values (3,30,300,3000);
27
select * from foo order by b desc;
29
alter table foo drop column d;
30
alter table bar drop column d;
31
source include/diff_tables.inc;
33
select * from foo order by b desc;
34
insert into foo values (4,40,400);
35
insert into bar values (4,40,400);
37
select * from foo order by b desc;
39
alter table foo add column d int default 20 first;
40
alter table bar add column d int default 20 first;
41
source include/diff_tables.inc;
43
select * from foo order by b desc;
44
insert into foo values (5,50,500,5000);
45
insert into bar values (5,50,500,5000);
47
select * from foo order by b desc;
49
alter table foo drop column d;
50
alter table bar drop column d;
51
source include/diff_tables.inc;
53
select * from foo order by b desc;
54
insert into foo values (6,60,600);
55
insert into bar values (6,60,600);
57
select * from foo order by b desc;
62
create table foo (a int NOT NULL, b bigint NOT NULL, c mediumint NOT NULL, primary key (c), key (b) clustering=yes)engine=TokuDB;
63
create table bar like foo;
64
alter table bar engine=MyISAM;
66
insert into foo values (1,10,100),(-1,-1,-1),(2,20,200);
67
insert into bar select * from foo;
69
alter table foo add column d int default 20;
70
alter table bar add column d int default 20;
71
source include/diff_tables.inc;
73
select * from foo order by b desc;
74
insert into foo values (3,30,300,3000);
75
insert into bar values (3,30,300,3000);
77
select * from foo order by b desc;
79
alter table foo drop column d;
80
alter table bar drop column d;
81
source include/diff_tables.inc;
83
select * from foo order by b desc;
84
insert into foo values (4,40,400);
85
insert into bar values (4,40,400);
87
select * from foo order by b desc;
89
alter table foo add column d int default 20 first;
90
alter table bar add column d int default 20 first;
91
source include/diff_tables.inc;
93
select * from foo order by b desc;
94
insert into foo values (5,50,500,5000);
95
insert into bar values (5,50,500,5000);
97
select * from foo order by b desc;
99
alter table foo drop column d;
100
alter table bar drop column d;
101
source include/diff_tables.inc;
103
select * from foo order by b desc;
104
insert into foo values (6,60,600);
105
insert into bar values (6,60,600);
107
select * from foo order by b desc;