Debian Codegraph @

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

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