--echo # Bug 34307874: Innodb import tablespace crash on tables with instant algorithm used --echo # Importing without .cfg file for tables with INSTANT columns must not crash --echo # Scenario 1: IMPORT without CFG file LET $MYSQLD_DATADIR = `SELECT @@datadir`; CREATE TABLE t1 (id INT, str1 VARCHAR(20), index(str1)); INSERT INTO t1 VALUES (1, 'val1'); ALTER TABLE t1 ADD COLUMN str2 VARCHAR(20), ALGORITHM=INSTANT; INSERT INTO t1 VALUES (2, 'val1', 'val2'); FLUSH TABLES t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd UNLOCK TABLES; CREATE TABLE t2 LIKE t1; ALTER TABLE t2 DISCARD TABLESPACE; --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd --error ER_TABLE_SCHEMA_MISMATCH ALTER TABLE t2 IMPORT TABLESPACE; DROP TABLE t1; DROP TABLE t2; --remove_file $MYSQLD_DATADIR/test/t2.ibd --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd --echo # Scenario 2: IMPORT with CFG file CREATE TABLE t1 (id INT, str1 VARCHAR(20), index(str1)); INSERT INTO t1 VALUES (1, 'val1'); ALTER TABLE t1 ADD COLUMN str2 VARCHAR(20), ALGORITHM=INSTANT; INSERT INTO t1 VALUES (2, 'val1', 'val2'); FLUSH TABLES t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLTEST_VARDIR/tmp/t1_backup.cfg UNLOCK TABLES; CREATE TABLE t2 LIKE t1; ALTER TABLE t2 DISCARD TABLESPACE; --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg $MYSQLD_DATADIR/test/t2.cfg ALTER TABLE t2 IMPORT TABLESPACE; SELECT * FROM t2; DROP TABLE t1; DROP TABLE t2; --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg --echo # Scenario 3: IMPORT without CFG file for another case CREATE TABLE t1 (id INT, c1 VARCHAR(20), c2 VARCHAR(20)); INSERT INTO t1 VALUES (1, "1-c1", "1-c2"); ALTER TABLE t1 ADD COLUMN c3 VARCHAR(20), ALGORITHM=INSTANT; INSERT INTO t1 VALUES (2, "2-c1", "2-c2", "2-c3"); ALTER TABLE t1 ADD COLUMN c4 VARCHAR(20) FIRST, ALGORITHM=INSTANT; INSERT INTO t1 VALUES ("3-c4", 3, "3-c1", "3-c2", "3-c3"); ALTER TABLE t1 DROP COLUMN c1, ALGORITHM=INSTANT; INSERT INTO t1 VALUES ("4-c4", 4, "4-c2", "4-c3"); ALTER TABLE t1 RENAME COLUMN c2 TO c22; INSERT INTO t1 VALUES ("5-c4", 5, "5-c22", "5-c3"); SELECT * FROM t1; FLUSH TABLES t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd UNLOCK TABLES; CREATE TABLE t2 LIKE t1; ALTER TABLE t2 DISCARD TABLESPACE; --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd --error ER_TABLE_SCHEMA_MISMATCH ALTER TABLE t2 IMPORT TABLESPACE; DROP TABLE t1; DROP TABLE t2; --remove_file $MYSQLD_DATADIR/test/t2.ibd --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd --echo # Scenario 4: IMPORT with CFG file for another case CREATE TABLE t1 (id INT, c1 VARCHAR(20), c2 VARCHAR(20)); INSERT INTO t1 VALUES (1, "1-c1", "1-c2"); ALTER TABLE t1 ADD COLUMN c3 VARCHAR(20), ALGORITHM=INSTANT; INSERT INTO t1 VALUES (2, "2-c1", "2-c2", "2-c3"); ALTER TABLE t1 ADD COLUMN c4 VARCHAR(20) FIRST, ALGORITHM=INSTANT; INSERT INTO t1 VALUES ("3-c4", 3, "3-c1", "3-c2", "3-c3"); ALTER TABLE t1 DROP COLUMN c1, ALGORITHM=INSTANT; INSERT INTO t1 VALUES ("4-c4", 4, "4-c2", "4-c3"); ALTER TABLE t1 RENAME COLUMN c2 TO c22; INSERT INTO t1 VALUES ("5-c4", 5, "5-c22", "5-c3"); SELECT * FROM t1; FLUSH TABLES t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLTEST_VARDIR/tmp/t1_backup.cfg UNLOCK TABLES; CREATE TABLE t2 LIKE t1; ALTER TABLE t2 DISCARD TABLESPACE; --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg $MYSQLD_DATADIR/test/t2.cfg ALTER TABLE t2 IMPORT TABLESPACE; SELECT * FROM t2; DROP TABLE t1; DROP TABLE t2; --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg