mysql-test/suite/innodb/r/implicit_gap_lock_convertion.result
raw| 1 | CREATE TABLE t(a INT UNSIGNED PRIMARY KEY) ENGINE=InnoDB; |
| 2 | INSERT INTO t VALUES (10), (30); |
| 3 | connect con1,localhost,root,,; |
| 4 | SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; |
| 5 | BEGIN; |
| 6 | INSERT INTO t VALUES (20); |
| 7 | SELECT * FROM t WHERE a BETWEEN 10 AND 30; |
| 8 | a |
| 9 | 10 |
| 10 | 20 |
| 11 | 30 |
| 12 | connection default; |
| 13 | SET session innodb_lock_wait_timeout=1; |
| 14 | INSERT INTO t VALUES (15); |
| 15 | ERROR HY000: Lock wait timeout exceeded; try restarting transaction |
| 16 | disconnect con1; |
| 17 | DROP TABLE t; |