--disable_warnings let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`; --enable_warnings --disable_warnings DROP TABLE IF EXISTS t3; --enable_warnings CREATE TABLE t3(c1 TINYINT UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 SMALLINT UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 MEDIUMINT UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 INT UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 INTEGER UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 BIGINT UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DECIMAL UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DEC UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 FIXED UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 NUMERIC UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DOUBLE UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 REAL UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DOUBLE PRECISION UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 FLOAT UNSIGNED NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 TINYINT UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 SMALLINT UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 MEDIUMINT UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 INT UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 INTEGER UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 BIGINT UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DECIMAL UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DEC UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 FIXED UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 NUMERIC UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DOUBLE UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 REAL UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 DOUBLE PRECISION UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; CREATE TABLE t3(c1 FLOAT UNSIGNED NOT NULL); SHOW TABLES; --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES;