2
DROP TABLE IF EXISTS t2;
4
CREATE TABLE t2(c1 BIT NOT 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 t2 MODIFY c1 BIT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
14
CREATE TABLE t2(c1 TINYINT NOT 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 t2 MODIFY c1 TINYINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
24
CREATE TABLE t2(c1 SMALLINT NOT 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 t2 MODIFY c1 SMALLINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
34
CREATE TABLE t2(c1 MEDIUMINT NOT 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 t2 MODIFY c1 MEDIUMINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
44
CREATE TABLE t2(c1 INT 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 t2 MODIFY c1 INT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
54
CREATE TABLE t2(c1 INTEGER 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 t2 MODIFY c1 INTEGER NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
64
CREATE TABLE t2(c1 BIGINT 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 t2 MODIFY c1 BIGINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
74
CREATE TABLE t2(c1 REAL 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 t2 MODIFY c1 REAL NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
84
CREATE TABLE t2(c1 DOUBLE NOT 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 t2 MODIFY c1 DOUBLE NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
94
CREATE TABLE t2(c1 FLOAT NOT 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 t2 MODIFY c1 FLOAT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
104
CREATE TABLE t2(c1 DECIMAL NOT 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 t2;
109
ALTER TABLE t2 MODIFY c1 DECIMAL NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
114
CREATE TABLE t2(c1 NUMERIC NOT 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 t2;
119
ALTER TABLE t2 MODIFY c1 NUMERIC NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
124
CREATE TABLE t2(c1 DATE 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 t2;
129
ALTER TABLE t2 MODIFY c1 DATE NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
134
CREATE TABLE t2(c1 TIME 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 t2;
139
ALTER TABLE t2 MODIFY c1 TIME NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
144
CREATE TABLE t2(c1 TIMESTAMP 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 t2;
149
ALTER TABLE t2 MODIFY c1 TIMESTAMP NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
154
CREATE TABLE t2(c1 YEAR 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 t2;
159
ALTER TABLE t2 MODIFY c1 YEAR NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
164
CREATE TABLE t2(c1 TINYBLOB NOT 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 t2;
169
ALTER TABLE t2 MODIFY c1 TINYBLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
174
CREATE TABLE t2(c1 BLOB NOT 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 t2;
179
ALTER TABLE t2 MODIFY c1 BLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
184
CREATE TABLE t2(c1 MEDIUMBLOB NOT 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 t2;
189
ALTER TABLE t2 MODIFY c1 MEDIUMBLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
194
CREATE TABLE t2(c1 LONGBLOB NOT 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 t2;
199
ALTER TABLE t2 MODIFY c1 LONGBLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
204
CREATE TABLE t2(c1 TINYTEXT 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 t2;
209
ALTER TABLE t2 MODIFY c1 TINYTEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
214
CREATE TABLE t2(c1 TEXT 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 t2;
219
ALTER TABLE t2 MODIFY c1 TEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
224
CREATE TABLE t2(c1 MEDIUMTEXT 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 t2;
229
ALTER TABLE t2 MODIFY c1 MEDIUMTEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
234
CREATE TABLE t2(c1 LONGTEXT 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 t2;
239
ALTER TABLE t2 MODIFY c1 LONGTEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
244
CREATE TABLE t2(c1 BIT NOT 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 t2;
249
ALTER TABLE t2 CHANGE c1 c1 BIT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
254
CREATE TABLE t2(c1 TINYINT NOT 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 t2;
259
ALTER TABLE t2 CHANGE c1 c1 TINYINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
264
CREATE TABLE t2(c1 SMALLINT NOT 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 t2;
269
ALTER TABLE t2 CHANGE c1 c1 SMALLINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
274
CREATE TABLE t2(c1 MEDIUMINT NOT 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 t2;
279
ALTER TABLE t2 CHANGE c1 c1 MEDIUMINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
284
CREATE TABLE t2(c1 INT 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 t2;
289
ALTER TABLE t2 CHANGE c1 c1 INT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
294
CREATE TABLE t2(c1 INTEGER 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 t2;
299
ALTER TABLE t2 CHANGE c1 c1 INTEGER NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
304
CREATE TABLE t2(c1 BIGINT 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 t2;
309
ALTER TABLE t2 CHANGE c1 c1 BIGINT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
314
CREATE TABLE t2(c1 REAL 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 t2;
319
ALTER TABLE t2 CHANGE c1 c1 REAL NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
324
CREATE TABLE t2(c1 DOUBLE NOT 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 t2;
329
ALTER TABLE t2 CHANGE c1 c1 DOUBLE NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
334
CREATE TABLE t2(c1 FLOAT NOT 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 t2;
339
ALTER TABLE t2 CHANGE c1 c1 FLOAT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
344
CREATE TABLE t2(c1 DECIMAL NOT 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 t2;
349
ALTER TABLE t2 CHANGE c1 c1 DECIMAL NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
354
CREATE TABLE t2(c1 NUMERIC NOT 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 t2;
359
ALTER TABLE t2 CHANGE c1 c1 NUMERIC NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
364
CREATE TABLE t2(c1 DATE 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 t2;
369
ALTER TABLE t2 CHANGE c1 c1 DATE NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
374
CREATE TABLE t2(c1 TIME 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 t2;
379
ALTER TABLE t2 CHANGE c1 c1 TIME NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
384
CREATE TABLE t2(c1 TIMESTAMP 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 t2;
389
ALTER TABLE t2 CHANGE c1 c1 TIMESTAMP NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
394
CREATE TABLE t2(c1 YEAR 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 t2;
399
ALTER TABLE t2 CHANGE c1 c1 YEAR NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
404
CREATE TABLE t2(c1 TINYBLOB NOT 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 t2;
409
ALTER TABLE t2 CHANGE c1 c1 TINYBLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
414
CREATE TABLE t2(c1 BLOB NOT 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 t2;
419
ALTER TABLE t2 CHANGE c1 c1 BLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
424
CREATE TABLE t2(c1 MEDIUMBLOB NOT 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 t2;
429
ALTER TABLE t2 CHANGE c1 c1 MEDIUMBLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
434
CREATE TABLE t2(c1 LONGBLOB NOT 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 t2;
439
ALTER TABLE t2 CHANGE c1 c1 LONGBLOB NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
444
CREATE TABLE t2(c1 TINYTEXT 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 t2;
449
ALTER TABLE t2 CHANGE c1 c1 TINYTEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
454
CREATE TABLE t2(c1 TEXT 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 t2;
459
ALTER TABLE t2 CHANGE c1 c1 TEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
464
CREATE TABLE t2(c1 MEDIUMTEXT 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 t2;
469
ALTER TABLE t2 CHANGE c1 c1 MEDIUMTEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;
474
CREATE TABLE t2(c1 LONGTEXT 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 t2;
479
ALTER TABLE t2 CHANGE c1 c1 LONGTEXT NULL;
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 t2; DROP TABLE t2; SHOW TABLES;