Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3
4 let MYSQLD_DATADIR =`SELECT @@datadir`;
5
6 --echo #
7 --echo # MDEV-15249 Crash in MVCC read after IMPORT TABLESPACE
8 --echo #
9
10 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
11 INSERT INTO t1 VALUES(0);
12 FLUSH TABLES t1 WITH READ LOCK;
13 perl;
14 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
15 ib_backup_tablespace("test", "t1");
16 EOF
17 UNLOCK TABLES;
18
19 START TRANSACTION WITH CONSISTENT SNAPSHOT;
20
21 connect (con1,localhost,root,,);
22 ALTER TABLE t1 FORCE, ALGORITHM=COPY;
23
24 connection default;
25 --error ER_TABLE_DEF_CHANGED
26 SELECT * FROM t1;
27 COMMIT;
28 START TRANSACTION WITH CONSISTENT SNAPSHOT;
29
30 connection con1;
31
32 ALTER TABLE t1 DISCARD TABLESPACE;
33
34 perl;
35 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
36 ib_restore_tablespace("test", "t1");
37 EOF
38
39 ALTER TABLE t1 IMPORT TABLESPACE;
40 disconnect con1;
41
42 connection default;
43 --echo # FIXME: Block this with ER_TABLE_DEF_CHANGED
44 SELECT * FROM t1;
45 COMMIT;
46 SELECT * FROM t1;
47
48 DROP TABLE t1;
49
50 --echo #
51 --echo # MDEV-23198 Crash in REPLACE
52 --echo #
53
54 DELIMITER $$;
55 BEGIN NOT ATOMIC
56 DECLARE c TEXT DEFAULT(SELECT CONCAT('CREATE TABLE t1(id INT PRIMARY KEY, c',
57 GROUP_CONCAT(seq SEPARATOR ' INT, c'),
58 ' INT NOT NULL UNIQUE) ENGINE=InnoDB')
59 FROM seq_1_to_294);
60 EXECUTE IMMEDIATE c;
61 END;
62 $$
63 DELIMITER ;$$
64
65 INSERT INTO t1 SET id=1,c294=1;
66 REPLACE t1 SET id=1,c294=1;
67 DROP TABLE t1;