1SET @session_start_value = @@session.query_cache_wlock_invalidate;
2SELECT @session_start_value;
3@session_start_value
40
5SET @global_start_value = @@global.query_cache_wlock_invalidate;
6SELECT @global_start_value;
7@global_start_value
80
9'#--------------------FN_DYNVARS_135_01------------------------#'
10SET @@session.query_cache_wlock_invalidate = 1;
11SET @@session.query_cache_wlock_invalidate = DEFAULT;
12SELECT @@session.query_cache_wlock_invalidate;
13@@session.query_cache_wlock_invalidate
140
15SET @@global.query_cache_wlock_invalidate = 1;
16SET @@global.query_cache_wlock_invalidate = DEFAULT;
17SELECT @@global.query_cache_wlock_invalidate;
18@@global.query_cache_wlock_invalidate
190
20'#---------------------FN_DYNVARS_135_02-------------------------#'
21SET query_cache_wlock_invalidate = 1;
22SELECT @@query_cache_wlock_invalidate;
23@@query_cache_wlock_invalidate
241
25SELECT session.query_cache_wlock_invalidate;
26ERROR 42S02: Unknown table 'session' in field list
27SELECT local.query_cache_wlock_invalidate;
28ERROR 42S02: Unknown table 'local' in field list
29SELECT global.query_cache_wlock_invalidate;
30ERROR 42S02: Unknown table 'global' in field list
31SET session query_cache_wlock_invalidate = 0;
32SELECT @@session.query_cache_wlock_invalidate;
33@@session.query_cache_wlock_invalidate
340
35SET global query_cache_wlock_invalidate = 0;
36SELECT @@global.query_cache_wlock_invalidate;
37@@global.query_cache_wlock_invalidate
380
39'#--------------------FN_DYNVARS_135_03------------------------#'
40SET @@session.query_cache_wlock_invalidate = 0;
41SELECT @@session.query_cache_wlock_invalidate;
42@@session.query_cache_wlock_invalidate
430
44SET @@session.query_cache_wlock_invalidate = 1;
45SELECT @@session.query_cache_wlock_invalidate;
46@@session.query_cache_wlock_invalidate
471
48SET @@global.query_cache_wlock_invalidate = 0;
49SELECT @@global.query_cache_wlock_invalidate;
50@@global.query_cache_wlock_invalidate
510
52SET @@global.query_cache_wlock_invalidate = 1;
53SELECT @@global.query_cache_wlock_invalidate;
54@@global.query_cache_wlock_invalidate
551
56'#--------------------FN_DYNVARS_135_04-------------------------#'
57SET @@session.query_cache_wlock_invalidate = -1;
58ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '-1'
59SET @@session.query_cache_wlock_invalidate = 1.6;
60ERROR 42000: Incorrect argument type to variable 'query_cache_wlock_invalidate'
61SET @@session.query_cache_wlock_invalidate = "T";
62ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'T'
63SET @@session.query_cache_wlock_invalidate = "Y";
64ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'Y'
65SET @@session.query_cache_wlock_invalidate = TR�E;
66ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'TR�E'
67SET @@session.query_cache_wlock_invalidate = �N;
68ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�N'
69SET @@session.query_cache_wlock_invalidate = OF;
70ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'OF'
71SET @@session.query_cache_wlock_invalidate = �FF;
72ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�FF'
73SET @@global.query_cache_wlock_invalidate = -1;
74ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '-1'
75SET @@global.query_cache_wlock_invalidate = 2;
76ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '2'
77SET @@global.query_cache_wlock_invalidate = "T";
78ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'T'
79SET @@global.query_cache_wlock_invalidate = "Y";
80ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'Y'
81SET @@global.query_cache_wlock_invalidate = TR�E;
82ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'TR�E'
83SET @@global.query_cache_wlock_invalidate = �N;
84ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�N'
85SET @@global.query_cache_wlock_invalidate = OF;
86ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'OF'
87SET @@global.query_cache_wlock_invalidate = �FF;
88ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�FF'
89'#-------------------FN_DYNVARS_135_05----------------------------#'
90SET @@global.query_cache_wlock_invalidate = 0;
91SET @@session.query_cache_wlock_invalidate = 1;
92SELECT @@global.query_cache_wlock_invalidate AS res_is_0;
93res_is_0
940
95SET @@global.query_cache_wlock_invalidate = 0;
96SELECT @@session.query_cache_wlock_invalidate AS res_is_1;
97res_is_1
981
99'#----------------------FN_DYNVARS_135_06------------------------#'
100SELECT IF(@@global.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE
101FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
102WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
103IF(@@global.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE
1041
105SELECT @@global.query_cache_wlock_invalidate;
106@@global.query_cache_wlock_invalidate
1070
108SELECT VARIABLE_VALUE
109FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
110WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
111VARIABLE_VALUE
112OFF
113'#----------------------FN_DYNVARS_135_07------------------------#'
114SELECT IF(@@session.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE
115FROM INFORMATION_SCHEMA.SESSION_VARIABLES
116WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
117IF(@@session.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE
1181
119SELECT @@session.query_cache_wlock_invalidate;
120@@session.query_cache_wlock_invalidate
1211
122SELECT VARIABLE_VALUE
123FROM INFORMATION_SCHEMA.SESSION_VARIABLES
124WHERE VARIABLE_NAME='query_cache_wlock_invalidate';
125VARIABLE_VALUE
126ON
127'#---------------------FN_DYNVARS_135_08-------------------------#'
128SET @@session.query_cache_wlock_invalidate = OFF;
129SELECT @@session.query_cache_wlock_invalidate;
130@@session.query_cache_wlock_invalidate
1310
132SET @@session.query_cache_wlock_invalidate = ON;
133SELECT @@session.query_cache_wlock_invalidate;
134@@session.query_cache_wlock_invalidate
1351
136SET @@global.query_cache_wlock_invalidate = OFF;
137SELECT @@global.query_cache_wlock_invalidate;
138@@global.query_cache_wlock_invalidate
1390
140SET @@global.query_cache_wlock_invalidate = ON;
141SELECT @@global.query_cache_wlock_invalidate;
142@@global.query_cache_wlock_invalidate
1431
144'#---------------------FN_DYNVARS_135_09----------------------#'
145SET @@session.query_cache_wlock_invalidate = TRUE;
146SELECT @@session.query_cache_wlock_invalidate;
147@@session.query_cache_wlock_invalidate
1481
149SET @@session.query_cache_wlock_invalidate = FALSE;
150SELECT @@session.query_cache_wlock_invalidate;
151@@session.query_cache_wlock_invalidate
1520
153SET @@global.query_cache_wlock_invalidate = TRUE;
154SELECT @@global.query_cache_wlock_invalidate;
155@@global.query_cache_wlock_invalidate
1561
157SET @@global.query_cache_wlock_invalidate = FALSE;
158SELECT @@global.query_cache_wlock_invalidate;
159@@global.query_cache_wlock_invalidate
1600
161SET @@session.query_cache_wlock_invalidate = @session_start_value;
162SELECT @@session.query_cache_wlock_invalidate;
163@@session.query_cache_wlock_invalidate
1640
165SET @@global.query_cache_wlock_invalidate = @global_start_value;
166SELECT @@global.query_cache_wlock_invalidate;
167@@global.query_cache_wlock_invalidate
1680
169