|
2062.4.1
by Andrew Hutchings
Backport http://bugs.mysql.com/bug.php?id=40113 |
1 |
CREATE TABLE t1 (a int, b int, PRIMARY KEY (a,b)) ENGINE=InnoDB;
|
2 |
INSERT INTO t1 (a,b) VALUES (1070109,99);
|
|
3 |
CREATE TABLE t2 (b int, a int, PRIMARY KEY (b)) ENGINE=InnoDB;
|
|
4 |
INSERT INTO t2 (b,a) VALUES (7,1070109);
|
|
5 |
SELECT * FROM t1;
|
|
6 |
a b
|
|
7 |
1070109 99
|
|
8 |
BEGIN;
|
|
9 |
SELECT b FROM t2 WHERE b=7 FOR UPDATE;
|
|
10 |
b
|
|
11 |
7
|
|
12 |
BEGIN;
|
|
13 |
DELETE FROM t1 WHERE a=(SELECT a FROM t2 WHERE b=7);
|
|
14 |
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
|
|
15 |
ROLLBACK;
|
|
16 |
DROP TABLE t2, t1;
|