1
# Test "ALTER TABLE ... IMPORT TABLESPACE" in InnoDB
2
--source include/have_innodb.inc
5
--echo # Bug#20977779 CANNOT IMPORT TABLES CONTAINING PREFIX INDEXES
8
CREATE TABLE t1 (c1 VARCHAR(32), c2 VARCHAR(32), c3 VARCHAR(32),
9
PRIMARY KEY (c1, c2, c3))
12
ALTER TABLE t1 ADD INDEX ind1(c1(5), c2, c3);
13
ALTER TABLE t1 ADD INDEX ind2(c3, c1(10), c2);
14
ALTER TABLE t1 ADD INDEX ind3(c2, c3, c1(20));
16
INSERT INTO t1 VALUES ('Test Data -1', 'Test Data -2', 'Test Data -3');
18
--echo # Test with 2ndary index having prefix
19
--source suite/innodb/include/import.inc
21
--echo # Test with PK & 2ndary index with prefix
22
ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY(c1(5), c2(10), c3(20));
23
--source suite/innodb/include/import.inc