Debian Codegraph @

mysql-test/suite/galera/r/MDEV-25039.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # 1. LOCK TABLE and INSERT
5 #
6 connection node_1;
7 CREATE TABLE t1 (
8 id varchar(100),
9 PRIMARY KEY (id)) engine=innodb;
10 CREATE TABLE t2 (
11 id varchar(100) , a varchar(100),
12 PRIMARY KEY (id,a),
13 KEY a (a),
14 CONSTRAINT FOREIGN KEY (a) REFERENCES t1 (id)
15 ) ENGINE=InnoDB;
16 CREATE TABLE t3 (
17 a varchar(100),
18 b varchar(100) ,
19 PRIMARY KEY (a, b),
20 CONSTRAINT FOREIGN KEY (a) REFERENCES t2 (a)
21 ) ENGINE=InnoDB;
22 LOCK TABLES t1 WRITE;
23 INSERT INTO t1 VALUES ('a');
24 UNLOCK TABLES;
25 connection node_2;
26 select * from t1;
27 id
28 a
29 connection node_1;
30 select * from t1;
31 id
32 a
33 DROP TABLE t3, t2, t1;
34 #
35 # 2. FLUSH TABLES WITH READ LOCK and INSERT
36 #
37 connection node_1;
38 CREATE TABLE t1 (
39 id varchar(100),
40 PRIMARY KEY (id)) engine=innodb;
41 CREATE TABLE t2 (
42 id varchar(100) , a varchar(100),
43 PRIMARY KEY (id,a),
44 KEY a (a),
45 CONSTRAINT FOREIGN KEY (a) REFERENCES t1 (id)
46 ) ENGINE=InnoDB;
47 CREATE TABLE t3 (
48 a varchar(100),
49 b varchar(100) ,
50 PRIMARY KEY (a, b),
51 CONSTRAINT FOREIGN KEY (a) REFERENCES t2 (a)
52 ) ENGINE=InnoDB;
53 FLUSH TABLES WITH READ LOCK;
54 INSERT INTO t1 VALUES ('a');
55 ERROR HY000: Can't execute the query because you have a conflicting read lock
56 UNLOCK TABLES;
57 connection node_2;
58 select * from t1;
59 id
60 connection node_1;
61 select * from t1;
62 id
63 DROP TABLE t3, t2, t1;