3
SELECT * FROM t1 FOR UPDATE;
4
-- eval $con1_extra_sql
7
SELECT * FROM t2 FOR UPDATE;
8
-- eval $con2_extra_sql
12
INSERT INTO t2 VALUES (0);
15
INSERT INTO t1 VALUES (0);
19
-- error ER_LOCK_DEADLOCK
24
INSERT INTO t1 VALUES (0);
27
INSERT INTO t2 VALUES (0);
31
-- error ER_LOCK_DEADLOCK
35
DELETE FROM t5_nontrans;