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