| 1 |
--source include/have_innodb.inc |
| 2 |
# |
| 3 |
# Bug #56716 InnoDB locks a record gap without locking the table |
| 4 |
# |
| 5 |
CREATE TABLE bug56716 (a INT PRIMARY KEY,b INT,c INT,INDEX(b)) ENGINE=InnoDB; |
| 6 |
|
| 7 |
SELECT * FROM bug56716 WHERE b<=42 ORDER BY b DESC FOR UPDATE; |
| 8 |
|
| 9 |
DROP TABLE bug56716; |