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 TABLE t1(c1 BIT NOT NULL); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11 SHOW CREATE TABLE t1; 12ALTER TABLE t1 ADD UNIQUE (c1); 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 16CREATE TABLE t1(c1 TINYINT NOT NULL); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19 SHOW CREATE TABLE t1; 20ALTER TABLE t1 ADD UNIQUE (c1); 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 24CREATE TABLE t1(c1 SMALLINT NOT NULL); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27 SHOW CREATE TABLE t1; 28ALTER TABLE t1 ADD UNIQUE (c1); 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 32CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 33SHOW TABLES; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35 SHOW CREATE TABLE t1; 36ALTER TABLE t1 ADD UNIQUE (c1); 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 40CREATE TABLE t1(c1 INT NOT NULL); 41SHOW TABLES; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43 SHOW CREATE TABLE t1; 44ALTER TABLE t1 ADD UNIQUE (c1); 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 48CREATE TABLE t1(c1 INTEGER NOT NULL); 49SHOW TABLES; 50--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 51 SHOW CREATE TABLE t1; 52ALTER TABLE t1 ADD UNIQUE (c1); 53SHOW TABLES; 54--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 55 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 56CREATE TABLE t1(c1 BIGINT NOT NULL); 57SHOW TABLES; 58--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 59 SHOW CREATE TABLE t1; 60ALTER TABLE t1 ADD UNIQUE (c1); 61SHOW TABLES; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 64CREATE TABLE t1(c1 REAL NOT NULL); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67 SHOW CREATE TABLE t1; 68ALTER TABLE t1 ADD UNIQUE (c1); 69SHOW TABLES; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 72CREATE TABLE t1(c1 DOUBLE NOT NULL); 73SHOW TABLES; 74--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 75 SHOW CREATE TABLE t1; 76ALTER TABLE t1 ADD UNIQUE (c1); 77SHOW TABLES; 78--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 79 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 80CREATE TABLE t1(c1 FLOAT NOT NULL); 81SHOW TABLES; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 83 SHOW CREATE TABLE t1; 84ALTER TABLE t1 ADD UNIQUE (c1); 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 88CREATE TABLE t1(c1 DECIMAL NOT NULL); 89SHOW TABLES; 90--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 91 SHOW CREATE TABLE t1; 92ALTER TABLE t1 ADD UNIQUE (c1); 93SHOW TABLES; 94--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 95 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 96CREATE TABLE t1(c1 NUMERIC NOT NULL); 97SHOW TABLES; 98--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 99 SHOW CREATE TABLE t1; 100ALTER TABLE t1 ADD UNIQUE (c1); 101SHOW TABLES; 102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 103 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 104CREATE TABLE t1(c1 DATE NOT NULL); 105SHOW TABLES; 106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 107 SHOW CREATE TABLE t1; 108ALTER TABLE t1 ADD UNIQUE (c1); 109SHOW TABLES; 110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 111 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 112CREATE TABLE t1(c1 TIME NOT NULL); 113SHOW TABLES; 114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 115 SHOW CREATE TABLE t1; 116ALTER TABLE t1 ADD UNIQUE (c1); 117SHOW TABLES; 118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 119 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 120CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 121SHOW TABLES; 122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 123 SHOW CREATE TABLE t1; 124ALTER TABLE t1 ADD UNIQUE (c1); 125SHOW TABLES; 126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 127 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 128CREATE TABLE t1(c1 YEAR NOT NULL); 129SHOW TABLES; 130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 131 SHOW CREATE TABLE t1; 132ALTER TABLE t1 ADD UNIQUE (c1); 133SHOW TABLES; 134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 135 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 136CREATE TABLE t1(c1 BIT NOT NULL); 137SHOW TABLES; 138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 139 SHOW CREATE TABLE t1; 140ALTER TABLE t1 ADD UNIQUE KEY (c1); 141SHOW TABLES; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 144CREATE TABLE t1(c1 TINYINT NOT NULL); 145SHOW TABLES; 146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 147 SHOW CREATE TABLE t1; 148ALTER TABLE t1 ADD UNIQUE KEY (c1); 149SHOW TABLES; 150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 151 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 152CREATE TABLE t1(c1 SMALLINT NOT NULL); 153SHOW TABLES; 154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 155 SHOW CREATE TABLE t1; 156ALTER TABLE t1 ADD UNIQUE KEY (c1); 157SHOW TABLES; 158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 159 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 160CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 161SHOW TABLES; 162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 163 SHOW CREATE TABLE t1; 164ALTER TABLE t1 ADD UNIQUE KEY (c1); 165SHOW TABLES; 166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 167 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 168CREATE TABLE t1(c1 INT NOT NULL); 169SHOW TABLES; 170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 171 SHOW CREATE TABLE t1; 172ALTER TABLE t1 ADD UNIQUE KEY (c1); 173SHOW TABLES; 174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 175 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 176CREATE TABLE t1(c1 INTEGER NOT NULL); 177SHOW TABLES; 178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 179 SHOW CREATE TABLE t1; 180ALTER TABLE t1 ADD UNIQUE KEY (c1); 181SHOW TABLES; 182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 183 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 184CREATE TABLE t1(c1 BIGINT NOT NULL); 185SHOW TABLES; 186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 187 SHOW CREATE TABLE t1; 188ALTER TABLE t1 ADD UNIQUE KEY (c1); 189SHOW TABLES; 190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 191 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 192CREATE TABLE t1(c1 REAL NOT NULL); 193SHOW TABLES; 194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 195 SHOW CREATE TABLE t1; 196ALTER TABLE t1 ADD UNIQUE KEY (c1); 197SHOW TABLES; 198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 199 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 200CREATE TABLE t1(c1 DOUBLE NOT NULL); 201SHOW TABLES; 202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 203 SHOW CREATE TABLE t1; 204ALTER TABLE t1 ADD UNIQUE KEY (c1); 205SHOW TABLES; 206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 207 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 208CREATE TABLE t1(c1 FLOAT NOT NULL); 209SHOW TABLES; 210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 211 SHOW CREATE TABLE t1; 212ALTER TABLE t1 ADD UNIQUE KEY (c1); 213SHOW TABLES; 214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 215 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 216CREATE TABLE t1(c1 DECIMAL NOT NULL); 217SHOW TABLES; 218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 219 SHOW CREATE TABLE t1; 220ALTER TABLE t1 ADD UNIQUE KEY (c1); 221SHOW TABLES; 222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 223 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 224CREATE TABLE t1(c1 NUMERIC NOT NULL); 225SHOW TABLES; 226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 227 SHOW CREATE TABLE t1; 228ALTER TABLE t1 ADD UNIQUE KEY (c1); 229SHOW TABLES; 230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 231 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 232CREATE TABLE t1(c1 DATE NOT NULL); 233SHOW TABLES; 234--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 235 SHOW CREATE TABLE t1; 236ALTER TABLE t1 ADD UNIQUE KEY (c1); 237SHOW TABLES; 238--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 239 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 240CREATE TABLE t1(c1 TIME NOT NULL); 241SHOW TABLES; 242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 243 SHOW CREATE TABLE t1; 244ALTER TABLE t1 ADD UNIQUE KEY (c1); 245SHOW TABLES; 246--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 247 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 248CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 249SHOW TABLES; 250--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 251 SHOW CREATE TABLE t1; 252ALTER TABLE t1 ADD UNIQUE KEY (c1); 253SHOW TABLES; 254--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 255 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 256CREATE TABLE t1(c1 YEAR NOT NULL); 257SHOW TABLES; 258--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 259 SHOW CREATE TABLE t1; 260ALTER TABLE t1 ADD UNIQUE KEY (c1); 261SHOW TABLES; 262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 263 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 264CREATE TABLE t1(c1 BIT NOT NULL); 265SHOW TABLES; 266--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 267 SHOW CREATE TABLE t1; 268ALTER TABLE t1 ADD UNIQUE INDEX (c1); 269SHOW TABLES; 270--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 271 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 272CREATE TABLE t1(c1 TINYINT NOT NULL); 273SHOW TABLES; 274--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 275 SHOW CREATE TABLE t1; 276ALTER TABLE t1 ADD UNIQUE INDEX (c1); 277SHOW TABLES; 278--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 279 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 280CREATE TABLE t1(c1 SMALLINT NOT NULL); 281SHOW TABLES; 282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 283 SHOW CREATE TABLE t1; 284ALTER TABLE t1 ADD UNIQUE INDEX (c1); 285SHOW TABLES; 286--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 287 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 288CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 289SHOW TABLES; 290--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 291 SHOW CREATE TABLE t1; 292ALTER TABLE t1 ADD UNIQUE INDEX (c1); 293SHOW TABLES; 294--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 295 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 296CREATE TABLE t1(c1 INT NOT NULL); 297SHOW TABLES; 298--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 299 SHOW CREATE TABLE t1; 300ALTER TABLE t1 ADD UNIQUE INDEX (c1); 301SHOW TABLES; 302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 303 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 304CREATE TABLE t1(c1 INTEGER NOT NULL); 305SHOW TABLES; 306--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 307 SHOW CREATE TABLE t1; 308ALTER TABLE t1 ADD UNIQUE INDEX (c1); 309SHOW TABLES; 310--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 311 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 312CREATE TABLE t1(c1 BIGINT NOT NULL); 313SHOW TABLES; 314--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 315 SHOW CREATE TABLE t1; 316ALTER TABLE t1 ADD UNIQUE INDEX (c1); 317SHOW TABLES; 318--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 319 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 320CREATE TABLE t1(c1 REAL NOT NULL); 321SHOW TABLES; 322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 323 SHOW CREATE TABLE t1; 324ALTER TABLE t1 ADD UNIQUE INDEX (c1); 325SHOW TABLES; 326--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 327 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 328CREATE TABLE t1(c1 DOUBLE NOT NULL); 329SHOW TABLES; 330--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 331 SHOW CREATE TABLE t1; 332ALTER TABLE t1 ADD UNIQUE INDEX (c1); 333SHOW TABLES; 334--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 335 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 336CREATE TABLE t1(c1 FLOAT NOT NULL); 337SHOW TABLES; 338--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 339 SHOW CREATE TABLE t1; 340ALTER TABLE t1 ADD UNIQUE INDEX (c1); 341SHOW TABLES; 342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 343 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 344CREATE TABLE t1(c1 DECIMAL NOT NULL); 345SHOW TABLES; 346--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 347 SHOW CREATE TABLE t1; 348ALTER TABLE t1 ADD UNIQUE INDEX (c1); 349SHOW TABLES; 350--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 351 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 352CREATE TABLE t1(c1 NUMERIC NOT NULL); 353SHOW TABLES; 354--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 355 SHOW CREATE TABLE t1; 356ALTER TABLE t1 ADD UNIQUE INDEX (c1); 357SHOW TABLES; 358--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 359 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 360CREATE TABLE t1(c1 DATE NOT NULL); 361SHOW TABLES; 362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 363 SHOW CREATE TABLE t1; 364ALTER TABLE t1 ADD UNIQUE INDEX (c1); 365SHOW TABLES; 366--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 367 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 368CREATE TABLE t1(c1 TIME NOT NULL); 369SHOW TABLES; 370--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 371 SHOW CREATE TABLE t1; 372ALTER TABLE t1 ADD UNIQUE INDEX (c1); 373SHOW TABLES; 374--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 375 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 376CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 377SHOW TABLES; 378--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 379 SHOW CREATE TABLE t1; 380ALTER TABLE t1 ADD UNIQUE INDEX (c1); 381SHOW TABLES; 382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 383 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 384CREATE TABLE t1(c1 YEAR NOT NULL); 385SHOW TABLES; 386--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 387 SHOW CREATE TABLE t1; 388ALTER TABLE t1 ADD UNIQUE INDEX (c1); 389SHOW TABLES; 390--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 391 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 392CREATE TABLE t1(c1 BIT NOT NULL); 393SHOW TABLES; 394--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 395 SHOW CREATE TABLE t1; 396ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 397SHOW TABLES; 398--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 399 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 400CREATE TABLE t1(c1 TINYINT NOT NULL); 401SHOW TABLES; 402--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 403 SHOW CREATE TABLE t1; 404ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 405SHOW TABLES; 406--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 407 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 408CREATE TABLE t1(c1 SMALLINT NOT NULL); 409SHOW TABLES; 410--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 411 SHOW CREATE TABLE t1; 412ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 413SHOW TABLES; 414--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 415 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 416CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 417SHOW TABLES; 418--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 419 SHOW CREATE TABLE t1; 420ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 421SHOW TABLES; 422--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 423 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 424CREATE TABLE t1(c1 INT NOT NULL); 425SHOW TABLES; 426--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 427 SHOW CREATE TABLE t1; 428ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 429SHOW TABLES; 430--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 431 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 432CREATE TABLE t1(c1 INTEGER NOT NULL); 433SHOW TABLES; 434--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 435 SHOW CREATE TABLE t1; 436ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 437SHOW TABLES; 438--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 439 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 440CREATE TABLE t1(c1 BIGINT NOT NULL); 441SHOW TABLES; 442--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 443 SHOW CREATE TABLE t1; 444ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 445SHOW TABLES; 446--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 447 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 448CREATE TABLE t1(c1 REAL NOT NULL); 449SHOW TABLES; 450--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 451 SHOW CREATE TABLE t1; 452ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 453SHOW TABLES; 454--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 455 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 456CREATE TABLE t1(c1 DOUBLE NOT NULL); 457SHOW TABLES; 458--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 459 SHOW CREATE TABLE t1; 460ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 461SHOW TABLES; 462--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 463 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 464CREATE TABLE t1(c1 FLOAT NOT NULL); 465SHOW TABLES; 466--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 467 SHOW CREATE TABLE t1; 468ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 469SHOW TABLES; 470--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 471 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 472CREATE TABLE t1(c1 DECIMAL NOT NULL); 473SHOW TABLES; 474--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 475 SHOW CREATE TABLE t1; 476ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 477SHOW TABLES; 478--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 479 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 480CREATE TABLE t1(c1 NUMERIC NOT NULL); 481SHOW TABLES; 482--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 483 SHOW CREATE TABLE t1; 484ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 485SHOW TABLES; 486--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 487 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 488CREATE TABLE t1(c1 DATE NOT NULL); 489SHOW TABLES; 490--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 491 SHOW CREATE TABLE t1; 492ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 493SHOW TABLES; 494--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 495 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 496CREATE TABLE t1(c1 TIME NOT NULL); 497SHOW TABLES; 498--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 499 SHOW CREATE TABLE t1; 500ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 501SHOW TABLES; 502--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 503 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 504CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 505SHOW TABLES; 506--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 507 SHOW CREATE TABLE t1; 508ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 509SHOW TABLES; 510--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 511 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 512CREATE TABLE t1(c1 YEAR NOT NULL); 513SHOW TABLES; 514--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 515 SHOW CREATE TABLE t1; 516ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 517SHOW TABLES; 518--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 519 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 520CREATE TABLE t1(c1 BIT NOT NULL); 521SHOW TABLES; 522--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 523 SHOW CREATE TABLE t1; 524ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 525SHOW TABLES; 526--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 527 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 528CREATE TABLE t1(c1 TINYINT NOT NULL); 529SHOW TABLES; 530--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 531 SHOW CREATE TABLE t1; 532ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 533SHOW TABLES; 534--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 535 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 536CREATE TABLE t1(c1 SMALLINT NOT NULL); 537SHOW TABLES; 538--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 539 SHOW CREATE TABLE t1; 540ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 541SHOW TABLES; 542--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 543 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 544CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 545SHOW TABLES; 546--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 547 SHOW CREATE TABLE t1; 548ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 549SHOW TABLES; 550--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 551 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 552CREATE TABLE t1(c1 INT NOT NULL); 553SHOW TABLES; 554--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 555 SHOW CREATE TABLE t1; 556ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 557SHOW TABLES; 558--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 559 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 560CREATE TABLE t1(c1 INTEGER NOT NULL); 561SHOW TABLES; 562--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 563 SHOW CREATE TABLE t1; 564ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 565SHOW TABLES; 566--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 567 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 568CREATE TABLE t1(c1 BIGINT NOT NULL); 569SHOW TABLES; 570--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 571 SHOW CREATE TABLE t1; 572ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 573SHOW TABLES; 574--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 575 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 576CREATE TABLE t1(c1 REAL NOT NULL); 577SHOW TABLES; 578--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 579 SHOW CREATE TABLE t1; 580ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 581SHOW TABLES; 582--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 583 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 584CREATE TABLE t1(c1 DOUBLE NOT NULL); 585SHOW TABLES; 586--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 587 SHOW CREATE TABLE t1; 588ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 589SHOW TABLES; 590--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 591 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 592CREATE TABLE t1(c1 FLOAT NOT NULL); 593SHOW TABLES; 594--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 595 SHOW CREATE TABLE t1; 596ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 597SHOW TABLES; 598--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 599 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 600CREATE TABLE t1(c1 DECIMAL NOT NULL); 601SHOW TABLES; 602--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 603 SHOW CREATE TABLE t1; 604ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 605SHOW TABLES; 606--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 607 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 608CREATE TABLE t1(c1 NUMERIC NOT NULL); 609SHOW TABLES; 610--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 611 SHOW CREATE TABLE t1; 612ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 613SHOW TABLES; 614--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 615 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 616CREATE TABLE t1(c1 DATE NOT NULL); 617SHOW TABLES; 618--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 619 SHOW CREATE TABLE t1; 620ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 621SHOW TABLES; 622--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 623 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 624CREATE TABLE t1(c1 TIME NOT NULL); 625SHOW TABLES; 626--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 627 SHOW CREATE TABLE t1; 628ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 629SHOW TABLES; 630--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 631 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 632CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 633SHOW TABLES; 634--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 635 SHOW CREATE TABLE t1; 636ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 637SHOW TABLES; 638--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 639 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 640CREATE TABLE t1(c1 YEAR NOT NULL); 641SHOW TABLES; 642--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 643 SHOW CREATE TABLE t1; 644ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 645SHOW TABLES; 646--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 647 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 648CREATE TABLE t1(c1 BIT NOT NULL); 649SHOW TABLES; 650--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 651 SHOW CREATE TABLE t1; 652ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 653SHOW TABLES; 654--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 655 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 656CREATE TABLE t1(c1 TINYINT NOT NULL); 657SHOW TABLES; 658--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 659 SHOW CREATE TABLE t1; 660ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 661SHOW TABLES; 662--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 663 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 664CREATE TABLE t1(c1 SMALLINT NOT NULL); 665SHOW TABLES; 666--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 667 SHOW CREATE TABLE t1; 668ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 669SHOW TABLES; 670--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 671 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 672CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 673SHOW TABLES; 674--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 675 SHOW CREATE TABLE t1; 676ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 677SHOW TABLES; 678--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 679 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 680CREATE TABLE t1(c1 INT NOT NULL); 681SHOW TABLES; 682--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 683 SHOW CREATE TABLE t1; 684ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 685SHOW TABLES; 686--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 687 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 688CREATE TABLE t1(c1 INTEGER NOT NULL); 689SHOW TABLES; 690--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 691 SHOW CREATE TABLE t1; 692ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 693SHOW TABLES; 694--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 695 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 696CREATE TABLE t1(c1 BIGINT NOT NULL); 697SHOW TABLES; 698--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 699 SHOW CREATE TABLE t1; 700ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 701SHOW TABLES; 702--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 703 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 704CREATE TABLE t1(c1 REAL NOT NULL); 705SHOW TABLES; 706--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 707 SHOW CREATE TABLE t1; 708ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 709SHOW TABLES; 710--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 711 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 712CREATE TABLE t1(c1 DOUBLE NOT NULL); 713SHOW TABLES; 714--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 715 SHOW CREATE TABLE t1; 716ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 717SHOW TABLES; 718--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 719 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 720CREATE TABLE t1(c1 FLOAT NOT NULL); 721SHOW TABLES; 722--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 723 SHOW CREATE TABLE t1; 724ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 725SHOW TABLES; 726--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 727 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 728CREATE TABLE t1(c1 DECIMAL NOT NULL); 729SHOW TABLES; 730--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 731 SHOW CREATE TABLE t1; 732ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 733SHOW TABLES; 734--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 735 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 736CREATE TABLE t1(c1 NUMERIC NOT NULL); 737SHOW TABLES; 738--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 739 SHOW CREATE TABLE t1; 740ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 741SHOW TABLES; 742--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 743 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 744CREATE TABLE t1(c1 DATE NOT NULL); 745SHOW TABLES; 746--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 747 SHOW CREATE TABLE t1; 748ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 749SHOW TABLES; 750--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 751 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 752CREATE TABLE t1(c1 TIME NOT NULL); 753SHOW TABLES; 754--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 755 SHOW CREATE TABLE t1; 756ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 757SHOW TABLES; 758--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 759 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 760CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 761SHOW TABLES; 762--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 763 SHOW CREATE TABLE t1; 764ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 765SHOW TABLES; 766--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 767 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 768CREATE TABLE t1(c1 YEAR NOT NULL); 769SHOW TABLES; 770--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 771 SHOW CREATE TABLE t1; 772ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 773SHOW TABLES; 774--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 775 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 776CREATE TABLE t1(c1 BIT NOT NULL); 777SHOW TABLES; 778--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 779 SHOW CREATE TABLE t1; 780ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 781SHOW TABLES; 782--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 783 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 784CREATE TABLE t1(c1 TINYINT NOT NULL); 785SHOW TABLES; 786--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 787 SHOW CREATE TABLE t1; 788ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 789SHOW TABLES; 790--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 791 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 792CREATE TABLE t1(c1 SMALLINT NOT NULL); 793SHOW TABLES; 794--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 795 SHOW CREATE TABLE t1; 796ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 797SHOW TABLES; 798--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 799 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 800CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 801SHOW TABLES; 802--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 803 SHOW CREATE TABLE t1; 804ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 805SHOW TABLES; 806--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 807 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 808CREATE TABLE t1(c1 INT NOT NULL); 809SHOW TABLES; 810--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 811 SHOW CREATE TABLE t1; 812ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 813SHOW TABLES; 814--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 815 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 816CREATE TABLE t1(c1 INTEGER NOT NULL); 817SHOW TABLES; 818--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 819 SHOW CREATE TABLE t1; 820ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 821SHOW TABLES; 822--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 823 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 824CREATE TABLE t1(c1 BIGINT NOT NULL); 825SHOW TABLES; 826--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 827 SHOW CREATE TABLE t1; 828ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 829SHOW TABLES; 830--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 831 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 832CREATE TABLE t1(c1 REAL NOT NULL); 833SHOW TABLES; 834--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 835 SHOW CREATE TABLE t1; 836ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 837SHOW TABLES; 838--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 839 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 840CREATE TABLE t1(c1 DOUBLE NOT NULL); 841SHOW TABLES; 842--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 843 SHOW CREATE TABLE t1; 844ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 845SHOW TABLES; 846--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 847 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 848CREATE TABLE t1(c1 FLOAT NOT NULL); 849SHOW TABLES; 850--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 851 SHOW CREATE TABLE t1; 852ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 853SHOW TABLES; 854--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 855 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 856CREATE TABLE t1(c1 DECIMAL NOT NULL); 857SHOW TABLES; 858--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 859 SHOW CREATE TABLE t1; 860ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 861SHOW TABLES; 862--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 863 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 864CREATE TABLE t1(c1 NUMERIC NOT NULL); 865SHOW TABLES; 866--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 867 SHOW CREATE TABLE t1; 868ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 869SHOW TABLES; 870--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 871 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 872CREATE TABLE t1(c1 DATE NOT NULL); 873SHOW TABLES; 874--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 875 SHOW CREATE TABLE t1; 876ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 877SHOW TABLES; 878--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 879 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 880CREATE TABLE t1(c1 TIME NOT NULL); 881SHOW TABLES; 882--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 883 SHOW CREATE TABLE t1; 884ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 885SHOW TABLES; 886--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 887 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 888CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 889SHOW TABLES; 890--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 891 SHOW CREATE TABLE t1; 892ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 893SHOW TABLES; 894--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 895 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 896CREATE TABLE t1(c1 YEAR NOT NULL); 897SHOW TABLES; 898--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 899 SHOW CREATE TABLE t1; 900ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 901SHOW TABLES; 902--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 903 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 904CREATE TABLE t1(c1 BIT NOT NULL); 905SHOW TABLES; 906--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 907 SHOW CREATE TABLE t1; 908ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 909SHOW TABLES; 910--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 911 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 912CREATE TABLE t1(c1 TINYINT NOT NULL); 913SHOW TABLES; 914--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 915 SHOW CREATE TABLE t1; 916ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 917SHOW TABLES; 918--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 919 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 920CREATE TABLE t1(c1 SMALLINT NOT NULL); 921SHOW TABLES; 922--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 923 SHOW CREATE TABLE t1; 924ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 925SHOW TABLES; 926--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 927 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 928CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 929SHOW TABLES; 930--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 931 SHOW CREATE TABLE t1; 932ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 933SHOW TABLES; 934--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 935 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 936CREATE TABLE t1(c1 INT NOT NULL); 937SHOW TABLES; 938--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 939 SHOW CREATE TABLE t1; 940ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 941SHOW TABLES; 942--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 943 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 944CREATE TABLE t1(c1 INTEGER NOT NULL); 945SHOW TABLES; 946--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 947 SHOW CREATE TABLE t1; 948ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 949SHOW TABLES; 950--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 951 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 952CREATE TABLE t1(c1 BIGINT NOT NULL); 953SHOW TABLES; 954--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 955 SHOW CREATE TABLE t1; 956ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 957SHOW TABLES; 958--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 959 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 960CREATE TABLE t1(c1 REAL NOT NULL); 961SHOW TABLES; 962--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 963 SHOW CREATE TABLE t1; 964ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 965SHOW TABLES; 966--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 967 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 968CREATE TABLE t1(c1 DOUBLE NOT NULL); 969SHOW TABLES; 970--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 971 SHOW CREATE TABLE t1; 972ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 973SHOW TABLES; 974--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 975 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 976CREATE TABLE t1(c1 FLOAT NOT NULL); 977SHOW TABLES; 978--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 979 SHOW CREATE TABLE t1; 980ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 981SHOW TABLES; 982--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 983 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 984CREATE TABLE t1(c1 DECIMAL NOT NULL); 985SHOW TABLES; 986--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 987 SHOW CREATE TABLE t1; 988ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 989SHOW TABLES; 990--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 991 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 992CREATE TABLE t1(c1 NUMERIC NOT NULL); 993SHOW TABLES; 994--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 995 SHOW CREATE TABLE t1; 996ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 997SHOW TABLES; 998--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 999 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1000CREATE TABLE t1(c1 DATE NOT NULL); 1001SHOW TABLES; 1002--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1003 SHOW CREATE TABLE t1; 1004ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1005SHOW TABLES; 1006--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1007 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1008CREATE TABLE t1(c1 TIME NOT NULL); 1009SHOW TABLES; 1010--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1011 SHOW CREATE TABLE t1; 1012ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1013SHOW TABLES; 1014--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1015 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1016CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1017SHOW TABLES; 1018--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1019 SHOW CREATE TABLE t1; 1020ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1021SHOW TABLES; 1022--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1023 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1024CREATE TABLE t1(c1 YEAR NOT NULL); 1025SHOW TABLES; 1026--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1027 SHOW CREATE TABLE t1; 1028ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1029SHOW TABLES; 1030--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1031 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1032CREATE TABLE t1(c1 BIT NOT NULL); 1033SHOW TABLES; 1034--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1035 SHOW CREATE TABLE t1; 1036ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1037SHOW TABLES; 1038--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1039 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1040CREATE TABLE t1(c1 TINYINT NOT NULL); 1041SHOW TABLES; 1042--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1043 SHOW CREATE TABLE t1; 1044ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1045SHOW TABLES; 1046--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1047 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1048CREATE TABLE t1(c1 SMALLINT NOT NULL); 1049SHOW TABLES; 1050--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1051 SHOW CREATE TABLE t1; 1052ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1053SHOW TABLES; 1054--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1055 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1056CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1057SHOW TABLES; 1058--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1059 SHOW CREATE TABLE t1; 1060ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1061SHOW TABLES; 1062--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1063 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1064CREATE TABLE t1(c1 INT NOT NULL); 1065SHOW TABLES; 1066--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1067 SHOW CREATE TABLE t1; 1068ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1069SHOW TABLES; 1070--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1071 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1072CREATE TABLE t1(c1 INTEGER NOT NULL); 1073SHOW TABLES; 1074--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1075 SHOW CREATE TABLE t1; 1076ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1077SHOW TABLES; 1078--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1079 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1080CREATE TABLE t1(c1 BIGINT NOT NULL); 1081SHOW TABLES; 1082--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1083 SHOW CREATE TABLE t1; 1084ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1085SHOW TABLES; 1086--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1087 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1088CREATE TABLE t1(c1 REAL NOT NULL); 1089SHOW TABLES; 1090--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1091 SHOW CREATE TABLE t1; 1092ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1093SHOW TABLES; 1094--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1095 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1096CREATE TABLE t1(c1 DOUBLE NOT NULL); 1097SHOW TABLES; 1098--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1099 SHOW CREATE TABLE t1; 1100ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1101SHOW TABLES; 1102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1103 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1104CREATE TABLE t1(c1 FLOAT NOT NULL); 1105SHOW TABLES; 1106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1107 SHOW CREATE TABLE t1; 1108ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1109SHOW TABLES; 1110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1111 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1112CREATE TABLE t1(c1 DECIMAL NOT NULL); 1113SHOW TABLES; 1114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1115 SHOW CREATE TABLE t1; 1116ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1117SHOW TABLES; 1118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1119 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1120CREATE TABLE t1(c1 NUMERIC NOT NULL); 1121SHOW TABLES; 1122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1123 SHOW CREATE TABLE t1; 1124ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1125SHOW TABLES; 1126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1127 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1128CREATE TABLE t1(c1 DATE NOT NULL); 1129SHOW TABLES; 1130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1131 SHOW CREATE TABLE t1; 1132ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1133SHOW TABLES; 1134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1135 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1136CREATE TABLE t1(c1 TIME NOT NULL); 1137SHOW TABLES; 1138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1139 SHOW CREATE TABLE t1; 1140ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1141SHOW TABLES; 1142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1144CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1145SHOW TABLES; 1146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1147 SHOW CREATE TABLE t1; 1148ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1149SHOW TABLES; 1150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1151 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1152CREATE TABLE t1(c1 YEAR NOT NULL); 1153SHOW TABLES; 1154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1155 SHOW CREATE TABLE t1; 1156ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1157SHOW TABLES; 1158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1159 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1160CREATE TABLE t1(c1 BIT NOT NULL); 1161SHOW TABLES; 1162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1163 SHOW CREATE TABLE t1; 1164ALTER TABLE t1 ADD UNIQUE i1 (c1); 1165SHOW TABLES; 1166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1167 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1168CREATE TABLE t1(c1 TINYINT NOT NULL); 1169SHOW TABLES; 1170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1171 SHOW CREATE TABLE t1; 1172ALTER TABLE t1 ADD UNIQUE i1 (c1); 1173SHOW TABLES; 1174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1175 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1176CREATE TABLE t1(c1 SMALLINT NOT NULL); 1177SHOW TABLES; 1178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1179 SHOW CREATE TABLE t1; 1180ALTER TABLE t1 ADD UNIQUE i1 (c1); 1181SHOW TABLES; 1182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1183 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1184CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1185SHOW TABLES; 1186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1187 SHOW CREATE TABLE t1; 1188ALTER TABLE t1 ADD UNIQUE i1 (c1); 1189SHOW TABLES; 1190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1191 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1192CREATE TABLE t1(c1 INT NOT NULL); 1193SHOW TABLES; 1194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1195 SHOW CREATE TABLE t1; 1196ALTER TABLE t1 ADD UNIQUE i1 (c1); 1197SHOW TABLES; 1198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1199 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1200CREATE TABLE t1(c1 INTEGER NOT NULL); 1201SHOW TABLES; 1202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1203 SHOW CREATE TABLE t1; 1204ALTER TABLE t1 ADD UNIQUE i1 (c1); 1205SHOW TABLES; 1206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1207 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1208CREATE TABLE t1(c1 BIGINT NOT NULL); 1209SHOW TABLES; 1210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1211 SHOW CREATE TABLE t1; 1212ALTER TABLE t1 ADD UNIQUE i1 (c1); 1213SHOW TABLES; 1214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1215 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1216CREATE TABLE t1(c1 REAL NOT NULL); 1217SHOW TABLES; 1218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1219 SHOW CREATE TABLE t1; 1220ALTER TABLE t1 ADD UNIQUE i1 (c1); 1221SHOW TABLES; 1222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1223 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1224CREATE TABLE t1(c1 DOUBLE NOT NULL); 1225SHOW TABLES; 1226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1227 SHOW CREATE TABLE t1; 1228ALTER TABLE t1 ADD UNIQUE i1 (c1); 1229SHOW TABLES; 1230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1231 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1232CREATE TABLE t1(c1 FLOAT NOT NULL); 1233SHOW TABLES; 1234--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1235 SHOW CREATE TABLE t1; 1236ALTER TABLE t1 ADD UNIQUE i1 (c1); 1237SHOW TABLES; 1238--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1239 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1240CREATE TABLE t1(c1 DECIMAL NOT NULL); 1241SHOW TABLES; 1242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1243 SHOW CREATE TABLE t1; 1244ALTER TABLE t1 ADD UNIQUE i1 (c1); 1245SHOW TABLES; 1246--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1247 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1248CREATE TABLE t1(c1 NUMERIC NOT NULL); 1249SHOW TABLES; 1250--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1251 SHOW CREATE TABLE t1; 1252ALTER TABLE t1 ADD UNIQUE i1 (c1); 1253SHOW TABLES; 1254--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1255 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1256CREATE TABLE t1(c1 DATE NOT NULL); 1257SHOW TABLES; 1258--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1259 SHOW CREATE TABLE t1; 1260ALTER TABLE t1 ADD UNIQUE i1 (c1); 1261SHOW TABLES; 1262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1263 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1264CREATE TABLE t1(c1 TIME NOT NULL); 1265SHOW TABLES; 1266--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1267 SHOW CREATE TABLE t1; 1268ALTER TABLE t1 ADD UNIQUE i1 (c1); 1269SHOW TABLES; 1270--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1271 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1272CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1273SHOW TABLES; 1274--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1275 SHOW CREATE TABLE t1; 1276ALTER TABLE t1 ADD UNIQUE i1 (c1); 1277SHOW TABLES; 1278--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1279 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1280CREATE TABLE t1(c1 YEAR NOT NULL); 1281SHOW TABLES; 1282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1283 SHOW CREATE TABLE t1; 1284ALTER TABLE t1 ADD UNIQUE i1 (c1); 1285SHOW TABLES; 1286--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1287 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1288CREATE TABLE t1(c1 BIT NOT NULL); 1289SHOW TABLES; 1290--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1291 SHOW CREATE TABLE t1; 1292ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1293SHOW TABLES; 1294--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1295 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1296CREATE TABLE t1(c1 TINYINT NOT NULL); 1297SHOW TABLES; 1298--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1299 SHOW CREATE TABLE t1; 1300ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1301SHOW TABLES; 1302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1303 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1304CREATE TABLE t1(c1 SMALLINT NOT NULL); 1305SHOW TABLES; 1306--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1307 SHOW CREATE TABLE t1; 1308ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1309SHOW TABLES; 1310--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1311 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1312CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1313SHOW TABLES; 1314--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1315 SHOW CREATE TABLE t1; 1316ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1317SHOW TABLES; 1318--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1319 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1320CREATE TABLE t1(c1 INT NOT NULL); 1321SHOW TABLES; 1322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1323 SHOW CREATE TABLE t1; 1324ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1325SHOW TABLES; 1326--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1327 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1328CREATE TABLE t1(c1 INTEGER NOT NULL); 1329SHOW TABLES; 1330--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1331 SHOW CREATE TABLE t1; 1332ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1333SHOW TABLES; 1334--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1335 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1336CREATE TABLE t1(c1 BIGINT NOT NULL); 1337SHOW TABLES; 1338--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1339 SHOW CREATE TABLE t1; 1340ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1341SHOW TABLES; 1342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1343 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1344CREATE TABLE t1(c1 REAL NOT NULL); 1345SHOW TABLES; 1346--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1347 SHOW CREATE TABLE t1; 1348ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1349SHOW TABLES; 1350--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1351 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1352CREATE TABLE t1(c1 DOUBLE NOT NULL); 1353SHOW TABLES; 1354--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1355 SHOW CREATE TABLE t1; 1356ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1357SHOW TABLES; 1358--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1359 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1360CREATE TABLE t1(c1 FLOAT NOT NULL); 1361SHOW TABLES; 1362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1363 SHOW CREATE TABLE t1; 1364ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1365SHOW TABLES; 1366--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1367 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1368CREATE TABLE t1(c1 DECIMAL NOT NULL); 1369SHOW TABLES; 1370--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1371 SHOW CREATE TABLE t1; 1372ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1373SHOW TABLES; 1374--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1375 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1376CREATE TABLE t1(c1 NUMERIC NOT NULL); 1377SHOW TABLES; 1378--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1379 SHOW CREATE TABLE t1; 1380ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1381SHOW TABLES; 1382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1383 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1384CREATE TABLE t1(c1 DATE NOT NULL); 1385SHOW TABLES; 1386--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1387 SHOW CREATE TABLE t1; 1388ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1389SHOW TABLES; 1390--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1391 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1392CREATE TABLE t1(c1 TIME NOT NULL); 1393SHOW TABLES; 1394--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1395 SHOW CREATE TABLE t1; 1396ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1397SHOW TABLES; 1398--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1399 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1400CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1401SHOW TABLES; 1402--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1403 SHOW CREATE TABLE t1; 1404ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1405SHOW TABLES; 1406--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1407 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1408CREATE TABLE t1(c1 YEAR NOT NULL); 1409SHOW TABLES; 1410--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1411 SHOW CREATE TABLE t1; 1412ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1413SHOW TABLES; 1414--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1415 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1416CREATE TABLE t1(c1 BIT NOT NULL); 1417SHOW TABLES; 1418--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1419 SHOW CREATE TABLE t1; 1420ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1421SHOW TABLES; 1422--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1423 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1424CREATE TABLE t1(c1 TINYINT NOT NULL); 1425SHOW TABLES; 1426--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1427 SHOW CREATE TABLE t1; 1428ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1429SHOW TABLES; 1430--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1431 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1432CREATE TABLE t1(c1 SMALLINT NOT NULL); 1433SHOW TABLES; 1434--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1435 SHOW CREATE TABLE t1; 1436ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1437SHOW TABLES; 1438--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1439 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1440CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1441SHOW TABLES; 1442--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1443 SHOW CREATE TABLE t1; 1444ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1445SHOW TABLES; 1446--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1447 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1448CREATE TABLE t1(c1 INT NOT NULL); 1449SHOW TABLES; 1450--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1451 SHOW CREATE TABLE t1; 1452ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1453SHOW TABLES; 1454--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1455 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1456CREATE TABLE t1(c1 INTEGER NOT NULL); 1457SHOW TABLES; 1458--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1459 SHOW CREATE TABLE t1; 1460ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1461SHOW TABLES; 1462--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1463 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1464CREATE TABLE t1(c1 BIGINT NOT NULL); 1465SHOW TABLES; 1466--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1467 SHOW CREATE TABLE t1; 1468ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1469SHOW TABLES; 1470--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1471 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1472CREATE TABLE t1(c1 REAL NOT NULL); 1473SHOW TABLES; 1474--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1475 SHOW CREATE TABLE t1; 1476ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1477SHOW TABLES; 1478--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1479 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1480CREATE TABLE t1(c1 DOUBLE NOT NULL); 1481SHOW TABLES; 1482--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1483 SHOW CREATE TABLE t1; 1484ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1485SHOW TABLES; 1486--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1487 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1488CREATE TABLE t1(c1 FLOAT NOT NULL); 1489SHOW TABLES; 1490--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1491 SHOW CREATE TABLE t1; 1492ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1493SHOW TABLES; 1494--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1495 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1496CREATE TABLE t1(c1 DECIMAL NOT NULL); 1497SHOW TABLES; 1498--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1499 SHOW CREATE TABLE t1; 1500ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1501SHOW TABLES; 1502--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1503 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1504CREATE TABLE t1(c1 NUMERIC NOT NULL); 1505SHOW TABLES; 1506--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1507 SHOW CREATE TABLE t1; 1508ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1509SHOW TABLES; 1510--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1511 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1512CREATE TABLE t1(c1 DATE NOT NULL); 1513SHOW TABLES; 1514--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1515 SHOW CREATE TABLE t1; 1516ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1517SHOW TABLES; 1518--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1519 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1520CREATE TABLE t1(c1 TIME NOT NULL); 1521SHOW TABLES; 1522--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1523 SHOW CREATE TABLE t1; 1524ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1525SHOW TABLES; 1526--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1527 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1528CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1529SHOW TABLES; 1530--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1531 SHOW CREATE TABLE t1; 1532ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1533SHOW TABLES; 1534--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1535 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1536CREATE TABLE t1(c1 YEAR NOT NULL); 1537SHOW TABLES; 1538--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1539 SHOW CREATE TABLE t1; 1540ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1541SHOW TABLES; 1542--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1543 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1544CREATE TABLE t1(c1 BIT NOT NULL); 1545SHOW TABLES; 1546--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1547 SHOW CREATE TABLE t1; 1548ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1549SHOW TABLES; 1550--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1551 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1552CREATE TABLE t1(c1 TINYINT NOT NULL); 1553SHOW TABLES; 1554--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1555 SHOW CREATE TABLE t1; 1556ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1557SHOW TABLES; 1558--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1559 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1560CREATE TABLE t1(c1 SMALLINT NOT NULL); 1561SHOW TABLES; 1562--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1563 SHOW CREATE TABLE t1; 1564ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1565SHOW TABLES; 1566--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1567 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1568CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1569SHOW TABLES; 1570--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1571 SHOW CREATE TABLE t1; 1572ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1573SHOW TABLES; 1574--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1575 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1576CREATE TABLE t1(c1 INT NOT NULL); 1577SHOW TABLES; 1578--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1579 SHOW CREATE TABLE t1; 1580ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1581SHOW TABLES; 1582--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1583 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1584CREATE TABLE t1(c1 INTEGER NOT NULL); 1585SHOW TABLES; 1586--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1587 SHOW CREATE TABLE t1; 1588ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1589SHOW TABLES; 1590--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1591 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1592CREATE TABLE t1(c1 BIGINT NOT NULL); 1593SHOW TABLES; 1594--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1595 SHOW CREATE TABLE t1; 1596ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1597SHOW TABLES; 1598--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1599 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1600CREATE TABLE t1(c1 REAL NOT NULL); 1601SHOW TABLES; 1602--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1603 SHOW CREATE TABLE t1; 1604ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1605SHOW TABLES; 1606--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1607 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1608CREATE TABLE t1(c1 DOUBLE NOT NULL); 1609SHOW TABLES; 1610--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1611 SHOW CREATE TABLE t1; 1612ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1613SHOW TABLES; 1614--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1615 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1616CREATE TABLE t1(c1 FLOAT NOT NULL); 1617SHOW TABLES; 1618--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1619 SHOW CREATE TABLE t1; 1620ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1621SHOW TABLES; 1622--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1623 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1624CREATE TABLE t1(c1 DECIMAL NOT NULL); 1625SHOW TABLES; 1626--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1627 SHOW CREATE TABLE t1; 1628ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1629SHOW TABLES; 1630--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1631 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1632CREATE TABLE t1(c1 NUMERIC NOT NULL); 1633SHOW TABLES; 1634--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1635 SHOW CREATE TABLE t1; 1636ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1637SHOW TABLES; 1638--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1639 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1640CREATE TABLE t1(c1 DATE NOT NULL); 1641SHOW TABLES; 1642--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1643 SHOW CREATE TABLE t1; 1644ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1645SHOW TABLES; 1646--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1647 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1648CREATE TABLE t1(c1 TIME NOT NULL); 1649SHOW TABLES; 1650--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1651 SHOW CREATE TABLE t1; 1652ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1653SHOW TABLES; 1654--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1655 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1656CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1657SHOW TABLES; 1658--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1659 SHOW CREATE TABLE t1; 1660ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1661SHOW TABLES; 1662--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1663 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1664CREATE TABLE t1(c1 YEAR NOT NULL); 1665SHOW TABLES; 1666--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1667 SHOW CREATE TABLE t1; 1668ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1669SHOW TABLES; 1670--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1671 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1672CREATE TABLE t1(c1 BIT NOT NULL); 1673SHOW TABLES; 1674--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1675 SHOW CREATE TABLE t1; 1676ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1677SHOW TABLES; 1678--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1679 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1680CREATE TABLE t1(c1 TINYINT NOT NULL); 1681SHOW TABLES; 1682--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1683 SHOW CREATE TABLE t1; 1684ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1685SHOW TABLES; 1686--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1687 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1688CREATE TABLE t1(c1 SMALLINT NOT NULL); 1689SHOW TABLES; 1690--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1691 SHOW CREATE TABLE t1; 1692ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1693SHOW TABLES; 1694--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1695 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1696CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1697SHOW TABLES; 1698--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1699 SHOW CREATE TABLE t1; 1700ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1701SHOW TABLES; 1702--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1703 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1704CREATE TABLE t1(c1 INT NOT NULL); 1705SHOW TABLES; 1706--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1707 SHOW CREATE TABLE t1; 1708ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1709SHOW TABLES; 1710--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1711 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1712CREATE TABLE t1(c1 INTEGER NOT NULL); 1713SHOW TABLES; 1714--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1715 SHOW CREATE TABLE t1; 1716ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1717SHOW TABLES; 1718--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1719 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1720CREATE TABLE t1(c1 BIGINT NOT NULL); 1721SHOW TABLES; 1722--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1723 SHOW CREATE TABLE t1; 1724ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1725SHOW TABLES; 1726--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1727 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1728CREATE TABLE t1(c1 REAL NOT NULL); 1729SHOW TABLES; 1730--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1731 SHOW CREATE TABLE t1; 1732ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1733SHOW TABLES; 1734--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1735 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1736CREATE TABLE t1(c1 DOUBLE NOT NULL); 1737SHOW TABLES; 1738--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1739 SHOW CREATE TABLE t1; 1740ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1741SHOW TABLES; 1742--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1743 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1744CREATE TABLE t1(c1 FLOAT NOT NULL); 1745SHOW TABLES; 1746--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1747 SHOW CREATE TABLE t1; 1748ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1749SHOW TABLES; 1750--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1751 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1752CREATE TABLE t1(c1 DECIMAL NOT NULL); 1753SHOW TABLES; 1754--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1755 SHOW CREATE TABLE t1; 1756ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1757SHOW TABLES; 1758--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1759 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1760CREATE TABLE t1(c1 NUMERIC NOT NULL); 1761SHOW TABLES; 1762--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1763 SHOW CREATE TABLE t1; 1764ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1765SHOW TABLES; 1766--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1767 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1768CREATE TABLE t1(c1 DATE NOT NULL); 1769SHOW TABLES; 1770--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1771 SHOW CREATE TABLE t1; 1772ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1773SHOW TABLES; 1774--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1775 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1776CREATE TABLE t1(c1 TIME NOT NULL); 1777SHOW TABLES; 1778--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1779 SHOW CREATE TABLE t1; 1780ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1781SHOW TABLES; 1782--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1783 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1784CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1785SHOW TABLES; 1786--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1787 SHOW CREATE TABLE t1; 1788ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1789SHOW TABLES; 1790--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1791 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1792CREATE TABLE t1(c1 YEAR NOT NULL); 1793SHOW TABLES; 1794--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1795 SHOW CREATE TABLE t1; 1796ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 1797SHOW TABLES; 1798--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1799 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1800CREATE TABLE t1(c1 BIT NOT NULL); 1801SHOW TABLES; 1802--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1803 SHOW CREATE TABLE t1; 1804ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1805SHOW TABLES; 1806--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1807 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1808CREATE TABLE t1(c1 TINYINT NOT NULL); 1809SHOW TABLES; 1810--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1811 SHOW CREATE TABLE t1; 1812ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1813SHOW TABLES; 1814--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1815 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1816CREATE TABLE t1(c1 SMALLINT NOT NULL); 1817SHOW TABLES; 1818--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1819 SHOW CREATE TABLE t1; 1820ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1821SHOW TABLES; 1822--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1823 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1824CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1825SHOW TABLES; 1826--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1827 SHOW CREATE TABLE t1; 1828ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1829SHOW TABLES; 1830--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1831 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1832CREATE TABLE t1(c1 INT NOT NULL); 1833SHOW TABLES; 1834--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1835 SHOW CREATE TABLE t1; 1836ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1837SHOW TABLES; 1838--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1839 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1840CREATE TABLE t1(c1 INTEGER NOT NULL); 1841SHOW TABLES; 1842--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1843 SHOW CREATE TABLE t1; 1844ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1845SHOW TABLES; 1846--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1847 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1848CREATE TABLE t1(c1 BIGINT NOT NULL); 1849SHOW TABLES; 1850--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1851 SHOW CREATE TABLE t1; 1852ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1853SHOW TABLES; 1854--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1855 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1856CREATE TABLE t1(c1 REAL NOT NULL); 1857SHOW TABLES; 1858--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1859 SHOW CREATE TABLE t1; 1860ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1861SHOW TABLES; 1862--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1863 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1864CREATE TABLE t1(c1 DOUBLE NOT NULL); 1865SHOW TABLES; 1866--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1867 SHOW CREATE TABLE t1; 1868ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1869SHOW TABLES; 1870--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1871 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1872CREATE TABLE t1(c1 FLOAT NOT NULL); 1873SHOW TABLES; 1874--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1875 SHOW CREATE TABLE t1; 1876ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1877SHOW TABLES; 1878--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1879 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1880CREATE TABLE t1(c1 DECIMAL NOT NULL); 1881SHOW TABLES; 1882--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1883 SHOW CREATE TABLE t1; 1884ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1885SHOW TABLES; 1886--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1887 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1888CREATE TABLE t1(c1 NUMERIC NOT NULL); 1889SHOW TABLES; 1890--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1891 SHOW CREATE TABLE t1; 1892ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1893SHOW TABLES; 1894--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1895 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1896CREATE TABLE t1(c1 DATE NOT NULL); 1897SHOW TABLES; 1898--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1899 SHOW CREATE TABLE t1; 1900ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1901SHOW TABLES; 1902--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1903 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1904CREATE TABLE t1(c1 TIME NOT NULL); 1905SHOW TABLES; 1906--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1907 SHOW CREATE TABLE t1; 1908ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1909SHOW TABLES; 1910--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1911 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1912CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1913SHOW TABLES; 1914--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1915 SHOW CREATE TABLE t1; 1916ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1917SHOW TABLES; 1918--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1919 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1920CREATE TABLE t1(c1 YEAR NOT NULL); 1921SHOW TABLES; 1922--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1923 SHOW CREATE TABLE t1; 1924ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 1925SHOW TABLES; 1926--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1927 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1928CREATE TABLE t1(c1 BIT NOT NULL); 1929SHOW TABLES; 1930--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1931 SHOW CREATE TABLE t1; 1932ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1933SHOW TABLES; 1934--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1935 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1936CREATE TABLE t1(c1 TINYINT NOT NULL); 1937SHOW TABLES; 1938--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1939 SHOW CREATE TABLE t1; 1940ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1941SHOW TABLES; 1942--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1943 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1944CREATE TABLE t1(c1 SMALLINT NOT NULL); 1945SHOW TABLES; 1946--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1947 SHOW CREATE TABLE t1; 1948ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1949SHOW TABLES; 1950--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1951 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1952CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1953SHOW TABLES; 1954--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1955 SHOW CREATE TABLE t1; 1956ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1957SHOW TABLES; 1958--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1959 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1960CREATE TABLE t1(c1 INT NOT NULL); 1961SHOW TABLES; 1962--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1963 SHOW CREATE TABLE t1; 1964ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1965SHOW TABLES; 1966--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1967 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1968CREATE TABLE t1(c1 INTEGER NOT NULL); 1969SHOW TABLES; 1970--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1971 SHOW CREATE TABLE t1; 1972ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1973SHOW TABLES; 1974--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1975 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1976CREATE TABLE t1(c1 BIGINT NOT NULL); 1977SHOW TABLES; 1978--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1979 SHOW CREATE TABLE t1; 1980ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1981SHOW TABLES; 1982--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1983 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1984CREATE TABLE t1(c1 REAL NOT NULL); 1985SHOW TABLES; 1986--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1987 SHOW CREATE TABLE t1; 1988ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1989SHOW TABLES; 1990--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1991 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1992CREATE TABLE t1(c1 DOUBLE NOT NULL); 1993SHOW TABLES; 1994--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1995 SHOW CREATE TABLE t1; 1996ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 1997SHOW TABLES; 1998--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 1999 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2000CREATE TABLE t1(c1 FLOAT NOT NULL); 2001SHOW TABLES; 2002--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2003 SHOW CREATE TABLE t1; 2004ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2005SHOW TABLES; 2006--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2007 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2008CREATE TABLE t1(c1 DECIMAL NOT NULL); 2009SHOW TABLES; 2010--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2011 SHOW CREATE TABLE t1; 2012ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2013SHOW TABLES; 2014--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2015 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2016CREATE TABLE t1(c1 NUMERIC NOT NULL); 2017SHOW TABLES; 2018--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2019 SHOW CREATE TABLE t1; 2020ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2021SHOW TABLES; 2022--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2023 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2024CREATE TABLE t1(c1 DATE NOT NULL); 2025SHOW TABLES; 2026--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2027 SHOW CREATE TABLE t1; 2028ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2029SHOW TABLES; 2030--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2031 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2032CREATE TABLE t1(c1 TIME NOT NULL); 2033SHOW TABLES; 2034--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2035 SHOW CREATE TABLE t1; 2036ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2037SHOW TABLES; 2038--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2039 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2040CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2041SHOW TABLES; 2042--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2043 SHOW CREATE TABLE t1; 2044ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2045SHOW TABLES; 2046--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2047 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2048CREATE TABLE t1(c1 YEAR NOT NULL); 2049SHOW TABLES; 2050--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2051 SHOW CREATE TABLE t1; 2052ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2053SHOW TABLES; 2054--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2055 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2056CREATE TABLE t1(c1 BIT NOT NULL); 2057SHOW TABLES; 2058--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2059 SHOW CREATE TABLE t1; 2060ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2061SHOW TABLES; 2062--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2063 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2064CREATE TABLE t1(c1 TINYINT NOT NULL); 2065SHOW TABLES; 2066--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2067 SHOW CREATE TABLE t1; 2068ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2069SHOW TABLES; 2070--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2071 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2072CREATE TABLE t1(c1 SMALLINT NOT NULL); 2073SHOW TABLES; 2074--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2075 SHOW CREATE TABLE t1; 2076ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2077SHOW TABLES; 2078--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2079 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2080CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2081SHOW TABLES; 2082--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2083 SHOW CREATE TABLE t1; 2084ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2085SHOW TABLES; 2086--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2087 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2088CREATE TABLE t1(c1 INT NOT NULL); 2089SHOW TABLES; 2090--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2091 SHOW CREATE TABLE t1; 2092ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2093SHOW TABLES; 2094--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2095 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2096CREATE TABLE t1(c1 INTEGER NOT NULL); 2097SHOW TABLES; 2098--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2099 SHOW CREATE TABLE t1; 2100ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2101SHOW TABLES; 2102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2103 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2104CREATE TABLE t1(c1 BIGINT NOT NULL); 2105SHOW TABLES; 2106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2107 SHOW CREATE TABLE t1; 2108ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2109SHOW TABLES; 2110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2111 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2112CREATE TABLE t1(c1 REAL NOT NULL); 2113SHOW TABLES; 2114--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2115 SHOW CREATE TABLE t1; 2116ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2117SHOW TABLES; 2118--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2119 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2120CREATE TABLE t1(c1 DOUBLE NOT NULL); 2121SHOW TABLES; 2122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2123 SHOW CREATE TABLE t1; 2124ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2125SHOW TABLES; 2126--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2127 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2128CREATE TABLE t1(c1 FLOAT NOT NULL); 2129SHOW TABLES; 2130--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2131 SHOW CREATE TABLE t1; 2132ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2133SHOW TABLES; 2134--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2135 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2136CREATE TABLE t1(c1 DECIMAL NOT NULL); 2137SHOW TABLES; 2138--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2139 SHOW CREATE TABLE t1; 2140ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2141SHOW TABLES; 2142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2144CREATE TABLE t1(c1 NUMERIC NOT NULL); 2145SHOW TABLES; 2146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2147 SHOW CREATE TABLE t1; 2148ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2149SHOW TABLES; 2150--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2151 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2152CREATE TABLE t1(c1 DATE NOT NULL); 2153SHOW TABLES; 2154--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2155 SHOW CREATE TABLE t1; 2156ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2157SHOW TABLES; 2158--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2159 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2160CREATE TABLE t1(c1 TIME NOT NULL); 2161SHOW TABLES; 2162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2163 SHOW CREATE TABLE t1; 2164ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2165SHOW TABLES; 2166--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2167 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2168CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2169SHOW TABLES; 2170--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2171 SHOW CREATE TABLE t1; 2172ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2173SHOW TABLES; 2174--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2175 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2176CREATE TABLE t1(c1 YEAR NOT NULL); 2177SHOW TABLES; 2178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2179 SHOW CREATE TABLE t1; 2180ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2181SHOW TABLES; 2182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2183 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2184CREATE TABLE t1(c1 BIT NOT NULL); 2185SHOW TABLES; 2186--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2187 SHOW CREATE TABLE t1; 2188ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2189SHOW TABLES; 2190--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2191 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2192CREATE TABLE t1(c1 TINYINT NOT NULL); 2193SHOW TABLES; 2194--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2195 SHOW CREATE TABLE t1; 2196ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2197SHOW TABLES; 2198--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2199 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2200CREATE TABLE t1(c1 SMALLINT NOT NULL); 2201SHOW TABLES; 2202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2203 SHOW CREATE TABLE t1; 2204ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2205SHOW TABLES; 2206--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2207 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2208CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2209SHOW TABLES; 2210--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2211 SHOW CREATE TABLE t1; 2212ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2213SHOW TABLES; 2214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2215 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2216CREATE TABLE t1(c1 INT NOT NULL); 2217SHOW TABLES; 2218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2219 SHOW CREATE TABLE t1; 2220ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2221SHOW TABLES; 2222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2223 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2224CREATE TABLE t1(c1 INTEGER NOT NULL); 2225SHOW TABLES; 2226--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2227 SHOW CREATE TABLE t1; 2228ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2229SHOW TABLES; 2230--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2231 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2232CREATE TABLE t1(c1 BIGINT NOT NULL); 2233SHOW TABLES; 2234--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2235 SHOW CREATE TABLE t1; 2236ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2237SHOW TABLES; 2238--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2239 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2240CREATE TABLE t1(c1 REAL NOT NULL); 2241SHOW TABLES; 2242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2243 SHOW CREATE TABLE t1; 2244ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2245SHOW TABLES; 2246--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2247 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2248CREATE TABLE t1(c1 DOUBLE NOT NULL); 2249SHOW TABLES; 2250--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2251 SHOW CREATE TABLE t1; 2252ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2253SHOW TABLES; 2254--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2255 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2256CREATE TABLE t1(c1 FLOAT NOT NULL); 2257SHOW TABLES; 2258--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2259 SHOW CREATE TABLE t1; 2260ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2261SHOW TABLES; 2262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2263 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2264CREATE TABLE t1(c1 DECIMAL NOT NULL); 2265SHOW TABLES; 2266--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2267 SHOW CREATE TABLE t1; 2268ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2269SHOW TABLES; 2270--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2271 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2272CREATE TABLE t1(c1 NUMERIC NOT NULL); 2273SHOW TABLES; 2274--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2275 SHOW CREATE TABLE t1; 2276ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2277SHOW TABLES; 2278--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2279 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2280CREATE TABLE t1(c1 DATE NOT NULL); 2281SHOW TABLES; 2282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2283 SHOW CREATE TABLE t1; 2284ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2285SHOW TABLES; 2286--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2287 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2288CREATE TABLE t1(c1 TIME NOT NULL); 2289SHOW TABLES; 2290--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2291 SHOW CREATE TABLE t1; 2292ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2293SHOW TABLES; 2294--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2295 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2296CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2297SHOW TABLES; 2298--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2299 SHOW CREATE TABLE t1; 2300ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2301SHOW TABLES; 2302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2303 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2304CREATE TABLE t1(c1 YEAR NOT NULL); 2305SHOW TABLES; 2306--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2307 SHOW CREATE TABLE t1; 2308ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2309SHOW TABLES; 2310--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 2311 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2312 2313