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 'connection con1'
9 SELECT @@global.innodb_table_locks;
10 @@global.innodb_table_locks
11 0
12 SELECT @@session.innodb_table_locks;
13 @@session.innodb_table_locks
14 0
15 '#--------------------FN_DYNVARS_048_02-------------------------#'
16 '----check when innodb_table_locks = ON and autocommit = OFF---'
17 'connect (con2,localhost,root,,,,)'
18 'connection default'
19 DROP TABLE IF EXISTS t1;
20 CREATE TABLE t1 (a INT) ENGINE=INNODB;
21 SET @@autocommit = OFF;
22 SET @@innodb_table_locks = ON;
23 BEGIN;
24 INSERT INTO t1 VALUES(1);
25 SELECT * FROM t1 FOR UPDATE;
26 a
27 1
28 'CONNECTION con2'
29 SET @@innodb_table_locks = ON;
30 SET @@autocommit = OFF;
31 LOCK TABLES t1 WRITE;
32 'CONNECTION default'
33 COMMIT;
34 'CONNECTION con2'
35 UNLOCK tables;
36 DROP TABLE t1;
37 SET @@global.innodb_table_locks= @start_value;
38 SELECT @@global.innodb_table_locks;
39 @@global.innodb_table_locks
40 1