Debian Codegraph @

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

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