Debian Codegraph @

mysql-test/suite/engines/funcs/t/ta_add_unique_index.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 t1;
9 --enable_warnings
10 CREATE TABLE t1(c1 BIT NOT NULL);
11 SHOW TABLES;
12 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
13 SHOW CREATE TABLE t1;
14 ALTER TABLE t1 ADD UNIQUE (c1);
15 SHOW TABLES;
16 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
17 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
18 CREATE TABLE t1(c1 TINYINT NOT NULL);
19 SHOW TABLES;
20 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
21 SHOW CREATE TABLE t1;
22 ALTER TABLE t1 ADD UNIQUE (c1);
23 SHOW TABLES;
24 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
25 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
26 CREATE TABLE t1(c1 SMALLINT NOT NULL);
27 SHOW TABLES;
28 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29 SHOW CREATE TABLE t1;
30 ALTER TABLE t1 ADD UNIQUE (c1);
31 SHOW TABLES;
32 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
33 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
34 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
35 SHOW TABLES;
36 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
37 SHOW CREATE TABLE t1;
38 ALTER TABLE t1 ADD UNIQUE (c1);
39 SHOW TABLES;
40 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
41 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
42 CREATE TABLE t1(c1 INT NOT NULL);
43 SHOW TABLES;
44 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
45 SHOW CREATE TABLE t1;
46 ALTER TABLE t1 ADD UNIQUE (c1);
47 SHOW TABLES;
48 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
49 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
50 CREATE TABLE t1(c1 INTEGER NOT NULL);
51 SHOW TABLES;
52 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
53 SHOW CREATE TABLE t1;
54 ALTER TABLE t1 ADD UNIQUE (c1);
55 SHOW TABLES;
56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
57 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
58 CREATE TABLE t1(c1 BIGINT NOT NULL);
59 SHOW TABLES;
60 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
61 SHOW CREATE TABLE t1;
62 ALTER TABLE t1 ADD UNIQUE (c1);
63 SHOW TABLES;
64 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
65 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
66 CREATE TABLE t1(c1 REAL NOT NULL);
67 SHOW TABLES;
68 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
69 SHOW CREATE TABLE t1;
70 ALTER TABLE t1 ADD UNIQUE (c1);
71 SHOW TABLES;
72 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
73 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
74 CREATE TABLE t1(c1 DOUBLE NOT NULL);
75 SHOW TABLES;
76 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
77 SHOW CREATE TABLE t1;
78 ALTER TABLE t1 ADD UNIQUE (c1);
79 SHOW TABLES;
80 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
81 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
82 CREATE TABLE t1(c1 FLOAT NOT NULL);
83 SHOW TABLES;
84 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
85 SHOW CREATE TABLE t1;
86 ALTER TABLE t1 ADD UNIQUE (c1);
87 SHOW TABLES;
88 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
90 CREATE TABLE t1(c1 DECIMAL NOT NULL);
91 SHOW TABLES;
92 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93 SHOW CREATE TABLE t1;
94 ALTER TABLE t1 ADD UNIQUE (c1);
95 SHOW TABLES;
96 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
97 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
98 CREATE TABLE t1(c1 NUMERIC NOT NULL);
99 SHOW TABLES;
100 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
101 SHOW CREATE TABLE t1;
102 ALTER TABLE t1 ADD UNIQUE (c1);
103 SHOW TABLES;
104 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
105 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
106 CREATE TABLE t1(c1 DATE NOT NULL);
107 SHOW TABLES;
108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
109 SHOW CREATE TABLE t1;
110 ALTER TABLE t1 ADD UNIQUE (c1);
111 SHOW TABLES;
112 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
113 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
114 CREATE TABLE t1(c1 TIME NOT NULL);
115 SHOW TABLES;
116 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
117 SHOW CREATE TABLE t1;
118 ALTER TABLE t1 ADD UNIQUE (c1);
119 SHOW TABLES;
120 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
121 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
122 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
123 SHOW TABLES;
124 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
125 SHOW CREATE TABLE t1;
126 ALTER TABLE t1 ADD UNIQUE (c1);
127 SHOW TABLES;
128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
129 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
130 CREATE TABLE t1(c1 YEAR NOT NULL);
131 SHOW TABLES;
132 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
133 SHOW CREATE TABLE t1;
134 ALTER TABLE t1 ADD UNIQUE (c1);
135 SHOW TABLES;
136 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
137 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
138 CREATE TABLE t1(c1 BIT NOT NULL);
139 SHOW TABLES;
140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
141 SHOW CREATE TABLE t1;
142 ALTER TABLE t1 ADD UNIQUE KEY (c1);
143 SHOW TABLES;
144 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
145 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
146 CREATE TABLE t1(c1 TINYINT NOT NULL);
147 SHOW TABLES;
148 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
149 SHOW CREATE TABLE t1;
150 ALTER TABLE t1 ADD UNIQUE KEY (c1);
151 SHOW TABLES;
152 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
153 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
154 CREATE TABLE t1(c1 SMALLINT NOT NULL);
155 SHOW TABLES;
156 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
157 SHOW CREATE TABLE t1;
158 ALTER TABLE t1 ADD UNIQUE KEY (c1);
159 SHOW TABLES;
160 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
161 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
162 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
163 SHOW TABLES;
164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
165 SHOW CREATE TABLE t1;
166 ALTER TABLE t1 ADD UNIQUE KEY (c1);
167 SHOW TABLES;
168 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
169 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
170 CREATE TABLE t1(c1 INT NOT NULL);
171 SHOW TABLES;
172 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
173 SHOW CREATE TABLE t1;
174 ALTER TABLE t1 ADD UNIQUE KEY (c1);
175 SHOW TABLES;
176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
177 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
178 CREATE TABLE t1(c1 INTEGER NOT NULL);
179 SHOW TABLES;
180 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
181 SHOW CREATE TABLE t1;
182 ALTER TABLE t1 ADD UNIQUE KEY (c1);
183 SHOW TABLES;
184 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
185 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
186 CREATE TABLE t1(c1 BIGINT NOT NULL);
187 SHOW TABLES;
188 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
189 SHOW CREATE TABLE t1;
190 ALTER TABLE t1 ADD UNIQUE KEY (c1);
191 SHOW TABLES;
192 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
193 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
194 CREATE TABLE t1(c1 REAL NOT NULL);
195 SHOW TABLES;
196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
197 SHOW CREATE TABLE t1;
198 ALTER TABLE t1 ADD UNIQUE KEY (c1);
199 SHOW TABLES;
200 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
201 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
202 CREATE TABLE t1(c1 DOUBLE NOT NULL);
203 SHOW TABLES;
204 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
205 SHOW CREATE TABLE t1;
206 ALTER TABLE t1 ADD UNIQUE KEY (c1);
207 SHOW TABLES;
208 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
209 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
210 CREATE TABLE t1(c1 FLOAT NOT NULL);
211 SHOW TABLES;
212 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
213 SHOW CREATE TABLE t1;
214 ALTER TABLE t1 ADD UNIQUE KEY (c1);
215 SHOW TABLES;
216 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
217 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
218 CREATE TABLE t1(c1 DECIMAL NOT NULL);
219 SHOW TABLES;
220 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
221 SHOW CREATE TABLE t1;
222 ALTER TABLE t1 ADD UNIQUE KEY (c1);
223 SHOW TABLES;
224 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
225 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
226 CREATE TABLE t1(c1 NUMERIC NOT NULL);
227 SHOW TABLES;
228 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
229 SHOW CREATE TABLE t1;
230 ALTER TABLE t1 ADD UNIQUE KEY (c1);
231 SHOW TABLES;
232 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
234 CREATE TABLE t1(c1 DATE NOT NULL);
235 SHOW TABLES;
236 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
237 SHOW CREATE TABLE t1;
238 ALTER TABLE t1 ADD UNIQUE KEY (c1);
239 SHOW TABLES;
240 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
241 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
242 CREATE TABLE t1(c1 TIME NOT NULL);
243 SHOW TABLES;
244 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
245 SHOW CREATE TABLE t1;
246 ALTER TABLE t1 ADD UNIQUE KEY (c1);
247 SHOW TABLES;
248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
249 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
250 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
251 SHOW TABLES;
252 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
253 SHOW CREATE TABLE t1;
254 ALTER TABLE t1 ADD UNIQUE KEY (c1);
255 SHOW TABLES;
256 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
257 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
258 CREATE TABLE t1(c1 YEAR NOT NULL);
259 SHOW TABLES;
260 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
261 SHOW CREATE TABLE t1;
262 ALTER TABLE t1 ADD UNIQUE KEY (c1);
263 SHOW TABLES;
264 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
265 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
266 CREATE TABLE t1(c1 BIT NOT NULL);
267 SHOW TABLES;
268 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
269 SHOW CREATE TABLE t1;
270 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
271 SHOW TABLES;
272 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
273 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
274 CREATE TABLE t1(c1 TINYINT NOT NULL);
275 SHOW TABLES;
276 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
277 SHOW CREATE TABLE t1;
278 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
279 SHOW TABLES;
280 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
281 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
282 CREATE TABLE t1(c1 SMALLINT NOT NULL);
283 SHOW TABLES;
284 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
285 SHOW CREATE TABLE t1;
286 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
287 SHOW TABLES;
288 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
289 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
290 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
291 SHOW TABLES;
292 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
293 SHOW CREATE TABLE t1;
294 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
295 SHOW TABLES;
296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
297 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
298 CREATE TABLE t1(c1 INT NOT NULL);
299 SHOW TABLES;
300 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
301 SHOW CREATE TABLE t1;
302 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
303 SHOW TABLES;
304 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
305 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
306 CREATE TABLE t1(c1 INTEGER NOT NULL);
307 SHOW TABLES;
308 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
309 SHOW CREATE TABLE t1;
310 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
311 SHOW TABLES;
312 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
313 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
314 CREATE TABLE t1(c1 BIGINT NOT NULL);
315 SHOW TABLES;
316 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
317 SHOW CREATE TABLE t1;
318 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
319 SHOW TABLES;
320 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
321 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
322 CREATE TABLE t1(c1 REAL NOT NULL);
323 SHOW TABLES;
324 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
325 SHOW CREATE TABLE t1;
326 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
327 SHOW TABLES;
328 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
329 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
330 CREATE TABLE t1(c1 DOUBLE NOT NULL);
331 SHOW TABLES;
332 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
333 SHOW CREATE TABLE t1;
334 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
335 SHOW TABLES;
336 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
337 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
338 CREATE TABLE t1(c1 FLOAT NOT NULL);
339 SHOW TABLES;
340 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
341 SHOW CREATE TABLE t1;
342 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
343 SHOW TABLES;
344 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
345 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
346 CREATE TABLE t1(c1 DECIMAL NOT NULL);
347 SHOW TABLES;
348 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
349 SHOW CREATE TABLE t1;
350 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
351 SHOW TABLES;
352 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
353 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
354 CREATE TABLE t1(c1 NUMERIC NOT NULL);
355 SHOW TABLES;
356 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
357 SHOW CREATE TABLE t1;
358 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
359 SHOW TABLES;
360 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
361 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
362 CREATE TABLE t1(c1 DATE NOT NULL);
363 SHOW TABLES;
364 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
365 SHOW CREATE TABLE t1;
366 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
367 SHOW TABLES;
368 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
369 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
370 CREATE TABLE t1(c1 TIME NOT NULL);
371 SHOW TABLES;
372 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
373 SHOW CREATE TABLE t1;
374 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
375 SHOW TABLES;
376 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
377 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
378 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
379 SHOW TABLES;
380 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
381 SHOW CREATE TABLE t1;
382 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
383 SHOW TABLES;
384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
385 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
386 CREATE TABLE t1(c1 YEAR NOT NULL);
387 SHOW TABLES;
388 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
389 SHOW CREATE TABLE t1;
390 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
391 SHOW TABLES;
392 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
393 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
394 CREATE TABLE t1(c1 BIT NOT NULL);
395 SHOW TABLES;
396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
397 SHOW CREATE TABLE t1;
398 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
399 SHOW TABLES;
400 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
401 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
402 CREATE TABLE t1(c1 TINYINT NOT NULL);
403 SHOW TABLES;
404 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
405 SHOW CREATE TABLE t1;
406 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
407 SHOW TABLES;
408 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
409 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
410 CREATE TABLE t1(c1 SMALLINT NOT NULL);
411 SHOW TABLES;
412 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
413 SHOW CREATE TABLE t1;
414 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
415 SHOW TABLES;
416 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
417 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
418 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
419 SHOW TABLES;
420 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
421 SHOW CREATE TABLE t1;
422 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
423 SHOW TABLES;
424 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
425 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
426 CREATE TABLE t1(c1 INT NOT NULL);
427 SHOW TABLES;
428 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
429 SHOW CREATE TABLE t1;
430 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
431 SHOW TABLES;
432 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
433 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
434 CREATE TABLE t1(c1 INTEGER NOT NULL);
435 SHOW TABLES;
436 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
437 SHOW CREATE TABLE t1;
438 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
439 SHOW TABLES;
440 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
441 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
442 CREATE TABLE t1(c1 BIGINT NOT NULL);
443 SHOW TABLES;
444 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
445 SHOW CREATE TABLE t1;
446 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
447 SHOW TABLES;
448 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
449 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
450 CREATE TABLE t1(c1 REAL NOT NULL);
451 SHOW TABLES;
452 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
453 SHOW CREATE TABLE t1;
454 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
455 SHOW TABLES;
456 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
457 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
458 CREATE TABLE t1(c1 DOUBLE NOT NULL);
459 SHOW TABLES;
460 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
461 SHOW CREATE TABLE t1;
462 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
463 SHOW TABLES;
464 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
465 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
466 CREATE TABLE t1(c1 FLOAT NOT NULL);
467 SHOW TABLES;
468 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
469 SHOW CREATE TABLE t1;
470 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
471 SHOW TABLES;
472 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
473 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
474 CREATE TABLE t1(c1 DECIMAL NOT NULL);
475 SHOW TABLES;
476 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
477 SHOW CREATE TABLE t1;
478 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
479 SHOW TABLES;
480 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
481 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
482 CREATE TABLE t1(c1 NUMERIC NOT NULL);
483 SHOW TABLES;
484 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
485 SHOW CREATE TABLE t1;
486 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
487 SHOW TABLES;
488 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
489 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
490 CREATE TABLE t1(c1 DATE NOT NULL);
491 SHOW TABLES;
492 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
493 SHOW CREATE TABLE t1;
494 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
495 SHOW TABLES;
496 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
497 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
498 CREATE TABLE t1(c1 TIME NOT NULL);
499 SHOW TABLES;
500 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
501 SHOW CREATE TABLE t1;
502 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
503 SHOW TABLES;
504 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
505 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
506 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
507 SHOW TABLES;
508 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
509 SHOW CREATE TABLE t1;
510 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
511 SHOW TABLES;
512 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
513 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
514 CREATE TABLE t1(c1 YEAR NOT NULL);
515 SHOW TABLES;
516 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
517 SHOW CREATE TABLE t1;
518 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
519 SHOW TABLES;
520 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
521 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
522 CREATE TABLE t1(c1 BIT NOT NULL);
523 SHOW TABLES;
524 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
525 SHOW CREATE TABLE t1;
526 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
527 SHOW TABLES;
528 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
529 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
530 CREATE TABLE t1(c1 TINYINT NOT NULL);
531 SHOW TABLES;
532 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
533 SHOW CREATE TABLE t1;
534 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
535 SHOW TABLES;
536 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
537 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
538 CREATE TABLE t1(c1 SMALLINT NOT NULL);
539 SHOW TABLES;
540 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
541 SHOW CREATE TABLE t1;
542 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
543 SHOW TABLES;
544 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
545 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
546 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
547 SHOW TABLES;
548 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
549 SHOW CREATE TABLE t1;
550 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
551 SHOW TABLES;
552 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
553 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
554 CREATE TABLE t1(c1 INT NOT NULL);
555 SHOW TABLES;
556 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
557 SHOW CREATE TABLE t1;
558 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
559 SHOW TABLES;
560 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
561 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
562 CREATE TABLE t1(c1 INTEGER NOT NULL);
563 SHOW TABLES;
564 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
565 SHOW CREATE TABLE t1;
566 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
567 SHOW TABLES;
568 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
569 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
570 CREATE TABLE t1(c1 BIGINT NOT NULL);
571 SHOW TABLES;
572 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
573 SHOW CREATE TABLE t1;
574 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
575 SHOW TABLES;
576 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
577 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
578 CREATE TABLE t1(c1 REAL NOT NULL);
579 SHOW TABLES;
580 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
581 SHOW CREATE TABLE t1;
582 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
583 SHOW TABLES;
584 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
585 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
586 CREATE TABLE t1(c1 DOUBLE NOT NULL);
587 SHOW TABLES;
588 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
589 SHOW CREATE TABLE t1;
590 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
591 SHOW TABLES;
592 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
593 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
594 CREATE TABLE t1(c1 FLOAT NOT NULL);
595 SHOW TABLES;
596 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
597 SHOW CREATE TABLE t1;
598 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
599 SHOW TABLES;
600 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
601 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
602 CREATE TABLE t1(c1 DECIMAL NOT NULL);
603 SHOW TABLES;
604 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
605 SHOW CREATE TABLE t1;
606 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
607 SHOW TABLES;
608 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
609 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
610 CREATE TABLE t1(c1 NUMERIC NOT NULL);
611 SHOW TABLES;
612 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
613 SHOW CREATE TABLE t1;
614 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
615 SHOW TABLES;
616 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
617 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
618 CREATE TABLE t1(c1 DATE NOT NULL);
619 SHOW TABLES;
620 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
621 SHOW CREATE TABLE t1;
622 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
623 SHOW TABLES;
624 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
625 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
626 CREATE TABLE t1(c1 TIME NOT NULL);
627 SHOW TABLES;
628 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
629 SHOW CREATE TABLE t1;
630 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
631 SHOW TABLES;
632 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
633 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
634 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
635 SHOW TABLES;
636 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
637 SHOW CREATE TABLE t1;
638 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
639 SHOW TABLES;
640 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
641 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
642 CREATE TABLE t1(c1 YEAR NOT NULL);
643 SHOW TABLES;
644 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
645 SHOW CREATE TABLE t1;
646 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
647 SHOW TABLES;
648 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
649 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
650 CREATE TABLE t1(c1 BIT NOT NULL);
651 SHOW TABLES;
652 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
653 SHOW CREATE TABLE t1;
654 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
655 SHOW TABLES;
656 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
657 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
658 CREATE TABLE t1(c1 TINYINT NOT NULL);
659 SHOW TABLES;
660 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
661 SHOW CREATE TABLE t1;
662 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
663 SHOW TABLES;
664 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
665 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
666 CREATE TABLE t1(c1 SMALLINT NOT NULL);
667 SHOW TABLES;
668 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
669 SHOW CREATE TABLE t1;
670 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
671 SHOW TABLES;
672 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
673 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
674 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
675 SHOW TABLES;
676 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
677 SHOW CREATE TABLE t1;
678 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
679 SHOW TABLES;
680 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
681 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
682 CREATE TABLE t1(c1 INT NOT NULL);
683 SHOW TABLES;
684 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
685 SHOW CREATE TABLE t1;
686 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
687 SHOW TABLES;
688 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
689 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
690 CREATE TABLE t1(c1 INTEGER NOT NULL);
691 SHOW TABLES;
692 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
693 SHOW CREATE TABLE t1;
694 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
695 SHOW TABLES;
696 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
697 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
698 CREATE TABLE t1(c1 BIGINT NOT NULL);
699 SHOW TABLES;
700 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
701 SHOW CREATE TABLE t1;
702 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
703 SHOW TABLES;
704 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
705 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
706 CREATE TABLE t1(c1 REAL NOT NULL);
707 SHOW TABLES;
708 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
709 SHOW CREATE TABLE t1;
710 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
711 SHOW TABLES;
712 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
713 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
714 CREATE TABLE t1(c1 DOUBLE NOT NULL);
715 SHOW TABLES;
716 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
717 SHOW CREATE TABLE t1;
718 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
719 SHOW TABLES;
720 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
721 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
722 CREATE TABLE t1(c1 FLOAT NOT NULL);
723 SHOW TABLES;
724 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
725 SHOW CREATE TABLE t1;
726 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
727 SHOW TABLES;
728 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
729 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
730 CREATE TABLE t1(c1 DECIMAL NOT NULL);
731 SHOW TABLES;
732 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
733 SHOW CREATE TABLE t1;
734 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
735 SHOW TABLES;
736 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
737 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
738 CREATE TABLE t1(c1 NUMERIC NOT NULL);
739 SHOW TABLES;
740 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
741 SHOW CREATE TABLE t1;
742 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
743 SHOW TABLES;
744 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
745 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
746 CREATE TABLE t1(c1 DATE NOT NULL);
747 SHOW TABLES;
748 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
749 SHOW CREATE TABLE t1;
750 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
751 SHOW TABLES;
752 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
753 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
754 CREATE TABLE t1(c1 TIME NOT NULL);
755 SHOW TABLES;
756 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
757 SHOW CREATE TABLE t1;
758 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
759 SHOW TABLES;
760 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
761 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
762 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
763 SHOW TABLES;
764 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
765 SHOW CREATE TABLE t1;
766 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
767 SHOW TABLES;
768 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
769 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
770 CREATE TABLE t1(c1 YEAR NOT NULL);
771 SHOW TABLES;
772 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
773 SHOW CREATE TABLE t1;
774 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
775 SHOW TABLES;
776 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
777 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
778 CREATE TABLE t1(c1 BIT NOT NULL);
779 SHOW TABLES;
780 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
781 SHOW CREATE TABLE t1;
782 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
783 SHOW TABLES;
784 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
785 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
786 CREATE TABLE t1(c1 TINYINT NOT NULL);
787 SHOW TABLES;
788 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
789 SHOW CREATE TABLE t1;
790 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
791 SHOW TABLES;
792 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
793 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
794 CREATE TABLE t1(c1 SMALLINT NOT NULL);
795 SHOW TABLES;
796 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
797 SHOW CREATE TABLE t1;
798 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
799 SHOW TABLES;
800 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
801 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
802 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
803 SHOW TABLES;
804 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
805 SHOW CREATE TABLE t1;
806 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
807 SHOW TABLES;
808 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
809 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
810 CREATE TABLE t1(c1 INT NOT NULL);
811 SHOW TABLES;
812 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
813 SHOW CREATE TABLE t1;
814 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
815 SHOW TABLES;
816 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
817 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
818 CREATE TABLE t1(c1 INTEGER NOT NULL);
819 SHOW TABLES;
820 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
821 SHOW CREATE TABLE t1;
822 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
823 SHOW TABLES;
824 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
825 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
826 CREATE TABLE t1(c1 BIGINT NOT NULL);
827 SHOW TABLES;
828 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
829 SHOW CREATE TABLE t1;
830 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
831 SHOW TABLES;
832 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
833 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
834 CREATE TABLE t1(c1 REAL NOT NULL);
835 SHOW TABLES;
836 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
837 SHOW CREATE TABLE t1;
838 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
839 SHOW TABLES;
840 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
841 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
842 CREATE TABLE t1(c1 DOUBLE NOT NULL);
843 SHOW TABLES;
844 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
845 SHOW CREATE TABLE t1;
846 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
847 SHOW TABLES;
848 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
849 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
850 CREATE TABLE t1(c1 FLOAT NOT NULL);
851 SHOW TABLES;
852 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
853 SHOW CREATE TABLE t1;
854 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
855 SHOW TABLES;
856 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
857 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
858 CREATE TABLE t1(c1 DECIMAL NOT NULL);
859 SHOW TABLES;
860 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
861 SHOW CREATE TABLE t1;
862 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
863 SHOW TABLES;
864 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
865 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
866 CREATE TABLE t1(c1 NUMERIC NOT NULL);
867 SHOW TABLES;
868 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
869 SHOW CREATE TABLE t1;
870 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
871 SHOW TABLES;
872 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
873 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
874 CREATE TABLE t1(c1 DATE NOT NULL);
875 SHOW TABLES;
876 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
877 SHOW CREATE TABLE t1;
878 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
879 SHOW TABLES;
880 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
881 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
882 CREATE TABLE t1(c1 TIME NOT NULL);
883 SHOW TABLES;
884 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
885 SHOW CREATE TABLE t1;
886 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
887 SHOW TABLES;
888 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
889 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
890 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
891 SHOW TABLES;
892 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
893 SHOW CREATE TABLE t1;
894 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
895 SHOW TABLES;
896 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
897 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
898 CREATE TABLE t1(c1 YEAR NOT NULL);
899 SHOW TABLES;
900 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
901 SHOW CREATE TABLE t1;
902 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
903 SHOW TABLES;
904 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
905 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
906 CREATE TABLE t1(c1 BIT NOT NULL);
907 SHOW TABLES;
908 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
909 SHOW CREATE TABLE t1;
910 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
911 SHOW TABLES;
912 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
913 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
914 CREATE TABLE t1(c1 TINYINT NOT NULL);
915 SHOW TABLES;
916 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
917 SHOW CREATE TABLE t1;
918 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
919 SHOW TABLES;
920 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
921 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
922 CREATE TABLE t1(c1 SMALLINT NOT NULL);
923 SHOW TABLES;
924 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
925 SHOW CREATE TABLE t1;
926 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
927 SHOW TABLES;
928 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
929 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
930 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
931 SHOW TABLES;
932 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
933 SHOW CREATE TABLE t1;
934 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
935 SHOW TABLES;
936 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
937 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
938 CREATE TABLE t1(c1 INT NOT NULL);
939 SHOW TABLES;
940 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
941 SHOW CREATE TABLE t1;
942 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
943 SHOW TABLES;
944 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
945 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
946 CREATE TABLE t1(c1 INTEGER NOT NULL);
947 SHOW TABLES;
948 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
949 SHOW CREATE TABLE t1;
950 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
951 SHOW TABLES;
952 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
953 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
954 CREATE TABLE t1(c1 BIGINT NOT NULL);
955 SHOW TABLES;
956 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
957 SHOW CREATE TABLE t1;
958 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
959 SHOW TABLES;
960 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
961 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
962 CREATE TABLE t1(c1 REAL NOT NULL);
963 SHOW TABLES;
964 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
965 SHOW CREATE TABLE t1;
966 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
967 SHOW TABLES;
968 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
969 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
970 CREATE TABLE t1(c1 DOUBLE NOT NULL);
971 SHOW TABLES;
972 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
973 SHOW CREATE TABLE t1;
974 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
975 SHOW TABLES;
976 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
977 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
978 CREATE TABLE t1(c1 FLOAT NOT NULL);
979 SHOW TABLES;
980 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
981 SHOW CREATE TABLE t1;
982 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
983 SHOW TABLES;
984 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
985 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
986 CREATE TABLE t1(c1 DECIMAL NOT NULL);
987 SHOW TABLES;
988 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
989 SHOW CREATE TABLE t1;
990 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
991 SHOW TABLES;
992 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
993 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
994 CREATE TABLE t1(c1 NUMERIC NOT NULL);
995 SHOW TABLES;
996 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
997 SHOW CREATE TABLE t1;
998 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
999 SHOW TABLES;
1000 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1001 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1002 CREATE TABLE t1(c1 DATE NOT NULL);
1003 SHOW TABLES;
1004 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1005 SHOW CREATE TABLE t1;
1006 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
1007 SHOW TABLES;
1008 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1009 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1010 CREATE TABLE t1(c1 TIME NOT NULL);
1011 SHOW TABLES;
1012 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1013 SHOW CREATE TABLE t1;
1014 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
1015 SHOW TABLES;
1016 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1017 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1018 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1019 SHOW TABLES;
1020 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1021 SHOW CREATE TABLE t1;
1022 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
1023 SHOW TABLES;
1024 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1025 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1026 CREATE TABLE t1(c1 YEAR NOT NULL);
1027 SHOW TABLES;
1028 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1029 SHOW CREATE TABLE t1;
1030 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
1031 SHOW TABLES;
1032 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1033 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1034 CREATE TABLE t1(c1 BIT NOT NULL);
1035 SHOW TABLES;
1036 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1037 SHOW CREATE TABLE t1;
1038 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1039 SHOW TABLES;
1040 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1041 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1042 CREATE TABLE t1(c1 TINYINT NOT NULL);
1043 SHOW TABLES;
1044 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1045 SHOW CREATE TABLE t1;
1046 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1047 SHOW TABLES;
1048 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1049 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1050 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1051 SHOW TABLES;
1052 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1053 SHOW CREATE TABLE t1;
1054 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1055 SHOW TABLES;
1056 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1057 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1058 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1059 SHOW TABLES;
1060 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1061 SHOW CREATE TABLE t1;
1062 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1063 SHOW TABLES;
1064 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1065 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1066 CREATE TABLE t1(c1 INT NOT NULL);
1067 SHOW TABLES;
1068 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1069 SHOW CREATE TABLE t1;
1070 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1071 SHOW TABLES;
1072 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1073 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1074 CREATE TABLE t1(c1 INTEGER NOT NULL);
1075 SHOW TABLES;
1076 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1077 SHOW CREATE TABLE t1;
1078 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1079 SHOW TABLES;
1080 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1081 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1082 CREATE TABLE t1(c1 BIGINT NOT NULL);
1083 SHOW TABLES;
1084 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1085 SHOW CREATE TABLE t1;
1086 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1087 SHOW TABLES;
1088 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1089 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1090 CREATE TABLE t1(c1 REAL NOT NULL);
1091 SHOW TABLES;
1092 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1093 SHOW CREATE TABLE t1;
1094 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1095 SHOW TABLES;
1096 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1097 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1098 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1099 SHOW TABLES;
1100 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1101 SHOW CREATE TABLE t1;
1102 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1103 SHOW TABLES;
1104 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1105 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1106 CREATE TABLE t1(c1 FLOAT NOT NULL);
1107 SHOW TABLES;
1108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1109 SHOW CREATE TABLE t1;
1110 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1111 SHOW TABLES;
1112 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1113 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1114 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1115 SHOW TABLES;
1116 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1117 SHOW CREATE TABLE t1;
1118 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1119 SHOW TABLES;
1120 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1121 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1122 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1123 SHOW TABLES;
1124 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1125 SHOW CREATE TABLE t1;
1126 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1127 SHOW TABLES;
1128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1129 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1130 CREATE TABLE t1(c1 DATE NOT NULL);
1131 SHOW TABLES;
1132 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1133 SHOW CREATE TABLE t1;
1134 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1135 SHOW TABLES;
1136 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1137 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1138 CREATE TABLE t1(c1 TIME NOT NULL);
1139 SHOW TABLES;
1140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1141 SHOW CREATE TABLE t1;
1142 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1143 SHOW TABLES;
1144 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1145 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1146 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1147 SHOW TABLES;
1148 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1149 SHOW CREATE TABLE t1;
1150 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1151 SHOW TABLES;
1152 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1153 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1154 CREATE TABLE t1(c1 YEAR NOT NULL);
1155 SHOW TABLES;
1156 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1157 SHOW CREATE TABLE t1;
1158 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
1159 SHOW TABLES;
1160 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1161 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1162 CREATE TABLE t1(c1 BIT NOT NULL);
1163 SHOW TABLES;
1164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1165 SHOW CREATE TABLE t1;
1166 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1167 SHOW TABLES;
1168 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1169 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1170 CREATE TABLE t1(c1 TINYINT NOT NULL);
1171 SHOW TABLES;
1172 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1173 SHOW CREATE TABLE t1;
1174 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1175 SHOW TABLES;
1176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1177 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1178 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1179 SHOW TABLES;
1180 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1181 SHOW CREATE TABLE t1;
1182 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1183 SHOW TABLES;
1184 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1185 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1186 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1187 SHOW TABLES;
1188 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1189 SHOW CREATE TABLE t1;
1190 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1191 SHOW TABLES;
1192 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1193 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1194 CREATE TABLE t1(c1 INT NOT NULL);
1195 SHOW TABLES;
1196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1197 SHOW CREATE TABLE t1;
1198 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1199 SHOW TABLES;
1200 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1201 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1202 CREATE TABLE t1(c1 INTEGER NOT NULL);
1203 SHOW TABLES;
1204 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1205 SHOW CREATE TABLE t1;
1206 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1207 SHOW TABLES;
1208 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1209 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1210 CREATE TABLE t1(c1 BIGINT NOT NULL);
1211 SHOW TABLES;
1212 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1213 SHOW CREATE TABLE t1;
1214 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1215 SHOW TABLES;
1216 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1217 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1218 CREATE TABLE t1(c1 REAL NOT NULL);
1219 SHOW TABLES;
1220 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1221 SHOW CREATE TABLE t1;
1222 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1223 SHOW TABLES;
1224 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1225 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1226 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1227 SHOW TABLES;
1228 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1229 SHOW CREATE TABLE t1;
1230 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1231 SHOW TABLES;
1232 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1234 CREATE TABLE t1(c1 FLOAT NOT NULL);
1235 SHOW TABLES;
1236 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1237 SHOW CREATE TABLE t1;
1238 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1239 SHOW TABLES;
1240 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1241 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1242 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1243 SHOW TABLES;
1244 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1245 SHOW CREATE TABLE t1;
1246 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1247 SHOW TABLES;
1248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1249 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1250 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1251 SHOW TABLES;
1252 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1253 SHOW CREATE TABLE t1;
1254 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1255 SHOW TABLES;
1256 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1257 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1258 CREATE TABLE t1(c1 DATE NOT NULL);
1259 SHOW TABLES;
1260 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1261 SHOW CREATE TABLE t1;
1262 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1263 SHOW TABLES;
1264 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1265 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1266 CREATE TABLE t1(c1 TIME NOT NULL);
1267 SHOW TABLES;
1268 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1269 SHOW CREATE TABLE t1;
1270 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1271 SHOW TABLES;
1272 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1273 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1274 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1275 SHOW TABLES;
1276 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1277 SHOW CREATE TABLE t1;
1278 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1279 SHOW TABLES;
1280 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1281 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1282 CREATE TABLE t1(c1 YEAR NOT NULL);
1283 SHOW TABLES;
1284 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1285 SHOW CREATE TABLE t1;
1286 ALTER TABLE t1 ADD UNIQUE i1 (c1);
1287 SHOW TABLES;
1288 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1289 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1290 CREATE TABLE t1(c1 BIT NOT NULL);
1291 SHOW TABLES;
1292 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1293 SHOW CREATE TABLE t1;
1294 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1295 SHOW TABLES;
1296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1297 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1298 CREATE TABLE t1(c1 TINYINT NOT NULL);
1299 SHOW TABLES;
1300 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1301 SHOW CREATE TABLE t1;
1302 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1303 SHOW TABLES;
1304 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1305 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1306 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1307 SHOW TABLES;
1308 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1309 SHOW CREATE TABLE t1;
1310 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1311 SHOW TABLES;
1312 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1313 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1314 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1315 SHOW TABLES;
1316 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1317 SHOW CREATE TABLE t1;
1318 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1319 SHOW TABLES;
1320 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1321 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1322 CREATE TABLE t1(c1 INT NOT NULL);
1323 SHOW TABLES;
1324 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1325 SHOW CREATE TABLE t1;
1326 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1327 SHOW TABLES;
1328 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1329 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1330 CREATE TABLE t1(c1 INTEGER NOT NULL);
1331 SHOW TABLES;
1332 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1333 SHOW CREATE TABLE t1;
1334 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1335 SHOW TABLES;
1336 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1337 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1338 CREATE TABLE t1(c1 BIGINT NOT NULL);
1339 SHOW TABLES;
1340 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1341 SHOW CREATE TABLE t1;
1342 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1343 SHOW TABLES;
1344 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1345 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1346 CREATE TABLE t1(c1 REAL NOT NULL);
1347 SHOW TABLES;
1348 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1349 SHOW CREATE TABLE t1;
1350 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1351 SHOW TABLES;
1352 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1353 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1354 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1355 SHOW TABLES;
1356 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1357 SHOW CREATE TABLE t1;
1358 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1359 SHOW TABLES;
1360 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1361 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1362 CREATE TABLE t1(c1 FLOAT NOT NULL);
1363 SHOW TABLES;
1364 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1365 SHOW CREATE TABLE t1;
1366 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1367 SHOW TABLES;
1368 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1369 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1370 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1371 SHOW TABLES;
1372 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1373 SHOW CREATE TABLE t1;
1374 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1375 SHOW TABLES;
1376 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1377 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1378 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1379 SHOW TABLES;
1380 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1381 SHOW CREATE TABLE t1;
1382 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1383 SHOW TABLES;
1384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1385 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1386 CREATE TABLE t1(c1 DATE NOT NULL);
1387 SHOW TABLES;
1388 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1389 SHOW CREATE TABLE t1;
1390 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1391 SHOW TABLES;
1392 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1393 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1394 CREATE TABLE t1(c1 TIME NOT NULL);
1395 SHOW TABLES;
1396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1397 SHOW CREATE TABLE t1;
1398 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1399 SHOW TABLES;
1400 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1401 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1402 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1403 SHOW TABLES;
1404 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1405 SHOW CREATE TABLE t1;
1406 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1407 SHOW TABLES;
1408 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1409 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1410 CREATE TABLE t1(c1 YEAR NOT NULL);
1411 SHOW TABLES;
1412 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1413 SHOW CREATE TABLE t1;
1414 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
1415 SHOW TABLES;
1416 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1417 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1418 CREATE TABLE t1(c1 BIT NOT NULL);
1419 SHOW TABLES;
1420 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1421 SHOW CREATE TABLE t1;
1422 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1423 SHOW TABLES;
1424 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1425 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1426 CREATE TABLE t1(c1 TINYINT NOT NULL);
1427 SHOW TABLES;
1428 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1429 SHOW CREATE TABLE t1;
1430 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1431 SHOW TABLES;
1432 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1433 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1434 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1435 SHOW TABLES;
1436 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1437 SHOW CREATE TABLE t1;
1438 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1439 SHOW TABLES;
1440 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1441 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1442 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1443 SHOW TABLES;
1444 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1445 SHOW CREATE TABLE t1;
1446 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1447 SHOW TABLES;
1448 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1449 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1450 CREATE TABLE t1(c1 INT NOT NULL);
1451 SHOW TABLES;
1452 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1453 SHOW CREATE TABLE t1;
1454 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1455 SHOW TABLES;
1456 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1457 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1458 CREATE TABLE t1(c1 INTEGER NOT NULL);
1459 SHOW TABLES;
1460 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1461 SHOW CREATE TABLE t1;
1462 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1463 SHOW TABLES;
1464 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1465 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1466 CREATE TABLE t1(c1 BIGINT NOT NULL);
1467 SHOW TABLES;
1468 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1469 SHOW CREATE TABLE t1;
1470 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1471 SHOW TABLES;
1472 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1473 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1474 CREATE TABLE t1(c1 REAL NOT NULL);
1475 SHOW TABLES;
1476 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1477 SHOW CREATE TABLE t1;
1478 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1479 SHOW TABLES;
1480 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1481 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1482 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1483 SHOW TABLES;
1484 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1485 SHOW CREATE TABLE t1;
1486 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1487 SHOW TABLES;
1488 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1489 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1490 CREATE TABLE t1(c1 FLOAT NOT NULL);
1491 SHOW TABLES;
1492 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1493 SHOW CREATE TABLE t1;
1494 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1495 SHOW TABLES;
1496 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1497 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1498 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1499 SHOW TABLES;
1500 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1501 SHOW CREATE TABLE t1;
1502 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1503 SHOW TABLES;
1504 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1505 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1506 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1507 SHOW TABLES;
1508 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1509 SHOW CREATE TABLE t1;
1510 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1511 SHOW TABLES;
1512 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1513 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1514 CREATE TABLE t1(c1 DATE NOT NULL);
1515 SHOW TABLES;
1516 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1517 SHOW CREATE TABLE t1;
1518 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1519 SHOW TABLES;
1520 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1521 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1522 CREATE TABLE t1(c1 TIME NOT NULL);
1523 SHOW TABLES;
1524 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1525 SHOW CREATE TABLE t1;
1526 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1527 SHOW TABLES;
1528 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1529 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1530 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1531 SHOW TABLES;
1532 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1533 SHOW CREATE TABLE t1;
1534 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1535 SHOW TABLES;
1536 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1537 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1538 CREATE TABLE t1(c1 YEAR NOT NULL);
1539 SHOW TABLES;
1540 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1541 SHOW CREATE TABLE t1;
1542 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1543 SHOW TABLES;
1544 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1545 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1546 CREATE TABLE t1(c1 BIT NOT NULL);
1547 SHOW TABLES;
1548 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1549 SHOW CREATE TABLE t1;
1550 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1551 SHOW TABLES;
1552 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1553 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1554 CREATE TABLE t1(c1 TINYINT NOT NULL);
1555 SHOW TABLES;
1556 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1557 SHOW CREATE TABLE t1;
1558 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1559 SHOW TABLES;
1560 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1561 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1562 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1563 SHOW TABLES;
1564 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1565 SHOW CREATE TABLE t1;
1566 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1567 SHOW TABLES;
1568 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1569 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1570 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1571 SHOW TABLES;
1572 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1573 SHOW CREATE TABLE t1;
1574 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1575 SHOW TABLES;
1576 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1577 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1578 CREATE TABLE t1(c1 INT NOT NULL);
1579 SHOW TABLES;
1580 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1581 SHOW CREATE TABLE t1;
1582 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1583 SHOW TABLES;
1584 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1585 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1586 CREATE TABLE t1(c1 INTEGER NOT NULL);
1587 SHOW TABLES;
1588 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1589 SHOW CREATE TABLE t1;
1590 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1591 SHOW TABLES;
1592 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1593 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1594 CREATE TABLE t1(c1 BIGINT NOT NULL);
1595 SHOW TABLES;
1596 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1597 SHOW CREATE TABLE t1;
1598 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1599 SHOW TABLES;
1600 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1601 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1602 CREATE TABLE t1(c1 REAL NOT NULL);
1603 SHOW TABLES;
1604 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1605 SHOW CREATE TABLE t1;
1606 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1607 SHOW TABLES;
1608 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1609 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1610 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1611 SHOW TABLES;
1612 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1613 SHOW CREATE TABLE t1;
1614 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1615 SHOW TABLES;
1616 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1617 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1618 CREATE TABLE t1(c1 FLOAT NOT NULL);
1619 SHOW TABLES;
1620 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1621 SHOW CREATE TABLE t1;
1622 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1623 SHOW TABLES;
1624 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1625 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1626 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1627 SHOW TABLES;
1628 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1629 SHOW CREATE TABLE t1;
1630 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1631 SHOW TABLES;
1632 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1633 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1634 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1635 SHOW TABLES;
1636 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1637 SHOW CREATE TABLE t1;
1638 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1639 SHOW TABLES;
1640 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1641 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1642 CREATE TABLE t1(c1 DATE NOT NULL);
1643 SHOW TABLES;
1644 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1645 SHOW CREATE TABLE t1;
1646 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1647 SHOW TABLES;
1648 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1649 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1650 CREATE TABLE t1(c1 TIME NOT NULL);
1651 SHOW TABLES;
1652 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1653 SHOW CREATE TABLE t1;
1654 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1655 SHOW TABLES;
1656 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1657 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1658 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1659 SHOW TABLES;
1660 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1661 SHOW CREATE TABLE t1;
1662 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1663 SHOW TABLES;
1664 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1665 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1666 CREATE TABLE t1(c1 YEAR NOT NULL);
1667 SHOW TABLES;
1668 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1669 SHOW CREATE TABLE t1;
1670 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1671 SHOW TABLES;
1672 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1673 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1674 CREATE TABLE t1(c1 BIT NOT NULL);
1675 SHOW TABLES;
1676 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1677 SHOW CREATE TABLE t1;
1678 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1679 SHOW TABLES;
1680 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1681 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1682 CREATE TABLE t1(c1 TINYINT NOT NULL);
1683 SHOW TABLES;
1684 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1685 SHOW CREATE TABLE t1;
1686 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1687 SHOW TABLES;
1688 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1689 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1690 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1691 SHOW TABLES;
1692 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1693 SHOW CREATE TABLE t1;
1694 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1695 SHOW TABLES;
1696 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1697 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1698 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1699 SHOW TABLES;
1700 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1701 SHOW CREATE TABLE t1;
1702 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1703 SHOW TABLES;
1704 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1705 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1706 CREATE TABLE t1(c1 INT NOT NULL);
1707 SHOW TABLES;
1708 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1709 SHOW CREATE TABLE t1;
1710 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1711 SHOW TABLES;
1712 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1713 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1714 CREATE TABLE t1(c1 INTEGER NOT NULL);
1715 SHOW TABLES;
1716 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1717 SHOW CREATE TABLE t1;
1718 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1719 SHOW TABLES;
1720 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1721 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1722 CREATE TABLE t1(c1 BIGINT NOT NULL);
1723 SHOW TABLES;
1724 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1725 SHOW CREATE TABLE t1;
1726 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1727 SHOW TABLES;
1728 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1729 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1730 CREATE TABLE t1(c1 REAL NOT NULL);
1731 SHOW TABLES;
1732 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1733 SHOW CREATE TABLE t1;
1734 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1735 SHOW TABLES;
1736 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1737 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1738 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1739 SHOW TABLES;
1740 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1741 SHOW CREATE TABLE t1;
1742 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1743 SHOW TABLES;
1744 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1745 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1746 CREATE TABLE t1(c1 FLOAT NOT NULL);
1747 SHOW TABLES;
1748 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1749 SHOW CREATE TABLE t1;
1750 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1751 SHOW TABLES;
1752 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1753 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1754 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1755 SHOW TABLES;
1756 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1757 SHOW CREATE TABLE t1;
1758 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1759 SHOW TABLES;
1760 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1761 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1762 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1763 SHOW TABLES;
1764 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1765 SHOW CREATE TABLE t1;
1766 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1767 SHOW TABLES;
1768 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1769 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1770 CREATE TABLE t1(c1 DATE NOT NULL);
1771 SHOW TABLES;
1772 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1773 SHOW CREATE TABLE t1;
1774 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1775 SHOW TABLES;
1776 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1777 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1778 CREATE TABLE t1(c1 TIME NOT NULL);
1779 SHOW TABLES;
1780 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1781 SHOW CREATE TABLE t1;
1782 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1783 SHOW TABLES;
1784 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1785 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1786 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1787 SHOW TABLES;
1788 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1789 SHOW CREATE TABLE t1;
1790 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1791 SHOW TABLES;
1792 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1793 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1794 CREATE TABLE t1(c1 YEAR NOT NULL);
1795 SHOW TABLES;
1796 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1797 SHOW CREATE TABLE t1;
1798 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1799 SHOW TABLES;
1800 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1801 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1802 CREATE TABLE t1(c1 BIT NOT NULL);
1803 SHOW TABLES;
1804 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1805 SHOW CREATE TABLE t1;
1806 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1807 SHOW TABLES;
1808 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1809 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1810 CREATE TABLE t1(c1 TINYINT NOT NULL);
1811 SHOW TABLES;
1812 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1813 SHOW CREATE TABLE t1;
1814 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1815 SHOW TABLES;
1816 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1817 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1818 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1819 SHOW TABLES;
1820 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1821 SHOW CREATE TABLE t1;
1822 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1823 SHOW TABLES;
1824 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1825 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1826 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1827 SHOW TABLES;
1828 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1829 SHOW CREATE TABLE t1;
1830 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1831 SHOW TABLES;
1832 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1833 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1834 CREATE TABLE t1(c1 INT NOT NULL);
1835 SHOW TABLES;
1836 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1837 SHOW CREATE TABLE t1;
1838 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1839 SHOW TABLES;
1840 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1841 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1842 CREATE TABLE t1(c1 INTEGER NOT NULL);
1843 SHOW TABLES;
1844 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1845 SHOW CREATE TABLE t1;
1846 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1847 SHOW TABLES;
1848 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1849 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1850 CREATE TABLE t1(c1 BIGINT NOT NULL);
1851 SHOW TABLES;
1852 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1853 SHOW CREATE TABLE t1;
1854 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1855 SHOW TABLES;
1856 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1857 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1858 CREATE TABLE t1(c1 REAL NOT NULL);
1859 SHOW TABLES;
1860 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1861 SHOW CREATE TABLE t1;
1862 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1863 SHOW TABLES;
1864 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1865 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1866 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1867 SHOW TABLES;
1868 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1869 SHOW CREATE TABLE t1;
1870 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1871 SHOW TABLES;
1872 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1873 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1874 CREATE TABLE t1(c1 FLOAT NOT NULL);
1875 SHOW TABLES;
1876 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1877 SHOW CREATE TABLE t1;
1878 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1879 SHOW TABLES;
1880 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1881 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1882 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1883 SHOW TABLES;
1884 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1885 SHOW CREATE TABLE t1;
1886 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1887 SHOW TABLES;
1888 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1889 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1890 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1891 SHOW TABLES;
1892 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1893 SHOW CREATE TABLE t1;
1894 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1895 SHOW TABLES;
1896 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1897 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1898 CREATE TABLE t1(c1 DATE NOT NULL);
1899 SHOW TABLES;
1900 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1901 SHOW CREATE TABLE t1;
1902 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1903 SHOW TABLES;
1904 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1905 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1906 CREATE TABLE t1(c1 TIME NOT NULL);
1907 SHOW TABLES;
1908 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1909 SHOW CREATE TABLE t1;
1910 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1911 SHOW TABLES;
1912 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1913 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1914 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1915 SHOW TABLES;
1916 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1917 SHOW CREATE TABLE t1;
1918 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1919 SHOW TABLES;
1920 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1921 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1922 CREATE TABLE t1(c1 YEAR NOT NULL);
1923 SHOW TABLES;
1924 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1925 SHOW CREATE TABLE t1;
1926 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1927 SHOW TABLES;
1928 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1929 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1930 CREATE TABLE t1(c1 BIT NOT NULL);
1931 SHOW TABLES;
1932 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1933 SHOW CREATE TABLE t1;
1934 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1935 SHOW TABLES;
1936 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1937 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1938 CREATE TABLE t1(c1 TINYINT NOT NULL);
1939 SHOW TABLES;
1940 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1941 SHOW CREATE TABLE t1;
1942 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1943 SHOW TABLES;
1944 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1945 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1946 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1947 SHOW TABLES;
1948 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1949 SHOW CREATE TABLE t1;
1950 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1951 SHOW TABLES;
1952 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1953 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1954 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1955 SHOW TABLES;
1956 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1957 SHOW CREATE TABLE t1;
1958 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1959 SHOW TABLES;
1960 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1961 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1962 CREATE TABLE t1(c1 INT NOT NULL);
1963 SHOW TABLES;
1964 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1965 SHOW CREATE TABLE t1;
1966 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1967 SHOW TABLES;
1968 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1969 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1970 CREATE TABLE t1(c1 INTEGER NOT NULL);
1971 SHOW TABLES;
1972 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1973 SHOW CREATE TABLE t1;
1974 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1975 SHOW TABLES;
1976 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1977 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1978 CREATE TABLE t1(c1 BIGINT NOT NULL);
1979 SHOW TABLES;
1980 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1981 SHOW CREATE TABLE t1;
1982 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1983 SHOW TABLES;
1984 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1985 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1986 CREATE TABLE t1(c1 REAL NOT NULL);
1987 SHOW TABLES;
1988 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1989 SHOW CREATE TABLE t1;
1990 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1991 SHOW TABLES;
1992 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1993 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1994 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1995 SHOW TABLES;
1996 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1997 SHOW CREATE TABLE t1;
1998 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1999 SHOW TABLES;
2000 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2001 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2002 CREATE TABLE t1(c1 FLOAT NOT NULL);
2003 SHOW TABLES;
2004 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2005 SHOW CREATE TABLE t1;
2006 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
2007 SHOW TABLES;
2008 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2009 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2010 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2011 SHOW TABLES;
2012 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2013 SHOW CREATE TABLE t1;
2014 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
2015 SHOW TABLES;
2016 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2017 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2018 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2019 SHOW TABLES;
2020 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2021 SHOW CREATE TABLE t1;
2022 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
2023 SHOW TABLES;
2024 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2025 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2026 CREATE TABLE t1(c1 DATE NOT NULL);
2027 SHOW TABLES;
2028 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2029 SHOW CREATE TABLE t1;
2030 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
2031 SHOW TABLES;
2032 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2033 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2034 CREATE TABLE t1(c1 TIME NOT NULL);
2035 SHOW TABLES;
2036 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2037 SHOW CREATE TABLE t1;
2038 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
2039 SHOW TABLES;
2040 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2041 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2042 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2043 SHOW TABLES;
2044 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2045 SHOW CREATE TABLE t1;
2046 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
2047 SHOW TABLES;
2048 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2049 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2050 CREATE TABLE t1(c1 YEAR NOT NULL);
2051 SHOW TABLES;
2052 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2053 SHOW CREATE TABLE t1;
2054 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
2055 SHOW TABLES;
2056 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2057 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2058 CREATE TABLE t1(c1 BIT NOT NULL);
2059 SHOW TABLES;
2060 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2061 SHOW CREATE TABLE t1;
2062 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2063 SHOW TABLES;
2064 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2065 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2066 CREATE TABLE t1(c1 TINYINT NOT NULL);
2067 SHOW TABLES;
2068 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2069 SHOW CREATE TABLE t1;
2070 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2071 SHOW TABLES;
2072 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2073 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2074 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2075 SHOW TABLES;
2076 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2077 SHOW CREATE TABLE t1;
2078 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2079 SHOW TABLES;
2080 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2081 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2082 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2083 SHOW TABLES;
2084 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2085 SHOW CREATE TABLE t1;
2086 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2087 SHOW TABLES;
2088 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2089 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2090 CREATE TABLE t1(c1 INT NOT NULL);
2091 SHOW TABLES;
2092 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2093 SHOW CREATE TABLE t1;
2094 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2095 SHOW TABLES;
2096 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2097 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2098 CREATE TABLE t1(c1 INTEGER NOT NULL);
2099 SHOW TABLES;
2100 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2101 SHOW CREATE TABLE t1;
2102 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2103 SHOW TABLES;
2104 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2105 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2106 CREATE TABLE t1(c1 BIGINT NOT NULL);
2107 SHOW TABLES;
2108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2109 SHOW CREATE TABLE t1;
2110 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2111 SHOW TABLES;
2112 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2113 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2114 CREATE TABLE t1(c1 REAL NOT NULL);
2115 SHOW TABLES;
2116 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2117 SHOW CREATE TABLE t1;
2118 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2119 SHOW TABLES;
2120 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2121 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2122 CREATE TABLE t1(c1 DOUBLE NOT NULL);
2123 SHOW TABLES;
2124 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2125 SHOW CREATE TABLE t1;
2126 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2127 SHOW TABLES;
2128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2129 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2130 CREATE TABLE t1(c1 FLOAT NOT NULL);
2131 SHOW TABLES;
2132 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2133 SHOW CREATE TABLE t1;
2134 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2135 SHOW TABLES;
2136 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2137 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2138 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2139 SHOW TABLES;
2140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2141 SHOW CREATE TABLE t1;
2142 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2143 SHOW TABLES;
2144 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2145 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2146 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2147 SHOW TABLES;
2148 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2149 SHOW CREATE TABLE t1;
2150 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2151 SHOW TABLES;
2152 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2153 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2154 CREATE TABLE t1(c1 DATE NOT NULL);
2155 SHOW TABLES;
2156 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2157 SHOW CREATE TABLE t1;
2158 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2159 SHOW TABLES;
2160 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2161 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2162 CREATE TABLE t1(c1 TIME NOT NULL);
2163 SHOW TABLES;
2164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2165 SHOW CREATE TABLE t1;
2166 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2167 SHOW TABLES;
2168 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2169 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2170 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2171 SHOW TABLES;
2172 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2173 SHOW CREATE TABLE t1;
2174 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2175 SHOW TABLES;
2176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2177 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2178 CREATE TABLE t1(c1 YEAR NOT NULL);
2179 SHOW TABLES;
2180 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2181 SHOW CREATE TABLE t1;
2182 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
2183 SHOW TABLES;
2184 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2185 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2186 CREATE TABLE t1(c1 BIT NOT NULL);
2187 SHOW TABLES;
2188 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2189 SHOW CREATE TABLE t1;
2190 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2191 SHOW TABLES;
2192 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2193 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2194 CREATE TABLE t1(c1 TINYINT NOT NULL);
2195 SHOW TABLES;
2196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2197 SHOW CREATE TABLE t1;
2198 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2199 SHOW TABLES;
2200 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2201 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2202 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2203 SHOW TABLES;
2204 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2205 SHOW CREATE TABLE t1;
2206 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2207 SHOW TABLES;
2208 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2209 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2210 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2211 SHOW TABLES;
2212 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2213 SHOW CREATE TABLE t1;
2214 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2215 SHOW TABLES;
2216 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2217 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2218 CREATE TABLE t1(c1 INT NOT NULL);
2219 SHOW TABLES;
2220 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2221 SHOW CREATE TABLE t1;
2222 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2223 SHOW TABLES;
2224 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2225 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2226 CREATE TABLE t1(c1 INTEGER NOT NULL);
2227 SHOW TABLES;
2228 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2229 SHOW CREATE TABLE t1;
2230 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2231 SHOW TABLES;
2232 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2234 CREATE TABLE t1(c1 BIGINT NOT NULL);
2235 SHOW TABLES;
2236 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2237 SHOW CREATE TABLE t1;
2238 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2239 SHOW TABLES;
2240 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2241 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2242 CREATE TABLE t1(c1 REAL NOT NULL);
2243 SHOW TABLES;
2244 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2245 SHOW CREATE TABLE t1;
2246 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2247 SHOW TABLES;
2248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2249 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2250 CREATE TABLE t1(c1 DOUBLE NOT NULL);
2251 SHOW TABLES;
2252 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2253 SHOW CREATE TABLE t1;
2254 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2255 SHOW TABLES;
2256 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2257 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2258 CREATE TABLE t1(c1 FLOAT NOT NULL);
2259 SHOW TABLES;
2260 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2261 SHOW CREATE TABLE t1;
2262 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2263 SHOW TABLES;
2264 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2265 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2266 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2267 SHOW TABLES;
2268 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2269 SHOW CREATE TABLE t1;
2270 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2271 SHOW TABLES;
2272 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2273 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2274 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2275 SHOW TABLES;
2276 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2277 SHOW CREATE TABLE t1;
2278 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2279 SHOW TABLES;
2280 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2281 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2282 CREATE TABLE t1(c1 DATE NOT NULL);
2283 SHOW TABLES;
2284 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2285 SHOW CREATE TABLE t1;
2286 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2287 SHOW TABLES;
2288 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2289 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2290 CREATE TABLE t1(c1 TIME NOT NULL);
2291 SHOW TABLES;
2292 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2293 SHOW CREATE TABLE t1;
2294 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2295 SHOW TABLES;
2296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2297 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2298 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2299 SHOW TABLES;
2300 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2301 SHOW CREATE TABLE t1;
2302 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2303 SHOW TABLES;
2304 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2305 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2306 CREATE TABLE t1(c1 YEAR NOT NULL);
2307 SHOW TABLES;
2308 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2309 SHOW CREATE TABLE t1;
2310 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
2311 SHOW TABLES;
2312 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2313 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;