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