--source include/have_innodb.inc

CREATE TABLE t1 (a INT) ENGINE=InnoDB;

CREATE TABLE t2 (a INT) ENGINE=InnoDB;

SET AUTOCOMMIT=0;

INSERT INTO t2 VALUES (1);

CONNECT  c1,localhost,root,,;

SET AUTOCOMMIT=0;

SET lock_wait_timeout=1;

LOCK TABLES t1 READ, t2 READ;

disconnect c1;

connection default;

DROP TABLE t1,t2;

mysqltest: At line 9: query 'LOCK TABLES t1 READ, t2 READ' failed: 1205: Lock wait timeout exceeded; try restarting transaction

SET @old_lock_wait_timeout= @@lock_wait_timeout;

SET lock_wait_timeout= 1;

--error ER_LOCK_WAIT_TIMEOUT

LOCK TABLES t1 READ, t2 READ;