1--source include/have_tokudb.inc
2SET DEFAULT_STORAGE_ENGINE='tokudb';
3
4--disable_warnings
5DROP TABLE IF EXISTS foo,bar;
6--enable_warnings
7
8set session tokudb_disable_slow_alter=ON;
9
10let $diff_tables= test.foo, test.bar;
11
12
13create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
14create table bar like foo;
15alter table bar engine=MyISAM;
16insert into foo values (NULL,NULL,NULL,NULL);
17insert into foo values (-1,NULL,'2008-1-1',NULL);
18insert into foo values (NULL,12345678987,NULL,1);
19insert into foo values (2,20,'1999-11-11',0);
20insert into bar select * from foo;
21source include/diff_tables.inc;
22alter table foo drop column aaa;
23alter table bar drop column aaa;
24source include/diff_tables.inc;
25drop table foo; drop table bar;
26
27
28create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
29create table bar like foo;
30alter table bar engine=MyISAM;
31insert into foo values (NULL,NULL,NULL,NULL);
32insert into foo values (-1,NULL,'2008-1-1',NULL);
33insert into foo values (NULL,12345678987,NULL,1);
34insert into foo values (2,20,'1999-11-11',0);
35insert into bar select * from foo;
36source include/diff_tables.inc;
37alter table foo drop column bbb;
38alter table bar drop column bbb;
39source include/diff_tables.inc;
40drop table foo; drop table bar;
41
42
43create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
44create table bar like foo;
45alter table bar engine=MyISAM;
46insert into foo values (NULL,NULL,NULL,NULL);
47insert into foo values (-1,NULL,'2008-1-1',NULL);
48insert into foo values (NULL,12345678987,NULL,1);
49insert into foo values (2,20,'1999-11-11',0);
50insert into bar select * from foo;
51source include/diff_tables.inc;
52alter table foo drop column ccc;
53alter table bar drop column ccc;
54source include/diff_tables.inc;
55drop table foo; drop table bar;
56
57
58create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
59create table bar like foo;
60alter table bar engine=MyISAM;
61insert into foo values (NULL,NULL,NULL,NULL);
62insert into foo values (-1,NULL,'2008-1-1',NULL);
63insert into foo values (NULL,12345678987,NULL,1);
64insert into foo values (2,20,'1999-11-11',0);
65insert into bar select * from foo;
66source include/diff_tables.inc;
67alter table foo drop column ddd;
68alter table bar drop column ddd;
69source include/diff_tables.inc;
70drop table foo; drop table bar;
71
72
73create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
74create table bar like foo;
75alter table bar engine=MyISAM;
76insert into foo values (NULL,NULL,NULL,NULL);
77insert into foo values (-1,NULL,'2008-1-1',NULL);
78insert into foo values (NULL,12345678987,NULL,1);
79insert into foo values (2,20,'1999-11-11',0);
80insert into bar select * from foo;
81source include/diff_tables.inc;
82alter table foo drop column aaa, drop column bbb;
83alter table bar drop column aaa, drop column bbb;
84source include/diff_tables.inc;
85drop table foo; drop table bar;
86
87
88create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
89create table bar like foo;
90alter table bar engine=MyISAM;
91insert into foo values (NULL,NULL,NULL,NULL);
92insert into foo values (-1,NULL,'2008-1-1',NULL);
93insert into foo values (NULL,12345678987,NULL,1);
94insert into foo values (2,20,'1999-11-11',0);
95insert into bar select * from foo;
96source include/diff_tables.inc;
97alter table foo drop column aaa, drop column ccc;
98alter table bar drop column aaa, drop column ccc;
99source include/diff_tables.inc;
100drop table foo; drop table bar;
101
102
103create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
104create table bar like foo;
105alter table bar engine=MyISAM;
106insert into foo values (NULL,NULL,NULL,NULL);
107insert into foo values (-1,NULL,'2008-1-1',NULL);
108insert into foo values (NULL,12345678987,NULL,1);
109insert into foo values (2,20,'1999-11-11',0);
110insert into bar select * from foo;
111source include/diff_tables.inc;
112alter table foo drop column aaa, drop column ddd;
113alter table bar drop column aaa, drop column ddd;
114source include/diff_tables.inc;
115drop table foo; drop table bar;
116
117
118create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
119create table bar like foo;
120alter table bar engine=MyISAM;
121insert into foo values (NULL,NULL,NULL,NULL);
122insert into foo values (-1,NULL,'2008-1-1',NULL);
123insert into foo values (NULL,12345678987,NULL,1);
124insert into foo values (2,20,'1999-11-11',0);
125insert into bar select * from foo;
126source include/diff_tables.inc;
127alter table foo drop column bbb, drop column aaa;
128alter table bar drop column bbb, drop column aaa;
129source include/diff_tables.inc;
130drop table foo; drop table bar;
131
132
133create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
134create table bar like foo;
135alter table bar engine=MyISAM;
136insert into foo values (NULL,NULL,NULL,NULL);
137insert into foo values (-1,NULL,'2008-1-1',NULL);
138insert into foo values (NULL,12345678987,NULL,1);
139insert into foo values (2,20,'1999-11-11',0);
140insert into bar select * from foo;
141source include/diff_tables.inc;
142alter table foo drop column bbb, drop column ccc;
143alter table bar drop column bbb, drop column ccc;
144source include/diff_tables.inc;
145drop table foo; drop table bar;
146
147
148create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
149create table bar like foo;
150alter table bar engine=MyISAM;
151insert into foo values (NULL,NULL,NULL,NULL);
152insert into foo values (-1,NULL,'2008-1-1',NULL);
153insert into foo values (NULL,12345678987,NULL,1);
154insert into foo values (2,20,'1999-11-11',0);
155insert into bar select * from foo;
156source include/diff_tables.inc;
157alter table foo drop column bbb, drop column ddd;
158alter table bar drop column bbb, drop column ddd;
159source include/diff_tables.inc;
160drop table foo; drop table bar;
161
162
163create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
164create table bar like foo;
165alter table bar engine=MyISAM;
166insert into foo values (NULL,NULL,NULL,NULL);
167insert into foo values (-1,NULL,'2008-1-1',NULL);
168insert into foo values (NULL,12345678987,NULL,1);
169insert into foo values (2,20,'1999-11-11',0);
170insert into bar select * from foo;
171source include/diff_tables.inc;
172alter table foo drop column ccc, drop column aaa;
173alter table bar drop column ccc, drop column aaa;
174source include/diff_tables.inc;
175drop table foo; drop table bar;
176
177
178create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
179create table bar like foo;
180alter table bar engine=MyISAM;
181insert into foo values (NULL,NULL,NULL,NULL);
182insert into foo values (-1,NULL,'2008-1-1',NULL);
183insert into foo values (NULL,12345678987,NULL,1);
184insert into foo values (2,20,'1999-11-11',0);
185insert into bar select * from foo;
186source include/diff_tables.inc;
187alter table foo drop column ccc, drop column bbb;
188alter table bar drop column ccc, drop column bbb;
189source include/diff_tables.inc;
190drop table foo; drop table bar;
191
192
193create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
194create table bar like foo;
195alter table bar engine=MyISAM;
196insert into foo values (NULL,NULL,NULL,NULL);
197insert into foo values (-1,NULL,'2008-1-1',NULL);
198insert into foo values (NULL,12345678987,NULL,1);
199insert into foo values (2,20,'1999-11-11',0);
200insert into bar select * from foo;
201source include/diff_tables.inc;
202alter table foo drop column ccc, drop column ddd;
203alter table bar drop column ccc, drop column ddd;
204source include/diff_tables.inc;
205drop table foo; drop table bar;
206
207
208create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
209create table bar like foo;
210alter table bar engine=MyISAM;
211insert into foo values (NULL,NULL,NULL,NULL);
212insert into foo values (-1,NULL,'2008-1-1',NULL);
213insert into foo values (NULL,12345678987,NULL,1);
214insert into foo values (2,20,'1999-11-11',0);
215insert into bar select * from foo;
216source include/diff_tables.inc;
217alter table foo drop column ddd, drop column aaa;
218alter table bar drop column ddd, drop column aaa;
219source include/diff_tables.inc;
220drop table foo; drop table bar;
221
222
223create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
224create table bar like foo;
225alter table bar engine=MyISAM;
226insert into foo values (NULL,NULL,NULL,NULL);
227insert into foo values (-1,NULL,'2008-1-1',NULL);
228insert into foo values (NULL,12345678987,NULL,1);
229insert into foo values (2,20,'1999-11-11',0);
230insert into bar select * from foo;
231source include/diff_tables.inc;
232alter table foo drop column ddd, drop column bbb;
233alter table bar drop column ddd, drop column bbb;
234source include/diff_tables.inc;
235drop table foo; drop table bar;
236
237
238create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
239create table bar like foo;
240alter table bar engine=MyISAM;
241insert into foo values (NULL,NULL,NULL,NULL);
242insert into foo values (-1,NULL,'2008-1-1',NULL);
243insert into foo values (NULL,12345678987,NULL,1);
244insert into foo values (2,20,'1999-11-11',0);
245insert into bar select * from foo;
246source include/diff_tables.inc;
247alter table foo drop column ddd, drop column ccc;
248alter table bar drop column ddd, drop column ccc;
249source include/diff_tables.inc;
250drop table foo; drop table bar;
251
252
253create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
254create table bar like foo;
255alter table bar engine=MyISAM;
256insert into foo values (NULL,NULL,NULL,NULL);
257insert into foo values (-1,NULL,'2008-1-1',NULL);
258insert into foo values (NULL,12345678987,NULL,1);
259insert into foo values (2,20,'1999-11-11',0);
260insert into bar select * from foo;
261source include/diff_tables.inc;
262alter table foo drop column aaa, drop column bbb, drop column ccc;
263alter table bar drop column aaa, drop column bbb, drop column ccc;
264source include/diff_tables.inc;
265drop table foo; drop table bar;
266
267
268create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
269create table bar like foo;
270alter table bar engine=MyISAM;
271insert into foo values (NULL,NULL,NULL,NULL);
272insert into foo values (-1,NULL,'2008-1-1',NULL);
273insert into foo values (NULL,12345678987,NULL,1);
274insert into foo values (2,20,'1999-11-11',0);
275insert into bar select * from foo;
276source include/diff_tables.inc;
277alter table foo drop column aaa, drop column bbb, drop column ddd;
278alter table bar drop column aaa, drop column bbb, drop column ddd;
279source include/diff_tables.inc;
280drop table foo; drop table bar;
281
282
283create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
284create table bar like foo;
285alter table bar engine=MyISAM;
286insert into foo values (NULL,NULL,NULL,NULL);
287insert into foo values (-1,NULL,'2008-1-1',NULL);
288insert into foo values (NULL,12345678987,NULL,1);
289insert into foo values (2,20,'1999-11-11',0);
290insert into bar select * from foo;
291source include/diff_tables.inc;
292alter table foo drop column aaa, drop column ccc, drop column ddd;
293alter table bar drop column aaa, drop column ccc, drop column ddd;
294source include/diff_tables.inc;
295drop table foo; drop table bar;
296
297
298create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB;
299create table bar like foo;
300alter table bar engine=MyISAM;
301insert into foo values (NULL,NULL,NULL,NULL);
302insert into foo values (-1,NULL,'2008-1-1',NULL);
303insert into foo values (NULL,12345678987,NULL,1);
304insert into foo values (2,20,'1999-11-11',0);
305insert into bar select * from foo;
306source include/diff_tables.inc;
307alter table foo drop column bbb, drop column ccc, drop column ddd;
308alter table bar drop column bbb, drop column ccc, drop column ddd;
309source include/diff_tables.inc;
310drop table foo; drop table bar;
311