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 TABLE t5(c1 BIT NULL); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11 SHOW CREATE TABLE t5; 12ALTER TABLE t5 ADD c2 CHAR(5) NULL; 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 16CREATE TABLE t5(c1 TINYINT NULL); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19 SHOW CREATE TABLE t5; 20ALTER TABLE t5 ADD c2 CHAR(5) NULL; 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 24CREATE TABLE t5(c1 SMALLINT NULL); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27 SHOW CREATE TABLE t5; 28ALTER TABLE t5 ADD c2 CHAR(5) NULL; 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 32CREATE TABLE t5(c1 MEDIUMINT NULL); 33SHOW TABLES; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35 SHOW CREATE TABLE t5; 36ALTER TABLE t5 ADD c2 CHAR(5) NULL; 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 40CREATE TABLE t5(c1 INT NULL); 41SHOW TABLES; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43 SHOW CREATE TABLE t5; 44ALTER TABLE t5 ADD c2 CHAR(5) NULL; 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 48CREATE TABLE t5(c1 INTEGER NULL); 49SHOW TABLES; 50--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 51 SHOW CREATE TABLE t5; 52ALTER TABLE t5 ADD c2 CHAR(5) NULL; 53SHOW TABLES; 54--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 55 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 56CREATE TABLE t5(c1 BIGINT NULL); 57SHOW TABLES; 58--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 59 SHOW CREATE TABLE t5; 60ALTER TABLE t5 ADD c2 CHAR(5) NULL; 61SHOW TABLES; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 64CREATE TABLE t5(c1 REAL NULL); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67 SHOW CREATE TABLE t5; 68ALTER TABLE t5 ADD c2 CHAR(5) NULL; 69SHOW TABLES; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 72CREATE TABLE t5(c1 DOUBLE NULL); 73SHOW TABLES; 74--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 75 SHOW CREATE TABLE t5; 76ALTER TABLE t5 ADD c2 CHAR(5) NULL; 77SHOW TABLES; 78--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 79 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 80CREATE TABLE t5(c1 FLOAT NULL); 81SHOW TABLES; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 83 SHOW CREATE TABLE t5; 84ALTER TABLE t5 ADD c2 CHAR(5) NULL; 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 88CREATE TABLE t5(c1 DECIMAL NULL); 89SHOW TABLES; 90--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 91 SHOW CREATE TABLE t5; 92ALTER TABLE t5 ADD c2 CHAR(5) NULL; 93SHOW TABLES; 94--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 95 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 96CREATE TABLE t5(c1 NUMERIC NULL); 97SHOW TABLES; 98--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 99 SHOW CREATE TABLE t5; 100ALTER TABLE t5 ADD c2 CHAR(5) NULL; 101SHOW TABLES; 102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 103 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 104CREATE TABLE t5(c1 DATE NULL); 105SHOW TABLES; 106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 107 SHOW CREATE TABLE t5; 108ALTER TABLE t5 ADD c2 CHAR(5) NULL; 109SHOW TABLES; 110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 111 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 112CREATE TABLE t5(c1 TIME NULL); 113SHOW TABLES; 114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 115 SHOW CREATE TABLE t5; 116ALTER TABLE t5 ADD c2 CHAR(5) NULL; 117SHOW TABLES; 118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 119 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 120CREATE TABLE t5(c1 TIMESTAMP NULL); 121SHOW TABLES; 122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 123 SHOW CREATE TABLE t5; 124ALTER TABLE t5 ADD c2 CHAR(5) NULL; 125SHOW TABLES; 126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 127 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 128CREATE TABLE t5(c1 YEAR NULL); 129SHOW TABLES; 130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 131 SHOW CREATE TABLE t5; 132ALTER TABLE t5 ADD c2 CHAR(5) NULL; 133SHOW TABLES; 134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 135 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 136CREATE TABLE t5(c1 TINYBLOB NULL); 137SHOW TABLES; 138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 139 SHOW CREATE TABLE t5; 140ALTER TABLE t5 ADD c2 CHAR(5) NULL; 141SHOW TABLES; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 143 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 144CREATE TABLE t5(c1 BLOB NULL); 145SHOW TABLES; 146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 147 SHOW CREATE TABLE t5; 148ALTER TABLE t5 ADD c2 CHAR(5) NULL; 149SHOW TABLES; 150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 151 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 152CREATE TABLE t5(c1 MEDIUMBLOB NULL); 153SHOW TABLES; 154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 155 SHOW CREATE TABLE t5; 156ALTER TABLE t5 ADD c2 CHAR(5) NULL; 157SHOW TABLES; 158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 159 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 160CREATE TABLE t5(c1 LONGBLOB NULL); 161SHOW TABLES; 162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 163 SHOW CREATE TABLE t5; 164ALTER TABLE t5 ADD c2 CHAR(5) NULL; 165SHOW TABLES; 166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 167 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 168CREATE TABLE t5(c1 TINYTEXT NULL); 169SHOW TABLES; 170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 171 SHOW CREATE TABLE t5; 172ALTER TABLE t5 ADD c2 CHAR(5) NULL; 173SHOW TABLES; 174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 175 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 176CREATE TABLE t5(c1 TEXT NULL); 177SHOW TABLES; 178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 179 SHOW CREATE TABLE t5; 180ALTER TABLE t5 ADD c2 CHAR(5) NULL; 181SHOW TABLES; 182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 183 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 184CREATE TABLE t5(c1 MEDIUMTEXT NULL); 185SHOW TABLES; 186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 187 SHOW CREATE TABLE t5; 188ALTER TABLE t5 ADD c2 CHAR(5) NULL; 189SHOW TABLES; 190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 191 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 192CREATE TABLE t5(c1 LONGTEXT NULL); 193SHOW TABLES; 194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 195 SHOW CREATE TABLE t5; 196ALTER TABLE t5 ADD c2 CHAR(5) NULL; 197SHOW TABLES; 198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 199 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 200CREATE TABLE t5(c1 BIT NOT NULL); 201SHOW TABLES; 202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 203 SHOW CREATE TABLE t5; 204ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 205SHOW TABLES; 206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 207 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 208CREATE TABLE t5(c1 TINYINT NOT NULL); 209SHOW TABLES; 210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 211 SHOW CREATE TABLE t5; 212ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 213SHOW TABLES; 214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 215 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 216CREATE TABLE t5(c1 SMALLINT NOT NULL); 217SHOW TABLES; 218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 219 SHOW CREATE TABLE t5; 220ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 221SHOW TABLES; 222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 223 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 224CREATE TABLE t5(c1 MEDIUMINT NOT NULL); 225SHOW TABLES; 226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 227 SHOW CREATE TABLE t5; 228ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 229SHOW TABLES; 230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 231 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 232CREATE TABLE t5(c1 INT NOT NULL); 233SHOW TABLES; 234--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 235 SHOW CREATE TABLE t5; 236ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 237SHOW TABLES; 238--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 239 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 240CREATE TABLE t5(c1 INTEGER NOT NULL); 241SHOW TABLES; 242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 243 SHOW CREATE TABLE t5; 244ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 245SHOW TABLES; 246--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 247 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 248CREATE TABLE t5(c1 BIGINT NOT NULL); 249SHOW TABLES; 250--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 251 SHOW CREATE TABLE t5; 252ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 253SHOW TABLES; 254--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 255 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 256CREATE TABLE t5(c1 REAL NOT NULL); 257SHOW TABLES; 258--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 259 SHOW CREATE TABLE t5; 260ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 261SHOW TABLES; 262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 263 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 264CREATE TABLE t5(c1 DOUBLE NOT NULL); 265SHOW TABLES; 266--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 267 SHOW CREATE TABLE t5; 268ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 269SHOW TABLES; 270--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 271 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 272CREATE TABLE t5(c1 FLOAT NOT NULL); 273SHOW TABLES; 274--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 275 SHOW CREATE TABLE t5; 276ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 277SHOW TABLES; 278--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 279 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 280CREATE TABLE t5(c1 DECIMAL NOT NULL); 281SHOW TABLES; 282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 283 SHOW CREATE TABLE t5; 284ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 285SHOW TABLES; 286--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 287 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 288CREATE TABLE t5(c1 NUMERIC NOT NULL); 289SHOW TABLES; 290--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 291 SHOW CREATE TABLE t5; 292ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 293SHOW TABLES; 294--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 295 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 296CREATE TABLE t5(c1 DATE NOT NULL); 297SHOW TABLES; 298--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 299 SHOW CREATE TABLE t5; 300ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 301SHOW TABLES; 302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 303 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 304CREATE TABLE t5(c1 TIME NOT NULL); 305SHOW TABLES; 306--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 307 SHOW CREATE TABLE t5; 308ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 309SHOW TABLES; 310--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 311 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 312CREATE TABLE t5(c1 TIMESTAMP NOT NULL); 313SHOW TABLES; 314--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 315 SHOW CREATE TABLE t5; 316ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 317SHOW TABLES; 318--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 319 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 320CREATE TABLE t5(c1 YEAR NOT NULL); 321SHOW TABLES; 322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 323 SHOW CREATE TABLE t5; 324ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 325SHOW TABLES; 326--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 327 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 328CREATE TABLE t5(c1 TINYBLOB NOT NULL); 329SHOW TABLES; 330--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 331 SHOW CREATE TABLE t5; 332ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 333SHOW TABLES; 334--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 335 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 336CREATE TABLE t5(c1 BLOB NOT NULL); 337SHOW TABLES; 338--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 339 SHOW CREATE TABLE t5; 340ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 341SHOW TABLES; 342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 343 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 344CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); 345SHOW TABLES; 346--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 347 SHOW CREATE TABLE t5; 348ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 349SHOW TABLES; 350--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 351 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 352CREATE TABLE t5(c1 LONGBLOB NOT NULL); 353SHOW TABLES; 354--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 355 SHOW CREATE TABLE t5; 356ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 357SHOW TABLES; 358--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 359 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 360CREATE TABLE t5(c1 TINYTEXT NOT NULL); 361SHOW TABLES; 362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 363 SHOW CREATE TABLE t5; 364ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 365SHOW TABLES; 366--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 367 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 368CREATE TABLE t5(c1 TEXT NOT NULL); 369SHOW TABLES; 370--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 371 SHOW CREATE TABLE t5; 372ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 373SHOW TABLES; 374--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 375 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 376CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); 377SHOW TABLES; 378--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 379 SHOW CREATE TABLE t5; 380ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 381SHOW TABLES; 382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 383 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 384CREATE TABLE t5(c1 LONGTEXT NOT NULL); 385SHOW TABLES; 386--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 387 SHOW CREATE TABLE t5; 388ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL; 389SHOW TABLES; 390--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 391 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 392CREATE TABLE t5(c1 BIT NULL); 393SHOW TABLES; 394--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 395 SHOW CREATE TABLE t5; 396ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 397SHOW TABLES; 398--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 399 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 400CREATE TABLE t5(c1 TINYINT NULL); 401SHOW TABLES; 402--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 403 SHOW CREATE TABLE t5; 404ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 405SHOW TABLES; 406--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 407 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 408CREATE TABLE t5(c1 SMALLINT NULL); 409SHOW TABLES; 410--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 411 SHOW CREATE TABLE t5; 412ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 413SHOW TABLES; 414--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 415 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 416CREATE TABLE t5(c1 MEDIUMINT NULL); 417SHOW TABLES; 418--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 419 SHOW CREATE TABLE t5; 420ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 421SHOW TABLES; 422--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 423 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 424CREATE TABLE t5(c1 INT NULL); 425SHOW TABLES; 426--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 427 SHOW CREATE TABLE t5; 428ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 429SHOW TABLES; 430--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 431 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 432CREATE TABLE t5(c1 INTEGER NULL); 433SHOW TABLES; 434--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 435 SHOW CREATE TABLE t5; 436ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 437SHOW TABLES; 438--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 439 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 440CREATE TABLE t5(c1 BIGINT NULL); 441SHOW TABLES; 442--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 443 SHOW CREATE TABLE t5; 444ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 445SHOW TABLES; 446--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 447 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 448CREATE TABLE t5(c1 REAL NULL); 449SHOW TABLES; 450--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 451 SHOW CREATE TABLE t5; 452ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 453SHOW TABLES; 454--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 455 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 456CREATE TABLE t5(c1 DOUBLE NULL); 457SHOW TABLES; 458--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 459 SHOW CREATE TABLE t5; 460ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 461SHOW TABLES; 462--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 463 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 464CREATE TABLE t5(c1 FLOAT NULL); 465SHOW TABLES; 466--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 467 SHOW CREATE TABLE t5; 468ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 469SHOW TABLES; 470--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 471 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 472CREATE TABLE t5(c1 DECIMAL NULL); 473SHOW TABLES; 474--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 475 SHOW CREATE TABLE t5; 476ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 477SHOW TABLES; 478--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 479 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 480CREATE TABLE t5(c1 NUMERIC NULL); 481SHOW TABLES; 482--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 483 SHOW CREATE TABLE t5; 484ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 485SHOW TABLES; 486--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 487 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 488CREATE TABLE t5(c1 DATE NULL); 489SHOW TABLES; 490--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 491 SHOW CREATE TABLE t5; 492ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 493SHOW TABLES; 494--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 495 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 496CREATE TABLE t5(c1 TIME NULL); 497SHOW TABLES; 498--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 499 SHOW CREATE TABLE t5; 500ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 501SHOW TABLES; 502--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 503 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 504CREATE TABLE t5(c1 TIMESTAMP NULL); 505SHOW TABLES; 506--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 507 SHOW CREATE TABLE t5; 508ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 509SHOW TABLES; 510--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 511 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 512CREATE TABLE t5(c1 YEAR NULL); 513SHOW TABLES; 514--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 515 SHOW CREATE TABLE t5; 516ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 517SHOW TABLES; 518--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 519 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 520CREATE TABLE t5(c1 TINYBLOB NULL); 521SHOW TABLES; 522--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 523 SHOW CREATE TABLE t5; 524ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 525SHOW TABLES; 526--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 527 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 528CREATE TABLE t5(c1 BLOB NULL); 529SHOW TABLES; 530--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 531 SHOW CREATE TABLE t5; 532ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 533SHOW TABLES; 534--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 535 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 536CREATE TABLE t5(c1 MEDIUMBLOB NULL); 537SHOW TABLES; 538--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 539 SHOW CREATE TABLE t5; 540ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 541SHOW TABLES; 542--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 543 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 544CREATE TABLE t5(c1 LONGBLOB NULL); 545SHOW TABLES; 546--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 547 SHOW CREATE TABLE t5; 548ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 549SHOW TABLES; 550--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 551 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 552CREATE TABLE t5(c1 TINYTEXT NULL); 553SHOW TABLES; 554--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 555 SHOW CREATE TABLE t5; 556ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 557SHOW TABLES; 558--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 559 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 560CREATE TABLE t5(c1 TEXT NULL); 561SHOW TABLES; 562--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 563 SHOW CREATE TABLE t5; 564ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 565SHOW TABLES; 566--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 567 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 568CREATE TABLE t5(c1 MEDIUMTEXT NULL); 569SHOW TABLES; 570--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 571 SHOW CREATE TABLE t5; 572ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 573SHOW TABLES; 574--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 575 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 576CREATE TABLE t5(c1 LONGTEXT NULL); 577SHOW TABLES; 578--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 579 SHOW CREATE TABLE t5; 580ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; 581SHOW TABLES; 582--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 583 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 584CREATE TABLE t5(c1 BIT NOT NULL); 585SHOW TABLES; 586--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 587 SHOW CREATE TABLE t5; 588ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 589SHOW TABLES; 590--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 591 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 592CREATE TABLE t5(c1 TINYINT NOT NULL); 593SHOW TABLES; 594--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 595 SHOW CREATE TABLE t5; 596ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 597SHOW TABLES; 598--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 599 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 600CREATE TABLE t5(c1 SMALLINT NOT NULL); 601SHOW TABLES; 602--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 603 SHOW CREATE TABLE t5; 604ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 605SHOW TABLES; 606--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 607 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 608CREATE TABLE t5(c1 MEDIUMINT NOT NULL); 609SHOW TABLES; 610--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 611 SHOW CREATE TABLE t5; 612ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 613SHOW TABLES; 614--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 615 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 616CREATE TABLE t5(c1 INT NOT NULL); 617SHOW TABLES; 618--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 619 SHOW CREATE TABLE t5; 620ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 621SHOW TABLES; 622--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 623 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 624CREATE TABLE t5(c1 INTEGER NOT NULL); 625SHOW TABLES; 626--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 627 SHOW CREATE TABLE t5; 628ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 629SHOW TABLES; 630--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 631 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 632CREATE TABLE t5(c1 BIGINT NOT NULL); 633SHOW TABLES; 634--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 635 SHOW CREATE TABLE t5; 636ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 637SHOW TABLES; 638--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 639 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 640CREATE TABLE t5(c1 REAL NOT NULL); 641SHOW TABLES; 642--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 643 SHOW CREATE TABLE t5; 644ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 645SHOW TABLES; 646--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 647 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 648CREATE TABLE t5(c1 DOUBLE NOT NULL); 649SHOW TABLES; 650--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 651 SHOW CREATE TABLE t5; 652ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 653SHOW TABLES; 654--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 655 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 656CREATE TABLE t5(c1 FLOAT NOT NULL); 657SHOW TABLES; 658--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 659 SHOW CREATE TABLE t5; 660ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 661SHOW TABLES; 662--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 663 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 664CREATE TABLE t5(c1 DECIMAL NOT NULL); 665SHOW TABLES; 666--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 667 SHOW CREATE TABLE t5; 668ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 669SHOW TABLES; 670--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 671 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 672CREATE TABLE t5(c1 NUMERIC NOT NULL); 673SHOW TABLES; 674--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 675 SHOW CREATE TABLE t5; 676ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 677SHOW TABLES; 678--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 679 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 680CREATE TABLE t5(c1 DATE NOT NULL); 681SHOW TABLES; 682--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 683 SHOW CREATE TABLE t5; 684ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 685SHOW TABLES; 686--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 687 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 688CREATE TABLE t5(c1 TIME NOT NULL); 689SHOW TABLES; 690--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 691 SHOW CREATE TABLE t5; 692ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 693SHOW TABLES; 694--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 695 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 696CREATE TABLE t5(c1 TIMESTAMP NOT NULL); 697SHOW TABLES; 698--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 699 SHOW CREATE TABLE t5; 700ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 701SHOW TABLES; 702--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 703 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 704CREATE TABLE t5(c1 YEAR NOT NULL); 705SHOW TABLES; 706--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 707 SHOW CREATE TABLE t5; 708ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 709SHOW TABLES; 710--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 711 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 712CREATE TABLE t5(c1 TINYBLOB NOT NULL); 713SHOW TABLES; 714--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 715 SHOW CREATE TABLE t5; 716ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 717SHOW TABLES; 718--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 719 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 720CREATE TABLE t5(c1 BLOB NOT NULL); 721SHOW TABLES; 722--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 723 SHOW CREATE TABLE t5; 724ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 725SHOW TABLES; 726--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 727 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 728CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); 729SHOW TABLES; 730--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 731 SHOW CREATE TABLE t5; 732ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 733SHOW TABLES; 734--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 735 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 736CREATE TABLE t5(c1 LONGBLOB NOT NULL); 737SHOW TABLES; 738--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 739 SHOW CREATE TABLE t5; 740ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 741SHOW TABLES; 742--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 743 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 744CREATE TABLE t5(c1 TINYTEXT NOT NULL); 745SHOW TABLES; 746--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 747 SHOW CREATE TABLE t5; 748ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 749SHOW TABLES; 750--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 751 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 752CREATE TABLE t5(c1 TEXT NOT NULL); 753SHOW TABLES; 754--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 755 SHOW CREATE TABLE t5; 756ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 757SHOW TABLES; 758--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 759 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 760CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); 761SHOW TABLES; 762--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 763 SHOW CREATE TABLE t5; 764ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 765SHOW TABLES; 766--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 767 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 768CREATE TABLE t5(c1 LONGTEXT NOT NULL); 769SHOW TABLES; 770--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 771 SHOW CREATE TABLE t5; 772ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL; 773SHOW TABLES; 774--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 775 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 776CREATE TABLE t5(c1 BIT NULL); 777SHOW TABLES; 778--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 779 SHOW CREATE TABLE t5; 780ALTER TABLE t5 ADD c2 BINARY(5) NULL; 781SHOW TABLES; 782--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 783 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 784CREATE TABLE t5(c1 TINYINT NULL); 785SHOW TABLES; 786--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 787 SHOW CREATE TABLE t5; 788ALTER TABLE t5 ADD c2 BINARY(5) NULL; 789SHOW TABLES; 790--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 791 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 792CREATE TABLE t5(c1 SMALLINT NULL); 793SHOW TABLES; 794--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 795 SHOW CREATE TABLE t5; 796ALTER TABLE t5 ADD c2 BINARY(5) NULL; 797SHOW TABLES; 798--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 799 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 800CREATE TABLE t5(c1 MEDIUMINT NULL); 801SHOW TABLES; 802--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 803 SHOW CREATE TABLE t5; 804ALTER TABLE t5 ADD c2 BINARY(5) NULL; 805SHOW TABLES; 806--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 807 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 808CREATE TABLE t5(c1 INT NULL); 809SHOW TABLES; 810--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 811 SHOW CREATE TABLE t5; 812ALTER TABLE t5 ADD c2 BINARY(5) NULL; 813SHOW TABLES; 814--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 815 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 816CREATE TABLE t5(c1 INTEGER NULL); 817SHOW TABLES; 818--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 819 SHOW CREATE TABLE t5; 820ALTER TABLE t5 ADD c2 BINARY(5) NULL; 821SHOW TABLES; 822--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 823 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 824CREATE TABLE t5(c1 BIGINT NULL); 825SHOW TABLES; 826--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 827 SHOW CREATE TABLE t5; 828ALTER TABLE t5 ADD c2 BINARY(5) NULL; 829SHOW TABLES; 830--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 831 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 832CREATE TABLE t5(c1 REAL NULL); 833SHOW TABLES; 834--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 835 SHOW CREATE TABLE t5; 836ALTER TABLE t5 ADD c2 BINARY(5) NULL; 837SHOW TABLES; 838--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 839 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 840CREATE TABLE t5(c1 DOUBLE NULL); 841SHOW TABLES; 842--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 843 SHOW CREATE TABLE t5; 844ALTER TABLE t5 ADD c2 BINARY(5) NULL; 845SHOW TABLES; 846--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 847 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 848CREATE TABLE t5(c1 FLOAT NULL); 849SHOW TABLES; 850--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 851 SHOW CREATE TABLE t5; 852ALTER TABLE t5 ADD c2 BINARY(5) NULL; 853SHOW TABLES; 854--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 855 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 856CREATE TABLE t5(c1 DECIMAL NULL); 857SHOW TABLES; 858--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 859 SHOW CREATE TABLE t5; 860ALTER TABLE t5 ADD c2 BINARY(5) NULL; 861SHOW TABLES; 862--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 863 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 864CREATE TABLE t5(c1 NUMERIC NULL); 865SHOW TABLES; 866--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 867 SHOW CREATE TABLE t5; 868ALTER TABLE t5 ADD c2 BINARY(5) NULL; 869SHOW TABLES; 870--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 871 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 872CREATE TABLE t5(c1 DATE NULL); 873SHOW TABLES; 874--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 875 SHOW CREATE TABLE t5; 876ALTER TABLE t5 ADD c2 BINARY(5) NULL; 877SHOW TABLES; 878--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 879 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 880CREATE TABLE t5(c1 TIME NULL); 881SHOW TABLES; 882--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 883 SHOW CREATE TABLE t5; 884ALTER TABLE t5 ADD c2 BINARY(5) NULL; 885SHOW TABLES; 886--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 887 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 888CREATE TABLE t5(c1 TIMESTAMP NULL); 889SHOW TABLES; 890--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 891 SHOW CREATE TABLE t5; 892ALTER TABLE t5 ADD c2 BINARY(5) NULL; 893SHOW TABLES; 894--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 895 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 896CREATE TABLE t5(c1 YEAR NULL); 897SHOW TABLES; 898--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 899 SHOW CREATE TABLE t5; 900ALTER TABLE t5 ADD c2 BINARY(5) NULL; 901SHOW TABLES; 902--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 903 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 904CREATE TABLE t5(c1 TINYBLOB NULL); 905SHOW TABLES; 906--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 907 SHOW CREATE TABLE t5; 908ALTER TABLE t5 ADD c2 BINARY(5) NULL; 909SHOW TABLES; 910--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 911 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 912CREATE TABLE t5(c1 BLOB NULL); 913SHOW TABLES; 914--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 915 SHOW CREATE TABLE t5; 916ALTER TABLE t5 ADD c2 BINARY(5) NULL; 917SHOW TABLES; 918--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 919 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 920CREATE TABLE t5(c1 MEDIUMBLOB NULL); 921SHOW TABLES; 922--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 923 SHOW CREATE TABLE t5; 924ALTER TABLE t5 ADD c2 BINARY(5) NULL; 925SHOW TABLES; 926--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 927 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 928CREATE TABLE t5(c1 LONGBLOB NULL); 929SHOW TABLES; 930--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 931 SHOW CREATE TABLE t5; 932ALTER TABLE t5 ADD c2 BINARY(5) NULL; 933SHOW TABLES; 934--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 935 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 936CREATE TABLE t5(c1 TINYTEXT NULL); 937SHOW TABLES; 938--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 939 SHOW CREATE TABLE t5; 940ALTER TABLE t5 ADD c2 BINARY(5) NULL; 941SHOW TABLES; 942--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 943 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 944CREATE TABLE t5(c1 TEXT NULL); 945SHOW TABLES; 946--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 947 SHOW CREATE TABLE t5; 948ALTER TABLE t5 ADD c2 BINARY(5) NULL; 949SHOW TABLES; 950--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 951 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 952CREATE TABLE t5(c1 MEDIUMTEXT NULL); 953SHOW TABLES; 954--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 955 SHOW CREATE TABLE t5; 956ALTER TABLE t5 ADD c2 BINARY(5) NULL; 957SHOW TABLES; 958--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 959 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 960CREATE TABLE t5(c1 LONGTEXT NULL); 961SHOW TABLES; 962--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 963 SHOW CREATE TABLE t5; 964ALTER TABLE t5 ADD c2 BINARY(5) NULL; 965SHOW TABLES; 966--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 967 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 968CREATE TABLE t5(c1 BIT NOT NULL); 969SHOW TABLES; 970--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 971 SHOW CREATE TABLE t5; 972ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 973SHOW TABLES; 974--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 975 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 976CREATE TABLE t5(c1 TINYINT NOT NULL); 977SHOW TABLES; 978--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 979 SHOW CREATE TABLE t5; 980ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 981SHOW TABLES; 982--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 983 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 984CREATE TABLE t5(c1 SMALLINT NOT NULL); 985SHOW TABLES; 986--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 987 SHOW CREATE TABLE t5; 988ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 989SHOW TABLES; 990--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 991 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 992CREATE TABLE t5(c1 MEDIUMINT NOT NULL); 993SHOW TABLES; 994--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 995 SHOW CREATE TABLE t5; 996ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 997SHOW TABLES; 998--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 999 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1000CREATE TABLE t5(c1 INT NOT NULL); 1001SHOW TABLES; 1002--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1003 SHOW CREATE TABLE t5; 1004ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1005SHOW TABLES; 1006--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1007 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1008CREATE TABLE t5(c1 INTEGER NOT NULL); 1009SHOW TABLES; 1010--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1011 SHOW CREATE TABLE t5; 1012ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1013SHOW TABLES; 1014--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1015 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1016CREATE TABLE t5(c1 BIGINT NOT NULL); 1017SHOW TABLES; 1018--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1019 SHOW CREATE TABLE t5; 1020ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1021SHOW TABLES; 1022--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1023 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1024CREATE TABLE t5(c1 REAL NOT NULL); 1025SHOW TABLES; 1026--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1027 SHOW CREATE TABLE t5; 1028ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1029SHOW TABLES; 1030--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1031 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1032CREATE TABLE t5(c1 DOUBLE NOT NULL); 1033SHOW TABLES; 1034--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1035 SHOW CREATE TABLE t5; 1036ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1037SHOW TABLES; 1038--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1039 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1040CREATE TABLE t5(c1 FLOAT NOT NULL); 1041SHOW TABLES; 1042--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1043 SHOW CREATE TABLE t5; 1044ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1045SHOW TABLES; 1046--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1047 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1048CREATE TABLE t5(c1 DECIMAL NOT NULL); 1049SHOW TABLES; 1050--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1051 SHOW CREATE TABLE t5; 1052ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1053SHOW TABLES; 1054--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1055 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1056CREATE TABLE t5(c1 NUMERIC NOT NULL); 1057SHOW TABLES; 1058--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1059 SHOW CREATE TABLE t5; 1060ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1061SHOW TABLES; 1062--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1063 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1064CREATE TABLE t5(c1 DATE NOT NULL); 1065SHOW TABLES; 1066--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1067 SHOW CREATE TABLE t5; 1068ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1069SHOW TABLES; 1070--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1071 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1072CREATE TABLE t5(c1 TIME NOT NULL); 1073SHOW TABLES; 1074--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1075 SHOW CREATE TABLE t5; 1076ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1077SHOW TABLES; 1078--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1079 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1080CREATE TABLE t5(c1 TIMESTAMP NOT NULL); 1081SHOW TABLES; 1082--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1083 SHOW CREATE TABLE t5; 1084ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1085SHOW TABLES; 1086--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1087 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1088CREATE TABLE t5(c1 YEAR NOT NULL); 1089SHOW TABLES; 1090--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1091 SHOW CREATE TABLE t5; 1092ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1093SHOW TABLES; 1094--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1095 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1096CREATE TABLE t5(c1 TINYBLOB NOT NULL); 1097SHOW TABLES; 1098--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1099 SHOW CREATE TABLE t5; 1100ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1101SHOW TABLES; 1102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1103 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1104CREATE TABLE t5(c1 BLOB NOT NULL); 1105SHOW TABLES; 1106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1107 SHOW CREATE TABLE t5; 1108ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1109SHOW TABLES; 1110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1111 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1112CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); 1113SHOW TABLES; 1114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1115 SHOW CREATE TABLE t5; 1116ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1117SHOW TABLES; 1118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1119 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1120CREATE TABLE t5(c1 LONGBLOB NOT NULL); 1121SHOW TABLES; 1122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1123 SHOW CREATE TABLE t5; 1124ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1125SHOW TABLES; 1126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1127 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1128CREATE TABLE t5(c1 TINYTEXT NOT NULL); 1129SHOW TABLES; 1130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1131 SHOW CREATE TABLE t5; 1132ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1133SHOW TABLES; 1134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1135 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1136CREATE TABLE t5(c1 TEXT NOT NULL); 1137SHOW TABLES; 1138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1139 SHOW CREATE TABLE t5; 1140ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1141SHOW TABLES; 1142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1143 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1144CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); 1145SHOW TABLES; 1146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1147 SHOW CREATE TABLE t5; 1148ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1149SHOW TABLES; 1150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1151 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1152CREATE TABLE t5(c1 LONGTEXT NOT NULL); 1153SHOW TABLES; 1154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1155 SHOW CREATE TABLE t5; 1156ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL; 1157SHOW TABLES; 1158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1159 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1160CREATE TABLE t5(c1 BIT NULL); 1161SHOW TABLES; 1162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1163 SHOW CREATE TABLE t5; 1164ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1165SHOW TABLES; 1166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1167 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1168CREATE TABLE t5(c1 TINYINT NULL); 1169SHOW TABLES; 1170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1171 SHOW CREATE TABLE t5; 1172ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1173SHOW TABLES; 1174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1175 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1176CREATE TABLE t5(c1 SMALLINT NULL); 1177SHOW TABLES; 1178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1179 SHOW CREATE TABLE t5; 1180ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1181SHOW TABLES; 1182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1183 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1184CREATE TABLE t5(c1 MEDIUMINT NULL); 1185SHOW TABLES; 1186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1187 SHOW CREATE TABLE t5; 1188ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1189SHOW TABLES; 1190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1191 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1192CREATE TABLE t5(c1 INT NULL); 1193SHOW TABLES; 1194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1195 SHOW CREATE TABLE t5; 1196ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1197SHOW TABLES; 1198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1199 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1200CREATE TABLE t5(c1 INTEGER NULL); 1201SHOW TABLES; 1202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1203 SHOW CREATE TABLE t5; 1204ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1205SHOW TABLES; 1206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1207 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1208CREATE TABLE t5(c1 BIGINT NULL); 1209SHOW TABLES; 1210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1211 SHOW CREATE TABLE t5; 1212ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1213SHOW TABLES; 1214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1215 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1216CREATE TABLE t5(c1 REAL NULL); 1217SHOW TABLES; 1218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1219 SHOW CREATE TABLE t5; 1220ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1221SHOW TABLES; 1222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1223 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1224CREATE TABLE t5(c1 DOUBLE NULL); 1225SHOW TABLES; 1226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1227 SHOW CREATE TABLE t5; 1228ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1229SHOW TABLES; 1230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1231 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1232CREATE TABLE t5(c1 FLOAT NULL); 1233SHOW TABLES; 1234--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1235 SHOW CREATE TABLE t5; 1236ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1237SHOW TABLES; 1238--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1239 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1240CREATE TABLE t5(c1 DECIMAL NULL); 1241SHOW TABLES; 1242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1243 SHOW CREATE TABLE t5; 1244ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1245SHOW TABLES; 1246--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1247 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1248CREATE TABLE t5(c1 NUMERIC NULL); 1249SHOW TABLES; 1250--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1251 SHOW CREATE TABLE t5; 1252ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1253SHOW TABLES; 1254--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1255 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1256CREATE TABLE t5(c1 DATE NULL); 1257SHOW TABLES; 1258--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1259 SHOW CREATE TABLE t5; 1260ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1261SHOW TABLES; 1262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1263 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1264CREATE TABLE t5(c1 TIME NULL); 1265SHOW TABLES; 1266--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1267 SHOW CREATE TABLE t5; 1268ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1269SHOW TABLES; 1270--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1271 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1272CREATE TABLE t5(c1 TIMESTAMP NULL); 1273SHOW TABLES; 1274--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1275 SHOW CREATE TABLE t5; 1276ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1277SHOW TABLES; 1278--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1279 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1280CREATE TABLE t5(c1 YEAR NULL); 1281SHOW TABLES; 1282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1283 SHOW CREATE TABLE t5; 1284ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1285SHOW TABLES; 1286--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1287 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1288CREATE TABLE t5(c1 TINYBLOB NULL); 1289SHOW TABLES; 1290--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1291 SHOW CREATE TABLE t5; 1292ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1293SHOW TABLES; 1294--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1295 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1296CREATE TABLE t5(c1 BLOB NULL); 1297SHOW TABLES; 1298--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1299 SHOW CREATE TABLE t5; 1300ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1301SHOW TABLES; 1302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1303 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1304CREATE TABLE t5(c1 MEDIUMBLOB NULL); 1305SHOW TABLES; 1306--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1307 SHOW CREATE TABLE t5; 1308ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1309SHOW TABLES; 1310--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1311 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1312CREATE TABLE t5(c1 LONGBLOB NULL); 1313SHOW TABLES; 1314--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1315 SHOW CREATE TABLE t5; 1316ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1317SHOW TABLES; 1318--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1319 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1320CREATE TABLE t5(c1 TINYTEXT NULL); 1321SHOW TABLES; 1322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1323 SHOW CREATE TABLE t5; 1324ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1325SHOW TABLES; 1326--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1327 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1328CREATE TABLE t5(c1 TEXT NULL); 1329SHOW TABLES; 1330--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1331 SHOW CREATE TABLE t5; 1332ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1333SHOW TABLES; 1334--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1335 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1336CREATE TABLE t5(c1 MEDIUMTEXT NULL); 1337SHOW TABLES; 1338--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1339 SHOW CREATE TABLE t5; 1340ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1341SHOW TABLES; 1342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1343 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1344CREATE TABLE t5(c1 LONGTEXT NULL); 1345SHOW TABLES; 1346--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1347 SHOW CREATE TABLE t5; 1348ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; 1349SHOW TABLES; 1350--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1351 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1352CREATE TABLE t5(c1 BIT NOT NULL); 1353SHOW TABLES; 1354--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1355 SHOW CREATE TABLE t5; 1356ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1357SHOW TABLES; 1358--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1359 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1360CREATE TABLE t5(c1 TINYINT NOT NULL); 1361SHOW TABLES; 1362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1363 SHOW CREATE TABLE t5; 1364ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1365SHOW TABLES; 1366--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1367 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1368CREATE TABLE t5(c1 SMALLINT NOT NULL); 1369SHOW TABLES; 1370--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1371 SHOW CREATE TABLE t5; 1372ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1373SHOW TABLES; 1374--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1375 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1376CREATE TABLE t5(c1 MEDIUMINT NOT NULL); 1377SHOW TABLES; 1378--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1379 SHOW CREATE TABLE t5; 1380ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1381SHOW TABLES; 1382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1383 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1384CREATE TABLE t5(c1 INT NOT NULL); 1385SHOW TABLES; 1386--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1387 SHOW CREATE TABLE t5; 1388ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1389SHOW TABLES; 1390--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1391 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1392CREATE TABLE t5(c1 INTEGER NOT NULL); 1393SHOW TABLES; 1394--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1395 SHOW CREATE TABLE t5; 1396ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1397SHOW TABLES; 1398--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1399 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1400CREATE TABLE t5(c1 BIGINT NOT NULL); 1401SHOW TABLES; 1402--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1403 SHOW CREATE TABLE t5; 1404ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1405SHOW TABLES; 1406--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1407 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1408CREATE TABLE t5(c1 REAL NOT NULL); 1409SHOW TABLES; 1410--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1411 SHOW CREATE TABLE t5; 1412ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1413SHOW TABLES; 1414--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1415 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1416CREATE TABLE t5(c1 DOUBLE NOT NULL); 1417SHOW TABLES; 1418--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1419 SHOW CREATE TABLE t5; 1420ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1421SHOW TABLES; 1422--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1423 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1424CREATE TABLE t5(c1 FLOAT NOT NULL); 1425SHOW TABLES; 1426--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1427 SHOW CREATE TABLE t5; 1428ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1429SHOW TABLES; 1430--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1431 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1432CREATE TABLE t5(c1 DECIMAL NOT NULL); 1433SHOW TABLES; 1434--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1435 SHOW CREATE TABLE t5; 1436ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1437SHOW TABLES; 1438--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1439 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1440CREATE TABLE t5(c1 NUMERIC NOT NULL); 1441SHOW TABLES; 1442--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1443 SHOW CREATE TABLE t5; 1444ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1445SHOW TABLES; 1446--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1447 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1448CREATE TABLE t5(c1 DATE NOT NULL); 1449SHOW TABLES; 1450--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1451 SHOW CREATE TABLE t5; 1452ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1453SHOW TABLES; 1454--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1455 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1456CREATE TABLE t5(c1 TIME NOT NULL); 1457SHOW TABLES; 1458--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1459 SHOW CREATE TABLE t5; 1460ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1461SHOW TABLES; 1462--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1463 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1464CREATE TABLE t5(c1 TIMESTAMP NOT NULL); 1465SHOW TABLES; 1466--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1467 SHOW CREATE TABLE t5; 1468ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1469SHOW TABLES; 1470--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1471 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1472CREATE TABLE t5(c1 YEAR NOT NULL); 1473SHOW TABLES; 1474--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1475 SHOW CREATE TABLE t5; 1476ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1477SHOW TABLES; 1478--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1479 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1480CREATE TABLE t5(c1 TINYBLOB NOT NULL); 1481SHOW TABLES; 1482--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1483 SHOW CREATE TABLE t5; 1484ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1485SHOW TABLES; 1486--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1487 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1488CREATE TABLE t5(c1 BLOB NOT NULL); 1489SHOW TABLES; 1490--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1491 SHOW CREATE TABLE t5; 1492ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1493SHOW TABLES; 1494--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1495 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1496CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); 1497SHOW TABLES; 1498--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1499 SHOW CREATE TABLE t5; 1500ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1501SHOW TABLES; 1502--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1503 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1504CREATE TABLE t5(c1 LONGBLOB NOT NULL); 1505SHOW TABLES; 1506--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1507 SHOW CREATE TABLE t5; 1508ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1509SHOW TABLES; 1510--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1511 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1512CREATE TABLE t5(c1 TINYTEXT NOT NULL); 1513SHOW TABLES; 1514--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1515 SHOW CREATE TABLE t5; 1516ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1517SHOW TABLES; 1518--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1519 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1520CREATE TABLE t5(c1 TEXT NOT NULL); 1521SHOW TABLES; 1522--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1523 SHOW CREATE TABLE t5; 1524ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1525SHOW TABLES; 1526--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1527 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1528CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); 1529SHOW TABLES; 1530--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1531 SHOW CREATE TABLE t5; 1532ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1533SHOW TABLES; 1534--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1535 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1536CREATE TABLE t5(c1 LONGTEXT NOT NULL); 1537SHOW TABLES; 1538--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1539 SHOW CREATE TABLE t5; 1540ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL; 1541SHOW TABLES; 1542--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1543 SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES; 1544 1545