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 t8; 7--enable_warnings 8CREATE TABLE t8(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11SHOW CREATE TABLE t8; DROP TABLE t8; SHOW TABLES; 12CREATE TABLE t8(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY); 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15SHOW CREATE TABLE t8; DROP TABLE t8; SHOW TABLES; 16CREATE TABLE t8(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19SHOW CREATE TABLE t8; DROP TABLE t8; SHOW TABLES; 20CREATE TABLE t8(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY); 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23SHOW CREATE TABLE t8; DROP TABLE t8; SHOW TABLES; 24CREATE TABLE t8(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27SHOW CREATE TABLE t8; DROP TABLE t8; SHOW TABLES; 28CREATE TABLE t8(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY); 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31SHOW CREATE TABLE t8; DROP TABLE t8; SHOW TABLES; 32 33