1
-- source include/have_innodb.inc
2
-- source suite/innodb/include/have_innodb_plugin.inc
4
let $timeout=`select @@innodb_lock_wait_timeout`;
5
set global innodb_lock_wait_timeout=42;
7
connect (a,localhost,root,,);
8
connect (b,localhost,root,,);
11
select @@innodb_lock_wait_timeout;
12
set innodb_lock_wait_timeout=1;
13
select @@innodb_lock_wait_timeout;
16
select @@innodb_lock_wait_timeout;
17
set global innodb_lock_wait_timeout=347;
18
select @@innodb_lock_wait_timeout;
19
set innodb_lock_wait_timeout=1;
20
select @@innodb_lock_wait_timeout;
22
connect (c,localhost,root,,);
24
select @@innodb_lock_wait_timeout;
29
create table t1(a int primary key)engine=innodb;
31
insert into t1 values(1),(2),(3);
35
select * from t1 for update;
45
insert into t1 values(4);
49
select * from t1 for update;
56
--error ER_LOCK_WAIT_TIMEOUT
65
eval set global innodb_lock_wait_timeout=$timeout;