Debian Codegraph @

mysql-test/suite/sys_vars/t/character_set_client_basic.test

raw
1 ############## mysql-test\t\character_set_client_basic.test ###################
2 # #
3 # Variable Name: character_set_client #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: utf8 (session), latin1 (global) #
8 # Range: NA #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author: Rizwan #
13 # #
14 # Description: Test Cases of Dynamic System Variable character_set_client #
15 # that checks the behavior of this variable in the following ways#
16 # * Default Value #
17 # * Valid & Invalid values #
18 # * Scope & Access method #
19 # * Data Integrity #
20 # #
21 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
22 # server-system-variables.html #
23 # #
24 ###############################################################################
25 --source include/have_big5.inc
26 --source include/have_ujis.inc
27 --source include/have_sjis.inc
28 --source include/have_utf8.inc
29 --source include/have_ucs2.inc
30 --source include/have_utf8mb4.inc
31 --source include/have_utf16.inc
32 --source include/have_utf32.inc
33 --source include/default_charset.inc
34 --source include/load_sysvars.inc
35
36 ###################################################
37 ## START OF character_set_client TESTS ##
38 ###################################################
39
40 #############################################################
41 # Save initial value #
42 #############################################################
43 SET @global_start_value = @@global.character_set_client;
44 SET @@global.character_set_client=@@character_set_client;
45 # Save initial session value
46 SET @session_start_value = @@character_set_client;
47 SELECT @session_start_value;
48 # now save using local access
49 SET @session_start_value = @@local.character_set_client;
50 SELECT @session_start_value;
51 # save using default access (session)
52 SET @session_start_value = @@session.character_set_client;
53 SELECT @session_start_value;
54
55 --echo '#--------------------FN_DYNVARS_010_01------------------#'
56 ###############################################################################
57 # Test Variable access and assignment with and withoud @@ #
58 ###############################################################################
59 # select without @@
60 --error ER_BAD_FIELD_ERROR
61 SELECT character_set_client;
62 # assign value without @@
63 SET character_set_client=utf8;
64 SELECT @@session.character_set_client;
65 # assign global variable without @@
66 # using another syntax for accessing session variable
67 SET session character_set_client=utf8;
68 # accessing variable with scope the wrong way
69 --Error ER_BAD_FIELD_ERROR
70 SELECT session character_set_client;
71 # using another syntax for accessing dynamic variable
72 SET global character_set_client=utf8;
73 --Error ER_BAD_FIELD_ERROR
74 SELECT global character_set_client;
75
76 --echo '#--------------------FN_DYNVARS_010_02-------------------------#'
77 ###############################################################################
78 # Check the DEFAULT value of character_set_client for session and global #
79 ###############################################################################
80 SET @@character_set_client = latin5;
81 SET @@character_set_client = DEFAULT;
82 SELECT @@character_set_client = @@global.character_set_client;
83
84 SET @@global.character_set_client = latin5;
85 SET @@global.character_set_client = DEFAULT;
86 SELECT @@global.character_set_client= @global_start_value;
87
88 --echo '#--------------------FN_DYNVARS_010_03-------------------------#'
89 ###############################################################################
90 # see if setting global value changes session value and vice versa #
91 ###############################################################################
92 SET @@session.character_set_client = utf8;
93 SELECT @@session.character_set_client;
94 SET @@global.character_set_client = latin2;
95 SELECT @@global.character_set_client;
96 SELECT @@session.character_set_client AS res_is_utf8;
97
98 SET @@session.character_set_client = latin5;
99 SELECT @@session.character_set_client;
100 SELECT @@global.character_set_client AS res_is_latin2;
101 # composite check
102 SELECT @@global.character_set_client=@@session.character_set_client
103 AS res_is_false;
104
105 --echo '#--------------------FN_DYNVARS_010_04-------------------------#'
106 ##############################################################################
107 # Check if accessing variable with and without session point to session #
108 # variable #
109 ##############################################################################
110 SELECT @@character_set_client = @@session.character_set_client AS res;
111 SELECT @@character_set_client = @@local.character_set_client AS res;
112
113 --echo '#--------------------FN_DYNVARS_010_05-------------------------#'
114 ###########################################################################
115 # Check if combining character set works #
116 ###########################################################################
117 --Error ER_BAD_FIELD_ERROR
118 SET @@character_set_client = utf8 + latin2;
119
120 --echo '#--------------------FN_DYNVARS_010_06-------------------------#'
121 ##############################################################################
122 # Change the value of character_set_client to a valid value for session #
123 ##############################################################################
124 SET @@character_set_client = big5;
125 SELECT @@character_set_client;
126 SET @@character_set_client = dec8;
127 SELECT @@character_set_client;
128 SET @@character_set_client = cp850;
129 SELECT @@character_set_client;
130 SET @@character_set_client = hp8;
131 SELECT @@character_set_client;
132 SET @@character_set_client = koi8r;
133 SELECT @@character_set_client;
134 SET @@character_set_client = latin1;
135 SELECT @@character_set_client;
136 SET @@character_set_client = latin2;
137 SELECT @@character_set_client;
138 SET @@character_set_client = swe7;
139 SELECT @@character_set_client;
140 SET @@character_set_client = ascii;
141 SELECT @@character_set_client;
142 SET @@character_set_client = ujis;
143 SELECT @@character_set_client;
144 SET @@character_set_client = sjis;
145 SELECT @@character_set_client;
146 SET @@character_set_client = hebrew;
147 SELECT @@character_set_client;
148 SET @@character_set_client = tis620;
149 SELECT @@character_set_client;
150 SET @@character_set_client = euckr;
151 SELECT @@character_set_client;
152 SET @@character_set_client = koi8u;
153 SELECT @@character_set_client;
154 SET @@character_set_client = gb2312;
155 SELECT @@character_set_client;
156 SET @@character_set_client = greek;
157 SELECT @@character_set_client;
158 SET @@character_set_client = cp1250;
159 SELECT @@character_set_client;
160 SET @@character_set_client = gbk;
161 SELECT @@character_set_client;
162 SET @@character_set_client = latin5;
163 SELECT @@character_set_client;
164 SET @@character_set_client = armscii8;
165 SELECT @@character_set_client;
166 SET @@character_set_client = utf8;
167 SELECT @@character_set_client;
168 SET @@character_set_client = utf8mb4;
169 SELECT @@character_set_client;
170
171 --error ER_WRONG_VALUE_FOR_VAR
172 SET @@character_set_client = ucs2;
173 --error ER_WRONG_VALUE_FOR_VAR
174 SET @@character_set_client = utf16;
175 --error ER_WRONG_VALUE_FOR_VAR
176 SET @@character_set_client = utf32;
177
178 SET @@character_set_client = cp866;
179 SELECT @@character_set_client;
180 SET @@character_set_client = keybcs2;
181 SELECT @@character_set_client;
182 SET @@character_set_client = macce;
183 SELECT @@character_set_client;
184 SET @@character_set_client = macroman;
185 SELECT @@character_set_client;
186 SET @@character_set_client = cp852;
187 SELECT @@character_set_client;
188 SET @@character_set_client = latin7;
189 SELECT @@character_set_client;
190 SET @@character_set_client = cp1251;
191 SELECT @@character_set_client;
192 SET @@character_set_client = cp1256;
193 SELECT @@character_set_client;
194 SET @@character_set_client = cp1257;
195 SELECT @@character_set_client;
196 SET @@character_set_client = binary;
197 SELECT @@character_set_client;
198 SET @@character_set_client = geostd8;
199 SELECT @@character_set_client;
200 SET @@character_set_client = cp932;
201 SELECT @@character_set_client;
202 SET @@character_set_client = eucjpms;
203 SELECT @@character_set_client;
204
205 --echo '#--------------------FN_DYNVARS_010_07-------------------------#'
206 ###############################################################################
207 # Change the value of character_set_client to a valid value for global #
208 ###############################################################################
209
210 let charset_variable = @@global.character_set_client;
211
212 --source suite/sys_vars/inc/charset_basic.inc
213
214 --echo '#--------------------FN_DYNVARS_010_08-------------------------#'
215 ################################################################################
216 # Change the value of character_set_client to a valid value with uppercase,#
217 # lowercase and mixedcase #
218 ################################################################################
219 SET @@character_set_client = UTF8;
220 SELECT @@character_set_client;
221 SET @@character_set_client = utf8;
222 SELECT @@character_set_client;
223 SET @@global.character_set_client = uTf8;
224 SELECT @@global.character_set_client;
225
226 --echo '#--------------------FN_DYNVARS_010_09-------------------------#'
227 ##############################################################
228 # Check if 1,2,3, ... values can be used on variable #
229 ##############################################################
230 SET @@character_set_client = 1;
231 SELECT @@character_set_client;
232
233 --echo # latin2_czech_cs is not a default collation
234 --error ER_UNKNOWN_CHARACTER_SET
235 SET @@character_set_client = 2;
236
237 SET @@character_set_client = 3;
238 SELECT @@character_set_client;
239 SET @@character_set_client = 36;
240 SELECT @@character_set_client;
241
242 --echo # cp1250_polish_ci is not a default collation
243 --error ER_UNKNOWN_CHARACTER_SET
244 SET @@character_set_client = 99;
245
246 --echo # Collation ID 100 does not exist
247 --Error ER_UNKNOWN_CHARACTER_SET
248 SET @@character_set_client = 100;
249
250 SET @@global.character_set_client = 1;
251 SELECT @@global.character_set_client;
252
253 --echo # latin2_czech_cs is not a default collation
254 --error ER_UNKNOWN_CHARACTER_SET
255 SET @@global.character_set_client = 2;
256
257 SET @@global.character_set_client = 3;
258 SELECT @@global.character_set_client;
259 SET @@global.character_set_client = 36;
260 SELECT @@global.character_set_client;
261
262 --echo # cp1250_polish_ci is not a default collation
263 --error ER_UNKNOWN_CHARACTER_SET
264 SET @@global.character_set_client = 99;
265
266 --echo # Collation ID 100 does not exist
267 --Error ER_UNKNOWN_CHARACTER_SET
268 SET @@global.character_set_client = 100;
269
270 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
271 SELECT @total_charset;
272
273 --echo '#--------------------FN_DYNVARS_010_10-------------------------#'
274 ###############################################################################
275 # Change the value of character_set_client to an invalid value for session #
276 ###############################################################################
277 --Error ER_UNKNOWN_CHARACTER_SET
278 SET @@character_set_client = abc;
279 --Error ER_UNKNOWN_CHARACTER_SET
280 SET @@character_set_client = 1utf8;
281 --Error ER_UNKNOWN_CHARACTER_SET
282 SET @@character_set_client = 0;
283 --Error ER_WRONG_TYPE_FOR_VAR
284 SET @@character_set_client = 1.1;
285 --Error ER_UNKNOWN_CHARACTER_SET
286 SET @@character_set_client = -1;
287 --Error ER_UNKNOWN_CHARACTER_SET
288 SET @@character_set_client = '';
289 --Error ER_UNKNOWN_CHARACTER_SET
290 SET @@character_set_client = 'utf';
291 SET @@character_set_client = true;
292 SELECT @@character_set_client AS res_with_true;
293 --Error ER_UNKNOWN_CHARACTER_SET
294 SET @@character_set_client = ON;
295
296 --echo '#--------------------FN_DYNVARS_010_11-------------------------#'
297 ###############################################################################
298 # Change the value of character_set_client to an invalid value for global #
299 ###############################################################################
300 --Error ER_UNKNOWN_CHARACTER_SET
301 SET @@global.character_set_client = abc;
302 --Error ER_UNKNOWN_CHARACTER_SET
303 SET @@global.character_set_client = 1utf8;
304 --Error ER_UNKNOWN_CHARACTER_SET
305 SET @@global.character_set_client = 0;
306 --Error ER_WRONG_TYPE_FOR_VAR
307 SET @@global.character_set_client = 1.1;
308 --Error ER_UNKNOWN_CHARACTER_SET
309 SET @@global.character_set_client = -1;
310 --Error ER_UNKNOWN_CHARACTER_SET
311 SET @@global.character_set_client = '';
312 --Error ER_UNKNOWN_CHARACTER_SET
313 SET @@global.character_set_client = 'utf';
314
315 SET @@global.character_set_client = true;
316 --Error ER_UNKNOWN_CHARACTER_SET
317 SET @@global.character_set_client = ON;
318
319 --echo '#--------------------FN_DYNVARS_010_12-------------------------#'
320 ##########################################################################
321 # Check if the value in GLOBAL Table matches value in variable #
322 ##########################################################################
323 SELECT @@global.character_set_client =
324 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
325 WHERE VARIABLE_NAME='character_set_client') AS res;
326 SET @@global.character_set_client = 1;
327 SELECT @@global.character_set_client;
328 SELECT @@global.character_set_client =
329 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
330 WHERE VARIABLE_NAME='character_set_client') AS res;
331
332 --echo '#--------------------FN_DYNVARS_010_13-------------------------#'
333 ###############################################################################
334 # Check if the value in SESSION Table matches value in variable #
335 ###############################################################################
336 SELECT @@character_set_client =
337 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
338 WHERE VARIABLE_NAME='character_set_client') AS res;
339 SELECT @@local.character_set_client =
340 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
341 WHERE VARIABLE_NAME='character_set_client') AS res;
342 SELECT @@session.character_set_client =
343 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
344 WHERE VARIABLE_NAME='character_set_client') AS res;
345
346 --echo #
347 --echo # MDEV-28769 Assertion `(m_ci->state & 32) || m_with_collate' failed in Lex_exact_charset_opt_extended_collate::Lex_exact_charset_opt_extended_collate on SET NAMES
348 --echo #
349
350 --error ER_UNKNOWN_CHARACTER_SET
351 SET GLOBAL character_set_client=2;
352
353 --echo #
354 --echo # 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
355 --echo #
356
357 SET @@pseudo_slave_mode=1;
358 SET character_set_client=2/*latin2_czech_cs*/;
359 SHOW VARIABLES LIKE 'character_set_client';
360 SET @@pseudo_slave_mode=0;
361
362 ####################################
363 # Restore initial value #
364 ####################################
365 SET @@global.character_set_client = @global_start_value;
366 SET @@session.character_set_client = @session_start_value;
367
368 #############################################################
369 # END OF character_set_client TESTS #
370 #############################################################