Debian Codegraph @

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

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