Debian Codegraph @

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

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