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 --source include/not_embedded.inc
23 --source include/have_innodb.inc
24
25 --echo '#--------------------FN_DYNVARS_048_01-------------------------#'
26 ####################################################################
27 # Check if setting innodb_table_locks is changed in new connection #
28 ####################################################################
29
30 SET @start_value= @@global.innodb_table_locks;
31 SELECT @start_value;
32
33 SET @@global.innodb_table_locks = OFF;
34 --echo 'connect (con1,localhost,root,,,,)'
35 connect (con1,localhost,root,,,,);
36 --echo 'connection con1'
37 connection con1;
38 SELECT @@global.innodb_table_locks;
39 SELECT @@session.innodb_table_locks;
40 disconnect con1;
41
42
43 --echo '#--------------------FN_DYNVARS_048_02-------------------------#'
44 ###########################################################
45 # Begin the functionality Testing of innodb_table_locks #
46 ###########################################################
47
48 #==============================================================================
49 --echo '----check when innodb_table_locks = ON and autocommit = OFF---'
50 #==============================================================================
51 --echo 'connect (con2,localhost,root,,,,)'
52 connect (con2,localhost,root,,,,);
53
54 --echo 'connection default'
55 connection default;
56
57 --disable_warnings
58 DROP TABLE IF EXISTS t1;
59 --enable_warnings
60 CREATE TABLE t1 (a INT) ENGINE=INNODB;
61
62 SET @@autocommit = OFF;
63 SET @@innodb_table_locks = ON;
64
65 BEGIN;
66 INSERT INTO t1 VALUES(1);
67 SELECT * FROM t1 FOR UPDATE;
68
69 --echo 'CONNECTION con2'
70 CONNECTION con2;
71 SET @@innodb_table_locks = ON;
72 SET @@autocommit = OFF;
73 send LOCK TABLES t1 WRITE;
74
75 --echo 'CONNECTION default'
76 CONNECTION default;
77 COMMIT;
78
79 --echo 'CONNECTION con2'
80 CONNECTION con2;
81 reap;
82 UNLOCK tables;
83
84 DROP TABLE t1;
85 disconnect con2;
86
87 connection default;
88 SET @@global.innodb_table_locks= @start_value;
89 SELECT @@global.innodb_table_locks;
90
91 ##########################################################
92 # End of functionality Testing for innodb_table_locks #
93 ##########################################################
94
95