diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb-lock.test')
-rw-r--r-- | mysql-test/suite/innodb/t/innodb-lock.test | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/mysql-test/suite/innodb/t/innodb-lock.test b/mysql-test/suite/innodb/t/innodb-lock.test index f73bf0d5a99..d17d73991aa 100644 --- a/mysql-test/suite/innodb/t/innodb-lock.test +++ b/mysql-test/suite/innodb/t/innodb-lock.test @@ -401,4 +401,28 @@ drop table t1; # TODO (MDEV-10962): H) Insert into an already passed locked gap (15) - +--echo # +--echo # MDEV-10962 Deadlock with 3 concurrent DELETEs by unique key +--echo # +create table t1 (a int unique) engine innodb; +insert into t1 values (1); +connect (con1, localhost, root,, test); +connect (con2, localhost, root,, test); +connect (con3, localhost, root,, test); +connection con1; +send delete from t1 where a = 1; +connection con2; +send delete from t1 where a = 1; +connection con3; +send delete from t1 where a = 1; +connection con1; +reap; +connection con2; +reap; +connection con3; +reap; +connection default; +disconnect con1; +disconnect con2; +disconnect con3; +drop table t1; |