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