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 t2; 7--enable_warnings 8CREATE TABLE t2(c1 BIT NOT NULL); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11 SHOW CREATE TABLE t2; 12ALTER TABLE t2 MODIFY c1 BIT NULL; 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 16CREATE TABLE t2(c1 TINYINT NOT NULL); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19 SHOW CREATE TABLE t2; 20ALTER TABLE t2 MODIFY c1 TINYINT NULL; 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 24CREATE TABLE t2(c1 SMALLINT NOT NULL); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27 SHOW CREATE TABLE t2; 28ALTER TABLE t2 MODIFY c1 SMALLINT NULL; 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 32CREATE TABLE t2(c1 MEDIUMINT NOT NULL); 33SHOW TABLES; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35 SHOW CREATE TABLE t2; 36ALTER TABLE t2 MODIFY c1 MEDIUMINT NULL; 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 40CREATE TABLE t2(c1 INT NOT NULL); 41SHOW TABLES; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43 SHOW CREATE TABLE t2; 44ALTER TABLE t2 MODIFY c1 INT NULL; 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 48CREATE TABLE t2(c1 INTEGER NOT NULL); 49SHOW TABLES; 50--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 51 SHOW CREATE TABLE t2; 52ALTER TABLE t2 MODIFY c1 INTEGER NULL; 53SHOW TABLES; 54--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 55 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 56CREATE TABLE t2(c1 BIGINT NOT NULL); 57SHOW TABLES; 58--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 59 SHOW CREATE TABLE t2; 60ALTER TABLE t2 MODIFY c1 BIGINT NULL; 61SHOW TABLES; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 64CREATE TABLE t2(c1 REAL NOT NULL); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67 SHOW CREATE TABLE t2; 68ALTER TABLE t2 MODIFY c1 REAL NULL; 69SHOW TABLES; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 72CREATE TABLE t2(c1 DOUBLE NOT NULL); 73SHOW TABLES; 74--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 75 SHOW CREATE TABLE t2; 76ALTER TABLE t2 MODIFY c1 DOUBLE NULL; 77SHOW TABLES; 78--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 79 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 80CREATE TABLE t2(c1 FLOAT NOT NULL); 81SHOW TABLES; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 83 SHOW CREATE TABLE t2; 84ALTER TABLE t2 MODIFY c1 FLOAT NULL; 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 88CREATE TABLE t2(c1 DECIMAL NOT NULL); 89SHOW TABLES; 90--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 91 SHOW CREATE TABLE t2; 92ALTER TABLE t2 MODIFY c1 DECIMAL NULL; 93SHOW TABLES; 94--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 95 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 96CREATE TABLE t2(c1 NUMERIC NOT NULL); 97SHOW TABLES; 98--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 99 SHOW CREATE TABLE t2; 100ALTER TABLE t2 MODIFY c1 NUMERIC NULL; 101SHOW TABLES; 102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 103 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 104CREATE TABLE t2(c1 DATE NOT NULL); 105SHOW TABLES; 106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 107 SHOW CREATE TABLE t2; 108ALTER TABLE t2 MODIFY c1 DATE NULL; 109SHOW TABLES; 110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 111 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 112CREATE TABLE t2(c1 TIME NOT NULL); 113SHOW TABLES; 114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 115 SHOW CREATE TABLE t2; 116ALTER TABLE t2 MODIFY c1 TIME NULL; 117SHOW TABLES; 118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 119 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 120CREATE TABLE t2(c1 TIMESTAMP NOT NULL); 121SHOW TABLES; 122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 123 SHOW CREATE TABLE t2; 124ALTER TABLE t2 MODIFY c1 TIMESTAMP NULL; 125SHOW TABLES; 126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 127 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 128CREATE TABLE t2(c1 YEAR NOT NULL); 129SHOW TABLES; 130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 131 SHOW CREATE TABLE t2; 132ALTER TABLE t2 MODIFY c1 YEAR NULL; 133SHOW TABLES; 134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 135 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 136CREATE TABLE t2(c1 TINYBLOB NOT NULL); 137SHOW TABLES; 138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 139 SHOW CREATE TABLE t2; 140ALTER TABLE t2 MODIFY c1 TINYBLOB NULL; 141SHOW TABLES; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 143 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 144CREATE TABLE t2(c1 BLOB NOT NULL); 145SHOW TABLES; 146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 147 SHOW CREATE TABLE t2; 148ALTER TABLE t2 MODIFY c1 BLOB NULL; 149SHOW TABLES; 150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 151 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 152CREATE TABLE t2(c1 MEDIUMBLOB NOT NULL); 153SHOW TABLES; 154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 155 SHOW CREATE TABLE t2; 156ALTER TABLE t2 MODIFY c1 MEDIUMBLOB NULL; 157SHOW TABLES; 158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 159 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 160CREATE TABLE t2(c1 LONGBLOB NOT NULL); 161SHOW TABLES; 162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 163 SHOW CREATE TABLE t2; 164ALTER TABLE t2 MODIFY c1 LONGBLOB NULL; 165SHOW TABLES; 166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 167 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 168CREATE TABLE t2(c1 TINYTEXT NOT NULL); 169SHOW TABLES; 170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 171 SHOW CREATE TABLE t2; 172ALTER TABLE t2 MODIFY c1 TINYTEXT NULL; 173SHOW TABLES; 174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 175 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 176CREATE TABLE t2(c1 TEXT NOT NULL); 177SHOW TABLES; 178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 179 SHOW CREATE TABLE t2; 180ALTER TABLE t2 MODIFY c1 TEXT NULL; 181SHOW TABLES; 182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 183 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 184CREATE TABLE t2(c1 MEDIUMTEXT NOT NULL); 185SHOW TABLES; 186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 187 SHOW CREATE TABLE t2; 188ALTER TABLE t2 MODIFY c1 MEDIUMTEXT NULL; 189SHOW TABLES; 190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 191 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 192CREATE TABLE t2(c1 LONGTEXT NOT NULL); 193SHOW TABLES; 194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 195 SHOW CREATE TABLE t2; 196ALTER TABLE t2 MODIFY c1 LONGTEXT NULL; 197SHOW TABLES; 198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 199 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 200CREATE TABLE t2(c1 BIT NOT NULL); 201SHOW TABLES; 202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 203 SHOW CREATE TABLE t2; 204ALTER TABLE t2 CHANGE c1 c1 BIT NULL; 205SHOW TABLES; 206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 207 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 208CREATE TABLE t2(c1 TINYINT NOT NULL); 209SHOW TABLES; 210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 211 SHOW CREATE TABLE t2; 212ALTER TABLE t2 CHANGE c1 c1 TINYINT NULL; 213SHOW TABLES; 214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 215 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 216CREATE TABLE t2(c1 SMALLINT NOT NULL); 217SHOW TABLES; 218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 219 SHOW CREATE TABLE t2; 220ALTER TABLE t2 CHANGE c1 c1 SMALLINT NULL; 221SHOW TABLES; 222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 223 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 224CREATE TABLE t2(c1 MEDIUMINT NOT NULL); 225SHOW TABLES; 226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 227 SHOW CREATE TABLE t2; 228ALTER TABLE t2 CHANGE c1 c1 MEDIUMINT NULL; 229SHOW TABLES; 230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 231 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 232CREATE TABLE t2(c1 INT NOT NULL); 233SHOW TABLES; 234--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 235 SHOW CREATE TABLE t2; 236ALTER TABLE t2 CHANGE c1 c1 INT NULL; 237SHOW TABLES; 238--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 239 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 240CREATE TABLE t2(c1 INTEGER NOT NULL); 241SHOW TABLES; 242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 243 SHOW CREATE TABLE t2; 244ALTER TABLE t2 CHANGE c1 c1 INTEGER NULL; 245SHOW TABLES; 246--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 247 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 248CREATE TABLE t2(c1 BIGINT NOT NULL); 249SHOW TABLES; 250--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 251 SHOW CREATE TABLE t2; 252ALTER TABLE t2 CHANGE c1 c1 BIGINT NULL; 253SHOW TABLES; 254--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 255 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 256CREATE TABLE t2(c1 REAL NOT NULL); 257SHOW TABLES; 258--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 259 SHOW CREATE TABLE t2; 260ALTER TABLE t2 CHANGE c1 c1 REAL NULL; 261SHOW TABLES; 262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 263 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 264CREATE TABLE t2(c1 DOUBLE NOT NULL); 265SHOW TABLES; 266--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 267 SHOW CREATE TABLE t2; 268ALTER TABLE t2 CHANGE c1 c1 DOUBLE NULL; 269SHOW TABLES; 270--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 271 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 272CREATE TABLE t2(c1 FLOAT NOT NULL); 273SHOW TABLES; 274--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 275 SHOW CREATE TABLE t2; 276ALTER TABLE t2 CHANGE c1 c1 FLOAT NULL; 277SHOW TABLES; 278--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 279 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 280CREATE TABLE t2(c1 DECIMAL NOT NULL); 281SHOW TABLES; 282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 283 SHOW CREATE TABLE t2; 284ALTER TABLE t2 CHANGE c1 c1 DECIMAL NULL; 285SHOW TABLES; 286--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 287 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 288CREATE TABLE t2(c1 NUMERIC NOT NULL); 289SHOW TABLES; 290--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 291 SHOW CREATE TABLE t2; 292ALTER TABLE t2 CHANGE c1 c1 NUMERIC NULL; 293SHOW TABLES; 294--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 295 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 296CREATE TABLE t2(c1 DATE NOT NULL); 297SHOW TABLES; 298--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 299 SHOW CREATE TABLE t2; 300ALTER TABLE t2 CHANGE c1 c1 DATE NULL; 301SHOW TABLES; 302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 303 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 304CREATE TABLE t2(c1 TIME NOT NULL); 305SHOW TABLES; 306--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 307 SHOW CREATE TABLE t2; 308ALTER TABLE t2 CHANGE c1 c1 TIME NULL; 309SHOW TABLES; 310--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 311 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 312CREATE TABLE t2(c1 TIMESTAMP NOT NULL); 313SHOW TABLES; 314--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 315 SHOW CREATE TABLE t2; 316ALTER TABLE t2 CHANGE c1 c1 TIMESTAMP NULL; 317SHOW TABLES; 318--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 319 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 320CREATE TABLE t2(c1 YEAR NOT NULL); 321SHOW TABLES; 322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 323 SHOW CREATE TABLE t2; 324ALTER TABLE t2 CHANGE c1 c1 YEAR NULL; 325SHOW TABLES; 326--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 327 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 328CREATE TABLE t2(c1 TINYBLOB NOT NULL); 329SHOW TABLES; 330--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 331 SHOW CREATE TABLE t2; 332ALTER TABLE t2 CHANGE c1 c1 TINYBLOB NULL; 333SHOW TABLES; 334--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 335 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 336CREATE TABLE t2(c1 BLOB NOT NULL); 337SHOW TABLES; 338--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 339 SHOW CREATE TABLE t2; 340ALTER TABLE t2 CHANGE c1 c1 BLOB NULL; 341SHOW TABLES; 342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 343 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 344CREATE TABLE t2(c1 MEDIUMBLOB NOT NULL); 345SHOW TABLES; 346--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 347 SHOW CREATE TABLE t2; 348ALTER TABLE t2 CHANGE c1 c1 MEDIUMBLOB NULL; 349SHOW TABLES; 350--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 351 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 352CREATE TABLE t2(c1 LONGBLOB NOT NULL); 353SHOW TABLES; 354--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 355 SHOW CREATE TABLE t2; 356ALTER TABLE t2 CHANGE c1 c1 LONGBLOB NULL; 357SHOW TABLES; 358--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 359 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 360CREATE TABLE t2(c1 TINYTEXT NOT NULL); 361SHOW TABLES; 362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 363 SHOW CREATE TABLE t2; 364ALTER TABLE t2 CHANGE c1 c1 TINYTEXT NULL; 365SHOW TABLES; 366--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 367 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 368CREATE TABLE t2(c1 TEXT NOT NULL); 369SHOW TABLES; 370--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 371 SHOW CREATE TABLE t2; 372ALTER TABLE t2 CHANGE c1 c1 TEXT NULL; 373SHOW TABLES; 374--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 375 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 376CREATE TABLE t2(c1 MEDIUMTEXT NOT NULL); 377SHOW TABLES; 378--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 379 SHOW CREATE TABLE t2; 380ALTER TABLE t2 CHANGE c1 c1 MEDIUMTEXT NULL; 381SHOW TABLES; 382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 383 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 384CREATE TABLE t2(c1 LONGTEXT NOT NULL); 385SHOW TABLES; 386--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 387 SHOW CREATE TABLE t2; 388ALTER TABLE t2 CHANGE c1 c1 LONGTEXT NULL; 389SHOW TABLES; 390--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 391 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 392 393