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 'SELECT'
20 SET character_set_filesystem=utf8;
21 SELECT @@session.character_set_filesystem;
22 @@session.character_set_filesystem
23 utf8mb3
24 SET session character_set_filesystem=utf8;
25 SELECT session character_set_filesystem;
26 ERROR 42S22: Unknown column 'session' in 'SELECT'
27 SET global character_set_filesystem=utf8;
28 SELECT global character_set_filesystem;
29 ERROR 42S22: Unknown column 'global' in 'SELECT'
30 '#--------------------FN_DYNVARS_008_02-------------------------#'
31 SET @@character_set_filesystem = latin5;
32 SET @@character_set_filesystem = DEFAULT;
33 SELECT @@character_set_filesystem AS DEFAULT_VALUE;
34 DEFAULT_VALUE
35 utf8mb3
36 SET @@global.character_set_filesystem = latin5;
37 SET @@global.character_set_filesystem = DEFAULT;
38 SELECT @@global.character_set_filesystem AS DEFAULT_VALUE;
39 DEFAULT_VALUE
40 binary
41 '#--------------------FN_DYNVARS_008_03-------------------------#'
42 SET @@session.character_set_filesystem = utf8;
43 SELECT @@session.character_set_filesystem;
44 @@session.character_set_filesystem
45 utf8mb3
46 SET @@global.character_set_filesystem = latin2;
47 SELECT @@global.character_set_filesystem;
48 @@global.character_set_filesystem
49 latin2
50 SELECT @@session.character_set_filesystem AS res_is_utf8;
51 res_is_utf8
52 utf8mb3
53 SET @@session.character_set_filesystem = latin5;
54 SELECT @@session.character_set_filesystem;
55 @@session.character_set_filesystem
56 latin5
57 SELECT @@global.character_set_filesystem AS res_is_latin2;
58 res_is_latin2
59 latin2
60 SELECT @@global.character_set_filesystem=
61 @@session.character_set_filesystem AS res_is_false;
62 res_is_false
63 0
64 '#--------------------FN_DYNVARS_008_04-------------------------#'
65 SELECT @@character_set_filesystem = @@session.character_set_filesystem AS res;
66 res
67 1
68 SELECT @@character_set_filesystem = @@local.character_set_filesystem AS res;
69 res
70 1
71 '#--------------------FN_DYNVARS_008_05-------------------------#'
72 SET @@character_set_filesystem = utf8 + latin2;
73 ERROR 42S22: Unknown column 'utf8' in 'SET'
74 '#--------------------FN_DYNVARS_008_06-------------------------#'
75 SET @@session.character_set_filesystem = big5;
76 SELECT @@session.character_set_filesystem;
77 @@session.character_set_filesystem
78 big5
79 SET @@session.character_set_filesystem = dec8;
80 SELECT @@session.character_set_filesystem;
81 @@session.character_set_filesystem
82 dec8
83 SET @@session.character_set_filesystem = cp850;
84 SELECT @@session.character_set_filesystem;
85 @@session.character_set_filesystem
86 cp850
87 SET @@session.character_set_filesystem = hp8;
88 SELECT @@session.character_set_filesystem;
89 @@session.character_set_filesystem
90 hp8
91 SET @@session.character_set_filesystem = koi8r;
92 SELECT @@session.character_set_filesystem;
93 @@session.character_set_filesystem
94 koi8r
95 SET @@session.character_set_filesystem = latin1;
96 SELECT @@session.character_set_filesystem;
97 @@session.character_set_filesystem
98 latin1
99 SET @@session.character_set_filesystem = latin2;
100 SELECT @@session.character_set_filesystem;
101 @@session.character_set_filesystem
102 latin2
103 SET @@session.character_set_filesystem = swe7;
104 SELECT @@session.character_set_filesystem;
105 @@session.character_set_filesystem
106 swe7
107 SET @@session.character_set_filesystem = ascii;
108 SELECT @@session.character_set_filesystem;
109 @@session.character_set_filesystem
110 ascii
111 SET @@session.character_set_filesystem = ujis;
112 SELECT @@session.character_set_filesystem;
113 @@session.character_set_filesystem
114 ujis
115 SET @@session.character_set_filesystem = sjis;
116 SELECT @@session.character_set_filesystem;
117 @@session.character_set_filesystem
118 sjis
119 SET @@session.character_set_filesystem = hebrew;
120 SELECT @@session.character_set_filesystem;
121 @@session.character_set_filesystem
122 hebrew
123 SET @@session.character_set_filesystem = tis620;
124 SELECT @@session.character_set_filesystem;
125 @@session.character_set_filesystem
126 tis620
127 SET @@session.character_set_filesystem = euckr;
128 SELECT @@session.character_set_filesystem;
129 @@session.character_set_filesystem
130 euckr
131 SET @@session.character_set_filesystem = koi8u;
132 SELECT @@session.character_set_filesystem;
133 @@session.character_set_filesystem
134 koi8u
135 SET @@session.character_set_filesystem = gb2312;
136 SELECT @@session.character_set_filesystem;
137 @@session.character_set_filesystem
138 gb2312
139 SET @@session.character_set_filesystem = greek;
140 SELECT @@session.character_set_filesystem;
141 @@session.character_set_filesystem
142 greek
143 SET @@session.character_set_filesystem = cp1250;
144 SELECT @@session.character_set_filesystem;
145 @@session.character_set_filesystem
146 cp1250
147 SET @@session.character_set_filesystem = gbk;
148 SELECT @@session.character_set_filesystem;
149 @@session.character_set_filesystem
150 gbk
151 SET @@session.character_set_filesystem = latin5;
152 SELECT @@session.character_set_filesystem;
153 @@session.character_set_filesystem
154 latin5
155 SET @@session.character_set_filesystem = armscii8;
156 SELECT @@session.character_set_filesystem;
157 @@session.character_set_filesystem
158 armscii8
159 SET @@session.character_set_filesystem = utf8;
160 SELECT @@session.character_set_filesystem;
161 @@session.character_set_filesystem
162 utf8mb3
163 SET @@session.character_set_filesystem = ucs2;
164 SELECT @@session.character_set_filesystem;
165 @@session.character_set_filesystem
166 ucs2
167 SET @@session.character_set_filesystem = cp866;
168 SELECT @@session.character_set_filesystem;
169 @@session.character_set_filesystem
170 cp866
171 SET @@session.character_set_filesystem = keybcs2;
172 SELECT @@session.character_set_filesystem;
173 @@session.character_set_filesystem
174 keybcs2
175 SET @@session.character_set_filesystem = macce;
176 SELECT @@session.character_set_filesystem;
177 @@session.character_set_filesystem
178 macce
179 SET @@session.character_set_filesystem = macroman;
180 SELECT @@session.character_set_filesystem;
181 @@session.character_set_filesystem
182 macroman
183 SET @@session.character_set_filesystem = cp852;
184 SELECT @@session.character_set_filesystem;
185 @@session.character_set_filesystem
186 cp852
187 SET @@session.character_set_filesystem = latin7;
188 SELECT @@session.character_set_filesystem;
189 @@session.character_set_filesystem
190 latin7
191 SET @@session.character_set_filesystem = cp1251;
192 SELECT @@session.character_set_filesystem;
193 @@session.character_set_filesystem
194 cp1251
195 SET @@session.character_set_filesystem = cp1256;
196 SELECT @@session.character_set_filesystem;
197 @@session.character_set_filesystem
198 cp1256
199 SET @@session.character_set_filesystem = cp1257;
200 SELECT @@session.character_set_filesystem;
201 @@session.character_set_filesystem
202 cp1257
203 SET @@session.character_set_filesystem = binary;
204 SELECT @@session.character_set_filesystem;
205 @@session.character_set_filesystem
206 binary
207 SET @@session.character_set_filesystem = geostd8;
208 SELECT @@session.character_set_filesystem;
209 @@session.character_set_filesystem
210 geostd8
211 SET @@session.character_set_filesystem = cp932;
212 SELECT @@session.character_set_filesystem;
213 @@session.character_set_filesystem
214 cp932
215 SET @@session.character_set_filesystem = eucjpms;
216 SELECT @@session.character_set_filesystem;
217 @@session.character_set_filesystem
218 eucjpms
219 '#--------------------FN_DYNVARS_008_07-------------------------#'
220 SET @@global.character_set_filesystem = big5;
221 SELECT @@global.character_set_filesystem;
222 @@global.character_set_filesystem
223 big5
224 SET @@global.character_set_filesystem = dec8;
225 SELECT @@global.character_set_filesystem;
226 @@global.character_set_filesystem
227 dec8
228 SET @@global.character_set_filesystem = cp850;
229 SELECT @@global.character_set_filesystem;
230 @@global.character_set_filesystem
231 cp850
232 SET @@global.character_set_filesystem = hp8;
233 SELECT @@global.character_set_filesystem;
234 @@global.character_set_filesystem
235 hp8
236 SET @@global.character_set_filesystem = koi8r;
237 SELECT @@global.character_set_filesystem;
238 @@global.character_set_filesystem
239 koi8r
240 SET @@global.character_set_filesystem = latin1;
241 SELECT @@global.character_set_filesystem;
242 @@global.character_set_filesystem
243 latin1
244 SET @@global.character_set_filesystem = latin2;
245 SELECT @@global.character_set_filesystem;
246 @@global.character_set_filesystem
247 latin2
248 SET @@global.character_set_filesystem = swe7;
249 SELECT @@global.character_set_filesystem;
250 @@global.character_set_filesystem
251 swe7
252 SET @@global.character_set_filesystem = ascii;
253 SELECT @@global.character_set_filesystem;
254 @@global.character_set_filesystem
255 ascii
256 SET @@global.character_set_filesystem = ujis;
257 SELECT @@global.character_set_filesystem;
258 @@global.character_set_filesystem
259 ujis
260 SET @@global.character_set_filesystem = sjis;
261 SELECT @@global.character_set_filesystem;
262 @@global.character_set_filesystem
263 sjis
264 SET @@global.character_set_filesystem = hebrew;
265 SELECT @@global.character_set_filesystem;
266 @@global.character_set_filesystem
267 hebrew
268 SET @@global.character_set_filesystem = tis620;
269 SELECT @@global.character_set_filesystem;
270 @@global.character_set_filesystem
271 tis620
272 SET @@global.character_set_filesystem = euckr;
273 SELECT @@global.character_set_filesystem;
274 @@global.character_set_filesystem
275 euckr
276 SET @@global.character_set_filesystem = koi8u;
277 SELECT @@global.character_set_filesystem;
278 @@global.character_set_filesystem
279 koi8u
280 SET @@global.character_set_filesystem = gb2312;
281 SELECT @@global.character_set_filesystem;
282 @@global.character_set_filesystem
283 gb2312
284 SET @@global.character_set_filesystem = greek;
285 SELECT @@global.character_set_filesystem;
286 @@global.character_set_filesystem
287 greek
288 SET @@global.character_set_filesystem = cp1250;
289 SELECT @@global.character_set_filesystem;
290 @@global.character_set_filesystem
291 cp1250
292 SET @@global.character_set_filesystem = gbk;
293 SELECT @@global.character_set_filesystem;
294 @@global.character_set_filesystem
295 gbk
296 SET @@global.character_set_filesystem = latin5;
297 SELECT @@global.character_set_filesystem;
298 @@global.character_set_filesystem
299 latin5
300 SET @@global.character_set_filesystem = armscii8;
301 SELECT @@global.character_set_filesystem;
302 @@global.character_set_filesystem
303 armscii8
304 SET @@global.character_set_filesystem = utf8;
305 SELECT @@global.character_set_filesystem;
306 @@global.character_set_filesystem
307 utf8mb3
308 SET @@global.character_set_filesystem = ucs2;
309 SELECT @@global.character_set_filesystem;
310 @@global.character_set_filesystem
311 ucs2
312 SET @@global.character_set_filesystem = cp866;
313 SELECT @@global.character_set_filesystem;
314 @@global.character_set_filesystem
315 cp866
316 SET @@global.character_set_filesystem = keybcs2;
317 SELECT @@global.character_set_filesystem;
318 @@global.character_set_filesystem
319 keybcs2
320 SET @@global.character_set_filesystem = macce;
321 SELECT @@global.character_set_filesystem;
322 @@global.character_set_filesystem
323 macce
324 SET @@global.character_set_filesystem = macroman;
325 SELECT @@global.character_set_filesystem;
326 @@global.character_set_filesystem
327 macroman
328 SET @@global.character_set_filesystem = cp852;
329 SELECT @@global.character_set_filesystem;
330 @@global.character_set_filesystem
331 cp852
332 SET @@global.character_set_filesystem = latin7;
333 SELECT @@global.character_set_filesystem;
334 @@global.character_set_filesystem
335 latin7
336 SET @@global.character_set_filesystem = cp1251;
337 SELECT @@global.character_set_filesystem;
338 @@global.character_set_filesystem
339 cp1251
340 SET @@global.character_set_filesystem = cp1256;
341 SELECT @@global.character_set_filesystem;
342 @@global.character_set_filesystem
343 cp1256
344 SET @@global.character_set_filesystem = cp1257;
345 SELECT @@global.character_set_filesystem;
346 @@global.character_set_filesystem
347 cp1257
348 SET @@global.character_set_filesystem = binary;
349 SELECT @@global.character_set_filesystem;
350 @@global.character_set_filesystem
351 binary
352 SET @@global.character_set_filesystem = geostd8;
353 SELECT @@global.character_set_filesystem;
354 @@global.character_set_filesystem
355 geostd8
356 SET @@global.character_set_filesystem = cp932;
357 SELECT @@global.character_set_filesystem;
358 @@global.character_set_filesystem
359 cp932
360 SET @@global.character_set_filesystem = eucjpms;
361 SELECT @@global.character_set_filesystem;
362 @@global.character_set_filesystem
363 eucjpms
364 '#--------------------FN_DYNVARS_008_08-------------------------#'
365 SET @@character_set_filesystem = UTF8;
366 SELECT @@character_set_filesystem;
367 @@character_set_filesystem
368 utf8mb3
369 SET @@character_set_filesystem = utf8;
370 SELECT @@character_set_filesystem;
371 @@character_set_filesystem
372 utf8mb3
373 SET @@character_set_filesystem = uTf8;
374 SELECT @@character_set_filesystem;
375 @@character_set_filesystem
376 utf8mb3
377 '#--------------------FN_DYNVARS_008_09-------------------------#'
378 SET @@character_set_filesystem = 1;
379 SELECT @@character_set_filesystem;
380 @@character_set_filesystem
381 big5
382 # latin2_czech_cs is not a default collation
383 SET @@character_set_filesystem = 2;
384 ERROR 42000: Unknown character set: '2'
385 SET @@character_set_filesystem = 3;
386 SELECT @@character_set_filesystem;
387 @@character_set_filesystem
388 dec8
389 SET @@character_set_filesystem = 36;
390 SELECT @@character_set_filesystem;
391 @@character_set_filesystem
392 cp866
393 # cp1250_polish_ci is not a default collation
394 SET @@character_set_filesystem = 99;
395 ERROR 42000: Unknown character set: '99'
396 # Collation ID 100 does not exist
397 SET @@character_set_filesystem = 100;
398 ERROR 42000: Unknown character set: '100'
399 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
400 SELECT @total_charset;
401 @total_charset
402 40
403 '#--------------------FN_DYNVARS_008_10-------------------------#'
404 SET @@character_set_filesystem = abc;
405 ERROR 42000: Unknown character set: 'abc'
406 SET @@character_set_filesystem = 1utf8;
407 ERROR 42000: Unknown character set: '1utf8'
408 SET @@character_set_filesystem = 0;
409 ERROR 42000: Unknown character set: '0'
410 SET @@character_set_filesystem = 1.1;
411 ERROR 42000: Incorrect argument type to variable 'character_set_filesystem'
412 SET @@character_set_filesystem = -1;
413 ERROR 42000: Unknown character set: '-1'
414 SET @@character_set_filesystem = '';
415 ERROR 42000: Unknown character set: ''
416 SET @@character_set_filesystem = 'utf';
417 ERROR 42000: Unknown character set: 'utf'
418 SET @@character_set_filesystem = true;
419 SELECT @@character_set_filesystem AS res_with_true;
420 res_with_true
421 big5
422 SET @@character_set_filesystem = ON;
423 ERROR 42000: Unknown character set: 'ON'
424 '#--------------------FN_DYNVARS_008_11-------------------------#'
425 SET @@global.character_set_filesystem = abc;
426 ERROR 42000: Unknown character set: 'abc'
427 SET @@global.character_set_filesystem = 1utf8;
428 ERROR 42000: Unknown character set: '1utf8'
429 SET @@global.character_set_filesystem = 0;
430 ERROR 42000: Unknown character set: '0'
431 SET @@global.character_set_filesystem = 1.1;
432 ERROR 42000: Incorrect argument type to variable 'character_set_filesystem'
433 SET @@global.character_set_filesystem = -1;
434 ERROR 42000: Unknown character set: '-1'
435 SET @@global.character_set_filesystem = '';
436 ERROR 42000: Unknown character set: ''
437 SET @@global.character_set_filesystem = 'utf';
438 ERROR 42000: Unknown character set: 'utf'
439 SET @@global.character_set_filesystem = true;
440 SET @@global.character_set_filesystem = ON;
441 ERROR 42000: Unknown character set: 'ON'
442 '#--------------------FN_DYNVARS_008_12-------------------------#'
443 SELECT @@global.character_set_filesystem =
444 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
445 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
446 res
447 1
448 SET @@global.character_set_filesystem = 1;
449 SELECT @@global.character_set_filesystem;
450 @@global.character_set_filesystem
451 big5
452 SELECT @@global.character_set_filesystem =
453 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
454 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
455 res
456 1
457 '#--------------------FN_DYNVARS_008_13-------------------------#'
458 SELECT @@character_set_filesystem =
459 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
460 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
461 res
462 1
463 SELECT @@local.character_set_filesystem =
464 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
465 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
466 res
467 1
468 SELECT @@session.character_set_filesystem =
469 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
470 WHERE VARIABLE_NAME='character_set_filesystem') AS res;
471 res
472 1
473 SET @@global.character_set_filesystem = @global_start_value;
474 SELECT @@global.character_set_filesystem;
475 @@global.character_set_filesystem
476 binary
477 SET @@session.character_set_filesystem = @session_start_value;
478 SELECT @@session.character_set_filesystem;
479 @@session.character_set_filesystem
480 binary