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