Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.collation_server;
2 SET @@global.collation_server= @@collation_server;
3 SET @session_start_value = @@collation_server;
4 SELECT @session_start_value;
5 @session_start_value
6 utf8mb4_uca1400_ai_ci
7 SET @session_start_value = @@local.collation_server;
8 SELECT @session_start_value;
9 @session_start_value
10 utf8mb4_uca1400_ai_ci
11 SET @session_start_value = @@session.collation_server;
12 SELECT @session_start_value;
13 @session_start_value
14 utf8mb4_uca1400_ai_ci
15 '#--------------------FN_DYNVARS_014_01------------------#'
16 SELECT collation_server;
17 ERROR 42S22: Unknown column 'collation_server' in 'SELECT'
18 SET collation_server=utf8_unicode_ci;
19 SELECT @@session.collation_server;
20 @@session.collation_server
21 utf8mb3_unicode_ci
22 SET session collation_server=utf8_unicode_ci;
23 SELECT session collation_server;
24 ERROR 42S22: Unknown column 'session' in 'SELECT'
25 SET global collation_server=utf8_unicode_ci;
26 SELECT global collation_server;
27 ERROR 42S22: Unknown column 'global' in 'SELECT'
28 '#--------------------FN_DYNVARS_014_02-------------------------#'
29 SET @@collation_server = latin1_bin;
30 SET @@collation_server = DEFAULT;
31 SELECT @@collation_server= @@global.collation_server;
32 @@collation_server= @@global.collation_server
33 1
34 SET @@global.collation_server = latin1_bin;
35 SET @@global.collation_server = DEFAULT;
36 SELECT @@global.collation_server = @global_start_value;
37 @@global.collation_server = @global_start_value
38 1
39 '#--------------------FN_DYNVARS_014_03-------------------------#'
40 SET @@session.collation_server = utf8_polish_ci;
41 SELECT @@session.collation_server;
42 @@session.collation_server
43 utf8mb3_polish_ci
44 SET @@global.collation_server = latin7_general_ci;
45 SELECT @@global.collation_server;
46 @@global.collation_server
47 latin7_general_ci
48 SELECT @@session.collation_server AS res_is_utf8_polish_ci;
49 res_is_utf8_polish_ci
50 utf8mb3_polish_ci
51 SET @@session.collation_server = latin7_bin;
52 SELECT @@session.collation_server;
53 @@session.collation_server
54 latin7_bin
55 SELECT @@global.collation_server AS res_is_latin7_general_ci;
56 res_is_latin7_general_ci
57 latin7_general_ci
58 SELECT @@global.collation_server=@@session.collation_server AS res_is_false;
59 res_is_false
60 0
61 '#--------------------FN_DYNVARS_014_04-------------------------#'
62 SELECT @@collation_server = @@session.collation_server AS res;
63 res
64 1
65 SELECT @@collation_server = @@local.collation_server AS res;
66 res
67 1
68 '#--------------------FN_DYNVARS_014_05-------------------------#'
69 SET @@collation_server = latin7_general_ci + latin7_general_cs;
70 ERROR 42S22: Unknown column 'latin7_general_ci' in 'SET'
71 '#--------------------FN_DYNVARS_014_06-------------------------#'
72 SET @@session.collation_server = big5_chinese_ci;
73 SELECT @@session.collation_server;
74 @@session.collation_server
75 big5_chinese_ci
76 SET @@session.collation_server = big5_bin;
77 SELECT @@session.collation_server;
78 @@session.collation_server
79 big5_bin
80 SET @@session.collation_server = dec8_swedish_ci;
81 SELECT @@session.collation_server;
82 @@session.collation_server
83 dec8_swedish_ci
84 SET @@session.collation_server = dec8_bin;
85 SELECT @@session.collation_server;
86 @@session.collation_server
87 dec8_bin
88 SET @@session.collation_server = cp850_general_ci;
89 SELECT @@session.collation_server;
90 @@session.collation_server
91 cp850_general_ci
92 SET @@session.collation_server = cp850_bin;
93 SELECT @@session.collation_server;
94 @@session.collation_server
95 cp850_bin
96 SET @@session.collation_server = hp8_english_ci;
97 SELECT @@session.collation_server;
98 @@session.collation_server
99 hp8_english_ci
100 SET @@session.collation_server = hp8_bin;
101 SELECT @@session.collation_server;
102 @@session.collation_server
103 hp8_bin
104 SET @@session.collation_server = koi8r_general_ci;
105 SELECT @@session.collation_server;
106 @@session.collation_server
107 koi8r_general_ci
108 SET @@session.collation_server = koi8r_bin;
109 SELECT @@session.collation_server;
110 @@session.collation_server
111 koi8r_bin
112 SET @@session.collation_server = latin1_german1_ci;
113 SELECT @@session.collation_server;
114 @@session.collation_server
115 latin1_german1_ci
116 SET @@session.collation_server = latin1_swedish_ci;
117 SELECT @@session.collation_server;
118 @@session.collation_server
119 latin1_swedish_ci
120 SET @@session.collation_server = latin1_danish_ci;
121 SELECT @@session.collation_server;
122 @@session.collation_server
123 latin1_danish_ci
124 SET @@session.collation_server = latin1_german2_ci;
125 SELECT @@session.collation_server;
126 @@session.collation_server
127 latin1_german2_ci
128 SET @@session.collation_server = latin1_bin;
129 SELECT @@session.collation_server;
130 @@session.collation_server
131 latin1_bin
132 SET @@session.collation_server = latin1_general_ci;
133 SELECT @@session.collation_server;
134 @@session.collation_server
135 latin1_general_ci
136 SET @@session.collation_server = latin1_general_cs;
137 SELECT @@session.collation_server;
138 @@session.collation_server
139 latin1_general_cs
140 SET @@session.collation_server = latin1_spanish_ci;
141 SELECT @@session.collation_server;
142 @@session.collation_server
143 latin1_spanish_ci
144 SET @@session.collation_server = latin2_czech_cs;
145 SELECT @@session.collation_server;
146 @@session.collation_server
147 latin2_czech_cs
148 SET @@session.collation_server = latin2_general_ci;
149 SELECT @@session.collation_server;
150 @@session.collation_server
151 latin2_general_ci
152 SET @@session.collation_server = latin2_hungarian_ci;
153 SELECT @@session.collation_server;
154 @@session.collation_server
155 latin2_hungarian_ci
156 SET @@session.collation_server = latin2_croatian_ci;
157 SELECT @@session.collation_server;
158 @@session.collation_server
159 latin2_croatian_ci
160 SET @@session.collation_server = latin2_bin;
161 SELECT @@session.collation_server;
162 @@session.collation_server
163 latin2_bin
164 SET @@session.collation_server = swe7_swedish_ci;
165 SELECT @@session.collation_server;
166 @@session.collation_server
167 swe7_swedish_ci
168 SET @@session.collation_server = swe7_bin;
169 SELECT @@session.collation_server;
170 @@session.collation_server
171 swe7_bin
172 SET @@session.collation_server = ascii_general_ci;
173 SELECT @@session.collation_server;
174 @@session.collation_server
175 ascii_general_ci
176 SET @@session.collation_server = ascii_bin;
177 SELECT @@session.collation_server;
178 @@session.collation_server
179 ascii_bin
180 SET @@session.collation_server = ujis_japanese_ci;
181 SELECT @@session.collation_server;
182 @@session.collation_server
183 ujis_japanese_ci
184 SET @@session.collation_server = ujis_bin;
185 SELECT @@session.collation_server;
186 @@session.collation_server
187 ujis_bin
188 SET @@session.collation_server = sjis_japanese_ci;
189 SELECT @@session.collation_server;
190 @@session.collation_server
191 sjis_japanese_ci
192 SET @@session.collation_server = sjis_bin;
193 SELECT @@session.collation_server;
194 @@session.collation_server
195 sjis_bin
196 SET @@session.collation_server = hebrew_general_ci;
197 SELECT @@session.collation_server;
198 @@session.collation_server
199 hebrew_general_ci
200 SET @@session.collation_server = hebrew_bin;
201 SELECT @@session.collation_server;
202 @@session.collation_server
203 hebrew_bin
204 SET @@session.collation_server = tis620_thai_ci;
205 SELECT @@session.collation_server;
206 @@session.collation_server
207 tis620_thai_ci
208 SET @@session.collation_server = tis620_bin;
209 SELECT @@session.collation_server;
210 @@session.collation_server
211 tis620_bin
212 SET @@session.collation_server = euckr_korean_ci;
213 SELECT @@session.collation_server;
214 @@session.collation_server
215 euckr_korean_ci
216 SET @@session.collation_server = euckr_bin;
217 SELECT @@session.collation_server;
218 @@session.collation_server
219 euckr_bin
220 SET @@session.collation_server = koi8u_general_ci;
221 SELECT @@session.collation_server;
222 @@session.collation_server
223 koi8u_general_ci
224 SET @@session.collation_server = koi8u_bin;
225 SELECT @@session.collation_server;
226 @@session.collation_server
227 koi8u_bin
228 SET @@session.collation_server = gb2312_chinese_ci;
229 SELECT @@session.collation_server;
230 @@session.collation_server
231 gb2312_chinese_ci
232 SET @@session.collation_server = gb2312_bin;
233 SELECT @@session.collation_server;
234 @@session.collation_server
235 gb2312_bin
236 SET @@session.collation_server = greek_general_ci;
237 SELECT @@session.collation_server;
238 @@session.collation_server
239 greek_general_ci
240 SET @@session.collation_server = greek_bin;
241 SELECT @@session.collation_server;
242 @@session.collation_server
243 greek_bin
244 SET @@session.collation_server = cp1250_general_ci;
245 SELECT @@session.collation_server;
246 @@session.collation_server
247 cp1250_general_ci
248 SET @@session.collation_server = cp1250_czech_cs;
249 SELECT @@session.collation_server;
250 @@session.collation_server
251 cp1250_czech_cs
252 SET @@session.collation_server = cp1250_croatian_ci;
253 SELECT @@session.collation_server;
254 @@session.collation_server
255 cp1250_croatian_ci
256 SET @@session.collation_server = cp1250_bin;
257 SELECT @@session.collation_server;
258 @@session.collation_server
259 cp1250_bin
260 SET @@session.collation_server = cp1250_polish_ci;
261 SELECT @@session.collation_server;
262 @@session.collation_server
263 cp1250_polish_ci
264 SET @@session.collation_server = gbk_chinese_ci;
265 SELECT @@session.collation_server;
266 @@session.collation_server
267 gbk_chinese_ci
268 SET @@session.collation_server = gbk_bin;
269 SELECT @@session.collation_server;
270 @@session.collation_server
271 gbk_bin
272 SET @@session.collation_server = latin5_turkish_ci;
273 SELECT @@session.collation_server;
274 @@session.collation_server
275 latin5_turkish_ci
276 SET @@session.collation_server = latin5_bin;
277 SELECT @@session.collation_server;
278 @@session.collation_server
279 latin5_bin
280 SET @@session.collation_server = armscii8_general_ci;
281 SELECT @@session.collation_server;
282 @@session.collation_server
283 armscii8_general_ci
284 SET @@session.collation_server = armscii8_bin;
285 SELECT @@session.collation_server;
286 @@session.collation_server
287 armscii8_bin
288 SET @@session.collation_server = utf8_general_ci;
289 SELECT @@session.collation_server;
290 @@session.collation_server
291 utf8mb3_general_ci
292 SET @@session.collation_server = utf8_bin;
293 SELECT @@session.collation_server;
294 @@session.collation_server
295 utf8mb3_bin
296 SET @@session.collation_server = utf8_unicode_ci;
297 SELECT @@session.collation_server;
298 @@session.collation_server
299 utf8mb3_unicode_ci
300 SET @@session.collation_server = utf8_icelandic_ci;
301 SELECT @@session.collation_server;
302 @@session.collation_server
303 utf8mb3_icelandic_ci
304 SET @@session.collation_server = utf8_latvian_ci;
305 SELECT @@session.collation_server;
306 @@session.collation_server
307 utf8mb3_latvian_ci
308 SET @@session.collation_server = utf8_romanian_ci;
309 SELECT @@session.collation_server;
310 @@session.collation_server
311 utf8mb3_romanian_ci
312 SET @@session.collation_server = utf8_slovenian_ci;
313 SELECT @@session.collation_server;
314 @@session.collation_server
315 utf8mb3_slovenian_ci
316 SET @@session.collation_server = utf8_polish_ci;
317 SELECT @@session.collation_server;
318 @@session.collation_server
319 utf8mb3_polish_ci
320 SET @@session.collation_server = utf8_estonian_ci;
321 SELECT @@session.collation_server;
322 @@session.collation_server
323 utf8mb3_estonian_ci
324 SET @@session.collation_server = utf8_spanish_ci;
325 SELECT @@session.collation_server;
326 @@session.collation_server
327 utf8mb3_spanish_ci
328 SET @@session.collation_server = utf8_swedish_ci;
329 SELECT @@session.collation_server;
330 @@session.collation_server
331 utf8mb3_swedish_ci
332 SET @@session.collation_server = utf8_turkish_ci;
333 SELECT @@session.collation_server;
334 @@session.collation_server
335 utf8mb3_turkish_ci
336 SET @@session.collation_server = utf8_czech_ci;
337 SELECT @@session.collation_server;
338 @@session.collation_server
339 utf8mb3_czech_ci
340 SET @@session.collation_server = utf8_danish_ci;
341 SELECT @@session.collation_server;
342 @@session.collation_server
343 utf8mb3_danish_ci
344 SET @@session.collation_server = utf8_lithuanian_ci;
345 SELECT @@session.collation_server;
346 @@session.collation_server
347 utf8mb3_lithuanian_ci
348 SET @@session.collation_server = utf8_slovak_ci;
349 SELECT @@session.collation_server;
350 @@session.collation_server
351 utf8mb3_slovak_ci
352 SET @@session.collation_server = utf8_spanish2_ci;
353 SELECT @@session.collation_server;
354 @@session.collation_server
355 utf8mb3_spanish2_ci
356 SET @@session.collation_server = utf8_roman_ci;
357 SELECT @@session.collation_server;
358 @@session.collation_server
359 utf8mb3_roman_ci
360 SET @@session.collation_server = utf8_persian_ci;
361 SELECT @@session.collation_server;
362 @@session.collation_server
363 utf8mb3_persian_ci
364 SET @@session.collation_server = utf8_esperanto_ci;
365 SELECT @@session.collation_server;
366 @@session.collation_server
367 utf8mb3_esperanto_ci
368 SET @@session.collation_server = utf8_hungarian_ci;
369 SELECT @@session.collation_server;
370 @@session.collation_server
371 utf8mb3_hungarian_ci
372 SET @@session.collation_server = utf8_thai_520_w2;
373 SELECT @@session.collation_server;
374 @@session.collation_server
375 utf8mb3_thai_520_w2
376 SET @@session.collation_server = ucs2_general_ci;
377 SELECT @@session.collation_server;
378 @@session.collation_server
379 ucs2_general_ci
380 SET @@session.collation_server = ucs2_bin;
381 SELECT @@session.collation_server;
382 @@session.collation_server
383 ucs2_bin
384 SET @@session.collation_server = ucs2_unicode_ci;
385 SELECT @@session.collation_server;
386 @@session.collation_server
387 ucs2_unicode_ci
388 SET @@session.collation_server = ucs2_icelandic_ci;
389 SELECT @@session.collation_server;
390 @@session.collation_server
391 ucs2_icelandic_ci
392 SET @@session.collation_server = ucs2_latvian_ci;
393 SELECT @@session.collation_server;
394 @@session.collation_server
395 ucs2_latvian_ci
396 SET @@session.collation_server = ucs2_romanian_ci;
397 SELECT @@session.collation_server;
398 @@session.collation_server
399 ucs2_romanian_ci
400 SET @@session.collation_server = ucs2_slovenian_ci;
401 SELECT @@session.collation_server;
402 @@session.collation_server
403 ucs2_slovenian_ci
404 SET @@session.collation_server = ucs2_polish_ci;
405 SELECT @@session.collation_server;
406 @@session.collation_server
407 ucs2_polish_ci
408 SET @@session.collation_server = ucs2_estonian_ci;
409 SELECT @@session.collation_server;
410 @@session.collation_server
411 ucs2_estonian_ci
412 SET @@session.collation_server = ucs2_spanish_ci;
413 SELECT @@session.collation_server;
414 @@session.collation_server
415 ucs2_spanish_ci
416 SET @@session.collation_server = ucs2_swedish_ci;
417 SELECT @@session.collation_server;
418 @@session.collation_server
419 ucs2_swedish_ci
420 SET @@session.collation_server = ucs2_turkish_ci;
421 SELECT @@session.collation_server;
422 @@session.collation_server
423 ucs2_turkish_ci
424 SET @@session.collation_server = ucs2_czech_ci;
425 SELECT @@session.collation_server;
426 @@session.collation_server
427 ucs2_czech_ci
428 SET @@session.collation_server = ucs2_danish_ci;
429 SELECT @@session.collation_server;
430 @@session.collation_server
431 ucs2_danish_ci
432 SET @@session.collation_server = ucs2_lithuanian_ci;
433 SELECT @@session.collation_server;
434 @@session.collation_server
435 ucs2_lithuanian_ci
436 SET @@session.collation_server = ucs2_slovak_ci;
437 SELECT @@session.collation_server;
438 @@session.collation_server
439 ucs2_slovak_ci
440 SET @@session.collation_server = ucs2_spanish2_ci;
441 SELECT @@session.collation_server;
442 @@session.collation_server
443 ucs2_spanish2_ci
444 SET @@session.collation_server = ucs2_roman_ci;
445 SELECT @@session.collation_server;
446 @@session.collation_server
447 ucs2_roman_ci
448 SET @@session.collation_server = ucs2_persian_ci;
449 SELECT @@session.collation_server;
450 @@session.collation_server
451 ucs2_persian_ci
452 SET @@session.collation_server = ucs2_esperanto_ci;
453 SELECT @@session.collation_server;
454 @@session.collation_server
455 ucs2_esperanto_ci
456 SET @@session.collation_server = ucs2_hungarian_ci;
457 SELECT @@session.collation_server;
458 @@session.collation_server
459 ucs2_hungarian_ci
460 SET @@session.collation_server = cp866_general_ci;
461 SELECT @@session.collation_server;
462 @@session.collation_server
463 cp866_general_ci
464 SET @@session.collation_server = cp866_bin;
465 SELECT @@session.collation_server;
466 @@session.collation_server
467 cp866_bin
468 SET @@session.collation_server = keybcs2_general_ci;
469 SELECT @@session.collation_server;
470 @@session.collation_server
471 keybcs2_general_ci
472 SET @@session.collation_server = keybcs2_bin;
473 SELECT @@session.collation_server;
474 @@session.collation_server
475 keybcs2_bin
476 SET @@session.collation_server = macce_general_ci;
477 SELECT @@session.collation_server;
478 @@session.collation_server
479 macce_general_ci
480 SET @@session.collation_server = macce_bin;
481 SELECT @@session.collation_server;
482 @@session.collation_server
483 macce_bin
484 SET @@session.collation_server = macroman_general_ci;
485 SELECT @@session.collation_server;
486 @@session.collation_server
487 macroman_general_ci
488 SET @@session.collation_server = macroman_bin;
489 SELECT @@session.collation_server;
490 @@session.collation_server
491 macroman_bin
492 SET @@session.collation_server = cp852_general_ci;
493 SELECT @@session.collation_server;
494 @@session.collation_server
495 cp852_general_ci
496 SET @@session.collation_server = cp852_bin;
497 SELECT @@session.collation_server;
498 @@session.collation_server
499 cp852_bin
500 SET @@session.collation_server = latin7_estonian_cs;
501 SELECT @@session.collation_server;
502 @@session.collation_server
503 latin7_estonian_cs
504 SET @@session.collation_server = latin7_general_ci;
505 SELECT @@session.collation_server;
506 @@session.collation_server
507 latin7_general_ci
508 SET @@session.collation_server = latin7_general_cs;
509 SELECT @@session.collation_server;
510 @@session.collation_server
511 latin7_general_cs
512 SET @@session.collation_server = latin7_bin;
513 SELECT @@session.collation_server;
514 @@session.collation_server
515 latin7_bin
516 SET @@session.collation_server = cp1251_bulgarian_ci;
517 SELECT @@session.collation_server;
518 @@session.collation_server
519 cp1251_bulgarian_ci
520 SET @@session.collation_server = cp1251_ukrainian_ci;
521 SELECT @@session.collation_server;
522 @@session.collation_server
523 cp1251_ukrainian_ci
524 SET @@session.collation_server = cp1251_bin;
525 SELECT @@session.collation_server;
526 @@session.collation_server
527 cp1251_bin
528 SET @@session.collation_server = cp1251_general_ci;
529 SELECT @@session.collation_server;
530 @@session.collation_server
531 cp1251_general_ci
532 SET @@session.collation_server = cp1251_general_cs;
533 SELECT @@session.collation_server;
534 @@session.collation_server
535 cp1251_general_cs
536 SET @@session.collation_server = cp1256_general_ci;
537 SELECT @@session.collation_server;
538 @@session.collation_server
539 cp1256_general_ci
540 SET @@session.collation_server = cp1256_bin;
541 SELECT @@session.collation_server;
542 @@session.collation_server
543 cp1256_bin
544 SET @@session.collation_server = cp1257_lithuanian_ci;
545 SELECT @@session.collation_server;
546 @@session.collation_server
547 cp1257_lithuanian_ci
548 SET @@session.collation_server = cp1257_bin;
549 SELECT @@session.collation_server;
550 @@session.collation_server
551 cp1257_bin
552 SET @@session.collation_server = cp1257_general_ci;
553 SELECT @@session.collation_server;
554 @@session.collation_server
555 cp1257_general_ci
556 SET @@session.collation_server = binary;
557 SELECT @@session.collation_server;
558 @@session.collation_server
559 binary
560 SET @@session.collation_server = geostd8_general_ci;
561 SELECT @@session.collation_server;
562 @@session.collation_server
563 geostd8_general_ci
564 SET @@session.collation_server = geostd8_bin;
565 SELECT @@session.collation_server;
566 @@session.collation_server
567 geostd8_bin
568 SET @@session.collation_server = cp932_japanese_ci;
569 SELECT @@session.collation_server;
570 @@session.collation_server
571 cp932_japanese_ci
572 SET @@session.collation_server = cp932_bin;
573 SELECT @@session.collation_server;
574 @@session.collation_server
575 cp932_bin
576 SET @@session.collation_server = eucjpms_japanese_ci;
577 SELECT @@session.collation_server;
578 @@session.collation_server
579 eucjpms_japanese_ci
580 SET @@session.collation_server = eucjpms_bin;
581 SELECT @@session.collation_server;
582 @@session.collation_server
583 eucjpms_bin
584 '#--------------------FN_DYNVARS_014_07-------------------------#'
585 SET @@global.collation_server = big5_chinese_ci;
586 SELECT @@global.collation_server;
587 @@global.collation_server
588 big5_chinese_ci
589 SET @@global.collation_server = big5_bin;
590 SELECT @@global.collation_server;
591 @@global.collation_server
592 big5_bin
593 SET @@global.collation_server = dec8_swedish_ci;
594 SELECT @@global.collation_server;
595 @@global.collation_server
596 dec8_swedish_ci
597 SET @@global.collation_server = dec8_bin;
598 SELECT @@global.collation_server;
599 @@global.collation_server
600 dec8_bin
601 SET @@global.collation_server = cp850_general_ci;
602 SELECT @@global.collation_server;
603 @@global.collation_server
604 cp850_general_ci
605 SET @@global.collation_server = cp850_bin;
606 SELECT @@global.collation_server;
607 @@global.collation_server
608 cp850_bin
609 SET @@global.collation_server = hp8_english_ci;
610 SELECT @@global.collation_server;
611 @@global.collation_server
612 hp8_english_ci
613 SET @@global.collation_server = hp8_bin;
614 SELECT @@global.collation_server;
615 @@global.collation_server
616 hp8_bin
617 SET @@global.collation_server = koi8r_general_ci;
618 SELECT @@global.collation_server;
619 @@global.collation_server
620 koi8r_general_ci
621 SET @@global.collation_server = koi8r_bin;
622 SELECT @@global.collation_server;
623 @@global.collation_server
624 koi8r_bin
625 SET @@global.collation_server = latin1_german1_ci;
626 SELECT @@global.collation_server;
627 @@global.collation_server
628 latin1_german1_ci
629 SET @@global.collation_server = latin1_swedish_ci;
630 SELECT @@global.collation_server;
631 @@global.collation_server
632 latin1_swedish_ci
633 SET @@global.collation_server = latin1_danish_ci;
634 SELECT @@global.collation_server;
635 @@global.collation_server
636 latin1_danish_ci
637 SET @@global.collation_server = latin1_german2_ci;
638 SELECT @@global.collation_server;
639 @@global.collation_server
640 latin1_german2_ci
641 SET @@global.collation_server = latin1_bin;
642 SELECT @@global.collation_server;
643 @@global.collation_server
644 latin1_bin
645 SET @@global.collation_server = latin1_general_ci;
646 SELECT @@global.collation_server;
647 @@global.collation_server
648 latin1_general_ci
649 SET @@global.collation_server = latin1_general_cs;
650 SELECT @@global.collation_server;
651 @@global.collation_server
652 latin1_general_cs
653 SET @@global.collation_server = latin1_spanish_ci;
654 SELECT @@global.collation_server;
655 @@global.collation_server
656 latin1_spanish_ci
657 SET @@global.collation_server = latin2_czech_cs;
658 SELECT @@global.collation_server;
659 @@global.collation_server
660 latin2_czech_cs
661 SET @@global.collation_server = latin2_general_ci;
662 SELECT @@global.collation_server;
663 @@global.collation_server
664 latin2_general_ci
665 SET @@global.collation_server = latin2_hungarian_ci;
666 SELECT @@global.collation_server;
667 @@global.collation_server
668 latin2_hungarian_ci
669 SET @@global.collation_server = latin2_croatian_ci;
670 SELECT @@global.collation_server;
671 @@global.collation_server
672 latin2_croatian_ci
673 SET @@global.collation_server = latin2_bin;
674 SELECT @@global.collation_server;
675 @@global.collation_server
676 latin2_bin
677 SET @@global.collation_server = swe7_swedish_ci;
678 SELECT @@global.collation_server;
679 @@global.collation_server
680 swe7_swedish_ci
681 SET @@global.collation_server = swe7_bin;
682 SELECT @@global.collation_server;
683 @@global.collation_server
684 swe7_bin
685 SET @@global.collation_server = ascii_general_ci;
686 SELECT @@global.collation_server;
687 @@global.collation_server
688 ascii_general_ci
689 SET @@global.collation_server = ascii_bin;
690 SELECT @@global.collation_server;
691 @@global.collation_server
692 ascii_bin
693 SET @@global.collation_server = ujis_japanese_ci;
694 SELECT @@global.collation_server;
695 @@global.collation_server
696 ujis_japanese_ci
697 SET @@global.collation_server = ujis_bin;
698 SELECT @@global.collation_server;
699 @@global.collation_server
700 ujis_bin
701 SET @@global.collation_server = sjis_japanese_ci;
702 SELECT @@global.collation_server;
703 @@global.collation_server
704 sjis_japanese_ci
705 SET @@global.collation_server = sjis_bin;
706 SELECT @@global.collation_server;
707 @@global.collation_server
708 sjis_bin
709 SET @@global.collation_server = hebrew_general_ci;
710 SELECT @@global.collation_server;
711 @@global.collation_server
712 hebrew_general_ci
713 SET @@global.collation_server = hebrew_bin;
714 SELECT @@global.collation_server;
715 @@global.collation_server
716 hebrew_bin
717 SET @@global.collation_server = tis620_thai_ci;
718 SELECT @@global.collation_server;
719 @@global.collation_server
720 tis620_thai_ci
721 SET @@global.collation_server = tis620_bin;
722 SELECT @@global.collation_server;
723 @@global.collation_server
724 tis620_bin
725 SET @@global.collation_server = euckr_korean_ci;
726 SELECT @@global.collation_server;
727 @@global.collation_server
728 euckr_korean_ci
729 SET @@global.collation_server = euckr_bin;
730 SELECT @@global.collation_server;
731 @@global.collation_server
732 euckr_bin
733 SET @@global.collation_server = koi8u_general_ci;
734 SELECT @@global.collation_server;
735 @@global.collation_server
736 koi8u_general_ci
737 SET @@global.collation_server = koi8u_bin;
738 SELECT @@global.collation_server;
739 @@global.collation_server
740 koi8u_bin
741 SET @@global.collation_server = gb2312_chinese_ci;
742 SELECT @@global.collation_server;
743 @@global.collation_server
744 gb2312_chinese_ci
745 SET @@global.collation_server = gb2312_bin;
746 SELECT @@global.collation_server;
747 @@global.collation_server
748 gb2312_bin
749 SET @@global.collation_server = greek_general_ci;
750 SELECT @@global.collation_server;
751 @@global.collation_server
752 greek_general_ci
753 SET @@global.collation_server = greek_bin;
754 SELECT @@global.collation_server;
755 @@global.collation_server
756 greek_bin
757 SET @@global.collation_server = cp1250_general_ci;
758 SELECT @@global.collation_server;
759 @@global.collation_server
760 cp1250_general_ci
761 SET @@global.collation_server = cp1250_czech_cs;
762 SELECT @@global.collation_server;
763 @@global.collation_server
764 cp1250_czech_cs
765 SET @@global.collation_server = cp1250_croatian_ci;
766 SELECT @@global.collation_server;
767 @@global.collation_server
768 cp1250_croatian_ci
769 SET @@global.collation_server = cp1250_bin;
770 SELECT @@global.collation_server;
771 @@global.collation_server
772 cp1250_bin
773 SET @@global.collation_server = cp1250_polish_ci;
774 SELECT @@global.collation_server;
775 @@global.collation_server
776 cp1250_polish_ci
777 SET @@global.collation_server = gbk_chinese_ci;
778 SELECT @@global.collation_server;
779 @@global.collation_server
780 gbk_chinese_ci
781 SET @@global.collation_server = gbk_bin;
782 SELECT @@global.collation_server;
783 @@global.collation_server
784 gbk_bin
785 SET @@global.collation_server = latin5_turkish_ci;
786 SELECT @@global.collation_server;
787 @@global.collation_server
788 latin5_turkish_ci
789 SET @@global.collation_server = latin5_bin;
790 SELECT @@global.collation_server;
791 @@global.collation_server
792 latin5_bin
793 SET @@global.collation_server = armscii8_general_ci;
794 SELECT @@global.collation_server;
795 @@global.collation_server
796 armscii8_general_ci
797 SET @@global.collation_server = armscii8_bin;
798 SELECT @@global.collation_server;
799 @@global.collation_server
800 armscii8_bin
801 SET @@global.collation_server = utf8_general_ci;
802 SELECT @@global.collation_server;
803 @@global.collation_server
804 utf8mb3_general_ci
805 SET @@global.collation_server = utf8_bin;
806 SELECT @@global.collation_server;
807 @@global.collation_server
808 utf8mb3_bin
809 SET @@global.collation_server = utf8_unicode_ci;
810 SELECT @@global.collation_server;
811 @@global.collation_server
812 utf8mb3_unicode_ci
813 SET @@global.collation_server = utf8_icelandic_ci;
814 SELECT @@global.collation_server;
815 @@global.collation_server
816 utf8mb3_icelandic_ci
817 SET @@global.collation_server = utf8_latvian_ci;
818 SELECT @@global.collation_server;
819 @@global.collation_server
820 utf8mb3_latvian_ci
821 SET @@global.collation_server = utf8_romanian_ci;
822 SELECT @@global.collation_server;
823 @@global.collation_server
824 utf8mb3_romanian_ci
825 SET @@global.collation_server = utf8_slovenian_ci;
826 SELECT @@global.collation_server;
827 @@global.collation_server
828 utf8mb3_slovenian_ci
829 SET @@global.collation_server = utf8_polish_ci;
830 SELECT @@global.collation_server;
831 @@global.collation_server
832 utf8mb3_polish_ci
833 SET @@global.collation_server = utf8_estonian_ci;
834 SELECT @@global.collation_server;
835 @@global.collation_server
836 utf8mb3_estonian_ci
837 SET @@global.collation_server = utf8_spanish_ci;
838 SELECT @@global.collation_server;
839 @@global.collation_server
840 utf8mb3_spanish_ci
841 SET @@global.collation_server = utf8_swedish_ci;
842 SELECT @@global.collation_server;
843 @@global.collation_server
844 utf8mb3_swedish_ci
845 SET @@global.collation_server = utf8_turkish_ci;
846 SELECT @@global.collation_server;
847 @@global.collation_server
848 utf8mb3_turkish_ci
849 SET @@global.collation_server = utf8_czech_ci;
850 SELECT @@global.collation_server;
851 @@global.collation_server
852 utf8mb3_czech_ci
853 SET @@global.collation_server = utf8_danish_ci;
854 SELECT @@global.collation_server;
855 @@global.collation_server
856 utf8mb3_danish_ci
857 SET @@global.collation_server = utf8_lithuanian_ci;
858 SELECT @@global.collation_server;
859 @@global.collation_server
860 utf8mb3_lithuanian_ci
861 SET @@global.collation_server = utf8_slovak_ci;
862 SELECT @@global.collation_server;
863 @@global.collation_server
864 utf8mb3_slovak_ci
865 SET @@global.collation_server = utf8_spanish2_ci;
866 SELECT @@global.collation_server;
867 @@global.collation_server
868 utf8mb3_spanish2_ci
869 SET @@global.collation_server = utf8_roman_ci;
870 SELECT @@global.collation_server;
871 @@global.collation_server
872 utf8mb3_roman_ci
873 SET @@global.collation_server = utf8_persian_ci;
874 SELECT @@global.collation_server;
875 @@global.collation_server
876 utf8mb3_persian_ci
877 SET @@global.collation_server = utf8_esperanto_ci;
878 SELECT @@global.collation_server;
879 @@global.collation_server
880 utf8mb3_esperanto_ci
881 SET @@global.collation_server = utf8_hungarian_ci;
882 SELECT @@global.collation_server;
883 @@global.collation_server
884 utf8mb3_hungarian_ci
885 SET @@global.collation_server = utf8_thai_520_w2;
886 SELECT @@global.collation_server;
887 @@global.collation_server
888 utf8mb3_thai_520_w2
889 SET @@global.collation_server = ucs2_general_ci;
890 SELECT @@global.collation_server;
891 @@global.collation_server
892 ucs2_general_ci
893 SET @@global.collation_server = ucs2_bin;
894 SELECT @@global.collation_server;
895 @@global.collation_server
896 ucs2_bin
897 SET @@global.collation_server = ucs2_unicode_ci;
898 SELECT @@global.collation_server;
899 @@global.collation_server
900 ucs2_unicode_ci
901 SET @@global.collation_server = ucs2_icelandic_ci;
902 SELECT @@global.collation_server;
903 @@global.collation_server
904 ucs2_icelandic_ci
905 SET @@global.collation_server = ucs2_latvian_ci;
906 SELECT @@global.collation_server;
907 @@global.collation_server
908 ucs2_latvian_ci
909 SET @@global.collation_server = ucs2_romanian_ci;
910 SELECT @@global.collation_server;
911 @@global.collation_server
912 ucs2_romanian_ci
913 SET @@global.collation_server = ucs2_slovenian_ci;
914 SELECT @@global.collation_server;
915 @@global.collation_server
916 ucs2_slovenian_ci
917 SET @@global.collation_server = ucs2_polish_ci;
918 SELECT @@global.collation_server;
919 @@global.collation_server
920 ucs2_polish_ci
921 SET @@global.collation_server = ucs2_estonian_ci;
922 SELECT @@global.collation_server;
923 @@global.collation_server
924 ucs2_estonian_ci
925 SET @@global.collation_server = ucs2_spanish_ci;
926 SELECT @@global.collation_server;
927 @@global.collation_server
928 ucs2_spanish_ci
929 SET @@global.collation_server = ucs2_swedish_ci;
930 SELECT @@global.collation_server;
931 @@global.collation_server
932 ucs2_swedish_ci
933 SET @@global.collation_server = ucs2_turkish_ci;
934 SELECT @@global.collation_server;
935 @@global.collation_server
936 ucs2_turkish_ci
937 SET @@global.collation_server = ucs2_czech_ci;
938 SELECT @@global.collation_server;
939 @@global.collation_server
940 ucs2_czech_ci
941 SET @@global.collation_server = ucs2_danish_ci;
942 SELECT @@global.collation_server;
943 @@global.collation_server
944 ucs2_danish_ci
945 SET @@global.collation_server = ucs2_lithuanian_ci;
946 SELECT @@global.collation_server;
947 @@global.collation_server
948 ucs2_lithuanian_ci
949 SET @@global.collation_server = ucs2_slovak_ci;
950 SELECT @@global.collation_server;
951 @@global.collation_server
952 ucs2_slovak_ci
953 SET @@global.collation_server = ucs2_spanish2_ci;
954 SELECT @@global.collation_server;
955 @@global.collation_server
956 ucs2_spanish2_ci
957 SET @@global.collation_server = ucs2_roman_ci;
958 SELECT @@global.collation_server;
959 @@global.collation_server
960 ucs2_roman_ci
961 SET @@global.collation_server = ucs2_persian_ci;
962 SELECT @@global.collation_server;
963 @@global.collation_server
964 ucs2_persian_ci
965 SET @@global.collation_server = ucs2_esperanto_ci;
966 SELECT @@global.collation_server;
967 @@global.collation_server
968 ucs2_esperanto_ci
969 SET @@global.collation_server = ucs2_hungarian_ci;
970 SELECT @@global.collation_server;
971 @@global.collation_server
972 ucs2_hungarian_ci
973 SET @@global.collation_server = cp866_general_ci;
974 SELECT @@global.collation_server;
975 @@global.collation_server
976 cp866_general_ci
977 SET @@global.collation_server = cp866_bin;
978 SELECT @@global.collation_server;
979 @@global.collation_server
980 cp866_bin
981 SET @@global.collation_server = keybcs2_general_ci;
982 SELECT @@global.collation_server;
983 @@global.collation_server
984 keybcs2_general_ci
985 SET @@global.collation_server = keybcs2_bin;
986 SELECT @@global.collation_server;
987 @@global.collation_server
988 keybcs2_bin
989 SET @@global.collation_server = macce_general_ci;
990 SELECT @@global.collation_server;
991 @@global.collation_server
992 macce_general_ci
993 SET @@global.collation_server = macce_bin;
994 SELECT @@global.collation_server;
995 @@global.collation_server
996 macce_bin
997 SET @@global.collation_server = macroman_general_ci;
998 SELECT @@global.collation_server;
999 @@global.collation_server
1000 macroman_general_ci
1001 SET @@global.collation_server = macroman_bin;
1002 SELECT @@global.collation_server;
1003 @@global.collation_server
1004 macroman_bin
1005 SET @@global.collation_server = cp852_general_ci;
1006 SELECT @@global.collation_server;
1007 @@global.collation_server
1008 cp852_general_ci
1009 SET @@global.collation_server = cp852_bin;
1010 SELECT @@global.collation_server;
1011 @@global.collation_server
1012 cp852_bin
1013 SET @@global.collation_server = latin7_estonian_cs;
1014 SELECT @@global.collation_server;
1015 @@global.collation_server
1016 latin7_estonian_cs
1017 SET @@global.collation_server = latin7_general_ci;
1018 SELECT @@global.collation_server;
1019 @@global.collation_server
1020 latin7_general_ci
1021 SET @@global.collation_server = latin7_general_cs;
1022 SELECT @@global.collation_server;
1023 @@global.collation_server
1024 latin7_general_cs
1025 SET @@global.collation_server = latin7_bin;
1026 SELECT @@global.collation_server;
1027 @@global.collation_server
1028 latin7_bin
1029 SET @@global.collation_server = cp1251_bulgarian_ci;
1030 SELECT @@global.collation_server;
1031 @@global.collation_server
1032 cp1251_bulgarian_ci
1033 SET @@global.collation_server = cp1251_ukrainian_ci;
1034 SELECT @@global.collation_server;
1035 @@global.collation_server
1036 cp1251_ukrainian_ci
1037 SET @@global.collation_server = cp1251_bin;
1038 SELECT @@global.collation_server;
1039 @@global.collation_server
1040 cp1251_bin
1041 SET @@global.collation_server = cp1251_general_ci;
1042 SELECT @@global.collation_server;
1043 @@global.collation_server
1044 cp1251_general_ci
1045 SET @@global.collation_server = cp1251_general_cs;
1046 SELECT @@global.collation_server;
1047 @@global.collation_server
1048 cp1251_general_cs
1049 SET @@global.collation_server = cp1256_general_ci;
1050 SELECT @@global.collation_server;
1051 @@global.collation_server
1052 cp1256_general_ci
1053 SET @@global.collation_server = cp1256_bin;
1054 SELECT @@global.collation_server;
1055 @@global.collation_server
1056 cp1256_bin
1057 SET @@global.collation_server = cp1257_lithuanian_ci;
1058 SELECT @@global.collation_server;
1059 @@global.collation_server
1060 cp1257_lithuanian_ci
1061 SET @@global.collation_server = cp1257_bin;
1062 SELECT @@global.collation_server;
1063 @@global.collation_server
1064 cp1257_bin
1065 SET @@global.collation_server = cp1257_general_ci;
1066 SELECT @@global.collation_server;
1067 @@global.collation_server
1068 cp1257_general_ci
1069 SET @@global.collation_server = binary;
1070 SELECT @@global.collation_server;
1071 @@global.collation_server
1072 binary
1073 SET @@global.collation_server = geostd8_general_ci;
1074 SELECT @@global.collation_server;
1075 @@global.collation_server
1076 geostd8_general_ci
1077 SET @@global.collation_server = geostd8_bin;
1078 SELECT @@global.collation_server;
1079 @@global.collation_server
1080 geostd8_bin
1081 SET @@global.collation_server = cp932_japanese_ci;
1082 SELECT @@global.collation_server;
1083 @@global.collation_server
1084 cp932_japanese_ci
1085 SET @@global.collation_server = cp932_bin;
1086 SELECT @@global.collation_server;
1087 @@global.collation_server
1088 cp932_bin
1089 SET @@global.collation_server = eucjpms_japanese_ci;
1090 SELECT @@global.collation_server;
1091 @@global.collation_server
1092 eucjpms_japanese_ci
1093 SET @@global.collation_server = eucjpms_bin;
1094 SELECT @@global.collation_server;
1095 @@global.collation_server
1096 eucjpms_bin
1097 '#--------------------FN_DYNVARS_014_08-------------------------#'
1098 SET @@collation_server = LATIN7_GENERAL_CS;
1099 SELECT @@collation_server;
1100 @@collation_server
1101 latin7_general_cs
1102 SET @@collation_server = latin7_general_cs;
1103 SELECT @@collation_server;
1104 @@collation_server
1105 latin7_general_cs
1106 SET @@global.collation_server = Latin7_GeneRal_cS;
1107 SELECT @@global.collation_server;
1108 @@global.collation_server
1109 latin7_general_cs
1110 '#--------------------FN_DYNVARS_014_09-------------------------#'
1111 SET @@collation_server = 1;
1112 SELECT @@collation_server;
1113 @@collation_server
1114 big5_chinese_ci
1115 SET @@collation_server = 2;
1116 SELECT @@collation_server;
1117 @@collation_server
1118 latin2_czech_cs
1119 SET @@collation_server = 3;
1120 SELECT @@collation_server;
1121 @@collation_server
1122 dec8_swedish_ci
1123 SET @@collation_server = 99;
1124 SELECT @@collation_server;
1125 @@collation_server
1126 cp1250_polish_ci
1127 SET @@collation_server = 100;
1128 ERROR HY000: Unknown collation: '100'
1129 SET @@global.collation_server = 1;
1130 SELECT @@global.collation_server;
1131 @@global.collation_server
1132 big5_chinese_ci
1133 SET @@global.collation_server = 2;
1134 SELECT @@global.collation_server;
1135 @@global.collation_server
1136 latin2_czech_cs
1137 SET @@global.collation_server = 3;
1138 SELECT @@global.collation_server;
1139 @@global.collation_server
1140 dec8_swedish_ci
1141 SET @@global.collation_server = 99;
1142 SELECT @@global.collation_server;
1143 @@global.collation_server
1144 cp1250_polish_ci
1145 SET @@global.collation_server = 100;
1146 ERROR HY000: Unknown collation: '100'
1147 SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS);
1148 SELECT @total_collations > 120;
1149 @total_collations > 120
1150 1
1151 '#--------------------FN_DYNVARS_014_10-------------------------#'
1152 SET @@collation_server = latin7_binary;
1153 ERROR HY000: Unknown collation: 'latin7_binary'
1154 SET @@collation_server = 'eucjpms_japanese_cs';
1155 ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1156 SET @@collation_server = 0;
1157 ERROR HY000: Unknown collation: '0'
1158 SET @@collation_server = 1.01;
1159 ERROR 42000: Incorrect argument type to variable 'collation_server'
1160 SET @@collation_server = -1;
1161 ERROR HY000: Unknown collation: '-1'
1162 SET @@collation_server = '';
1163 ERROR HY000: Unknown collation: ''
1164 SET @@collation_server = ' eucjpms_bin';
1165 ERROR HY000: Unknown collation: ' eucjpms_bin'
1166 SET @@collation_server = true;
1167 SELECT @@collation_server AS res_with_true;
1168 res_with_true
1169 big5_chinese_ci
1170 SET @@collation_server = ON;
1171 ERROR HY000: Unknown collation: 'ON'
1172 '#--------------------FN_DYNVARS_014_11-------------------------#'
1173 SET @@global.collation_server = latin7_binary;
1174 ERROR HY000: Unknown collation: 'latin7_binary'
1175 SET @@global.collation_server = 'eucjpms_japanese_cs';
1176 ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1177 SET @@global.collation_server = 0;
1178 ERROR HY000: Unknown collation: '0'
1179 SET @@global.collation_server = 1.1;
1180 ERROR 42000: Incorrect argument type to variable 'collation_server'
1181 SET @@global.collation_server = -1;
1182 ERROR HY000: Unknown collation: '-1'
1183 SET @@global.collation_server = "";
1184 ERROR HY000: Unknown collation: ''
1185 SET @@global.collation_server = ' eucjpms_bin';
1186 ERROR HY000: Unknown collation: ' eucjpms_bin'
1187 SET @@global.collation_server = true;
1188 SET @@global.collation_server = ON;
1189 ERROR HY000: Unknown collation: 'ON'
1190 '#--------------------FN_DYNVARS_014_12-------------------------#'
1191 SELECT @@global.collation_server =
1192 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1193 WHERE VARIABLE_NAME='collation_server') AS res;
1194 res
1195 1
1196 SET @@global.collation_server = 1;
1197 SELECT @@global.collation_server;
1198 @@global.collation_server
1199 big5_chinese_ci
1200 SELECT @@global.collation_server =
1201 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1202 WHERE VARIABLE_NAME='collation_server') AS res;
1203 res
1204 1
1205 '#--------------------FN_DYNVARS_014_13-------------------------#'
1206 SELECT @@collation_server =
1207 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1208 WHERE VARIABLE_NAME='collation_server') AS res;
1209 res
1210 1
1211 SELECT @@local.collation_server =
1212 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1213 WHERE VARIABLE_NAME='collation_server') AS res;
1214 res
1215 1
1216 SELECT @@session.collation_server =
1217 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1218 WHERE VARIABLE_NAME='collation_server') AS res;
1219 res
1220 1
1221 SET @@global.collation_server = @global_start_value;
1222 SET @@session.collation_server = @session_start_value;