Debian Codegraph @

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

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