Debian Codegraph @

mysql-test/suite/galera/t/unique_key.test

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