Debian Codegraph @

mysql-test/suite/galera/t/MDEV-25039.test

raw
1 #
2 # MDEV-38216 was failing after MDEV-25039 changes.
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7 --source include/have_debug.inc
8 --source include/have_debug_sync.inc
9 --source include/have_perfschema.inc
10
11 --echo #
12 --echo # 1. LOCK TABLE and INSERT
13 --echo #
14
15 #
16 # Setup
17 #
18 --connection node_1
19 CREATE TABLE t1 (
20 id varchar(100),
21 PRIMARY KEY (id)) engine=innodb;
22
23 CREATE TABLE t2 (
24 id varchar(100) , a varchar(100),
25 PRIMARY KEY (id,a),
26 KEY a (a),
27 CONSTRAINT FOREIGN KEY (a) REFERENCES t1 (id)
28 ) ENGINE=InnoDB;
29
30 CREATE TABLE t3 (
31 a varchar(100),
32 b varchar(100) ,
33 PRIMARY KEY (a, b),
34 CONSTRAINT FOREIGN KEY (a) REFERENCES t2 (a)
35 ) ENGINE=InnoDB;
36
37 LOCK TABLES t1 WRITE;
38 INSERT INTO t1 VALUES ('a');
39 UNLOCK TABLES;
40
41
42 #
43 # Verify insert has succeded.
44 #
45 --connection node_2
46 --let $wait_condition = SELECT COUNT(*) = 1 FROM test.t1
47 --source include/wait_condition.inc
48
49 select * from t1;
50
51 --connection node_1
52 select * from t1;
53
54
55 #
56 # Cleanup
57 #
58 DROP TABLE t3, t2, t1;
59
60
61 --echo #
62 --echo # 2. FLUSH TABLES WITH READ LOCK and INSERT
63 --echo #
64
65 #
66 # Setup
67 #
68 --connection node_1
69 CREATE TABLE t1 (
70 id varchar(100),
71 PRIMARY KEY (id)) engine=innodb;
72
73 CREATE TABLE t2 (
74 id varchar(100) , a varchar(100),
75 PRIMARY KEY (id,a),
76 KEY a (a),
77 CONSTRAINT FOREIGN KEY (a) REFERENCES t1 (id)
78 ) ENGINE=InnoDB;
79
80 CREATE TABLE t3 (
81 a varchar(100),
82 b varchar(100) ,
83 PRIMARY KEY (a, b),
84 CONSTRAINT FOREIGN KEY (a) REFERENCES t2 (a)
85 ) ENGINE=InnoDB;
86
87 FLUSH TABLES WITH READ LOCK;
88 --error ER_CANT_UPDATE_WITH_READLOCK
89 INSERT INTO t1 VALUES ('a');
90 UNLOCK TABLES;
91
92
93 #
94 # Verify insert has succeded.
95 #
96 --connection node_2
97 --let $wait_condition = SELECT COUNT(*) = 0 FROM test.t1
98 --source include/wait_condition.inc
99
100 select * from t1;
101
102 --connection node_1
103 select * from t1;
104
105
106 #
107 # Cleanup
108 #
109 DROP TABLE t3, t2, t1;