Debian Codegraph @

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

raw
1 #
2 # LP:1276424 Deadlock with insertion of NULL unique ke
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INT DEFAULT NULL, UNIQUE KEY i1 (f1)) ENGINE=InnoDB;
9
10 INSERT INTO t1 VALUES (NULL);
11 INSERT INTO t1 VALUES (NULL);
12
13 --connection node_2
14 SELECT COUNT(*) = 2 FROM t1;
15 SELECT f1 IS NULL FROM t1;
16
17 DROP TABLE t1;