1
SET @session_start_value = @@session.query_cache_wlock_invalidate;
2
SELECT @session_start_value;
5
SET @global_start_value = @@global.query_cache_wlock_invalidate;
6
SELECT @global_start_value;
9
'#--------------------FN_DYNVARS_135_01------------------------#'
10
SET @@session.query_cache_wlock_invalidate = 1;
11
SET @@session.query_cache_wlock_invalidate = DEFAULT;
12
SELECT @@session.query_cache_wlock_invalidate;
13
@@session.query_cache_wlock_invalidate
15
SET @@global.query_cache_wlock_invalidate = 1;
16
SET @@global.query_cache_wlock_invalidate = DEFAULT;
17
SELECT @@global.query_cache_wlock_invalidate;
18
@@global.query_cache_wlock_invalidate
20
'#---------------------FN_DYNVARS_135_02-------------------------#'
21
SET query_cache_wlock_invalidate = 1;
22
SELECT @@query_cache_wlock_invalidate;
23
@@query_cache_wlock_invalidate
25
SELECT session.query_cache_wlock_invalidate;
26
ERROR 42S02: Unknown table 'session' in field list
27
SELECT local.query_cache_wlock_invalidate;
28
ERROR 42S02: Unknown table 'local' in field list
29
SELECT global.query_cache_wlock_invalidate;
30
ERROR 42S02: Unknown table 'global' in field list
31
SET session query_cache_wlock_invalidate = 0;
32
SELECT @@session.query_cache_wlock_invalidate;
33
@@session.query_cache_wlock_invalidate
35
SET global query_cache_wlock_invalidate = 0;
36
SELECT @@global.query_cache_wlock_invalidate;
37
@@global.query_cache_wlock_invalidate
39
'#--------------------FN_DYNVARS_135_03------------------------#'
40
SET @@session.query_cache_wlock_invalidate = 0;
41
SELECT @@session.query_cache_wlock_invalidate;
42
@@session.query_cache_wlock_invalidate
44
SET @@session.query_cache_wlock_invalidate = 1;
45
SELECT @@session.query_cache_wlock_invalidate;
46
@@session.query_cache_wlock_invalidate
48
SET @@global.query_cache_wlock_invalidate = 0;
49
SELECT @@global.query_cache_wlock_invalidate;
50
@@global.query_cache_wlock_invalidate
52
SET @@global.query_cache_wlock_invalidate = 1;
53
SELECT @@global.query_cache_wlock_invalidate;
54
@@global.query_cache_wlock_invalidate
56
'#--------------------FN_DYNVARS_135_04-------------------------#'
57
SET @@session.query_cache_wlock_invalidate = -1;
58
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '-1'
59
SET @@session.query_cache_wlock_invalidate = 1.6;
60
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '2'
61
SET @@session.query_cache_wlock_invalidate = "T";
62
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'T'
63
SET @@session.query_cache_wlock_invalidate = "Y";
64
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'Y'
65
SET @@session.query_cache_wlock_invalidate = TR�E;
66
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'TRÜE'
67
SET @@session.query_cache_wlock_invalidate = �N;
68
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'ÕN'
69
SET @@session.query_cache_wlock_invalidate = OF;
70
SELECT @@session.query_cache_wlock_invalidate;
71
@@session.query_cache_wlock_invalidate
73
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
74
SET @@session.query_cache_wlock_invalidate = �FF;
75
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'ÓFF'
76
SET @@global.query_cache_wlock_invalidate = -1;
77
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '-1'
78
SET @@global.query_cache_wlock_invalidate = 2;
79
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '2'
80
SET @@global.query_cache_wlock_invalidate = "T";
81
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'T'
82
SET @@global.query_cache_wlock_invalidate = "Y";
83
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'Y'
84
SET @@global.query_cache_wlock_invalidate = TR�E;
85
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'TRÜE'
86
SET @@global.query_cache_wlock_invalidate = �N;
87
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'ÕN'
88
SET @@global.query_cache_wlock_invalidate = OF;
89
SELECT @@global.query_cache_wlock_invalidate;
90
@@global.query_cache_wlock_invalidate
92
'Bug 34828: OF is taken as OFF and a value of 0 is set.'
93
SET @@global.query_cache_wlock_invalidate = �FF;
94
ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'ÓFF'
95
'#-------------------FN_DYNVARS_135_05----------------------------#'
96
SET @@global.query_cache_wlock_invalidate = 0;
97
SET @@session.query_cache_wlock_invalidate = 1;
98
SELECT @@global.query_cache_wlock_invalidate AS res_is_0;
101
SET @@global.query_cache_wlock_invalidate = 0;
102
SELECT @@session.query_cache_wlock_invalidate AS res_is_1;
105
'#----------------------FN_DYNVARS_135_06------------------------#'
106
SELECT @@global.query_cache_wlock_invalidate = VARIABLE_VALUE
107
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
108
WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
109
@@global.query_cache_wlock_invalidate = VARIABLE_VALUE
111
SELECT @@global.query_cache_wlock_invalidate;
112
@@global.query_cache_wlock_invalidate
114
SELECT VARIABLE_VALUE
115
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
116
WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
119
'#----------------------FN_DYNVARS_135_07------------------------#'
120
SELECT @@session.query_cache_wlock_invalidate = VARIABLE_VALUE
121
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
122
WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
123
@@session.query_cache_wlock_invalidate = VARIABLE_VALUE
125
SELECT @@session.query_cache_wlock_invalidate;
126
@@session.query_cache_wlock_invalidate
128
SELECT VARIABLE_VALUE
129
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
130
WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
133
'#---------------------FN_DYNVARS_135_08-------------------------#'
134
SET @@session.query_cache_wlock_invalidate = OFF;
135
SELECT @@session.query_cache_wlock_invalidate;
136
@@session.query_cache_wlock_invalidate
138
SET @@session.query_cache_wlock_invalidate = ON;
139
SELECT @@session.query_cache_wlock_invalidate;
140
@@session.query_cache_wlock_invalidate
142
SET @@global.query_cache_wlock_invalidate = OFF;
143
SELECT @@global.query_cache_wlock_invalidate;
144
@@global.query_cache_wlock_invalidate
146
SET @@global.query_cache_wlock_invalidate = ON;
147
SELECT @@global.query_cache_wlock_invalidate;
148
@@global.query_cache_wlock_invalidate
150
'#---------------------FN_DYNVARS_135_09----------------------#'
151
SET @@session.query_cache_wlock_invalidate = TRUE;
152
SELECT @@session.query_cache_wlock_invalidate;
153
@@session.query_cache_wlock_invalidate
155
SET @@session.query_cache_wlock_invalidate = FALSE;
156
SELECT @@session.query_cache_wlock_invalidate;
157
@@session.query_cache_wlock_invalidate
159
SET @@global.query_cache_wlock_invalidate = TRUE;
160
SELECT @@global.query_cache_wlock_invalidate;
161
@@global.query_cache_wlock_invalidate
163
SET @@global.query_cache_wlock_invalidate = FALSE;
164
SELECT @@global.query_cache_wlock_invalidate;
165
@@global.query_cache_wlock_invalidate
167
SET @@session.query_cache_wlock_invalidate = @session_start_value;
168
SELECT @@session.query_cache_wlock_invalidate;
169
@@session.query_cache_wlock_invalidate
171
SET @@global.query_cache_wlock_invalidate = @global_start_value;
172
SELECT @@global.query_cache_wlock_invalidate;
173
@@global.query_cache_wlock_invalidate