--source include/have_innodb.inc CREATE TABLE t(a INT UNSIGNED PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t VALUES (10), (30); --connect (con1,localhost,root,,) SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN; INSERT INTO t VALUES (20); SELECT * FROM t WHERE a BETWEEN 10 AND 30; --connection default SET session innodb_lock_wait_timeout=1; --error ER_LOCK_WAIT_TIMEOUT INSERT INTO t VALUES (15); --disconnect con1 DROP TABLE t;