← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_varblob_drop.test

  • Committer: Package Import Robot
  • Author(s): James Page, Otto Kekäläinen
  • Date: 2014-02-17 16:51:52 UTC
  • mfrom: (2.1.1 sid)
  • Revision ID: package-import@ubuntu.com-20140217165152-k315d3175g865kkx
Tags: 5.5.35-1
http://bugs.debian.org/737597
http://bugs.debian.org/733002
http://bugs.debian.org/734426
http://bugs.debian.org/735284
http://bugs.debian.org/736480
http://bugs.debian.org/732967
[ Otto Kekäläinen ]
* New upstream release, fixing the following security issues:
  - Buffer overflow in client/mysql.cc (Closes: #737597).
    - CVE-2014-0001
  - http://www.oracle.com/technetwork/topics/security/cpujan2014-1972949.html
    - CVE-2013-5891
    - CVE-2013-5908
    - CVE-2014-0386
    - CVE-2014-0393
    - CVE-2014-0401
    - CVE-2014-0402
    - CVE-2014-0412
    - CVE-2014-0420
    - CVE-2014-0437
* Upstream https://mariadb.atlassian.net/browse/MDEV-4902
  fixes compatibility with Bison 3.0 (Closes: #733002)
* Updated Russian debconf translation (Closes: #734426)
* Updated Japanese debconf translation (Closes: #735284)
* Updated French debconf translation (Closes: #736480)
* Renamed SONAME properly (Closes: #732967)

Show diffs side-by-side

added added

removed removed

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