Debian Codegraph @

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

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