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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY 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 TEMPORARY TABLE t1(c1 LONGTEXT NULL); 117SHOW TABLES; 118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 119SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 120CREATE TEMPORARY TABLE t1(c1 BIT NOT NULL); 121SHOW TABLES; 122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 123SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 124CREATE TEMPORARY TABLE t1(c1 TINYINT NOT NULL); 125SHOW TABLES; 126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 127SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 128CREATE TEMPORARY TABLE t1(c1 SMALLINT NOT NULL); 129SHOW TABLES; 130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 131SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 132CREATE TEMPORARY TABLE t1(c1 MEDIUMINT NOT NULL); 133SHOW TABLES; 134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 135SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 136CREATE TEMPORARY TABLE t1(c1 INT NOT NULL); 137SHOW TABLES; 138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 139SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 140CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL); 141SHOW TABLES; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 143SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 144CREATE TEMPORARY TABLE t1(c1 BIGINT NOT NULL); 145SHOW TABLES; 146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 147SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 148CREATE TEMPORARY TABLE t1(c1 DECIMAL NOT NULL); 149SHOW TABLES; 150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 151SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 152CREATE TEMPORARY TABLE t1(c1 DEC NOT NULL); 153SHOW TABLES; 154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 155SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 156CREATE TEMPORARY TABLE t1(c1 FIXED NOT NULL); 157SHOW TABLES; 158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 159SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 160CREATE TEMPORARY TABLE t1(c1 NUMERIC NOT NULL); 161SHOW TABLES; 162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 163SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 164CREATE TEMPORARY TABLE t1(c1 DOUBLE NOT NULL); 165SHOW TABLES; 166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 167SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 168CREATE TEMPORARY TABLE t1(c1 REAL NOT NULL); 169SHOW TABLES; 170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 171SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 172CREATE TEMPORARY TABLE t1(c1 DOUBLE PRECISION NOT NULL); 173SHOW TABLES; 174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 175SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 176CREATE TEMPORARY TABLE t1(c1 FLOAT NOT NULL); 177SHOW TABLES; 178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 179SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 180CREATE TEMPORARY TABLE t1(c1 DATE NOT NULL); 181SHOW TABLES; 182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 183SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 184CREATE TEMPORARY TABLE t1(c1 TIME NOT NULL); 185SHOW TABLES; 186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 187SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 188CREATE TEMPORARY TABLE t1(c1 TIMESTAMP NOT NULL); 189SHOW TABLES; 190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 191SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 192CREATE TEMPORARY TABLE t1(c1 DATETIME NOT NULL); 193SHOW TABLES; 194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 195SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 196CREATE TEMPORARY TABLE t1(c1 YEAR NOT NULL); 197SHOW TABLES; 198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 199SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 200CREATE TEMPORARY TABLE t1(c1 TINYBLOB NOT NULL); 201SHOW TABLES; 202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 203SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 204CREATE TEMPORARY TABLE t1(c1 BLOB NOT NULL); 205SHOW TABLES; 206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 207SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 208CREATE TEMPORARY TABLE t1(c1 MEDIUMBLOB NOT NULL); 209SHOW TABLES; 210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 211SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 212CREATE TEMPORARY TABLE t1(c1 LONGBLOB NOT NULL); 213SHOW TABLES; 214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 215SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 216CREATE TEMPORARY TABLE t1(c1 TINYTEXT NOT NULL); 217SHOW TABLES; 218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 219SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 220CREATE TEMPORARY TABLE t1(c1 TEXT NOT NULL); 221SHOW TABLES; 222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 223SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 224CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT NOT NULL); 225SHOW TABLES; 226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 227SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 228CREATE TEMPORARY TABLE t1(c1 LONGTEXT NOT NULL); 229SHOW TABLES; 230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 231SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 232 233