Debian Codegraph @

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

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t4;
7 --enable_warnings
8 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
9 SHOW TABLES;
10 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
11 SHOW CREATE TABLE t4;
12 ALTER TABLE t4 MODIFY c1 TINYINT NULL;
13 SHOW TABLES;
14 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
15 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
16 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
17 SHOW TABLES;
18 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
19 SHOW CREATE TABLE t4;
20 ALTER TABLE t4 MODIFY c1 SMALLINT NULL;
21 SHOW TABLES;
22 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
24 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
25 SHOW TABLES;
26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
27 SHOW CREATE TABLE t4;
28 ALTER TABLE t4 MODIFY c1 MEDIUMINT NULL;
29 SHOW TABLES;
30 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
31 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
32 CREATE TABLE t4(c1 INT ZEROFILL NULL);
33 SHOW TABLES;
34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
35 SHOW CREATE TABLE t4;
36 ALTER TABLE t4 MODIFY c1 INT NULL;
37 SHOW TABLES;
38 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
40 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
41 SHOW TABLES;
42 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
43 SHOW CREATE TABLE t4;
44 ALTER TABLE t4 MODIFY c1 INTEGER NULL;
45 SHOW TABLES;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
47 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
48 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
49 SHOW TABLES;
50 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
51 SHOW CREATE TABLE t4;
52 ALTER TABLE t4 MODIFY c1 BIGINT NULL;
53 SHOW TABLES;
54 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
55 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
56 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
57 SHOW TABLES;
58 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
59 SHOW CREATE TABLE t4;
60 ALTER TABLE t4 MODIFY c1 REAL NULL;
61 SHOW TABLES;
62 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
63 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
64 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
65 SHOW TABLES;
66 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
67 SHOW CREATE TABLE t4;
68 ALTER TABLE t4 MODIFY c1 DOUBLE NULL;
69 SHOW TABLES;
70 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
71 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
72 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
73 SHOW TABLES;
74 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
75 SHOW CREATE TABLE t4;
76 ALTER TABLE t4 MODIFY c1 FLOAT NULL;
77 SHOW TABLES;
78 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
79 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
80 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
81 SHOW TABLES;
82 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
83 SHOW CREATE TABLE t4;
84 ALTER TABLE t4 MODIFY c1 DECIMAL NULL;
85 SHOW TABLES;
86 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
87 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
88 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
89 SHOW TABLES;
90 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
91 SHOW CREATE TABLE t4;
92 ALTER TABLE t4 MODIFY c1 NUMERIC NULL;
93 SHOW TABLES;
94 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
95 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
96 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
97 SHOW TABLES;
98 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
99 SHOW CREATE TABLE t4;
100 ALTER TABLE t4 CHANGE c1 c1 TINYINT NULL;
101 SHOW TABLES;
102 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
103 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
104 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
105 SHOW TABLES;
106 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
107 SHOW CREATE TABLE t4;
108 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NULL;
109 SHOW TABLES;
110 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
111 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
112 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
113 SHOW TABLES;
114 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
115 SHOW CREATE TABLE t4;
116 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NULL;
117 SHOW TABLES;
118 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
119 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
120 CREATE TABLE t4(c1 INT ZEROFILL NULL);
121 SHOW TABLES;
122 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
123 SHOW CREATE TABLE t4;
124 ALTER TABLE t4 CHANGE c1 c1 INT NULL;
125 SHOW TABLES;
126 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
127 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
128 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
129 SHOW TABLES;
130 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
131 SHOW CREATE TABLE t4;
132 ALTER TABLE t4 CHANGE c1 c1 INTEGER NULL;
133 SHOW TABLES;
134 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
135 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
136 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
137 SHOW TABLES;
138 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
139 SHOW CREATE TABLE t4;
140 ALTER TABLE t4 CHANGE c1 c1 BIGINT NULL;
141 SHOW TABLES;
142 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
143 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
144 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
145 SHOW TABLES;
146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
147 SHOW CREATE TABLE t4;
148 ALTER TABLE t4 CHANGE c1 c1 REAL NULL;
149 SHOW TABLES;
150 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
151 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
152 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
153 SHOW TABLES;
154 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
155 SHOW CREATE TABLE t4;
156 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NULL;
157 SHOW TABLES;
158 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
159 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
160 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
161 SHOW TABLES;
162 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
163 SHOW CREATE TABLE t4;
164 ALTER TABLE t4 CHANGE c1 c1 FLOAT NULL;
165 SHOW TABLES;
166 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
167 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
168 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
169 SHOW TABLES;
170 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
171 SHOW CREATE TABLE t4;
172 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NULL;
173 SHOW TABLES;
174 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
175 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
176 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
177 SHOW TABLES;
178 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
179 SHOW CREATE TABLE t4;
180 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NULL;
181 SHOW TABLES;
182 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
183 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
184 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
185 SHOW TABLES;
186 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
187 SHOW CREATE TABLE t4;
188 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NULL;
189 SHOW TABLES;
190 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
191 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
192 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
193 SHOW TABLES;
194 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
195 SHOW CREATE TABLE t4;
196 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED NULL;
197 SHOW TABLES;
198 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
199 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
200 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
201 SHOW TABLES;
202 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
203 SHOW CREATE TABLE t4;
204 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NULL;
205 SHOW TABLES;
206 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
207 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
208 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
209 SHOW TABLES;
210 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
211 SHOW CREATE TABLE t4;
212 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NULL;
213 SHOW TABLES;
214 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
215 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
216 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
217 SHOW TABLES;
218 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
219 SHOW CREATE TABLE t4;
220 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NULL;
221 SHOW TABLES;
222 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
223 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
224 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
225 SHOW TABLES;
226 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
227 SHOW CREATE TABLE t4;
228 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED NULL;
229 SHOW TABLES;
230 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
231 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
232 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
233 SHOW TABLES;
234 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
235 SHOW CREATE TABLE t4;
236 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NULL;
237 SHOW TABLES;
238 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
239 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
240 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
241 SHOW TABLES;
242 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
243 SHOW CREATE TABLE t4;
244 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NULL;
245 SHOW TABLES;
246 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
247 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
248 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
249 SHOW TABLES;
250 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
251 SHOW CREATE TABLE t4;
252 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NULL;
253 SHOW TABLES;
254 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
255 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
256 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
257 SHOW TABLES;
258 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
259 SHOW CREATE TABLE t4;
260 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED NULL;
261 SHOW TABLES;
262 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
263 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
264 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
265 SHOW TABLES;
266 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
267 SHOW CREATE TABLE t4;
268 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NULL;
269 SHOW TABLES;
270 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
271 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
272 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
273 SHOW TABLES;
274 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
275 SHOW CREATE TABLE t4;
276 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NULL;
277 SHOW TABLES;
278 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
279 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
280 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
281 SHOW TABLES;
282 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
283 SHOW CREATE TABLE t4;
284 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NULL;
285 SHOW TABLES;
286 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
287 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
288 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
289 SHOW TABLES;
290 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
291 SHOW CREATE TABLE t4;
292 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL;
293 SHOW TABLES;
294 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
295 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
296 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
297 SHOW TABLES;
298 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
299 SHOW CREATE TABLE t4;
300 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NULL;
301 SHOW TABLES;
302 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
303 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
304 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
305 SHOW TABLES;
306 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
307 SHOW CREATE TABLE t4;
308 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NULL;
309 SHOW TABLES;
310 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
311 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
312 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
313 SHOW TABLES;
314 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
315 SHOW CREATE TABLE t4;
316 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NULL;
317 SHOW TABLES;
318 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
319 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
320 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
321 SHOW TABLES;
322 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
323 SHOW CREATE TABLE t4;
324 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NULL;
325 SHOW TABLES;
326 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
327 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
328 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
329 SHOW TABLES;
330 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
331 SHOW CREATE TABLE t4;
332 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NULL;
333 SHOW TABLES;
334 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
335 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
336 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
337 SHOW TABLES;
338 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
339 SHOW CREATE TABLE t4;
340 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NULL;
341 SHOW TABLES;
342 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
343 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
344 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
345 SHOW TABLES;
346 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
347 SHOW CREATE TABLE t4;
348 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NULL;
349 SHOW TABLES;
350 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
351 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
352 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
353 SHOW TABLES;
354 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
355 SHOW CREATE TABLE t4;
356 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NULL;
357 SHOW TABLES;
358 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
359 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
360 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
361 SHOW TABLES;
362 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
363 SHOW CREATE TABLE t4;
364 ALTER TABLE t4 MODIFY c1 TINYINT NOT NULL;
365 SHOW TABLES;
366 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
367 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
368 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
369 SHOW TABLES;
370 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
371 SHOW CREATE TABLE t4;
372 ALTER TABLE t4 MODIFY c1 SMALLINT NOT NULL;
373 SHOW TABLES;
374 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
375 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
376 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
377 SHOW TABLES;
378 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
379 SHOW CREATE TABLE t4;
380 ALTER TABLE t4 MODIFY c1 MEDIUMINT NOT NULL;
381 SHOW TABLES;
382 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
383 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
384 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
385 SHOW TABLES;
386 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
387 SHOW CREATE TABLE t4;
388 ALTER TABLE t4 MODIFY c1 INT NOT NULL;
389 SHOW TABLES;
390 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
391 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
392 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
393 SHOW TABLES;
394 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
395 SHOW CREATE TABLE t4;
396 ALTER TABLE t4 MODIFY c1 INTEGER NOT NULL;
397 SHOW TABLES;
398 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
399 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
400 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
401 SHOW TABLES;
402 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
403 SHOW CREATE TABLE t4;
404 ALTER TABLE t4 MODIFY c1 BIGINT NOT NULL;
405 SHOW TABLES;
406 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
407 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
408 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
409 SHOW TABLES;
410 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
411 SHOW CREATE TABLE t4;
412 ALTER TABLE t4 MODIFY c1 REAL NOT NULL;
413 SHOW TABLES;
414 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
415 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
416 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
417 SHOW TABLES;
418 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
419 SHOW CREATE TABLE t4;
420 ALTER TABLE t4 MODIFY c1 DOUBLE NOT NULL;
421 SHOW TABLES;
422 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
423 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
424 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
425 SHOW TABLES;
426 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
427 SHOW CREATE TABLE t4;
428 ALTER TABLE t4 MODIFY c1 FLOAT NOT NULL;
429 SHOW TABLES;
430 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
431 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
432 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
433 SHOW TABLES;
434 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
435 SHOW CREATE TABLE t4;
436 ALTER TABLE t4 MODIFY c1 DECIMAL NOT NULL;
437 SHOW TABLES;
438 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
439 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
440 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
441 SHOW TABLES;
442 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
443 SHOW CREATE TABLE t4;
444 ALTER TABLE t4 MODIFY c1 NUMERIC NOT NULL;
445 SHOW TABLES;
446 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
447 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
448 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
449 SHOW TABLES;
450 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
451 SHOW CREATE TABLE t4;
452 ALTER TABLE t4 CHANGE c1 c1 TINYINT NOT NULL;
453 SHOW TABLES;
454 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
455 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
456 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
457 SHOW TABLES;
458 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
459 SHOW CREATE TABLE t4;
460 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NOT NULL;
461 SHOW TABLES;
462 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
463 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
464 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
465 SHOW TABLES;
466 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
467 SHOW CREATE TABLE t4;
468 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NOT NULL;
469 SHOW TABLES;
470 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
471 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
472 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
473 SHOW TABLES;
474 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
475 SHOW CREATE TABLE t4;
476 ALTER TABLE t4 CHANGE c1 c1 INT NOT NULL;
477 SHOW TABLES;
478 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
479 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
480 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
481 SHOW TABLES;
482 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
483 SHOW CREATE TABLE t4;
484 ALTER TABLE t4 CHANGE c1 c1 INTEGER NOT NULL;
485 SHOW TABLES;
486 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
487 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
488 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
489 SHOW TABLES;
490 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
491 SHOW CREATE TABLE t4;
492 ALTER TABLE t4 CHANGE c1 c1 BIGINT NOT NULL;
493 SHOW TABLES;
494 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
495 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
496 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
497 SHOW TABLES;
498 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
499 SHOW CREATE TABLE t4;
500 ALTER TABLE t4 CHANGE c1 c1 REAL NOT NULL;
501 SHOW TABLES;
502 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
503 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
504 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
505 SHOW TABLES;
506 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
507 SHOW CREATE TABLE t4;
508 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NOT NULL;
509 SHOW TABLES;
510 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
511 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
512 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
513 SHOW TABLES;
514 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
515 SHOW CREATE TABLE t4;
516 ALTER TABLE t4 CHANGE c1 c1 FLOAT NOT NULL;
517 SHOW TABLES;
518 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
519 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
520 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
521 SHOW TABLES;
522 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
523 SHOW CREATE TABLE t4;
524 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NOT NULL;
525 SHOW TABLES;
526 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
527 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
528 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
529 SHOW TABLES;
530 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
531 SHOW CREATE TABLE t4;
532 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NOT NULL;
533 SHOW TABLES;
534 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
535 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
536 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
537 SHOW TABLES;
538 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
539 SHOW CREATE TABLE t4;
540 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NOT NULL;
541 SHOW TABLES;
542 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
543 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
544 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
545 SHOW TABLES;
546 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
547 SHOW CREATE TABLE t4;
548 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED NOT NULL;
549 SHOW TABLES;
550 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
551 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
552 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
553 SHOW TABLES;
554 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
555 SHOW CREATE TABLE t4;
556 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL;
557 SHOW TABLES;
558 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
559 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
560 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
561 SHOW TABLES;
562 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
563 SHOW CREATE TABLE t4;
564 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NOT NULL;
565 SHOW TABLES;
566 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
567 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
568 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
569 SHOW TABLES;
570 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
571 SHOW CREATE TABLE t4;
572 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NOT NULL;
573 SHOW TABLES;
574 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
575 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
576 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
577 SHOW TABLES;
578 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
579 SHOW CREATE TABLE t4;
580 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED NOT NULL;
581 SHOW TABLES;
582 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
583 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
584 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
585 SHOW TABLES;
586 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
587 SHOW CREATE TABLE t4;
588 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NOT NULL;
589 SHOW TABLES;
590 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
591 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
592 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
593 SHOW TABLES;
594 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
595 SHOW CREATE TABLE t4;
596 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NOT NULL;
597 SHOW TABLES;
598 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
599 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
600 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
601 SHOW TABLES;
602 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
603 SHOW CREATE TABLE t4;
604 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NOT NULL;
605 SHOW TABLES;
606 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
607 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
608 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
609 SHOW TABLES;
610 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
611 SHOW CREATE TABLE t4;
612 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED NOT NULL;
613 SHOW TABLES;
614 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
615 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
616 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
617 SHOW TABLES;
618 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
619 SHOW CREATE TABLE t4;
620 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
621 SHOW TABLES;
622 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
623 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
624 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
625 SHOW TABLES;
626 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
627 SHOW CREATE TABLE t4;
628 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL;
629 SHOW TABLES;
630 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
631 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
632 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
633 SHOW TABLES;
634 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
635 SHOW CREATE TABLE t4;
636 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL;
637 SHOW TABLES;
638 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
639 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
640 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
641 SHOW TABLES;
642 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
643 SHOW CREATE TABLE t4;
644 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL;
645 SHOW TABLES;
646 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
647 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
648 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
649 SHOW TABLES;
650 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
651 SHOW CREATE TABLE t4;
652 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NOT NULL;
653 SHOW TABLES;
654 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
655 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
656 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
657 SHOW TABLES;
658 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
659 SHOW CREATE TABLE t4;
660 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;
661 SHOW TABLES;
662 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
663 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
664 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
665 SHOW TABLES;
666 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
667 SHOW CREATE TABLE t4;
668 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL;
669 SHOW TABLES;
670 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
671 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
672 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
673 SHOW TABLES;
674 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
675 SHOW CREATE TABLE t4;
676 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NOT NULL;
677 SHOW TABLES;
678 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
679 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
680 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
681 SHOW TABLES;
682 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
683 SHOW CREATE TABLE t4;
684 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL;
685 SHOW TABLES;
686 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
687 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
688 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
689 SHOW TABLES;
690 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
691 SHOW CREATE TABLE t4;
692 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL;
693 SHOW TABLES;
694 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
695 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
696 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
697 SHOW TABLES;
698 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
699 SHOW CREATE TABLE t4;
700 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL;
701 SHOW TABLES;
702 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
703 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
704 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
705 SHOW TABLES;
706 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
707 SHOW CREATE TABLE t4;
708 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL;
709 SHOW TABLES;
710 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
711 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
712