Debian Codegraph @

mysql-test/suite/innodb/t/implicit_gap_lock_convertion.test

raw
1 --source include/have_innodb.inc
2 --source include/count_sessions.inc
3
4 CREATE TABLE t(a INT UNSIGNED PRIMARY KEY) ENGINE=InnoDB;
5
6 INSERT INTO t VALUES (10), (30);
7
8 --connect (con1,localhost,root,,)
9 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
10 BEGIN;
11 INSERT INTO t VALUES (20);
12 SELECT * FROM t WHERE a BETWEEN 10 AND 30;
13
14 --connection default
15 SET session innodb_lock_wait_timeout=1;
16 --error ER_LOCK_WAIT_TIMEOUT
17 INSERT INTO t VALUES (15);
18
19 --disconnect con1
20 DROP TABLE t;
21 --source include/wait_until_count_sessions.inc