Debian Codegraph @

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

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