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 (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
14create table bar like foo;
15alter table bar engine=MyISAM;
16insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
17insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
18insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
19insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
20insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
21insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
22insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
23insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
24insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
25insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
26insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
27insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
28insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
29insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
30insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
31insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
32insert into bar select * from foo;
33source include/diff_tables.inc;
34alter table foo drop column a;
35alter table bar drop column a;
36source include/diff_tables.inc;
37drop table foo; drop table bar;
38
39
40create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
41create table bar like foo;
42alter table bar engine=MyISAM;
43insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
44insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
45insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
46insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
47insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
48insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
49insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
50insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
51insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
52insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
53insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
54insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
55insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
56insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
57insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
58insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
59insert into bar select * from foo;
60source include/diff_tables.inc;
61alter table foo drop column b;
62alter table bar drop column b;
63source include/diff_tables.inc;
64drop table foo; drop table bar;
65
66
67create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
68create table bar like foo;
69alter table bar engine=MyISAM;
70insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
71insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
72insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
73insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
74insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
75insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
76insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
77insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
78insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
79insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
80insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
81insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
82insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
83insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
84insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
85insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
86insert into bar select * from foo;
87source include/diff_tables.inc;
88alter table foo drop column c;
89alter table bar drop column c;
90source include/diff_tables.inc;
91drop table foo; drop table bar;
92
93
94create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
95create table bar like foo;
96alter table bar engine=MyISAM;
97insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
98insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
99insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
100insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
101insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
102insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
103insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
104insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
105insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
106insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
107insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
108insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
109insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
110insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
111insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
112insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
113insert into bar select * from foo;
114source include/diff_tables.inc;
115alter table foo drop column d;
116alter table bar drop column d;
117source include/diff_tables.inc;
118drop table foo; drop table bar;
119
120
121create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
122create table bar like foo;
123alter table bar engine=MyISAM;
124insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
125insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
126insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
127insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
128insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
129insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
130insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
131insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
132insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
133insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
134insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
135insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
136insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
137insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
138insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
139insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
140insert into bar select * from foo;
141source include/diff_tables.inc;
142alter table foo drop column aa;
143alter table bar drop column aa;
144source include/diff_tables.inc;
145drop table foo; drop table bar;
146
147
148create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
149create table bar like foo;
150alter table bar engine=MyISAM;
151insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
152insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
153insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
154insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
155insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
156insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
157insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
158insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
159insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
160insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
161insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
162insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
163insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
164insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
165insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
166insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
167insert into bar select * from foo;
168source include/diff_tables.inc;
169alter table foo drop column bb;
170alter table bar drop column bb;
171source include/diff_tables.inc;
172drop table foo; drop table bar;
173
174
175create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
176create table bar like foo;
177alter table bar engine=MyISAM;
178insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
179insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
180insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
181insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
182insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
183insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
184insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
185insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
186insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
187insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
188insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
189insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
190insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
191insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
192insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
193insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
194insert into bar select * from foo;
195source include/diff_tables.inc;
196alter table foo drop column cc;
197alter table bar drop column cc;
198source include/diff_tables.inc;
199drop table foo; drop table bar;
200
201
202create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
203create table bar like foo;
204alter table bar engine=MyISAM;
205insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
206insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
207insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
208insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
209insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
210insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
211insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
212insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
213insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
214insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
215insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
216insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
217insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
218insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
219insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
220insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
221insert into bar select * from foo;
222source include/diff_tables.inc;
223alter table foo drop column dd;
224alter table bar drop column dd;
225source include/diff_tables.inc;
226drop table foo; drop table bar;
227
228
229create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
230create table bar like foo;
231alter table bar engine=MyISAM;
232insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
233insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
234insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
235insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
236insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
237insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
238insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
239insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
240insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
241insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
242insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
243insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
244insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
245insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
246insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
247insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
248insert into bar select * from foo;
249source include/diff_tables.inc;
250alter table foo drop column a, drop column b;
251alter table bar drop column a, drop column b;
252source include/diff_tables.inc;
253drop table foo; drop table bar;
254
255
256create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
257create table bar like foo;
258alter table bar engine=MyISAM;
259insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
260insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
261insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
262insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
263insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
264insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
265insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
266insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
267insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
268insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
269insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
270insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
271insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
272insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
273insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
274insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
275insert into bar select * from foo;
276source include/diff_tables.inc;
277alter table foo drop column a, drop column c;
278alter table bar drop column a, drop column c;
279source include/diff_tables.inc;
280drop table foo; drop table bar;
281
282
283create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
284create table bar like foo;
285alter table bar engine=MyISAM;
286insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
287insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
288insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
289insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
290insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
291insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
292insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
293insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
294insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
295insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
296insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
297insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
298insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
299insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
300insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
301insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
302insert into bar select * from foo;
303source include/diff_tables.inc;
304alter table foo drop column a, drop column d;
305alter table bar drop column a, drop column d;
306source include/diff_tables.inc;
307drop table foo; drop table bar;
308
309
310create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
311create table bar like foo;
312alter table bar engine=MyISAM;
313insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
314insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
315insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
316insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
317insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
318insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
319insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
320insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
321insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
322insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
323insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
324insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
325insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
326insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
327insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
328insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
329insert into bar select * from foo;
330source include/diff_tables.inc;
331alter table foo drop column a, drop column aa;
332alter table bar drop column a, drop column aa;
333source include/diff_tables.inc;
334drop table foo; drop table bar;
335
336
337create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
338create table bar like foo;
339alter table bar engine=MyISAM;
340insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
341insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
342insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
343insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
344insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
345insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
346insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
347insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
348insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
349insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
350insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
351insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
352insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
353insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
354insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
355insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
356insert into bar select * from foo;
357source include/diff_tables.inc;
358alter table foo drop column a, drop column bb;
359alter table bar drop column a, drop column bb;
360source include/diff_tables.inc;
361drop table foo; drop table bar;
362
363
364create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
365create table bar like foo;
366alter table bar engine=MyISAM;
367insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
368insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
369insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
370insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
371insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
372insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
373insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
374insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
375insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
376insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
377insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
378insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
379insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
380insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
381insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
382insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
383insert into bar select * from foo;
384source include/diff_tables.inc;
385alter table foo drop column a, drop column cc;
386alter table bar drop column a, drop column cc;
387source include/diff_tables.inc;
388drop table foo; drop table bar;
389
390
391create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
392create table bar like foo;
393alter table bar engine=MyISAM;
394insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
395insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
396insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
397insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
398insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
399insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
400insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
401insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
402insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
403insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
404insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
405insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
406insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
407insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
408insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
409insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
410insert into bar select * from foo;
411source include/diff_tables.inc;
412alter table foo drop column a, drop column dd;
413alter table bar drop column a, drop column dd;
414source include/diff_tables.inc;
415drop table foo; drop table bar;
416
417
418create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
419create table bar like foo;
420alter table bar engine=MyISAM;
421insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
422insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
423insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
424insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
425insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
426insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
427insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
428insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
429insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
430insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
431insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
432insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
433insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
434insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
435insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
436insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
437insert into bar select * from foo;
438source include/diff_tables.inc;
439alter table foo drop column b, drop column a;
440alter table bar drop column b, drop column a;
441source include/diff_tables.inc;
442drop table foo; drop table bar;
443
444
445create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
446create table bar like foo;
447alter table bar engine=MyISAM;
448insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
449insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
450insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
451insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
452insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
453insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
454insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
455insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
456insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
457insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
458insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
459insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
460insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
461insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
462insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
463insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
464insert into bar select * from foo;
465source include/diff_tables.inc;
466alter table foo drop column b, drop column c;
467alter table bar drop column b, drop column c;
468source include/diff_tables.inc;
469drop table foo; drop table bar;
470
471
472create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
473create table bar like foo;
474alter table bar engine=MyISAM;
475insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
476insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
477insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
478insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
479insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
480insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
481insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
482insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
483insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
484insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
485insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
486insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
487insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
488insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
489insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
490insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
491insert into bar select * from foo;
492source include/diff_tables.inc;
493alter table foo drop column b, drop column d;
494alter table bar drop column b, drop column d;
495source include/diff_tables.inc;
496drop table foo; drop table bar;
497
498
499create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
500create table bar like foo;
501alter table bar engine=MyISAM;
502insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
503insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
504insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
505insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
506insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
507insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
508insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
509insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
510insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
511insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
512insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
513insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
514insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
515insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
516insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
517insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
518insert into bar select * from foo;
519source include/diff_tables.inc;
520alter table foo drop column b, drop column aa;
521alter table bar drop column b, drop column aa;
522source include/diff_tables.inc;
523drop table foo; drop table bar;
524
525
526create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
527create table bar like foo;
528alter table bar engine=MyISAM;
529insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
530insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
531insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
532insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
533insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
534insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
535insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
536insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
537insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
538insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
539insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
540insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
541insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
542insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
543insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
544insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
545insert into bar select * from foo;
546source include/diff_tables.inc;
547alter table foo drop column b, drop column bb;
548alter table bar drop column b, drop column bb;
549source include/diff_tables.inc;
550drop table foo; drop table bar;
551
552
553create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
554create table bar like foo;
555alter table bar engine=MyISAM;
556insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
557insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
558insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
559insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
560insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
561insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
562insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
563insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
564insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
565insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
566insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
567insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
568insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
569insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
570insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
571insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
572insert into bar select * from foo;
573source include/diff_tables.inc;
574alter table foo drop column b, drop column cc;
575alter table bar drop column b, drop column cc;
576source include/diff_tables.inc;
577drop table foo; drop table bar;
578
579
580create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
581create table bar like foo;
582alter table bar engine=MyISAM;
583insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
584insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
585insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
586insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
587insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
588insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
589insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
590insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
591insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
592insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
593insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
594insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
595insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
596insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
597insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
598insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
599insert into bar select * from foo;
600source include/diff_tables.inc;
601alter table foo drop column b, drop column dd;
602alter table bar drop column b, drop column dd;
603source include/diff_tables.inc;
604drop table foo; drop table bar;
605
606
607create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
608create table bar like foo;
609alter table bar engine=MyISAM;
610insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
611insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
612insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
613insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
614insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
615insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
616insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
617insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
618insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
619insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
620insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
621insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
622insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
623insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
624insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
625insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
626insert into bar select * from foo;
627source include/diff_tables.inc;
628alter table foo drop column c, drop column a;
629alter table bar drop column c, drop column a;
630source include/diff_tables.inc;
631drop table foo; drop table bar;
632
633
634create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
635create table bar like foo;
636alter table bar engine=MyISAM;
637insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
638insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
639insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
640insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
641insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
642insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
643insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
644insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
645insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
646insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
647insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
648insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
649insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
650insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
651insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
652insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
653insert into bar select * from foo;
654source include/diff_tables.inc;
655alter table foo drop column c, drop column b;
656alter table bar drop column c, drop column b;
657source include/diff_tables.inc;
658drop table foo; drop table bar;
659
660
661create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
662create table bar like foo;
663alter table bar engine=MyISAM;
664insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
665insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
666insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
667insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
668insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
669insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
670insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
671insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
672insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
673insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
674insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
675insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
676insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
677insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
678insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
679insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
680insert into bar select * from foo;
681source include/diff_tables.inc;
682alter table foo drop column c, drop column d;
683alter table bar drop column c, drop column d;
684source include/diff_tables.inc;
685drop table foo; drop table bar;
686
687
688create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
689create table bar like foo;
690alter table bar engine=MyISAM;
691insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
692insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
693insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
694insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
695insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
696insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
697insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
698insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
699insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
700insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
701insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
702insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
703insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
704insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
705insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
706insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
707insert into bar select * from foo;
708source include/diff_tables.inc;
709alter table foo drop column c, drop column aa;
710alter table bar drop column c, drop column aa;
711source include/diff_tables.inc;
712drop table foo; drop table bar;
713
714
715create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
716create table bar like foo;
717alter table bar engine=MyISAM;
718insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
719insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
720insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
721insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
722insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
723insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
724insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
725insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
726insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
727insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
728insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
729insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
730insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
731insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
732insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
733insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
734insert into bar select * from foo;
735source include/diff_tables.inc;
736alter table foo drop column c, drop column bb;
737alter table bar drop column c, drop column bb;
738source include/diff_tables.inc;
739drop table foo; drop table bar;
740
741
742create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
743create table bar like foo;
744alter table bar engine=MyISAM;
745insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
746insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
747insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
748insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
749insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
750insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
751insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
752insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
753insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
754insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
755insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
756insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
757insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
758insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
759insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
760insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
761insert into bar select * from foo;
762source include/diff_tables.inc;
763alter table foo drop column c, drop column cc;
764alter table bar drop column c, drop column cc;
765source include/diff_tables.inc;
766drop table foo; drop table bar;
767
768
769create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
770create table bar like foo;
771alter table bar engine=MyISAM;
772insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
773insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
774insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
775insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
776insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
777insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
778insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
779insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
780insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
781insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
782insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
783insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
784insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
785insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
786insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
787insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
788insert into bar select * from foo;
789source include/diff_tables.inc;
790alter table foo drop column c, drop column dd;
791alter table bar drop column c, drop column dd;
792source include/diff_tables.inc;
793drop table foo; drop table bar;
794
795
796create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
797create table bar like foo;
798alter table bar engine=MyISAM;
799insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
800insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
801insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
802insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
803insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
804insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
805insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
806insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
807insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
808insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
809insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
810insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
811insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
812insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
813insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
814insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
815insert into bar select * from foo;
816source include/diff_tables.inc;
817alter table foo drop column d, drop column a;
818alter table bar drop column d, drop column a;
819source include/diff_tables.inc;
820drop table foo; drop table bar;
821
822
823create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
824create table bar like foo;
825alter table bar engine=MyISAM;
826insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
827insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
828insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
829insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
830insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
831insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
832insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
833insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
834insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
835insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
836insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
837insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
838insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
839insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
840insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
841insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
842insert into bar select * from foo;
843source include/diff_tables.inc;
844alter table foo drop column d, drop column b;
845alter table bar drop column d, drop column b;
846source include/diff_tables.inc;
847drop table foo; drop table bar;
848
849
850create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
851create table bar like foo;
852alter table bar engine=MyISAM;
853insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
854insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
855insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
856insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
857insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
858insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
859insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
860insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
861insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
862insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
863insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
864insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
865insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
866insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
867insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
868insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
869insert into bar select * from foo;
870source include/diff_tables.inc;
871alter table foo drop column d, drop column c;
872alter table bar drop column d, drop column c;
873source include/diff_tables.inc;
874drop table foo; drop table bar;
875
876
877create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
878create table bar like foo;
879alter table bar engine=MyISAM;
880insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
881insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
882insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
883insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
884insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
885insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
886insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
887insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
888insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
889insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
890insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
891insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
892insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
893insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
894insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
895insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
896insert into bar select * from foo;
897source include/diff_tables.inc;
898alter table foo drop column d, drop column aa;
899alter table bar drop column d, drop column aa;
900source include/diff_tables.inc;
901drop table foo; drop table bar;
902
903
904create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
905create table bar like foo;
906alter table bar engine=MyISAM;
907insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
908insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
909insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
910insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
911insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
912insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
913insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
914insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
915insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
916insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
917insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
918insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
919insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
920insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
921insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
922insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
923insert into bar select * from foo;
924source include/diff_tables.inc;
925alter table foo drop column d, drop column bb;
926alter table bar drop column d, drop column bb;
927source include/diff_tables.inc;
928drop table foo; drop table bar;
929
930
931create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
932create table bar like foo;
933alter table bar engine=MyISAM;
934insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
935insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
936insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
937insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
938insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
939insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
940insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
941insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
942insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
943insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
944insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
945insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
946insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
947insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
948insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
949insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
950insert into bar select * from foo;
951source include/diff_tables.inc;
952alter table foo drop column d, drop column cc;
953alter table bar drop column d, drop column cc;
954source include/diff_tables.inc;
955drop table foo; drop table bar;
956
957
958create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
959create table bar like foo;
960alter table bar engine=MyISAM;
961insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
962insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
963insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
964insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
965insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
966insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
967insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
968insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
969insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
970insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
971insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
972insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
973insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
974insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
975insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
976insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
977insert into bar select * from foo;
978source include/diff_tables.inc;
979alter table foo drop column d, drop column dd;
980alter table bar drop column d, drop column dd;
981source include/diff_tables.inc;
982drop table foo; drop table bar;
983
984
985create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
986create table bar like foo;
987alter table bar engine=MyISAM;
988insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
989insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
990insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
991insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
992insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
993insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
994insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
995insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
996insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
997insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
998insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
999insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1000insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1001insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1002insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1003insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1004insert into bar select * from foo;
1005source include/diff_tables.inc;
1006alter table foo drop column aa, drop column a;
1007alter table bar drop column aa, drop column a;
1008source include/diff_tables.inc;
1009drop table foo; drop table bar;
1010
1011
1012create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1013create table bar like foo;
1014alter table bar engine=MyISAM;
1015insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1016insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1017insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1018insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1019insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1020insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1021insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1022insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1023insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1024insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1025insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1026insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1027insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1028insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1029insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1030insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1031insert into bar select * from foo;
1032source include/diff_tables.inc;
1033alter table foo drop column aa, drop column b;
1034alter table bar drop column aa, drop column b;
1035source include/diff_tables.inc;
1036drop table foo; drop table bar;
1037
1038
1039create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1040create table bar like foo;
1041alter table bar engine=MyISAM;
1042insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1043insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1044insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1045insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1046insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1047insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1048insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1049insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1050insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1051insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1052insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1053insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1054insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1055insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1056insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1057insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1058insert into bar select * from foo;
1059source include/diff_tables.inc;
1060alter table foo drop column aa, drop column c;
1061alter table bar drop column aa, drop column c;
1062source include/diff_tables.inc;
1063drop table foo; drop table bar;
1064
1065
1066create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1067create table bar like foo;
1068alter table bar engine=MyISAM;
1069insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1070insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1071insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1072insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1073insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1074insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1075insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1076insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1077insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1078insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1079insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1080insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1081insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1082insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1083insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1084insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1085insert into bar select * from foo;
1086source include/diff_tables.inc;
1087alter table foo drop column aa, drop column d;
1088alter table bar drop column aa, drop column d;
1089source include/diff_tables.inc;
1090drop table foo; drop table bar;
1091
1092
1093create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1094create table bar like foo;
1095alter table bar engine=MyISAM;
1096insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1097insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1098insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1099insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1100insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1101insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1102insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1103insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1104insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1105insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1106insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1107insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1108insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1109insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1110insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1111insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1112insert into bar select * from foo;
1113source include/diff_tables.inc;
1114alter table foo drop column aa, drop column bb;
1115alter table bar drop column aa, drop column bb;
1116source include/diff_tables.inc;
1117drop table foo; drop table bar;
1118
1119
1120create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1121create table bar like foo;
1122alter table bar engine=MyISAM;
1123insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1124insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1125insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1126insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1127insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1128insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1129insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1130insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1131insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1132insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1133insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1134insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1135insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1136insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1137insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1138insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1139insert into bar select * from foo;
1140source include/diff_tables.inc;
1141alter table foo drop column aa, drop column cc;
1142alter table bar drop column aa, drop column cc;
1143source include/diff_tables.inc;
1144drop table foo; drop table bar;
1145
1146
1147create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1148create table bar like foo;
1149alter table bar engine=MyISAM;
1150insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1151insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1152insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1153insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1154insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1155insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1156insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1157insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1158insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1159insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1160insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1161insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1162insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1163insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1164insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1165insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1166insert into bar select * from foo;
1167source include/diff_tables.inc;
1168alter table foo drop column aa, drop column dd;
1169alter table bar drop column aa, drop column dd;
1170source include/diff_tables.inc;
1171drop table foo; drop table bar;
1172
1173
1174create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1175create table bar like foo;
1176alter table bar engine=MyISAM;
1177insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1178insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1179insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1180insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1181insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1182insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1183insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1184insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1185insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1186insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1187insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1188insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1189insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1190insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1191insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1192insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1193insert into bar select * from foo;
1194source include/diff_tables.inc;
1195alter table foo drop column bb, drop column a;
1196alter table bar drop column bb, drop column a;
1197source include/diff_tables.inc;
1198drop table foo; drop table bar;
1199
1200
1201create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1202create table bar like foo;
1203alter table bar engine=MyISAM;
1204insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1205insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1206insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1207insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1208insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1209insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1210insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1211insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1212insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1213insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1214insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1215insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1216insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1217insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1218insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1219insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1220insert into bar select * from foo;
1221source include/diff_tables.inc;
1222alter table foo drop column bb, drop column b;
1223alter table bar drop column bb, drop column b;
1224source include/diff_tables.inc;
1225drop table foo; drop table bar;
1226
1227
1228create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1229create table bar like foo;
1230alter table bar engine=MyISAM;
1231insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1232insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1233insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1234insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1235insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1236insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1237insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1238insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1239insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1240insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1241insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1242insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1243insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1244insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1245insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1246insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1247insert into bar select * from foo;
1248source include/diff_tables.inc;
1249alter table foo drop column bb, drop column c;
1250alter table bar drop column bb, drop column c;
1251source include/diff_tables.inc;
1252drop table foo; drop table bar;
1253
1254
1255create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1256create table bar like foo;
1257alter table bar engine=MyISAM;
1258insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1259insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1260insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1261insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1262insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1263insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1264insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1265insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1266insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1267insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1268insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1269insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1270insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1271insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1272insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1273insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1274insert into bar select * from foo;
1275source include/diff_tables.inc;
1276alter table foo drop column bb, drop column d;
1277alter table bar drop column bb, drop column d;
1278source include/diff_tables.inc;
1279drop table foo; drop table bar;
1280
1281
1282create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1283create table bar like foo;
1284alter table bar engine=MyISAM;
1285insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1286insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1287insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1288insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1289insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1290insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1291insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1292insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1293insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1294insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1295insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1296insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1297insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1298insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1299insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1300insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1301insert into bar select * from foo;
1302source include/diff_tables.inc;
1303alter table foo drop column bb, drop column aa;
1304alter table bar drop column bb, drop column aa;
1305source include/diff_tables.inc;
1306drop table foo; drop table bar;
1307
1308
1309create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1310create table bar like foo;
1311alter table bar engine=MyISAM;
1312insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1313insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1314insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1315insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1316insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1317insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1318insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1319insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1320insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1321insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1322insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1323insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1324insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1325insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1326insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1327insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1328insert into bar select * from foo;
1329source include/diff_tables.inc;
1330alter table foo drop column bb, drop column cc;
1331alter table bar drop column bb, drop column cc;
1332source include/diff_tables.inc;
1333drop table foo; drop table bar;
1334
1335
1336create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1337create table bar like foo;
1338alter table bar engine=MyISAM;
1339insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1340insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1341insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1342insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1343insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1344insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1345insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1346insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1347insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1348insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1349insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1350insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1351insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1352insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1353insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1354insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1355insert into bar select * from foo;
1356source include/diff_tables.inc;
1357alter table foo drop column bb, drop column dd;
1358alter table bar drop column bb, drop column dd;
1359source include/diff_tables.inc;
1360drop table foo; drop table bar;
1361
1362
1363create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1364create table bar like foo;
1365alter table bar engine=MyISAM;
1366insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1367insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1368insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1369insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1370insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1371insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1372insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1373insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1374insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1375insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1376insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1377insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1378insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1379insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1380insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1381insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1382insert into bar select * from foo;
1383source include/diff_tables.inc;
1384alter table foo drop column cc, drop column a;
1385alter table bar drop column cc, drop column a;
1386source include/diff_tables.inc;
1387drop table foo; drop table bar;
1388
1389
1390create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1391create table bar like foo;
1392alter table bar engine=MyISAM;
1393insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1394insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1395insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1396insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1397insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1398insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1399insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1400insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1401insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1402insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1403insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1404insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1405insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1406insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1407insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1408insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1409insert into bar select * from foo;
1410source include/diff_tables.inc;
1411alter table foo drop column cc, drop column b;
1412alter table bar drop column cc, drop column b;
1413source include/diff_tables.inc;
1414drop table foo; drop table bar;
1415
1416
1417create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1418create table bar like foo;
1419alter table bar engine=MyISAM;
1420insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1421insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1422insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1423insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1424insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1425insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1426insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1427insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1428insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1429insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1430insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1431insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1432insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1433insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1434insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1435insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1436insert into bar select * from foo;
1437source include/diff_tables.inc;
1438alter table foo drop column cc, drop column c;
1439alter table bar drop column cc, drop column c;
1440source include/diff_tables.inc;
1441drop table foo; drop table bar;
1442
1443
1444create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1445create table bar like foo;
1446alter table bar engine=MyISAM;
1447insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1448insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1449insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1450insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1451insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1452insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1453insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1454insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1455insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1456insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1457insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1458insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1459insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1460insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1461insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1462insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1463insert into bar select * from foo;
1464source include/diff_tables.inc;
1465alter table foo drop column cc, drop column d;
1466alter table bar drop column cc, drop column d;
1467source include/diff_tables.inc;
1468drop table foo; drop table bar;
1469
1470
1471create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1472create table bar like foo;
1473alter table bar engine=MyISAM;
1474insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1475insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1476insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1477insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1478insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1479insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1480insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1481insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1482insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1483insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1484insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1485insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1486insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1487insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1488insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1489insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1490insert into bar select * from foo;
1491source include/diff_tables.inc;
1492alter table foo drop column cc, drop column aa;
1493alter table bar drop column cc, drop column aa;
1494source include/diff_tables.inc;
1495drop table foo; drop table bar;
1496
1497
1498create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1499create table bar like foo;
1500alter table bar engine=MyISAM;
1501insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1502insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1503insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1504insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1505insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1506insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1507insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1508insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1509insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1510insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1511insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1512insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1513insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1514insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1515insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1516insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1517insert into bar select * from foo;
1518source include/diff_tables.inc;
1519alter table foo drop column cc, drop column bb;
1520alter table bar drop column cc, drop column bb;
1521source include/diff_tables.inc;
1522drop table foo; drop table bar;
1523
1524
1525create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1526create table bar like foo;
1527alter table bar engine=MyISAM;
1528insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1529insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1530insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1531insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1532insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1533insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1534insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1535insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1536insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1537insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1538insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1539insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1540insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1541insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1542insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1543insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1544insert into bar select * from foo;
1545source include/diff_tables.inc;
1546alter table foo drop column cc, drop column dd;
1547alter table bar drop column cc, drop column dd;
1548source include/diff_tables.inc;
1549drop table foo; drop table bar;
1550
1551
1552create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1553create table bar like foo;
1554alter table bar engine=MyISAM;
1555insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1556insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1557insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1558insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1559insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1560insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1561insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1562insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1563insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1564insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1565insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1566insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1567insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1568insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1569insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1570insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1571insert into bar select * from foo;
1572source include/diff_tables.inc;
1573alter table foo drop column dd, drop column a;
1574alter table bar drop column dd, drop column a;
1575source include/diff_tables.inc;
1576drop table foo; drop table bar;
1577
1578
1579create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1580create table bar like foo;
1581alter table bar engine=MyISAM;
1582insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1583insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1584insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1585insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1586insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1587insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1588insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1589insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1590insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1591insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1592insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1593insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1594insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1595insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1596insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1597insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1598insert into bar select * from foo;
1599source include/diff_tables.inc;
1600alter table foo drop column dd, drop column b;
1601alter table bar drop column dd, drop column b;
1602source include/diff_tables.inc;
1603drop table foo; drop table bar;
1604
1605
1606create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1607create table bar like foo;
1608alter table bar engine=MyISAM;
1609insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1610insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1611insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1612insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1613insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1614insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1615insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1616insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1617insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1618insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1619insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1620insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1621insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1622insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1623insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1624insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1625insert into bar select * from foo;
1626source include/diff_tables.inc;
1627alter table foo drop column dd, drop column c;
1628alter table bar drop column dd, drop column c;
1629source include/diff_tables.inc;
1630drop table foo; drop table bar;
1631
1632
1633create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1634create table bar like foo;
1635alter table bar engine=MyISAM;
1636insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1637insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1638insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1639insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1640insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1641insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1642insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1643insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1644insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1645insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1646insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1647insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1648insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1649insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1650insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1651insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1652insert into bar select * from foo;
1653source include/diff_tables.inc;
1654alter table foo drop column dd, drop column d;
1655alter table bar drop column dd, drop column d;
1656source include/diff_tables.inc;
1657drop table foo; drop table bar;
1658
1659
1660create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1661create table bar like foo;
1662alter table bar engine=MyISAM;
1663insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1664insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1665insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1666insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1667insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1668insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1669insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1670insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1671insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1672insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1673insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1674insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1675insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1676insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1677insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1678insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1679insert into bar select * from foo;
1680source include/diff_tables.inc;
1681alter table foo drop column dd, drop column aa;
1682alter table bar drop column dd, drop column aa;
1683source include/diff_tables.inc;
1684drop table foo; drop table bar;
1685
1686
1687create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1688create table bar like foo;
1689alter table bar engine=MyISAM;
1690insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1691insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1692insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1693insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1694insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1695insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1696insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1697insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1698insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1699insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1700insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1701insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1702insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1703insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1704insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1705insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1706insert into bar select * from foo;
1707source include/diff_tables.inc;
1708alter table foo drop column dd, drop column bb;
1709alter table bar drop column dd, drop column bb;
1710source include/diff_tables.inc;
1711drop table foo; drop table bar;
1712
1713
1714create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1715create table bar like foo;
1716alter table bar engine=MyISAM;
1717insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1718insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1719insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1720insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1721insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1722insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1723insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1724insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1725insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1726insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1727insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1728insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1729insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1730insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1731insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1732insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1733insert into bar select * from foo;
1734source include/diff_tables.inc;
1735alter table foo drop column dd, drop column cc;
1736alter table bar drop column dd, drop column cc;
1737source include/diff_tables.inc;
1738drop table foo; drop table bar;
1739
1740
1741create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1742create table bar like foo;
1743alter table bar engine=MyISAM;
1744insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1745insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1746insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1747insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1748insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1749insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1750insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1751insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1752insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1753insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1754insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1755insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1756insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1757insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1758insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1759insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1760insert into bar select * from foo;
1761source include/diff_tables.inc;
1762alter table foo drop column a, drop column b, drop column c;
1763alter table bar drop column a, drop column b, drop column c;
1764source include/diff_tables.inc;
1765drop table foo; drop table bar;
1766
1767
1768create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1769create table bar like foo;
1770alter table bar engine=MyISAM;
1771insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1772insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1773insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1774insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1775insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1776insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1777insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1778insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1779insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1780insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1781insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1782insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1783insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1784insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1785insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1786insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1787insert into bar select * from foo;
1788source include/diff_tables.inc;
1789alter table foo drop column a, drop column b, drop column d;
1790alter table bar drop column a, drop column b, drop column d;
1791source include/diff_tables.inc;
1792drop table foo; drop table bar;
1793
1794
1795create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1796create table bar like foo;
1797alter table bar engine=MyISAM;
1798insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1799insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1800insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1801insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1802insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1803insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1804insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1805insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1806insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1807insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1808insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1809insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1810insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1811insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1812insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1813insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1814insert into bar select * from foo;
1815source include/diff_tables.inc;
1816alter table foo drop column a, drop column c, drop column d;
1817alter table bar drop column a, drop column c, drop column d;
1818source include/diff_tables.inc;
1819drop table foo; drop table bar;
1820
1821
1822create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1823create table bar like foo;
1824alter table bar engine=MyISAM;
1825insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1826insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1827insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1828insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1829insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1830insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1831insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1832insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1833insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1834insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1835insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1836insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1837insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1838insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1839insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1840insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1841insert into bar select * from foo;
1842source include/diff_tables.inc;
1843alter table foo drop column b, drop column c, drop column d;
1844alter table bar drop column b, drop column c, drop column d;
1845source include/diff_tables.inc;
1846drop table foo; drop table bar;
1847
1848
1849create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1850create table bar like foo;
1851alter table bar engine=MyISAM;
1852insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1853insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1854insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1855insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1856insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1857insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1858insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1859insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1860insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1861insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1862insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1863insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1864insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1865insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1866insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1867insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1868insert into bar select * from foo;
1869source include/diff_tables.inc;
1870alter table foo drop column a, drop column b, drop column c, drop column d;
1871alter table bar drop column a, drop column b, drop column c, drop column d;
1872source include/diff_tables.inc;
1873drop table foo; drop table bar;
1874
1875
1876create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB;
1877create table bar like foo;
1878alter table bar engine=MyISAM;
1879insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1880insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL);
1881insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds");
1882insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew");
1883insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL);
1884insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL);
1885insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds");
1886insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew");
1887insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL);
1888insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL);
1889insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds");
1890insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew");
1891insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL);
1892insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL);
1893insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds");
1894insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew");
1895insert into bar select * from foo;
1896source include/diff_tables.inc;
1897alter table foo drop column aa, drop column bb, drop column cc, drop column dd;
1898alter table bar drop column aa, drop column bb, drop column cc, drop column dd;
1899source include/diff_tables.inc;
1900drop table foo; drop table bar;
1901