Debian Codegraph @

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

raw
1 #
2 # MDEV-15249 Crash in MVCC read after IMPORT TABLESPACE
3 #
4 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES(0);
6 FLUSH TABLES t1 WITH READ LOCK;
7 UNLOCK TABLES;
8 START TRANSACTION WITH CONSISTENT SNAPSHOT;
9 connect con1,localhost,root,,;
10 ALTER TABLE t1 FORCE, ALGORITHM=COPY;
11 connection default;
12 SELECT * FROM t1;
13 ERROR HY000: Table definition has changed, please retry transaction
14 COMMIT;
15 START TRANSACTION WITH CONSISTENT SNAPSHOT;
16 connection con1;
17 ALTER TABLE t1 DISCARD TABLESPACE;
18 ALTER TABLE t1 IMPORT TABLESPACE;
19 disconnect con1;
20 connection default;
21 # FIXME: Block this with ER_TABLE_DEF_CHANGED
22 SELECT * FROM t1;
23 a
24 0
25 COMMIT;
26 SELECT * FROM t1;
27 a
28 0
29 DROP TABLE t1;
30 #
31 # MDEV-23198 Crash in REPLACE
32 #
33 BEGIN NOT ATOMIC
34 DECLARE c TEXT DEFAULT(SELECT CONCAT('CREATE TABLE t1(id INT PRIMARY KEY, c',
35 GROUP_CONCAT(seq SEPARATOR ' INT, c'),
36 ' INT NOT NULL UNIQUE) ENGINE=InnoDB')
37 FROM seq_1_to_294);
38 EXECUTE IMMEDIATE c;
39 END;
40 $$
41 INSERT INTO t1 SET id=1,c294=1;
42 REPLACE t1 SET id=1,c294=1;
43 DROP TABLE t1;