Debian Codegraph @

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

raw
1 CREATE TABLE t1(a INT, b INT NOT NULL, PRIMARY KEY (a)) ENGINE=innodb
2 DEFAULT CHARSET=latin1;
3 INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7);
4 CONNECT con1,localhost,root,,;
5 CONNECT con2,localhost,root,,;
6 connection con1;
7 START TRANSACTION;
8 SELECT * FROM t1 WHERE b=3 LIMIT 1 FOR UPDATE;
9 a b
10 3 3
11 connection con2;
12 START TRANSACTION;
13 UPDATE t1 SET b=b+12 WHERE a > 2 ORDER BY a;
14 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
15 ROLLBACK;
16 connection con1;
17 START TRANSACTION;
18 SELECT * FROM t1 WHERE b=3 LIMIT 1 FOR UPDATE;
19 a b
20 3 3
21 connection con2;
22 START TRANSACTION;
23 UPDATE t1 SET b=10 WHERE a > 1 ORDER BY a;
24 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
25 SELECT * FROM t1 WHERE b = 10;
26 a b
27 connection default;
28 disconnect con1;
29 disconnect con2;
30 DROP TABLE t1;