1'#--------------------FN_DYNVARS_048_01-------------------------#'
2SET @start_value= @@global.innodb_table_locks;
3SELECT @start_value;
4@start_value
51
6SET @@global.innodb_table_locks = OFF;
7'connect (con1,localhost,root,,,,)'
8connect  con1,localhost,root,,,,;
9'connection con1'
10connection con1;
11SELECT @@global.innodb_table_locks;
12@@global.innodb_table_locks
130
14SELECT @@session.innodb_table_locks;
15@@session.innodb_table_locks
160
17disconnect con1;
18'#--------------------FN_DYNVARS_048_02-------------------------#'
19'----check when innodb_table_locks = ON and autocommit = OFF---'
20'connect (con2,localhost,root,,,,)'
21connect  con2,localhost,root,,,,;
22'connection default'
23connection default;
24DROP TABLE IF EXISTS t1;
25CREATE TABLE t1 (a INT) ENGINE=INNODB;
26SET @@autocommit = OFF;
27SET @@innodb_table_locks = ON;
28BEGIN;
29INSERT INTO t1 VALUES(1);
30SELECT * FROM t1 FOR UPDATE;
31a
321
33'CONNECTION con2'
34connection con2;
35SET @@innodb_table_locks = ON;
36SET @@autocommit = OFF;
37LOCK TABLES t1 WRITE;
38'CONNECTION default'
39connection default;
40COMMIT;
41'CONNECTION con2'
42connection con2;
43UNLOCK tables;
44DROP TABLE t1;
45disconnect con2;
46connection default;
47SET @@global.innodb_table_locks= @start_value;
48SELECT @@global.innodb_table_locks;
49@@global.innodb_table_locks
501
51