1--disable_warnings 2let $ENGINE=`select variable_value from performance_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 BIT NULL); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 12CREATE TABLE t1(c1 TINYINT NULL); 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 16CREATE TABLE t1(c1 SMALLINT NULL); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 20CREATE TABLE t1(c1 MEDIUMINT NULL); 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 24CREATE TABLE t1(c1 INT NULL); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 28CREATE TABLE t1(c1 INTEGER NULL); 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 32CREATE TABLE t1(c1 BIGINT NULL); 33SHOW TABLES; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 36CREATE TABLE t1(c1 DECIMAL NULL); 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 40CREATE TABLE t1(c1 DEC NULL); 41SHOW TABLES; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 44CREATE TABLE t1(c1 FIXED NULL); 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 48CREATE TABLE t1(c1 NUMERIC NULL); 49SHOW TABLES; 50--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 51SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 52CREATE TABLE t1(c1 DOUBLE NULL); 53SHOW TABLES; 54--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 55SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 56CREATE TABLE t1(c1 REAL NULL); 57SHOW TABLES; 58--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 59SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 60CREATE TABLE t1(c1 DOUBLE PRECISION NULL); 61SHOW TABLES; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 64CREATE TABLE t1(c1 FLOAT NULL); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 68CREATE TABLE t1(c1 DATE NULL); 69SHOW TABLES; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 72CREATE TABLE t1(c1 TIME NULL); 73SHOW TABLES; 74--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 75SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 76CREATE TABLE t1(c1 TIMESTAMP NULL); 77SHOW TABLES; 78--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 79SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 80CREATE TABLE t1(c1 DATETIME NULL); 81SHOW TABLES; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 83SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 84CREATE TABLE t1(c1 YEAR NULL); 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 88CREATE TABLE t1(c1 TINYBLOB NULL); 89SHOW TABLES; 90--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 91SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 92CREATE TABLE t1(c1 BLOB NULL); 93SHOW TABLES; 94--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 95SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 96CREATE TABLE t1(c1 MEDIUMBLOB NULL); 97SHOW TABLES; 98--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 99SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 100CREATE TABLE t1(c1 LONGBLOB NULL); 101SHOW TABLES; 102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 103SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 104CREATE TABLE t1(c1 TINYTEXT NULL); 105SHOW TABLES; 106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 107SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 108CREATE TABLE t1(c1 TEXT NULL); 109SHOW TABLES; 110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 111SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 112CREATE TABLE t1(c1 MEDIUMTEXT NULL); 113SHOW TABLES; 114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 115SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 116CREATE TABLE t1(c1 LONGTEXT NULL); 117SHOW TABLES; 118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 119SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 120