Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_table_locks_func.test

raw
1 ################# mysql-test\t\innodb_table_locks_func.test ##################
2 # #
3 # Variable Name: innodb_table_locks #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: boolean #
7 # Default Value: 1 #
8 # Range: 0,1 #
9 # #
10 # #
11 # Creation Date: 2008-03-08 #
12 # Author: Rizwan #
13 # #
14 # Description: Test Cases of Dynamic System Variable innodb_table_locks #
15 # that checks the behavior of this variable #
16 # #
17 # Reference: #
18 # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html #
19 # #
20 ###############################################################################
21
22
23 --echo '#--------------------FN_DYNVARS_048_01-------------------------#'
24 ####################################################################
25 # Check if setting innodb_table_locks is changed in new connection #
26 ####################################################################
27
28 SET @start_value= @@global.innodb_table_locks;
29 SELECT @start_value;
30
31 SET @@global.innodb_table_locks = OFF;
32 --echo 'connect (con1,localhost,root,,,,)'
33 connect (con1,localhost,root,,,,);
34 --echo 'connection con1'
35 connection con1;
36 SELECT @@global.innodb_table_locks;
37 SELECT @@session.innodb_table_locks;
38 disconnect con1;
39
40
41 --echo '#--------------------FN_DYNVARS_048_02-------------------------#'
42 ###########################################################
43 # Begin the functionality Testing of innodb_table_locks #
44 ###########################################################
45
46 #==============================================================================
47 --echo '----check when innodb_table_locks = ON and autocommit = OFF---'
48 #==============================================================================
49 --echo 'connect (con2,localhost,root,,,,)'
50 connect (con2,localhost,root,,,,);
51
52 --echo 'connection default'
53 connection default;
54
55 --disable_warnings
56 DROP TABLE IF EXISTS t1;
57 --enable_warnings
58 CREATE TABLE t1 (a INT) ENGINE=INNODB;
59
60 SET @@autocommit = OFF;
61 SET @@innodb_table_locks = ON;
62
63 BEGIN;
64 INSERT INTO t1 VALUES(1);
65 SELECT * FROM t1 FOR UPDATE;
66
67 --echo 'CONNECTION con2'
68 CONNECTION con2;
69 SET @@innodb_table_locks = ON;
70 SET @@autocommit = OFF;
71 send LOCK TABLES t1 WRITE;
72
73 --echo 'CONNECTION default'
74 CONNECTION default;
75 COMMIT;
76
77 --echo 'CONNECTION con2'
78 CONNECTION con2;
79 reap;
80 UNLOCK tables;
81
82 DROP TABLE t1;
83 disconnect con2;
84
85 connection default;
86 SET @@global.innodb_table_locks= @start_value;
87 SELECT @@global.innodb_table_locks;
88
89 ##########################################################
90 # End of functionality Testing for innodb_table_locks #
91 ##########################################################
92
93