Debian Codegraph @

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