Debian Codegraph @

mysql-test/suite/galera/r/unique_key.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV#5552 Deadlock when inserting NULL column value in column with
5 # UNIQUE index
6 #
7 USE test;
8
9 # On node_1
10 connection node_1;
11 CREATE TABLE t1(c1 INT DEFAULT NULL, UNIQUE KEY c1(c1)) ENGINE=INNODB;
12 INSERT INTO t1 VALUES (NULL);
13 INSERT INTO t1 VALUES (NULL);
14 SELECT * FROM test.t1;
15 c1
16 NULL
17 NULL
18
19 # On node_2
20 connection node_2;
21 SELECT * FROM test.t1;
22 c1
23 NULL
24 NULL
25
26 # On node_1
27 connection node_1;
28 INSERT INTO t1 VALUES (1);
29 UPDATE t1 SET c1=NULL WHERE c1=1;
30 SELECT * FROM test.t1;
31 c1
32 NULL
33 NULL
34 NULL
35
36 # On node_2
37 connection node_2;
38 SELECT * FROM test.t1;
39 c1
40 NULL
41 NULL
42 NULL
43
44 # On node_1
45 connection node_1;
46 DELETE FROM t1 WHERE c1<=>NULL;
47 SELECT * FROM test.t1;
48 c1
49
50 # On node_2
51 connection node_2;
52 SELECT * FROM test.t1;
53 c1
54 DROP TABLE t1;
55 disconnect node_2;
56 disconnect node_1;
57 # End of test