Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.character_set_filesystem;
2 SELECT @global_start_value;
3 @global_start_value
4 binary
5 SET @session_start_value = @@character_set_filesystem;
6 SELECT @session_start_value;
7 @session_start_value
8 binary
9 SET @session_start_value = @@local.character_set_filesystem;
10 SELECT @session_start_value;
11 @session_start_value
12 binary
13 SET @session_start_value = @@session.character_set_filesystem;
14 SELECT @session_start_value;
15 @session_start_value
16 binary
17 '#--------------------FN_DYNVARS_008_01------------------#'
18 SELECT character_set_filesystem;
19 ERROR 42S22: Unknown column 'character_set_filesystem' in 'field list'
20 SET character_set_filesystem=utf8;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 SELECT @@session.character_set_filesystem;
24 @@session.character_set_filesystem
25 utf8mb3
26 SET global.character_set_filesystem=utf8;
27 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.character_set_filesystem=utf8' at line 1
28 SET session character_set_filesystem=utf8;
29 Warnings:
30 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
31 SELECT session character_set_filesystem;
32 ERROR 42S22: Unknown column 'session' in 'field list'
33 SET global character_set_filesystem=utf8;
34 Warnings:
35 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
36 SELECT global character_set_filesystem;
37 ERROR 42S22: Unknown column 'global' in 'field list'
38 '#--------------------FN_DYNVARS_008_02-------------------------#'
39 SET @@character_set_filesystem = latin5;
40 SET @@character_set_filesystem = DEFAULT;
41 SELECT @@character_set_filesystem AS DEFAULT_VALUE;
42 DEFAULT_VALUE
43 utf8mb3
44 SET @@global.character_set_filesystem = latin5;
45 SET @@global.character_set_filesystem = DEFAULT;
46 SELECT @@global.character_set_filesystem AS DEFAULT_VALUE;
47 DEFAULT_VALUE
48 binary
49 '#--------------------FN_DYNVARS_008_03-------------------------#'
50 SET @@session.character_set_filesystem = utf8;
51 Warnings:
52 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
53 SELECT @@session.character_set_filesystem;
54 @@session.character_set_filesystem
55 utf8mb3
56 SET @@global.character_set_filesystem = latin2;
57 SELECT @@global.character_set_filesystem;
58 @@global.character_set_filesystem
59 latin2
60 SELECT @@session.character_set_filesystem AS res_is_utf8;
61 res_is_utf8
62 utf8mb3
63 SET @@session.character_set_filesystem = latin5;
64 SELECT @@session.character_set_filesystem;
65 @@session.character_set_filesystem
66 latin5
67 SELECT @@global.character_set_filesystem AS res_is_latin2;
68 res_is_latin2
69 latin2
70 SELECT @@global.character_set_filesystem=
71 @@session.character_set_filesystem AS res_is_false;
72 res_is_false
73 0
74 '#--------------------FN_DYNVARS_008_04-------------------------#'
75 SELECT @@character_set_filesystem = @@session.character_set_filesystem AS res;
76 res
77 1
78 SELECT @@character_set_filesystem = @@local.character_set_filesystem AS res;
79 res
80 1
81 '#--------------------FN_DYNVARS_008_05-------------------------#'
82 SET @@character_set_filesystem = utf8 + latin2;
83 ERROR 42S22: Unknown column 'utf8' in 'field list'
84 '#--------------------FN_DYNVARS_008_06-------------------------#'
85 SET @@session.character_set_filesystem = big5;
86 SELECT @@session.character_set_filesystem;
87 @@session.character_set_filesystem
88 big5
89 SET @@session.character_set_filesystem = dec8;
90 Warnings:
91 Warning 1287 'dec8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
92 SELECT @@session.character_set_filesystem;
93 @@session.character_set_filesystem
94 dec8
95 SET @@session.character_set_filesystem = cp850;
96 SELECT @@session.character_set_filesystem;
97 @@session.character_set_filesystem
98 cp850
99 SET @@session.character_set_filesystem = hp8;
100 Warnings:
101 Warning 1287 'hp8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
102 SELECT @@session.character_set_filesystem;
103 @@session.character_set_filesystem
104 hp8
105 SET @@session.character_set_filesystem = koi8r;
106 SELECT @@session.character_set_filesystem;
107 @@session.character_set_filesystem
108 koi8r
109 SET @@session.character_set_filesystem = latin1;
110 SELECT @@session.character_set_filesystem;
111 @@session.character_set_filesystem
112 latin1
113 SET @@session.character_set_filesystem = latin2;
114 SELECT @@session.character_set_filesystem;
115 @@session.character_set_filesystem
116 latin2
117 SET @@session.character_set_filesystem = swe7;
118 SELECT @@session.character_set_filesystem;
119 @@session.character_set_filesystem
120 swe7
121 SET @@session.character_set_filesystem = ascii;
122 SELECT @@session.character_set_filesystem;
123 @@session.character_set_filesystem
124 ascii
125 SET @@session.character_set_filesystem = ujis;
126 SELECT @@session.character_set_filesystem;
127 @@session.character_set_filesystem
128 ujis
129 SET @@session.character_set_filesystem = sjis;
130 SELECT @@session.character_set_filesystem;
131 @@session.character_set_filesystem
132 sjis
133 SET @@session.character_set_filesystem = hebrew;
134 SELECT @@session.character_set_filesystem;
135 @@session.character_set_filesystem
136 hebrew
137 SET @@session.character_set_filesystem = tis620;
138 SELECT @@session.character_set_filesystem;
139 @@session.character_set_filesystem
140 tis620
141 SET @@session.character_set_filesystem = euckr;
142 SELECT @@session.character_set_filesystem;
143 @@session.character_set_filesystem
144 euckr
145 SET @@session.character_set_filesystem = koi8u;
146 SELECT @@session.character_set_filesystem;
147 @@session.character_set_filesystem
148 koi8u
149 SET @@session.character_set_filesystem = gb2312;
150 SELECT @@session.character_set_filesystem;
151 @@session.character_set_filesystem
152 gb2312
153 SET @@session.character_set_filesystem = greek;
154 SELECT @@session.character_set_filesystem;
155 @@session.character_set_filesystem
156 greek
157 SET @@session.character_set_filesystem = cp1250;
158 SELECT @@session.character_set_filesystem;
159 @@session.character_set_filesystem
160 cp1250
161 SET @@session.character_set_filesystem = gbk;
162 SELECT @@session.character_set_filesystem;
163 @@session.character_set_filesystem
164 gbk
165 SET @@session.character_set_filesystem = gb18030;
166 SELECT @@session.character_set_filesystem;
167 @@session.character_set_filesystem
168 gb18030
169 SET @@session.character_set_filesystem = latin5;
170 SELECT @@session.character_set_filesystem;
171 @@session.character_set_filesystem
172 latin5
173 SET @@session.character_set_filesystem = armscii8;
174 SELECT @@session.character_set_filesystem;
175 @@session.character_set_filesystem
176 armscii8
177 SET @@session.character_set_filesystem = utf8;
178 Warnings:
179 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
180 SELECT @@session.character_set_filesystem;
181 @@session.character_set_filesystem
182 utf8mb3
183 SET @@session.character_set_filesystem = utf8mb4;
184 SELECT @@session.character_set_filesystem;
185 @@session.character_set_filesystem
186 utf8mb4
187 SET @@session.character_set_filesystem = ucs2;
188 Warnings:
189 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
190 SELECT @@session.character_set_filesystem;
191 @@session.character_set_filesystem
192 ucs2
193 SET @@session.character_set_filesystem = cp866;
194 SELECT @@session.character_set_filesystem;
195 @@session.character_set_filesystem
196 cp866
197 SET @@session.character_set_filesystem = keybcs2;
198 SELECT @@session.character_set_filesystem;
199 @@session.character_set_filesystem
200 keybcs2
201 SET @@session.character_set_filesystem = macce;
202 Warnings:
203 Warning 1287 'macce' is deprecated and will be removed in a future release. Please use utf8mb4 instead
204 SELECT @@session.character_set_filesystem;
205 @@session.character_set_filesystem
206 macce
207 SET @@session.character_set_filesystem = macroman;
208 Warnings:
209 Warning 1287 'macroman' is deprecated and will be removed in a future release. Please use utf8mb4 instead
210 SELECT @@session.character_set_filesystem;
211 @@session.character_set_filesystem
212 macroman
213 SET @@session.character_set_filesystem = cp852;
214 SELECT @@session.character_set_filesystem;
215 @@session.character_set_filesystem
216 cp852
217 SET @@session.character_set_filesystem = latin7;
218 SELECT @@session.character_set_filesystem;
219 @@session.character_set_filesystem
220 latin7
221 SET @@session.character_set_filesystem = cp1251;
222 SELECT @@session.character_set_filesystem;
223 @@session.character_set_filesystem
224 cp1251
225 SET @@session.character_set_filesystem = cp1256;
226 SELECT @@session.character_set_filesystem;
227 @@session.character_set_filesystem
228 cp1256
229 SET @@session.character_set_filesystem = cp1257;
230 SELECT @@session.character_set_filesystem;
231 @@session.character_set_filesystem
232 cp1257
233 SET @@session.character_set_filesystem = binary;
234 SELECT @@session.character_set_filesystem;
235 @@session.character_set_filesystem
236 binary
237 SET @@session.character_set_filesystem = geostd8;
238 SELECT @@session.character_set_filesystem;
239 @@session.character_set_filesystem
240 geostd8
241 SET @@session.character_set_filesystem = cp932;
242 SELECT @@session.character_set_filesystem;
243 @@session.character_set_filesystem
244 cp932
245 SET @@session.character_set_filesystem = eucjpms;
246 SELECT @@session.character_set_filesystem;
247 @@session.character_set_filesystem
248 eucjpms
249 '#--------------------FN_DYNVARS_008_07-------------------------#'
250 SET @@global.character_set_filesystem = big5;
251 SELECT @@global.character_set_filesystem;
252 @@global.character_set_filesystem
253 big5
254 SET @@global.character_set_filesystem = dec8;
255 Warnings:
256 Warning 1287 'dec8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
257 SELECT @@global.character_set_filesystem;
258 @@global.character_set_filesystem
259 dec8
260 SET @@global.character_set_filesystem = cp850;
261 SELECT @@global.character_set_filesystem;
262 @@global.character_set_filesystem
263 cp850
264 SET @@global.character_set_filesystem = hp8;
265 Warnings:
266 Warning 1287 'hp8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
267 SELECT @@global.character_set_filesystem;
268 @@global.character_set_filesystem
269 hp8
270 SET @@global.character_set_filesystem = koi8r;
271 SELECT @@global.character_set_filesystem;
272 @@global.character_set_filesystem
273 koi8r
274 SET @@global.character_set_filesystem = latin1;
275 SELECT @@global.character_set_filesystem;
276 @@global.character_set_filesystem
277 latin1
278 SET @@global.character_set_filesystem = latin2;
279 SELECT @@global.character_set_filesystem;
280 @@global.character_set_filesystem
281 latin2
282 SET @@global.character_set_filesystem = swe7;
283 SELECT @@global.character_set_filesystem;
284 @@global.character_set_filesystem
285 swe7
286 SET @@global.character_set_filesystem = ascii;
287 SELECT @@global.character_set_filesystem;
288 @@global.character_set_filesystem
289 ascii
290 SET @@global.character_set_filesystem = ujis;
291 SELECT @@global.character_set_filesystem;
292 @@global.character_set_filesystem
293 ujis
294 SET @@global.character_set_filesystem = sjis;
295 SELECT @@global.character_set_filesystem;
296 @@global.character_set_filesystem
297 sjis
298 SET @@global.character_set_filesystem = hebrew;
299 SELECT @@global.character_set_filesystem;
300 @@global.character_set_filesystem
301 hebrew
302 SET @@global.character_set_filesystem = tis620;
303 SELECT @@global.character_set_filesystem;
304 @@global.character_set_filesystem
305 tis620
306 SET @@global.character_set_filesystem = euckr;
307 SELECT @@global.character_set_filesystem;
308 @@global.character_set_filesystem
309 euckr
310 SET @@global.character_set_filesystem = koi8u;
311 SELECT @@global.character_set_filesystem;
312 @@global.character_set_filesystem
313 koi8u
314 SET @@global.character_set_filesystem = gb2312;
315 SELECT @@global.character_set_filesystem;
316 @@global.character_set_filesystem
317 gb2312
318 SET @@global.character_set_filesystem = greek;
319 SELECT @@global.character_set_filesystem;
320 @@global.character_set_filesystem
321 greek
322 SET @@global.character_set_filesystem = cp1250;
323 SELECT @@global.character_set_filesystem;
324 @@global.character_set_filesystem
325 cp1250
326 SET @@global.character_set_filesystem = gbk;
327 SELECT @@global.character_set_filesystem;
328 @@global.character_set_filesystem
329 gbk
330 SET @@global.character_set_filesystem = gb18030;
331 SELECT @@global.character_set_filesystem;
332 @@global.character_set_filesystem
333 gb18030
334 SET @@global.character_set_filesystem = latin5;
335 SELECT @@global.character_set_filesystem;
336 @@global.character_set_filesystem
337 latin5
338 SET @@global.character_set_filesystem = armscii8;
339 SELECT @@global.character_set_filesystem;
340 @@global.character_set_filesystem
341 armscii8
342 SET @@global.character_set_filesystem = utf8;
343 Warnings:
344 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
345 SELECT @@global.character_set_filesystem;
346 @@global.character_set_filesystem
347 utf8mb3
348 SET @@global.character_set_filesystem = utf8mb4;
349 SELECT @@global.character_set_filesystem;
350 @@global.character_set_filesystem
351 utf8mb4
352 SET @@global.character_set_filesystem = ucs2;
353 Warnings:
354 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
355 SELECT @@global.character_set_filesystem;
356 @@global.character_set_filesystem
357 ucs2
358 SET @@global.character_set_filesystem = cp866;
359 SELECT @@global.character_set_filesystem;
360 @@global.character_set_filesystem
361 cp866
362 SET @@global.character_set_filesystem = keybcs2;
363 SELECT @@global.character_set_filesystem;
364 @@global.character_set_filesystem
365 keybcs2
366 SET @@global.character_set_filesystem = macce;
367 Warnings:
368 Warning 1287 'macce' is deprecated and will be removed in a future release. Please use utf8mb4 instead
369 SELECT @@global.character_set_filesystem;
370 @@global.character_set_filesystem
371 macce
372 SET @@global.character_set_filesystem = macroman;
373 Warnings:
374 Warning 1287 'macroman' is deprecated and will be removed in a future release. Please use utf8mb4 instead
375 SELECT @@global.character_set_filesystem;
376 @@global.character_set_filesystem
377 macroman
378 SET @@global.character_set_filesystem = cp852;
379 SELECT @@global.character_set_filesystem;
380 @@global.character_set_filesystem
381 cp852
382 SET @@global.character_set_filesystem = latin7;
383 SELECT @@global.character_set_filesystem;
384 @@global.character_set_filesystem
385 latin7
386 SET @@global.character_set_filesystem = cp1251;
387 SELECT @@global.character_set_filesystem;
388 @@global.character_set_filesystem
389 cp1251
390 SET @@global.character_set_filesystem = cp1256;
391 SELECT @@global.character_set_filesystem;
392 @@global.character_set_filesystem
393 cp1256
394 SET @@global.character_set_filesystem = cp1257;
395 SELECT @@global.character_set_filesystem;
396 @@global.character_set_filesystem
397 cp1257
398 SET @@global.character_set_filesystem = binary;
399 SELECT @@global.character_set_filesystem;
400 @@global.character_set_filesystem
401 binary
402 SET @@global.character_set_filesystem = geostd8;
403 SELECT @@global.character_set_filesystem;
404 @@global.character_set_filesystem
405 geostd8
406 SET @@global.character_set_filesystem = cp932;
407 SELECT @@global.character_set_filesystem;
408 @@global.character_set_filesystem
409 cp932
410 SET @@global.character_set_filesystem = eucjpms;
411 SELECT @@global.character_set_filesystem;
412 @@global.character_set_filesystem
413 eucjpms
414 '#--------------------FN_DYNVARS_008_08-------------------------#'
415 SET @@character_set_filesystem = UTF8;
416 Warnings:
417 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
418 SELECT @@character_set_filesystem;
419 @@character_set_filesystem
420 utf8mb3
421 SET @@character_set_filesystem = utf8;
422 Warnings:
423 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
424 SELECT @@character_set_filesystem;
425 @@character_set_filesystem
426 utf8mb3
427 SET @@character_set_filesystem = uTf8;
428 Warnings:
429 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
430 SELECT @@character_set_filesystem;
431 @@character_set_filesystem
432 utf8mb3
433 '#--------------------FN_DYNVARS_008_09-------------------------#'
434 SET @@character_set_filesystem = 1;
435 SELECT @@character_set_filesystem;
436 @@character_set_filesystem
437 big5
438 SET @@character_set_filesystem = 2;
439 SELECT @@character_set_filesystem;
440 @@character_set_filesystem
441 latin2
442 SET @@character_set_filesystem = 3;
443 Warnings:
444 Warning 1287 'dec8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
445 SELECT @@character_set_filesystem;
446 @@character_set_filesystem
447 dec8
448 SET @@character_set_filesystem = 36;
449 SELECT @@character_set_filesystem;
450 @@character_set_filesystem
451 cp866
452 SET @@character_set_filesystem = 99;
453 SELECT @@character_set_filesystem;
454 @@character_set_filesystem
455 cp1250
456 SET @@character_set_filesystem = 100;
457 ERROR 42000: Unknown character set: '100'
458 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
459 SELECT @total_charset;
460 @total_charset
461 41
462 '#--------------------FN_DYNVARS_008_10-------------------------#'
463 SET @@character_set_filesystem = abc;
464 ERROR 42000: Unknown character set: 'abc'
465 SET @@character_set_filesystem = 1utf8;
466 ERROR 42000: Unknown character set: '1utf8'
467 SET @@character_set_filesystem = 0;
468 ERROR 42000: Unknown character set: '0'
469 SET @@character_set_filesystem = 1.1;
470 ERROR 42000: Incorrect argument type to variable 'character_set_filesystem'
471 SET @@character_set_filesystem = -1;
472 ERROR 42000: Unknown character set: '-1'
473 SET @@character_set_filesystem = '';
474 ERROR 42000: Unknown character set: ''
475 SET @@character_set_filesystem = 'utf';
476 ERROR 42000: Unknown character set: 'utf'
477 SET @@character_set_filesystem = true;
478 SELECT @@character_set_filesystem AS res_with_true;
479 res_with_true
480 big5
481 SET @@character_set_filesystem = ON;
482 ERROR 42000: Unknown character set: 'ON'
483 '#--------------------FN_DYNVARS_008_11-------------------------#'
484 SET @@global.character_set_filesystem = abc;
485 ERROR 42000: Unknown character set: 'abc'
486 SET @@global.character_set_filesystem = 1utf8;
487 ERROR 42000: Unknown character set: '1utf8'
488 SET @@global.character_set_filesystem = 0;
489 ERROR 42000: Unknown character set: '0'
490 SET @@global.character_set_filesystem = 1.1;
491 ERROR 42000: Incorrect argument type to variable 'character_set_filesystem'
492 SET @@global.character_set_filesystem = -1;
493 ERROR 42000: Unknown character set: '-1'
494 SET @@global.character_set_filesystem = '';
495 ERROR 42000: Unknown character set: ''
496 SET @@global.character_set_filesystem = 'utf';
497 ERROR 42000: Unknown character set: 'utf'
498 SET @@global.character_set_filesystem = true;
499 SET @@global.character_set_filesystem = ON;
500 ERROR 42000: Unknown character set: 'ON'
501 '#--------------------FN_DYNVARS_008_12-------------------------#'
502 SELECT @@global.character_set_filesystem =
503 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
504 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
505 res
506 1
507 SET @@global.character_set_filesystem = 1;
508 SELECT @@global.character_set_filesystem;
509 @@global.character_set_filesystem
510 big5
511 SELECT @@global.character_set_filesystem =
512 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
513 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
514 res
515 1
516 '#--------------------FN_DYNVARS_008_13-------------------------#'
517 SELECT @@character_set_filesystem =
518 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
519 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
520 res
521 1
522 SELECT @@local.character_set_filesystem =
523 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
524 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
525 res
526 1
527 SELECT @@session.character_set_filesystem =
528 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
529 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
530 res
531 1
532 SET @@global.character_set_filesystem = @global_start_value;
533 SELECT @@global.character_set_filesystem;
534 @@global.character_set_filesystem
535 binary
536 SET @@session.character_set_filesystem = @session_start_value;
537 SELECT @@session.character_set_filesystem;
538 @@session.character_set_filesystem
539 binary