Debian Codegraph @

mysql-test/suite/engines/funcs/t/ta_add_string2.test

raw
1 --source include/no_valgrind_without_big.inc
2
3 --disable_warnings
4 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
5 --enable_warnings
6
7 --disable_warnings
8 DROP TABLE IF EXISTS t5;
9 --enable_warnings
10 CREATE TABLE t5(c1 BIT NULL);
11 SHOW TABLES;
12 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
13 SHOW CREATE TABLE t5;
14 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
15 SHOW TABLES;
16 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
17 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
18 CREATE TABLE t5(c1 TINYINT NULL);
19 SHOW TABLES;
20 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
21 SHOW CREATE TABLE t5;
22 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
23 SHOW TABLES;
24 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
25 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
26 CREATE TABLE t5(c1 SMALLINT NULL);
27 SHOW TABLES;
28 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29 SHOW CREATE TABLE t5;
30 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
31 SHOW TABLES;
32 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
33 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
34 CREATE TABLE t5(c1 MEDIUMINT NULL);
35 SHOW TABLES;
36 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
37 SHOW CREATE TABLE t5;
38 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
39 SHOW TABLES;
40 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
41 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
42 CREATE TABLE t5(c1 INT NULL);
43 SHOW TABLES;
44 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
45 SHOW CREATE TABLE t5;
46 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
47 SHOW TABLES;
48 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
49 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
50 CREATE TABLE t5(c1 INTEGER NULL);
51 SHOW TABLES;
52 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
53 SHOW CREATE TABLE t5;
54 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
55 SHOW TABLES;
56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
57 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
58 CREATE TABLE t5(c1 BIGINT NULL);
59 SHOW TABLES;
60 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
61 SHOW CREATE TABLE t5;
62 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
63 SHOW TABLES;
64 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
65 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
66 CREATE TABLE t5(c1 REAL NULL);
67 SHOW TABLES;
68 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
69 SHOW CREATE TABLE t5;
70 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
71 SHOW TABLES;
72 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
73 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
74 CREATE TABLE t5(c1 DOUBLE NULL);
75 SHOW TABLES;
76 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
77 SHOW CREATE TABLE t5;
78 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
79 SHOW TABLES;
80 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
81 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
82 CREATE TABLE t5(c1 FLOAT NULL);
83 SHOW TABLES;
84 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
85 SHOW CREATE TABLE t5;
86 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
87 SHOW TABLES;
88 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
90 CREATE TABLE t5(c1 DECIMAL NULL);
91 SHOW TABLES;
92 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93 SHOW CREATE TABLE t5;
94 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
95 SHOW TABLES;
96 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
97 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
98 CREATE TABLE t5(c1 NUMERIC NULL);
99 SHOW TABLES;
100 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
101 SHOW CREATE TABLE t5;
102 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
103 SHOW TABLES;
104 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
105 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
106 CREATE TABLE t5(c1 DATE NULL);
107 SHOW TABLES;
108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
109 SHOW CREATE TABLE t5;
110 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
111 SHOW TABLES;
112 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
113 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
114 CREATE TABLE t5(c1 TIME NULL);
115 SHOW TABLES;
116 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
117 SHOW CREATE TABLE t5;
118 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
119 SHOW TABLES;
120 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
121 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
122 CREATE TABLE t5(c1 TIMESTAMP NULL);
123 SHOW TABLES;
124 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
125 SHOW CREATE TABLE t5;
126 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
127 SHOW TABLES;
128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
129 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
130 CREATE TABLE t5(c1 YEAR NULL);
131 SHOW TABLES;
132 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
133 SHOW CREATE TABLE t5;
134 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
135 SHOW TABLES;
136 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
137 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
138 CREATE TABLE t5(c1 TINYBLOB NULL);
139 SHOW TABLES;
140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
141 SHOW CREATE TABLE t5;
142 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
143 SHOW TABLES;
144 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
145 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
146 CREATE TABLE t5(c1 BLOB NULL);
147 SHOW TABLES;
148 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
149 SHOW CREATE TABLE t5;
150 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
151 SHOW TABLES;
152 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
153 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
154 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
155 SHOW TABLES;
156 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
157 SHOW CREATE TABLE t5;
158 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
159 SHOW TABLES;
160 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
161 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
162 CREATE TABLE t5(c1 LONGBLOB NULL);
163 SHOW TABLES;
164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
165 SHOW CREATE TABLE t5;
166 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
167 SHOW TABLES;
168 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
169 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
170 CREATE TABLE t5(c1 TINYTEXT NULL);
171 SHOW TABLES;
172 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
173 SHOW CREATE TABLE t5;
174 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
175 SHOW TABLES;
176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
177 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
178 CREATE TABLE t5(c1 TEXT NULL);
179 SHOW TABLES;
180 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
181 SHOW CREATE TABLE t5;
182 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
183 SHOW TABLES;
184 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
185 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
186 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
187 SHOW TABLES;
188 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
189 SHOW CREATE TABLE t5;
190 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
191 SHOW TABLES;
192 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
193 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
194 CREATE TABLE t5(c1 LONGTEXT NULL);
195 SHOW TABLES;
196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
197 SHOW CREATE TABLE t5;
198 ALTER TABLE t5 ADD c2 CHAR(5) NULL;
199 SHOW TABLES;
200 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
201 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
202 CREATE TABLE t5(c1 BIT NOT NULL);
203 SHOW TABLES;
204 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
205 SHOW CREATE TABLE t5;
206 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
207 SHOW TABLES;
208 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
209 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
210 CREATE TABLE t5(c1 TINYINT NOT NULL);
211 SHOW TABLES;
212 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
213 SHOW CREATE TABLE t5;
214 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
215 SHOW TABLES;
216 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
217 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
218 CREATE TABLE t5(c1 SMALLINT NOT NULL);
219 SHOW TABLES;
220 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
221 SHOW CREATE TABLE t5;
222 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
223 SHOW TABLES;
224 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
225 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
226 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
227 SHOW TABLES;
228 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
229 SHOW CREATE TABLE t5;
230 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
231 SHOW TABLES;
232 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
233 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
234 CREATE TABLE t5(c1 INT NOT NULL);
235 SHOW TABLES;
236 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
237 SHOW CREATE TABLE t5;
238 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
239 SHOW TABLES;
240 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
241 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
242 CREATE TABLE t5(c1 INTEGER NOT NULL);
243 SHOW TABLES;
244 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
245 SHOW CREATE TABLE t5;
246 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
247 SHOW TABLES;
248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
249 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
250 CREATE TABLE t5(c1 BIGINT NOT NULL);
251 SHOW TABLES;
252 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
253 SHOW CREATE TABLE t5;
254 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
255 SHOW TABLES;
256 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
257 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
258 CREATE TABLE t5(c1 REAL NOT NULL);
259 SHOW TABLES;
260 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
261 SHOW CREATE TABLE t5;
262 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
263 SHOW TABLES;
264 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
265 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
266 CREATE TABLE t5(c1 DOUBLE NOT NULL);
267 SHOW TABLES;
268 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
269 SHOW CREATE TABLE t5;
270 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
271 SHOW TABLES;
272 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
273 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
274 CREATE TABLE t5(c1 FLOAT NOT NULL);
275 SHOW TABLES;
276 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
277 SHOW CREATE TABLE t5;
278 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
279 SHOW TABLES;
280 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
281 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
282 CREATE TABLE t5(c1 DECIMAL NOT NULL);
283 SHOW TABLES;
284 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
285 SHOW CREATE TABLE t5;
286 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
287 SHOW TABLES;
288 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
289 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
290 CREATE TABLE t5(c1 NUMERIC NOT NULL);
291 SHOW TABLES;
292 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
293 SHOW CREATE TABLE t5;
294 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
295 SHOW TABLES;
296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
297 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
298 CREATE TABLE t5(c1 DATE NOT NULL);
299 SHOW TABLES;
300 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
301 SHOW CREATE TABLE t5;
302 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
303 SHOW TABLES;
304 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
305 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
306 CREATE TABLE t5(c1 TIME NOT NULL);
307 SHOW TABLES;
308 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
309 SHOW CREATE TABLE t5;
310 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
311 SHOW TABLES;
312 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
313 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
314 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
315 SHOW TABLES;
316 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
317 SHOW CREATE TABLE t5;
318 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
319 SHOW TABLES;
320 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
321 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
322 CREATE TABLE t5(c1 YEAR NOT NULL);
323 SHOW TABLES;
324 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
325 SHOW CREATE TABLE t5;
326 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
327 SHOW TABLES;
328 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
329 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
330 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
331 SHOW TABLES;
332 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
333 SHOW CREATE TABLE t5;
334 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
335 SHOW TABLES;
336 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
337 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
338 CREATE TABLE t5(c1 BLOB NOT NULL);
339 SHOW TABLES;
340 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
341 SHOW CREATE TABLE t5;
342 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
343 SHOW TABLES;
344 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
345 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
346 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
347 SHOW TABLES;
348 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
349 SHOW CREATE TABLE t5;
350 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
351 SHOW TABLES;
352 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
353 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
354 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
355 SHOW TABLES;
356 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
357 SHOW CREATE TABLE t5;
358 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
359 SHOW TABLES;
360 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
361 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
362 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
363 SHOW TABLES;
364 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
365 SHOW CREATE TABLE t5;
366 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
367 SHOW TABLES;
368 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
369 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
370 CREATE TABLE t5(c1 TEXT NOT NULL);
371 SHOW TABLES;
372 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
373 SHOW CREATE TABLE t5;
374 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
375 SHOW TABLES;
376 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
377 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
378 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
379 SHOW TABLES;
380 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
381 SHOW CREATE TABLE t5;
382 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
383 SHOW TABLES;
384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
385 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
386 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
387 SHOW TABLES;
388 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
389 SHOW CREATE TABLE t5;
390 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL;
391 SHOW TABLES;
392 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
393 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
394 CREATE TABLE t5(c1 BIT NULL);
395 SHOW TABLES;
396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
397 SHOW CREATE TABLE t5;
398 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
399 SHOW TABLES;
400 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
401 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
402 CREATE TABLE t5(c1 TINYINT NULL);
403 SHOW TABLES;
404 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
405 SHOW CREATE TABLE t5;
406 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
407 SHOW TABLES;
408 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
409 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
410 CREATE TABLE t5(c1 SMALLINT NULL);
411 SHOW TABLES;
412 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
413 SHOW CREATE TABLE t5;
414 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
415 SHOW TABLES;
416 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
417 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
418 CREATE TABLE t5(c1 MEDIUMINT NULL);
419 SHOW TABLES;
420 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
421 SHOW CREATE TABLE t5;
422 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
423 SHOW TABLES;
424 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
425 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
426 CREATE TABLE t5(c1 INT NULL);
427 SHOW TABLES;
428 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
429 SHOW CREATE TABLE t5;
430 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
431 SHOW TABLES;
432 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
433 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
434 CREATE TABLE t5(c1 INTEGER NULL);
435 SHOW TABLES;
436 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
437 SHOW CREATE TABLE t5;
438 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
439 SHOW TABLES;
440 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
441 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
442 CREATE TABLE t5(c1 BIGINT NULL);
443 SHOW TABLES;
444 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
445 SHOW CREATE TABLE t5;
446 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
447 SHOW TABLES;
448 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
449 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
450 CREATE TABLE t5(c1 REAL NULL);
451 SHOW TABLES;
452 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
453 SHOW CREATE TABLE t5;
454 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
455 SHOW TABLES;
456 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
457 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
458 CREATE TABLE t5(c1 DOUBLE NULL);
459 SHOW TABLES;
460 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
461 SHOW CREATE TABLE t5;
462 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
463 SHOW TABLES;
464 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
465 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
466 CREATE TABLE t5(c1 FLOAT NULL);
467 SHOW TABLES;
468 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
469 SHOW CREATE TABLE t5;
470 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
471 SHOW TABLES;
472 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
473 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
474 CREATE TABLE t5(c1 DECIMAL NULL);
475 SHOW TABLES;
476 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
477 SHOW CREATE TABLE t5;
478 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
479 SHOW TABLES;
480 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
481 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
482 CREATE TABLE t5(c1 NUMERIC NULL);
483 SHOW TABLES;
484 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
485 SHOW CREATE TABLE t5;
486 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
487 SHOW TABLES;
488 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
489 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
490 CREATE TABLE t5(c1 DATE NULL);
491 SHOW TABLES;
492 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
493 SHOW CREATE TABLE t5;
494 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
495 SHOW TABLES;
496 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
497 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
498 CREATE TABLE t5(c1 TIME NULL);
499 SHOW TABLES;
500 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
501 SHOW CREATE TABLE t5;
502 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
503 SHOW TABLES;
504 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
505 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
506 CREATE TABLE t5(c1 TIMESTAMP NULL);
507 SHOW TABLES;
508 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
509 SHOW CREATE TABLE t5;
510 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
511 SHOW TABLES;
512 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
513 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
514 CREATE TABLE t5(c1 YEAR NULL);
515 SHOW TABLES;
516 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
517 SHOW CREATE TABLE t5;
518 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
519 SHOW TABLES;
520 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
521 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
522 CREATE TABLE t5(c1 TINYBLOB NULL);
523 SHOW TABLES;
524 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
525 SHOW CREATE TABLE t5;
526 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
527 SHOW TABLES;
528 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
529 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
530 CREATE TABLE t5(c1 BLOB NULL);
531 SHOW TABLES;
532 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
533 SHOW CREATE TABLE t5;
534 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
535 SHOW TABLES;
536 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
537 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
538 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
539 SHOW TABLES;
540 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
541 SHOW CREATE TABLE t5;
542 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
543 SHOW TABLES;
544 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
545 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
546 CREATE TABLE t5(c1 LONGBLOB NULL);
547 SHOW TABLES;
548 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
549 SHOW CREATE TABLE t5;
550 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
551 SHOW TABLES;
552 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
553 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
554 CREATE TABLE t5(c1 TINYTEXT NULL);
555 SHOW TABLES;
556 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
557 SHOW CREATE TABLE t5;
558 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
559 SHOW TABLES;
560 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
561 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
562 CREATE TABLE t5(c1 TEXT NULL);
563 SHOW TABLES;
564 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
565 SHOW CREATE TABLE t5;
566 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
567 SHOW TABLES;
568 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
569 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
570 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
571 SHOW TABLES;
572 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
573 SHOW CREATE TABLE t5;
574 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
575 SHOW TABLES;
576 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
577 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
578 CREATE TABLE t5(c1 LONGTEXT NULL);
579 SHOW TABLES;
580 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
581 SHOW CREATE TABLE t5;
582 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL;
583 SHOW TABLES;
584 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
585 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
586 CREATE TABLE t5(c1 BIT NOT NULL);
587 SHOW TABLES;
588 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
589 SHOW CREATE TABLE t5;
590 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
591 SHOW TABLES;
592 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
593 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
594 CREATE TABLE t5(c1 TINYINT NOT NULL);
595 SHOW TABLES;
596 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
597 SHOW CREATE TABLE t5;
598 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
599 SHOW TABLES;
600 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
601 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
602 CREATE TABLE t5(c1 SMALLINT NOT NULL);
603 SHOW TABLES;
604 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
605 SHOW CREATE TABLE t5;
606 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
607 SHOW TABLES;
608 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
609 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
610 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
611 SHOW TABLES;
612 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
613 SHOW CREATE TABLE t5;
614 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
615 SHOW TABLES;
616 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
617 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
618 CREATE TABLE t5(c1 INT NOT NULL);
619 SHOW TABLES;
620 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
621 SHOW CREATE TABLE t5;
622 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
623 SHOW TABLES;
624 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
625 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
626 CREATE TABLE t5(c1 INTEGER NOT NULL);
627 SHOW TABLES;
628 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
629 SHOW CREATE TABLE t5;
630 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
631 SHOW TABLES;
632 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
633 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
634 CREATE TABLE t5(c1 BIGINT NOT NULL);
635 SHOW TABLES;
636 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
637 SHOW CREATE TABLE t5;
638 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
639 SHOW TABLES;
640 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
641 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
642 CREATE TABLE t5(c1 REAL NOT NULL);
643 SHOW TABLES;
644 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
645 SHOW CREATE TABLE t5;
646 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
647 SHOW TABLES;
648 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
649 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
650 CREATE TABLE t5(c1 DOUBLE NOT NULL);
651 SHOW TABLES;
652 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
653 SHOW CREATE TABLE t5;
654 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
655 SHOW TABLES;
656 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
657 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
658 CREATE TABLE t5(c1 FLOAT NOT NULL);
659 SHOW TABLES;
660 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
661 SHOW CREATE TABLE t5;
662 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
663 SHOW TABLES;
664 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
665 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
666 CREATE TABLE t5(c1 DECIMAL NOT NULL);
667 SHOW TABLES;
668 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
669 SHOW CREATE TABLE t5;
670 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
671 SHOW TABLES;
672 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
673 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
674 CREATE TABLE t5(c1 NUMERIC NOT NULL);
675 SHOW TABLES;
676 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
677 SHOW CREATE TABLE t5;
678 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
679 SHOW TABLES;
680 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
681 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
682 CREATE TABLE t5(c1 DATE NOT NULL);
683 SHOW TABLES;
684 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
685 SHOW CREATE TABLE t5;
686 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
687 SHOW TABLES;
688 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
689 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
690 CREATE TABLE t5(c1 TIME NOT NULL);
691 SHOW TABLES;
692 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
693 SHOW CREATE TABLE t5;
694 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
695 SHOW TABLES;
696 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
697 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
698 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
699 SHOW TABLES;
700 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
701 SHOW CREATE TABLE t5;
702 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
703 SHOW TABLES;
704 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
705 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
706 CREATE TABLE t5(c1 YEAR NOT NULL);
707 SHOW TABLES;
708 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
709 SHOW CREATE TABLE t5;
710 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
711 SHOW TABLES;
712 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
713 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
714 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
715 SHOW TABLES;
716 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
717 SHOW CREATE TABLE t5;
718 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
719 SHOW TABLES;
720 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
721 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
722 CREATE TABLE t5(c1 BLOB NOT NULL);
723 SHOW TABLES;
724 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
725 SHOW CREATE TABLE t5;
726 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
727 SHOW TABLES;
728 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
729 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
730 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
731 SHOW TABLES;
732 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
733 SHOW CREATE TABLE t5;
734 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
735 SHOW TABLES;
736 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
737 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
738 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
739 SHOW TABLES;
740 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
741 SHOW CREATE TABLE t5;
742 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
743 SHOW TABLES;
744 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
745 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
746 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
747 SHOW TABLES;
748 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
749 SHOW CREATE TABLE t5;
750 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
751 SHOW TABLES;
752 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
753 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
754 CREATE TABLE t5(c1 TEXT NOT NULL);
755 SHOW TABLES;
756 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
757 SHOW CREATE TABLE t5;
758 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
759 SHOW TABLES;
760 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
761 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
762 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
763 SHOW TABLES;
764 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
765 SHOW CREATE TABLE t5;
766 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
767 SHOW TABLES;
768 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
769 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
770 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
771 SHOW TABLES;
772 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
773 SHOW CREATE TABLE t5;
774 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL;
775 SHOW TABLES;
776 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
777 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
778 CREATE TABLE t5(c1 BIT NULL);
779 SHOW TABLES;
780 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
781 SHOW CREATE TABLE t5;
782 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
783 SHOW TABLES;
784 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
785 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
786 CREATE TABLE t5(c1 TINYINT NULL);
787 SHOW TABLES;
788 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
789 SHOW CREATE TABLE t5;
790 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
791 SHOW TABLES;
792 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
793 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
794 CREATE TABLE t5(c1 SMALLINT NULL);
795 SHOW TABLES;
796 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
797 SHOW CREATE TABLE t5;
798 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
799 SHOW TABLES;
800 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
801 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
802 CREATE TABLE t5(c1 MEDIUMINT NULL);
803 SHOW TABLES;
804 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
805 SHOW CREATE TABLE t5;
806 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
807 SHOW TABLES;
808 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
809 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
810 CREATE TABLE t5(c1 INT NULL);
811 SHOW TABLES;
812 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
813 SHOW CREATE TABLE t5;
814 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
815 SHOW TABLES;
816 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
817 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
818 CREATE TABLE t5(c1 INTEGER NULL);
819 SHOW TABLES;
820 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
821 SHOW CREATE TABLE t5;
822 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
823 SHOW TABLES;
824 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
825 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
826 CREATE TABLE t5(c1 BIGINT NULL);
827 SHOW TABLES;
828 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
829 SHOW CREATE TABLE t5;
830 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
831 SHOW TABLES;
832 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
833 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
834 CREATE TABLE t5(c1 REAL NULL);
835 SHOW TABLES;
836 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
837 SHOW CREATE TABLE t5;
838 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
839 SHOW TABLES;
840 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
841 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
842 CREATE TABLE t5(c1 DOUBLE NULL);
843 SHOW TABLES;
844 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
845 SHOW CREATE TABLE t5;
846 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
847 SHOW TABLES;
848 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
849 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
850 CREATE TABLE t5(c1 FLOAT NULL);
851 SHOW TABLES;
852 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
853 SHOW CREATE TABLE t5;
854 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
855 SHOW TABLES;
856 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
857 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
858 CREATE TABLE t5(c1 DECIMAL NULL);
859 SHOW TABLES;
860 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
861 SHOW CREATE TABLE t5;
862 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
863 SHOW TABLES;
864 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
865 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
866 CREATE TABLE t5(c1 NUMERIC NULL);
867 SHOW TABLES;
868 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
869 SHOW CREATE TABLE t5;
870 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
871 SHOW TABLES;
872 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
873 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
874 CREATE TABLE t5(c1 DATE NULL);
875 SHOW TABLES;
876 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
877 SHOW CREATE TABLE t5;
878 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
879 SHOW TABLES;
880 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
881 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
882 CREATE TABLE t5(c1 TIME NULL);
883 SHOW TABLES;
884 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
885 SHOW CREATE TABLE t5;
886 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
887 SHOW TABLES;
888 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
889 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
890 CREATE TABLE t5(c1 TIMESTAMP NULL);
891 SHOW TABLES;
892 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
893 SHOW CREATE TABLE t5;
894 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
895 SHOW TABLES;
896 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
897 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
898 CREATE TABLE t5(c1 YEAR NULL);
899 SHOW TABLES;
900 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
901 SHOW CREATE TABLE t5;
902 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
903 SHOW TABLES;
904 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
905 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
906 CREATE TABLE t5(c1 TINYBLOB NULL);
907 SHOW TABLES;
908 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
909 SHOW CREATE TABLE t5;
910 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
911 SHOW TABLES;
912 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
913 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
914 CREATE TABLE t5(c1 BLOB NULL);
915 SHOW TABLES;
916 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
917 SHOW CREATE TABLE t5;
918 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
919 SHOW TABLES;
920 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
921 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
922 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
923 SHOW TABLES;
924 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
925 SHOW CREATE TABLE t5;
926 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
927 SHOW TABLES;
928 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
929 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
930 CREATE TABLE t5(c1 LONGBLOB NULL);
931 SHOW TABLES;
932 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
933 SHOW CREATE TABLE t5;
934 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
935 SHOW TABLES;
936 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
937 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
938 CREATE TABLE t5(c1 TINYTEXT NULL);
939 SHOW TABLES;
940 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
941 SHOW CREATE TABLE t5;
942 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
943 SHOW TABLES;
944 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
945 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
946 CREATE TABLE t5(c1 TEXT NULL);
947 SHOW TABLES;
948 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
949 SHOW CREATE TABLE t5;
950 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
951 SHOW TABLES;
952 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
953 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
954 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
955 SHOW TABLES;
956 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
957 SHOW CREATE TABLE t5;
958 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
959 SHOW TABLES;
960 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
961 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
962 CREATE TABLE t5(c1 LONGTEXT NULL);
963 SHOW TABLES;
964 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
965 SHOW CREATE TABLE t5;
966 ALTER TABLE t5 ADD c2 BINARY(5) NULL;
967 SHOW TABLES;
968 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
969 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
970 CREATE TABLE t5(c1 BIT NOT NULL);
971 SHOW TABLES;
972 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
973 SHOW CREATE TABLE t5;
974 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
975 SHOW TABLES;
976 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
977 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
978 CREATE TABLE t5(c1 TINYINT NOT NULL);
979 SHOW TABLES;
980 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
981 SHOW CREATE TABLE t5;
982 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
983 SHOW TABLES;
984 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
985 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
986 CREATE TABLE t5(c1 SMALLINT NOT NULL);
987 SHOW TABLES;
988 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
989 SHOW CREATE TABLE t5;
990 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
991 SHOW TABLES;
992 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
993 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
994 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
995 SHOW TABLES;
996 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
997 SHOW CREATE TABLE t5;
998 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
999 SHOW TABLES;
1000 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1001 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1002 CREATE TABLE t5(c1 INT NOT NULL);
1003 SHOW TABLES;
1004 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1005 SHOW CREATE TABLE t5;
1006 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1007 SHOW TABLES;
1008 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1009 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1010 CREATE TABLE t5(c1 INTEGER NOT NULL);
1011 SHOW TABLES;
1012 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1013 SHOW CREATE TABLE t5;
1014 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1015 SHOW TABLES;
1016 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1017 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1018 CREATE TABLE t5(c1 BIGINT NOT NULL);
1019 SHOW TABLES;
1020 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1021 SHOW CREATE TABLE t5;
1022 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1023 SHOW TABLES;
1024 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1025 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1026 CREATE TABLE t5(c1 REAL NOT NULL);
1027 SHOW TABLES;
1028 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1029 SHOW CREATE TABLE t5;
1030 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1031 SHOW TABLES;
1032 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1033 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1034 CREATE TABLE t5(c1 DOUBLE NOT NULL);
1035 SHOW TABLES;
1036 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1037 SHOW CREATE TABLE t5;
1038 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1039 SHOW TABLES;
1040 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1041 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1042 CREATE TABLE t5(c1 FLOAT NOT NULL);
1043 SHOW TABLES;
1044 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1045 SHOW CREATE TABLE t5;
1046 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1047 SHOW TABLES;
1048 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1049 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1050 CREATE TABLE t5(c1 DECIMAL NOT NULL);
1051 SHOW TABLES;
1052 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1053 SHOW CREATE TABLE t5;
1054 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1055 SHOW TABLES;
1056 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1057 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1058 CREATE TABLE t5(c1 NUMERIC NOT NULL);
1059 SHOW TABLES;
1060 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1061 SHOW CREATE TABLE t5;
1062 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1063 SHOW TABLES;
1064 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1065 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1066 CREATE TABLE t5(c1 DATE NOT NULL);
1067 SHOW TABLES;
1068 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1069 SHOW CREATE TABLE t5;
1070 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1071 SHOW TABLES;
1072 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1073 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1074 CREATE TABLE t5(c1 TIME NOT NULL);
1075 SHOW TABLES;
1076 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1077 SHOW CREATE TABLE t5;
1078 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1079 SHOW TABLES;
1080 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1081 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1082 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
1083 SHOW TABLES;
1084 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1085 SHOW CREATE TABLE t5;
1086 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1087 SHOW TABLES;
1088 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1089 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1090 CREATE TABLE t5(c1 YEAR NOT NULL);
1091 SHOW TABLES;
1092 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1093 SHOW CREATE TABLE t5;
1094 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1095 SHOW TABLES;
1096 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1097 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1098 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
1099 SHOW TABLES;
1100 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1101 SHOW CREATE TABLE t5;
1102 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1103 SHOW TABLES;
1104 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1105 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1106 CREATE TABLE t5(c1 BLOB NOT NULL);
1107 SHOW TABLES;
1108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1109 SHOW CREATE TABLE t5;
1110 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1111 SHOW TABLES;
1112 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1113 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1114 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
1115 SHOW TABLES;
1116 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1117 SHOW CREATE TABLE t5;
1118 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1119 SHOW TABLES;
1120 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1121 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1122 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
1123 SHOW TABLES;
1124 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1125 SHOW CREATE TABLE t5;
1126 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1127 SHOW TABLES;
1128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1129 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1130 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
1131 SHOW TABLES;
1132 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1133 SHOW CREATE TABLE t5;
1134 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1135 SHOW TABLES;
1136 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1137 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1138 CREATE TABLE t5(c1 TEXT NOT NULL);
1139 SHOW TABLES;
1140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1141 SHOW CREATE TABLE t5;
1142 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1143 SHOW TABLES;
1144 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1145 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1146 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
1147 SHOW TABLES;
1148 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1149 SHOW CREATE TABLE t5;
1150 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1151 SHOW TABLES;
1152 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1153 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1154 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
1155 SHOW TABLES;
1156 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1157 SHOW CREATE TABLE t5;
1158 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL;
1159 SHOW TABLES;
1160 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1161 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1162 CREATE TABLE t5(c1 BIT NULL);
1163 SHOW TABLES;
1164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1165 SHOW CREATE TABLE t5;
1166 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1167 SHOW TABLES;
1168 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1169 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1170 CREATE TABLE t5(c1 TINYINT NULL);
1171 SHOW TABLES;
1172 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1173 SHOW CREATE TABLE t5;
1174 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1175 SHOW TABLES;
1176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1177 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1178 CREATE TABLE t5(c1 SMALLINT NULL);
1179 SHOW TABLES;
1180 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1181 SHOW CREATE TABLE t5;
1182 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1183 SHOW TABLES;
1184 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1185 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1186 CREATE TABLE t5(c1 MEDIUMINT NULL);
1187 SHOW TABLES;
1188 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1189 SHOW CREATE TABLE t5;
1190 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1191 SHOW TABLES;
1192 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1193 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1194 CREATE TABLE t5(c1 INT NULL);
1195 SHOW TABLES;
1196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1197 SHOW CREATE TABLE t5;
1198 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1199 SHOW TABLES;
1200 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1201 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1202 CREATE TABLE t5(c1 INTEGER NULL);
1203 SHOW TABLES;
1204 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1205 SHOW CREATE TABLE t5;
1206 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1207 SHOW TABLES;
1208 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1209 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1210 CREATE TABLE t5(c1 BIGINT NULL);
1211 SHOW TABLES;
1212 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1213 SHOW CREATE TABLE t5;
1214 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1215 SHOW TABLES;
1216 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1217 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1218 CREATE TABLE t5(c1 REAL NULL);
1219 SHOW TABLES;
1220 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1221 SHOW CREATE TABLE t5;
1222 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1223 SHOW TABLES;
1224 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1225 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1226 CREATE TABLE t5(c1 DOUBLE NULL);
1227 SHOW TABLES;
1228 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1229 SHOW CREATE TABLE t5;
1230 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1231 SHOW TABLES;
1232 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1233 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1234 CREATE TABLE t5(c1 FLOAT NULL);
1235 SHOW TABLES;
1236 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1237 SHOW CREATE TABLE t5;
1238 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1239 SHOW TABLES;
1240 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1241 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1242 CREATE TABLE t5(c1 DECIMAL NULL);
1243 SHOW TABLES;
1244 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1245 SHOW CREATE TABLE t5;
1246 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1247 SHOW TABLES;
1248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1249 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1250 CREATE TABLE t5(c1 NUMERIC NULL);
1251 SHOW TABLES;
1252 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1253 SHOW CREATE TABLE t5;
1254 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1255 SHOW TABLES;
1256 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1257 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1258 CREATE TABLE t5(c1 DATE NULL);
1259 SHOW TABLES;
1260 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1261 SHOW CREATE TABLE t5;
1262 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1263 SHOW TABLES;
1264 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1265 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1266 CREATE TABLE t5(c1 TIME NULL);
1267 SHOW TABLES;
1268 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1269 SHOW CREATE TABLE t5;
1270 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1271 SHOW TABLES;
1272 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1273 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1274 CREATE TABLE t5(c1 TIMESTAMP NULL);
1275 SHOW TABLES;
1276 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1277 SHOW CREATE TABLE t5;
1278 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1279 SHOW TABLES;
1280 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1281 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1282 CREATE TABLE t5(c1 YEAR NULL);
1283 SHOW TABLES;
1284 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1285 SHOW CREATE TABLE t5;
1286 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1287 SHOW TABLES;
1288 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1289 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1290 CREATE TABLE t5(c1 TINYBLOB NULL);
1291 SHOW TABLES;
1292 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1293 SHOW CREATE TABLE t5;
1294 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1295 SHOW TABLES;
1296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1297 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1298 CREATE TABLE t5(c1 BLOB NULL);
1299 SHOW TABLES;
1300 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1301 SHOW CREATE TABLE t5;
1302 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1303 SHOW TABLES;
1304 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1305 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1306 CREATE TABLE t5(c1 MEDIUMBLOB NULL);
1307 SHOW TABLES;
1308 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1309 SHOW CREATE TABLE t5;
1310 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1311 SHOW TABLES;
1312 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1313 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1314 CREATE TABLE t5(c1 LONGBLOB NULL);
1315 SHOW TABLES;
1316 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1317 SHOW CREATE TABLE t5;
1318 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1319 SHOW TABLES;
1320 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1321 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1322 CREATE TABLE t5(c1 TINYTEXT NULL);
1323 SHOW TABLES;
1324 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1325 SHOW CREATE TABLE t5;
1326 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1327 SHOW TABLES;
1328 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1329 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1330 CREATE TABLE t5(c1 TEXT NULL);
1331 SHOW TABLES;
1332 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1333 SHOW CREATE TABLE t5;
1334 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1335 SHOW TABLES;
1336 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1337 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1338 CREATE TABLE t5(c1 MEDIUMTEXT NULL);
1339 SHOW TABLES;
1340 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1341 SHOW CREATE TABLE t5;
1342 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1343 SHOW TABLES;
1344 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1345 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1346 CREATE TABLE t5(c1 LONGTEXT NULL);
1347 SHOW TABLES;
1348 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1349 SHOW CREATE TABLE t5;
1350 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL;
1351 SHOW TABLES;
1352 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1353 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1354 CREATE TABLE t5(c1 BIT NOT NULL);
1355 SHOW TABLES;
1356 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1357 SHOW CREATE TABLE t5;
1358 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1359 SHOW TABLES;
1360 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1361 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1362 CREATE TABLE t5(c1 TINYINT NOT NULL);
1363 SHOW TABLES;
1364 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1365 SHOW CREATE TABLE t5;
1366 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1367 SHOW TABLES;
1368 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1369 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1370 CREATE TABLE t5(c1 SMALLINT NOT NULL);
1371 SHOW TABLES;
1372 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1373 SHOW CREATE TABLE t5;
1374 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1375 SHOW TABLES;
1376 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1377 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1378 CREATE TABLE t5(c1 MEDIUMINT NOT NULL);
1379 SHOW TABLES;
1380 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1381 SHOW CREATE TABLE t5;
1382 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1383 SHOW TABLES;
1384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1385 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1386 CREATE TABLE t5(c1 INT NOT NULL);
1387 SHOW TABLES;
1388 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1389 SHOW CREATE TABLE t5;
1390 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1391 SHOW TABLES;
1392 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1393 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1394 CREATE TABLE t5(c1 INTEGER NOT NULL);
1395 SHOW TABLES;
1396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1397 SHOW CREATE TABLE t5;
1398 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1399 SHOW TABLES;
1400 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1401 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1402 CREATE TABLE t5(c1 BIGINT NOT NULL);
1403 SHOW TABLES;
1404 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1405 SHOW CREATE TABLE t5;
1406 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1407 SHOW TABLES;
1408 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1409 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1410 CREATE TABLE t5(c1 REAL NOT NULL);
1411 SHOW TABLES;
1412 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1413 SHOW CREATE TABLE t5;
1414 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1415 SHOW TABLES;
1416 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1417 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1418 CREATE TABLE t5(c1 DOUBLE NOT NULL);
1419 SHOW TABLES;
1420 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1421 SHOW CREATE TABLE t5;
1422 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1423 SHOW TABLES;
1424 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1425 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1426 CREATE TABLE t5(c1 FLOAT NOT NULL);
1427 SHOW TABLES;
1428 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1429 SHOW CREATE TABLE t5;
1430 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1431 SHOW TABLES;
1432 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1433 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1434 CREATE TABLE t5(c1 DECIMAL NOT NULL);
1435 SHOW TABLES;
1436 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1437 SHOW CREATE TABLE t5;
1438 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1439 SHOW TABLES;
1440 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1441 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1442 CREATE TABLE t5(c1 NUMERIC NOT NULL);
1443 SHOW TABLES;
1444 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1445 SHOW CREATE TABLE t5;
1446 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1447 SHOW TABLES;
1448 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1449 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1450 CREATE TABLE t5(c1 DATE NOT NULL);
1451 SHOW TABLES;
1452 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1453 SHOW CREATE TABLE t5;
1454 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1455 SHOW TABLES;
1456 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1457 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1458 CREATE TABLE t5(c1 TIME NOT NULL);
1459 SHOW TABLES;
1460 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1461 SHOW CREATE TABLE t5;
1462 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1463 SHOW TABLES;
1464 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1465 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1466 CREATE TABLE t5(c1 TIMESTAMP NOT NULL);
1467 SHOW TABLES;
1468 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1469 SHOW CREATE TABLE t5;
1470 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1471 SHOW TABLES;
1472 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1473 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1474 CREATE TABLE t5(c1 YEAR NOT NULL);
1475 SHOW TABLES;
1476 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1477 SHOW CREATE TABLE t5;
1478 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1479 SHOW TABLES;
1480 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1481 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1482 CREATE TABLE t5(c1 TINYBLOB NOT NULL);
1483 SHOW TABLES;
1484 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1485 SHOW CREATE TABLE t5;
1486 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1487 SHOW TABLES;
1488 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1489 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1490 CREATE TABLE t5(c1 BLOB NOT NULL);
1491 SHOW TABLES;
1492 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1493 SHOW CREATE TABLE t5;
1494 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1495 SHOW TABLES;
1496 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1497 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1498 CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL);
1499 SHOW TABLES;
1500 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1501 SHOW CREATE TABLE t5;
1502 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1503 SHOW TABLES;
1504 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1505 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1506 CREATE TABLE t5(c1 LONGBLOB NOT NULL);
1507 SHOW TABLES;
1508 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1509 SHOW CREATE TABLE t5;
1510 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1511 SHOW TABLES;
1512 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1513 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1514 CREATE TABLE t5(c1 TINYTEXT NOT NULL);
1515 SHOW TABLES;
1516 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1517 SHOW CREATE TABLE t5;
1518 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1519 SHOW TABLES;
1520 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1521 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1522 CREATE TABLE t5(c1 TEXT NOT NULL);
1523 SHOW TABLES;
1524 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1525 SHOW CREATE TABLE t5;
1526 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1527 SHOW TABLES;
1528 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1529 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1530 CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL);
1531 SHOW TABLES;
1532 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1533 SHOW CREATE TABLE t5;
1534 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1535 SHOW TABLES;
1536 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1537 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
1538 CREATE TABLE t5(c1 LONGTEXT NOT NULL);
1539 SHOW TABLES;
1540 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1541 SHOW CREATE TABLE t5;
1542 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL;
1543 SHOW TABLES;
1544 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1545 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;