From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/suite/innodb/t/mdev-117.test | 34 +++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 mysql-test/suite/innodb/t/mdev-117.test (limited to 'mysql-test/suite/innodb/t/mdev-117.test') diff --git a/mysql-test/suite/innodb/t/mdev-117.test b/mysql-test/suite/innodb/t/mdev-117.test new file mode 100644 index 00000000..b29b2cd5 --- /dev/null +++ b/mysql-test/suite/innodb/t/mdev-117.test @@ -0,0 +1,34 @@ +# +# verify that DELETE IGNORE does not ignore deadlocks +# + +--source include/have_innodb.inc + +SET GLOBAL innodb_lock_wait_timeout=3; + +CREATE TABLE t1 (col_int_key INT, KEY (col_int_key)) ENGINE=InnoDB; +INSERT INTO t1 VALUES (6); + +--connect (con1,localhost,root,,test) +SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; +SET AUTOCOMMIT=OFF; +SELECT col_int_key FROM t1; + +--connection default +--send DELETE IGNORE FROM t1; + +--connection con1 +--error 0,ER_LOCK_DEADLOCK,ER_LOCK_WAIT_TIMEOUT +DELETE FROM t1 WHERE col_int_key IN (1, 40000000); + +--connection default +--disable_warnings +--error 0,ER_LOCK_DEADLOCK,ER_LOCK_WAIT_TIMEOUT +--reap +--enable_warnings + +--disconnect con1 +drop table t1; +SET GLOBAL innodb_lock_wait_timeout=default; + +call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction"); -- cgit v1.2.3