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 t4; 7--enable_warnings 8CREATE TABLE t4(c1 TINYINT ZEROFILL NULL); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 12CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL); 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 16CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 20CREATE TABLE t4(c1 INT ZEROFILL NULL); 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 24CREATE TABLE t4(c1 INTEGER ZEROFILL NULL); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 28CREATE TABLE t4(c1 BIGINT ZEROFILL NULL); 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 32CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL); 33SHOW TABLES; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 36CREATE TABLE t4(c1 DEC ZEROFILL NULL); 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 40CREATE TABLE t4(c1 FIXED ZEROFILL NULL); 41SHOW TABLES; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 44CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL); 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 48CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL); 49SHOW TABLES; 50--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 51SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 52CREATE TABLE t4(c1 REAL ZEROFILL NULL); 53SHOW TABLES; 54--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 55SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 56CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NULL); 57SHOW TABLES; 58--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 59SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 60CREATE TABLE t4(c1 FLOAT ZEROFILL NULL); 61SHOW TABLES; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 64CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 68CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL); 69SHOW TABLES; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 72CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL); 73SHOW TABLES; 74--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 75SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 76CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL); 77SHOW TABLES; 78--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 79SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 80CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL); 81SHOW TABLES; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 83SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 84CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL); 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 88CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL); 89SHOW TABLES; 90--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 91SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 92CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NULL); 93SHOW TABLES; 94--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 95SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 96CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NULL); 97SHOW TABLES; 98--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 99SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 100CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL); 101SHOW TABLES; 102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 103SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 104CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL); 105SHOW TABLES; 106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 107SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 108CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL); 109SHOW TABLES; 110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 111SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 112CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NULL); 113SHOW TABLES; 114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 115SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 116CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL); 117SHOW TABLES; 118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 119SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 120CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL); 121SHOW TABLES; 122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 123SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 124CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL); 125SHOW TABLES; 126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 127SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 128CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL); 129SHOW TABLES; 130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 131SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 132CREATE TABLE t4(c1 INT ZEROFILL NOT NULL); 133SHOW TABLES; 134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 135SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 136CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL); 137SHOW TABLES; 138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 139SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 140CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL); 141SHOW TABLES; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 143SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 144CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL); 145SHOW TABLES; 146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 147SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 148CREATE TABLE t4(c1 DEC ZEROFILL NOT NULL); 149SHOW TABLES; 150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 151SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 152CREATE TABLE t4(c1 FIXED ZEROFILL NOT NULL); 153SHOW TABLES; 154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 155SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 156CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL); 157SHOW TABLES; 158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 159SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 160CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL); 161SHOW TABLES; 162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 163SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 164CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL); 165SHOW TABLES; 166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 167SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 168CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NOT NULL); 169SHOW TABLES; 170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 171SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 172CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL); 173SHOW TABLES; 174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 175SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 176CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL); 177SHOW TABLES; 178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 179SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 180CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL); 181SHOW TABLES; 182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 183SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 184CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL); 185SHOW TABLES; 186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 187SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 188CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL); 189SHOW TABLES; 190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 191SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 192CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL); 193SHOW TABLES; 194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 195SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 196CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL); 197SHOW TABLES; 198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 199SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 200CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL); 201SHOW TABLES; 202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 203SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 204CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NOT NULL); 205SHOW TABLES; 206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 207SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 208CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NOT NULL); 209SHOW TABLES; 210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 211SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 212CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL); 213SHOW TABLES; 214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 215SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 216CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL); 217SHOW TABLES; 218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 219SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 220CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL); 221SHOW TABLES; 222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 223SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 224CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NOT NULL); 225SHOW TABLES; 226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 227SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 228CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL); 229SHOW TABLES; 230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 231SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 232