Debian Codegraph @

mysql-test/suite/innodb/r/bug34307874.result

raw
1 # Bug 34307874: Innodb import tablespace crash on tables with instant algorithm used
2 # Importing without .cfg file for tables with INSTANT columns must not crash
3 # Scenario 1: IMPORT without CFG file
4 CREATE TABLE t1 (id INT, str1 VARCHAR(20), index(str1));
5 INSERT INTO t1 VALUES (1, 'val1');
6 ALTER TABLE t1 ADD COLUMN str2 VARCHAR(20), ALGORITHM=INSTANT;
7 INSERT INTO t1 VALUES (2, 'val1', 'val2');
8 FLUSH TABLES t1 FOR EXPORT;
9 UNLOCK TABLES;
10 CREATE TABLE t2 LIKE t1;
11 ALTER TABLE t2 DISCARD TABLESPACE;
12 ALTER TABLE t2 IMPORT TABLESPACE;
13 ERROR HY000: Schema mismatch (CFG file is missing and source table is found to have row versions. CFG file is must to IMPORT tables with row versions.)
14 DROP TABLE t1;
15 DROP TABLE t2;
16 # Scenario 2: IMPORT with CFG file
17 CREATE TABLE t1 (id INT, str1 VARCHAR(20), index(str1));
18 INSERT INTO t1 VALUES (1, 'val1');
19 ALTER TABLE t1 ADD COLUMN str2 VARCHAR(20), ALGORITHM=INSTANT;
20 INSERT INTO t1 VALUES (2, 'val1', 'val2');
21 FLUSH TABLES t1 FOR EXPORT;
22 UNLOCK TABLES;
23 CREATE TABLE t2 LIKE t1;
24 ALTER TABLE t2 DISCARD TABLESPACE;
25 ALTER TABLE t2 IMPORT TABLESPACE;
26 SELECT * FROM t2;
27 id str1 str2
28 1 val1 NULL
29 2 val1 val2
30 DROP TABLE t1;
31 DROP TABLE t2;
32 # Scenario 3: IMPORT without CFG file for another case
33 CREATE TABLE t1 (id INT, c1 VARCHAR(20), c2 VARCHAR(20));
34 INSERT INTO t1 VALUES (1, "1-c1", "1-c2");
35 ALTER TABLE t1 ADD COLUMN c3 VARCHAR(20), ALGORITHM=INSTANT;
36 INSERT INTO t1 VALUES (2, "2-c1", "2-c2", "2-c3");
37 ALTER TABLE t1 ADD COLUMN c4 VARCHAR(20) FIRST, ALGORITHM=INSTANT;
38 INSERT INTO t1 VALUES ("3-c4", 3, "3-c1", "3-c2", "3-c3");
39 ALTER TABLE t1 DROP COLUMN c1, ALGORITHM=INSTANT;
40 INSERT INTO t1 VALUES ("4-c4", 4, "4-c2", "4-c3");
41 ALTER TABLE t1 RENAME COLUMN c2 TO c22;
42 INSERT INTO t1 VALUES ("5-c4", 5, "5-c22", "5-c3");
43 SELECT * FROM t1;
44 c4 id c22 c3
45 NULL 1 1-c2 NULL
46 NULL 2 2-c2 2-c3
47 3-c4 3 3-c2 3-c3
48 4-c4 4 4-c2 4-c3
49 5-c4 5 5-c22 5-c3
50 FLUSH TABLES t1 FOR EXPORT;
51 UNLOCK TABLES;
52 CREATE TABLE t2 LIKE t1;
53 ALTER TABLE t2 DISCARD TABLESPACE;
54 ALTER TABLE t2 IMPORT TABLESPACE;
55 ERROR HY000: Schema mismatch (CFG file is missing and source table is found to have row versions. CFG file is must to IMPORT tables with row versions.)
56 DROP TABLE t1;
57 DROP TABLE t2;
58 # Scenario 4: IMPORT with CFG file for another case
59 CREATE TABLE t1 (id INT, c1 VARCHAR(20), c2 VARCHAR(20));
60 INSERT INTO t1 VALUES (1, "1-c1", "1-c2");
61 ALTER TABLE t1 ADD COLUMN c3 VARCHAR(20), ALGORITHM=INSTANT;
62 INSERT INTO t1 VALUES (2, "2-c1", "2-c2", "2-c3");
63 ALTER TABLE t1 ADD COLUMN c4 VARCHAR(20) FIRST, ALGORITHM=INSTANT;
64 INSERT INTO t1 VALUES ("3-c4", 3, "3-c1", "3-c2", "3-c3");
65 ALTER TABLE t1 DROP COLUMN c1, ALGORITHM=INSTANT;
66 INSERT INTO t1 VALUES ("4-c4", 4, "4-c2", "4-c3");
67 ALTER TABLE t1 RENAME COLUMN c2 TO c22;
68 INSERT INTO t1 VALUES ("5-c4", 5, "5-c22", "5-c3");
69 SELECT * FROM t1;
70 c4 id c22 c3
71 NULL 1 1-c2 NULL
72 NULL 2 2-c2 2-c3
73 3-c4 3 3-c2 3-c3
74 4-c4 4 4-c2 4-c3
75 5-c4 5 5-c22 5-c3
76 FLUSH TABLES t1 FOR EXPORT;
77 UNLOCK TABLES;
78 CREATE TABLE t2 LIKE t1;
79 ALTER TABLE t2 DISCARD TABLESPACE;
80 ALTER TABLE t2 IMPORT TABLESPACE;
81 SELECT * FROM t2;
82 c4 id c22 c3
83 NULL 1 1-c2 NULL
84 NULL 2 2-c2 2-c3
85 3-c4 3 3-c2 3-c3
86 4-c4 4 4-c2 4-c3
87 5-c4 5 5-c22 5-c3
88 DROP TABLE t1;
89 DROP TABLE t2;