1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ); 3SHOW CREATE TABLE t1; 4Table Create Table 5t1 CREATE TABLE `t1` ( 6 `c1` tinyint NOT NULL AUTO_INCREMENT, 7 PRIMARY KEY (`c1`) 8) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 9SET INSERT_ID = 10; 10INSERT INTO t1 VALUES(null); 11INSERT INTO t1 VALUES(null); 12INSERT INTO t1 VALUES(null); 13SELECT * FROM t1; 14c1 1510 1611 1712 18DROP TABLE t1; 19SHOW TABLES; 20Tables_in_test 21CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ); 22SHOW CREATE TABLE t1; 23Table Create Table 24t1 CREATE TABLE `t1` ( 25 `c1` smallint NOT NULL AUTO_INCREMENT, 26 PRIMARY KEY (`c1`) 27) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 28SET INSERT_ID = 10; 29INSERT INTO t1 VALUES(null); 30INSERT INTO t1 VALUES(null); 31INSERT INTO t1 VALUES(null); 32SELECT * FROM t1; 33c1 3410 3511 3612 37DROP TABLE t1; 38SHOW TABLES; 39Tables_in_test 40CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ); 41SHOW CREATE TABLE t1; 42Table Create Table 43t1 CREATE TABLE `t1` ( 44 `c1` mediumint NOT NULL AUTO_INCREMENT, 45 PRIMARY KEY (`c1`) 46) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 47SET INSERT_ID = 10; 48INSERT INTO t1 VALUES(null); 49INSERT INTO t1 VALUES(null); 50INSERT INTO t1 VALUES(null); 51SELECT * FROM t1; 52c1 5310 5411 5512 56DROP TABLE t1; 57SHOW TABLES; 58Tables_in_test 59CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ); 60SHOW CREATE TABLE t1; 61Table Create Table 62t1 CREATE TABLE `t1` ( 63 `c1` int NOT NULL AUTO_INCREMENT, 64 PRIMARY KEY (`c1`) 65) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 66SET INSERT_ID = 10; 67INSERT INTO t1 VALUES(null); 68INSERT INTO t1 VALUES(null); 69INSERT INTO t1 VALUES(null); 70SELECT * FROM t1; 71c1 7210 7311 7412 75DROP TABLE t1; 76SHOW TABLES; 77Tables_in_test 78CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ); 79SHOW CREATE TABLE t1; 80Table Create Table 81t1 CREATE TABLE `t1` ( 82 `c1` int NOT NULL AUTO_INCREMENT, 83 PRIMARY KEY (`c1`) 84) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 85SET INSERT_ID = 10; 86INSERT INTO t1 VALUES(null); 87INSERT INTO t1 VALUES(null); 88INSERT INTO t1 VALUES(null); 89SELECT * FROM t1; 90c1 9110 9211 9312 94DROP TABLE t1; 95SHOW TABLES; 96Tables_in_test 97CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ); 98SHOW CREATE TABLE t1; 99Table Create Table 100t1 CREATE TABLE `t1` ( 101 `c1` bigint NOT NULL AUTO_INCREMENT, 102 PRIMARY KEY (`c1`) 103) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 104SET INSERT_ID = 10; 105INSERT INTO t1 VALUES(null); 106INSERT INTO t1 VALUES(null); 107INSERT INTO t1 VALUES(null); 108SELECT * FROM t1; 109c1 11010 11111 11212 113DROP TABLE t1; 114SHOW TABLES; 115Tables_in_test 116CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ); 117SHOW CREATE TABLE t1; 118Table Create Table 119t1 CREATE TABLE `t1` ( 120 `c1` tinyint NOT NULL AUTO_INCREMENT, 121 PRIMARY KEY (`c1`) 122) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 123SET INSERT_ID = 10; 124INSERT INTO t1 VALUES(null); 125INSERT INTO t1 VALUES(null); 126INSERT INTO t1 VALUES(null); 127SELECT * FROM t1; 128c1 12910 13011 13112 132DROP TABLE t1; 133SHOW TABLES; 134Tables_in_test 135CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ); 136SHOW CREATE TABLE t1; 137Table Create Table 138t1 CREATE TABLE `t1` ( 139 `c1` smallint NOT NULL AUTO_INCREMENT, 140 PRIMARY KEY (`c1`) 141) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 142SET INSERT_ID = 10; 143INSERT INTO t1 VALUES(null); 144INSERT INTO t1 VALUES(null); 145INSERT INTO t1 VALUES(null); 146SELECT * FROM t1; 147c1 14810 14911 15012 151DROP TABLE t1; 152SHOW TABLES; 153Tables_in_test 154CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ); 155SHOW CREATE TABLE t1; 156Table Create Table 157t1 CREATE TABLE `t1` ( 158 `c1` mediumint NOT NULL AUTO_INCREMENT, 159 PRIMARY KEY (`c1`) 160) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 161SET INSERT_ID = 10; 162INSERT INTO t1 VALUES(null); 163INSERT INTO t1 VALUES(null); 164INSERT INTO t1 VALUES(null); 165SELECT * FROM t1; 166c1 16710 16811 16912 170DROP TABLE t1; 171SHOW TABLES; 172Tables_in_test 173CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ); 174SHOW CREATE TABLE t1; 175Table Create Table 176t1 CREATE TABLE `t1` ( 177 `c1` int NOT NULL AUTO_INCREMENT, 178 PRIMARY KEY (`c1`) 179) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 180SET INSERT_ID = 10; 181INSERT INTO t1 VALUES(null); 182INSERT INTO t1 VALUES(null); 183INSERT INTO t1 VALUES(null); 184SELECT * FROM t1; 185c1 18610 18711 18812 189DROP TABLE t1; 190SHOW TABLES; 191Tables_in_test 192CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ); 193SHOW CREATE TABLE t1; 194Table Create Table 195t1 CREATE TABLE `t1` ( 196 `c1` int NOT NULL AUTO_INCREMENT, 197 PRIMARY KEY (`c1`) 198) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 199SET INSERT_ID = 10; 200INSERT INTO t1 VALUES(null); 201INSERT INTO t1 VALUES(null); 202INSERT INTO t1 VALUES(null); 203SELECT * FROM t1; 204c1 20510 20611 20712 208DROP TABLE t1; 209SHOW TABLES; 210Tables_in_test 211CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ); 212SHOW CREATE TABLE t1; 213Table Create Table 214t1 CREATE TABLE `t1` ( 215 `c1` bigint NOT NULL AUTO_INCREMENT, 216 PRIMARY KEY (`c1`) 217) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 218SET INSERT_ID = 10; 219INSERT INTO t1 VALUES(null); 220INSERT INTO t1 VALUES(null); 221INSERT INTO t1 VALUES(null); 222SELECT * FROM t1; 223c1 22410 22511 22612 227DROP TABLE t1; 228SHOW TABLES; 229Tables_in_test 230CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ); 231SHOW CREATE TABLE t1; 232Table Create Table 233t1 CREATE TABLE `t1` ( 234 `c1` tinyint AUTO_INCREMENT, 235 UNIQUE KEY `c1` (`c1`) 236) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 237SET INSERT_ID = 10; 238INSERT INTO t1 VALUES(null); 239INSERT INTO t1 VALUES(null); 240INSERT INTO t1 VALUES(null); 241SELECT * FROM t1; 242c1 243NULL 244NULL 245NULL 246DROP TABLE t1; 247SHOW TABLES; 248Tables_in_test 249CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ); 250SHOW CREATE TABLE t1; 251Table Create Table 252t1 CREATE TABLE `t1` ( 253 `c1` smallint AUTO_INCREMENT, 254 UNIQUE KEY `c1` (`c1`) 255) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 256SET INSERT_ID = 10; 257INSERT INTO t1 VALUES(null); 258INSERT INTO t1 VALUES(null); 259INSERT INTO t1 VALUES(null); 260SELECT * FROM t1; 261c1 262NULL 263NULL 264NULL 265DROP TABLE t1; 266SHOW TABLES; 267Tables_in_test 268CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ); 269SHOW CREATE TABLE t1; 270Table Create Table 271t1 CREATE TABLE `t1` ( 272 `c1` mediumint AUTO_INCREMENT, 273 UNIQUE KEY `c1` (`c1`) 274) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 275SET INSERT_ID = 10; 276INSERT INTO t1 VALUES(null); 277INSERT INTO t1 VALUES(null); 278INSERT INTO t1 VALUES(null); 279SELECT * FROM t1; 280c1 281NULL 282NULL 283NULL 284DROP TABLE t1; 285SHOW TABLES; 286Tables_in_test 287CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ); 288SHOW CREATE TABLE t1; 289Table Create Table 290t1 CREATE TABLE `t1` ( 291 `c1` int AUTO_INCREMENT, 292 UNIQUE KEY `c1` (`c1`) 293) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 294SET INSERT_ID = 10; 295INSERT INTO t1 VALUES(null); 296INSERT INTO t1 VALUES(null); 297INSERT INTO t1 VALUES(null); 298SELECT * FROM t1; 299c1 300NULL 301NULL 302NULL 303DROP TABLE t1; 304SHOW TABLES; 305Tables_in_test 306CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ); 307SHOW CREATE TABLE t1; 308Table Create Table 309t1 CREATE TABLE `t1` ( 310 `c1` int AUTO_INCREMENT, 311 UNIQUE KEY `c1` (`c1`) 312) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 313SET INSERT_ID = 10; 314INSERT INTO t1 VALUES(null); 315INSERT INTO t1 VALUES(null); 316INSERT INTO t1 VALUES(null); 317SELECT * FROM t1; 318c1 319NULL 320NULL 321NULL 322DROP TABLE t1; 323SHOW TABLES; 324Tables_in_test 325CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ); 326SHOW CREATE TABLE t1; 327Table Create Table 328t1 CREATE TABLE `t1` ( 329 `c1` bigint AUTO_INCREMENT, 330 UNIQUE KEY `c1` (`c1`) 331) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 332SET INSERT_ID = 10; 333INSERT INTO t1 VALUES(null); 334INSERT INTO t1 VALUES(null); 335INSERT INTO t1 VALUES(null); 336SELECT * FROM t1; 337c1 338NULL 339NULL 340NULL 341DROP TABLE t1; 342SHOW TABLES; 343Tables_in_test 344CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ); 345SHOW CREATE TABLE t1; 346Table Create Table 347t1 CREATE TABLE `t1` ( 348 `c1` tinyint NOT NULL AUTO_INCREMENT, 349 UNIQUE KEY `c1` (`c1`) 350) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 351SET INSERT_ID = 10; 352INSERT INTO t1 VALUES(null); 353INSERT INTO t1 VALUES(null); 354INSERT INTO t1 VALUES(null); 355SELECT * FROM t1; 356c1 35710 35811 35912 360DROP TABLE t1; 361SHOW TABLES; 362Tables_in_test 363CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ); 364SHOW CREATE TABLE t1; 365Table Create Table 366t1 CREATE TABLE `t1` ( 367 `c1` smallint NOT NULL AUTO_INCREMENT, 368 UNIQUE KEY `c1` (`c1`) 369) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 370SET INSERT_ID = 10; 371INSERT INTO t1 VALUES(null); 372INSERT INTO t1 VALUES(null); 373INSERT INTO t1 VALUES(null); 374SELECT * FROM t1; 375c1 37610 37711 37812 379DROP TABLE t1; 380SHOW TABLES; 381Tables_in_test 382CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ); 383SHOW CREATE TABLE t1; 384Table Create Table 385t1 CREATE TABLE `t1` ( 386 `c1` mediumint NOT NULL AUTO_INCREMENT, 387 UNIQUE KEY `c1` (`c1`) 388) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 389SET INSERT_ID = 10; 390INSERT INTO t1 VALUES(null); 391INSERT INTO t1 VALUES(null); 392INSERT INTO t1 VALUES(null); 393SELECT * FROM t1; 394c1 39510 39611 39712 398DROP TABLE t1; 399SHOW TABLES; 400Tables_in_test 401CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ); 402SHOW CREATE TABLE t1; 403Table Create Table 404t1 CREATE TABLE `t1` ( 405 `c1` int NOT NULL AUTO_INCREMENT, 406 UNIQUE KEY `c1` (`c1`) 407) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 408SET INSERT_ID = 10; 409INSERT INTO t1 VALUES(null); 410INSERT INTO t1 VALUES(null); 411INSERT INTO t1 VALUES(null); 412SELECT * FROM t1; 413c1 41410 41511 41612 417DROP TABLE t1; 418SHOW TABLES; 419Tables_in_test 420CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ); 421SHOW CREATE TABLE t1; 422Table Create Table 423t1 CREATE TABLE `t1` ( 424 `c1` int NOT NULL AUTO_INCREMENT, 425 UNIQUE KEY `c1` (`c1`) 426) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 427SET INSERT_ID = 10; 428INSERT INTO t1 VALUES(null); 429INSERT INTO t1 VALUES(null); 430INSERT INTO t1 VALUES(null); 431SELECT * FROM t1; 432c1 43310 43411 43512 436DROP TABLE t1; 437SHOW TABLES; 438Tables_in_test 439CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ); 440SHOW CREATE TABLE t1; 441Table Create Table 442t1 CREATE TABLE `t1` ( 443 `c1` bigint NOT NULL AUTO_INCREMENT, 444 UNIQUE KEY `c1` (`c1`) 445) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 446SET INSERT_ID = 10; 447INSERT INTO t1 VALUES(null); 448INSERT INTO t1 VALUES(null); 449INSERT INTO t1 VALUES(null); 450SELECT * FROM t1; 451c1 45210 45311 45412 455DROP TABLE t1; 456SHOW TABLES; 457Tables_in_test 458CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ); 459SHOW CREATE TABLE t1; 460Table Create Table 461t1 CREATE TABLE `t1` ( 462 `c1` tinyint NOT NULL AUTO_INCREMENT, 463 PRIMARY KEY (`c1`) 464) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 465SET INSERT_ID = 10; 466INSERT INTO t1 VALUES(null); 467INSERT INTO t1 VALUES(null); 468INSERT INTO t1 VALUES(null); 469SELECT * FROM t1; 470c1 47110 47211 47312 474DROP TABLE t1; 475SHOW TABLES; 476Tables_in_test 477CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ); 478SHOW CREATE TABLE t1; 479Table Create Table 480t1 CREATE TABLE `t1` ( 481 `c1` smallint NOT NULL AUTO_INCREMENT, 482 PRIMARY KEY (`c1`) 483) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 484SET INSERT_ID = 10; 485INSERT INTO t1 VALUES(null); 486INSERT INTO t1 VALUES(null); 487INSERT INTO t1 VALUES(null); 488SELECT * FROM t1; 489c1 49010 49111 49212 493DROP TABLE t1; 494SHOW TABLES; 495Tables_in_test 496CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ); 497SHOW CREATE TABLE t1; 498Table Create Table 499t1 CREATE TABLE `t1` ( 500 `c1` mediumint NOT NULL AUTO_INCREMENT, 501 PRIMARY KEY (`c1`) 502) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 503SET INSERT_ID = 10; 504INSERT INTO t1 VALUES(null); 505INSERT INTO t1 VALUES(null); 506INSERT INTO t1 VALUES(null); 507SELECT * FROM t1; 508c1 50910 51011 51112 512DROP TABLE t1; 513SHOW TABLES; 514Tables_in_test 515CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ); 516SHOW CREATE TABLE t1; 517Table Create Table 518t1 CREATE TABLE `t1` ( 519 `c1` int NOT NULL AUTO_INCREMENT, 520 PRIMARY KEY (`c1`) 521) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 522SET INSERT_ID = 10; 523INSERT INTO t1 VALUES(null); 524INSERT INTO t1 VALUES(null); 525INSERT INTO t1 VALUES(null); 526SELECT * FROM t1; 527c1 52810 52911 53012 531DROP TABLE t1; 532SHOW TABLES; 533Tables_in_test 534CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ); 535SHOW CREATE TABLE t1; 536Table Create Table 537t1 CREATE TABLE `t1` ( 538 `c1` int NOT NULL AUTO_INCREMENT, 539 PRIMARY KEY (`c1`) 540) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 541SET INSERT_ID = 10; 542INSERT INTO t1 VALUES(null); 543INSERT INTO t1 VALUES(null); 544INSERT INTO t1 VALUES(null); 545SELECT * FROM t1; 546c1 54710 54811 54912 550DROP TABLE t1; 551SHOW TABLES; 552Tables_in_test 553CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ); 554SHOW CREATE TABLE t1; 555Table Create Table 556t1 CREATE TABLE `t1` ( 557 `c1` bigint NOT NULL AUTO_INCREMENT, 558 PRIMARY KEY (`c1`) 559) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 560SET INSERT_ID = 10; 561INSERT INTO t1 VALUES(null); 562INSERT INTO t1 VALUES(null); 563INSERT INTO t1 VALUES(null); 564SELECT * FROM t1; 565c1 56610 56711 56812 569DROP TABLE t1; 570SHOW TABLES; 571Tables_in_test 572CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 573SHOW CREATE TABLE t1; 574Table Create Table 575t1 CREATE TABLE `t1` ( 576 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT, 577 PRIMARY KEY (`c1`) 578) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 579SET INSERT_ID = 10; 580INSERT INTO t1 VALUES(null); 581INSERT INTO t1 VALUES(null); 582INSERT INTO t1 VALUES(null); 583SELECT * FROM t1; 584c1 58510 58611 58712 588DROP TABLE t1; 589SHOW TABLES; 590Tables_in_test 591CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 592SHOW CREATE TABLE t1; 593Table Create Table 594t1 CREATE TABLE `t1` ( 595 `c1` smallint unsigned NOT NULL AUTO_INCREMENT, 596 PRIMARY KEY (`c1`) 597) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 598SET INSERT_ID = 10; 599INSERT INTO t1 VALUES(null); 600INSERT INTO t1 VALUES(null); 601INSERT INTO t1 VALUES(null); 602SELECT * FROM t1; 603c1 60410 60511 60612 607DROP TABLE t1; 608SHOW TABLES; 609Tables_in_test 610CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 611SHOW CREATE TABLE t1; 612Table Create Table 613t1 CREATE TABLE `t1` ( 614 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT, 615 PRIMARY KEY (`c1`) 616) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 617SET INSERT_ID = 10; 618INSERT INTO t1 VALUES(null); 619INSERT INTO t1 VALUES(null); 620INSERT INTO t1 VALUES(null); 621SELECT * FROM t1; 622c1 62310 62411 62512 626DROP TABLE t1; 627SHOW TABLES; 628Tables_in_test 629CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 630SHOW CREATE TABLE t1; 631Table Create Table 632t1 CREATE TABLE `t1` ( 633 `c1` int unsigned NOT NULL AUTO_INCREMENT, 634 PRIMARY KEY (`c1`) 635) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 636SET INSERT_ID = 10; 637INSERT INTO t1 VALUES(null); 638INSERT INTO t1 VALUES(null); 639INSERT INTO t1 VALUES(null); 640SELECT * FROM t1; 641c1 64210 64311 64412 645DROP TABLE t1; 646SHOW TABLES; 647Tables_in_test 648CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 649SHOW CREATE TABLE t1; 650Table Create Table 651t1 CREATE TABLE `t1` ( 652 `c1` int unsigned NOT NULL AUTO_INCREMENT, 653 PRIMARY KEY (`c1`) 654) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 655SET INSERT_ID = 10; 656INSERT INTO t1 VALUES(null); 657INSERT INTO t1 VALUES(null); 658INSERT INTO t1 VALUES(null); 659SELECT * FROM t1; 660c1 66110 66211 66312 664DROP TABLE t1; 665SHOW TABLES; 666Tables_in_test 667CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 668SHOW CREATE TABLE t1; 669Table Create Table 670t1 CREATE TABLE `t1` ( 671 `c1` bigint unsigned NOT NULL AUTO_INCREMENT, 672 PRIMARY KEY (`c1`) 673) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 674SET INSERT_ID = 10; 675INSERT INTO t1 VALUES(null); 676INSERT INTO t1 VALUES(null); 677INSERT INTO t1 VALUES(null); 678SELECT * FROM t1; 679c1 68010 68111 68212 683DROP TABLE t1; 684SHOW TABLES; 685Tables_in_test 686CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 687SHOW CREATE TABLE t1; 688Table Create Table 689t1 CREATE TABLE `t1` ( 690 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT, 691 PRIMARY KEY (`c1`) 692) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 693SET INSERT_ID = 10; 694INSERT INTO t1 VALUES(null); 695INSERT INTO t1 VALUES(null); 696INSERT INTO t1 VALUES(null); 697SELECT * FROM t1; 698c1 69910 70011 70112 702DROP TABLE t1; 703SHOW TABLES; 704Tables_in_test 705CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 706SHOW CREATE TABLE t1; 707Table Create Table 708t1 CREATE TABLE `t1` ( 709 `c1` smallint unsigned NOT NULL AUTO_INCREMENT, 710 PRIMARY KEY (`c1`) 711) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 712SET INSERT_ID = 10; 713INSERT INTO t1 VALUES(null); 714INSERT INTO t1 VALUES(null); 715INSERT INTO t1 VALUES(null); 716SELECT * FROM t1; 717c1 71810 71911 72012 721DROP TABLE t1; 722SHOW TABLES; 723Tables_in_test 724CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 725SHOW CREATE TABLE t1; 726Table Create Table 727t1 CREATE TABLE `t1` ( 728 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT, 729 PRIMARY KEY (`c1`) 730) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 731SET INSERT_ID = 10; 732INSERT INTO t1 VALUES(null); 733INSERT INTO t1 VALUES(null); 734INSERT INTO t1 VALUES(null); 735SELECT * FROM t1; 736c1 73710 73811 73912 740DROP TABLE t1; 741SHOW TABLES; 742Tables_in_test 743CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 744SHOW CREATE TABLE t1; 745Table Create Table 746t1 CREATE TABLE `t1` ( 747 `c1` int unsigned NOT NULL AUTO_INCREMENT, 748 PRIMARY KEY (`c1`) 749) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 750SET INSERT_ID = 10; 751INSERT INTO t1 VALUES(null); 752INSERT INTO t1 VALUES(null); 753INSERT INTO t1 VALUES(null); 754SELECT * FROM t1; 755c1 75610 75711 75812 759DROP TABLE t1; 760SHOW TABLES; 761Tables_in_test 762CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 763SHOW CREATE TABLE t1; 764Table Create Table 765t1 CREATE TABLE `t1` ( 766 `c1` int unsigned NOT NULL AUTO_INCREMENT, 767 PRIMARY KEY (`c1`) 768) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 769SET INSERT_ID = 10; 770INSERT INTO t1 VALUES(null); 771INSERT INTO t1 VALUES(null); 772INSERT INTO t1 VALUES(null); 773SELECT * FROM t1; 774c1 77510 77611 77712 778DROP TABLE t1; 779SHOW TABLES; 780Tables_in_test 781CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ); 782SHOW CREATE TABLE t1; 783Table Create Table 784t1 CREATE TABLE `t1` ( 785 `c1` bigint unsigned NOT NULL AUTO_INCREMENT, 786 PRIMARY KEY (`c1`) 787) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 788SET INSERT_ID = 10; 789INSERT INTO t1 VALUES(null); 790INSERT INTO t1 VALUES(null); 791INSERT INTO t1 VALUES(null); 792SELECT * FROM t1; 793c1 79410 79511 79612 797DROP TABLE t1; 798SHOW TABLES; 799Tables_in_test 800CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ); 801SHOW CREATE TABLE t1; 802Table Create Table 803t1 CREATE TABLE `t1` ( 804 `c1` tinyint unsigned AUTO_INCREMENT, 805 UNIQUE KEY `c1` (`c1`) 806) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 807SET INSERT_ID = 10; 808INSERT INTO t1 VALUES(null); 809INSERT INTO t1 VALUES(null); 810INSERT INTO t1 VALUES(null); 811SELECT * FROM t1; 812c1 813NULL 814NULL 815NULL 816DROP TABLE t1; 817SHOW TABLES; 818Tables_in_test 819CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ); 820SHOW CREATE TABLE t1; 821Table Create Table 822t1 CREATE TABLE `t1` ( 823 `c1` smallint unsigned AUTO_INCREMENT, 824 UNIQUE KEY `c1` (`c1`) 825) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 826SET INSERT_ID = 10; 827INSERT INTO t1 VALUES(null); 828INSERT INTO t1 VALUES(null); 829INSERT INTO t1 VALUES(null); 830SELECT * FROM t1; 831c1 832NULL 833NULL 834NULL 835DROP TABLE t1; 836SHOW TABLES; 837Tables_in_test 838CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ); 839SHOW CREATE TABLE t1; 840Table Create Table 841t1 CREATE TABLE `t1` ( 842 `c1` mediumint unsigned AUTO_INCREMENT, 843 UNIQUE KEY `c1` (`c1`) 844) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 845SET INSERT_ID = 10; 846INSERT INTO t1 VALUES(null); 847INSERT INTO t1 VALUES(null); 848INSERT INTO t1 VALUES(null); 849SELECT * FROM t1; 850c1 851NULL 852NULL 853NULL 854DROP TABLE t1; 855SHOW TABLES; 856Tables_in_test 857CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ); 858SHOW CREATE TABLE t1; 859Table Create Table 860t1 CREATE TABLE `t1` ( 861 `c1` int unsigned AUTO_INCREMENT, 862 UNIQUE KEY `c1` (`c1`) 863) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 864SET INSERT_ID = 10; 865INSERT INTO t1 VALUES(null); 866INSERT INTO t1 VALUES(null); 867INSERT INTO t1 VALUES(null); 868SELECT * FROM t1; 869c1 870NULL 871NULL 872NULL 873DROP TABLE t1; 874SHOW TABLES; 875Tables_in_test 876CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ); 877SHOW CREATE TABLE t1; 878Table Create Table 879t1 CREATE TABLE `t1` ( 880 `c1` int unsigned AUTO_INCREMENT, 881 UNIQUE KEY `c1` (`c1`) 882) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 883SET INSERT_ID = 10; 884INSERT INTO t1 VALUES(null); 885INSERT INTO t1 VALUES(null); 886INSERT INTO t1 VALUES(null); 887SELECT * FROM t1; 888c1 889NULL 890NULL 891NULL 892DROP TABLE t1; 893SHOW TABLES; 894Tables_in_test 895CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ); 896SHOW CREATE TABLE t1; 897Table Create Table 898t1 CREATE TABLE `t1` ( 899 `c1` bigint unsigned AUTO_INCREMENT, 900 UNIQUE KEY `c1` (`c1`) 901) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 902SET INSERT_ID = 10; 903INSERT INTO t1 VALUES(null); 904INSERT INTO t1 VALUES(null); 905INSERT INTO t1 VALUES(null); 906SELECT * FROM t1; 907c1 908NULL 909NULL 910NULL 911DROP TABLE t1; 912SHOW TABLES; 913Tables_in_test 914CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ); 915SHOW CREATE TABLE t1; 916Table Create Table 917t1 CREATE TABLE `t1` ( 918 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT, 919 UNIQUE KEY `c1` (`c1`) 920) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 921SET INSERT_ID = 10; 922INSERT INTO t1 VALUES(null); 923INSERT INTO t1 VALUES(null); 924INSERT INTO t1 VALUES(null); 925SELECT * FROM t1; 926c1 92710 92811 92912 930DROP TABLE t1; 931SHOW TABLES; 932Tables_in_test 933CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ); 934SHOW CREATE TABLE t1; 935Table Create Table 936t1 CREATE TABLE `t1` ( 937 `c1` smallint unsigned NOT NULL AUTO_INCREMENT, 938 UNIQUE KEY `c1` (`c1`) 939) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 940SET INSERT_ID = 10; 941INSERT INTO t1 VALUES(null); 942INSERT INTO t1 VALUES(null); 943INSERT INTO t1 VALUES(null); 944SELECT * FROM t1; 945c1 94610 94711 94812 949DROP TABLE t1; 950SHOW TABLES; 951Tables_in_test 952CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ); 953SHOW CREATE TABLE t1; 954Table Create Table 955t1 CREATE TABLE `t1` ( 956 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT, 957 UNIQUE KEY `c1` (`c1`) 958) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 959SET INSERT_ID = 10; 960INSERT INTO t1 VALUES(null); 961INSERT INTO t1 VALUES(null); 962INSERT INTO t1 VALUES(null); 963SELECT * FROM t1; 964c1 96510 96611 96712 968DROP TABLE t1; 969SHOW TABLES; 970Tables_in_test 971CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ); 972SHOW CREATE TABLE t1; 973Table Create Table 974t1 CREATE TABLE `t1` ( 975 `c1` int unsigned NOT NULL AUTO_INCREMENT, 976 UNIQUE KEY `c1` (`c1`) 977) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 978SET INSERT_ID = 10; 979INSERT INTO t1 VALUES(null); 980INSERT INTO t1 VALUES(null); 981INSERT INTO t1 VALUES(null); 982SELECT * FROM t1; 983c1 98410 98511 98612 987DROP TABLE t1; 988SHOW TABLES; 989Tables_in_test 990CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ); 991SHOW CREATE TABLE t1; 992Table Create Table 993t1 CREATE TABLE `t1` ( 994 `c1` int unsigned NOT NULL AUTO_INCREMENT, 995 UNIQUE KEY `c1` (`c1`) 996) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 997SET INSERT_ID = 10; 998INSERT INTO t1 VALUES(null); 999INSERT INTO t1 VALUES(null); 1000INSERT INTO t1 VALUES(null); 1001SELECT * FROM t1; 1002c1 100310 100411 100512 1006DROP TABLE t1; 1007SHOW TABLES; 1008Tables_in_test 1009CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ); 1010SHOW CREATE TABLE t1; 1011Table Create Table 1012t1 CREATE TABLE `t1` ( 1013 `c1` bigint unsigned NOT NULL AUTO_INCREMENT, 1014 UNIQUE KEY `c1` (`c1`) 1015) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1016SET INSERT_ID = 10; 1017INSERT INTO t1 VALUES(null); 1018INSERT INTO t1 VALUES(null); 1019INSERT INTO t1 VALUES(null); 1020SELECT * FROM t1; 1021c1 102210 102311 102412 1025DROP TABLE t1; 1026SHOW TABLES; 1027Tables_in_test 1028CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ); 1029SHOW CREATE TABLE t1; 1030Table Create Table 1031t1 CREATE TABLE `t1` ( 1032 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT, 1033 PRIMARY KEY (`c1`) 1034) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1035SET INSERT_ID = 10; 1036INSERT INTO t1 VALUES(null); 1037INSERT INTO t1 VALUES(null); 1038INSERT INTO t1 VALUES(null); 1039SELECT * FROM t1; 1040c1 104110 104211 104312 1044DROP TABLE t1; 1045SHOW TABLES; 1046Tables_in_test 1047CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ); 1048SHOW CREATE TABLE t1; 1049Table Create Table 1050t1 CREATE TABLE `t1` ( 1051 `c1` smallint unsigned NOT NULL AUTO_INCREMENT, 1052 PRIMARY KEY (`c1`) 1053) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1054SET INSERT_ID = 10; 1055INSERT INTO t1 VALUES(null); 1056INSERT INTO t1 VALUES(null); 1057INSERT INTO t1 VALUES(null); 1058SELECT * FROM t1; 1059c1 106010 106111 106212 1063DROP TABLE t1; 1064SHOW TABLES; 1065Tables_in_test 1066CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ); 1067SHOW CREATE TABLE t1; 1068Table Create Table 1069t1 CREATE TABLE `t1` ( 1070 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT, 1071 PRIMARY KEY (`c1`) 1072) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1073SET INSERT_ID = 10; 1074INSERT INTO t1 VALUES(null); 1075INSERT INTO t1 VALUES(null); 1076INSERT INTO t1 VALUES(null); 1077SELECT * FROM t1; 1078c1 107910 108011 108112 1082DROP TABLE t1; 1083SHOW TABLES; 1084Tables_in_test 1085CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ); 1086SHOW CREATE TABLE t1; 1087Table Create Table 1088t1 CREATE TABLE `t1` ( 1089 `c1` int unsigned NOT NULL AUTO_INCREMENT, 1090 PRIMARY KEY (`c1`) 1091) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1092SET INSERT_ID = 10; 1093INSERT INTO t1 VALUES(null); 1094INSERT INTO t1 VALUES(null); 1095INSERT INTO t1 VALUES(null); 1096SELECT * FROM t1; 1097c1 109810 109911 110012 1101DROP TABLE t1; 1102SHOW TABLES; 1103Tables_in_test 1104CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ); 1105SHOW CREATE TABLE t1; 1106Table Create Table 1107t1 CREATE TABLE `t1` ( 1108 `c1` int unsigned NOT NULL AUTO_INCREMENT, 1109 PRIMARY KEY (`c1`) 1110) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1111SET INSERT_ID = 10; 1112INSERT INTO t1 VALUES(null); 1113INSERT INTO t1 VALUES(null); 1114INSERT INTO t1 VALUES(null); 1115SELECT * FROM t1; 1116c1 111710 111811 111912 1120DROP TABLE t1; 1121SHOW TABLES; 1122Tables_in_test 1123CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ); 1124SHOW CREATE TABLE t1; 1125Table Create Table 1126t1 CREATE TABLE `t1` ( 1127 `c1` bigint unsigned NOT NULL AUTO_INCREMENT, 1128 PRIMARY KEY (`c1`) 1129) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1130SET INSERT_ID = 10; 1131INSERT INTO t1 VALUES(null); 1132INSERT INTO t1 VALUES(null); 1133INSERT INTO t1 VALUES(null); 1134SELECT * FROM t1; 1135c1 113610 113711 113812 1139DROP TABLE t1; 1140SHOW TABLES; 1141Tables_in_test 1142