2 DROP TABLE IF EXISTS t1;
4 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
5 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
6 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
8 INSERT INTO t1 VALUES(null);
9 INSERT INTO t1 VALUES(null);
10 INSERT INTO t1 VALUES(null);
14 INSERT INTO t1 VALUES(null);
17 ALTER TABLE t1 AUTO_INCREMENT=10;
18 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
21 INSERT INTO t1 VALUES(null);
22 INSERT INTO t1 VALUES(null);
23 INSERT INTO t1 VALUES(null);
27 INSERT INTO t1 VALUES(null);
31 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
32 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
33 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
35 INSERT INTO t1 VALUES(null);
36 INSERT INTO t1 VALUES(null);
37 INSERT INTO t1 VALUES(null);
41 INSERT INTO t1 VALUES(null);
44 ALTER TABLE t1 AUTO_INCREMENT=10;
45 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 INSERT INTO t1 VALUES(null);
49 INSERT INTO t1 VALUES(null);
50 INSERT INTO t1 VALUES(null);
54 INSERT INTO t1 VALUES(null);
58 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
59 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
60 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
62 INSERT INTO t1 VALUES(null);
63 INSERT INTO t1 VALUES(null);
64 INSERT INTO t1 VALUES(null);
68 INSERT INTO t1 VALUES(null);
71 ALTER TABLE t1 AUTO_INCREMENT=10;
72 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
73 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
75 INSERT INTO t1 VALUES(null);
76 INSERT INTO t1 VALUES(null);
77 INSERT INTO t1 VALUES(null);
81 INSERT INTO t1 VALUES(null);
85 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
86 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
87 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89 INSERT INTO t1 VALUES(null);
90 INSERT INTO t1 VALUES(null);
91 INSERT INTO t1 VALUES(null);
95 INSERT INTO t1 VALUES(null);
98 ALTER TABLE t1 AUTO_INCREMENT=10;
99 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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);
108 INSERT INTO t1 VALUES(null);
112 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
113 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
114 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
115 SHOW CREATE TABLE t1;
116 INSERT INTO t1 VALUES(null);
117 INSERT INTO t1 VALUES(null);
118 INSERT INTO t1 VALUES(null);
122 INSERT INTO t1 VALUES(null);
125 ALTER TABLE t1 AUTO_INCREMENT=10;
126 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
127 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
128 SHOW CREATE TABLE t1;
129 INSERT INTO t1 VALUES(null);
130 INSERT INTO t1 VALUES(null);
131 INSERT INTO t1 VALUES(null);
135 INSERT INTO t1 VALUES(null);
139 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
140 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
141 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
142 SHOW CREATE TABLE t1;
143 INSERT INTO t1 VALUES(null);
144 INSERT INTO t1 VALUES(null);
145 INSERT INTO t1 VALUES(null);
149 INSERT INTO t1 VALUES(null);
152 ALTER TABLE t1 AUTO_INCREMENT=10;
153 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
154 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
155 SHOW CREATE TABLE t1;
156 INSERT INTO t1 VALUES(null);
157 INSERT INTO t1 VALUES(null);
158 INSERT INTO t1 VALUES(null);
162 INSERT INTO t1 VALUES(null);
166 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
167 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
168 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
169 SHOW CREATE TABLE t1;
170 INSERT INTO t1 VALUES(null);
171 INSERT INTO t1 VALUES(null);
172 INSERT INTO t1 VALUES(null);
176 INSERT INTO t1 VALUES(null);
179 ALTER TABLE t1 AUTO_INCREMENT=10;
180 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
181 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
182 SHOW CREATE TABLE t1;
183 INSERT INTO t1 VALUES(null);
184 INSERT INTO t1 VALUES(null);
185 INSERT INTO t1 VALUES(null);
189 INSERT INTO t1 VALUES(null);
193 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
194 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
195 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
196 SHOW CREATE TABLE t1;
197 INSERT INTO t1 VALUES(null);
198 INSERT INTO t1 VALUES(null);
199 INSERT INTO t1 VALUES(null);
203 INSERT INTO t1 VALUES(null);
206 ALTER TABLE t1 AUTO_INCREMENT=10;
207 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
208 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
209 SHOW CREATE TABLE t1;
210 INSERT INTO t1 VALUES(null);
211 INSERT INTO t1 VALUES(null);
212 INSERT INTO t1 VALUES(null);
216 INSERT INTO t1 VALUES(null);
220 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
221 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
222 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
223 SHOW CREATE TABLE t1;
224 INSERT INTO t1 VALUES(null);
225 INSERT INTO t1 VALUES(null);
226 INSERT INTO t1 VALUES(null);
230 INSERT INTO t1 VALUES(null);
233 ALTER TABLE t1 AUTO_INCREMENT=10;
234 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
235 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
236 SHOW CREATE TABLE t1;
237 INSERT INTO t1 VALUES(null);
238 INSERT INTO t1 VALUES(null);
239 INSERT INTO t1 VALUES(null);
243 INSERT INTO t1 VALUES(null);
247 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
248 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
249 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
250 SHOW CREATE TABLE t1;
251 INSERT INTO t1 VALUES(null);
252 INSERT INTO t1 VALUES(null);
253 INSERT INTO t1 VALUES(null);
257 INSERT INTO t1 VALUES(null);
260 ALTER TABLE t1 AUTO_INCREMENT=10;
261 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
262 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
263 SHOW CREATE TABLE t1;
264 INSERT INTO t1 VALUES(null);
265 INSERT INTO t1 VALUES(null);
266 INSERT INTO t1 VALUES(null);
270 INSERT INTO t1 VALUES(null);
274 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
275 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
276 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
277 SHOW CREATE TABLE t1;
278 INSERT INTO t1 VALUES(null);
279 INSERT INTO t1 VALUES(null);
280 INSERT INTO t1 VALUES(null);
284 INSERT INTO t1 VALUES(null);
287 ALTER TABLE t1 AUTO_INCREMENT=10;
288 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
289 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
290 SHOW CREATE TABLE t1;
291 INSERT INTO t1 VALUES(null);
292 INSERT INTO t1 VALUES(null);
293 INSERT INTO t1 VALUES(null);
297 INSERT INTO t1 VALUES(null);
301 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
302 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
303 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
304 SHOW CREATE TABLE t1;
305 INSERT INTO t1 VALUES(null);
306 INSERT INTO t1 VALUES(null);
307 INSERT INTO t1 VALUES(null);
311 INSERT INTO t1 VALUES(null);
314 ALTER TABLE t1 AUTO_INCREMENT=10;
315 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
316 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
317 SHOW CREATE TABLE t1;
318 INSERT INTO t1 VALUES(null);
319 INSERT INTO t1 VALUES(null);
320 INSERT INTO t1 VALUES(null);
324 INSERT INTO t1 VALUES(null);
328 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
329 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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);
338 INSERT INTO t1 VALUES(null);
341 ALTER TABLE t1 AUTO_INCREMENT=10;
342 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
343 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
344 SHOW CREATE TABLE t1;
345 INSERT INTO t1 VALUES(null);
346 INSERT INTO t1 VALUES(null);
347 INSERT INTO t1 VALUES(null);
351 INSERT INTO t1 VALUES(null);
355 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
356 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
357 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
358 SHOW CREATE TABLE t1;
359 INSERT INTO t1 VALUES(null);
360 INSERT INTO t1 VALUES(null);
361 INSERT INTO t1 VALUES(null);
365 INSERT INTO t1 VALUES(null);
368 ALTER TABLE t1 AUTO_INCREMENT=10;
369 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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);
378 INSERT INTO t1 VALUES(null);
382 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
383 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
385 SHOW CREATE TABLE t1;
386 INSERT INTO t1 VALUES(null);
387 INSERT INTO t1 VALUES(null);
388 INSERT INTO t1 VALUES(null);
392 INSERT INTO t1 VALUES(null);
395 ALTER TABLE t1 AUTO_INCREMENT=10;
396 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
397 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
398 SHOW CREATE TABLE t1;
399 INSERT INTO t1 VALUES(null);
400 INSERT INTO t1 VALUES(null);
401 INSERT INTO t1 VALUES(null);
405 INSERT INTO t1 VALUES(null);
409 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
410 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
411 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
412 SHOW CREATE TABLE t1;
413 INSERT INTO t1 VALUES(null);
414 INSERT INTO t1 VALUES(null);
415 INSERT INTO t1 VALUES(null);
419 INSERT INTO t1 VALUES(null);
422 ALTER TABLE t1 AUTO_INCREMENT=10;
423 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
424 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
425 SHOW CREATE TABLE t1;
426 INSERT INTO t1 VALUES(null);
427 INSERT INTO t1 VALUES(null);
428 INSERT INTO t1 VALUES(null);
432 INSERT INTO t1 VALUES(null);
436 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
437 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
438 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
439 SHOW CREATE TABLE t1;
440 INSERT INTO t1 VALUES(null);
441 INSERT INTO t1 VALUES(null);
442 INSERT INTO t1 VALUES(null);
446 INSERT INTO t1 VALUES(null);
449 ALTER TABLE t1 AUTO_INCREMENT=10;
450 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
451 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
452 SHOW CREATE TABLE t1;
453 INSERT INTO t1 VALUES(null);
454 INSERT INTO t1 VALUES(null);
455 INSERT INTO t1 VALUES(null);
459 INSERT INTO t1 VALUES(null);
463 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
464 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
465 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
466 SHOW CREATE TABLE t1;
467 INSERT INTO t1 VALUES(null);
468 INSERT INTO t1 VALUES(null);
469 INSERT INTO t1 VALUES(null);
473 INSERT INTO t1 VALUES(null);
476 ALTER TABLE t1 AUTO_INCREMENT=10;
477 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
478 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
479 SHOW CREATE TABLE t1;
480 INSERT INTO t1 VALUES(null);
481 INSERT INTO t1 VALUES(null);
482 INSERT INTO t1 VALUES(null);
486 INSERT INTO t1 VALUES(null);
490 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
491 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
492 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
493 SHOW CREATE TABLE t1;
494 INSERT INTO t1 VALUES(null);
495 INSERT INTO t1 VALUES(null);
496 INSERT INTO t1 VALUES(null);
500 INSERT INTO t1 VALUES(null);
503 ALTER TABLE t1 AUTO_INCREMENT=10;
504 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
505 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
506 SHOW CREATE TABLE t1;
507 INSERT INTO t1 VALUES(null);
508 INSERT INTO t1 VALUES(null);
509 INSERT INTO t1 VALUES(null);
513 INSERT INTO t1 VALUES(null);
517 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
518 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
519 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
520 SHOW CREATE TABLE t1;
521 INSERT INTO t1 VALUES(null);
522 INSERT INTO t1 VALUES(null);
523 INSERT INTO t1 VALUES(null);
527 INSERT INTO t1 VALUES(null);
530 ALTER TABLE t1 AUTO_INCREMENT=10;
531 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
532 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
533 SHOW CREATE TABLE t1;
534 INSERT INTO t1 VALUES(null);
535 INSERT INTO t1 VALUES(null);
536 INSERT INTO t1 VALUES(null);
540 INSERT INTO t1 VALUES(null);
544 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
545 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
546 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
547 SHOW CREATE TABLE t1;
548 INSERT INTO t1 VALUES(null);
549 INSERT INTO t1 VALUES(null);
550 INSERT INTO t1 VALUES(null);
554 INSERT INTO t1 VALUES(null);
557 ALTER TABLE t1 AUTO_INCREMENT=10;
558 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
559 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
560 SHOW CREATE TABLE t1;
561 INSERT INTO t1 VALUES(null);
562 INSERT INTO t1 VALUES(null);
563 INSERT INTO t1 VALUES(null);
567 INSERT INTO t1 VALUES(null);
571 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
572 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
573 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
574 SHOW CREATE TABLE t1;
575 INSERT INTO t1 VALUES(null);
576 INSERT INTO t1 VALUES(null);
577 INSERT INTO t1 VALUES(null);
581 INSERT INTO t1 VALUES(null);
584 ALTER TABLE t1 AUTO_INCREMENT=10;
585 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
586 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
587 SHOW CREATE TABLE t1;
588 INSERT INTO t1 VALUES(null);
589 INSERT INTO t1 VALUES(null);
590 INSERT INTO t1 VALUES(null);
594 INSERT INTO t1 VALUES(null);
598 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
599 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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);
608 INSERT INTO t1 VALUES(null);
611 ALTER TABLE t1 AUTO_INCREMENT=10;
612 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
613 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
614 SHOW CREATE TABLE t1;
615 INSERT INTO t1 VALUES(null);
616 INSERT INTO t1 VALUES(null);
617 INSERT INTO t1 VALUES(null);
621 INSERT INTO t1 VALUES(null);
625 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
626 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
627 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
628 SHOW CREATE TABLE t1;
629 INSERT INTO t1 VALUES(null);
630 INSERT INTO t1 VALUES(null);
631 INSERT INTO t1 VALUES(null);
635 INSERT INTO t1 VALUES(null);
638 ALTER TABLE t1 AUTO_INCREMENT=10;
639 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
640 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
641 SHOW CREATE TABLE t1;
642 INSERT INTO t1 VALUES(null);
643 INSERT INTO t1 VALUES(null);
644 INSERT INTO t1 VALUES(null);
648 INSERT INTO t1 VALUES(null);
652 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
653 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
654 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
655 SHOW CREATE TABLE t1;
656 INSERT INTO t1 VALUES(null);
657 INSERT INTO t1 VALUES(null);
658 INSERT INTO t1 VALUES(null);
662 INSERT INTO t1 VALUES(null);
665 ALTER TABLE t1 AUTO_INCREMENT=10;
666 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
667 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
668 SHOW CREATE TABLE t1;
669 INSERT INTO t1 VALUES(null);
670 INSERT INTO t1 VALUES(null);
671 INSERT INTO t1 VALUES(null);
675 INSERT INTO t1 VALUES(null);
679 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
680 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
681 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
682 SHOW CREATE TABLE t1;
683 INSERT INTO t1 VALUES(null);
684 INSERT INTO t1 VALUES(null);
685 INSERT INTO t1 VALUES(null);
689 INSERT INTO t1 VALUES(null);
692 ALTER TABLE t1 AUTO_INCREMENT=10;
693 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
694 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
695 SHOW CREATE TABLE t1;
696 INSERT INTO t1 VALUES(null);
697 INSERT INTO t1 VALUES(null);
698 INSERT INTO t1 VALUES(null);
702 INSERT INTO t1 VALUES(null);
706 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
707 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
708 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
709 SHOW CREATE TABLE t1;
710 INSERT INTO t1 VALUES(null);
711 INSERT INTO t1 VALUES(null);
712 INSERT INTO t1 VALUES(null);
716 INSERT INTO t1 VALUES(null);
719 ALTER TABLE t1 AUTO_INCREMENT=10;
720 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
721 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
722 SHOW CREATE TABLE t1;
723 INSERT INTO t1 VALUES(null);
724 INSERT INTO t1 VALUES(null);
725 INSERT INTO t1 VALUES(null);
729 INSERT INTO t1 VALUES(null);
733 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
734 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
735 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
736 SHOW CREATE TABLE t1;
737 INSERT INTO t1 VALUES(null);
738 INSERT INTO t1 VALUES(null);
739 INSERT INTO t1 VALUES(null);
743 INSERT INTO t1 VALUES(null);
746 ALTER TABLE t1 AUTO_INCREMENT=10;
747 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
748 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
749 SHOW CREATE TABLE t1;
750 INSERT INTO t1 VALUES(null);
751 INSERT INTO t1 VALUES(null);
752 INSERT INTO t1 VALUES(null);
756 INSERT INTO t1 VALUES(null);
760 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
761 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
762 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
763 SHOW CREATE TABLE t1;
764 INSERT INTO t1 VALUES(null);
765 INSERT INTO t1 VALUES(null);
766 INSERT INTO t1 VALUES(null);
770 INSERT INTO t1 VALUES(null);
773 ALTER TABLE t1 AUTO_INCREMENT=10;
774 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
775 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
776 SHOW CREATE TABLE t1;
777 INSERT INTO t1 VALUES(null);
778 INSERT INTO t1 VALUES(null);
779 INSERT INTO t1 VALUES(null);
783 INSERT INTO t1 VALUES(null);
787 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
788 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
789 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
790 SHOW CREATE TABLE t1;
791 INSERT INTO t1 VALUES(null);
792 INSERT INTO t1 VALUES(null);
793 INSERT INTO t1 VALUES(null);
797 INSERT INTO t1 VALUES(null);
800 ALTER TABLE t1 AUTO_INCREMENT=10;
801 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
802 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
803 SHOW CREATE TABLE t1;
804 INSERT INTO t1 VALUES(null);
805 INSERT INTO t1 VALUES(null);
806 INSERT INTO t1 VALUES(null);
810 INSERT INTO t1 VALUES(null);
814 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
815 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
816 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
817 SHOW CREATE TABLE t1;
818 INSERT INTO t1 VALUES(null);
819 INSERT INTO t1 VALUES(null);
820 INSERT INTO t1 VALUES(null);
824 INSERT INTO t1 VALUES(null);
827 ALTER TABLE t1 AUTO_INCREMENT=10;
828 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
829 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
830 SHOW CREATE TABLE t1;
831 INSERT INTO t1 VALUES(null);
832 INSERT INTO t1 VALUES(null);
833 INSERT INTO t1 VALUES(null);
837 INSERT INTO t1 VALUES(null);
841 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
842 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
843 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
844 SHOW CREATE TABLE t1;
845 INSERT INTO t1 VALUES(null);
846 INSERT INTO t1 VALUES(null);
847 INSERT INTO t1 VALUES(null);
851 INSERT INTO t1 VALUES(null);
854 ALTER TABLE t1 AUTO_INCREMENT=10;
855 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
856 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
857 SHOW CREATE TABLE t1;
858 INSERT INTO t1 VALUES(null);
859 INSERT INTO t1 VALUES(null);
860 INSERT INTO t1 VALUES(null);
864 INSERT INTO t1 VALUES(null);
868 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
869 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
870 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
871 SHOW CREATE TABLE t1;
872 INSERT INTO t1 VALUES(null);
873 INSERT INTO t1 VALUES(null);
874 INSERT INTO t1 VALUES(null);
878 INSERT INTO t1 VALUES(null);
881 ALTER TABLE t1 AUTO_INCREMENT=10;
882 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
883 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
884 SHOW CREATE TABLE t1;
885 INSERT INTO t1 VALUES(null);
886 INSERT INTO t1 VALUES(null);
887 INSERT INTO t1 VALUES(null);
891 INSERT INTO t1 VALUES(null);
895 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
896 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
897 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
898 SHOW CREATE TABLE t1;
899 INSERT INTO t1 VALUES(null);
900 INSERT INTO t1 VALUES(null);
901 INSERT INTO t1 VALUES(null);
905 INSERT INTO t1 VALUES(null);
908 ALTER TABLE t1 AUTO_INCREMENT=10;
909 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
910 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
911 SHOW CREATE TABLE t1;
912 INSERT INTO t1 VALUES(null);
913 INSERT INTO t1 VALUES(null);
914 INSERT INTO t1 VALUES(null);
918 INSERT INTO t1 VALUES(null);
922 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
923 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
924 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
925 SHOW CREATE TABLE t1;
926 INSERT INTO t1 VALUES(null);
927 INSERT INTO t1 VALUES(null);
928 INSERT INTO t1 VALUES(null);
932 INSERT INTO t1 VALUES(null);
935 ALTER TABLE t1 AUTO_INCREMENT=10;
936 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
937 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
938 SHOW CREATE TABLE t1;
939 INSERT INTO t1 VALUES(null);
940 INSERT INTO t1 VALUES(null);
941 INSERT INTO t1 VALUES(null);
945 INSERT INTO t1 VALUES(null);
949 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
950 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
951 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
952 SHOW CREATE TABLE t1;
953 INSERT INTO t1 VALUES(null);
954 INSERT INTO t1 VALUES(null);
955 INSERT INTO t1 VALUES(null);
959 INSERT INTO t1 VALUES(null);
962 ALTER TABLE t1 AUTO_INCREMENT=10;
963 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
964 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
965 SHOW CREATE TABLE t1;
966 INSERT INTO t1 VALUES(null);
967 INSERT INTO t1 VALUES(null);
968 INSERT INTO t1 VALUES(null);
972 INSERT INTO t1 VALUES(null);
976 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
977 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
978 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
979 SHOW CREATE TABLE t1;
980 INSERT INTO t1 VALUES(null);
981 INSERT INTO t1 VALUES(null);
982 INSERT INTO t1 VALUES(null);
986 INSERT INTO t1 VALUES(null);
989 ALTER TABLE t1 AUTO_INCREMENT=10;
990 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
991 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
992 SHOW CREATE TABLE t1;
993 INSERT INTO t1 VALUES(null);
994 INSERT INTO t1 VALUES(null);
995 INSERT INTO t1 VALUES(null);
999 INSERT INTO t1 VALUES(null);
1003 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1004 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1005 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1006 SHOW CREATE TABLE t1;
1007 INSERT INTO t1 VALUES(null);
1008 INSERT INTO t1 VALUES(null);
1009 INSERT INTO t1 VALUES(null);
1013 INSERT INTO t1 VALUES(null);
1016 ALTER TABLE t1 AUTO_INCREMENT=10;
1017 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1018 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1019 SHOW CREATE TABLE t1;
1020 INSERT INTO t1 VALUES(null);
1021 INSERT INTO t1 VALUES(null);
1022 INSERT INTO t1 VALUES(null);
1026 INSERT INTO t1 VALUES(null);
1030 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1031 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1032 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1033 SHOW CREATE TABLE t1;
1034 INSERT INTO t1 VALUES(null);
1035 INSERT INTO t1 VALUES(null);
1036 INSERT INTO t1 VALUES(null);
1040 INSERT INTO t1 VALUES(null);
1043 ALTER TABLE t1 AUTO_INCREMENT=10;
1044 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1045 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1046 SHOW CREATE TABLE t1;
1047 INSERT INTO t1 VALUES(null);
1048 INSERT INTO t1 VALUES(null);
1049 INSERT INTO t1 VALUES(null);
1053 INSERT INTO t1 VALUES(null);
1057 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1058 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1059 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1060 SHOW CREATE TABLE t1;
1061 INSERT INTO t1 VALUES(null);
1062 INSERT INTO t1 VALUES(null);
1063 INSERT INTO t1 VALUES(null);
1067 INSERT INTO t1 VALUES(null);
1070 ALTER TABLE t1 AUTO_INCREMENT=10;
1071 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1072 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1073 SHOW CREATE TABLE t1;
1074 INSERT INTO t1 VALUES(null);
1075 INSERT INTO t1 VALUES(null);
1076 INSERT INTO t1 VALUES(null);
1080 INSERT INTO t1 VALUES(null);
1084 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1085 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1086 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1087 SHOW CREATE TABLE t1;
1088 INSERT INTO t1 VALUES(null);
1089 INSERT INTO t1 VALUES(null);
1090 INSERT INTO t1 VALUES(null);
1094 INSERT INTO t1 VALUES(null);
1097 ALTER TABLE t1 AUTO_INCREMENT=10;
1098 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1099 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1100 SHOW CREATE TABLE t1;
1101 INSERT INTO t1 VALUES(null);
1102 INSERT INTO t1 VALUES(null);
1103 INSERT INTO t1 VALUES(null);
1107 INSERT INTO t1 VALUES(null);
1111 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1112 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1113 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1114 SHOW CREATE TABLE t1;
1115 INSERT INTO t1 VALUES(null);
1116 INSERT INTO t1 VALUES(null);
1117 INSERT INTO t1 VALUES(null);
1121 INSERT INTO t1 VALUES(null);
1124 ALTER TABLE t1 AUTO_INCREMENT=10;
1125 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1126 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1127 SHOW CREATE TABLE t1;
1128 INSERT INTO t1 VALUES(null);
1129 INSERT INTO t1 VALUES(null);
1130 INSERT INTO t1 VALUES(null);
1134 INSERT INTO t1 VALUES(null);
1138 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1139 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1141 SHOW CREATE TABLE t1;
1142 INSERT INTO t1 VALUES(null);
1143 INSERT INTO t1 VALUES(null);
1144 INSERT INTO t1 VALUES(null);
1148 INSERT INTO t1 VALUES(null);
1151 ALTER TABLE t1 AUTO_INCREMENT=10;
1152 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1153 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1154 SHOW CREATE TABLE t1;
1155 INSERT INTO t1 VALUES(null);
1156 INSERT INTO t1 VALUES(null);
1157 INSERT INTO t1 VALUES(null);
1161 INSERT INTO t1 VALUES(null);
1165 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1166 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1167 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1168 SHOW CREATE TABLE t1;
1169 INSERT INTO t1 VALUES(null);
1170 INSERT INTO t1 VALUES(null);
1171 INSERT INTO t1 VALUES(null);
1175 INSERT INTO t1 VALUES(null);
1178 ALTER TABLE t1 AUTO_INCREMENT=10;
1179 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1180 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1181 SHOW CREATE TABLE t1;
1182 INSERT INTO t1 VALUES(null);
1183 INSERT INTO t1 VALUES(null);
1184 INSERT INTO t1 VALUES(null);
1188 INSERT INTO t1 VALUES(null);
1192 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1193 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1194 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1195 SHOW CREATE TABLE t1;
1196 INSERT INTO t1 VALUES(null);
1197 INSERT INTO t1 VALUES(null);
1198 INSERT INTO t1 VALUES(null);
1202 INSERT INTO t1 VALUES(null);
1205 ALTER TABLE t1 AUTO_INCREMENT=10;
1206 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1207 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1208 SHOW CREATE TABLE t1;
1209 INSERT INTO t1 VALUES(null);
1210 INSERT INTO t1 VALUES(null);
1211 INSERT INTO t1 VALUES(null);
1215 INSERT INTO t1 VALUES(null);
1219 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1220 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1221 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1222 SHOW CREATE TABLE t1;
1223 INSERT INTO t1 VALUES(null);
1224 INSERT INTO t1 VALUES(null);
1225 INSERT INTO t1 VALUES(null);
1229 INSERT INTO t1 VALUES(null);
1232 ALTER TABLE t1 AUTO_INCREMENT=10;
1233 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1234 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1235 SHOW CREATE TABLE t1;
1236 INSERT INTO t1 VALUES(null);
1237 INSERT INTO t1 VALUES(null);
1238 INSERT INTO t1 VALUES(null);
1242 INSERT INTO t1 VALUES(null);
1246 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1247 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1249 SHOW CREATE TABLE t1;
1250 INSERT INTO t1 VALUES(null);
1251 INSERT INTO t1 VALUES(null);
1252 INSERT INTO t1 VALUES(null);
1256 INSERT INTO t1 VALUES(null);
1259 ALTER TABLE t1 AUTO_INCREMENT=10;
1260 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1261 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1262 SHOW CREATE TABLE t1;
1263 INSERT INTO t1 VALUES(null);
1264 INSERT INTO t1 VALUES(null);
1265 INSERT INTO t1 VALUES(null);
1269 INSERT INTO t1 VALUES(null);
1273 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1274 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1275 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1276 SHOW CREATE TABLE t1;
1277 INSERT INTO t1 VALUES(null);
1278 INSERT INTO t1 VALUES(null);
1279 INSERT INTO t1 VALUES(null);
1283 INSERT INTO t1 VALUES(null);
1286 ALTER TABLE t1 AUTO_INCREMENT=10;
1287 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1288 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1289 SHOW CREATE TABLE t1;
1290 INSERT INTO t1 VALUES(null);
1291 INSERT INTO t1 VALUES(null);
1292 INSERT INTO t1 VALUES(null);
1296 INSERT INTO t1 VALUES(null);
1300 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1301 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1302 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1303 SHOW CREATE TABLE t1;
1304 INSERT INTO t1 VALUES(null);
1305 INSERT INTO t1 VALUES(null);
1306 INSERT INTO t1 VALUES(null);
1310 INSERT INTO t1 VALUES(null);
1313 ALTER TABLE t1 AUTO_INCREMENT=10;
1314 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1315 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1316 SHOW CREATE TABLE t1;
1317 INSERT INTO t1 VALUES(null);
1318 INSERT INTO t1 VALUES(null);
1319 INSERT INTO t1 VALUES(null);
1323 INSERT INTO t1 VALUES(null);
1327 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1328 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1329 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1330 SHOW CREATE TABLE t1;
1331 INSERT INTO t1 VALUES(null);
1332 INSERT INTO t1 VALUES(null);
1333 INSERT INTO t1 VALUES(null);
1337 INSERT INTO t1 VALUES(null);
1340 ALTER TABLE t1 AUTO_INCREMENT=10;
1341 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1342 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1343 SHOW CREATE TABLE t1;
1344 INSERT INTO t1 VALUES(null);
1345 INSERT INTO t1 VALUES(null);
1346 INSERT INTO t1 VALUES(null);
1350 INSERT INTO t1 VALUES(null);
1354 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1355 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1356 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1357 SHOW CREATE TABLE t1;
1358 INSERT INTO t1 VALUES(null);
1359 INSERT INTO t1 VALUES(null);
1360 INSERT INTO t1 VALUES(null);
1364 INSERT INTO t1 VALUES(null);
1367 ALTER TABLE t1 AUTO_INCREMENT=10;
1368 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1369 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1370 SHOW CREATE TABLE t1;
1371 INSERT INTO t1 VALUES(null);
1372 INSERT INTO t1 VALUES(null);
1373 INSERT INTO t1 VALUES(null);
1377 INSERT INTO t1 VALUES(null);
1381 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1382 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1383 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1384 SHOW CREATE TABLE t1;
1385 INSERT INTO t1 VALUES(null);
1386 INSERT INTO t1 VALUES(null);
1387 INSERT INTO t1 VALUES(null);
1391 INSERT INTO t1 VALUES(null);
1394 ALTER TABLE t1 AUTO_INCREMENT=10;
1395 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1397 SHOW CREATE TABLE t1;
1398 INSERT INTO t1 VALUES(null);
1399 INSERT INTO t1 VALUES(null);
1400 INSERT INTO t1 VALUES(null);
1404 INSERT INTO t1 VALUES(null);
1408 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1409 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1410 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1411 SHOW CREATE TABLE t1;
1412 INSERT INTO t1 VALUES(null);
1413 INSERT INTO t1 VALUES(null);
1414 INSERT INTO t1 VALUES(null);
1418 INSERT INTO t1 VALUES(null);
1421 ALTER TABLE t1 AUTO_INCREMENT=10;
1422 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1423 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1424 SHOW CREATE TABLE t1;
1425 INSERT INTO t1 VALUES(null);
1426 INSERT INTO t1 VALUES(null);
1427 INSERT INTO t1 VALUES(null);
1431 INSERT INTO t1 VALUES(null);
1435 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1436 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1437 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1438 SHOW CREATE TABLE t1;
1439 INSERT INTO t1 VALUES(null);
1440 INSERT INTO t1 VALUES(null);
1441 INSERT INTO t1 VALUES(null);
1445 INSERT INTO t1 VALUES(null);
1448 ALTER TABLE t1 AUTO_INCREMENT=10;
1449 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1450 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1451 SHOW CREATE TABLE t1;
1452 INSERT INTO t1 VALUES(null);
1453 INSERT INTO t1 VALUES(null);
1454 INSERT INTO t1 VALUES(null);
1458 INSERT INTO t1 VALUES(null);
1462 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1463 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1464 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1465 SHOW CREATE TABLE t1;
1466 INSERT INTO t1 VALUES(null);
1467 INSERT INTO t1 VALUES(null);
1468 INSERT INTO t1 VALUES(null);
1472 INSERT INTO t1 VALUES(null);
1475 ALTER TABLE t1 AUTO_INCREMENT=10;
1476 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1477 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1478 SHOW CREATE TABLE t1;
1479 INSERT INTO t1 VALUES(null);
1480 INSERT INTO t1 VALUES(null);
1481 INSERT INTO t1 VALUES(null);
1485 INSERT INTO t1 VALUES(null);
1489 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1490 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1491 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1492 SHOW CREATE TABLE t1;
1493 INSERT INTO t1 VALUES(null);
1494 INSERT INTO t1 VALUES(null);
1495 INSERT INTO t1 VALUES(null);
1499 INSERT INTO t1 VALUES(null);
1502 ALTER TABLE t1 AUTO_INCREMENT=10;
1503 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1504 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1505 SHOW CREATE TABLE t1;
1506 INSERT INTO t1 VALUES(null);
1507 INSERT INTO t1 VALUES(null);
1508 INSERT INTO t1 VALUES(null);
1512 INSERT INTO t1 VALUES(null);
1516 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1517 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1518 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1519 SHOW CREATE TABLE t1;
1520 INSERT INTO t1 VALUES(null);
1521 INSERT INTO t1 VALUES(null);
1522 INSERT INTO t1 VALUES(null);
1526 INSERT INTO t1 VALUES(null);
1529 ALTER TABLE t1 AUTO_INCREMENT=10;
1530 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1531 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1532 SHOW CREATE TABLE t1;
1533 INSERT INTO t1 VALUES(null);
1534 INSERT INTO t1 VALUES(null);
1535 INSERT INTO t1 VALUES(null);
1539 INSERT INTO t1 VALUES(null);
1543 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1544 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1545 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1546 SHOW CREATE TABLE t1;
1547 INSERT INTO t1 VALUES(null);
1548 INSERT INTO t1 VALUES(null);
1549 INSERT INTO t1 VALUES(null);
1553 INSERT INTO t1 VALUES(null);
1556 ALTER TABLE t1 AUTO_INCREMENT=10;
1557 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1558 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1559 SHOW CREATE TABLE t1;
1560 INSERT INTO t1 VALUES(null);
1561 INSERT INTO t1 VALUES(null);
1562 INSERT INTO t1 VALUES(null);
1566 INSERT INTO t1 VALUES(null);
1570 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1571 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1572 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1573 SHOW CREATE TABLE t1;
1574 INSERT INTO t1 VALUES(null);
1575 INSERT INTO t1 VALUES(null);
1576 INSERT INTO t1 VALUES(null);
1580 INSERT INTO t1 VALUES(null);
1583 ALTER TABLE t1 AUTO_INCREMENT=10;
1584 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1585 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1586 SHOW CREATE TABLE t1;
1587 INSERT INTO t1 VALUES(null);
1588 INSERT INTO t1 VALUES(null);
1589 INSERT INTO t1 VALUES(null);
1593 INSERT INTO t1 VALUES(null);
1597 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1598 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1599 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1600 SHOW CREATE TABLE t1;
1601 INSERT INTO t1 VALUES(null);
1602 INSERT INTO t1 VALUES(null);
1603 INSERT INTO t1 VALUES(null);
1607 INSERT INTO t1 VALUES(null);
1610 ALTER TABLE t1 AUTO_INCREMENT=10;
1611 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
1612 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1613 SHOW CREATE TABLE t1;
1614 INSERT INTO t1 VALUES(null);
1615 INSERT INTO t1 VALUES(null);
1616 INSERT INTO t1 VALUES(null);
1620 INSERT INTO t1 VALUES(null);