1SET @session_start_value = @@session.innodb_table_locks;
2SELECT @session_start_value;
3@session_start_value
41
5SET @global_start_value = @@global.innodb_table_locks;
6SELECT @global_start_value;
7@global_start_value
81
9'#--------------------FN_DYNVARS_046_01------------------------#'
10SET @@session.innodb_table_locks = 0;
11SET @@session.innodb_table_locks = DEFAULT;
12SELECT @@session.innodb_table_locks;
13@@session.innodb_table_locks
141
15SET @@global.innodb_table_locks = 0;
16SET @@global.innodb_table_locks = DEFAULT;
17SELECT @@global.innodb_table_locks;
18@@global.innodb_table_locks
191
20'#---------------------FN_DYNVARS_046_02-------------------------#'
21SET innodb_table_locks = 1;
22SELECT @@innodb_table_locks;
23@@innodb_table_locks
241
25SELECT session.innodb_table_locks;
26ERROR 42S02: Unknown table 'session' in field list
27SELECT local.innodb_table_locks;
28ERROR 42S02: Unknown table 'local' in field list
29SELECT global.innodb_table_locks;
30ERROR 42S02: Unknown table 'global' in field list
31SET session innodb_table_locks = 0;
32SELECT @@session.innodb_table_locks;
33@@session.innodb_table_locks
340
35SET global innodb_table_locks = 0;
36SELECT @@global.innodb_table_locks;
37@@global.innodb_table_locks
380
39'#--------------------FN_DYNVARS_046_03------------------------#'
40SET @@session.innodb_table_locks = 0;
41SELECT @@session.innodb_table_locks;
42@@session.innodb_table_locks
430
44SET @@session.innodb_table_locks = 1;
45SELECT @@session.innodb_table_locks;
46@@session.innodb_table_locks
471
48SET @@global.innodb_table_locks = 0;
49SELECT @@global.innodb_table_locks;
50@@global.innodb_table_locks
510
52SET @@global.innodb_table_locks = 1;
53SELECT @@global.innodb_table_locks;
54@@global.innodb_table_locks
551
56'#--------------------FN_DYNVARS_046_04-------------------------#'
57SET @@session.innodb_table_locks = -6;
58ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '-6'
59SET @@session.innodb_table_locks = 1.6;
60ERROR 42000: Incorrect argument type to variable 'innodb_table_locks'
61SET @@session.innodb_table_locks = "T";
62ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'T'
63SET @@session.innodb_table_locks = "Y";
64ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'Y'
65SET @@session.innodb_table_locks = TR�E;
66ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'TR�E'
67SET @@session.innodb_table_locks = �N;
68ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '�N'
69SET @@session.innodb_table_locks = OF;
70SELECT @@session.innodb_table_locks;
71@@session.innodb_table_locks
720
73SET @@session.innodb_table_locks = �FF;
74ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '�FF'
75SET @@global.innodb_table_locks = -1;
76ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '-1'
77SET @@global.innodb_table_locks = 2;
78ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '2'
79SET @@global.innodb_table_locks = "T";
80ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'T'
81SET @@global.innodb_table_locks = "Y";
82ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'Y'
83SET @@global.innodb_table_locks = TR�E;
84ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'TR�E'
85SET @@global.innodb_table_locks = QN;
86ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'QN'
87SET @@global.innodb_table_locks = OF;
88SELECT @@global.innodb_table_locks;
89@@global.innodb_table_locks
900
91'#-------------------FN_DYNVARS_046_05----------------------------#'
92SET @@global.innodb_table_locks = 0;
93SET @@session.innodb_table_locks = 1;
94SELECT @@global.innodb_table_locks AS res_is_0;
95res_is_0
960
97SET @@global.innodb_table_locks = 0;
98SELECT @@session.innodb_table_locks AS res_is_1;
99res_is_1
1001
101'#----------------------FN_DYNVARS_046_06------------------------#'
102SELECT IF(@@global.innodb_table_locks, "ON", "OFF") =
103VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
104WHERE VARIABLE_NAME='innodb_table_locks';
105IF(@@global.innodb_table_locks, "ON", "OFF") =
106VARIABLE_VALUE
1071
108SELECT @@global.innodb_table_locks;
109@@global.innodb_table_locks
1100
111SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
112WHERE VARIABLE_NAME='innodb_table_locks';
113VARIABLE_VALUE
114OFF
115'#----------------------FN_DYNVARS_046_07------------------------#'
116SELECT IF(@@session.innodb_table_locks, "ON", "OFF") =
117VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
118WHERE VARIABLE_NAME='innodb_table_locks';
119IF(@@session.innodb_table_locks, "ON", "OFF") =
120VARIABLE_VALUE
1211
122SELECT @@session.innodb_table_locks;
123@@session.innodb_table_locks
1241
125SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
126WHERE VARIABLE_NAME='innodb_table_locks';
127VARIABLE_VALUE
128ON
129'#---------------------FN_DYNVARS_046_08-------------------------#'
130SET @@session.innodb_table_locks = OFF;
131SELECT @@session.innodb_table_locks;
132@@session.innodb_table_locks
1330
134SET @@session.innodb_table_locks = ON;
135SELECT @@session.innodb_table_locks;
136@@session.innodb_table_locks
1371
138SET @@global.innodb_table_locks = OFF;
139SELECT @@global.innodb_table_locks;
140@@global.innodb_table_locks
1410
142SET @@global.innodb_table_locks = ON;
143SELECT @@global.innodb_table_locks;
144@@global.innodb_table_locks
1451
146'#---------------------FN_DYNVARS_046_09----------------------#'
147SET @@session.innodb_table_locks = TRUE;
148SELECT @@session.innodb_table_locks;
149@@session.innodb_table_locks
1501
151SET @@session.innodb_table_locks = FALSE;
152SELECT @@session.innodb_table_locks;
153@@session.innodb_table_locks
1540
155SET @@global.innodb_table_locks = TRUE;
156SELECT @@global.innodb_table_locks;
157@@global.innodb_table_locks
1581
159SET @@global.innodb_table_locks = FALSE;
160SELECT @@global.innodb_table_locks;
161@@global.innodb_table_locks
1620
163SET @@session.innodb_table_locks = @session_start_value;
164SELECT @@session.innodb_table_locks;
165@@session.innodb_table_locks
1661
167SET @@global.innodb_table_locks = @global_start_value;
168SELECT @@global.innodb_table_locks;
169@@global.innodb_table_locks
1701
171