1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4CREATE TABLE t1(c1 BIT NOT NULL); 5SHOW TABLES; 6let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 7--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 8 SHOW CREATE TABLE t1; 9ALTER TABLE t1 ADD UNIQUE (c1); 10SHOW TABLES; 11let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 12--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 13 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 14CREATE TABLE t1(c1 TINYINT NOT NULL); 15SHOW TABLES; 16let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 17--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 18 SHOW CREATE TABLE t1; 19ALTER TABLE t1 ADD UNIQUE (c1); 20SHOW TABLES; 21let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 23 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 24CREATE TABLE t1(c1 SMALLINT NOT NULL); 25SHOW TABLES; 26let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 27--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 28 SHOW CREATE TABLE t1; 29ALTER TABLE t1 ADD UNIQUE (c1); 30SHOW TABLES; 31let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 32--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 33 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 34CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 35SHOW TABLES; 36let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 37--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 38 SHOW CREATE TABLE t1; 39ALTER TABLE t1 ADD UNIQUE (c1); 40SHOW TABLES; 41let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 43 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 44CREATE TABLE t1(c1 INT NOT NULL); 45SHOW TABLES; 46let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 47--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 48 SHOW CREATE TABLE t1; 49ALTER TABLE t1 ADD UNIQUE (c1); 50SHOW TABLES; 51let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 52--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 53 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 54CREATE TABLE t1(c1 INTEGER NOT NULL); 55SHOW TABLES; 56let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 57--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 58 SHOW CREATE TABLE t1; 59ALTER TABLE t1 ADD UNIQUE (c1); 60SHOW TABLES; 61let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 63 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 64CREATE TABLE t1(c1 BIGINT NOT NULL); 65SHOW TABLES; 66let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 67--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 68 SHOW CREATE TABLE t1; 69ALTER TABLE t1 ADD UNIQUE (c1); 70SHOW TABLES; 71let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 72--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 73 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 74CREATE TABLE t1(c1 REAL NOT NULL); 75SHOW TABLES; 76let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 77--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 78 SHOW CREATE TABLE t1; 79ALTER TABLE t1 ADD UNIQUE (c1); 80SHOW TABLES; 81let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 83 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 84CREATE TABLE t1(c1 DOUBLE NOT NULL); 85SHOW TABLES; 86let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 87--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 88 SHOW CREATE TABLE t1; 89ALTER TABLE t1 ADD UNIQUE (c1); 90SHOW TABLES; 91let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 92--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 93 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 94CREATE TABLE t1(c1 FLOAT NOT NULL); 95SHOW TABLES; 96let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 97--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 98 SHOW CREATE TABLE t1; 99ALTER TABLE t1 ADD UNIQUE (c1); 100SHOW TABLES; 101let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 103 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 104CREATE TABLE t1(c1 DECIMAL NOT NULL); 105SHOW TABLES; 106let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 107--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 108 SHOW CREATE TABLE t1; 109ALTER TABLE t1 ADD UNIQUE (c1); 110SHOW TABLES; 111let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 112--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 113 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 114CREATE TABLE t1(c1 NUMERIC NOT NULL); 115SHOW TABLES; 116let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 117--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 118 SHOW CREATE TABLE t1; 119ALTER TABLE t1 ADD UNIQUE (c1); 120SHOW TABLES; 121let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 123 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 124CREATE TABLE t1(c1 DATE NOT NULL); 125SHOW TABLES; 126let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 127--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 128 SHOW CREATE TABLE t1; 129ALTER TABLE t1 ADD UNIQUE (c1); 130SHOW TABLES; 131let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 132--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 133 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 134CREATE TABLE t1(c1 TIME NOT NULL); 135SHOW TABLES; 136let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 137--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 138 SHOW CREATE TABLE t1; 139ALTER TABLE t1 ADD UNIQUE (c1); 140SHOW TABLES; 141let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 144CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 145SHOW TABLES; 146let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 147--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 148 SHOW CREATE TABLE t1; 149ALTER TABLE t1 ADD UNIQUE (c1); 150SHOW TABLES; 151let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 152--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 153 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 154CREATE TABLE t1(c1 YEAR NOT NULL); 155SHOW TABLES; 156let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 157--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 158 SHOW CREATE TABLE t1; 159ALTER TABLE t1 ADD UNIQUE (c1); 160SHOW TABLES; 161let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 163 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 164CREATE TABLE t1(c1 BIT NOT NULL); 165SHOW TABLES; 166let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 167--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 168 SHOW CREATE TABLE t1; 169ALTER TABLE t1 ADD UNIQUE KEY (c1); 170SHOW TABLES; 171let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 172--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 173 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 174CREATE TABLE t1(c1 TINYINT NOT NULL); 175SHOW TABLES; 176let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 177--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 178 SHOW CREATE TABLE t1; 179ALTER TABLE t1 ADD UNIQUE KEY (c1); 180SHOW TABLES; 181let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 183 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 184CREATE TABLE t1(c1 SMALLINT NOT NULL); 185SHOW TABLES; 186let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 187--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 188 SHOW CREATE TABLE t1; 189ALTER TABLE t1 ADD UNIQUE KEY (c1); 190SHOW TABLES; 191let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 192--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 193 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 194CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 195SHOW TABLES; 196let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 197--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 198 SHOW CREATE TABLE t1; 199ALTER TABLE t1 ADD UNIQUE KEY (c1); 200SHOW TABLES; 201let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 203 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 204CREATE TABLE t1(c1 INT NOT NULL); 205SHOW TABLES; 206let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 207--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 208 SHOW CREATE TABLE t1; 209ALTER TABLE t1 ADD UNIQUE KEY (c1); 210SHOW TABLES; 211let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 212--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 213 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 214CREATE TABLE t1(c1 INTEGER NOT NULL); 215SHOW TABLES; 216let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 217--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 218 SHOW CREATE TABLE t1; 219ALTER TABLE t1 ADD UNIQUE KEY (c1); 220SHOW TABLES; 221let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 223 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 224CREATE TABLE t1(c1 BIGINT NOT NULL); 225SHOW TABLES; 226let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 227--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 228 SHOW CREATE TABLE t1; 229ALTER TABLE t1 ADD UNIQUE KEY (c1); 230SHOW TABLES; 231let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 232--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 234CREATE TABLE t1(c1 REAL NOT NULL); 235SHOW TABLES; 236let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 237--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 238 SHOW CREATE TABLE t1; 239ALTER TABLE t1 ADD UNIQUE KEY (c1); 240SHOW TABLES; 241let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 243 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 244CREATE TABLE t1(c1 DOUBLE NOT NULL); 245SHOW TABLES; 246let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 247--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 248 SHOW CREATE TABLE t1; 249ALTER TABLE t1 ADD UNIQUE KEY (c1); 250SHOW TABLES; 251let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 252--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 253 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 254CREATE TABLE t1(c1 FLOAT NOT NULL); 255SHOW TABLES; 256let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 257--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 258 SHOW CREATE TABLE t1; 259ALTER TABLE t1 ADD UNIQUE KEY (c1); 260SHOW TABLES; 261let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 263 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 264CREATE TABLE t1(c1 DECIMAL NOT NULL); 265SHOW TABLES; 266let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 267--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 268 SHOW CREATE TABLE t1; 269ALTER TABLE t1 ADD UNIQUE KEY (c1); 270SHOW TABLES; 271let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 272--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 273 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 274CREATE TABLE t1(c1 NUMERIC NOT NULL); 275SHOW TABLES; 276let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 277--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 278 SHOW CREATE TABLE t1; 279ALTER TABLE t1 ADD UNIQUE KEY (c1); 280SHOW TABLES; 281let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 283 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 284CREATE TABLE t1(c1 DATE NOT NULL); 285SHOW TABLES; 286let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 287--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 288 SHOW CREATE TABLE t1; 289ALTER TABLE t1 ADD UNIQUE KEY (c1); 290SHOW TABLES; 291let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 292--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 293 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 294CREATE TABLE t1(c1 TIME NOT NULL); 295SHOW TABLES; 296let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 297--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 298 SHOW CREATE TABLE t1; 299ALTER TABLE t1 ADD UNIQUE KEY (c1); 300SHOW TABLES; 301let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 303 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 304CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 305SHOW TABLES; 306let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 307--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 308 SHOW CREATE TABLE t1; 309ALTER TABLE t1 ADD UNIQUE KEY (c1); 310SHOW TABLES; 311let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 312--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 313 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 314CREATE TABLE t1(c1 YEAR NOT NULL); 315SHOW TABLES; 316let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 317--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 318 SHOW CREATE TABLE t1; 319ALTER TABLE t1 ADD UNIQUE KEY (c1); 320SHOW TABLES; 321let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 323 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 324CREATE TABLE t1(c1 BIT NOT NULL); 325SHOW TABLES; 326let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 327--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 328 SHOW CREATE TABLE t1; 329ALTER TABLE t1 ADD UNIQUE INDEX (c1); 330SHOW TABLES; 331let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 332--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 333 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 334CREATE TABLE t1(c1 TINYINT NOT NULL); 335SHOW TABLES; 336let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 337--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 338 SHOW CREATE TABLE t1; 339ALTER TABLE t1 ADD UNIQUE INDEX (c1); 340SHOW TABLES; 341let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 343 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 344CREATE TABLE t1(c1 SMALLINT NOT NULL); 345SHOW TABLES; 346let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 347--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 348 SHOW CREATE TABLE t1; 349ALTER TABLE t1 ADD UNIQUE INDEX (c1); 350SHOW TABLES; 351let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 352--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 353 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 354CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 355SHOW TABLES; 356let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 357--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 358 SHOW CREATE TABLE t1; 359ALTER TABLE t1 ADD UNIQUE INDEX (c1); 360SHOW TABLES; 361let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 363 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 364CREATE TABLE t1(c1 INT NOT NULL); 365SHOW TABLES; 366let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 367--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 368 SHOW CREATE TABLE t1; 369ALTER TABLE t1 ADD UNIQUE INDEX (c1); 370SHOW TABLES; 371let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 372--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 373 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 374CREATE TABLE t1(c1 INTEGER NOT NULL); 375SHOW TABLES; 376let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 377--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 378 SHOW CREATE TABLE t1; 379ALTER TABLE t1 ADD UNIQUE INDEX (c1); 380SHOW TABLES; 381let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 383 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 384CREATE TABLE t1(c1 BIGINT NOT NULL); 385SHOW TABLES; 386let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 387--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 388 SHOW CREATE TABLE t1; 389ALTER TABLE t1 ADD UNIQUE INDEX (c1); 390SHOW TABLES; 391let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 392--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 393 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 394CREATE TABLE t1(c1 REAL NOT NULL); 395SHOW TABLES; 396let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 397--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 398 SHOW CREATE TABLE t1; 399ALTER TABLE t1 ADD UNIQUE INDEX (c1); 400SHOW TABLES; 401let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 402--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 403 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 404CREATE TABLE t1(c1 DOUBLE NOT NULL); 405SHOW TABLES; 406let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 407--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 408 SHOW CREATE TABLE t1; 409ALTER TABLE t1 ADD UNIQUE INDEX (c1); 410SHOW TABLES; 411let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 412--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 413 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 414CREATE TABLE t1(c1 FLOAT NOT NULL); 415SHOW TABLES; 416let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 417--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 418 SHOW CREATE TABLE t1; 419ALTER TABLE t1 ADD UNIQUE INDEX (c1); 420SHOW TABLES; 421let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 422--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 423 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 424CREATE TABLE t1(c1 DECIMAL NOT NULL); 425SHOW TABLES; 426let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 427--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 428 SHOW CREATE TABLE t1; 429ALTER TABLE t1 ADD UNIQUE INDEX (c1); 430SHOW TABLES; 431let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 432--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 433 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 434CREATE TABLE t1(c1 NUMERIC NOT NULL); 435SHOW TABLES; 436let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 437--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 438 SHOW CREATE TABLE t1; 439ALTER TABLE t1 ADD UNIQUE INDEX (c1); 440SHOW TABLES; 441let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 442--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 443 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 444CREATE TABLE t1(c1 DATE NOT NULL); 445SHOW TABLES; 446let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 447--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 448 SHOW CREATE TABLE t1; 449ALTER TABLE t1 ADD UNIQUE INDEX (c1); 450SHOW TABLES; 451let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 452--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 453 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 454CREATE TABLE t1(c1 TIME NOT NULL); 455SHOW TABLES; 456let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 457--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 458 SHOW CREATE TABLE t1; 459ALTER TABLE t1 ADD UNIQUE INDEX (c1); 460SHOW TABLES; 461let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 462--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 463 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 464CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 465SHOW TABLES; 466let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 467--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 468 SHOW CREATE TABLE t1; 469ALTER TABLE t1 ADD UNIQUE INDEX (c1); 470SHOW TABLES; 471let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 472--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 473 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 474CREATE TABLE t1(c1 YEAR NOT NULL); 475SHOW TABLES; 476let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 477--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 478 SHOW CREATE TABLE t1; 479ALTER TABLE t1 ADD UNIQUE INDEX (c1); 480SHOW TABLES; 481let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 482--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 483 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 484CREATE TABLE t1(c1 BIT NOT NULL); 485SHOW TABLES; 486let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 487--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 488 SHOW CREATE TABLE t1; 489ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 490SHOW TABLES; 491let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 492--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 493 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 494CREATE TABLE t1(c1 TINYINT NOT NULL); 495SHOW TABLES; 496let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 497--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 498 SHOW CREATE TABLE t1; 499ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 500SHOW TABLES; 501let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 502--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 503 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 504CREATE TABLE t1(c1 SMALLINT NOT NULL); 505SHOW TABLES; 506let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 507--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 508 SHOW CREATE TABLE t1; 509ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 510SHOW TABLES; 511let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 512--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 513 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 514CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 515SHOW TABLES; 516let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 517--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 518 SHOW CREATE TABLE t1; 519ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 520SHOW TABLES; 521let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 522--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 523 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 524CREATE TABLE t1(c1 INT NOT NULL); 525SHOW TABLES; 526let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 527--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 528 SHOW CREATE TABLE t1; 529ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 530SHOW TABLES; 531let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 532--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 533 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 534CREATE TABLE t1(c1 INTEGER NOT NULL); 535SHOW TABLES; 536let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 537--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 538 SHOW CREATE TABLE t1; 539ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 540SHOW TABLES; 541let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 542--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 543 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 544CREATE TABLE t1(c1 BIGINT NOT NULL); 545SHOW TABLES; 546let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 547--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 548 SHOW CREATE TABLE t1; 549ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 550SHOW TABLES; 551let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 552--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 553 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 554CREATE TABLE t1(c1 REAL NOT NULL); 555SHOW TABLES; 556let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 557--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 558 SHOW CREATE TABLE t1; 559ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 560SHOW TABLES; 561let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 562--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 563 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 564CREATE TABLE t1(c1 DOUBLE NOT NULL); 565SHOW TABLES; 566let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 567--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 568 SHOW CREATE TABLE t1; 569ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 570SHOW TABLES; 571let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 572--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 573 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 574CREATE TABLE t1(c1 FLOAT NOT NULL); 575SHOW TABLES; 576let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 577--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 578 SHOW CREATE TABLE t1; 579ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 580SHOW TABLES; 581let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 582--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 583 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 584CREATE TABLE t1(c1 DECIMAL NOT NULL); 585SHOW TABLES; 586let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 587--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 588 SHOW CREATE TABLE t1; 589ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 590SHOW TABLES; 591let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 592--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 593 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 594CREATE TABLE t1(c1 NUMERIC NOT NULL); 595SHOW TABLES; 596let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 597--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 598 SHOW CREATE TABLE t1; 599ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 600SHOW TABLES; 601let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 602--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 603 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 604CREATE TABLE t1(c1 DATE NOT NULL); 605SHOW TABLES; 606let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 607--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 608 SHOW CREATE TABLE t1; 609ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 610SHOW TABLES; 611let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 612--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 613 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 614CREATE TABLE t1(c1 TIME NOT NULL); 615SHOW TABLES; 616let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 617--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 618 SHOW CREATE TABLE t1; 619ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 620SHOW TABLES; 621let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 622--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 623 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 624CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 625SHOW TABLES; 626let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 627--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 628 SHOW CREATE TABLE t1; 629ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 630SHOW TABLES; 631let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 632--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 633 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 634CREATE TABLE t1(c1 YEAR NOT NULL); 635SHOW TABLES; 636let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 637--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 638 SHOW CREATE TABLE t1; 639ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 640SHOW TABLES; 641let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 642--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 643 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 644CREATE TABLE t1(c1 BIT NOT NULL); 645SHOW TABLES; 646let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 647--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 648 SHOW CREATE TABLE t1; 649ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 650SHOW TABLES; 651let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 652--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 653 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 654CREATE TABLE t1(c1 TINYINT NOT NULL); 655SHOW TABLES; 656let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 657--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 658 SHOW CREATE TABLE t1; 659ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 660SHOW TABLES; 661let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 662--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 663 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 664CREATE TABLE t1(c1 SMALLINT NOT NULL); 665SHOW TABLES; 666let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 667--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 668 SHOW CREATE TABLE t1; 669ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 670SHOW TABLES; 671let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 672--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 673 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 674CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 675SHOW TABLES; 676let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 677--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 678 SHOW CREATE TABLE t1; 679ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 680SHOW TABLES; 681let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 682--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 683 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 684CREATE TABLE t1(c1 INT NOT NULL); 685SHOW TABLES; 686let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 687--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 688 SHOW CREATE TABLE t1; 689ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 690SHOW TABLES; 691let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 692--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 693 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 694CREATE TABLE t1(c1 INTEGER NOT NULL); 695SHOW TABLES; 696let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 697--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 698 SHOW CREATE TABLE t1; 699ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 700SHOW TABLES; 701let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 702--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 703 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 704CREATE TABLE t1(c1 BIGINT NOT NULL); 705SHOW TABLES; 706let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 707--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 708 SHOW CREATE TABLE t1; 709ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 710SHOW TABLES; 711let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 712--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 713 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 714CREATE TABLE t1(c1 REAL NOT NULL); 715SHOW TABLES; 716let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 717--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 718 SHOW CREATE TABLE t1; 719ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 720SHOW TABLES; 721let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 722--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 723 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 724CREATE TABLE t1(c1 DOUBLE NOT NULL); 725SHOW TABLES; 726let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 727--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 728 SHOW CREATE TABLE t1; 729ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 730SHOW TABLES; 731let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 732--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 733 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 734CREATE TABLE t1(c1 FLOAT NOT NULL); 735SHOW TABLES; 736let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 737--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 738 SHOW CREATE TABLE t1; 739ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 740SHOW TABLES; 741let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 742--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 743 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 744CREATE TABLE t1(c1 DECIMAL NOT NULL); 745SHOW TABLES; 746let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 747--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 748 SHOW CREATE TABLE t1; 749ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 750SHOW TABLES; 751let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 752--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 753 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 754CREATE TABLE t1(c1 NUMERIC NOT NULL); 755SHOW TABLES; 756let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 757--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 758 SHOW CREATE TABLE t1; 759ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 760SHOW TABLES; 761let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 762--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 763 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 764CREATE TABLE t1(c1 DATE NOT NULL); 765SHOW TABLES; 766let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 767--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 768 SHOW CREATE TABLE t1; 769ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 770SHOW TABLES; 771let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 772--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 773 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 774CREATE TABLE t1(c1 TIME NOT NULL); 775SHOW TABLES; 776let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 777--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 778 SHOW CREATE TABLE t1; 779ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 780SHOW TABLES; 781let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 782--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 783 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 784CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 785SHOW TABLES; 786let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 787--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 788 SHOW CREATE TABLE t1; 789ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 790SHOW TABLES; 791let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 792--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 793 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 794CREATE TABLE t1(c1 YEAR NOT NULL); 795SHOW TABLES; 796let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 797--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 798 SHOW CREATE TABLE t1; 799ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 800SHOW TABLES; 801let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 802--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 803 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 804CREATE TABLE t1(c1 BIT NOT NULL); 805SHOW TABLES; 806let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 807--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 808 SHOW CREATE TABLE t1; 809ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 810SHOW TABLES; 811let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 812--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 813 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 814CREATE TABLE t1(c1 TINYINT NOT NULL); 815SHOW TABLES; 816let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 817--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 818 SHOW CREATE TABLE t1; 819ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 820SHOW TABLES; 821let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 822--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 823 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 824CREATE TABLE t1(c1 SMALLINT NOT NULL); 825SHOW TABLES; 826let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 827--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 828 SHOW CREATE TABLE t1; 829ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 830SHOW TABLES; 831let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 832--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 833 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 834CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 835SHOW TABLES; 836let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 837--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 838 SHOW CREATE TABLE t1; 839ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 840SHOW TABLES; 841let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 842--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 843 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 844CREATE TABLE t1(c1 INT NOT NULL); 845SHOW TABLES; 846let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 847--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 848 SHOW CREATE TABLE t1; 849ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 850SHOW TABLES; 851let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 852--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 853 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 854CREATE TABLE t1(c1 INTEGER NOT NULL); 855SHOW TABLES; 856let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 857--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 858 SHOW CREATE TABLE t1; 859ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 860SHOW TABLES; 861let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 862--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 863 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 864CREATE TABLE t1(c1 BIGINT NOT NULL); 865SHOW TABLES; 866let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 867--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 868 SHOW CREATE TABLE t1; 869ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 870SHOW TABLES; 871let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 872--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 873 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 874CREATE TABLE t1(c1 REAL NOT NULL); 875SHOW TABLES; 876let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 877--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 878 SHOW CREATE TABLE t1; 879ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 880SHOW TABLES; 881let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 882--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 883 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 884CREATE TABLE t1(c1 DOUBLE NOT NULL); 885SHOW TABLES; 886let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 887--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 888 SHOW CREATE TABLE t1; 889ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 890SHOW TABLES; 891let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 892--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 893 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 894CREATE TABLE t1(c1 FLOAT NOT NULL); 895SHOW TABLES; 896let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 897--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 898 SHOW CREATE TABLE t1; 899ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 900SHOW TABLES; 901let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 902--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 903 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 904CREATE TABLE t1(c1 DECIMAL NOT NULL); 905SHOW TABLES; 906let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 907--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 908 SHOW CREATE TABLE t1; 909ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 910SHOW TABLES; 911let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 912--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 913 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 914CREATE TABLE t1(c1 NUMERIC NOT NULL); 915SHOW TABLES; 916let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 917--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 918 SHOW CREATE TABLE t1; 919ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 920SHOW TABLES; 921let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 922--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 923 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 924CREATE TABLE t1(c1 DATE NOT NULL); 925SHOW TABLES; 926let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 927--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 928 SHOW CREATE TABLE t1; 929ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 930SHOW TABLES; 931let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 932--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 933 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 934CREATE TABLE t1(c1 TIME NOT NULL); 935SHOW TABLES; 936let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 937--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 938 SHOW CREATE TABLE t1; 939ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 940SHOW TABLES; 941let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 942--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 943 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 944CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 945SHOW TABLES; 946let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 947--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 948 SHOW CREATE TABLE t1; 949ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 950SHOW TABLES; 951let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 952--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 953 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 954CREATE TABLE t1(c1 YEAR NOT NULL); 955SHOW TABLES; 956let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 957--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 958 SHOW CREATE TABLE t1; 959ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 960SHOW TABLES; 961let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 962--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 963 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 964CREATE TABLE t1(c1 BIT NOT NULL); 965SHOW TABLES; 966let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 967--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 968 SHOW CREATE TABLE t1; 969ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 970SHOW TABLES; 971let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 972--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 973 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 974CREATE TABLE t1(c1 TINYINT NOT NULL); 975SHOW TABLES; 976let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 977--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 978 SHOW CREATE TABLE t1; 979ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 980SHOW TABLES; 981let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 982--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 983 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 984CREATE TABLE t1(c1 SMALLINT NOT NULL); 985SHOW TABLES; 986let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 987--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 988 SHOW CREATE TABLE t1; 989ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 990SHOW TABLES; 991let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 992--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 993 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 994CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 995SHOW TABLES; 996let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 997--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 998 SHOW CREATE TABLE t1; 999ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1000SHOW TABLES; 1001let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1002--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1003 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1004CREATE TABLE t1(c1 INT NOT NULL); 1005SHOW TABLES; 1006let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1007--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1008 SHOW CREATE TABLE t1; 1009ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1010SHOW TABLES; 1011let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1012--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1013 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1014CREATE TABLE t1(c1 INTEGER NOT NULL); 1015SHOW TABLES; 1016let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1017--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1018 SHOW CREATE TABLE t1; 1019ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1020SHOW TABLES; 1021let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1022--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1023 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1024CREATE TABLE t1(c1 BIGINT NOT NULL); 1025SHOW TABLES; 1026let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1027--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1028 SHOW CREATE TABLE t1; 1029ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1030SHOW TABLES; 1031let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1032--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1033 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1034CREATE TABLE t1(c1 REAL NOT NULL); 1035SHOW TABLES; 1036let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1037--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1038 SHOW CREATE TABLE t1; 1039ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1040SHOW TABLES; 1041let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1042--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1043 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1044CREATE TABLE t1(c1 DOUBLE NOT NULL); 1045SHOW TABLES; 1046let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1047--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1048 SHOW CREATE TABLE t1; 1049ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1050SHOW TABLES; 1051let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1052--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1053 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1054CREATE TABLE t1(c1 FLOAT NOT NULL); 1055SHOW TABLES; 1056let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1057--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1058 SHOW CREATE TABLE t1; 1059ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1060SHOW TABLES; 1061let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1062--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1063 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1064CREATE TABLE t1(c1 DECIMAL NOT NULL); 1065SHOW TABLES; 1066let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1067--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1068 SHOW CREATE TABLE t1; 1069ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1070SHOW TABLES; 1071let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1072--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1073 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1074CREATE TABLE t1(c1 NUMERIC NOT NULL); 1075SHOW TABLES; 1076let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1077--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1078 SHOW CREATE TABLE t1; 1079ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1080SHOW TABLES; 1081let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1082--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1083 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1084CREATE TABLE t1(c1 DATE NOT NULL); 1085SHOW TABLES; 1086let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1087--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1088 SHOW CREATE TABLE t1; 1089ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1090SHOW TABLES; 1091let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1092--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1093 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1094CREATE TABLE t1(c1 TIME NOT NULL); 1095SHOW TABLES; 1096let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1097--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1098 SHOW CREATE TABLE t1; 1099ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1100SHOW TABLES; 1101let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1103 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1104CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1105SHOW TABLES; 1106let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1107--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1108 SHOW CREATE TABLE t1; 1109ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1110SHOW TABLES; 1111let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1112--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1113 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1114CREATE TABLE t1(c1 YEAR NOT NULL); 1115SHOW TABLES; 1116let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1117--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1118 SHOW CREATE TABLE t1; 1119ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 1120SHOW TABLES; 1121let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1123 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1124CREATE TABLE t1(c1 BIT NOT NULL); 1125SHOW TABLES; 1126let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1127--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1128 SHOW CREATE TABLE t1; 1129ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1130SHOW TABLES; 1131let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1132--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1133 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1134CREATE TABLE t1(c1 TINYINT NOT NULL); 1135SHOW TABLES; 1136let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1137--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1138 SHOW CREATE TABLE t1; 1139ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1140SHOW TABLES; 1141let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1144CREATE TABLE t1(c1 SMALLINT NOT NULL); 1145SHOW TABLES; 1146let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1147--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1148 SHOW CREATE TABLE t1; 1149ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1150SHOW TABLES; 1151let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1152--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1153 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1154CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1155SHOW TABLES; 1156let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1157--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1158 SHOW CREATE TABLE t1; 1159ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1160SHOW TABLES; 1161let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1163 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1164CREATE TABLE t1(c1 INT NOT NULL); 1165SHOW TABLES; 1166let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1167--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1168 SHOW CREATE TABLE t1; 1169ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1170SHOW TABLES; 1171let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1172--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1173 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1174CREATE TABLE t1(c1 INTEGER NOT NULL); 1175SHOW TABLES; 1176let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1177--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1178 SHOW CREATE TABLE t1; 1179ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1180SHOW TABLES; 1181let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1183 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1184CREATE TABLE t1(c1 BIGINT NOT NULL); 1185SHOW TABLES; 1186let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1187--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1188 SHOW CREATE TABLE t1; 1189ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1190SHOW TABLES; 1191let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1192--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1193 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1194CREATE TABLE t1(c1 REAL NOT NULL); 1195SHOW TABLES; 1196let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1197--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1198 SHOW CREATE TABLE t1; 1199ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1200SHOW TABLES; 1201let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1203 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1204CREATE TABLE t1(c1 DOUBLE NOT NULL); 1205SHOW TABLES; 1206let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1207--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1208 SHOW CREATE TABLE t1; 1209ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1210SHOW TABLES; 1211let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1212--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1213 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1214CREATE TABLE t1(c1 FLOAT NOT NULL); 1215SHOW TABLES; 1216let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1217--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1218 SHOW CREATE TABLE t1; 1219ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1220SHOW TABLES; 1221let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1223 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1224CREATE TABLE t1(c1 DECIMAL NOT NULL); 1225SHOW TABLES; 1226let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1227--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1228 SHOW CREATE TABLE t1; 1229ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1230SHOW TABLES; 1231let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1232--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1234CREATE TABLE t1(c1 NUMERIC NOT NULL); 1235SHOW TABLES; 1236let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1237--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1238 SHOW CREATE TABLE t1; 1239ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1240SHOW TABLES; 1241let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1243 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1244CREATE TABLE t1(c1 DATE NOT NULL); 1245SHOW TABLES; 1246let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1247--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1248 SHOW CREATE TABLE t1; 1249ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1250SHOW TABLES; 1251let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1252--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1253 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1254CREATE TABLE t1(c1 TIME NOT NULL); 1255SHOW TABLES; 1256let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1257--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1258 SHOW CREATE TABLE t1; 1259ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1260SHOW TABLES; 1261let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1263 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1264CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1265SHOW TABLES; 1266let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1267--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1268 SHOW CREATE TABLE t1; 1269ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1270SHOW TABLES; 1271let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1272--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1273 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1274CREATE TABLE t1(c1 YEAR NOT NULL); 1275SHOW TABLES; 1276let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1277--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1278 SHOW CREATE TABLE t1; 1279ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 1280SHOW TABLES; 1281let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1283 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1284CREATE TABLE t1(c1 BIT NOT NULL); 1285SHOW TABLES; 1286let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1287--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1288 SHOW CREATE TABLE t1; 1289ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1290SHOW TABLES; 1291let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1292--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1293 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1294CREATE TABLE t1(c1 TINYINT NOT NULL); 1295SHOW TABLES; 1296let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1297--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1298 SHOW CREATE TABLE t1; 1299ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1300SHOW TABLES; 1301let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1303 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1304CREATE TABLE t1(c1 SMALLINT NOT NULL); 1305SHOW TABLES; 1306let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1307--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1308 SHOW CREATE TABLE t1; 1309ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1310SHOW TABLES; 1311let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1312--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1313 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1314CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1315SHOW TABLES; 1316let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1317--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1318 SHOW CREATE TABLE t1; 1319ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1320SHOW TABLES; 1321let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1323 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1324CREATE TABLE t1(c1 INT NOT NULL); 1325SHOW TABLES; 1326let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1327--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1328 SHOW CREATE TABLE t1; 1329ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1330SHOW TABLES; 1331let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1332--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1333 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1334CREATE TABLE t1(c1 INTEGER NOT NULL); 1335SHOW TABLES; 1336let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1337--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1338 SHOW CREATE TABLE t1; 1339ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1340SHOW TABLES; 1341let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1343 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1344CREATE TABLE t1(c1 BIGINT NOT NULL); 1345SHOW TABLES; 1346let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1347--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1348 SHOW CREATE TABLE t1; 1349ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1350SHOW TABLES; 1351let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1352--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1353 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1354CREATE TABLE t1(c1 REAL NOT NULL); 1355SHOW TABLES; 1356let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1357--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1358 SHOW CREATE TABLE t1; 1359ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1360SHOW TABLES; 1361let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1363 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1364CREATE TABLE t1(c1 DOUBLE NOT NULL); 1365SHOW TABLES; 1366let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1367--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1368 SHOW CREATE TABLE t1; 1369ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1370SHOW TABLES; 1371let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1372--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1373 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1374CREATE TABLE t1(c1 FLOAT NOT NULL); 1375SHOW TABLES; 1376let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1377--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1378 SHOW CREATE TABLE t1; 1379ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1380SHOW TABLES; 1381let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1383 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1384CREATE TABLE t1(c1 DECIMAL NOT NULL); 1385SHOW TABLES; 1386let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1387--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1388 SHOW CREATE TABLE t1; 1389ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1390SHOW TABLES; 1391let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1392--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1393 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1394CREATE TABLE t1(c1 NUMERIC NOT NULL); 1395SHOW TABLES; 1396let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1397--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1398 SHOW CREATE TABLE t1; 1399ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1400SHOW TABLES; 1401let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1402--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1403 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1404CREATE TABLE t1(c1 DATE NOT NULL); 1405SHOW TABLES; 1406let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1407--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1408 SHOW CREATE TABLE t1; 1409ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1410SHOW TABLES; 1411let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1412--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1413 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1414CREATE TABLE t1(c1 TIME NOT NULL); 1415SHOW TABLES; 1416let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1417--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1418 SHOW CREATE TABLE t1; 1419ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1420SHOW TABLES; 1421let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1422--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1423 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1424CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1425SHOW TABLES; 1426let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1427--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1428 SHOW CREATE TABLE t1; 1429ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1430SHOW TABLES; 1431let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1432--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1433 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1434CREATE TABLE t1(c1 YEAR NOT NULL); 1435SHOW TABLES; 1436let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1437--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1438 SHOW CREATE TABLE t1; 1439ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 1440SHOW TABLES; 1441let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1442--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1443 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1444CREATE TABLE t1(c1 BIT NOT NULL); 1445SHOW TABLES; 1446let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1447--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1448 SHOW CREATE TABLE t1; 1449ALTER TABLE t1 ADD UNIQUE i1 (c1); 1450SHOW TABLES; 1451let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1452--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1453 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1454CREATE TABLE t1(c1 TINYINT NOT NULL); 1455SHOW TABLES; 1456let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1457--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1458 SHOW CREATE TABLE t1; 1459ALTER TABLE t1 ADD UNIQUE i1 (c1); 1460SHOW TABLES; 1461let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1462--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1463 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1464CREATE TABLE t1(c1 SMALLINT NOT NULL); 1465SHOW TABLES; 1466let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1467--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1468 SHOW CREATE TABLE t1; 1469ALTER TABLE t1 ADD UNIQUE i1 (c1); 1470SHOW TABLES; 1471let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1472--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1473 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1474CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1475SHOW TABLES; 1476let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1477--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1478 SHOW CREATE TABLE t1; 1479ALTER TABLE t1 ADD UNIQUE i1 (c1); 1480SHOW TABLES; 1481let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1482--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1483 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1484CREATE TABLE t1(c1 INT NOT NULL); 1485SHOW TABLES; 1486let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1487--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1488 SHOW CREATE TABLE t1; 1489ALTER TABLE t1 ADD UNIQUE i1 (c1); 1490SHOW TABLES; 1491let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1492--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1493 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1494CREATE TABLE t1(c1 INTEGER NOT NULL); 1495SHOW TABLES; 1496let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1497--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1498 SHOW CREATE TABLE t1; 1499ALTER TABLE t1 ADD UNIQUE i1 (c1); 1500SHOW TABLES; 1501let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1502--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1503 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1504CREATE TABLE t1(c1 BIGINT NOT NULL); 1505SHOW TABLES; 1506let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1507--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1508 SHOW CREATE TABLE t1; 1509ALTER TABLE t1 ADD UNIQUE i1 (c1); 1510SHOW TABLES; 1511let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1512--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1513 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1514CREATE TABLE t1(c1 REAL NOT NULL); 1515SHOW TABLES; 1516let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1517--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1518 SHOW CREATE TABLE t1; 1519ALTER TABLE t1 ADD UNIQUE i1 (c1); 1520SHOW TABLES; 1521let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1522--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1523 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1524CREATE TABLE t1(c1 DOUBLE NOT NULL); 1525SHOW TABLES; 1526let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1527--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1528 SHOW CREATE TABLE t1; 1529ALTER TABLE t1 ADD UNIQUE i1 (c1); 1530SHOW TABLES; 1531let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1532--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1533 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1534CREATE TABLE t1(c1 FLOAT NOT NULL); 1535SHOW TABLES; 1536let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1537--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1538 SHOW CREATE TABLE t1; 1539ALTER TABLE t1 ADD UNIQUE i1 (c1); 1540SHOW TABLES; 1541let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1542--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1543 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1544CREATE TABLE t1(c1 DECIMAL NOT NULL); 1545SHOW TABLES; 1546let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1547--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1548 SHOW CREATE TABLE t1; 1549ALTER TABLE t1 ADD UNIQUE i1 (c1); 1550SHOW TABLES; 1551let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1552--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1553 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1554CREATE TABLE t1(c1 NUMERIC NOT NULL); 1555SHOW TABLES; 1556let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1557--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1558 SHOW CREATE TABLE t1; 1559ALTER TABLE t1 ADD UNIQUE i1 (c1); 1560SHOW TABLES; 1561let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1562--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1563 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1564CREATE TABLE t1(c1 DATE NOT NULL); 1565SHOW TABLES; 1566let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1567--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1568 SHOW CREATE TABLE t1; 1569ALTER TABLE t1 ADD UNIQUE i1 (c1); 1570SHOW TABLES; 1571let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1572--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1573 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1574CREATE TABLE t1(c1 TIME NOT NULL); 1575SHOW TABLES; 1576let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1577--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1578 SHOW CREATE TABLE t1; 1579ALTER TABLE t1 ADD UNIQUE i1 (c1); 1580SHOW TABLES; 1581let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1582--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1583 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1584CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1585SHOW TABLES; 1586let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1587--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1588 SHOW CREATE TABLE t1; 1589ALTER TABLE t1 ADD UNIQUE i1 (c1); 1590SHOW TABLES; 1591let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1592--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1593 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1594CREATE TABLE t1(c1 YEAR NOT NULL); 1595SHOW TABLES; 1596let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1597--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1598 SHOW CREATE TABLE t1; 1599ALTER TABLE t1 ADD UNIQUE i1 (c1); 1600SHOW TABLES; 1601let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1602--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1603 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1604CREATE TABLE t1(c1 BIT NOT NULL); 1605SHOW TABLES; 1606let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1607--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1608 SHOW CREATE TABLE t1; 1609ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1610SHOW TABLES; 1611let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1612--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1613 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1614CREATE TABLE t1(c1 TINYINT NOT NULL); 1615SHOW TABLES; 1616let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1617--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1618 SHOW CREATE TABLE t1; 1619ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1620SHOW TABLES; 1621let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1622--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1623 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1624CREATE TABLE t1(c1 SMALLINT NOT NULL); 1625SHOW TABLES; 1626let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1627--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1628 SHOW CREATE TABLE t1; 1629ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1630SHOW TABLES; 1631let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1632--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1633 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1634CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1635SHOW TABLES; 1636let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1637--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1638 SHOW CREATE TABLE t1; 1639ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1640SHOW TABLES; 1641let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1642--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1643 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1644CREATE TABLE t1(c1 INT NOT NULL); 1645SHOW TABLES; 1646let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1647--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1648 SHOW CREATE TABLE t1; 1649ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1650SHOW TABLES; 1651let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1652--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1653 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1654CREATE TABLE t1(c1 INTEGER NOT NULL); 1655SHOW TABLES; 1656let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1657--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1658 SHOW CREATE TABLE t1; 1659ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1660SHOW TABLES; 1661let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1662--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1663 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1664CREATE TABLE t1(c1 BIGINT NOT NULL); 1665SHOW TABLES; 1666let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1667--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1668 SHOW CREATE TABLE t1; 1669ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1670SHOW TABLES; 1671let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1672--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1673 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1674CREATE TABLE t1(c1 REAL NOT NULL); 1675SHOW TABLES; 1676let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1677--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1678 SHOW CREATE TABLE t1; 1679ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1680SHOW TABLES; 1681let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1682--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1683 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1684CREATE TABLE t1(c1 DOUBLE NOT NULL); 1685SHOW TABLES; 1686let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1687--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1688 SHOW CREATE TABLE t1; 1689ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1690SHOW TABLES; 1691let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1692--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1693 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1694CREATE TABLE t1(c1 FLOAT NOT NULL); 1695SHOW TABLES; 1696let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1697--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1698 SHOW CREATE TABLE t1; 1699ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1700SHOW TABLES; 1701let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1702--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1703 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1704CREATE TABLE t1(c1 DECIMAL NOT NULL); 1705SHOW TABLES; 1706let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1707--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1708 SHOW CREATE TABLE t1; 1709ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1710SHOW TABLES; 1711let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1712--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1713 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1714CREATE TABLE t1(c1 NUMERIC NOT NULL); 1715SHOW TABLES; 1716let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1717--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1718 SHOW CREATE TABLE t1; 1719ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1720SHOW TABLES; 1721let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1722--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1723 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1724CREATE TABLE t1(c1 DATE NOT NULL); 1725SHOW TABLES; 1726let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1727--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1728 SHOW CREATE TABLE t1; 1729ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1730SHOW TABLES; 1731let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1732--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1733 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1734CREATE TABLE t1(c1 TIME NOT NULL); 1735SHOW TABLES; 1736let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1737--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1738 SHOW CREATE TABLE t1; 1739ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1740SHOW TABLES; 1741let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1742--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1743 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1744CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1745SHOW TABLES; 1746let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1747--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1748 SHOW CREATE TABLE t1; 1749ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1750SHOW TABLES; 1751let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1752--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1753 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1754CREATE TABLE t1(c1 YEAR NOT NULL); 1755SHOW TABLES; 1756let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1757--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1758 SHOW CREATE TABLE t1; 1759ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 1760SHOW TABLES; 1761let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1762--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1763 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1764CREATE TABLE t1(c1 BIT NOT NULL); 1765SHOW TABLES; 1766let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1767--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1768 SHOW CREATE TABLE t1; 1769ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1770SHOW TABLES; 1771let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1772--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1773 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1774CREATE TABLE t1(c1 TINYINT NOT NULL); 1775SHOW TABLES; 1776let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1777--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1778 SHOW CREATE TABLE t1; 1779ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1780SHOW TABLES; 1781let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1782--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1783 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1784CREATE TABLE t1(c1 SMALLINT NOT NULL); 1785SHOW TABLES; 1786let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1787--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1788 SHOW CREATE TABLE t1; 1789ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1790SHOW TABLES; 1791let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1792--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1793 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1794CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1795SHOW TABLES; 1796let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1797--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1798 SHOW CREATE TABLE t1; 1799ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1800SHOW TABLES; 1801let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1802--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1803 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1804CREATE TABLE t1(c1 INT NOT NULL); 1805SHOW TABLES; 1806let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1807--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1808 SHOW CREATE TABLE t1; 1809ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1810SHOW TABLES; 1811let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1812--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1813 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1814CREATE TABLE t1(c1 INTEGER NOT NULL); 1815SHOW TABLES; 1816let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1817--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1818 SHOW CREATE TABLE t1; 1819ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1820SHOW TABLES; 1821let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1822--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1823 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1824CREATE TABLE t1(c1 BIGINT NOT NULL); 1825SHOW TABLES; 1826let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1827--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1828 SHOW CREATE TABLE t1; 1829ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1830SHOW TABLES; 1831let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1832--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1833 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1834CREATE TABLE t1(c1 REAL NOT NULL); 1835SHOW TABLES; 1836let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1837--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1838 SHOW CREATE TABLE t1; 1839ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1840SHOW TABLES; 1841let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1842--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1843 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1844CREATE TABLE t1(c1 DOUBLE NOT NULL); 1845SHOW TABLES; 1846let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1847--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1848 SHOW CREATE TABLE t1; 1849ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1850SHOW TABLES; 1851let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1852--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1853 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1854CREATE TABLE t1(c1 FLOAT NOT NULL); 1855SHOW TABLES; 1856let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1857--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1858 SHOW CREATE TABLE t1; 1859ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1860SHOW TABLES; 1861let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1862--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1863 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1864CREATE TABLE t1(c1 DECIMAL NOT NULL); 1865SHOW TABLES; 1866let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1867--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1868 SHOW CREATE TABLE t1; 1869ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1870SHOW TABLES; 1871let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1872--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1873 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1874CREATE TABLE t1(c1 NUMERIC NOT NULL); 1875SHOW TABLES; 1876let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1877--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1878 SHOW CREATE TABLE t1; 1879ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1880SHOW TABLES; 1881let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1882--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1883 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1884CREATE TABLE t1(c1 DATE NOT NULL); 1885SHOW TABLES; 1886let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1887--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1888 SHOW CREATE TABLE t1; 1889ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1890SHOW TABLES; 1891let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1892--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1893 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1894CREATE TABLE t1(c1 TIME NOT NULL); 1895SHOW TABLES; 1896let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1897--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1898 SHOW CREATE TABLE t1; 1899ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1900SHOW TABLES; 1901let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1902--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1903 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1904CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1905SHOW TABLES; 1906let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1907--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1908 SHOW CREATE TABLE t1; 1909ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1910SHOW TABLES; 1911let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1912--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1913 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1914CREATE TABLE t1(c1 YEAR NOT NULL); 1915SHOW TABLES; 1916let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1917--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1918 SHOW CREATE TABLE t1; 1919ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 1920SHOW TABLES; 1921let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1922--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1923 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1924CREATE TABLE t1(c1 BIT NOT NULL); 1925SHOW TABLES; 1926let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1927--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1928 SHOW CREATE TABLE t1; 1929ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1930SHOW TABLES; 1931let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1932--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1933 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1934CREATE TABLE t1(c1 TINYINT NOT NULL); 1935SHOW TABLES; 1936let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1937--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1938 SHOW CREATE TABLE t1; 1939ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1940SHOW TABLES; 1941let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1942--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1943 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1944CREATE TABLE t1(c1 SMALLINT NOT NULL); 1945SHOW TABLES; 1946let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1947--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1948 SHOW CREATE TABLE t1; 1949ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1950SHOW TABLES; 1951let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1952--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1953 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1954CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1955SHOW TABLES; 1956let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1957--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1958 SHOW CREATE TABLE t1; 1959ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1960SHOW TABLES; 1961let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1962--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1963 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1964CREATE TABLE t1(c1 INT NOT NULL); 1965SHOW TABLES; 1966let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1967--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1968 SHOW CREATE TABLE t1; 1969ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1970SHOW TABLES; 1971let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1972--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1973 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1974CREATE TABLE t1(c1 INTEGER NOT NULL); 1975SHOW TABLES; 1976let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1977--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1978 SHOW CREATE TABLE t1; 1979ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1980SHOW TABLES; 1981let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1982--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1983 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1984CREATE TABLE t1(c1 BIGINT NOT NULL); 1985SHOW TABLES; 1986let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1987--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1988 SHOW CREATE TABLE t1; 1989ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 1990SHOW TABLES; 1991let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1992--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1993 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 1994CREATE TABLE t1(c1 REAL NOT NULL); 1995SHOW TABLES; 1996let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 1997--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 1998 SHOW CREATE TABLE t1; 1999ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2000SHOW TABLES; 2001let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2002--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2003 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2004CREATE TABLE t1(c1 DOUBLE NOT NULL); 2005SHOW TABLES; 2006let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2007--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2008 SHOW CREATE TABLE t1; 2009ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2010SHOW TABLES; 2011let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2012--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2013 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2014CREATE TABLE t1(c1 FLOAT NOT NULL); 2015SHOW TABLES; 2016let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2017--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2018 SHOW CREATE TABLE t1; 2019ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2020SHOW TABLES; 2021let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2022--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2023 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2024CREATE TABLE t1(c1 DECIMAL NOT NULL); 2025SHOW TABLES; 2026let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2027--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2028 SHOW CREATE TABLE t1; 2029ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2030SHOW TABLES; 2031let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2032--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2033 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2034CREATE TABLE t1(c1 NUMERIC NOT NULL); 2035SHOW TABLES; 2036let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2037--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2038 SHOW CREATE TABLE t1; 2039ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2040SHOW TABLES; 2041let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2042--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2043 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2044CREATE TABLE t1(c1 DATE NOT NULL); 2045SHOW TABLES; 2046let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2047--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2048 SHOW CREATE TABLE t1; 2049ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2050SHOW TABLES; 2051let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2052--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2053 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2054CREATE TABLE t1(c1 TIME NOT NULL); 2055SHOW TABLES; 2056let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2057--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2058 SHOW CREATE TABLE t1; 2059ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2060SHOW TABLES; 2061let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2062--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2063 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2064CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2065SHOW TABLES; 2066let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2067--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2068 SHOW CREATE TABLE t1; 2069ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2070SHOW TABLES; 2071let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2072--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2073 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2074CREATE TABLE t1(c1 YEAR NOT NULL); 2075SHOW TABLES; 2076let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2077--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2078 SHOW CREATE TABLE t1; 2079ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 2080SHOW TABLES; 2081let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2082--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2083 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2084CREATE TABLE t1(c1 BIT NOT NULL); 2085SHOW TABLES; 2086let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2087--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2088 SHOW CREATE TABLE t1; 2089ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2090SHOW TABLES; 2091let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2092--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2093 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2094CREATE TABLE t1(c1 TINYINT NOT NULL); 2095SHOW TABLES; 2096let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2097--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2098 SHOW CREATE TABLE t1; 2099ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2100SHOW TABLES; 2101let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2103 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2104CREATE TABLE t1(c1 SMALLINT NOT NULL); 2105SHOW TABLES; 2106let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2107--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2108 SHOW CREATE TABLE t1; 2109ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2110SHOW TABLES; 2111let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2112--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2113 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2114CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2115SHOW TABLES; 2116let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2117--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2118 SHOW CREATE TABLE t1; 2119ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2120SHOW TABLES; 2121let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2123 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2124CREATE TABLE t1(c1 INT NOT NULL); 2125SHOW TABLES; 2126let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2127--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2128 SHOW CREATE TABLE t1; 2129ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2130SHOW TABLES; 2131let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2132--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2133 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2134CREATE TABLE t1(c1 INTEGER NOT NULL); 2135SHOW TABLES; 2136let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2137--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2138 SHOW CREATE TABLE t1; 2139ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2140SHOW TABLES; 2141let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2144CREATE TABLE t1(c1 BIGINT NOT NULL); 2145SHOW TABLES; 2146let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2147--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2148 SHOW CREATE TABLE t1; 2149ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2150SHOW TABLES; 2151let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2152--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2153 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2154CREATE TABLE t1(c1 REAL NOT NULL); 2155SHOW TABLES; 2156let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2157--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2158 SHOW CREATE TABLE t1; 2159ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2160SHOW TABLES; 2161let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2163 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2164CREATE TABLE t1(c1 DOUBLE NOT NULL); 2165SHOW TABLES; 2166let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2167--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2168 SHOW CREATE TABLE t1; 2169ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2170SHOW TABLES; 2171let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2172--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2173 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2174CREATE TABLE t1(c1 FLOAT NOT NULL); 2175SHOW TABLES; 2176let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2177--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2178 SHOW CREATE TABLE t1; 2179ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2180SHOW TABLES; 2181let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2183 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2184CREATE TABLE t1(c1 DECIMAL NOT NULL); 2185SHOW TABLES; 2186let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2187--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2188 SHOW CREATE TABLE t1; 2189ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2190SHOW TABLES; 2191let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2192--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2193 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2194CREATE TABLE t1(c1 NUMERIC NOT NULL); 2195SHOW TABLES; 2196let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2197--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2198 SHOW CREATE TABLE t1; 2199ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2200SHOW TABLES; 2201let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2202--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2203 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2204CREATE TABLE t1(c1 DATE NOT NULL); 2205SHOW TABLES; 2206let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2207--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2208 SHOW CREATE TABLE t1; 2209ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2210SHOW TABLES; 2211let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2212--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2213 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2214CREATE TABLE t1(c1 TIME NOT NULL); 2215SHOW TABLES; 2216let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2217--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2218 SHOW CREATE TABLE t1; 2219ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2220SHOW TABLES; 2221let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2222--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2223 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2224CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2225SHOW TABLES; 2226let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2227--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2228 SHOW CREATE TABLE t1; 2229ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2230SHOW TABLES; 2231let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2232--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2234CREATE TABLE t1(c1 YEAR NOT NULL); 2235SHOW TABLES; 2236let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2237--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2238 SHOW CREATE TABLE t1; 2239ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 2240SHOW TABLES; 2241let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2242--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2243 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2244CREATE TABLE t1(c1 BIT NOT NULL); 2245SHOW TABLES; 2246let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2247--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2248 SHOW CREATE TABLE t1; 2249ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2250SHOW TABLES; 2251let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2252--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2253 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2254CREATE TABLE t1(c1 TINYINT NOT NULL); 2255SHOW TABLES; 2256let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2257--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2258 SHOW CREATE TABLE t1; 2259ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2260SHOW TABLES; 2261let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2262--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2263 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2264CREATE TABLE t1(c1 SMALLINT NOT NULL); 2265SHOW TABLES; 2266let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2267--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2268 SHOW CREATE TABLE t1; 2269ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2270SHOW TABLES; 2271let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2272--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2273 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2274CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2275SHOW TABLES; 2276let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2277--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2278 SHOW CREATE TABLE t1; 2279ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2280SHOW TABLES; 2281let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2282--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2283 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2284CREATE TABLE t1(c1 INT NOT NULL); 2285SHOW TABLES; 2286let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2287--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2288 SHOW CREATE TABLE t1; 2289ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2290SHOW TABLES; 2291let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2292--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2293 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2294CREATE TABLE t1(c1 INTEGER NOT NULL); 2295SHOW TABLES; 2296let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2297--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2298 SHOW CREATE TABLE t1; 2299ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2300SHOW TABLES; 2301let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2302--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2303 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2304CREATE TABLE t1(c1 BIGINT NOT NULL); 2305SHOW TABLES; 2306let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2307--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2308 SHOW CREATE TABLE t1; 2309ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2310SHOW TABLES; 2311let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2312--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2313 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2314CREATE TABLE t1(c1 REAL NOT NULL); 2315SHOW TABLES; 2316let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2317--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2318 SHOW CREATE TABLE t1; 2319ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2320SHOW TABLES; 2321let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2322--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2323 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2324CREATE TABLE t1(c1 DOUBLE NOT NULL); 2325SHOW TABLES; 2326let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2327--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2328 SHOW CREATE TABLE t1; 2329ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2330SHOW TABLES; 2331let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2332--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2333 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2334CREATE TABLE t1(c1 FLOAT NOT NULL); 2335SHOW TABLES; 2336let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2337--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2338 SHOW CREATE TABLE t1; 2339ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2340SHOW TABLES; 2341let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2342--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2343 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2344CREATE TABLE t1(c1 DECIMAL NOT NULL); 2345SHOW TABLES; 2346let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2347--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2348 SHOW CREATE TABLE t1; 2349ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2350SHOW TABLES; 2351let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2352--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2353 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2354CREATE TABLE t1(c1 NUMERIC NOT NULL); 2355SHOW TABLES; 2356let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2357--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2358 SHOW CREATE TABLE t1; 2359ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2360SHOW TABLES; 2361let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2362--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2363 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2364CREATE TABLE t1(c1 DATE NOT NULL); 2365SHOW TABLES; 2366let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2367--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2368 SHOW CREATE TABLE t1; 2369ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2370SHOW TABLES; 2371let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2372--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2373 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2374CREATE TABLE t1(c1 TIME NOT NULL); 2375SHOW TABLES; 2376let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2377--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2378 SHOW CREATE TABLE t1; 2379ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2380SHOW TABLES; 2381let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2382--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2383 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2384CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2385SHOW TABLES; 2386let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2387--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2388 SHOW CREATE TABLE t1; 2389ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2390SHOW TABLES; 2391let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2392--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2393 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2394CREATE TABLE t1(c1 YEAR NOT NULL); 2395SHOW TABLES; 2396let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2397--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2398 SHOW CREATE TABLE t1; 2399ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 2400SHOW TABLES; 2401let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2402--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2403 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2404CREATE TABLE t1(c1 BIT NOT NULL); 2405SHOW TABLES; 2406let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2407--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2408 SHOW CREATE TABLE t1; 2409ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2410SHOW TABLES; 2411let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2412--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2413 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2414CREATE TABLE t1(c1 TINYINT NOT NULL); 2415SHOW TABLES; 2416let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2417--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2418 SHOW CREATE TABLE t1; 2419ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2420SHOW TABLES; 2421let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2422--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2423 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2424CREATE TABLE t1(c1 SMALLINT NOT NULL); 2425SHOW TABLES; 2426let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2427--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2428 SHOW CREATE TABLE t1; 2429ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2430SHOW TABLES; 2431let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2432--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2433 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2434CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2435SHOW TABLES; 2436let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2437--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2438 SHOW CREATE TABLE t1; 2439ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2440SHOW TABLES; 2441let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2442--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2443 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2444CREATE TABLE t1(c1 INT NOT NULL); 2445SHOW TABLES; 2446let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2447--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2448 SHOW CREATE TABLE t1; 2449ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2450SHOW TABLES; 2451let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2452--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2453 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2454CREATE TABLE t1(c1 INTEGER NOT NULL); 2455SHOW TABLES; 2456let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2457--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2458 SHOW CREATE TABLE t1; 2459ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2460SHOW TABLES; 2461let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2462--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2463 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2464CREATE TABLE t1(c1 BIGINT NOT NULL); 2465SHOW TABLES; 2466let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2467--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2468 SHOW CREATE TABLE t1; 2469ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2470SHOW TABLES; 2471let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2472--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2473 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2474CREATE TABLE t1(c1 REAL NOT NULL); 2475SHOW TABLES; 2476let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2477--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2478 SHOW CREATE TABLE t1; 2479ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2480SHOW TABLES; 2481let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2482--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2483 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2484CREATE TABLE t1(c1 DOUBLE NOT NULL); 2485SHOW TABLES; 2486let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2487--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2488 SHOW CREATE TABLE t1; 2489ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2490SHOW TABLES; 2491let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2492--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2493 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2494CREATE TABLE t1(c1 FLOAT NOT NULL); 2495SHOW TABLES; 2496let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2497--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2498 SHOW CREATE TABLE t1; 2499ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2500SHOW TABLES; 2501let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2502--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2503 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2504CREATE TABLE t1(c1 DECIMAL NOT NULL); 2505SHOW TABLES; 2506let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2507--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2508 SHOW CREATE TABLE t1; 2509ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2510SHOW TABLES; 2511let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2512--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2513 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2514CREATE TABLE t1(c1 NUMERIC NOT NULL); 2515SHOW TABLES; 2516let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2517--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2518 SHOW CREATE TABLE t1; 2519ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2520SHOW TABLES; 2521let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2522--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2523 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2524CREATE TABLE t1(c1 DATE NOT NULL); 2525SHOW TABLES; 2526let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2527--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2528 SHOW CREATE TABLE t1; 2529ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2530SHOW TABLES; 2531let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2532--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2533 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2534CREATE TABLE t1(c1 TIME NOT NULL); 2535SHOW TABLES; 2536let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2537--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2538 SHOW CREATE TABLE t1; 2539ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2540SHOW TABLES; 2541let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2542--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2543 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2544CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2545SHOW TABLES; 2546let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2547--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2548 SHOW CREATE TABLE t1; 2549ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2550SHOW TABLES; 2551let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2552--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2553 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2554CREATE TABLE t1(c1 YEAR NOT NULL); 2555SHOW TABLES; 2556let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2557--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2558 SHOW CREATE TABLE t1; 2559ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 2560SHOW TABLES; 2561let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2562--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2563 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2564CREATE TABLE t1(c1 BIT NOT NULL); 2565SHOW TABLES; 2566let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2567--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2568 SHOW CREATE TABLE t1; 2569ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2570SHOW TABLES; 2571let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2572--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2573 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2574CREATE TABLE t1(c1 TINYINT NOT NULL); 2575SHOW TABLES; 2576let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2577--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2578 SHOW CREATE TABLE t1; 2579ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2580SHOW TABLES; 2581let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2582--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2583 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2584CREATE TABLE t1(c1 SMALLINT NOT NULL); 2585SHOW TABLES; 2586let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2587--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2588 SHOW CREATE TABLE t1; 2589ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2590SHOW TABLES; 2591let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2592--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2593 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2594CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2595SHOW TABLES; 2596let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2597--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2598 SHOW CREATE TABLE t1; 2599ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2600SHOW TABLES; 2601let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2602--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2603 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2604CREATE TABLE t1(c1 INT NOT NULL); 2605SHOW TABLES; 2606let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2607--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2608 SHOW CREATE TABLE t1; 2609ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2610SHOW TABLES; 2611let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2612--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2613 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2614CREATE TABLE t1(c1 INTEGER NOT NULL); 2615SHOW TABLES; 2616let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2617--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2618 SHOW CREATE TABLE t1; 2619ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2620SHOW TABLES; 2621let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2622--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2623 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2624CREATE TABLE t1(c1 BIGINT NOT NULL); 2625SHOW TABLES; 2626let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2627--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2628 SHOW CREATE TABLE t1; 2629ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2630SHOW TABLES; 2631let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2632--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2633 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2634CREATE TABLE t1(c1 REAL NOT NULL); 2635SHOW TABLES; 2636let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2637--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2638 SHOW CREATE TABLE t1; 2639ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2640SHOW TABLES; 2641let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2642--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2643 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2644CREATE TABLE t1(c1 DOUBLE NOT NULL); 2645SHOW TABLES; 2646let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2647--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2648 SHOW CREATE TABLE t1; 2649ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2650SHOW TABLES; 2651let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2652--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2653 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2654CREATE TABLE t1(c1 FLOAT NOT NULL); 2655SHOW TABLES; 2656let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2657--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2658 SHOW CREATE TABLE t1; 2659ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2660SHOW TABLES; 2661let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2662--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2663 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2664CREATE TABLE t1(c1 DECIMAL NOT NULL); 2665SHOW TABLES; 2666let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2667--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2668 SHOW CREATE TABLE t1; 2669ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2670SHOW TABLES; 2671let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2672--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2673 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2674CREATE TABLE t1(c1 NUMERIC NOT NULL); 2675SHOW TABLES; 2676let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2677--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2678 SHOW CREATE TABLE t1; 2679ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2680SHOW TABLES; 2681let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2682--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2683 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2684CREATE TABLE t1(c1 DATE NOT NULL); 2685SHOW TABLES; 2686let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2687--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2688 SHOW CREATE TABLE t1; 2689ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2690SHOW TABLES; 2691let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2692--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2693 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2694CREATE TABLE t1(c1 TIME NOT NULL); 2695SHOW TABLES; 2696let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2697--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2698 SHOW CREATE TABLE t1; 2699ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2700SHOW TABLES; 2701let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2702--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2703 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2704CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2705SHOW TABLES; 2706let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2707--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2708 SHOW CREATE TABLE t1; 2709ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2710SHOW TABLES; 2711let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2712--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2713 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2714CREATE TABLE t1(c1 YEAR NOT NULL); 2715SHOW TABLES; 2716let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2717--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2718 SHOW CREATE TABLE t1; 2719ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 2720SHOW TABLES; 2721let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2722--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2723 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2724CREATE TABLE t1(c1 BIT NOT NULL); 2725SHOW TABLES; 2726let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2727--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2728 SHOW CREATE TABLE t1; 2729ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2730SHOW TABLES; 2731let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2732--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2733 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2734CREATE TABLE t1(c1 TINYINT NOT NULL); 2735SHOW TABLES; 2736let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2737--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2738 SHOW CREATE TABLE t1; 2739ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2740SHOW TABLES; 2741let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2742--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2743 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2744CREATE TABLE t1(c1 SMALLINT NOT NULL); 2745SHOW TABLES; 2746let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2747--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2748 SHOW CREATE TABLE t1; 2749ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2750SHOW TABLES; 2751let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2752--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2753 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2754CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2755SHOW TABLES; 2756let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2757--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2758 SHOW CREATE TABLE t1; 2759ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2760SHOW TABLES; 2761let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2762--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2763 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2764CREATE TABLE t1(c1 INT NOT NULL); 2765SHOW TABLES; 2766let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2767--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2768 SHOW CREATE TABLE t1; 2769ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2770SHOW TABLES; 2771let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2772--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2773 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2774CREATE TABLE t1(c1 INTEGER NOT NULL); 2775SHOW TABLES; 2776let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2777--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2778 SHOW CREATE TABLE t1; 2779ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2780SHOW TABLES; 2781let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2782--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2783 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2784CREATE TABLE t1(c1 BIGINT NOT NULL); 2785SHOW TABLES; 2786let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2787--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2788 SHOW CREATE TABLE t1; 2789ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2790SHOW TABLES; 2791let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2792--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2793 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2794CREATE TABLE t1(c1 REAL NOT NULL); 2795SHOW TABLES; 2796let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2797--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2798 SHOW CREATE TABLE t1; 2799ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2800SHOW TABLES; 2801let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2802--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2803 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2804CREATE TABLE t1(c1 DOUBLE NOT NULL); 2805SHOW TABLES; 2806let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2807--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2808 SHOW CREATE TABLE t1; 2809ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2810SHOW TABLES; 2811let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2812--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2813 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2814CREATE TABLE t1(c1 FLOAT NOT NULL); 2815SHOW TABLES; 2816let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2817--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2818 SHOW CREATE TABLE t1; 2819ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2820SHOW TABLES; 2821let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2822--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2823 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2824CREATE TABLE t1(c1 DECIMAL NOT NULL); 2825SHOW TABLES; 2826let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2827--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2828 SHOW CREATE TABLE t1; 2829ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2830SHOW TABLES; 2831let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2832--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2833 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2834CREATE TABLE t1(c1 NUMERIC NOT NULL); 2835SHOW TABLES; 2836let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2837--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2838 SHOW CREATE TABLE t1; 2839ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2840SHOW TABLES; 2841let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2842--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2843 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2844CREATE TABLE t1(c1 DATE NOT NULL); 2845SHOW TABLES; 2846let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2847--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2848 SHOW CREATE TABLE t1; 2849ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2850SHOW TABLES; 2851let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2852--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2853 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2854CREATE TABLE t1(c1 TIME NOT NULL); 2855SHOW TABLES; 2856let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2857--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2858 SHOW CREATE TABLE t1; 2859ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2860SHOW TABLES; 2861let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2862--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2863 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2864CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2865SHOW TABLES; 2866let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2867--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2868 SHOW CREATE TABLE t1; 2869ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2870SHOW TABLES; 2871let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2872--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2873 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2874CREATE TABLE t1(c1 YEAR NOT NULL); 2875SHOW TABLES; 2876let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2877--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2878 SHOW CREATE TABLE t1; 2879ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 2880SHOW TABLES; 2881let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 2882--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" 2883 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 2884 2885