2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
6
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
9
ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
11
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
12
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
13
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
14
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
16
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
17
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
19
ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
21
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
22
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
24
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
26
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
27
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29
ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
31
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
32
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
33
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
34
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
36
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
37
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39
ALTER TABLE t1 ADD c4 BIT NULL AFTER c2;
41
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
42
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
43
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
44
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
46
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
47
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
49
ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
51
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
52
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
53
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
54
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
56
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
57
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
59
ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
61
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
62
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
63
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
64
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
66
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
69
ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
71
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
72
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
73
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
74
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
76
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
77
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
79
ALTER TABLE t1 ADD c4 BIT NOT NULL AFTER c2;
81
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
82
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
83
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
84
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
86
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
87
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89
ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
91
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
92
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
94
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
96
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
97
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
99
ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
101
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
102
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
103
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
104
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
106
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
107
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
108
SHOW CREATE TABLE t1;
109
ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
111
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
112
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
113
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
114
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
116
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
117
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
118
SHOW CREATE TABLE t1;
119
ALTER TABLE t1 ADD c4 TINYINT NULL AFTER c2;
121
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
122
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
123
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
124
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
126
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
127
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
128
SHOW CREATE TABLE t1;
129
ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
131
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
132
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
133
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
134
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
136
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
137
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138
SHOW CREATE TABLE t1;
139
ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
141
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
142
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
143
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
144
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
146
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
147
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
148
SHOW CREATE TABLE t1;
149
ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
151
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
152
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
153
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
154
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
156
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
157
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
158
SHOW CREATE TABLE t1;
159
ALTER TABLE t1 ADD c4 TINYINT NOT NULL AFTER c2;
161
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
162
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
163
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
164
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
166
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
167
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
168
SHOW CREATE TABLE t1;
169
ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
171
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
172
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
173
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
174
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
176
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
177
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
178
SHOW CREATE TABLE t1;
179
ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
181
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
182
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
183
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
184
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
186
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
187
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
188
SHOW CREATE TABLE t1;
189
ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
191
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
192
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
193
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
194
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
196
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
197
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
198
SHOW CREATE TABLE t1;
199
ALTER TABLE t1 ADD c4 SMALLINT NULL AFTER c2;
201
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
202
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
203
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
204
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
206
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
207
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
208
SHOW CREATE TABLE t1;
209
ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
211
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
212
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
213
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
214
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
216
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
217
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
218
SHOW CREATE TABLE t1;
219
ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
221
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
222
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
223
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
224
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
226
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
227
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
228
SHOW CREATE TABLE t1;
229
ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
231
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
232
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
233
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
234
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
236
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
237
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
238
SHOW CREATE TABLE t1;
239
ALTER TABLE t1 ADD c4 SMALLINT NOT NULL AFTER c2;
241
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
242
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
243
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
244
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
246
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
247
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
248
SHOW CREATE TABLE t1;
249
ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
251
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
252
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
253
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
254
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
256
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
257
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
258
SHOW CREATE TABLE t1;
259
ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
261
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
262
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
263
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
264
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
266
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
267
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
268
SHOW CREATE TABLE t1;
269
ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
271
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
272
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
273
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
274
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
276
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
277
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
278
SHOW CREATE TABLE t1;
279
ALTER TABLE t1 ADD c4 MEDIUMINT NULL AFTER c2;
281
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
282
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
283
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
284
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
286
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
287
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
288
SHOW CREATE TABLE t1;
289
ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
291
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
292
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
293
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
294
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
296
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
297
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
298
SHOW CREATE TABLE t1;
299
ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
301
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
302
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
303
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
304
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
306
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
307
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
308
SHOW CREATE TABLE t1;
309
ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
311
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
312
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
313
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
314
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
316
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
317
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
318
SHOW CREATE TABLE t1;
319
ALTER TABLE t1 ADD c4 MEDIUMINT NOT NULL AFTER c2;
321
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
322
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
323
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
324
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
326
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
327
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
328
SHOW CREATE TABLE t1;
329
ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
331
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
332
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
333
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
334
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
336
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
337
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
338
SHOW CREATE TABLE t1;
339
ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
341
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
342
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
343
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
344
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
346
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
347
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
348
SHOW CREATE TABLE t1;
349
ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
351
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
352
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
353
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
354
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
356
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
357
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
358
SHOW CREATE TABLE t1;
359
ALTER TABLE t1 ADD c4 INT NULL AFTER c2;
361
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
362
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
363
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
364
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
366
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
367
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
368
SHOW CREATE TABLE t1;
369
ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
371
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
372
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
373
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
374
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
376
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
377
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
378
SHOW CREATE TABLE t1;
379
ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
381
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
382
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
383
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
384
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
386
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
387
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
388
SHOW CREATE TABLE t1;
389
ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
391
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
392
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
393
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
394
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
396
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
397
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
398
SHOW CREATE TABLE t1;
399
ALTER TABLE t1 ADD c4 INT NOT NULL AFTER c2;
401
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
402
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
403
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
404
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
406
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
407
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
408
SHOW CREATE TABLE t1;
409
ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
411
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
412
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
413
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
414
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
416
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
417
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
418
SHOW CREATE TABLE t1;
419
ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
421
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
422
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
423
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
424
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
426
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
427
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
428
SHOW CREATE TABLE t1;
429
ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
431
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
432
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
433
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
434
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
436
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
437
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
438
SHOW CREATE TABLE t1;
439
ALTER TABLE t1 ADD c4 INTEGER NULL AFTER c2;
441
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
442
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
443
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
444
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
446
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
447
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
448
SHOW CREATE TABLE t1;
449
ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
451
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
452
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
453
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
454
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
456
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
457
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
458
SHOW CREATE TABLE t1;
459
ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
461
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
462
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
463
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
464
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
466
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
467
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
468
SHOW CREATE TABLE t1;
469
ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
471
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
472
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
473
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
474
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
476
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
477
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
478
SHOW CREATE TABLE t1;
479
ALTER TABLE t1 ADD c4 INTEGER NOT NULL AFTER c2;
481
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
482
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
483
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
484
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
486
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
487
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
488
SHOW CREATE TABLE t1;
489
ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
491
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
492
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
493
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
494
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
496
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
497
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
498
SHOW CREATE TABLE t1;
499
ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
501
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
502
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
503
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
504
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
506
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
507
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
508
SHOW CREATE TABLE t1;
509
ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
511
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
512
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
513
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
514
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
516
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
517
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
518
SHOW CREATE TABLE t1;
519
ALTER TABLE t1 ADD c4 BIGINT NULL AFTER c2;
521
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
522
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
523
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
524
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
526
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
527
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
528
SHOW CREATE TABLE t1;
529
ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
531
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
532
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
533
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
534
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
536
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
537
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
538
SHOW CREATE TABLE t1;
539
ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
541
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
542
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
543
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
544
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
546
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
547
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
548
SHOW CREATE TABLE t1;
549
ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
551
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
552
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
553
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
554
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
556
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
557
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
558
SHOW CREATE TABLE t1;
559
ALTER TABLE t1 ADD c4 BIGINT NOT NULL AFTER c2;
561
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
562
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
563
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
564
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
566
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
567
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
568
SHOW CREATE TABLE t1;
569
ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
571
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
572
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
573
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
574
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
576
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
577
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
578
SHOW CREATE TABLE t1;
579
ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
581
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
582
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
583
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
584
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
586
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
587
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
588
SHOW CREATE TABLE t1;
589
ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
591
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
592
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
593
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
594
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
596
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
597
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
598
SHOW CREATE TABLE t1;
599
ALTER TABLE t1 ADD c4 REAL NULL AFTER c2;
601
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
602
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
603
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
604
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
606
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
607
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
608
SHOW CREATE TABLE t1;
609
ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
611
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
612
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
613
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
614
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
616
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
617
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
618
SHOW CREATE TABLE t1;
619
ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
621
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
622
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
623
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
624
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
626
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
627
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
628
SHOW CREATE TABLE t1;
629
ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
631
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
632
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
633
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
634
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
636
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
637
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
638
SHOW CREATE TABLE t1;
639
ALTER TABLE t1 ADD c4 REAL NOT NULL AFTER c2;
641
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
642
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
643
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
644
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
646
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
647
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
648
SHOW CREATE TABLE t1;
649
ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
651
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
652
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
653
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
654
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
656
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
657
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
658
SHOW CREATE TABLE t1;
659
ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
661
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
662
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
663
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
664
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
666
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
667
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
668
SHOW CREATE TABLE t1;
669
ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
671
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
672
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
673
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
674
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
676
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
677
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
678
SHOW CREATE TABLE t1;
679
ALTER TABLE t1 ADD c4 DOUBLE NULL AFTER c2;
681
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
682
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
683
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
684
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
686
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
687
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
688
SHOW CREATE TABLE t1;
689
ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
691
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
692
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
693
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
694
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
696
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
697
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
698
SHOW CREATE TABLE t1;
699
ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
701
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
702
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
703
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
704
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
706
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
707
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
708
SHOW CREATE TABLE t1;
709
ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
711
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
712
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
713
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
714
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
716
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
717
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
718
SHOW CREATE TABLE t1;
719
ALTER TABLE t1 ADD c4 DOUBLE NOT NULL AFTER c2;
721
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
722
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
723
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
724
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
726
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
727
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
728
SHOW CREATE TABLE t1;
729
ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
731
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
732
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
733
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
734
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
736
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
737
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
738
SHOW CREATE TABLE t1;
739
ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
741
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
742
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
743
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
744
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
746
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
747
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
748
SHOW CREATE TABLE t1;
749
ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
751
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
752
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
753
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
754
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
756
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
757
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
758
SHOW CREATE TABLE t1;
759
ALTER TABLE t1 ADD c4 FLOAT NULL AFTER c2;
761
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
762
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
763
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
764
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
766
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
767
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
768
SHOW CREATE TABLE t1;
769
ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
771
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
772
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
773
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
774
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
776
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
777
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
778
SHOW CREATE TABLE t1;
779
ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
781
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
782
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
783
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
784
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
786
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
787
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
788
SHOW CREATE TABLE t1;
789
ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
791
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
792
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
793
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
794
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
796
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
797
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
798
SHOW CREATE TABLE t1;
799
ALTER TABLE t1 ADD c4 FLOAT NOT NULL AFTER c2;
801
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
802
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
803
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
804
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
806
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
807
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
808
SHOW CREATE TABLE t1;
809
ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
811
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
812
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
813
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
814
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
816
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
817
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
818
SHOW CREATE TABLE t1;
819
ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
821
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
822
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
823
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
824
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
826
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
827
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
828
SHOW CREATE TABLE t1;
829
ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
831
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
832
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
833
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
834
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
836
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
837
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
838
SHOW CREATE TABLE t1;
839
ALTER TABLE t1 ADD c4 DECIMAL NULL AFTER c2;
841
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
842
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
843
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
844
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
846
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
847
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
848
SHOW CREATE TABLE t1;
849
ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
851
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
852
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
853
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
854
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
856
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
857
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
858
SHOW CREATE TABLE t1;
859
ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
861
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
862
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
863
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
864
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
866
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
867
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
868
SHOW CREATE TABLE t1;
869
ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
871
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
872
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
873
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
874
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
876
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
877
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
878
SHOW CREATE TABLE t1;
879
ALTER TABLE t1 ADD c4 DECIMAL NOT NULL AFTER c2;
881
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
882
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
883
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
884
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
886
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
887
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
888
SHOW CREATE TABLE t1;
889
ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
891
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
892
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
893
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
894
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
896
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
897
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
898
SHOW CREATE TABLE t1;
899
ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
901
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
902
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
903
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
904
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
906
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
907
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
908
SHOW CREATE TABLE t1;
909
ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
911
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
912
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
913
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
914
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
916
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
917
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
918
SHOW CREATE TABLE t1;
919
ALTER TABLE t1 ADD c4 NUMERIC NULL AFTER c2;
921
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
922
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
923
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
924
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
926
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
927
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
928
SHOW CREATE TABLE t1;
929
ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
931
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
932
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
933
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
934
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
936
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
937
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
938
SHOW CREATE TABLE t1;
939
ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
941
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
942
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
943
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
944
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
946
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
947
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
948
SHOW CREATE TABLE t1;
949
ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
951
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
952
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
953
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
954
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
956
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
957
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
958
SHOW CREATE TABLE t1;
959
ALTER TABLE t1 ADD c4 NUMERIC NOT NULL AFTER c2;
961
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
962
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
963
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
964
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
966
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
967
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
968
SHOW CREATE TABLE t1;
969
ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
971
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
972
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
973
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
974
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
976
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
977
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
978
SHOW CREATE TABLE t1;
979
ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
981
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
982
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
983
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
984
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
986
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
987
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
988
SHOW CREATE TABLE t1;
989
ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
991
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
992
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
993
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
994
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
996
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
997
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
998
SHOW CREATE TABLE t1;
999
ALTER TABLE t1 ADD c4 DATE NULL AFTER c2;
1001
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1002
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1003
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1004
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1006
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1007
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1008
SHOW CREATE TABLE t1;
1009
ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
1011
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1012
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1013
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1014
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1016
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1017
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1018
SHOW CREATE TABLE t1;
1019
ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
1021
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1022
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1023
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1024
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1026
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1027
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1028
SHOW CREATE TABLE t1;
1029
ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
1031
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1032
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1033
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1034
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1036
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1037
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1038
SHOW CREATE TABLE t1;
1039
ALTER TABLE t1 ADD c4 DATE NOT NULL AFTER c2;
1041
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1042
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1043
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1044
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1046
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1047
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1048
SHOW CREATE TABLE t1;
1049
ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
1051
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1052
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1053
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1054
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1056
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1057
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1058
SHOW CREATE TABLE t1;
1059
ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
1061
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1062
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1063
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1064
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1066
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1067
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1068
SHOW CREATE TABLE t1;
1069
ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
1071
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1072
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1073
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1074
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1076
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1077
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1078
SHOW CREATE TABLE t1;
1079
ALTER TABLE t1 ADD c4 TIME NULL AFTER c2;
1081
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1082
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1083
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1084
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1086
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1087
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1088
SHOW CREATE TABLE t1;
1089
ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
1091
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1092
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1093
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1094
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1096
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1097
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1098
SHOW CREATE TABLE t1;
1099
ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
1101
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1102
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1103
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1104
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1106
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1107
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1108
SHOW CREATE TABLE t1;
1109
ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
1111
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1112
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1113
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1114
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1116
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1117
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1118
SHOW CREATE TABLE t1;
1119
ALTER TABLE t1 ADD c4 TIME NOT NULL AFTER c2;
1121
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1122
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1123
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1124
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1126
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1127
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1128
SHOW CREATE TABLE t1;
1129
ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
1131
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1132
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1133
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1134
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1136
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1137
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1138
SHOW CREATE TABLE t1;
1139
ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
1141
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1142
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1143
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1144
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1146
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1147
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1148
SHOW CREATE TABLE t1;
1149
ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
1151
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1152
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1153
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1154
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1156
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1157
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1158
SHOW CREATE TABLE t1;
1159
ALTER TABLE t1 ADD c4 TIMESTAMP NULL AFTER c2;
1161
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1162
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1163
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1164
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1166
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1167
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1168
SHOW CREATE TABLE t1;
1169
ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
1171
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1172
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1173
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1174
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1176
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1177
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1178
SHOW CREATE TABLE t1;
1179
ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
1181
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1182
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1183
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1184
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1186
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1187
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1188
SHOW CREATE TABLE t1;
1189
ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
1191
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1192
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1193
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1194
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1196
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1197
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1198
SHOW CREATE TABLE t1;
1199
ALTER TABLE t1 ADD c4 TIMESTAMP NOT NULL AFTER c2;
1201
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1202
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1203
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1204
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1206
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1207
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1208
SHOW CREATE TABLE t1;
1209
ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
1211
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1212
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1213
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1214
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1216
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1217
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1218
SHOW CREATE TABLE t1;
1219
ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
1221
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1222
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1223
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1224
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1226
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1227
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1228
SHOW CREATE TABLE t1;
1229
ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
1231
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1232
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1233
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1234
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1236
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1237
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1238
SHOW CREATE TABLE t1;
1239
ALTER TABLE t1 ADD c4 YEAR NULL AFTER c2;
1241
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1242
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1243
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1244
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1246
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1247
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1248
SHOW CREATE TABLE t1;
1249
ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
1251
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1252
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1253
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1254
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1256
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1257
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1258
SHOW CREATE TABLE t1;
1259
ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
1261
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1262
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1263
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1264
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1266
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1267
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1268
SHOW CREATE TABLE t1;
1269
ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
1271
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1272
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1273
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1274
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1276
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1277
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1278
SHOW CREATE TABLE t1;
1279
ALTER TABLE t1 ADD c4 YEAR NOT NULL AFTER c2;
1281
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1282
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1283
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1284
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1286
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1287
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1288
SHOW CREATE TABLE t1;
1289
ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
1291
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1292
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1293
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1294
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1296
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1297
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1298
SHOW CREATE TABLE t1;
1299
ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
1301
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1302
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1303
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1304
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1306
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1307
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1308
SHOW CREATE TABLE t1;
1309
ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
1311
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1312
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1313
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1314
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1316
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1317
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1318
SHOW CREATE TABLE t1;
1319
ALTER TABLE t1 ADD c4 TINYBLOB NULL AFTER c2;
1321
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1322
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1323
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1324
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1326
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1327
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1328
SHOW CREATE TABLE t1;
1329
ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
1331
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1332
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1333
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1334
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1336
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1337
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1338
SHOW CREATE TABLE t1;
1339
ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
1341
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1342
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1343
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1344
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1346
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1347
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1348
SHOW CREATE TABLE t1;
1349
ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
1351
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1352
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1353
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1354
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1356
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1357
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1358
SHOW CREATE TABLE t1;
1359
ALTER TABLE t1 ADD c4 TINYBLOB NOT NULL AFTER c2;
1361
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1362
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1363
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1364
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1366
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1367
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1368
SHOW CREATE TABLE t1;
1369
ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
1371
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1372
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1373
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1374
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1376
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1377
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1378
SHOW CREATE TABLE t1;
1379
ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
1381
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1382
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1383
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1384
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1386
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1387
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1388
SHOW CREATE TABLE t1;
1389
ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
1391
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1392
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1393
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1394
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1396
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1397
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1398
SHOW CREATE TABLE t1;
1399
ALTER TABLE t1 ADD c4 BLOB NULL AFTER c2;
1401
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1402
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1403
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1404
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1406
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1407
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1408
SHOW CREATE TABLE t1;
1409
ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
1411
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1412
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1413
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1414
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1416
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1417
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1418
SHOW CREATE TABLE t1;
1419
ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
1421
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1422
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1423
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1424
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1426
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1427
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1428
SHOW CREATE TABLE t1;
1429
ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
1431
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1432
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1433
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1434
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1436
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1437
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1438
SHOW CREATE TABLE t1;
1439
ALTER TABLE t1 ADD c4 BLOB NOT NULL AFTER c2;
1441
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1442
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1443
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1444
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1446
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1447
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1448
SHOW CREATE TABLE t1;
1449
ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
1451
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1452
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1453
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1454
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1456
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1457
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1458
SHOW CREATE TABLE t1;
1459
ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
1461
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1462
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1463
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1464
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1466
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1467
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1468
SHOW CREATE TABLE t1;
1469
ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
1471
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1472
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1473
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1474
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1476
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1477
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1478
SHOW CREATE TABLE t1;
1479
ALTER TABLE t1 ADD c4 MEDIUMBLOB NULL AFTER c2;
1481
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1482
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1483
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1484
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1486
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1487
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1488
SHOW CREATE TABLE t1;
1489
ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
1491
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1492
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1493
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1494
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1496
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1497
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1498
SHOW CREATE TABLE t1;
1499
ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
1501
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1502
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1503
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1504
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1506
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1507
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1508
SHOW CREATE TABLE t1;
1509
ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
1511
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1512
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1513
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1514
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1516
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1517
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1518
SHOW CREATE TABLE t1;
1519
ALTER TABLE t1 ADD c4 MEDIUMBLOB NOT NULL AFTER c2;
1521
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1522
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1523
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1524
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1526
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1527
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1528
SHOW CREATE TABLE t1;
1529
ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
1531
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1532
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1533
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1534
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1536
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1537
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1538
SHOW CREATE TABLE t1;
1539
ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
1541
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1542
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1543
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1544
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1546
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1547
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1548
SHOW CREATE TABLE t1;
1549
ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
1551
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1552
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1553
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1554
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1556
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1557
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1558
SHOW CREATE TABLE t1;
1559
ALTER TABLE t1 ADD c4 LONGBLOB NULL AFTER c2;
1561
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1562
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1563
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1564
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1566
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1567
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1568
SHOW CREATE TABLE t1;
1569
ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
1571
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1572
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1573
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1574
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1576
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1577
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1578
SHOW CREATE TABLE t1;
1579
ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
1581
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1582
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1583
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1584
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1586
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1587
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1588
SHOW CREATE TABLE t1;
1589
ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
1591
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1592
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1593
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1594
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1596
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1597
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1598
SHOW CREATE TABLE t1;
1599
ALTER TABLE t1 ADD c4 LONGBLOB NOT NULL AFTER c2;
1601
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1602
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1603
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1604
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1606
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1607
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1608
SHOW CREATE TABLE t1;
1609
ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
1611
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1612
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1613
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1614
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1616
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1617
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1618
SHOW CREATE TABLE t1;
1619
ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
1621
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1622
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1623
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1624
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1626
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1627
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1628
SHOW CREATE TABLE t1;
1629
ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
1631
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1632
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1633
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1634
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1636
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1637
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1638
SHOW CREATE TABLE t1;
1639
ALTER TABLE t1 ADD c4 TINYTEXT NULL AFTER c2;
1641
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1642
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1643
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1644
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1646
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1647
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1648
SHOW CREATE TABLE t1;
1649
ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
1651
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1652
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1653
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1654
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1656
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1657
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1658
SHOW CREATE TABLE t1;
1659
ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
1661
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1662
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1663
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1664
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1666
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1667
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1668
SHOW CREATE TABLE t1;
1669
ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
1671
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1672
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1673
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1674
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1676
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1677
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1678
SHOW CREATE TABLE t1;
1679
ALTER TABLE t1 ADD c4 TINYTEXT NOT NULL AFTER c2;
1681
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1682
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1683
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1684
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1686
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1687
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1688
SHOW CREATE TABLE t1;
1689
ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
1691
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1692
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1693
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1694
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1696
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1697
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1698
SHOW CREATE TABLE t1;
1699
ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
1701
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1702
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1703
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1704
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1706
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1707
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1708
SHOW CREATE TABLE t1;
1709
ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
1711
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1712
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1713
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1714
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1716
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1717
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1718
SHOW CREATE TABLE t1;
1719
ALTER TABLE t1 ADD c4 TEXT NULL AFTER c2;
1721
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1722
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1723
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1724
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1726
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1727
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1728
SHOW CREATE TABLE t1;
1729
ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
1731
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1732
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1733
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1734
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1736
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1737
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1738
SHOW CREATE TABLE t1;
1739
ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
1741
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1742
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1743
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1744
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1746
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1747
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1748
SHOW CREATE TABLE t1;
1749
ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
1751
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1752
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1753
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1754
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1756
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1757
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1758
SHOW CREATE TABLE t1;
1759
ALTER TABLE t1 ADD c4 TEXT NOT NULL AFTER c2;
1761
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1762
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1763
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1764
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1766
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1767
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1768
SHOW CREATE TABLE t1;
1769
ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
1771
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1772
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1773
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1774
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1776
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1777
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1778
SHOW CREATE TABLE t1;
1779
ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
1781
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1782
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1783
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1784
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1786
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1787
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1788
SHOW CREATE TABLE t1;
1789
ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
1791
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1792
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1793
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1794
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1796
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1797
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1798
SHOW CREATE TABLE t1;
1799
ALTER TABLE t1 ADD c4 MEDIUMTEXT NULL AFTER c2;
1801
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1802
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1803
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1804
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1806
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1807
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1808
SHOW CREATE TABLE t1;
1809
ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
1811
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1812
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1813
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1814
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1816
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1817
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1818
SHOW CREATE TABLE t1;
1819
ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
1821
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1822
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1823
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1824
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1826
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1827
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1828
SHOW CREATE TABLE t1;
1829
ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
1831
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1832
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1833
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1834
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1836
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1837
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1838
SHOW CREATE TABLE t1;
1839
ALTER TABLE t1 ADD c4 MEDIUMTEXT NOT NULL AFTER c2;
1841
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1842
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1843
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1844
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NULL);
1846
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1847
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1848
SHOW CREATE TABLE t1;
1849
ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
1851
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1852
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1853
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1854
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NULL);
1856
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1857
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1858
SHOW CREATE TABLE t1;
1859
ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
1861
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1862
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1863
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1864
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NULL);
1866
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1867
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1868
SHOW CREATE TABLE t1;
1869
ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
1871
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1872
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1873
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1874
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NULL);
1876
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1877
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1878
SHOW CREATE TABLE t1;
1879
ALTER TABLE t1 ADD c4 LONGTEXT NULL AFTER c2;
1881
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1882
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1883
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1884
CREATE TABLE t1(c1 CHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 CHAR(20) NOT NULL);
1886
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1887
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1888
SHOW CREATE TABLE t1;
1889
ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
1891
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1892
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1893
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1894
CREATE TABLE t1(c1 VARCHAR(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARCHAR(20) NOT NULL);
1896
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1897
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1898
SHOW CREATE TABLE t1;
1899
ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
1901
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1902
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1903
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1904
CREATE TABLE t1(c1 BINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 BINARY(20) NOT NULL);
1906
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1907
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1908
SHOW CREATE TABLE t1;
1909
ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
1911
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1912
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1913
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1914
CREATE TABLE t1(c1 VARBINARY(15) NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 VARBINARY(20) NOT NULL);
1916
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1917
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1918
SHOW CREATE TABLE t1;
1919
ALTER TABLE t1 ADD c4 LONGTEXT NOT NULL AFTER c2;
1921
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1922
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1923
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;