Debian Codegraph @

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;