Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_table_locks_func.result

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