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 t5; 7--enable_warnings 8CREATE TEMPORARY TABLE t5(c1 BIT(10) NULL); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 12CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NULL); 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 16CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NULL); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 20CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NULL); 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 24CREATE TEMPORARY TABLE t5(c1 INT(10) NULL); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 28CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NULL); 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 32CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NULL); 33SHOW TABLES; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 36CREATE TEMPORARY TABLE t5(c1 CHAR(10) NULL); 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 40CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NULL); 41SHOW TABLES; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 44CREATE TEMPORARY TABLE t5(c1 BINARY(10) NULL); 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 48CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NULL); 49SHOW TABLES; 50--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 51SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 52CREATE TEMPORARY TABLE t5(c1 BIT(10) NOT NULL); 53SHOW TABLES; 54--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 55SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 56CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NOT NULL); 57SHOW TABLES; 58--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 59SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 60CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NOT NULL); 61SHOW TABLES; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 64CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NOT NULL); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 68CREATE TEMPORARY TABLE t5(c1 INT(10) NOT NULL); 69SHOW TABLES; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 72CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NOT NULL); 73SHOW TABLES; 74--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 75SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 76CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NOT NULL); 77SHOW TABLES; 78--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 79SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 80CREATE TEMPORARY TABLE t5(c1 CHAR(10) NOT NULL); 81SHOW TABLES; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 83SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 84CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NOT NULL); 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 88CREATE TEMPORARY TABLE t5(c1 BINARY(10) NOT NULL); 89SHOW TABLES; 90--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 91SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 92CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NOT NULL); 93SHOW TABLES; 94--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 95SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 96 97