Debian Codegraph @

mysql-test/suite/innodb/t/bug34307874.test

raw
1 --echo # Bug 34307874: Innodb import tablespace crash on tables with instant algorithm used
2 --echo # Importing without .cfg file for tables with INSTANT columns must not crash
3
4 --echo # Scenario 1: IMPORT without CFG file
5
6 LET $MYSQLD_DATADIR = `SELECT @@datadir`;
7
8 CREATE TABLE t1 (id INT, str1 VARCHAR(20), index(str1));
9 INSERT INTO t1 VALUES (1, 'val1');
10 ALTER TABLE t1 ADD COLUMN str2 VARCHAR(20), ALGORITHM=INSTANT;
11 INSERT INTO t1 VALUES (2, 'val1', 'val2');
12
13 FLUSH TABLES t1 FOR EXPORT;
14 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
15 UNLOCK TABLES;
16
17 CREATE TABLE t2 LIKE t1;
18 ALTER TABLE t2 DISCARD TABLESPACE;
19 --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd
20 --error ER_TABLE_SCHEMA_MISMATCH
21 ALTER TABLE t2 IMPORT TABLESPACE;
22
23 DROP TABLE t1;
24 DROP TABLE t2;
25 --remove_file $MYSQLD_DATADIR/test/t2.ibd
26 --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
27
28 --echo # Scenario 2: IMPORT with CFG file
29
30 CREATE TABLE t1 (id INT, str1 VARCHAR(20), index(str1));
31 INSERT INTO t1 VALUES (1, 'val1');
32 ALTER TABLE t1 ADD COLUMN str2 VARCHAR(20), ALGORITHM=INSTANT;
33 INSERT INTO t1 VALUES (2, 'val1', 'val2');
34
35 FLUSH TABLES t1 FOR EXPORT;
36 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
37 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLTEST_VARDIR/tmp/t1_backup.cfg
38 UNLOCK TABLES;
39
40 CREATE TABLE t2 LIKE t1;
41 ALTER TABLE t2 DISCARD TABLESPACE;
42 --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd
43 --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg $MYSQLD_DATADIR/test/t2.cfg
44 ALTER TABLE t2 IMPORT TABLESPACE;
45 SELECT * FROM t2;
46
47 DROP TABLE t1;
48 DROP TABLE t2;
49 --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
50 --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg
51
52 --echo # Scenario 3: IMPORT without CFG file for another case
53
54 CREATE TABLE t1 (id INT, c1 VARCHAR(20), c2 VARCHAR(20));
55 INSERT INTO t1 VALUES (1, "1-c1", "1-c2");
56
57 ALTER TABLE t1 ADD COLUMN c3 VARCHAR(20), ALGORITHM=INSTANT;
58 INSERT INTO t1 VALUES (2, "2-c1", "2-c2", "2-c3");
59
60 ALTER TABLE t1 ADD COLUMN c4 VARCHAR(20) FIRST, ALGORITHM=INSTANT;
61 INSERT INTO t1 VALUES ("3-c4", 3, "3-c1", "3-c2", "3-c3");
62
63 ALTER TABLE t1 DROP COLUMN c1, ALGORITHM=INSTANT;
64 INSERT INTO t1 VALUES ("4-c4", 4, "4-c2", "4-c3");
65
66 ALTER TABLE t1 RENAME COLUMN c2 TO c22;
67 INSERT INTO t1 VALUES ("5-c4", 5, "5-c22", "5-c3");
68
69 SELECT * FROM t1;
70
71 FLUSH TABLES t1 FOR EXPORT;
72 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
73 UNLOCK TABLES;
74
75 CREATE TABLE t2 LIKE t1;
76 ALTER TABLE t2 DISCARD TABLESPACE;
77 --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd
78 --error ER_TABLE_SCHEMA_MISMATCH
79 ALTER TABLE t2 IMPORT TABLESPACE;
80
81 DROP TABLE t1;
82 DROP TABLE t2;
83 --remove_file $MYSQLD_DATADIR/test/t2.ibd
84 --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
85
86 --echo # Scenario 4: IMPORT with CFG file for another case
87
88 CREATE TABLE t1 (id INT, c1 VARCHAR(20), c2 VARCHAR(20));
89 INSERT INTO t1 VALUES (1, "1-c1", "1-c2");
90
91 ALTER TABLE t1 ADD COLUMN c3 VARCHAR(20), ALGORITHM=INSTANT;
92 INSERT INTO t1 VALUES (2, "2-c1", "2-c2", "2-c3");
93
94 ALTER TABLE t1 ADD COLUMN c4 VARCHAR(20) FIRST, ALGORITHM=INSTANT;
95 INSERT INTO t1 VALUES ("3-c4", 3, "3-c1", "3-c2", "3-c3");
96
97 ALTER TABLE t1 DROP COLUMN c1, ALGORITHM=INSTANT;
98 INSERT INTO t1 VALUES ("4-c4", 4, "4-c2", "4-c3");
99
100 ALTER TABLE t1 RENAME COLUMN c2 TO c22;
101 INSERT INTO t1 VALUES ("5-c4", 5, "5-c22", "5-c3");
102
103 SELECT * FROM t1;
104
105 FLUSH TABLES t1 FOR EXPORT;
106 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
107 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLTEST_VARDIR/tmp/t1_backup.cfg
108 UNLOCK TABLES;
109
110 CREATE TABLE t2 LIKE t1;
111 ALTER TABLE t2 DISCARD TABLESPACE;
112 --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd $MYSQLD_DATADIR/test/t2.ibd
113 --copy_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg $MYSQLD_DATADIR/test/t2.cfg
114 ALTER TABLE t2 IMPORT TABLESPACE;
115 SELECT * FROM t2;
116
117 DROP TABLE t1;
118 DROP TABLE t2;
119 --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.ibd
120 --remove_file $MYSQLTEST_VARDIR/tmp/t1_backup.cfg