Debian Codegraph @

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

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