mysql-test/suite/innodb_zip/include/innodb_create_tab_indx.inc
raw| 1 | --echo # Create table & Index |
| 2 | |
| 3 | eval CREATE TABLE tab5(col_1 TINYBLOB, col_2 TINYTEXT,col_3 BLOB, |
| 4 | col_4 TEXT,col_5 MEDIUMBLOB,col_6 MEDIUMTEXT, |
| 5 | col_7 LONGBLOB,col_8 LONGTEXT,col_9 VARCHAR(67)) |
| 6 | ENGINE=INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=$block_size; |
| 7 | |
| 8 | |
| 9 | let $i = 9; |
| 10 | while ($i) { |
| 11 | |
| 12 | eval CREATE INDEX idx$i ON tab5(col_$i(10)); |
| 13 | dec $i; |
| 14 | } |
| 15 | |
| 16 |