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) engine=TokuDB;
14create table bar like foo;
15alter table bar engine=MyISAM;
16insert into foo values (NULL,NULL,NULL,NULL);
17insert into foo values (-1,NULL,'2008-1-1',NULL);
18insert into foo values (NULL,12345678987,NULL,1);
19insert into foo values (2,20,'1999-11-11',0);
20insert into bar select * from foo;
21source include/diff_tables.inc;
22alter table foo add column added_1 bigint default NULL;
23alter table bar add column added_1 bigint default NULL;
24source include/diff_tables.inc;
25drop table foo; drop table bar;
26
27
28create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
29create table bar like foo;
30alter table bar engine=MyISAM;
31insert into foo values (NULL,NULL,NULL,NULL);
32insert into foo values (-1,NULL,'2008-1-1',NULL);
33insert into foo values (NULL,12345678987,NULL,1);
34insert into foo values (2,20,'1999-11-11',0);
35insert into bar select * from foo;
36source include/diff_tables.inc;
37alter table foo add column added_2 bigint default -1;
38alter table bar add column added_2 bigint default -1;
39source include/diff_tables.inc;
40drop table foo; drop table bar;
41
42
43create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
44create table bar like foo;
45alter table bar engine=MyISAM;
46insert into foo values (NULL,NULL,NULL,NULL);
47insert into foo values (-1,NULL,'2008-1-1',NULL);
48insert into foo values (NULL,12345678987,NULL,1);
49insert into foo values (2,20,'1999-11-11',0);
50insert into bar select * from foo;
51source include/diff_tables.inc;
52alter table foo add column added_3 bigint NOT NULL default -1;
53alter table bar add column added_3 bigint NOT NULL default -1;
54source include/diff_tables.inc;
55drop table foo; drop table bar;
56
57
58create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
59create table bar like foo;
60alter table bar engine=MyISAM;
61insert into foo values (NULL,NULL,NULL,NULL);
62insert into foo values (-1,NULL,'2008-1-1',NULL);
63insert into foo values (NULL,12345678987,NULL,1);
64insert into foo values (2,20,'1999-11-11',0);
65insert into bar select * from foo;
66source include/diff_tables.inc;
67alter table foo add column added_4 varchar(10) default NULL;
68alter table bar add column added_4 varchar(10) default NULL;
69source include/diff_tables.inc;
70drop table foo; drop table bar;
71
72
73create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
74create table bar like foo;
75alter table bar engine=MyISAM;
76insert into foo values (NULL,NULL,NULL,NULL);
77insert into foo values (-1,NULL,'2008-1-1',NULL);
78insert into foo values (NULL,12345678987,NULL,1);
79insert into foo values (2,20,'1999-11-11',0);
80insert into bar select * from foo;
81source include/diff_tables.inc;
82alter table foo add column added_5 varchar(10) default "qwerty";
83alter table bar add column added_5 varchar(10) default "qwerty";
84source include/diff_tables.inc;
85drop table foo; drop table bar;
86
87
88create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
89create table bar like foo;
90alter table bar engine=MyISAM;
91insert into foo values (NULL,NULL,NULL,NULL);
92insert into foo values (-1,NULL,'2008-1-1',NULL);
93insert into foo values (NULL,12345678987,NULL,1);
94insert into foo values (2,20,'1999-11-11',0);
95insert into bar select * from foo;
96source include/diff_tables.inc;
97alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt";
98alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt";
99source include/diff_tables.inc;
100drop table foo; drop table bar;
101
102
103create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
104create table bar like foo;
105alter table bar engine=MyISAM;
106insert into foo values (NULL,NULL,NULL,NULL);
107insert into foo values (-1,NULL,'2008-1-1',NULL);
108insert into foo values (NULL,12345678987,NULL,1);
109insert into foo values (2,20,'1999-11-11',0);
110insert into bar select * from foo;
111source include/diff_tables.inc;
112alter table foo add column added_7 text default NULL;
113alter table bar add column added_7 text default NULL;
114source include/diff_tables.inc;
115drop table foo; drop table bar;
116
117
118create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
119create table bar like foo;
120alter table bar engine=MyISAM;
121insert into foo values (NULL,NULL,NULL,NULL);
122insert into foo values (-1,NULL,'2008-1-1',NULL);
123insert into foo values (NULL,12345678987,NULL,1);
124insert into foo values (2,20,'1999-11-11',0);
125insert into bar select * from foo;
126source include/diff_tables.inc;
127alter table foo add column added_8 mediumtext default NULL;
128alter table bar add column added_8 mediumtext default NULL;
129source include/diff_tables.inc;
130drop table foo; drop table bar;
131
132
133create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
134create table bar like foo;
135alter table bar engine=MyISAM;
136insert into foo values (NULL,NULL,NULL,NULL);
137insert into foo values (-1,NULL,'2008-1-1',NULL);
138insert into foo values (NULL,12345678987,NULL,1);
139insert into foo values (2,20,'1999-11-11',0);
140insert into bar select * from foo;
141source include/diff_tables.inc;
142alter table foo add column added_1 bigint default NULL first;
143alter table bar add column added_1 bigint default NULL first;
144source include/diff_tables.inc;
145drop table foo; drop table bar;
146
147
148create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
149create table bar like foo;
150alter table bar engine=MyISAM;
151insert into foo values (NULL,NULL,NULL,NULL);
152insert into foo values (-1,NULL,'2008-1-1',NULL);
153insert into foo values (NULL,12345678987,NULL,1);
154insert into foo values (2,20,'1999-11-11',0);
155insert into bar select * from foo;
156source include/diff_tables.inc;
157alter table foo add column added_2 bigint default -1 first;
158alter table bar add column added_2 bigint default -1 first;
159source include/diff_tables.inc;
160drop table foo; drop table bar;
161
162
163create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
164create table bar like foo;
165alter table bar engine=MyISAM;
166insert into foo values (NULL,NULL,NULL,NULL);
167insert into foo values (-1,NULL,'2008-1-1',NULL);
168insert into foo values (NULL,12345678987,NULL,1);
169insert into foo values (2,20,'1999-11-11',0);
170insert into bar select * from foo;
171source include/diff_tables.inc;
172alter table foo add column added_3 bigint NOT NULL default -1 first;
173alter table bar add column added_3 bigint NOT NULL default -1 first;
174source include/diff_tables.inc;
175drop table foo; drop table bar;
176
177
178create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
179create table bar like foo;
180alter table bar engine=MyISAM;
181insert into foo values (NULL,NULL,NULL,NULL);
182insert into foo values (-1,NULL,'2008-1-1',NULL);
183insert into foo values (NULL,12345678987,NULL,1);
184insert into foo values (2,20,'1999-11-11',0);
185insert into bar select * from foo;
186source include/diff_tables.inc;
187alter table foo add column added_4 varchar(10) default NULL first;
188alter table bar add column added_4 varchar(10) default NULL first;
189source include/diff_tables.inc;
190drop table foo; drop table bar;
191
192
193create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
194create table bar like foo;
195alter table bar engine=MyISAM;
196insert into foo values (NULL,NULL,NULL,NULL);
197insert into foo values (-1,NULL,'2008-1-1',NULL);
198insert into foo values (NULL,12345678987,NULL,1);
199insert into foo values (2,20,'1999-11-11',0);
200insert into bar select * from foo;
201source include/diff_tables.inc;
202alter table foo add column added_5 varchar(10) default "qwerty" first;
203alter table bar add column added_5 varchar(10) default "qwerty" first;
204source include/diff_tables.inc;
205drop table foo; drop table bar;
206
207
208create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
209create table bar like foo;
210alter table bar engine=MyISAM;
211insert into foo values (NULL,NULL,NULL,NULL);
212insert into foo values (-1,NULL,'2008-1-1',NULL);
213insert into foo values (NULL,12345678987,NULL,1);
214insert into foo values (2,20,'1999-11-11',0);
215insert into bar select * from foo;
216source include/diff_tables.inc;
217alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first;
218alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first;
219source include/diff_tables.inc;
220drop table foo; drop table bar;
221
222
223create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
224create table bar like foo;
225alter table bar engine=MyISAM;
226insert into foo values (NULL,NULL,NULL,NULL);
227insert into foo values (-1,NULL,'2008-1-1',NULL);
228insert into foo values (NULL,12345678987,NULL,1);
229insert into foo values (2,20,'1999-11-11',0);
230insert into bar select * from foo;
231source include/diff_tables.inc;
232alter table foo add column added_7 text default NULL first;
233alter table bar add column added_7 text default NULL first;
234source include/diff_tables.inc;
235drop table foo; drop table bar;
236
237
238create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
239create table bar like foo;
240alter table bar engine=MyISAM;
241insert into foo values (NULL,NULL,NULL,NULL);
242insert into foo values (-1,NULL,'2008-1-1',NULL);
243insert into foo values (NULL,12345678987,NULL,1);
244insert into foo values (2,20,'1999-11-11',0);
245insert into bar select * from foo;
246source include/diff_tables.inc;
247alter table foo add column added_8 mediumtext default NULL first;
248alter table bar add column added_8 mediumtext default NULL first;
249source include/diff_tables.inc;
250drop table foo; drop table bar;
251
252
253create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
254create table bar like foo;
255alter table bar engine=MyISAM;
256insert into foo values (NULL,NULL,NULL,NULL);
257insert into foo values (-1,NULL,'2008-1-1',NULL);
258insert into foo values (NULL,12345678987,NULL,1);
259insert into foo values (2,20,'1999-11-11',0);
260insert into bar select * from foo;
261source include/diff_tables.inc;
262alter table foo add column added_1 bigint default NULL after b;
263alter table bar add column added_1 bigint default NULL after b;
264source include/diff_tables.inc;
265drop table foo; drop table bar;
266
267
268create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
269create table bar like foo;
270alter table bar engine=MyISAM;
271insert into foo values (NULL,NULL,NULL,NULL);
272insert into foo values (-1,NULL,'2008-1-1',NULL);
273insert into foo values (NULL,12345678987,NULL,1);
274insert into foo values (2,20,'1999-11-11',0);
275insert into bar select * from foo;
276source include/diff_tables.inc;
277alter table foo add column added_2 bigint default -1 after b;
278alter table bar add column added_2 bigint default -1 after b;
279source include/diff_tables.inc;
280drop table foo; drop table bar;
281
282
283create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
284create table bar like foo;
285alter table bar engine=MyISAM;
286insert into foo values (NULL,NULL,NULL,NULL);
287insert into foo values (-1,NULL,'2008-1-1',NULL);
288insert into foo values (NULL,12345678987,NULL,1);
289insert into foo values (2,20,'1999-11-11',0);
290insert into bar select * from foo;
291source include/diff_tables.inc;
292alter table foo add column added_3 bigint NOT NULL default -1 after b;
293alter table bar add column added_3 bigint NOT NULL default -1 after b;
294source include/diff_tables.inc;
295drop table foo; drop table bar;
296
297
298create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
299create table bar like foo;
300alter table bar engine=MyISAM;
301insert into foo values (NULL,NULL,NULL,NULL);
302insert into foo values (-1,NULL,'2008-1-1',NULL);
303insert into foo values (NULL,12345678987,NULL,1);
304insert into foo values (2,20,'1999-11-11',0);
305insert into bar select * from foo;
306source include/diff_tables.inc;
307alter table foo add column added_4 varchar(10) default NULL after b;
308alter table bar add column added_4 varchar(10) default NULL after b;
309source include/diff_tables.inc;
310drop table foo; drop table bar;
311
312
313create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
314create table bar like foo;
315alter table bar engine=MyISAM;
316insert into foo values (NULL,NULL,NULL,NULL);
317insert into foo values (-1,NULL,'2008-1-1',NULL);
318insert into foo values (NULL,12345678987,NULL,1);
319insert into foo values (2,20,'1999-11-11',0);
320insert into bar select * from foo;
321source include/diff_tables.inc;
322alter table foo add column added_5 varchar(10) default "qwerty" after b;
323alter table bar add column added_5 varchar(10) default "qwerty" after b;
324source include/diff_tables.inc;
325drop table foo; drop table bar;
326
327
328create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
329create table bar like foo;
330alter table bar engine=MyISAM;
331insert into foo values (NULL,NULL,NULL,NULL);
332insert into foo values (-1,NULL,'2008-1-1',NULL);
333insert into foo values (NULL,12345678987,NULL,1);
334insert into foo values (2,20,'1999-11-11',0);
335insert into bar select * from foo;
336source include/diff_tables.inc;
337alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b;
338alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b;
339source include/diff_tables.inc;
340drop table foo; drop table bar;
341
342
343create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
344create table bar like foo;
345alter table bar engine=MyISAM;
346insert into foo values (NULL,NULL,NULL,NULL);
347insert into foo values (-1,NULL,'2008-1-1',NULL);
348insert into foo values (NULL,12345678987,NULL,1);
349insert into foo values (2,20,'1999-11-11',0);
350insert into bar select * from foo;
351source include/diff_tables.inc;
352alter table foo add column added_7 text default NULL after b;
353alter table bar add column added_7 text default NULL after b;
354source include/diff_tables.inc;
355drop table foo; drop table bar;
356
357
358create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
359create table bar like foo;
360alter table bar engine=MyISAM;
361insert into foo values (NULL,NULL,NULL,NULL);
362insert into foo values (-1,NULL,'2008-1-1',NULL);
363insert into foo values (NULL,12345678987,NULL,1);
364insert into foo values (2,20,'1999-11-11',0);
365insert into bar select * from foo;
366source include/diff_tables.inc;
367alter table foo add column added_8 mediumtext default NULL after b;
368alter table bar add column added_8 mediumtext default NULL after b;
369source include/diff_tables.inc;
370drop table foo; drop table bar;
371
372
373create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
374create table bar like foo;
375alter table bar engine=MyISAM;
376insert into foo values (NULL,NULL,NULL,NULL);
377insert into foo values (-1,NULL,'2008-1-1',NULL);
378insert into foo values (NULL,12345678987,NULL,1);
379insert into foo values (2,20,'1999-11-11',0);
380insert into bar select * from foo;
381source include/diff_tables.inc;
382alter table foo add column added_1 bigint default NULL, add column added_11 bigint default NULL;
383alter table bar add column added_1 bigint default NULL, add column added_11 bigint default NULL;
384source include/diff_tables.inc;
385drop table foo; drop table bar;
386
387
388create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
389create table bar like foo;
390alter table bar engine=MyISAM;
391insert into foo values (NULL,NULL,NULL,NULL);
392insert into foo values (-1,NULL,'2008-1-1',NULL);
393insert into foo values (NULL,12345678987,NULL,1);
394insert into foo values (2,20,'1999-11-11',0);
395insert into bar select * from foo;
396source include/diff_tables.inc;
397alter table foo add column added_1 bigint default NULL, add column added_21 bigint default 1234;
398alter table bar add column added_1 bigint default NULL, add column added_21 bigint default 1234;
399source include/diff_tables.inc;
400drop table foo; drop table bar;
401
402
403create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
404create table bar like foo;
405alter table bar engine=MyISAM;
406insert into foo values (NULL,NULL,NULL,NULL);
407insert into foo values (-1,NULL,'2008-1-1',NULL);
408insert into foo values (NULL,12345678987,NULL,1);
409insert into foo values (2,20,'1999-11-11',0);
410insert into bar select * from foo;
411source include/diff_tables.inc;
412alter table foo add column added_1 bigint default NULL, add column added_31 bigint NOT NULL default 54;
413alter table bar add column added_1 bigint default NULL, add column added_31 bigint NOT NULL default 54;
414source include/diff_tables.inc;
415drop table foo; drop table bar;
416
417
418create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
419create table bar like foo;
420alter table bar engine=MyISAM;
421insert into foo values (NULL,NULL,NULL,NULL);
422insert into foo values (-1,NULL,'2008-1-1',NULL);
423insert into foo values (NULL,12345678987,NULL,1);
424insert into foo values (2,20,'1999-11-11',0);
425insert into bar select * from foo;
426source include/diff_tables.inc;
427alter table foo add column added_1 bigint default NULL, add column added_41 varchar(10) default NULL;
428alter table bar add column added_1 bigint default NULL, add column added_41 varchar(10) default NULL;
429source include/diff_tables.inc;
430drop table foo; drop table bar;
431
432
433create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
434create table bar like foo;
435alter table bar engine=MyISAM;
436insert into foo values (NULL,NULL,NULL,NULL);
437insert into foo values (-1,NULL,'2008-1-1',NULL);
438insert into foo values (NULL,12345678987,NULL,1);
439insert into foo values (2,20,'1999-11-11',0);
440insert into bar select * from foo;
441source include/diff_tables.inc;
442alter table foo add column added_1 bigint default NULL, add column added_51 varchar(10) default "abracadab";
443alter table bar add column added_1 bigint default NULL, add column added_51 varchar(10) default "abracadab";
444source include/diff_tables.inc;
445drop table foo; drop table bar;
446
447
448create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
449create table bar like foo;
450alter table bar engine=MyISAM;
451insert into foo values (NULL,NULL,NULL,NULL);
452insert into foo values (-1,NULL,'2008-1-1',NULL);
453insert into foo values (NULL,12345678987,NULL,1);
454insert into foo values (2,20,'1999-11-11',0);
455insert into bar select * from foo;
456source include/diff_tables.inc;
457alter table foo add column added_1 bigint default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
458alter table bar add column added_1 bigint default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
459source include/diff_tables.inc;
460drop table foo; drop table bar;
461
462
463create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
464create table bar like foo;
465alter table bar engine=MyISAM;
466insert into foo values (NULL,NULL,NULL,NULL);
467insert into foo values (-1,NULL,'2008-1-1',NULL);
468insert into foo values (NULL,12345678987,NULL,1);
469insert into foo values (2,20,'1999-11-11',0);
470insert into bar select * from foo;
471source include/diff_tables.inc;
472alter table foo add column added_1 bigint default NULL, add column added_71 text default NULL;
473alter table bar add column added_1 bigint default NULL, add column added_71 text default NULL;
474source include/diff_tables.inc;
475drop table foo; drop table bar;
476
477
478create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
479create table bar like foo;
480alter table bar engine=MyISAM;
481insert into foo values (NULL,NULL,NULL,NULL);
482insert into foo values (-1,NULL,'2008-1-1',NULL);
483insert into foo values (NULL,12345678987,NULL,1);
484insert into foo values (2,20,'1999-11-11',0);
485insert into bar select * from foo;
486source include/diff_tables.inc;
487alter table foo add column added_1 bigint default NULL, add column added_81 mediumtext default NULL;
488alter table bar add column added_1 bigint default NULL, add column added_81 mediumtext default NULL;
489source include/diff_tables.inc;
490drop table foo; drop table bar;
491
492
493create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
494create table bar like foo;
495alter table bar engine=MyISAM;
496insert into foo values (NULL,NULL,NULL,NULL);
497insert into foo values (-1,NULL,'2008-1-1',NULL);
498insert into foo values (NULL,12345678987,NULL,1);
499insert into foo values (2,20,'1999-11-11',0);
500insert into bar select * from foo;
501source include/diff_tables.inc;
502alter table foo add column added_2 bigint default -1, add column added_11 bigint default NULL;
503alter table bar add column added_2 bigint default -1, add column added_11 bigint default NULL;
504source include/diff_tables.inc;
505drop table foo; drop table bar;
506
507
508create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
509create table bar like foo;
510alter table bar engine=MyISAM;
511insert into foo values (NULL,NULL,NULL,NULL);
512insert into foo values (-1,NULL,'2008-1-1',NULL);
513insert into foo values (NULL,12345678987,NULL,1);
514insert into foo values (2,20,'1999-11-11',0);
515insert into bar select * from foo;
516source include/diff_tables.inc;
517alter table foo add column added_2 bigint default -1, add column added_21 bigint default 1234;
518alter table bar add column added_2 bigint default -1, add column added_21 bigint default 1234;
519source include/diff_tables.inc;
520drop table foo; drop table bar;
521
522
523create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
524create table bar like foo;
525alter table bar engine=MyISAM;
526insert into foo values (NULL,NULL,NULL,NULL);
527insert into foo values (-1,NULL,'2008-1-1',NULL);
528insert into foo values (NULL,12345678987,NULL,1);
529insert into foo values (2,20,'1999-11-11',0);
530insert into bar select * from foo;
531source include/diff_tables.inc;
532alter table foo add column added_2 bigint default -1, add column added_31 bigint NOT NULL default 54;
533alter table bar add column added_2 bigint default -1, add column added_31 bigint NOT NULL default 54;
534source include/diff_tables.inc;
535drop table foo; drop table bar;
536
537
538create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
539create table bar like foo;
540alter table bar engine=MyISAM;
541insert into foo values (NULL,NULL,NULL,NULL);
542insert into foo values (-1,NULL,'2008-1-1',NULL);
543insert into foo values (NULL,12345678987,NULL,1);
544insert into foo values (2,20,'1999-11-11',0);
545insert into bar select * from foo;
546source include/diff_tables.inc;
547alter table foo add column added_2 bigint default -1, add column added_41 varchar(10) default NULL;
548alter table bar add column added_2 bigint default -1, add column added_41 varchar(10) default NULL;
549source include/diff_tables.inc;
550drop table foo; drop table bar;
551
552
553create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
554create table bar like foo;
555alter table bar engine=MyISAM;
556insert into foo values (NULL,NULL,NULL,NULL);
557insert into foo values (-1,NULL,'2008-1-1',NULL);
558insert into foo values (NULL,12345678987,NULL,1);
559insert into foo values (2,20,'1999-11-11',0);
560insert into bar select * from foo;
561source include/diff_tables.inc;
562alter table foo add column added_2 bigint default -1, add column added_51 varchar(10) default "abracadab";
563alter table bar add column added_2 bigint default -1, add column added_51 varchar(10) default "abracadab";
564source include/diff_tables.inc;
565drop table foo; drop table bar;
566
567
568create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
569create table bar like foo;
570alter table bar engine=MyISAM;
571insert into foo values (NULL,NULL,NULL,NULL);
572insert into foo values (-1,NULL,'2008-1-1',NULL);
573insert into foo values (NULL,12345678987,NULL,1);
574insert into foo values (2,20,'1999-11-11',0);
575insert into bar select * from foo;
576source include/diff_tables.inc;
577alter table foo add column added_2 bigint default -1, add column added_61 varchar(10) NOT NULL default "abracadab";
578alter table bar add column added_2 bigint default -1, add column added_61 varchar(10) NOT NULL default "abracadab";
579source include/diff_tables.inc;
580drop table foo; drop table bar;
581
582
583create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
584create table bar like foo;
585alter table bar engine=MyISAM;
586insert into foo values (NULL,NULL,NULL,NULL);
587insert into foo values (-1,NULL,'2008-1-1',NULL);
588insert into foo values (NULL,12345678987,NULL,1);
589insert into foo values (2,20,'1999-11-11',0);
590insert into bar select * from foo;
591source include/diff_tables.inc;
592alter table foo add column added_2 bigint default -1, add column added_71 text default NULL;
593alter table bar add column added_2 bigint default -1, add column added_71 text default NULL;
594source include/diff_tables.inc;
595drop table foo; drop table bar;
596
597
598create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
599create table bar like foo;
600alter table bar engine=MyISAM;
601insert into foo values (NULL,NULL,NULL,NULL);
602insert into foo values (-1,NULL,'2008-1-1',NULL);
603insert into foo values (NULL,12345678987,NULL,1);
604insert into foo values (2,20,'1999-11-11',0);
605insert into bar select * from foo;
606source include/diff_tables.inc;
607alter table foo add column added_2 bigint default -1, add column added_81 mediumtext default NULL;
608alter table bar add column added_2 bigint default -1, add column added_81 mediumtext default NULL;
609source include/diff_tables.inc;
610drop table foo; drop table bar;
611
612
613create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
614create table bar like foo;
615alter table bar engine=MyISAM;
616insert into foo values (NULL,NULL,NULL,NULL);
617insert into foo values (-1,NULL,'2008-1-1',NULL);
618insert into foo values (NULL,12345678987,NULL,1);
619insert into foo values (2,20,'1999-11-11',0);
620insert into bar select * from foo;
621source include/diff_tables.inc;
622alter table foo add column added_3 bigint NOT NULL default -1, add column added_11 bigint default NULL;
623alter table bar add column added_3 bigint NOT NULL default -1, add column added_11 bigint default NULL;
624source include/diff_tables.inc;
625drop table foo; drop table bar;
626
627
628create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
629create table bar like foo;
630alter table bar engine=MyISAM;
631insert into foo values (NULL,NULL,NULL,NULL);
632insert into foo values (-1,NULL,'2008-1-1',NULL);
633insert into foo values (NULL,12345678987,NULL,1);
634insert into foo values (2,20,'1999-11-11',0);
635insert into bar select * from foo;
636source include/diff_tables.inc;
637alter table foo add column added_3 bigint NOT NULL default -1, add column added_21 bigint default 1234;
638alter table bar add column added_3 bigint NOT NULL default -1, add column added_21 bigint default 1234;
639source include/diff_tables.inc;
640drop table foo; drop table bar;
641
642
643create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
644create table bar like foo;
645alter table bar engine=MyISAM;
646insert into foo values (NULL,NULL,NULL,NULL);
647insert into foo values (-1,NULL,'2008-1-1',NULL);
648insert into foo values (NULL,12345678987,NULL,1);
649insert into foo values (2,20,'1999-11-11',0);
650insert into bar select * from foo;
651source include/diff_tables.inc;
652alter table foo add column added_3 bigint NOT NULL default -1, add column added_31 bigint NOT NULL default 54;
653alter table bar add column added_3 bigint NOT NULL default -1, add column added_31 bigint NOT NULL default 54;
654source include/diff_tables.inc;
655drop table foo; drop table bar;
656
657
658create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
659create table bar like foo;
660alter table bar engine=MyISAM;
661insert into foo values (NULL,NULL,NULL,NULL);
662insert into foo values (-1,NULL,'2008-1-1',NULL);
663insert into foo values (NULL,12345678987,NULL,1);
664insert into foo values (2,20,'1999-11-11',0);
665insert into bar select * from foo;
666source include/diff_tables.inc;
667alter table foo add column added_3 bigint NOT NULL default -1, add column added_41 varchar(10) default NULL;
668alter table bar add column added_3 bigint NOT NULL default -1, add column added_41 varchar(10) default NULL;
669source include/diff_tables.inc;
670drop table foo; drop table bar;
671
672
673create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
674create table bar like foo;
675alter table bar engine=MyISAM;
676insert into foo values (NULL,NULL,NULL,NULL);
677insert into foo values (-1,NULL,'2008-1-1',NULL);
678insert into foo values (NULL,12345678987,NULL,1);
679insert into foo values (2,20,'1999-11-11',0);
680insert into bar select * from foo;
681source include/diff_tables.inc;
682alter table foo add column added_3 bigint NOT NULL default -1, add column added_51 varchar(10) default "abracadab";
683alter table bar add column added_3 bigint NOT NULL default -1, add column added_51 varchar(10) default "abracadab";
684source include/diff_tables.inc;
685drop table foo; drop table bar;
686
687
688create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
689create table bar like foo;
690alter table bar engine=MyISAM;
691insert into foo values (NULL,NULL,NULL,NULL);
692insert into foo values (-1,NULL,'2008-1-1',NULL);
693insert into foo values (NULL,12345678987,NULL,1);
694insert into foo values (2,20,'1999-11-11',0);
695insert into bar select * from foo;
696source include/diff_tables.inc;
697alter table foo add column added_3 bigint NOT NULL default -1, add column added_61 varchar(10) NOT NULL default "abracadab";
698alter table bar add column added_3 bigint NOT NULL default -1, add column added_61 varchar(10) NOT NULL default "abracadab";
699source include/diff_tables.inc;
700drop table foo; drop table bar;
701
702
703create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
704create table bar like foo;
705alter table bar engine=MyISAM;
706insert into foo values (NULL,NULL,NULL,NULL);
707insert into foo values (-1,NULL,'2008-1-1',NULL);
708insert into foo values (NULL,12345678987,NULL,1);
709insert into foo values (2,20,'1999-11-11',0);
710insert into bar select * from foo;
711source include/diff_tables.inc;
712alter table foo add column added_3 bigint NOT NULL default -1, add column added_71 text default NULL;
713alter table bar add column added_3 bigint NOT NULL default -1, add column added_71 text default NULL;
714source include/diff_tables.inc;
715drop table foo; drop table bar;
716
717
718create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
719create table bar like foo;
720alter table bar engine=MyISAM;
721insert into foo values (NULL,NULL,NULL,NULL);
722insert into foo values (-1,NULL,'2008-1-1',NULL);
723insert into foo values (NULL,12345678987,NULL,1);
724insert into foo values (2,20,'1999-11-11',0);
725insert into bar select * from foo;
726source include/diff_tables.inc;
727alter table foo add column added_3 bigint NOT NULL default -1, add column added_81 mediumtext default NULL;
728alter table bar add column added_3 bigint NOT NULL default -1, add column added_81 mediumtext default NULL;
729source include/diff_tables.inc;
730drop table foo; drop table bar;
731
732
733create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
734create table bar like foo;
735alter table bar engine=MyISAM;
736insert into foo values (NULL,NULL,NULL,NULL);
737insert into foo values (-1,NULL,'2008-1-1',NULL);
738insert into foo values (NULL,12345678987,NULL,1);
739insert into foo values (2,20,'1999-11-11',0);
740insert into bar select * from foo;
741source include/diff_tables.inc;
742alter table foo add column added_4 varchar(10) default NULL, add column added_11 bigint default NULL;
743alter table bar add column added_4 varchar(10) default NULL, add column added_11 bigint default NULL;
744source include/diff_tables.inc;
745drop table foo; drop table bar;
746
747
748create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
749create table bar like foo;
750alter table bar engine=MyISAM;
751insert into foo values (NULL,NULL,NULL,NULL);
752insert into foo values (-1,NULL,'2008-1-1',NULL);
753insert into foo values (NULL,12345678987,NULL,1);
754insert into foo values (2,20,'1999-11-11',0);
755insert into bar select * from foo;
756source include/diff_tables.inc;
757alter table foo add column added_4 varchar(10) default NULL, add column added_21 bigint default 1234;
758alter table bar add column added_4 varchar(10) default NULL, add column added_21 bigint default 1234;
759source include/diff_tables.inc;
760drop table foo; drop table bar;
761
762
763create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
764create table bar like foo;
765alter table bar engine=MyISAM;
766insert into foo values (NULL,NULL,NULL,NULL);
767insert into foo values (-1,NULL,'2008-1-1',NULL);
768insert into foo values (NULL,12345678987,NULL,1);
769insert into foo values (2,20,'1999-11-11',0);
770insert into bar select * from foo;
771source include/diff_tables.inc;
772alter table foo add column added_4 varchar(10) default NULL, add column added_31 bigint NOT NULL default 54;
773alter table bar add column added_4 varchar(10) default NULL, add column added_31 bigint NOT NULL default 54;
774source include/diff_tables.inc;
775drop table foo; drop table bar;
776
777
778create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
779create table bar like foo;
780alter table bar engine=MyISAM;
781insert into foo values (NULL,NULL,NULL,NULL);
782insert into foo values (-1,NULL,'2008-1-1',NULL);
783insert into foo values (NULL,12345678987,NULL,1);
784insert into foo values (2,20,'1999-11-11',0);
785insert into bar select * from foo;
786source include/diff_tables.inc;
787alter table foo add column added_4 varchar(10) default NULL, add column added_41 varchar(10) default NULL;
788alter table bar add column added_4 varchar(10) default NULL, add column added_41 varchar(10) default NULL;
789source include/diff_tables.inc;
790drop table foo; drop table bar;
791
792
793create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
794create table bar like foo;
795alter table bar engine=MyISAM;
796insert into foo values (NULL,NULL,NULL,NULL);
797insert into foo values (-1,NULL,'2008-1-1',NULL);
798insert into foo values (NULL,12345678987,NULL,1);
799insert into foo values (2,20,'1999-11-11',0);
800insert into bar select * from foo;
801source include/diff_tables.inc;
802alter table foo add column added_4 varchar(10) default NULL, add column added_51 varchar(10) default "abracadab";
803alter table bar add column added_4 varchar(10) default NULL, add column added_51 varchar(10) default "abracadab";
804source include/diff_tables.inc;
805drop table foo; drop table bar;
806
807
808create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
809create table bar like foo;
810alter table bar engine=MyISAM;
811insert into foo values (NULL,NULL,NULL,NULL);
812insert into foo values (-1,NULL,'2008-1-1',NULL);
813insert into foo values (NULL,12345678987,NULL,1);
814insert into foo values (2,20,'1999-11-11',0);
815insert into bar select * from foo;
816source include/diff_tables.inc;
817alter table foo add column added_4 varchar(10) default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
818alter table bar add column added_4 varchar(10) default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
819source include/diff_tables.inc;
820drop table foo; drop table bar;
821
822
823create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
824create table bar like foo;
825alter table bar engine=MyISAM;
826insert into foo values (NULL,NULL,NULL,NULL);
827insert into foo values (-1,NULL,'2008-1-1',NULL);
828insert into foo values (NULL,12345678987,NULL,1);
829insert into foo values (2,20,'1999-11-11',0);
830insert into bar select * from foo;
831source include/diff_tables.inc;
832alter table foo add column added_4 varchar(10) default NULL, add column added_71 text default NULL;
833alter table bar add column added_4 varchar(10) default NULL, add column added_71 text default NULL;
834source include/diff_tables.inc;
835drop table foo; drop table bar;
836
837
838create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
839create table bar like foo;
840alter table bar engine=MyISAM;
841insert into foo values (NULL,NULL,NULL,NULL);
842insert into foo values (-1,NULL,'2008-1-1',NULL);
843insert into foo values (NULL,12345678987,NULL,1);
844insert into foo values (2,20,'1999-11-11',0);
845insert into bar select * from foo;
846source include/diff_tables.inc;
847alter table foo add column added_4 varchar(10) default NULL, add column added_81 mediumtext default NULL;
848alter table bar add column added_4 varchar(10) default NULL, add column added_81 mediumtext default NULL;
849source include/diff_tables.inc;
850drop table foo; drop table bar;
851
852
853create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
854create table bar like foo;
855alter table bar engine=MyISAM;
856insert into foo values (NULL,NULL,NULL,NULL);
857insert into foo values (-1,NULL,'2008-1-1',NULL);
858insert into foo values (NULL,12345678987,NULL,1);
859insert into foo values (2,20,'1999-11-11',0);
860insert into bar select * from foo;
861source include/diff_tables.inc;
862alter table foo add column added_5 varchar(10) default "qwerty", add column added_11 bigint default NULL;
863alter table bar add column added_5 varchar(10) default "qwerty", add column added_11 bigint default NULL;
864source include/diff_tables.inc;
865drop table foo; drop table bar;
866
867
868create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
869create table bar like foo;
870alter table bar engine=MyISAM;
871insert into foo values (NULL,NULL,NULL,NULL);
872insert into foo values (-1,NULL,'2008-1-1',NULL);
873insert into foo values (NULL,12345678987,NULL,1);
874insert into foo values (2,20,'1999-11-11',0);
875insert into bar select * from foo;
876source include/diff_tables.inc;
877alter table foo add column added_5 varchar(10) default "qwerty", add column added_21 bigint default 1234;
878alter table bar add column added_5 varchar(10) default "qwerty", add column added_21 bigint default 1234;
879source include/diff_tables.inc;
880drop table foo; drop table bar;
881
882
883create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
884create table bar like foo;
885alter table bar engine=MyISAM;
886insert into foo values (NULL,NULL,NULL,NULL);
887insert into foo values (-1,NULL,'2008-1-1',NULL);
888insert into foo values (NULL,12345678987,NULL,1);
889insert into foo values (2,20,'1999-11-11',0);
890insert into bar select * from foo;
891source include/diff_tables.inc;
892alter table foo add column added_5 varchar(10) default "qwerty", add column added_31 bigint NOT NULL default 54;
893alter table bar add column added_5 varchar(10) default "qwerty", add column added_31 bigint NOT NULL default 54;
894source include/diff_tables.inc;
895drop table foo; drop table bar;
896
897
898create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
899create table bar like foo;
900alter table bar engine=MyISAM;
901insert into foo values (NULL,NULL,NULL,NULL);
902insert into foo values (-1,NULL,'2008-1-1',NULL);
903insert into foo values (NULL,12345678987,NULL,1);
904insert into foo values (2,20,'1999-11-11',0);
905insert into bar select * from foo;
906source include/diff_tables.inc;
907alter table foo add column added_5 varchar(10) default "qwerty", add column added_41 varchar(10) default NULL;
908alter table bar add column added_5 varchar(10) default "qwerty", add column added_41 varchar(10) default NULL;
909source include/diff_tables.inc;
910drop table foo; drop table bar;
911
912
913create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
914create table bar like foo;
915alter table bar engine=MyISAM;
916insert into foo values (NULL,NULL,NULL,NULL);
917insert into foo values (-1,NULL,'2008-1-1',NULL);
918insert into foo values (NULL,12345678987,NULL,1);
919insert into foo values (2,20,'1999-11-11',0);
920insert into bar select * from foo;
921source include/diff_tables.inc;
922alter table foo add column added_5 varchar(10) default "qwerty", add column added_51 varchar(10) default "abracadab";
923alter table bar add column added_5 varchar(10) default "qwerty", add column added_51 varchar(10) default "abracadab";
924source include/diff_tables.inc;
925drop table foo; drop table bar;
926
927
928create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
929create table bar like foo;
930alter table bar engine=MyISAM;
931insert into foo values (NULL,NULL,NULL,NULL);
932insert into foo values (-1,NULL,'2008-1-1',NULL);
933insert into foo values (NULL,12345678987,NULL,1);
934insert into foo values (2,20,'1999-11-11',0);
935insert into bar select * from foo;
936source include/diff_tables.inc;
937alter table foo add column added_5 varchar(10) default "qwerty", add column added_61 varchar(10) NOT NULL default "abracadab";
938alter table bar add column added_5 varchar(10) default "qwerty", add column added_61 varchar(10) NOT NULL default "abracadab";
939source include/diff_tables.inc;
940drop table foo; drop table bar;
941
942
943create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
944create table bar like foo;
945alter table bar engine=MyISAM;
946insert into foo values (NULL,NULL,NULL,NULL);
947insert into foo values (-1,NULL,'2008-1-1',NULL);
948insert into foo values (NULL,12345678987,NULL,1);
949insert into foo values (2,20,'1999-11-11',0);
950insert into bar select * from foo;
951source include/diff_tables.inc;
952alter table foo add column added_5 varchar(10) default "qwerty", add column added_71 text default NULL;
953alter table bar add column added_5 varchar(10) default "qwerty", add column added_71 text default NULL;
954source include/diff_tables.inc;
955drop table foo; drop table bar;
956
957
958create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
959create table bar like foo;
960alter table bar engine=MyISAM;
961insert into foo values (NULL,NULL,NULL,NULL);
962insert into foo values (-1,NULL,'2008-1-1',NULL);
963insert into foo values (NULL,12345678987,NULL,1);
964insert into foo values (2,20,'1999-11-11',0);
965insert into bar select * from foo;
966source include/diff_tables.inc;
967alter table foo add column added_5 varchar(10) default "qwerty", add column added_81 mediumtext default NULL;
968alter table bar add column added_5 varchar(10) default "qwerty", add column added_81 mediumtext default NULL;
969source include/diff_tables.inc;
970drop table foo; drop table bar;
971
972
973create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
974create table bar like foo;
975alter table bar engine=MyISAM;
976insert into foo values (NULL,NULL,NULL,NULL);
977insert into foo values (-1,NULL,'2008-1-1',NULL);
978insert into foo values (NULL,12345678987,NULL,1);
979insert into foo values (2,20,'1999-11-11',0);
980insert into bar select * from foo;
981source include/diff_tables.inc;
982alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_11 bigint default NULL;
983alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_11 bigint default NULL;
984source include/diff_tables.inc;
985drop table foo; drop table bar;
986
987
988create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
989create table bar like foo;
990alter table bar engine=MyISAM;
991insert into foo values (NULL,NULL,NULL,NULL);
992insert into foo values (-1,NULL,'2008-1-1',NULL);
993insert into foo values (NULL,12345678987,NULL,1);
994insert into foo values (2,20,'1999-11-11',0);
995insert into bar select * from foo;
996source include/diff_tables.inc;
997alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_21 bigint default 1234;
998alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_21 bigint default 1234;
999source include/diff_tables.inc;
1000drop table foo; drop table bar;
1001
1002
1003create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1004create table bar like foo;
1005alter table bar engine=MyISAM;
1006insert into foo values (NULL,NULL,NULL,NULL);
1007insert into foo values (-1,NULL,'2008-1-1',NULL);
1008insert into foo values (NULL,12345678987,NULL,1);
1009insert into foo values (2,20,'1999-11-11',0);
1010insert into bar select * from foo;
1011source include/diff_tables.inc;
1012alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_31 bigint NOT NULL default 54;
1013alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_31 bigint NOT NULL default 54;
1014source include/diff_tables.inc;
1015drop table foo; drop table bar;
1016
1017
1018create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1019create table bar like foo;
1020alter table bar engine=MyISAM;
1021insert into foo values (NULL,NULL,NULL,NULL);
1022insert into foo values (-1,NULL,'2008-1-1',NULL);
1023insert into foo values (NULL,12345678987,NULL,1);
1024insert into foo values (2,20,'1999-11-11',0);
1025insert into bar select * from foo;
1026source include/diff_tables.inc;
1027alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_41 varchar(10) default NULL;
1028alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_41 varchar(10) default NULL;
1029source include/diff_tables.inc;
1030drop table foo; drop table bar;
1031
1032
1033create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1034create table bar like foo;
1035alter table bar engine=MyISAM;
1036insert into foo values (NULL,NULL,NULL,NULL);
1037insert into foo values (-1,NULL,'2008-1-1',NULL);
1038insert into foo values (NULL,12345678987,NULL,1);
1039insert into foo values (2,20,'1999-11-11',0);
1040insert into bar select * from foo;
1041source include/diff_tables.inc;
1042alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_51 varchar(10) default "abracadab";
1043alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_51 varchar(10) default "abracadab";
1044source include/diff_tables.inc;
1045drop table foo; drop table bar;
1046
1047
1048create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1049create table bar like foo;
1050alter table bar engine=MyISAM;
1051insert into foo values (NULL,NULL,NULL,NULL);
1052insert into foo values (-1,NULL,'2008-1-1',NULL);
1053insert into foo values (NULL,12345678987,NULL,1);
1054insert into foo values (2,20,'1999-11-11',0);
1055insert into bar select * from foo;
1056source include/diff_tables.inc;
1057alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_61 varchar(10) NOT NULL default "abracadab";
1058alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_61 varchar(10) NOT NULL default "abracadab";
1059source include/diff_tables.inc;
1060drop table foo; drop table bar;
1061
1062
1063create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1064create table bar like foo;
1065alter table bar engine=MyISAM;
1066insert into foo values (NULL,NULL,NULL,NULL);
1067insert into foo values (-1,NULL,'2008-1-1',NULL);
1068insert into foo values (NULL,12345678987,NULL,1);
1069insert into foo values (2,20,'1999-11-11',0);
1070insert into bar select * from foo;
1071source include/diff_tables.inc;
1072alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_71 text default NULL;
1073alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_71 text default NULL;
1074source include/diff_tables.inc;
1075drop table foo; drop table bar;
1076
1077
1078create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1079create table bar like foo;
1080alter table bar engine=MyISAM;
1081insert into foo values (NULL,NULL,NULL,NULL);
1082insert into foo values (-1,NULL,'2008-1-1',NULL);
1083insert into foo values (NULL,12345678987,NULL,1);
1084insert into foo values (2,20,'1999-11-11',0);
1085insert into bar select * from foo;
1086source include/diff_tables.inc;
1087alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_81 mediumtext default NULL;
1088alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_81 mediumtext default NULL;
1089source include/diff_tables.inc;
1090drop table foo; drop table bar;
1091
1092
1093create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1094create table bar like foo;
1095alter table bar engine=MyISAM;
1096insert into foo values (NULL,NULL,NULL,NULL);
1097insert into foo values (-1,NULL,'2008-1-1',NULL);
1098insert into foo values (NULL,12345678987,NULL,1);
1099insert into foo values (2,20,'1999-11-11',0);
1100insert into bar select * from foo;
1101source include/diff_tables.inc;
1102alter table foo add column added_7 text default NULL, add column added_11 bigint default NULL;
1103alter table bar add column added_7 text default NULL, add column added_11 bigint default NULL;
1104source include/diff_tables.inc;
1105drop table foo; drop table bar;
1106
1107
1108create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1109create table bar like foo;
1110alter table bar engine=MyISAM;
1111insert into foo values (NULL,NULL,NULL,NULL);
1112insert into foo values (-1,NULL,'2008-1-1',NULL);
1113insert into foo values (NULL,12345678987,NULL,1);
1114insert into foo values (2,20,'1999-11-11',0);
1115insert into bar select * from foo;
1116source include/diff_tables.inc;
1117alter table foo add column added_7 text default NULL, add column added_21 bigint default 1234;
1118alter table bar add column added_7 text default NULL, add column added_21 bigint default 1234;
1119source include/diff_tables.inc;
1120drop table foo; drop table bar;
1121
1122
1123create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1124create table bar like foo;
1125alter table bar engine=MyISAM;
1126insert into foo values (NULL,NULL,NULL,NULL);
1127insert into foo values (-1,NULL,'2008-1-1',NULL);
1128insert into foo values (NULL,12345678987,NULL,1);
1129insert into foo values (2,20,'1999-11-11',0);
1130insert into bar select * from foo;
1131source include/diff_tables.inc;
1132alter table foo add column added_7 text default NULL, add column added_31 bigint NOT NULL default 54;
1133alter table bar add column added_7 text default NULL, add column added_31 bigint NOT NULL default 54;
1134source include/diff_tables.inc;
1135drop table foo; drop table bar;
1136
1137
1138create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1139create table bar like foo;
1140alter table bar engine=MyISAM;
1141insert into foo values (NULL,NULL,NULL,NULL);
1142insert into foo values (-1,NULL,'2008-1-1',NULL);
1143insert into foo values (NULL,12345678987,NULL,1);
1144insert into foo values (2,20,'1999-11-11',0);
1145insert into bar select * from foo;
1146source include/diff_tables.inc;
1147alter table foo add column added_7 text default NULL, add column added_41 varchar(10) default NULL;
1148alter table bar add column added_7 text default NULL, add column added_41 varchar(10) default NULL;
1149source include/diff_tables.inc;
1150drop table foo; drop table bar;
1151
1152
1153create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1154create table bar like foo;
1155alter table bar engine=MyISAM;
1156insert into foo values (NULL,NULL,NULL,NULL);
1157insert into foo values (-1,NULL,'2008-1-1',NULL);
1158insert into foo values (NULL,12345678987,NULL,1);
1159insert into foo values (2,20,'1999-11-11',0);
1160insert into bar select * from foo;
1161source include/diff_tables.inc;
1162alter table foo add column added_7 text default NULL, add column added_51 varchar(10) default "abracadab";
1163alter table bar add column added_7 text default NULL, add column added_51 varchar(10) default "abracadab";
1164source include/diff_tables.inc;
1165drop table foo; drop table bar;
1166
1167
1168create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1169create table bar like foo;
1170alter table bar engine=MyISAM;
1171insert into foo values (NULL,NULL,NULL,NULL);
1172insert into foo values (-1,NULL,'2008-1-1',NULL);
1173insert into foo values (NULL,12345678987,NULL,1);
1174insert into foo values (2,20,'1999-11-11',0);
1175insert into bar select * from foo;
1176source include/diff_tables.inc;
1177alter table foo add column added_7 text default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
1178alter table bar add column added_7 text default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
1179source include/diff_tables.inc;
1180drop table foo; drop table bar;
1181
1182
1183create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1184create table bar like foo;
1185alter table bar engine=MyISAM;
1186insert into foo values (NULL,NULL,NULL,NULL);
1187insert into foo values (-1,NULL,'2008-1-1',NULL);
1188insert into foo values (NULL,12345678987,NULL,1);
1189insert into foo values (2,20,'1999-11-11',0);
1190insert into bar select * from foo;
1191source include/diff_tables.inc;
1192alter table foo add column added_7 text default NULL, add column added_71 text default NULL;
1193alter table bar add column added_7 text default NULL, add column added_71 text default NULL;
1194source include/diff_tables.inc;
1195drop table foo; drop table bar;
1196
1197
1198create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1199create table bar like foo;
1200alter table bar engine=MyISAM;
1201insert into foo values (NULL,NULL,NULL,NULL);
1202insert into foo values (-1,NULL,'2008-1-1',NULL);
1203insert into foo values (NULL,12345678987,NULL,1);
1204insert into foo values (2,20,'1999-11-11',0);
1205insert into bar select * from foo;
1206source include/diff_tables.inc;
1207alter table foo add column added_7 text default NULL, add column added_81 mediumtext default NULL;
1208alter table bar add column added_7 text default NULL, add column added_81 mediumtext default NULL;
1209source include/diff_tables.inc;
1210drop table foo; drop table bar;
1211
1212
1213create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1214create table bar like foo;
1215alter table bar engine=MyISAM;
1216insert into foo values (NULL,NULL,NULL,NULL);
1217insert into foo values (-1,NULL,'2008-1-1',NULL);
1218insert into foo values (NULL,12345678987,NULL,1);
1219insert into foo values (2,20,'1999-11-11',0);
1220insert into bar select * from foo;
1221source include/diff_tables.inc;
1222alter table foo add column added_8 mediumtext default NULL, add column added_11 bigint default NULL;
1223alter table bar add column added_8 mediumtext default NULL, add column added_11 bigint default NULL;
1224source include/diff_tables.inc;
1225drop table foo; drop table bar;
1226
1227
1228create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1229create table bar like foo;
1230alter table bar engine=MyISAM;
1231insert into foo values (NULL,NULL,NULL,NULL);
1232insert into foo values (-1,NULL,'2008-1-1',NULL);
1233insert into foo values (NULL,12345678987,NULL,1);
1234insert into foo values (2,20,'1999-11-11',0);
1235insert into bar select * from foo;
1236source include/diff_tables.inc;
1237alter table foo add column added_8 mediumtext default NULL, add column added_21 bigint default 1234;
1238alter table bar add column added_8 mediumtext default NULL, add column added_21 bigint default 1234;
1239source include/diff_tables.inc;
1240drop table foo; drop table bar;
1241
1242
1243create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1244create table bar like foo;
1245alter table bar engine=MyISAM;
1246insert into foo values (NULL,NULL,NULL,NULL);
1247insert into foo values (-1,NULL,'2008-1-1',NULL);
1248insert into foo values (NULL,12345678987,NULL,1);
1249insert into foo values (2,20,'1999-11-11',0);
1250insert into bar select * from foo;
1251source include/diff_tables.inc;
1252alter table foo add column added_8 mediumtext default NULL, add column added_31 bigint NOT NULL default 54;
1253alter table bar add column added_8 mediumtext default NULL, add column added_31 bigint NOT NULL default 54;
1254source include/diff_tables.inc;
1255drop table foo; drop table bar;
1256
1257
1258create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1259create table bar like foo;
1260alter table bar engine=MyISAM;
1261insert into foo values (NULL,NULL,NULL,NULL);
1262insert into foo values (-1,NULL,'2008-1-1',NULL);
1263insert into foo values (NULL,12345678987,NULL,1);
1264insert into foo values (2,20,'1999-11-11',0);
1265insert into bar select * from foo;
1266source include/diff_tables.inc;
1267alter table foo add column added_8 mediumtext default NULL, add column added_41 varchar(10) default NULL;
1268alter table bar add column added_8 mediumtext default NULL, add column added_41 varchar(10) default NULL;
1269source include/diff_tables.inc;
1270drop table foo; drop table bar;
1271
1272
1273create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1274create table bar like foo;
1275alter table bar engine=MyISAM;
1276insert into foo values (NULL,NULL,NULL,NULL);
1277insert into foo values (-1,NULL,'2008-1-1',NULL);
1278insert into foo values (NULL,12345678987,NULL,1);
1279insert into foo values (2,20,'1999-11-11',0);
1280insert into bar select * from foo;
1281source include/diff_tables.inc;
1282alter table foo add column added_8 mediumtext default NULL, add column added_51 varchar(10) default "abracadab";
1283alter table bar add column added_8 mediumtext default NULL, add column added_51 varchar(10) default "abracadab";
1284source include/diff_tables.inc;
1285drop table foo; drop table bar;
1286
1287
1288create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1289create table bar like foo;
1290alter table bar engine=MyISAM;
1291insert into foo values (NULL,NULL,NULL,NULL);
1292insert into foo values (-1,NULL,'2008-1-1',NULL);
1293insert into foo values (NULL,12345678987,NULL,1);
1294insert into foo values (2,20,'1999-11-11',0);
1295insert into bar select * from foo;
1296source include/diff_tables.inc;
1297alter table foo add column added_8 mediumtext default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
1298alter table bar add column added_8 mediumtext default NULL, add column added_61 varchar(10) NOT NULL default "abracadab";
1299source include/diff_tables.inc;
1300drop table foo; drop table bar;
1301
1302
1303create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1304create table bar like foo;
1305alter table bar engine=MyISAM;
1306insert into foo values (NULL,NULL,NULL,NULL);
1307insert into foo values (-1,NULL,'2008-1-1',NULL);
1308insert into foo values (NULL,12345678987,NULL,1);
1309insert into foo values (2,20,'1999-11-11',0);
1310insert into bar select * from foo;
1311source include/diff_tables.inc;
1312alter table foo add column added_8 mediumtext default NULL, add column added_71 text default NULL;
1313alter table bar add column added_8 mediumtext default NULL, add column added_71 text default NULL;
1314source include/diff_tables.inc;
1315drop table foo; drop table bar;
1316
1317
1318create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1319create table bar like foo;
1320alter table bar engine=MyISAM;
1321insert into foo values (NULL,NULL,NULL,NULL);
1322insert into foo values (-1,NULL,'2008-1-1',NULL);
1323insert into foo values (NULL,12345678987,NULL,1);
1324insert into foo values (2,20,'1999-11-11',0);
1325insert into bar select * from foo;
1326source include/diff_tables.inc;
1327alter table foo add column added_8 mediumtext default NULL, add column added_81 mediumtext default NULL;
1328alter table bar add column added_8 mediumtext default NULL, add column added_81 mediumtext default NULL;
1329source include/diff_tables.inc;
1330drop table foo; drop table bar;
1331
1332
1333create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1334create table bar like foo;
1335alter table bar engine=MyISAM;
1336insert into foo values (NULL,NULL,NULL,NULL);
1337insert into foo values (-1,NULL,'2008-1-1',NULL);
1338insert into foo values (NULL,12345678987,NULL,1);
1339insert into foo values (2,20,'1999-11-11',0);
1340insert into bar select * from foo;
1341source include/diff_tables.inc;
1342alter table foo add column added_1 bigint default NULL first, add column added_11 bigint default NULL;
1343alter table bar add column added_1 bigint default NULL first, add column added_11 bigint default NULL;
1344source include/diff_tables.inc;
1345drop table foo; drop table bar;
1346
1347
1348create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1349create table bar like foo;
1350alter table bar engine=MyISAM;
1351insert into foo values (NULL,NULL,NULL,NULL);
1352insert into foo values (-1,NULL,'2008-1-1',NULL);
1353insert into foo values (NULL,12345678987,NULL,1);
1354insert into foo values (2,20,'1999-11-11',0);
1355insert into bar select * from foo;
1356source include/diff_tables.inc;
1357alter table foo add column added_1 bigint default NULL first, add column added_21 bigint default 1234;
1358alter table bar add column added_1 bigint default NULL first, add column added_21 bigint default 1234;
1359source include/diff_tables.inc;
1360drop table foo; drop table bar;
1361
1362
1363create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1364create table bar like foo;
1365alter table bar engine=MyISAM;
1366insert into foo values (NULL,NULL,NULL,NULL);
1367insert into foo values (-1,NULL,'2008-1-1',NULL);
1368insert into foo values (NULL,12345678987,NULL,1);
1369insert into foo values (2,20,'1999-11-11',0);
1370insert into bar select * from foo;
1371source include/diff_tables.inc;
1372alter table foo add column added_1 bigint default NULL first, add column added_31 bigint NOT NULL default 54;
1373alter table bar add column added_1 bigint default NULL first, add column added_31 bigint NOT NULL default 54;
1374source include/diff_tables.inc;
1375drop table foo; drop table bar;
1376
1377
1378create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1379create table bar like foo;
1380alter table bar engine=MyISAM;
1381insert into foo values (NULL,NULL,NULL,NULL);
1382insert into foo values (-1,NULL,'2008-1-1',NULL);
1383insert into foo values (NULL,12345678987,NULL,1);
1384insert into foo values (2,20,'1999-11-11',0);
1385insert into bar select * from foo;
1386source include/diff_tables.inc;
1387alter table foo add column added_1 bigint default NULL first, add column added_41 varchar(10) default NULL;
1388alter table bar add column added_1 bigint default NULL first, add column added_41 varchar(10) default NULL;
1389source include/diff_tables.inc;
1390drop table foo; drop table bar;
1391
1392
1393create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1394create table bar like foo;
1395alter table bar engine=MyISAM;
1396insert into foo values (NULL,NULL,NULL,NULL);
1397insert into foo values (-1,NULL,'2008-1-1',NULL);
1398insert into foo values (NULL,12345678987,NULL,1);
1399insert into foo values (2,20,'1999-11-11',0);
1400insert into bar select * from foo;
1401source include/diff_tables.inc;
1402alter table foo add column added_1 bigint default NULL first, add column added_51 varchar(10) default "abracadab";
1403alter table bar add column added_1 bigint default NULL first, add column added_51 varchar(10) default "abracadab";
1404source include/diff_tables.inc;
1405drop table foo; drop table bar;
1406
1407
1408create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1409create table bar like foo;
1410alter table bar engine=MyISAM;
1411insert into foo values (NULL,NULL,NULL,NULL);
1412insert into foo values (-1,NULL,'2008-1-1',NULL);
1413insert into foo values (NULL,12345678987,NULL,1);
1414insert into foo values (2,20,'1999-11-11',0);
1415insert into bar select * from foo;
1416source include/diff_tables.inc;
1417alter table foo add column added_1 bigint default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
1418alter table bar add column added_1 bigint default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
1419source include/diff_tables.inc;
1420drop table foo; drop table bar;
1421
1422
1423create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1424create table bar like foo;
1425alter table bar engine=MyISAM;
1426insert into foo values (NULL,NULL,NULL,NULL);
1427insert into foo values (-1,NULL,'2008-1-1',NULL);
1428insert into foo values (NULL,12345678987,NULL,1);
1429insert into foo values (2,20,'1999-11-11',0);
1430insert into bar select * from foo;
1431source include/diff_tables.inc;
1432alter table foo add column added_1 bigint default NULL first, add column added_71 text default NULL;
1433alter table bar add column added_1 bigint default NULL first, add column added_71 text default NULL;
1434source include/diff_tables.inc;
1435drop table foo; drop table bar;
1436
1437
1438create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1439create table bar like foo;
1440alter table bar engine=MyISAM;
1441insert into foo values (NULL,NULL,NULL,NULL);
1442insert into foo values (-1,NULL,'2008-1-1',NULL);
1443insert into foo values (NULL,12345678987,NULL,1);
1444insert into foo values (2,20,'1999-11-11',0);
1445insert into bar select * from foo;
1446source include/diff_tables.inc;
1447alter table foo add column added_1 bigint default NULL first, add column added_81 mediumtext default NULL;
1448alter table bar add column added_1 bigint default NULL first, add column added_81 mediumtext default NULL;
1449source include/diff_tables.inc;
1450drop table foo; drop table bar;
1451
1452
1453create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1454create table bar like foo;
1455alter table bar engine=MyISAM;
1456insert into foo values (NULL,NULL,NULL,NULL);
1457insert into foo values (-1,NULL,'2008-1-1',NULL);
1458insert into foo values (NULL,12345678987,NULL,1);
1459insert into foo values (2,20,'1999-11-11',0);
1460insert into bar select * from foo;
1461source include/diff_tables.inc;
1462alter table foo add column added_2 bigint default -1 first, add column added_11 bigint default NULL;
1463alter table bar add column added_2 bigint default -1 first, add column added_11 bigint default NULL;
1464source include/diff_tables.inc;
1465drop table foo; drop table bar;
1466
1467
1468create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1469create table bar like foo;
1470alter table bar engine=MyISAM;
1471insert into foo values (NULL,NULL,NULL,NULL);
1472insert into foo values (-1,NULL,'2008-1-1',NULL);
1473insert into foo values (NULL,12345678987,NULL,1);
1474insert into foo values (2,20,'1999-11-11',0);
1475insert into bar select * from foo;
1476source include/diff_tables.inc;
1477alter table foo add column added_2 bigint default -1 first, add column added_21 bigint default 1234;
1478alter table bar add column added_2 bigint default -1 first, add column added_21 bigint default 1234;
1479source include/diff_tables.inc;
1480drop table foo; drop table bar;
1481
1482
1483create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1484create table bar like foo;
1485alter table bar engine=MyISAM;
1486insert into foo values (NULL,NULL,NULL,NULL);
1487insert into foo values (-1,NULL,'2008-1-1',NULL);
1488insert into foo values (NULL,12345678987,NULL,1);
1489insert into foo values (2,20,'1999-11-11',0);
1490insert into bar select * from foo;
1491source include/diff_tables.inc;
1492alter table foo add column added_2 bigint default -1 first, add column added_31 bigint NOT NULL default 54;
1493alter table bar add column added_2 bigint default -1 first, add column added_31 bigint NOT NULL default 54;
1494source include/diff_tables.inc;
1495drop table foo; drop table bar;
1496
1497
1498create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1499create table bar like foo;
1500alter table bar engine=MyISAM;
1501insert into foo values (NULL,NULL,NULL,NULL);
1502insert into foo values (-1,NULL,'2008-1-1',NULL);
1503insert into foo values (NULL,12345678987,NULL,1);
1504insert into foo values (2,20,'1999-11-11',0);
1505insert into bar select * from foo;
1506source include/diff_tables.inc;
1507alter table foo add column added_2 bigint default -1 first, add column added_41 varchar(10) default NULL;
1508alter table bar add column added_2 bigint default -1 first, add column added_41 varchar(10) default NULL;
1509source include/diff_tables.inc;
1510drop table foo; drop table bar;
1511
1512
1513create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1514create table bar like foo;
1515alter table bar engine=MyISAM;
1516insert into foo values (NULL,NULL,NULL,NULL);
1517insert into foo values (-1,NULL,'2008-1-1',NULL);
1518insert into foo values (NULL,12345678987,NULL,1);
1519insert into foo values (2,20,'1999-11-11',0);
1520insert into bar select * from foo;
1521source include/diff_tables.inc;
1522alter table foo add column added_2 bigint default -1 first, add column added_51 varchar(10) default "abracadab";
1523alter table bar add column added_2 bigint default -1 first, add column added_51 varchar(10) default "abracadab";
1524source include/diff_tables.inc;
1525drop table foo; drop table bar;
1526
1527
1528create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1529create table bar like foo;
1530alter table bar engine=MyISAM;
1531insert into foo values (NULL,NULL,NULL,NULL);
1532insert into foo values (-1,NULL,'2008-1-1',NULL);
1533insert into foo values (NULL,12345678987,NULL,1);
1534insert into foo values (2,20,'1999-11-11',0);
1535insert into bar select * from foo;
1536source include/diff_tables.inc;
1537alter table foo add column added_2 bigint default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab";
1538alter table bar add column added_2 bigint default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab";
1539source include/diff_tables.inc;
1540drop table foo; drop table bar;
1541
1542
1543create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1544create table bar like foo;
1545alter table bar engine=MyISAM;
1546insert into foo values (NULL,NULL,NULL,NULL);
1547insert into foo values (-1,NULL,'2008-1-1',NULL);
1548insert into foo values (NULL,12345678987,NULL,1);
1549insert into foo values (2,20,'1999-11-11',0);
1550insert into bar select * from foo;
1551source include/diff_tables.inc;
1552alter table foo add column added_2 bigint default -1 first, add column added_71 text default NULL;
1553alter table bar add column added_2 bigint default -1 first, add column added_71 text default NULL;
1554source include/diff_tables.inc;
1555drop table foo; drop table bar;
1556
1557
1558create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1559create table bar like foo;
1560alter table bar engine=MyISAM;
1561insert into foo values (NULL,NULL,NULL,NULL);
1562insert into foo values (-1,NULL,'2008-1-1',NULL);
1563insert into foo values (NULL,12345678987,NULL,1);
1564insert into foo values (2,20,'1999-11-11',0);
1565insert into bar select * from foo;
1566source include/diff_tables.inc;
1567alter table foo add column added_2 bigint default -1 first, add column added_81 mediumtext default NULL;
1568alter table bar add column added_2 bigint default -1 first, add column added_81 mediumtext default NULL;
1569source include/diff_tables.inc;
1570drop table foo; drop table bar;
1571
1572
1573create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1574create table bar like foo;
1575alter table bar engine=MyISAM;
1576insert into foo values (NULL,NULL,NULL,NULL);
1577insert into foo values (-1,NULL,'2008-1-1',NULL);
1578insert into foo values (NULL,12345678987,NULL,1);
1579insert into foo values (2,20,'1999-11-11',0);
1580insert into bar select * from foo;
1581source include/diff_tables.inc;
1582alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_11 bigint default NULL;
1583alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_11 bigint default NULL;
1584source include/diff_tables.inc;
1585drop table foo; drop table bar;
1586
1587
1588create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1589create table bar like foo;
1590alter table bar engine=MyISAM;
1591insert into foo values (NULL,NULL,NULL,NULL);
1592insert into foo values (-1,NULL,'2008-1-1',NULL);
1593insert into foo values (NULL,12345678987,NULL,1);
1594insert into foo values (2,20,'1999-11-11',0);
1595insert into bar select * from foo;
1596source include/diff_tables.inc;
1597alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_21 bigint default 1234;
1598alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_21 bigint default 1234;
1599source include/diff_tables.inc;
1600drop table foo; drop table bar;
1601
1602
1603create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1604create table bar like foo;
1605alter table bar engine=MyISAM;
1606insert into foo values (NULL,NULL,NULL,NULL);
1607insert into foo values (-1,NULL,'2008-1-1',NULL);
1608insert into foo values (NULL,12345678987,NULL,1);
1609insert into foo values (2,20,'1999-11-11',0);
1610insert into bar select * from foo;
1611source include/diff_tables.inc;
1612alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_31 bigint NOT NULL default 54;
1613alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_31 bigint NOT NULL default 54;
1614source include/diff_tables.inc;
1615drop table foo; drop table bar;
1616
1617
1618create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1619create table bar like foo;
1620alter table bar engine=MyISAM;
1621insert into foo values (NULL,NULL,NULL,NULL);
1622insert into foo values (-1,NULL,'2008-1-1',NULL);
1623insert into foo values (NULL,12345678987,NULL,1);
1624insert into foo values (2,20,'1999-11-11',0);
1625insert into bar select * from foo;
1626source include/diff_tables.inc;
1627alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_41 varchar(10) default NULL;
1628alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_41 varchar(10) default NULL;
1629source include/diff_tables.inc;
1630drop table foo; drop table bar;
1631
1632
1633create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1634create table bar like foo;
1635alter table bar engine=MyISAM;
1636insert into foo values (NULL,NULL,NULL,NULL);
1637insert into foo values (-1,NULL,'2008-1-1',NULL);
1638insert into foo values (NULL,12345678987,NULL,1);
1639insert into foo values (2,20,'1999-11-11',0);
1640insert into bar select * from foo;
1641source include/diff_tables.inc;
1642alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_51 varchar(10) default "abracadab";
1643alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_51 varchar(10) default "abracadab";
1644source include/diff_tables.inc;
1645drop table foo; drop table bar;
1646
1647
1648create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1649create table bar like foo;
1650alter table bar engine=MyISAM;
1651insert into foo values (NULL,NULL,NULL,NULL);
1652insert into foo values (-1,NULL,'2008-1-1',NULL);
1653insert into foo values (NULL,12345678987,NULL,1);
1654insert into foo values (2,20,'1999-11-11',0);
1655insert into bar select * from foo;
1656source include/diff_tables.inc;
1657alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab";
1658alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab";
1659source include/diff_tables.inc;
1660drop table foo; drop table bar;
1661
1662
1663create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1664create table bar like foo;
1665alter table bar engine=MyISAM;
1666insert into foo values (NULL,NULL,NULL,NULL);
1667insert into foo values (-1,NULL,'2008-1-1',NULL);
1668insert into foo values (NULL,12345678987,NULL,1);
1669insert into foo values (2,20,'1999-11-11',0);
1670insert into bar select * from foo;
1671source include/diff_tables.inc;
1672alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_71 text default NULL;
1673alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_71 text default NULL;
1674source include/diff_tables.inc;
1675drop table foo; drop table bar;
1676
1677
1678create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1679create table bar like foo;
1680alter table bar engine=MyISAM;
1681insert into foo values (NULL,NULL,NULL,NULL);
1682insert into foo values (-1,NULL,'2008-1-1',NULL);
1683insert into foo values (NULL,12345678987,NULL,1);
1684insert into foo values (2,20,'1999-11-11',0);
1685insert into bar select * from foo;
1686source include/diff_tables.inc;
1687alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_81 mediumtext default NULL;
1688alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_81 mediumtext default NULL;
1689source include/diff_tables.inc;
1690drop table foo; drop table bar;
1691
1692
1693create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1694create table bar like foo;
1695alter table bar engine=MyISAM;
1696insert into foo values (NULL,NULL,NULL,NULL);
1697insert into foo values (-1,NULL,'2008-1-1',NULL);
1698insert into foo values (NULL,12345678987,NULL,1);
1699insert into foo values (2,20,'1999-11-11',0);
1700insert into bar select * from foo;
1701source include/diff_tables.inc;
1702alter table foo add column added_4 varchar(10) default NULL first, add column added_11 bigint default NULL;
1703alter table bar add column added_4 varchar(10) default NULL first, add column added_11 bigint default NULL;
1704source include/diff_tables.inc;
1705drop table foo; drop table bar;
1706
1707
1708create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1709create table bar like foo;
1710alter table bar engine=MyISAM;
1711insert into foo values (NULL,NULL,NULL,NULL);
1712insert into foo values (-1,NULL,'2008-1-1',NULL);
1713insert into foo values (NULL,12345678987,NULL,1);
1714insert into foo values (2,20,'1999-11-11',0);
1715insert into bar select * from foo;
1716source include/diff_tables.inc;
1717alter table foo add column added_4 varchar(10) default NULL first, add column added_21 bigint default 1234;
1718alter table bar add column added_4 varchar(10) default NULL first, add column added_21 bigint default 1234;
1719source include/diff_tables.inc;
1720drop table foo; drop table bar;
1721
1722
1723create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1724create table bar like foo;
1725alter table bar engine=MyISAM;
1726insert into foo values (NULL,NULL,NULL,NULL);
1727insert into foo values (-1,NULL,'2008-1-1',NULL);
1728insert into foo values (NULL,12345678987,NULL,1);
1729insert into foo values (2,20,'1999-11-11',0);
1730insert into bar select * from foo;
1731source include/diff_tables.inc;
1732alter table foo add column added_4 varchar(10) default NULL first, add column added_31 bigint NOT NULL default 54;
1733alter table bar add column added_4 varchar(10) default NULL first, add column added_31 bigint NOT NULL default 54;
1734source include/diff_tables.inc;
1735drop table foo; drop table bar;
1736
1737
1738create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1739create table bar like foo;
1740alter table bar engine=MyISAM;
1741insert into foo values (NULL,NULL,NULL,NULL);
1742insert into foo values (-1,NULL,'2008-1-1',NULL);
1743insert into foo values (NULL,12345678987,NULL,1);
1744insert into foo values (2,20,'1999-11-11',0);
1745insert into bar select * from foo;
1746source include/diff_tables.inc;
1747alter table foo add column added_4 varchar(10) default NULL first, add column added_41 varchar(10) default NULL;
1748alter table bar add column added_4 varchar(10) default NULL first, add column added_41 varchar(10) default NULL;
1749source include/diff_tables.inc;
1750drop table foo; drop table bar;
1751
1752
1753create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1754create table bar like foo;
1755alter table bar engine=MyISAM;
1756insert into foo values (NULL,NULL,NULL,NULL);
1757insert into foo values (-1,NULL,'2008-1-1',NULL);
1758insert into foo values (NULL,12345678987,NULL,1);
1759insert into foo values (2,20,'1999-11-11',0);
1760insert into bar select * from foo;
1761source include/diff_tables.inc;
1762alter table foo add column added_4 varchar(10) default NULL first, add column added_51 varchar(10) default "abracadab";
1763alter table bar add column added_4 varchar(10) default NULL first, add column added_51 varchar(10) default "abracadab";
1764source include/diff_tables.inc;
1765drop table foo; drop table bar;
1766
1767
1768create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1769create table bar like foo;
1770alter table bar engine=MyISAM;
1771insert into foo values (NULL,NULL,NULL,NULL);
1772insert into foo values (-1,NULL,'2008-1-1',NULL);
1773insert into foo values (NULL,12345678987,NULL,1);
1774insert into foo values (2,20,'1999-11-11',0);
1775insert into bar select * from foo;
1776source include/diff_tables.inc;
1777alter table foo add column added_4 varchar(10) default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
1778alter table bar add column added_4 varchar(10) default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
1779source include/diff_tables.inc;
1780drop table foo; drop table bar;
1781
1782
1783create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1784create table bar like foo;
1785alter table bar engine=MyISAM;
1786insert into foo values (NULL,NULL,NULL,NULL);
1787insert into foo values (-1,NULL,'2008-1-1',NULL);
1788insert into foo values (NULL,12345678987,NULL,1);
1789insert into foo values (2,20,'1999-11-11',0);
1790insert into bar select * from foo;
1791source include/diff_tables.inc;
1792alter table foo add column added_4 varchar(10) default NULL first, add column added_71 text default NULL;
1793alter table bar add column added_4 varchar(10) default NULL first, add column added_71 text default NULL;
1794source include/diff_tables.inc;
1795drop table foo; drop table bar;
1796
1797
1798create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1799create table bar like foo;
1800alter table bar engine=MyISAM;
1801insert into foo values (NULL,NULL,NULL,NULL);
1802insert into foo values (-1,NULL,'2008-1-1',NULL);
1803insert into foo values (NULL,12345678987,NULL,1);
1804insert into foo values (2,20,'1999-11-11',0);
1805insert into bar select * from foo;
1806source include/diff_tables.inc;
1807alter table foo add column added_4 varchar(10) default NULL first, add column added_81 mediumtext default NULL;
1808alter table bar add column added_4 varchar(10) default NULL first, add column added_81 mediumtext default NULL;
1809source include/diff_tables.inc;
1810drop table foo; drop table bar;
1811
1812
1813create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1814create table bar like foo;
1815alter table bar engine=MyISAM;
1816insert into foo values (NULL,NULL,NULL,NULL);
1817insert into foo values (-1,NULL,'2008-1-1',NULL);
1818insert into foo values (NULL,12345678987,NULL,1);
1819insert into foo values (2,20,'1999-11-11',0);
1820insert into bar select * from foo;
1821source include/diff_tables.inc;
1822alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_11 bigint default NULL;
1823alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_11 bigint default NULL;
1824source include/diff_tables.inc;
1825drop table foo; drop table bar;
1826
1827
1828create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1829create table bar like foo;
1830alter table bar engine=MyISAM;
1831insert into foo values (NULL,NULL,NULL,NULL);
1832insert into foo values (-1,NULL,'2008-1-1',NULL);
1833insert into foo values (NULL,12345678987,NULL,1);
1834insert into foo values (2,20,'1999-11-11',0);
1835insert into bar select * from foo;
1836source include/diff_tables.inc;
1837alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_21 bigint default 1234;
1838alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_21 bigint default 1234;
1839source include/diff_tables.inc;
1840drop table foo; drop table bar;
1841
1842
1843create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1844create table bar like foo;
1845alter table bar engine=MyISAM;
1846insert into foo values (NULL,NULL,NULL,NULL);
1847insert into foo values (-1,NULL,'2008-1-1',NULL);
1848insert into foo values (NULL,12345678987,NULL,1);
1849insert into foo values (2,20,'1999-11-11',0);
1850insert into bar select * from foo;
1851source include/diff_tables.inc;
1852alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_31 bigint NOT NULL default 54;
1853alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_31 bigint NOT NULL default 54;
1854source include/diff_tables.inc;
1855drop table foo; drop table bar;
1856
1857
1858create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1859create table bar like foo;
1860alter table bar engine=MyISAM;
1861insert into foo values (NULL,NULL,NULL,NULL);
1862insert into foo values (-1,NULL,'2008-1-1',NULL);
1863insert into foo values (NULL,12345678987,NULL,1);
1864insert into foo values (2,20,'1999-11-11',0);
1865insert into bar select * from foo;
1866source include/diff_tables.inc;
1867alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_41 varchar(10) default NULL;
1868alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_41 varchar(10) default NULL;
1869source include/diff_tables.inc;
1870drop table foo; drop table bar;
1871
1872
1873create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1874create table bar like foo;
1875alter table bar engine=MyISAM;
1876insert into foo values (NULL,NULL,NULL,NULL);
1877insert into foo values (-1,NULL,'2008-1-1',NULL);
1878insert into foo values (NULL,12345678987,NULL,1);
1879insert into foo values (2,20,'1999-11-11',0);
1880insert into bar select * from foo;
1881source include/diff_tables.inc;
1882alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_51 varchar(10) default "abracadab";
1883alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_51 varchar(10) default "abracadab";
1884source include/diff_tables.inc;
1885drop table foo; drop table bar;
1886
1887
1888create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1889create table bar like foo;
1890alter table bar engine=MyISAM;
1891insert into foo values (NULL,NULL,NULL,NULL);
1892insert into foo values (-1,NULL,'2008-1-1',NULL);
1893insert into foo values (NULL,12345678987,NULL,1);
1894insert into foo values (2,20,'1999-11-11',0);
1895insert into bar select * from foo;
1896source include/diff_tables.inc;
1897alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_61 varchar(10) NOT NULL default "abracadab";
1898alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_61 varchar(10) NOT NULL default "abracadab";
1899source include/diff_tables.inc;
1900drop table foo; drop table bar;
1901
1902
1903create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1904create table bar like foo;
1905alter table bar engine=MyISAM;
1906insert into foo values (NULL,NULL,NULL,NULL);
1907insert into foo values (-1,NULL,'2008-1-1',NULL);
1908insert into foo values (NULL,12345678987,NULL,1);
1909insert into foo values (2,20,'1999-11-11',0);
1910insert into bar select * from foo;
1911source include/diff_tables.inc;
1912alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_71 text default NULL;
1913alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_71 text default NULL;
1914source include/diff_tables.inc;
1915drop table foo; drop table bar;
1916
1917
1918create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1919create table bar like foo;
1920alter table bar engine=MyISAM;
1921insert into foo values (NULL,NULL,NULL,NULL);
1922insert into foo values (-1,NULL,'2008-1-1',NULL);
1923insert into foo values (NULL,12345678987,NULL,1);
1924insert into foo values (2,20,'1999-11-11',0);
1925insert into bar select * from foo;
1926source include/diff_tables.inc;
1927alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_81 mediumtext default NULL;
1928alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_81 mediumtext default NULL;
1929source include/diff_tables.inc;
1930drop table foo; drop table bar;
1931
1932
1933create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1934create table bar like foo;
1935alter table bar engine=MyISAM;
1936insert into foo values (NULL,NULL,NULL,NULL);
1937insert into foo values (-1,NULL,'2008-1-1',NULL);
1938insert into foo values (NULL,12345678987,NULL,1);
1939insert into foo values (2,20,'1999-11-11',0);
1940insert into bar select * from foo;
1941source include/diff_tables.inc;
1942alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_11 bigint default NULL;
1943alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_11 bigint default NULL;
1944source include/diff_tables.inc;
1945drop table foo; drop table bar;
1946
1947
1948create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1949create table bar like foo;
1950alter table bar engine=MyISAM;
1951insert into foo values (NULL,NULL,NULL,NULL);
1952insert into foo values (-1,NULL,'2008-1-1',NULL);
1953insert into foo values (NULL,12345678987,NULL,1);
1954insert into foo values (2,20,'1999-11-11',0);
1955insert into bar select * from foo;
1956source include/diff_tables.inc;
1957alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_21 bigint default 1234;
1958alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_21 bigint default 1234;
1959source include/diff_tables.inc;
1960drop table foo; drop table bar;
1961
1962
1963create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1964create table bar like foo;
1965alter table bar engine=MyISAM;
1966insert into foo values (NULL,NULL,NULL,NULL);
1967insert into foo values (-1,NULL,'2008-1-1',NULL);
1968insert into foo values (NULL,12345678987,NULL,1);
1969insert into foo values (2,20,'1999-11-11',0);
1970insert into bar select * from foo;
1971source include/diff_tables.inc;
1972alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_31 bigint NOT NULL default 54;
1973alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_31 bigint NOT NULL default 54;
1974source include/diff_tables.inc;
1975drop table foo; drop table bar;
1976
1977
1978create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1979create table bar like foo;
1980alter table bar engine=MyISAM;
1981insert into foo values (NULL,NULL,NULL,NULL);
1982insert into foo values (-1,NULL,'2008-1-1',NULL);
1983insert into foo values (NULL,12345678987,NULL,1);
1984insert into foo values (2,20,'1999-11-11',0);
1985insert into bar select * from foo;
1986source include/diff_tables.inc;
1987alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_41 varchar(10) default NULL;
1988alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_41 varchar(10) default NULL;
1989source include/diff_tables.inc;
1990drop table foo; drop table bar;
1991
1992
1993create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
1994create table bar like foo;
1995alter table bar engine=MyISAM;
1996insert into foo values (NULL,NULL,NULL,NULL);
1997insert into foo values (-1,NULL,'2008-1-1',NULL);
1998insert into foo values (NULL,12345678987,NULL,1);
1999insert into foo values (2,20,'1999-11-11',0);
2000insert into bar select * from foo;
2001source include/diff_tables.inc;
2002alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_51 varchar(10) default "abracadab";
2003alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_51 varchar(10) default "abracadab";
2004source include/diff_tables.inc;
2005drop table foo; drop table bar;
2006
2007
2008create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2009create table bar like foo;
2010alter table bar engine=MyISAM;
2011insert into foo values (NULL,NULL,NULL,NULL);
2012insert into foo values (-1,NULL,'2008-1-1',NULL);
2013insert into foo values (NULL,12345678987,NULL,1);
2014insert into foo values (2,20,'1999-11-11',0);
2015insert into bar select * from foo;
2016source include/diff_tables.inc;
2017alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_61 varchar(10) NOT NULL default "abracadab";
2018alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_61 varchar(10) NOT NULL default "abracadab";
2019source include/diff_tables.inc;
2020drop table foo; drop table bar;
2021
2022
2023create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2024create table bar like foo;
2025alter table bar engine=MyISAM;
2026insert into foo values (NULL,NULL,NULL,NULL);
2027insert into foo values (-1,NULL,'2008-1-1',NULL);
2028insert into foo values (NULL,12345678987,NULL,1);
2029insert into foo values (2,20,'1999-11-11',0);
2030insert into bar select * from foo;
2031source include/diff_tables.inc;
2032alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_71 text default NULL;
2033alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_71 text default NULL;
2034source include/diff_tables.inc;
2035drop table foo; drop table bar;
2036
2037
2038create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2039create table bar like foo;
2040alter table bar engine=MyISAM;
2041insert into foo values (NULL,NULL,NULL,NULL);
2042insert into foo values (-1,NULL,'2008-1-1',NULL);
2043insert into foo values (NULL,12345678987,NULL,1);
2044insert into foo values (2,20,'1999-11-11',0);
2045insert into bar select * from foo;
2046source include/diff_tables.inc;
2047alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_81 mediumtext default NULL;
2048alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_81 mediumtext default NULL;
2049source include/diff_tables.inc;
2050drop table foo; drop table bar;
2051
2052
2053create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2054create table bar like foo;
2055alter table bar engine=MyISAM;
2056insert into foo values (NULL,NULL,NULL,NULL);
2057insert into foo values (-1,NULL,'2008-1-1',NULL);
2058insert into foo values (NULL,12345678987,NULL,1);
2059insert into foo values (2,20,'1999-11-11',0);
2060insert into bar select * from foo;
2061source include/diff_tables.inc;
2062alter table foo add column added_7 text default NULL first, add column added_11 bigint default NULL;
2063alter table bar add column added_7 text default NULL first, add column added_11 bigint default NULL;
2064source include/diff_tables.inc;
2065drop table foo; drop table bar;
2066
2067
2068create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2069create table bar like foo;
2070alter table bar engine=MyISAM;
2071insert into foo values (NULL,NULL,NULL,NULL);
2072insert into foo values (-1,NULL,'2008-1-1',NULL);
2073insert into foo values (NULL,12345678987,NULL,1);
2074insert into foo values (2,20,'1999-11-11',0);
2075insert into bar select * from foo;
2076source include/diff_tables.inc;
2077alter table foo add column added_7 text default NULL first, add column added_21 bigint default 1234;
2078alter table bar add column added_7 text default NULL first, add column added_21 bigint default 1234;
2079source include/diff_tables.inc;
2080drop table foo; drop table bar;
2081
2082
2083create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2084create table bar like foo;
2085alter table bar engine=MyISAM;
2086insert into foo values (NULL,NULL,NULL,NULL);
2087insert into foo values (-1,NULL,'2008-1-1',NULL);
2088insert into foo values (NULL,12345678987,NULL,1);
2089insert into foo values (2,20,'1999-11-11',0);
2090insert into bar select * from foo;
2091source include/diff_tables.inc;
2092alter table foo add column added_7 text default NULL first, add column added_31 bigint NOT NULL default 54;
2093alter table bar add column added_7 text default NULL first, add column added_31 bigint NOT NULL default 54;
2094source include/diff_tables.inc;
2095drop table foo; drop table bar;
2096
2097
2098create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2099create table bar like foo;
2100alter table bar engine=MyISAM;
2101insert into foo values (NULL,NULL,NULL,NULL);
2102insert into foo values (-1,NULL,'2008-1-1',NULL);
2103insert into foo values (NULL,12345678987,NULL,1);
2104insert into foo values (2,20,'1999-11-11',0);
2105insert into bar select * from foo;
2106source include/diff_tables.inc;
2107alter table foo add column added_7 text default NULL first, add column added_41 varchar(10) default NULL;
2108alter table bar add column added_7 text default NULL first, add column added_41 varchar(10) default NULL;
2109source include/diff_tables.inc;
2110drop table foo; drop table bar;
2111
2112
2113create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2114create table bar like foo;
2115alter table bar engine=MyISAM;
2116insert into foo values (NULL,NULL,NULL,NULL);
2117insert into foo values (-1,NULL,'2008-1-1',NULL);
2118insert into foo values (NULL,12345678987,NULL,1);
2119insert into foo values (2,20,'1999-11-11',0);
2120insert into bar select * from foo;
2121source include/diff_tables.inc;
2122alter table foo add column added_7 text default NULL first, add column added_51 varchar(10) default "abracadab";
2123alter table bar add column added_7 text default NULL first, add column added_51 varchar(10) default "abracadab";
2124source include/diff_tables.inc;
2125drop table foo; drop table bar;
2126
2127
2128create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2129create table bar like foo;
2130alter table bar engine=MyISAM;
2131insert into foo values (NULL,NULL,NULL,NULL);
2132insert into foo values (-1,NULL,'2008-1-1',NULL);
2133insert into foo values (NULL,12345678987,NULL,1);
2134insert into foo values (2,20,'1999-11-11',0);
2135insert into bar select * from foo;
2136source include/diff_tables.inc;
2137alter table foo add column added_7 text default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
2138alter table bar add column added_7 text default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
2139source include/diff_tables.inc;
2140drop table foo; drop table bar;
2141
2142
2143create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2144create table bar like foo;
2145alter table bar engine=MyISAM;
2146insert into foo values (NULL,NULL,NULL,NULL);
2147insert into foo values (-1,NULL,'2008-1-1',NULL);
2148insert into foo values (NULL,12345678987,NULL,1);
2149insert into foo values (2,20,'1999-11-11',0);
2150insert into bar select * from foo;
2151source include/diff_tables.inc;
2152alter table foo add column added_7 text default NULL first, add column added_71 text default NULL;
2153alter table bar add column added_7 text default NULL first, add column added_71 text default NULL;
2154source include/diff_tables.inc;
2155drop table foo; drop table bar;
2156
2157
2158create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2159create table bar like foo;
2160alter table bar engine=MyISAM;
2161insert into foo values (NULL,NULL,NULL,NULL);
2162insert into foo values (-1,NULL,'2008-1-1',NULL);
2163insert into foo values (NULL,12345678987,NULL,1);
2164insert into foo values (2,20,'1999-11-11',0);
2165insert into bar select * from foo;
2166source include/diff_tables.inc;
2167alter table foo add column added_7 text default NULL first, add column added_81 mediumtext default NULL;
2168alter table bar add column added_7 text default NULL first, add column added_81 mediumtext default NULL;
2169source include/diff_tables.inc;
2170drop table foo; drop table bar;
2171
2172
2173create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2174create table bar like foo;
2175alter table bar engine=MyISAM;
2176insert into foo values (NULL,NULL,NULL,NULL);
2177insert into foo values (-1,NULL,'2008-1-1',NULL);
2178insert into foo values (NULL,12345678987,NULL,1);
2179insert into foo values (2,20,'1999-11-11',0);
2180insert into bar select * from foo;
2181source include/diff_tables.inc;
2182alter table foo add column added_8 mediumtext default NULL first, add column added_11 bigint default NULL;
2183alter table bar add column added_8 mediumtext default NULL first, add column added_11 bigint default NULL;
2184source include/diff_tables.inc;
2185drop table foo; drop table bar;
2186
2187
2188create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2189create table bar like foo;
2190alter table bar engine=MyISAM;
2191insert into foo values (NULL,NULL,NULL,NULL);
2192insert into foo values (-1,NULL,'2008-1-1',NULL);
2193insert into foo values (NULL,12345678987,NULL,1);
2194insert into foo values (2,20,'1999-11-11',0);
2195insert into bar select * from foo;
2196source include/diff_tables.inc;
2197alter table foo add column added_8 mediumtext default NULL first, add column added_21 bigint default 1234;
2198alter table bar add column added_8 mediumtext default NULL first, add column added_21 bigint default 1234;
2199source include/diff_tables.inc;
2200drop table foo; drop table bar;
2201
2202
2203create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2204create table bar like foo;
2205alter table bar engine=MyISAM;
2206insert into foo values (NULL,NULL,NULL,NULL);
2207insert into foo values (-1,NULL,'2008-1-1',NULL);
2208insert into foo values (NULL,12345678987,NULL,1);
2209insert into foo values (2,20,'1999-11-11',0);
2210insert into bar select * from foo;
2211source include/diff_tables.inc;
2212alter table foo add column added_8 mediumtext default NULL first, add column added_31 bigint NOT NULL default 54;
2213alter table bar add column added_8 mediumtext default NULL first, add column added_31 bigint NOT NULL default 54;
2214source include/diff_tables.inc;
2215drop table foo; drop table bar;
2216
2217
2218create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2219create table bar like foo;
2220alter table bar engine=MyISAM;
2221insert into foo values (NULL,NULL,NULL,NULL);
2222insert into foo values (-1,NULL,'2008-1-1',NULL);
2223insert into foo values (NULL,12345678987,NULL,1);
2224insert into foo values (2,20,'1999-11-11',0);
2225insert into bar select * from foo;
2226source include/diff_tables.inc;
2227alter table foo add column added_8 mediumtext default NULL first, add column added_41 varchar(10) default NULL;
2228alter table bar add column added_8 mediumtext default NULL first, add column added_41 varchar(10) default NULL;
2229source include/diff_tables.inc;
2230drop table foo; drop table bar;
2231
2232
2233create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2234create table bar like foo;
2235alter table bar engine=MyISAM;
2236insert into foo values (NULL,NULL,NULL,NULL);
2237insert into foo values (-1,NULL,'2008-1-1',NULL);
2238insert into foo values (NULL,12345678987,NULL,1);
2239insert into foo values (2,20,'1999-11-11',0);
2240insert into bar select * from foo;
2241source include/diff_tables.inc;
2242alter table foo add column added_8 mediumtext default NULL first, add column added_51 varchar(10) default "abracadab";
2243alter table bar add column added_8 mediumtext default NULL first, add column added_51 varchar(10) default "abracadab";
2244source include/diff_tables.inc;
2245drop table foo; drop table bar;
2246
2247
2248create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2249create table bar like foo;
2250alter table bar engine=MyISAM;
2251insert into foo values (NULL,NULL,NULL,NULL);
2252insert into foo values (-1,NULL,'2008-1-1',NULL);
2253insert into foo values (NULL,12345678987,NULL,1);
2254insert into foo values (2,20,'1999-11-11',0);
2255insert into bar select * from foo;
2256source include/diff_tables.inc;
2257alter table foo add column added_8 mediumtext default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
2258alter table bar add column added_8 mediumtext default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab";
2259source include/diff_tables.inc;
2260drop table foo; drop table bar;
2261
2262
2263create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2264create table bar like foo;
2265alter table bar engine=MyISAM;
2266insert into foo values (NULL,NULL,NULL,NULL);
2267insert into foo values (-1,NULL,'2008-1-1',NULL);
2268insert into foo values (NULL,12345678987,NULL,1);
2269insert into foo values (2,20,'1999-11-11',0);
2270insert into bar select * from foo;
2271source include/diff_tables.inc;
2272alter table foo add column added_8 mediumtext default NULL first, add column added_71 text default NULL;
2273alter table bar add column added_8 mediumtext default NULL first, add column added_71 text default NULL;
2274source include/diff_tables.inc;
2275drop table foo; drop table bar;
2276
2277
2278create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2279create table bar like foo;
2280alter table bar engine=MyISAM;
2281insert into foo values (NULL,NULL,NULL,NULL);
2282insert into foo values (-1,NULL,'2008-1-1',NULL);
2283insert into foo values (NULL,12345678987,NULL,1);
2284insert into foo values (2,20,'1999-11-11',0);
2285insert into bar select * from foo;
2286source include/diff_tables.inc;
2287alter table foo add column added_8 mediumtext default NULL first, add column added_81 mediumtext default NULL;
2288alter table bar add column added_8 mediumtext default NULL first, add column added_81 mediumtext default NULL;
2289source include/diff_tables.inc;
2290drop table foo; drop table bar;
2291
2292
2293create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2294create table bar like foo;
2295alter table bar engine=MyISAM;
2296insert into foo values (NULL,NULL,NULL,NULL);
2297insert into foo values (-1,NULL,'2008-1-1',NULL);
2298insert into foo values (NULL,12345678987,NULL,1);
2299insert into foo values (2,20,'1999-11-11',0);
2300insert into bar select * from foo;
2301source include/diff_tables.inc;
2302alter table foo add column added_1 bigint default NULL after b, add column added_11 bigint default NULL after b;
2303alter table bar add column added_1 bigint default NULL after b, add column added_11 bigint default NULL after b;
2304source include/diff_tables.inc;
2305drop table foo; drop table bar;
2306
2307
2308create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2309create table bar like foo;
2310alter table bar engine=MyISAM;
2311insert into foo values (NULL,NULL,NULL,NULL);
2312insert into foo values (-1,NULL,'2008-1-1',NULL);
2313insert into foo values (NULL,12345678987,NULL,1);
2314insert into foo values (2,20,'1999-11-11',0);
2315insert into bar select * from foo;
2316source include/diff_tables.inc;
2317alter table foo add column added_1 bigint default NULL after b, add column added_21 bigint default 1234 after b;
2318alter table bar add column added_1 bigint default NULL after b, add column added_21 bigint default 1234 after b;
2319source include/diff_tables.inc;
2320drop table foo; drop table bar;
2321
2322
2323create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2324create table bar like foo;
2325alter table bar engine=MyISAM;
2326insert into foo values (NULL,NULL,NULL,NULL);
2327insert into foo values (-1,NULL,'2008-1-1',NULL);
2328insert into foo values (NULL,12345678987,NULL,1);
2329insert into foo values (2,20,'1999-11-11',0);
2330insert into bar select * from foo;
2331source include/diff_tables.inc;
2332alter table foo add column added_1 bigint default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
2333alter table bar add column added_1 bigint default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
2334source include/diff_tables.inc;
2335drop table foo; drop table bar;
2336
2337
2338create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2339create table bar like foo;
2340alter table bar engine=MyISAM;
2341insert into foo values (NULL,NULL,NULL,NULL);
2342insert into foo values (-1,NULL,'2008-1-1',NULL);
2343insert into foo values (NULL,12345678987,NULL,1);
2344insert into foo values (2,20,'1999-11-11',0);
2345insert into bar select * from foo;
2346source include/diff_tables.inc;
2347alter table foo add column added_1 bigint default NULL after b, add column added_41 varchar(10) default NULL after b;
2348alter table bar add column added_1 bigint default NULL after b, add column added_41 varchar(10) default NULL after b;
2349source include/diff_tables.inc;
2350drop table foo; drop table bar;
2351
2352
2353create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2354create table bar like foo;
2355alter table bar engine=MyISAM;
2356insert into foo values (NULL,NULL,NULL,NULL);
2357insert into foo values (-1,NULL,'2008-1-1',NULL);
2358insert into foo values (NULL,12345678987,NULL,1);
2359insert into foo values (2,20,'1999-11-11',0);
2360insert into bar select * from foo;
2361source include/diff_tables.inc;
2362alter table foo add column added_1 bigint default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
2363alter table bar add column added_1 bigint default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
2364source include/diff_tables.inc;
2365drop table foo; drop table bar;
2366
2367
2368create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2369create table bar like foo;
2370alter table bar engine=MyISAM;
2371insert into foo values (NULL,NULL,NULL,NULL);
2372insert into foo values (-1,NULL,'2008-1-1',NULL);
2373insert into foo values (NULL,12345678987,NULL,1);
2374insert into foo values (2,20,'1999-11-11',0);
2375insert into bar select * from foo;
2376source include/diff_tables.inc;
2377alter table foo add column added_1 bigint default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2378alter table bar add column added_1 bigint default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2379source include/diff_tables.inc;
2380drop table foo; drop table bar;
2381
2382
2383create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2384create table bar like foo;
2385alter table bar engine=MyISAM;
2386insert into foo values (NULL,NULL,NULL,NULL);
2387insert into foo values (-1,NULL,'2008-1-1',NULL);
2388insert into foo values (NULL,12345678987,NULL,1);
2389insert into foo values (2,20,'1999-11-11',0);
2390insert into bar select * from foo;
2391source include/diff_tables.inc;
2392alter table foo add column added_1 bigint default NULL after b, add column added_71 text default NULL after b;
2393alter table bar add column added_1 bigint default NULL after b, add column added_71 text default NULL after b;
2394source include/diff_tables.inc;
2395drop table foo; drop table bar;
2396
2397
2398create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2399create table bar like foo;
2400alter table bar engine=MyISAM;
2401insert into foo values (NULL,NULL,NULL,NULL);
2402insert into foo values (-1,NULL,'2008-1-1',NULL);
2403insert into foo values (NULL,12345678987,NULL,1);
2404insert into foo values (2,20,'1999-11-11',0);
2405insert into bar select * from foo;
2406source include/diff_tables.inc;
2407alter table foo add column added_1 bigint default NULL after b, add column added_81 mediumtext default NULL after b;
2408alter table bar add column added_1 bigint default NULL after b, add column added_81 mediumtext default NULL after b;
2409source include/diff_tables.inc;
2410drop table foo; drop table bar;
2411
2412
2413create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2414create table bar like foo;
2415alter table bar engine=MyISAM;
2416insert into foo values (NULL,NULL,NULL,NULL);
2417insert into foo values (-1,NULL,'2008-1-1',NULL);
2418insert into foo values (NULL,12345678987,NULL,1);
2419insert into foo values (2,20,'1999-11-11',0);
2420insert into bar select * from foo;
2421source include/diff_tables.inc;
2422alter table foo add column added_2 bigint default -1 after b, add column added_11 bigint default NULL after b;
2423alter table bar add column added_2 bigint default -1 after b, add column added_11 bigint default NULL after b;
2424source include/diff_tables.inc;
2425drop table foo; drop table bar;
2426
2427
2428create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2429create table bar like foo;
2430alter table bar engine=MyISAM;
2431insert into foo values (NULL,NULL,NULL,NULL);
2432insert into foo values (-1,NULL,'2008-1-1',NULL);
2433insert into foo values (NULL,12345678987,NULL,1);
2434insert into foo values (2,20,'1999-11-11',0);
2435insert into bar select * from foo;
2436source include/diff_tables.inc;
2437alter table foo add column added_2 bigint default -1 after b, add column added_21 bigint default 1234 after b;
2438alter table bar add column added_2 bigint default -1 after b, add column added_21 bigint default 1234 after b;
2439source include/diff_tables.inc;
2440drop table foo; drop table bar;
2441
2442
2443create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2444create table bar like foo;
2445alter table bar engine=MyISAM;
2446insert into foo values (NULL,NULL,NULL,NULL);
2447insert into foo values (-1,NULL,'2008-1-1',NULL);
2448insert into foo values (NULL,12345678987,NULL,1);
2449insert into foo values (2,20,'1999-11-11',0);
2450insert into bar select * from foo;
2451source include/diff_tables.inc;
2452alter table foo add column added_2 bigint default -1 after b, add column added_31 bigint NOT NULL default 54 after b;
2453alter table bar add column added_2 bigint default -1 after b, add column added_31 bigint NOT NULL default 54 after b;
2454source include/diff_tables.inc;
2455drop table foo; drop table bar;
2456
2457
2458create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2459create table bar like foo;
2460alter table bar engine=MyISAM;
2461insert into foo values (NULL,NULL,NULL,NULL);
2462insert into foo values (-1,NULL,'2008-1-1',NULL);
2463insert into foo values (NULL,12345678987,NULL,1);
2464insert into foo values (2,20,'1999-11-11',0);
2465insert into bar select * from foo;
2466source include/diff_tables.inc;
2467alter table foo add column added_2 bigint default -1 after b, add column added_41 varchar(10) default NULL after b;
2468alter table bar add column added_2 bigint default -1 after b, add column added_41 varchar(10) default NULL after b;
2469source include/diff_tables.inc;
2470drop table foo; drop table bar;
2471
2472
2473create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2474create table bar like foo;
2475alter table bar engine=MyISAM;
2476insert into foo values (NULL,NULL,NULL,NULL);
2477insert into foo values (-1,NULL,'2008-1-1',NULL);
2478insert into foo values (NULL,12345678987,NULL,1);
2479insert into foo values (2,20,'1999-11-11',0);
2480insert into bar select * from foo;
2481source include/diff_tables.inc;
2482alter table foo add column added_2 bigint default -1 after b, add column added_51 varchar(10) default "abracadab" after b;
2483alter table bar add column added_2 bigint default -1 after b, add column added_51 varchar(10) default "abracadab" after b;
2484source include/diff_tables.inc;
2485drop table foo; drop table bar;
2486
2487
2488create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2489create table bar like foo;
2490alter table bar engine=MyISAM;
2491insert into foo values (NULL,NULL,NULL,NULL);
2492insert into foo values (-1,NULL,'2008-1-1',NULL);
2493insert into foo values (NULL,12345678987,NULL,1);
2494insert into foo values (2,20,'1999-11-11',0);
2495insert into bar select * from foo;
2496source include/diff_tables.inc;
2497alter table foo add column added_2 bigint default -1 after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2498alter table bar add column added_2 bigint default -1 after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2499source include/diff_tables.inc;
2500drop table foo; drop table bar;
2501
2502
2503create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2504create table bar like foo;
2505alter table bar engine=MyISAM;
2506insert into foo values (NULL,NULL,NULL,NULL);
2507insert into foo values (-1,NULL,'2008-1-1',NULL);
2508insert into foo values (NULL,12345678987,NULL,1);
2509insert into foo values (2,20,'1999-11-11',0);
2510insert into bar select * from foo;
2511source include/diff_tables.inc;
2512alter table foo add column added_2 bigint default -1 after b, add column added_71 text default NULL after b;
2513alter table bar add column added_2 bigint default -1 after b, add column added_71 text default NULL after b;
2514source include/diff_tables.inc;
2515drop table foo; drop table bar;
2516
2517
2518create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2519create table bar like foo;
2520alter table bar engine=MyISAM;
2521insert into foo values (NULL,NULL,NULL,NULL);
2522insert into foo values (-1,NULL,'2008-1-1',NULL);
2523insert into foo values (NULL,12345678987,NULL,1);
2524insert into foo values (2,20,'1999-11-11',0);
2525insert into bar select * from foo;
2526source include/diff_tables.inc;
2527alter table foo add column added_2 bigint default -1 after b, add column added_81 mediumtext default NULL after b;
2528alter table bar add column added_2 bigint default -1 after b, add column added_81 mediumtext default NULL after b;
2529source include/diff_tables.inc;
2530drop table foo; drop table bar;
2531
2532
2533create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2534create table bar like foo;
2535alter table bar engine=MyISAM;
2536insert into foo values (NULL,NULL,NULL,NULL);
2537insert into foo values (-1,NULL,'2008-1-1',NULL);
2538insert into foo values (NULL,12345678987,NULL,1);
2539insert into foo values (2,20,'1999-11-11',0);
2540insert into bar select * from foo;
2541source include/diff_tables.inc;
2542alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_11 bigint default NULL after b;
2543alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_11 bigint default NULL after b;
2544source include/diff_tables.inc;
2545drop table foo; drop table bar;
2546
2547
2548create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2549create table bar like foo;
2550alter table bar engine=MyISAM;
2551insert into foo values (NULL,NULL,NULL,NULL);
2552insert into foo values (-1,NULL,'2008-1-1',NULL);
2553insert into foo values (NULL,12345678987,NULL,1);
2554insert into foo values (2,20,'1999-11-11',0);
2555insert into bar select * from foo;
2556source include/diff_tables.inc;
2557alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_21 bigint default 1234 after b;
2558alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_21 bigint default 1234 after b;
2559source include/diff_tables.inc;
2560drop table foo; drop table bar;
2561
2562
2563create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2564create table bar like foo;
2565alter table bar engine=MyISAM;
2566insert into foo values (NULL,NULL,NULL,NULL);
2567insert into foo values (-1,NULL,'2008-1-1',NULL);
2568insert into foo values (NULL,12345678987,NULL,1);
2569insert into foo values (2,20,'1999-11-11',0);
2570insert into bar select * from foo;
2571source include/diff_tables.inc;
2572alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_31 bigint NOT NULL default 54 after b;
2573alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_31 bigint NOT NULL default 54 after b;
2574source include/diff_tables.inc;
2575drop table foo; drop table bar;
2576
2577
2578create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2579create table bar like foo;
2580alter table bar engine=MyISAM;
2581insert into foo values (NULL,NULL,NULL,NULL);
2582insert into foo values (-1,NULL,'2008-1-1',NULL);
2583insert into foo values (NULL,12345678987,NULL,1);
2584insert into foo values (2,20,'1999-11-11',0);
2585insert into bar select * from foo;
2586source include/diff_tables.inc;
2587alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_41 varchar(10) default NULL after b;
2588alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_41 varchar(10) default NULL after b;
2589source include/diff_tables.inc;
2590drop table foo; drop table bar;
2591
2592
2593create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2594create table bar like foo;
2595alter table bar engine=MyISAM;
2596insert into foo values (NULL,NULL,NULL,NULL);
2597insert into foo values (-1,NULL,'2008-1-1',NULL);
2598insert into foo values (NULL,12345678987,NULL,1);
2599insert into foo values (2,20,'1999-11-11',0);
2600insert into bar select * from foo;
2601source include/diff_tables.inc;
2602alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_51 varchar(10) default "abracadab" after b;
2603alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_51 varchar(10) default "abracadab" after b;
2604source include/diff_tables.inc;
2605drop table foo; drop table bar;
2606
2607
2608create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2609create table bar like foo;
2610alter table bar engine=MyISAM;
2611insert into foo values (NULL,NULL,NULL,NULL);
2612insert into foo values (-1,NULL,'2008-1-1',NULL);
2613insert into foo values (NULL,12345678987,NULL,1);
2614insert into foo values (2,20,'1999-11-11',0);
2615insert into bar select * from foo;
2616source include/diff_tables.inc;
2617alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2618alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2619source include/diff_tables.inc;
2620drop table foo; drop table bar;
2621
2622
2623create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2624create table bar like foo;
2625alter table bar engine=MyISAM;
2626insert into foo values (NULL,NULL,NULL,NULL);
2627insert into foo values (-1,NULL,'2008-1-1',NULL);
2628insert into foo values (NULL,12345678987,NULL,1);
2629insert into foo values (2,20,'1999-11-11',0);
2630insert into bar select * from foo;
2631source include/diff_tables.inc;
2632alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_71 text default NULL after b;
2633alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_71 text default NULL after b;
2634source include/diff_tables.inc;
2635drop table foo; drop table bar;
2636
2637
2638create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2639create table bar like foo;
2640alter table bar engine=MyISAM;
2641insert into foo values (NULL,NULL,NULL,NULL);
2642insert into foo values (-1,NULL,'2008-1-1',NULL);
2643insert into foo values (NULL,12345678987,NULL,1);
2644insert into foo values (2,20,'1999-11-11',0);
2645insert into bar select * from foo;
2646source include/diff_tables.inc;
2647alter table foo add column added_3 bigint NOT NULL default -1 after b, add column added_81 mediumtext default NULL after b;
2648alter table bar add column added_3 bigint NOT NULL default -1 after b, add column added_81 mediumtext default NULL after b;
2649source include/diff_tables.inc;
2650drop table foo; drop table bar;
2651
2652
2653create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2654create table bar like foo;
2655alter table bar engine=MyISAM;
2656insert into foo values (NULL,NULL,NULL,NULL);
2657insert into foo values (-1,NULL,'2008-1-1',NULL);
2658insert into foo values (NULL,12345678987,NULL,1);
2659insert into foo values (2,20,'1999-11-11',0);
2660insert into bar select * from foo;
2661source include/diff_tables.inc;
2662alter table foo add column added_4 varchar(10) default NULL after b, add column added_11 bigint default NULL after b;
2663alter table bar add column added_4 varchar(10) default NULL after b, add column added_11 bigint default NULL after b;
2664source include/diff_tables.inc;
2665drop table foo; drop table bar;
2666
2667
2668create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2669create table bar like foo;
2670alter table bar engine=MyISAM;
2671insert into foo values (NULL,NULL,NULL,NULL);
2672insert into foo values (-1,NULL,'2008-1-1',NULL);
2673insert into foo values (NULL,12345678987,NULL,1);
2674insert into foo values (2,20,'1999-11-11',0);
2675insert into bar select * from foo;
2676source include/diff_tables.inc;
2677alter table foo add column added_4 varchar(10) default NULL after b, add column added_21 bigint default 1234 after b;
2678alter table bar add column added_4 varchar(10) default NULL after b, add column added_21 bigint default 1234 after b;
2679source include/diff_tables.inc;
2680drop table foo; drop table bar;
2681
2682
2683create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2684create table bar like foo;
2685alter table bar engine=MyISAM;
2686insert into foo values (NULL,NULL,NULL,NULL);
2687insert into foo values (-1,NULL,'2008-1-1',NULL);
2688insert into foo values (NULL,12345678987,NULL,1);
2689insert into foo values (2,20,'1999-11-11',0);
2690insert into bar select * from foo;
2691source include/diff_tables.inc;
2692alter table foo add column added_4 varchar(10) default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
2693alter table bar add column added_4 varchar(10) default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
2694source include/diff_tables.inc;
2695drop table foo; drop table bar;
2696
2697
2698create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2699create table bar like foo;
2700alter table bar engine=MyISAM;
2701insert into foo values (NULL,NULL,NULL,NULL);
2702insert into foo values (-1,NULL,'2008-1-1',NULL);
2703insert into foo values (NULL,12345678987,NULL,1);
2704insert into foo values (2,20,'1999-11-11',0);
2705insert into bar select * from foo;
2706source include/diff_tables.inc;
2707alter table foo add column added_4 varchar(10) default NULL after b, add column added_41 varchar(10) default NULL after b;
2708alter table bar add column added_4 varchar(10) default NULL after b, add column added_41 varchar(10) default NULL after b;
2709source include/diff_tables.inc;
2710drop table foo; drop table bar;
2711
2712
2713create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2714create table bar like foo;
2715alter table bar engine=MyISAM;
2716insert into foo values (NULL,NULL,NULL,NULL);
2717insert into foo values (-1,NULL,'2008-1-1',NULL);
2718insert into foo values (NULL,12345678987,NULL,1);
2719insert into foo values (2,20,'1999-11-11',0);
2720insert into bar select * from foo;
2721source include/diff_tables.inc;
2722alter table foo add column added_4 varchar(10) default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
2723alter table bar add column added_4 varchar(10) default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
2724source include/diff_tables.inc;
2725drop table foo; drop table bar;
2726
2727
2728create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2729create table bar like foo;
2730alter table bar engine=MyISAM;
2731insert into foo values (NULL,NULL,NULL,NULL);
2732insert into foo values (-1,NULL,'2008-1-1',NULL);
2733insert into foo values (NULL,12345678987,NULL,1);
2734insert into foo values (2,20,'1999-11-11',0);
2735insert into bar select * from foo;
2736source include/diff_tables.inc;
2737alter table foo add column added_4 varchar(10) default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2738alter table bar add column added_4 varchar(10) default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2739source include/diff_tables.inc;
2740drop table foo; drop table bar;
2741
2742
2743create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2744create table bar like foo;
2745alter table bar engine=MyISAM;
2746insert into foo values (NULL,NULL,NULL,NULL);
2747insert into foo values (-1,NULL,'2008-1-1',NULL);
2748insert into foo values (NULL,12345678987,NULL,1);
2749insert into foo values (2,20,'1999-11-11',0);
2750insert into bar select * from foo;
2751source include/diff_tables.inc;
2752alter table foo add column added_4 varchar(10) default NULL after b, add column added_71 text default NULL after b;
2753alter table bar add column added_4 varchar(10) default NULL after b, add column added_71 text default NULL after b;
2754source include/diff_tables.inc;
2755drop table foo; drop table bar;
2756
2757
2758create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2759create table bar like foo;
2760alter table bar engine=MyISAM;
2761insert into foo values (NULL,NULL,NULL,NULL);
2762insert into foo values (-1,NULL,'2008-1-1',NULL);
2763insert into foo values (NULL,12345678987,NULL,1);
2764insert into foo values (2,20,'1999-11-11',0);
2765insert into bar select * from foo;
2766source include/diff_tables.inc;
2767alter table foo add column added_4 varchar(10) default NULL after b, add column added_81 mediumtext default NULL after b;
2768alter table bar add column added_4 varchar(10) default NULL after b, add column added_81 mediumtext default NULL after b;
2769source include/diff_tables.inc;
2770drop table foo; drop table bar;
2771
2772
2773create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2774create table bar like foo;
2775alter table bar engine=MyISAM;
2776insert into foo values (NULL,NULL,NULL,NULL);
2777insert into foo values (-1,NULL,'2008-1-1',NULL);
2778insert into foo values (NULL,12345678987,NULL,1);
2779insert into foo values (2,20,'1999-11-11',0);
2780insert into bar select * from foo;
2781source include/diff_tables.inc;
2782alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_11 bigint default NULL after b;
2783alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_11 bigint default NULL after b;
2784source include/diff_tables.inc;
2785drop table foo; drop table bar;
2786
2787
2788create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2789create table bar like foo;
2790alter table bar engine=MyISAM;
2791insert into foo values (NULL,NULL,NULL,NULL);
2792insert into foo values (-1,NULL,'2008-1-1',NULL);
2793insert into foo values (NULL,12345678987,NULL,1);
2794insert into foo values (2,20,'1999-11-11',0);
2795insert into bar select * from foo;
2796source include/diff_tables.inc;
2797alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_21 bigint default 1234 after b;
2798alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_21 bigint default 1234 after b;
2799source include/diff_tables.inc;
2800drop table foo; drop table bar;
2801
2802
2803create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2804create table bar like foo;
2805alter table bar engine=MyISAM;
2806insert into foo values (NULL,NULL,NULL,NULL);
2807insert into foo values (-1,NULL,'2008-1-1',NULL);
2808insert into foo values (NULL,12345678987,NULL,1);
2809insert into foo values (2,20,'1999-11-11',0);
2810insert into bar select * from foo;
2811source include/diff_tables.inc;
2812alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_31 bigint NOT NULL default 54 after b;
2813alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_31 bigint NOT NULL default 54 after b;
2814source include/diff_tables.inc;
2815drop table foo; drop table bar;
2816
2817
2818create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2819create table bar like foo;
2820alter table bar engine=MyISAM;
2821insert into foo values (NULL,NULL,NULL,NULL);
2822insert into foo values (-1,NULL,'2008-1-1',NULL);
2823insert into foo values (NULL,12345678987,NULL,1);
2824insert into foo values (2,20,'1999-11-11',0);
2825insert into bar select * from foo;
2826source include/diff_tables.inc;
2827alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_41 varchar(10) default NULL after b;
2828alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_41 varchar(10) default NULL after b;
2829source include/diff_tables.inc;
2830drop table foo; drop table bar;
2831
2832
2833create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2834create table bar like foo;
2835alter table bar engine=MyISAM;
2836insert into foo values (NULL,NULL,NULL,NULL);
2837insert into foo values (-1,NULL,'2008-1-1',NULL);
2838insert into foo values (NULL,12345678987,NULL,1);
2839insert into foo values (2,20,'1999-11-11',0);
2840insert into bar select * from foo;
2841source include/diff_tables.inc;
2842alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_51 varchar(10) default "abracadab" after b;
2843alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_51 varchar(10) default "abracadab" after b;
2844source include/diff_tables.inc;
2845drop table foo; drop table bar;
2846
2847
2848create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2849create table bar like foo;
2850alter table bar engine=MyISAM;
2851insert into foo values (NULL,NULL,NULL,NULL);
2852insert into foo values (-1,NULL,'2008-1-1',NULL);
2853insert into foo values (NULL,12345678987,NULL,1);
2854insert into foo values (2,20,'1999-11-11',0);
2855insert into bar select * from foo;
2856source include/diff_tables.inc;
2857alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2858alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2859source include/diff_tables.inc;
2860drop table foo; drop table bar;
2861
2862
2863create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2864create table bar like foo;
2865alter table bar engine=MyISAM;
2866insert into foo values (NULL,NULL,NULL,NULL);
2867insert into foo values (-1,NULL,'2008-1-1',NULL);
2868insert into foo values (NULL,12345678987,NULL,1);
2869insert into foo values (2,20,'1999-11-11',0);
2870insert into bar select * from foo;
2871source include/diff_tables.inc;
2872alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_71 text default NULL after b;
2873alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_71 text default NULL after b;
2874source include/diff_tables.inc;
2875drop table foo; drop table bar;
2876
2877
2878create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2879create table bar like foo;
2880alter table bar engine=MyISAM;
2881insert into foo values (NULL,NULL,NULL,NULL);
2882insert into foo values (-1,NULL,'2008-1-1',NULL);
2883insert into foo values (NULL,12345678987,NULL,1);
2884insert into foo values (2,20,'1999-11-11',0);
2885insert into bar select * from foo;
2886source include/diff_tables.inc;
2887alter table foo add column added_5 varchar(10) default "qwerty" after b, add column added_81 mediumtext default NULL after b;
2888alter table bar add column added_5 varchar(10) default "qwerty" after b, add column added_81 mediumtext default NULL after b;
2889source include/diff_tables.inc;
2890drop table foo; drop table bar;
2891
2892
2893create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2894create table bar like foo;
2895alter table bar engine=MyISAM;
2896insert into foo values (NULL,NULL,NULL,NULL);
2897insert into foo values (-1,NULL,'2008-1-1',NULL);
2898insert into foo values (NULL,12345678987,NULL,1);
2899insert into foo values (2,20,'1999-11-11',0);
2900insert into bar select * from foo;
2901source include/diff_tables.inc;
2902alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_11 bigint default NULL after b;
2903alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_11 bigint default NULL after b;
2904source include/diff_tables.inc;
2905drop table foo; drop table bar;
2906
2907
2908create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2909create table bar like foo;
2910alter table bar engine=MyISAM;
2911insert into foo values (NULL,NULL,NULL,NULL);
2912insert into foo values (-1,NULL,'2008-1-1',NULL);
2913insert into foo values (NULL,12345678987,NULL,1);
2914insert into foo values (2,20,'1999-11-11',0);
2915insert into bar select * from foo;
2916source include/diff_tables.inc;
2917alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_21 bigint default 1234 after b;
2918alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_21 bigint default 1234 after b;
2919source include/diff_tables.inc;
2920drop table foo; drop table bar;
2921
2922
2923create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2924create table bar like foo;
2925alter table bar engine=MyISAM;
2926insert into foo values (NULL,NULL,NULL,NULL);
2927insert into foo values (-1,NULL,'2008-1-1',NULL);
2928insert into foo values (NULL,12345678987,NULL,1);
2929insert into foo values (2,20,'1999-11-11',0);
2930insert into bar select * from foo;
2931source include/diff_tables.inc;
2932alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_31 bigint NOT NULL default 54 after b;
2933alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_31 bigint NOT NULL default 54 after b;
2934source include/diff_tables.inc;
2935drop table foo; drop table bar;
2936
2937
2938create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2939create table bar like foo;
2940alter table bar engine=MyISAM;
2941insert into foo values (NULL,NULL,NULL,NULL);
2942insert into foo values (-1,NULL,'2008-1-1',NULL);
2943insert into foo values (NULL,12345678987,NULL,1);
2944insert into foo values (2,20,'1999-11-11',0);
2945insert into bar select * from foo;
2946source include/diff_tables.inc;
2947alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_41 varchar(10) default NULL after b;
2948alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_41 varchar(10) default NULL after b;
2949source include/diff_tables.inc;
2950drop table foo; drop table bar;
2951
2952
2953create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2954create table bar like foo;
2955alter table bar engine=MyISAM;
2956insert into foo values (NULL,NULL,NULL,NULL);
2957insert into foo values (-1,NULL,'2008-1-1',NULL);
2958insert into foo values (NULL,12345678987,NULL,1);
2959insert into foo values (2,20,'1999-11-11',0);
2960insert into bar select * from foo;
2961source include/diff_tables.inc;
2962alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_51 varchar(10) default "abracadab" after b;
2963alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_51 varchar(10) default "abracadab" after b;
2964source include/diff_tables.inc;
2965drop table foo; drop table bar;
2966
2967
2968create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2969create table bar like foo;
2970alter table bar engine=MyISAM;
2971insert into foo values (NULL,NULL,NULL,NULL);
2972insert into foo values (-1,NULL,'2008-1-1',NULL);
2973insert into foo values (NULL,12345678987,NULL,1);
2974insert into foo values (2,20,'1999-11-11',0);
2975insert into bar select * from foo;
2976source include/diff_tables.inc;
2977alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2978alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
2979source include/diff_tables.inc;
2980drop table foo; drop table bar;
2981
2982
2983create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2984create table bar like foo;
2985alter table bar engine=MyISAM;
2986insert into foo values (NULL,NULL,NULL,NULL);
2987insert into foo values (-1,NULL,'2008-1-1',NULL);
2988insert into foo values (NULL,12345678987,NULL,1);
2989insert into foo values (2,20,'1999-11-11',0);
2990insert into bar select * from foo;
2991source include/diff_tables.inc;
2992alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_71 text default NULL after b;
2993alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_71 text default NULL after b;
2994source include/diff_tables.inc;
2995drop table foo; drop table bar;
2996
2997
2998create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
2999create table bar like foo;
3000alter table bar engine=MyISAM;
3001insert into foo values (NULL,NULL,NULL,NULL);
3002insert into foo values (-1,NULL,'2008-1-1',NULL);
3003insert into foo values (NULL,12345678987,NULL,1);
3004insert into foo values (2,20,'1999-11-11',0);
3005insert into bar select * from foo;
3006source include/diff_tables.inc;
3007alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_81 mediumtext default NULL after b;
3008alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after b, add column added_81 mediumtext default NULL after b;
3009source include/diff_tables.inc;
3010drop table foo; drop table bar;
3011
3012
3013create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3014create table bar like foo;
3015alter table bar engine=MyISAM;
3016insert into foo values (NULL,NULL,NULL,NULL);
3017insert into foo values (-1,NULL,'2008-1-1',NULL);
3018insert into foo values (NULL,12345678987,NULL,1);
3019insert into foo values (2,20,'1999-11-11',0);
3020insert into bar select * from foo;
3021source include/diff_tables.inc;
3022alter table foo add column added_7 text default NULL after b, add column added_11 bigint default NULL after b;
3023alter table bar add column added_7 text default NULL after b, add column added_11 bigint default NULL after b;
3024source include/diff_tables.inc;
3025drop table foo; drop table bar;
3026
3027
3028create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3029create table bar like foo;
3030alter table bar engine=MyISAM;
3031insert into foo values (NULL,NULL,NULL,NULL);
3032insert into foo values (-1,NULL,'2008-1-1',NULL);
3033insert into foo values (NULL,12345678987,NULL,1);
3034insert into foo values (2,20,'1999-11-11',0);
3035insert into bar select * from foo;
3036source include/diff_tables.inc;
3037alter table foo add column added_7 text default NULL after b, add column added_21 bigint default 1234 after b;
3038alter table bar add column added_7 text default NULL after b, add column added_21 bigint default 1234 after b;
3039source include/diff_tables.inc;
3040drop table foo; drop table bar;
3041
3042
3043create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3044create table bar like foo;
3045alter table bar engine=MyISAM;
3046insert into foo values (NULL,NULL,NULL,NULL);
3047insert into foo values (-1,NULL,'2008-1-1',NULL);
3048insert into foo values (NULL,12345678987,NULL,1);
3049insert into foo values (2,20,'1999-11-11',0);
3050insert into bar select * from foo;
3051source include/diff_tables.inc;
3052alter table foo add column added_7 text default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
3053alter table bar add column added_7 text default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
3054source include/diff_tables.inc;
3055drop table foo; drop table bar;
3056
3057
3058create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3059create table bar like foo;
3060alter table bar engine=MyISAM;
3061insert into foo values (NULL,NULL,NULL,NULL);
3062insert into foo values (-1,NULL,'2008-1-1',NULL);
3063insert into foo values (NULL,12345678987,NULL,1);
3064insert into foo values (2,20,'1999-11-11',0);
3065insert into bar select * from foo;
3066source include/diff_tables.inc;
3067alter table foo add column added_7 text default NULL after b, add column added_41 varchar(10) default NULL after b;
3068alter table bar add column added_7 text default NULL after b, add column added_41 varchar(10) default NULL after b;
3069source include/diff_tables.inc;
3070drop table foo; drop table bar;
3071
3072
3073create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3074create table bar like foo;
3075alter table bar engine=MyISAM;
3076insert into foo values (NULL,NULL,NULL,NULL);
3077insert into foo values (-1,NULL,'2008-1-1',NULL);
3078insert into foo values (NULL,12345678987,NULL,1);
3079insert into foo values (2,20,'1999-11-11',0);
3080insert into bar select * from foo;
3081source include/diff_tables.inc;
3082alter table foo add column added_7 text default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
3083alter table bar add column added_7 text default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
3084source include/diff_tables.inc;
3085drop table foo; drop table bar;
3086
3087
3088create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3089create table bar like foo;
3090alter table bar engine=MyISAM;
3091insert into foo values (NULL,NULL,NULL,NULL);
3092insert into foo values (-1,NULL,'2008-1-1',NULL);
3093insert into foo values (NULL,12345678987,NULL,1);
3094insert into foo values (2,20,'1999-11-11',0);
3095insert into bar select * from foo;
3096source include/diff_tables.inc;
3097alter table foo add column added_7 text default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
3098alter table bar add column added_7 text default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
3099source include/diff_tables.inc;
3100drop table foo; drop table bar;
3101
3102
3103create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3104create table bar like foo;
3105alter table bar engine=MyISAM;
3106insert into foo values (NULL,NULL,NULL,NULL);
3107insert into foo values (-1,NULL,'2008-1-1',NULL);
3108insert into foo values (NULL,12345678987,NULL,1);
3109insert into foo values (2,20,'1999-11-11',0);
3110insert into bar select * from foo;
3111source include/diff_tables.inc;
3112alter table foo add column added_7 text default NULL after b, add column added_71 text default NULL after b;
3113alter table bar add column added_7 text default NULL after b, add column added_71 text default NULL after b;
3114source include/diff_tables.inc;
3115drop table foo; drop table bar;
3116
3117
3118create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3119create table bar like foo;
3120alter table bar engine=MyISAM;
3121insert into foo values (NULL,NULL,NULL,NULL);
3122insert into foo values (-1,NULL,'2008-1-1',NULL);
3123insert into foo values (NULL,12345678987,NULL,1);
3124insert into foo values (2,20,'1999-11-11',0);
3125insert into bar select * from foo;
3126source include/diff_tables.inc;
3127alter table foo add column added_7 text default NULL after b, add column added_81 mediumtext default NULL after b;
3128alter table bar add column added_7 text default NULL after b, add column added_81 mediumtext default NULL after b;
3129source include/diff_tables.inc;
3130drop table foo; drop table bar;
3131
3132
3133create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3134create table bar like foo;
3135alter table bar engine=MyISAM;
3136insert into foo values (NULL,NULL,NULL,NULL);
3137insert into foo values (-1,NULL,'2008-1-1',NULL);
3138insert into foo values (NULL,12345678987,NULL,1);
3139insert into foo values (2,20,'1999-11-11',0);
3140insert into bar select * from foo;
3141source include/diff_tables.inc;
3142alter table foo add column added_8 mediumtext default NULL after b, add column added_11 bigint default NULL after b;
3143alter table bar add column added_8 mediumtext default NULL after b, add column added_11 bigint default NULL after b;
3144source include/diff_tables.inc;
3145drop table foo; drop table bar;
3146
3147
3148create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3149create table bar like foo;
3150alter table bar engine=MyISAM;
3151insert into foo values (NULL,NULL,NULL,NULL);
3152insert into foo values (-1,NULL,'2008-1-1',NULL);
3153insert into foo values (NULL,12345678987,NULL,1);
3154insert into foo values (2,20,'1999-11-11',0);
3155insert into bar select * from foo;
3156source include/diff_tables.inc;
3157alter table foo add column added_8 mediumtext default NULL after b, add column added_21 bigint default 1234 after b;
3158alter table bar add column added_8 mediumtext default NULL after b, add column added_21 bigint default 1234 after b;
3159source include/diff_tables.inc;
3160drop table foo; drop table bar;
3161
3162
3163create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3164create table bar like foo;
3165alter table bar engine=MyISAM;
3166insert into foo values (NULL,NULL,NULL,NULL);
3167insert into foo values (-1,NULL,'2008-1-1',NULL);
3168insert into foo values (NULL,12345678987,NULL,1);
3169insert into foo values (2,20,'1999-11-11',0);
3170insert into bar select * from foo;
3171source include/diff_tables.inc;
3172alter table foo add column added_8 mediumtext default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
3173alter table bar add column added_8 mediumtext default NULL after b, add column added_31 bigint NOT NULL default 54 after b;
3174source include/diff_tables.inc;
3175drop table foo; drop table bar;
3176
3177
3178create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3179create table bar like foo;
3180alter table bar engine=MyISAM;
3181insert into foo values (NULL,NULL,NULL,NULL);
3182insert into foo values (-1,NULL,'2008-1-1',NULL);
3183insert into foo values (NULL,12345678987,NULL,1);
3184insert into foo values (2,20,'1999-11-11',0);
3185insert into bar select * from foo;
3186source include/diff_tables.inc;
3187alter table foo add column added_8 mediumtext default NULL after b, add column added_41 varchar(10) default NULL after b;
3188alter table bar add column added_8 mediumtext default NULL after b, add column added_41 varchar(10) default NULL after b;
3189source include/diff_tables.inc;
3190drop table foo; drop table bar;
3191
3192
3193create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3194create table bar like foo;
3195alter table bar engine=MyISAM;
3196insert into foo values (NULL,NULL,NULL,NULL);
3197insert into foo values (-1,NULL,'2008-1-1',NULL);
3198insert into foo values (NULL,12345678987,NULL,1);
3199insert into foo values (2,20,'1999-11-11',0);
3200insert into bar select * from foo;
3201source include/diff_tables.inc;
3202alter table foo add column added_8 mediumtext default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
3203alter table bar add column added_8 mediumtext default NULL after b, add column added_51 varchar(10) default "abracadab" after b;
3204source include/diff_tables.inc;
3205drop table foo; drop table bar;
3206
3207
3208create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3209create table bar like foo;
3210alter table bar engine=MyISAM;
3211insert into foo values (NULL,NULL,NULL,NULL);
3212insert into foo values (-1,NULL,'2008-1-1',NULL);
3213insert into foo values (NULL,12345678987,NULL,1);
3214insert into foo values (2,20,'1999-11-11',0);
3215insert into bar select * from foo;
3216source include/diff_tables.inc;
3217alter table foo add column added_8 mediumtext default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
3218alter table bar add column added_8 mediumtext default NULL after b, add column added_61 varchar(10) NOT NULL default "abracadab" after b;
3219source include/diff_tables.inc;
3220drop table foo; drop table bar;
3221
3222
3223create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3224create table bar like foo;
3225alter table bar engine=MyISAM;
3226insert into foo values (NULL,NULL,NULL,NULL);
3227insert into foo values (-1,NULL,'2008-1-1',NULL);
3228insert into foo values (NULL,12345678987,NULL,1);
3229insert into foo values (2,20,'1999-11-11',0);
3230insert into bar select * from foo;
3231source include/diff_tables.inc;
3232alter table foo add column added_8 mediumtext default NULL after b, add column added_71 text default NULL after b;
3233alter table bar add column added_8 mediumtext default NULL after b, add column added_71 text default NULL after b;
3234source include/diff_tables.inc;
3235drop table foo; drop table bar;
3236
3237
3238create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3239create table bar like foo;
3240alter table bar engine=MyISAM;
3241insert into foo values (NULL,NULL,NULL,NULL);
3242insert into foo values (-1,NULL,'2008-1-1',NULL);
3243insert into foo values (NULL,12345678987,NULL,1);
3244insert into foo values (2,20,'1999-11-11',0);
3245insert into bar select * from foo;
3246source include/diff_tables.inc;
3247alter table foo add column added_8 mediumtext default NULL after b, add column added_81 mediumtext default NULL after b;
3248alter table bar add column added_8 mediumtext default NULL after b, add column added_81 mediumtext default NULL after b;
3249source include/diff_tables.inc;
3250drop table foo; drop table bar;
3251
3252
3253create table foo (a int, b bigint, c date, d tinyint) engine=TokuDB;
3254create table bar like foo;
3255alter table bar engine=MyISAM;
3256insert into foo values (NULL,NULL,NULL,NULL);
3257insert into foo values (-1,NULL,'2008-1-1',NULL);
3258insert into foo values (NULL,12345678987,NULL,1);
3259insert into foo values (2,20,'1999-11-11',0);
3260insert into bar select * from foo;
3261source include/diff_tables.inc;
3262alter table foo add column added_1 bigint default NULL, add column added_2 bigint default -1 after b, add column added_3 bigint NOT NULL default -1;
3263alter table bar add column added_1 bigint default NULL, add column added_2 bigint default -1 after b, add column added_3 bigint NOT NULL default -1;
3264source include/diff_tables.inc;
3265drop table foo; drop table bar;
3266