Debian Codegraph @

mysql-test/suite/innodb/r/row_lock.result

raw
1 CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (1,1),(2,2);
3 CREATE TABLE t2 (c INT, d INT) ENGINE=InnoDB;
4 INSERT INTO t2 VALUES (1,1), (2,2);
5 CREATE TABLE t3 (e INT) ENGINE=InnoDB;
6 CREATE TABLE t4 ENGINE=InnoDB AS SELECT * FROM t2;
7 connect con11,localhost,root,,test;
8 BEGIN;
9 UPDATE t1 SET a = 0 WHERE a = ( SELECT e FROM t3 );
10 connect con12,localhost,root,,test;
11 UPDATE t4 SET d = 1 WHERE d in ( SELECT a FROM t1 ) ORDER BY c LIMIT 6;
12 connection con11;
13 UPDATE t4 SET d = 9;
14 connection con12;
15 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
16 connection con11;
17 commit;
18 connection default;
19 disconnect con12;
20 disconnect con11;
21 drop table t1,t2,t3,t4;
22 call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction");
23 call mtr.add_suppression("Sort aborted.*");