Debian Codegraph @

mysql-test/suite/sys_vars/r/max_delayed_threads_basic.result

raw
1 SET @start_global_value = @@global.max_delayed_threads;
2 Warnings:
3 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
4 SELECT @start_global_value;
5 @start_global_value
6 20
7 SET @start_session_value = @@session.max_delayed_threads;
8 Warnings:
9 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
10 SELECT @start_session_value;
11 @start_session_value
12 20
13 '#--------------------FN_DYNVARS_075_01-------------------------#'
14 SET @@global.max_delayed_threads = 1000;
15 Warnings:
16 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
17 SET @@global.max_delayed_threads = DEFAULT;
18 Warnings:
19 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
20 SELECT @@global.max_delayed_threads;
21 @@global.max_delayed_threads
22 20
23 Warnings:
24 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
25 SET @@session.max_delayed_threads = 1000;
26 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1000'
27 SET @@session.max_delayed_threads = DEFAULT;
28 Warnings:
29 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
30 SELECT @@session.max_delayed_threads;
31 @@session.max_delayed_threads
32 20
33 Warnings:
34 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
35 '#--------------------FN_DYNVARS_075_02-------------------------#'
36 SET @@global.max_delayed_threads = DEFAULT;
37 Warnings:
38 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
39 SELECT @@global.max_delayed_threads = 20;
40 @@global.max_delayed_threads = 20
41 1
42 Warnings:
43 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
44 SET @@session.max_delayed_threads = DEFAULT;
45 Warnings:
46 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
47 SELECT @@session.max_delayed_threads = 20;
48 @@session.max_delayed_threads = 20
49 1
50 Warnings:
51 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
52 '#--------------------FN_DYNVARS_075_03-------------------------#'
53 SET @@global.max_delayed_threads = 1;
54 Warnings:
55 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
56 SELECT @@global.max_delayed_threads;
57 @@global.max_delayed_threads
58 1
59 Warnings:
60 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
61 SET @@global.max_delayed_threads = 1025;
62 Warnings:
63 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
64 SELECT @@global.max_delayed_threads;
65 @@global.max_delayed_threads
66 1025
67 Warnings:
68 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
69 SET @@global.max_delayed_threads = 0;
70 Warnings:
71 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
72 SELECT @@global.max_delayed_threads;
73 @@global.max_delayed_threads
74 0
75 Warnings:
76 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
77 SET @@global.max_delayed_threads = 16384;
78 Warnings:
79 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
80 SELECT @@global.max_delayed_threads;
81 @@global.max_delayed_threads
82 16384
83 Warnings:
84 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
85 SET @@global.max_delayed_threads = 16383;
86 Warnings:
87 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
88 SELECT @@global.max_delayed_threads;
89 @@global.max_delayed_threads
90 16383
91 Warnings:
92 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
93 '#--------------------FN_DYNVARS_075_04-------------------------#'
94 SET @@session.max_delayed_threads = 1;
95 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1'
96 SELECT @@session.max_delayed_threads;
97 @@session.max_delayed_threads
98 20
99 Warnings:
100 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
101 SET @@session.max_delayed_threads = 1025;
102 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1025'
103 SELECT @@session.max_delayed_threads;
104 @@session.max_delayed_threads
105 20
106 Warnings:
107 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
108 SET @@session.max_delayed_threads = 0;
109 Warnings:
110 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
111 SELECT @@session.max_delayed_threads;
112 @@session.max_delayed_threads
113 0
114 Warnings:
115 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
116 SET @@session.max_delayed_threads = 16384;
117 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '16384'
118 SELECT @@session.max_delayed_threads;
119 @@session.max_delayed_threads
120 0
121 Warnings:
122 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
123 SET @@session.max_delayed_threads = 16383;
124 Warnings:
125 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
126 SELECT @@session.max_delayed_threads;
127 @@session.max_delayed_threads
128 16383
129 Warnings:
130 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
131 '#------------------FN_DYNVARS_075_05-----------------------#'
132 SET @@global.max_delayed_threads = -1024;
133 Warnings:
134 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
135 Warning 1292 Truncated incorrect max_delayed_threads value: '-1024'
136 SELECT @@global.max_delayed_threads;
137 @@global.max_delayed_threads
138 0
139 Warnings:
140 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
141 SET @@global.max_delayed_threads = -1;
142 Warnings:
143 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
144 Warning 1292 Truncated incorrect max_delayed_threads value: '-1'
145 SELECT @@global.max_delayed_threads;
146 @@global.max_delayed_threads
147 0
148 Warnings:
149 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
150 SET @@global.max_delayed_threads = 16385;
151 Warnings:
152 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
153 Warning 1292 Truncated incorrect max_delayed_threads value: '16385'
154 SELECT @@global.max_delayed_threads;
155 @@global.max_delayed_threads
156 16384
157 Warnings:
158 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
159 SET @@global.max_delayed_threads = 1638523;
160 Warnings:
161 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
162 Warning 1292 Truncated incorrect max_delayed_threads value: '1638523'
163 SELECT @@global.max_delayed_threads;
164 @@global.max_delayed_threads
165 16384
166 Warnings:
167 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
168 SET @@global.max_delayed_threads = 65530.34;
169 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
170 SELECT @@global.max_delayed_threads;
171 @@global.max_delayed_threads
172 16384
173 Warnings:
174 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
175 SET @@global.max_delayed_threads = test;
176 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
177 SELECT @@global.max_delayed_threads;
178 @@global.max_delayed_threads
179 16384
180 Warnings:
181 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
182 SET @@global.max_delayed_threads = ' ';
183 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
184 SELECT @@global.max_delayed_threads;
185 @@global.max_delayed_threads
186 16384
187 Warnings:
188 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
189 SET @@session.max_delayed_threads = 16385;
190 Warnings:
191 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
192 Warning 1292 Truncated incorrect max_delayed_threads value: '16385'
193 SELECT @@session.max_delayed_threads;
194 @@session.max_delayed_threads
195 16384
196 Warnings:
197 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
198 SET @@session.max_delayed_threads = -1;
199 Warnings:
200 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
201 Warning 1292 Truncated incorrect max_delayed_threads value: '-1'
202 SELECT @@session.max_delayed_threads;
203 @@session.max_delayed_threads
204 0
205 Warnings:
206 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
207 SET @@session.max_delayed_threads = -2;
208 Warnings:
209 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
210 Warning 1292 Truncated incorrect max_delayed_threads value: '-2'
211 SELECT @@session.max_delayed_threads;
212 @@session.max_delayed_threads
213 0
214 Warnings:
215 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
216 SET @@session.max_delayed_threads = -1024;
217 Warnings:
218 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
219 Warning 1292 Truncated incorrect max_delayed_threads value: '-1024'
220 SELECT @@session.max_delayed_threads;
221 @@session.max_delayed_threads
222 0
223 Warnings:
224 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
225 SET @@session.max_delayed_threads = 65530.34;
226 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
227 SELECT @@session.max_delayed_threads;
228 @@session.max_delayed_threads
229 0
230 Warnings:
231 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
232 SET @@session.max_delayed_threads = 10737418241;
233 Warnings:
234 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
235 Warning 1292 Truncated incorrect max_delayed_threads value: '10737418241'
236 SELECT @@session.max_delayed_threads;
237 @@session.max_delayed_threads
238 16384
239 Warnings:
240 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
241 SET @@session.max_delayed_threads = test;
242 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
243 SELECT @@session.max_delayed_threads;
244 @@session.max_delayed_threads
245 16384
246 Warnings:
247 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
248 SET @@session.max_delayed_threads = ' ';
249 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
250 SELECT @@session.max_delayed_threads;
251 @@session.max_delayed_threads
252 16384
253 Warnings:
254 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
255 '#------------------FN_DYNVARS_075_06-----------------------#'
256 SELECT VARIABLE_VALUE
257 FROM performance_schema.global_variables
258 WHERE VARIABLE_NAME='max_delayed_threads'
259 into @tmp;
260 SELECT @@global.max_delayed_threads = @tmp;
261 @@global.max_delayed_threads = @tmp
262 1
263 Warnings:
264 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
265 '#------------------FN_DYNVARS_075_07-----------------------#'
266 SELECT VARIABLE_VALUE
267 FROM performance_schema.session_variables
268 WHERE VARIABLE_NAME='max_delayed_threads'
269 into @tmp;
270 SELECT @@session.max_delayed_threads = @tmp;
271 @@session.max_delayed_threads = @tmp
272 1
273 Warnings:
274 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
275 '#------------------FN_DYNVARS_075_08-----------------------#'
276 SET @@global.max_delayed_threads = TRUE;
277 Warnings:
278 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
279 SELECT @@global.max_delayed_threads;
280 @@global.max_delayed_threads
281 1
282 Warnings:
283 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
284 SET @@global.max_delayed_threads = FALSE;
285 Warnings:
286 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
287 SELECT @@global.max_delayed_threads;
288 @@global.max_delayed_threads
289 0
290 Warnings:
291 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
292 '#---------------------FN_DYNVARS_001_09----------------------#'
293 SET @@global.max_delayed_threads = 2048;
294 Warnings:
295 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
296 SELECT @@max_delayed_threads = @@global.max_delayed_threads;
297 @@max_delayed_threads = @@global.max_delayed_threads
298 0
299 Warnings:
300 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
301 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
302 '#---------------------FN_DYNVARS_001_10----------------------#'
303 SET @@max_delayed_threads = 100000;
304 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '100000'
305 SELECT @@max_delayed_threads = @@local.max_delayed_threads;
306 @@max_delayed_threads = @@local.max_delayed_threads
307 1
308 Warnings:
309 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
310 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
311 SELECT @@local.max_delayed_threads = @@session.max_delayed_threads;
312 @@local.max_delayed_threads = @@session.max_delayed_threads
313 1
314 Warnings:
315 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
316 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
317 '#---------------------FN_DYNVARS_001_11----------------------#'
318 SET max_delayed_threads = 1024;
319 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1024'
320 SELECT @@max_delayed_threads;
321 @@max_delayed_threads
322 16384
323 Warnings:
324 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
325 SELECT local.max_delayed_threads;
326 ERROR 42S02: Unknown table 'local' in field list
327 SELECT session.max_delayed_threads;
328 ERROR 42S02: Unknown table 'session' in field list
329 SELECT max_delayed_threads = @@session.max_delayed_threads;
330 ERROR 42S22: Unknown column 'max_delayed_threads' in 'field list'
331 '#---------------------FN_DYNVARS_001_12----------------------#'
332 CREATE USER foo, bar;
333 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
334 SELECT @@session.max_delayed_threads;
335 @@session.max_delayed_threads
336 2048
337 Warnings:
338 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
339 SET @@session.max_delayed_threads = 2048;
340 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
341 SELECT @@session.max_delayed_threads;
342 @@session.max_delayed_threads
343 2048
344 Warnings:
345 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
346 SET @@session.max_delayed_threads = 2048;
347 Warnings:
348 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
349 SELECT @@session.max_delayed_threads;
350 @@session.max_delayed_threads
351 2048
352 Warnings:
353 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
354 DROP USER foo, bar;
355 SET @@global.max_delayed_threads = @start_global_value;
356 Warnings:
357 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
358 SELECT @@global.max_delayed_threads;
359 @@global.max_delayed_threads
360 20
361 Warnings:
362 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
363 SET @@session.max_delayed_threads = @start_session_value;
364 Warnings:
365 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.
366 SELECT @@session.max_delayed_threads;
367 @@session.max_delayed_threads
368 20
369 Warnings:
370 Warning 1287 '@@max_delayed_threads' is deprecated and will be removed in a future release.