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/load_sysvars.inc
26 ###################################################
27 ## START OF character_set_client TESTS ##
28 ###################################################
29
30 #############################################################
31 # Save initial value #
32 #############################################################
33 SET @global_start_value = @@global.character_set_client;
34 SELECT @global_start_value;
35 # Save initial session value
36 SET @session_start_value = @@character_set_client;
37 SELECT @session_start_value;
38 # now save using local access
39 SET @session_start_value = @@local.character_set_client;
40 SELECT @session_start_value;
41 # save using default access (session)
42 SET @session_start_value = @@session.character_set_client;
43 SELECT @session_start_value;
44
45 --echo '#--------------------FN_DYNVARS_010_01------------------#'
46 ###############################################################################
47 # Test Variable access and assignment with and withoud @@ #
48 ###############################################################################
49 # select without @@
50 --error ER_BAD_FIELD_ERROR
51 SELECT character_set_client;
52 # assign value without @@
53 SET character_set_client=utf8;
54 SELECT @@session.character_set_client;
55 # assign global variable without @@
56 --Error ER_PARSE_ERROR
57 SET global.character_set_client=utf8;
58 # using another syntax for accessing session variable
59 SET session character_set_client=utf8;
60 # accessing variable with scope the wrong way
61 --Error ER_BAD_FIELD_ERROR
62 SELECT session character_set_client;
63 # using another syntax for accessing dynamic variable
64 SET global character_set_client=utf8;
65 --Error ER_BAD_FIELD_ERROR
66 SELECT global character_set_client;
67
68 --echo '#--------------------FN_DYNVARS_010_02-------------------------#'
69 ###############################################################################
70 # Check the DEFAULT value of character_set_client for session and global #
71 ###############################################################################
72 SET @@character_set_client = latin5;
73 SET @@character_set_client = DEFAULT;
74 SELECT @@character_set_client AS DEFAULT_VALUE;
75
76 SET @@global.character_set_client = latin5;
77 SET @@global.character_set_client = DEFAULT;
78 SELECT @@global.character_set_client;
79
80 --echo '#--------------------FN_DYNVARS_010_03-------------------------#'
81 ###############################################################################
82 # see if setting global value changes session value and vice versa #
83 ###############################################################################
84 SET @@session.character_set_client = utf8;
85 SELECT @@session.character_set_client;
86 SET @@global.character_set_client = latin2;
87 SELECT @@global.character_set_client;
88 SELECT @@session.character_set_client AS res_is_utf8;
89
90 SET @@session.character_set_client = latin5;
91 SELECT @@session.character_set_client;
92 SELECT @@global.character_set_client AS res_is_latin2;
93 # composite check
94 SELECT @@global.character_set_client=@@session.character_set_client
95 AS res_is_false;
96
97 --echo '#--------------------FN_DYNVARS_010_04-------------------------#'
98 ##############################################################################
99 # Check if accessing variable with and without session point to session #
100 # variable #
101 ##############################################################################
102 SELECT @@character_set_client = @@session.character_set_client AS res;
103 SELECT @@character_set_client = @@local.character_set_client AS res;
104
105 --echo '#--------------------FN_DYNVARS_010_05-------------------------#'
106 ###########################################################################
107 # Check if combining character set works #
108 ###########################################################################
109 --Error ER_BAD_FIELD_ERROR
110 SET @@character_set_client = utf8 + latin2;
111
112 --echo '#--------------------FN_DYNVARS_010_06-------------------------#'
113 ##############################################################################
114 # Change the value of character_set_client to a valid value for session #
115 ##############################################################################
116 SET @@character_set_client = big5;
117 SELECT @@character_set_client;
118 SET @@character_set_client = dec8;
119 SELECT @@character_set_client;
120 SET @@character_set_client = cp850;
121 SELECT @@character_set_client;
122 SET @@character_set_client = hp8;
123 SELECT @@character_set_client;
124 SET @@character_set_client = koi8r;
125 SELECT @@character_set_client;
126 SET @@character_set_client = latin1;
127 SELECT @@character_set_client;
128 SET @@character_set_client = latin2;
129 SELECT @@character_set_client;
130 SET @@character_set_client = swe7;
131 SELECT @@character_set_client;
132 SET @@character_set_client = ascii;
133 SELECT @@character_set_client;
134 SET @@character_set_client = ujis;
135 SELECT @@character_set_client;
136 SET @@character_set_client = sjis;
137 SELECT @@character_set_client;
138 SET @@character_set_client = hebrew;
139 SELECT @@character_set_client;
140 SET @@character_set_client = tis620;
141 SELECT @@character_set_client;
142 SET @@character_set_client = euckr;
143 SELECT @@character_set_client;
144 SET @@character_set_client = koi8u;
145 SELECT @@character_set_client;
146 SET @@character_set_client = gb2312;
147 SELECT @@character_set_client;
148 SET @@character_set_client = greek;
149 SELECT @@character_set_client;
150 SET @@character_set_client = cp1250;
151 SELECT @@character_set_client;
152 SET @@character_set_client = gbk;
153 SELECT @@character_set_client;
154 SET @@character_set_client = latin5;
155 SELECT @@character_set_client;
156 SET @@character_set_client = armscii8;
157 SELECT @@character_set_client;
158 SET @@character_set_client = utf8;
159 SELECT @@character_set_client;
160 SET @@character_set_client = utf8mb4;
161 SELECT @@character_set_client;
162
163 --error ER_WRONG_VALUE_FOR_VAR
164 SET @@character_set_client = ucs2;
165 --error ER_WRONG_VALUE_FOR_VAR
166 SET @@character_set_client = utf16;
167 --error ER_WRONG_VALUE_FOR_VAR
168 SET @@character_set_client = utf32;
169
170 SET @@character_set_client = cp866;
171 SELECT @@character_set_client;
172 SET @@character_set_client = keybcs2;
173 SELECT @@character_set_client;
174 SET @@character_set_client = macce;
175 SELECT @@character_set_client;
176 SET @@character_set_client = macroman;
177 SELECT @@character_set_client;
178 SET @@character_set_client = cp852;
179 SELECT @@character_set_client;
180 SET @@character_set_client = latin7;
181 SELECT @@character_set_client;
182 SET @@character_set_client = cp1251;
183 SELECT @@character_set_client;
184 SET @@character_set_client = cp1256;
185 SELECT @@character_set_client;
186 SET @@character_set_client = cp1257;
187 SELECT @@character_set_client;
188 SET @@character_set_client = binary;
189 SELECT @@character_set_client;
190 SET @@character_set_client = geostd8;
191 SELECT @@character_set_client;
192 SET @@character_set_client = cp932;
193 SELECT @@character_set_client;
194 SET @@character_set_client = eucjpms;
195 SELECT @@character_set_client;
196
197 --echo '#--------------------FN_DYNVARS_010_07-------------------------#'
198 ###############################################################################
199 # Change the value of character_set_client to a valid value for global #
200 ###############################################################################
201
202 let charset_variable = @@global.character_set_client;
203
204 --source suite/sys_vars/inc/charset_basic.inc
205
206 --echo '#--------------------FN_DYNVARS_010_08-------------------------#'
207 ################################################################################
208 # Change the value of character_set_client to a valid value with uppercase,#
209 # lowercase and mixedcase #
210 ################################################################################
211 SET @@character_set_client = UTF8;
212 SELECT @@character_set_client;
213 SET @@character_set_client = utf8;
214 SELECT @@character_set_client;
215 SET @@global.character_set_client = uTf8;
216 SELECT @@global.character_set_client;
217
218 --echo '#--------------------FN_DYNVARS_010_09-------------------------#'
219 ##############################################################
220 # Check if 1,2,3, ... values can be used on variable #
221 ##############################################################
222 SET @@character_set_client = 1;
223 SELECT @@character_set_client;
224 SET @@character_set_client = 2;
225 SELECT @@character_set_client;
226 SET @@character_set_client = 3;
227 SELECT @@character_set_client;
228 SET @@character_set_client = 36;
229 SELECT @@character_set_client;
230 SET @@character_set_client = 99;
231 SELECT @@character_set_client;
232
233 --Error ER_UNKNOWN_CHARACTER_SET
234 SET @@character_set_client = 100;
235
236 SET @@global.character_set_client = 1;
237 SELECT @@global.character_set_client;
238 SET @@global.character_set_client = 2;
239 SELECT @@global.character_set_client;
240 SET @@global.character_set_client = 3;
241 SELECT @@global.character_set_client;
242 SET @@global.character_set_client = 36;
243 SELECT @@global.character_set_client;
244 SET @@global.character_set_client = 99;
245 SELECT @@global.character_set_client;
246
247 --Error ER_UNKNOWN_CHARACTER_SET
248 SET @@global.character_set_client = 100;
249
250
251 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
252 SELECT @total_charset;
253
254 --echo '#--------------------FN_DYNVARS_010_10-------------------------#'
255 ###############################################################################
256 # Change the value of character_set_client to an invalid value for session #
257 ###############################################################################
258 --Error ER_UNKNOWN_CHARACTER_SET
259 SET @@character_set_client = abc;
260 --Error ER_UNKNOWN_CHARACTER_SET
261 SET @@character_set_client = 1utf8;
262 --Error ER_UNKNOWN_CHARACTER_SET
263 SET @@character_set_client = 0;
264 --Error ER_WRONG_TYPE_FOR_VAR
265 SET @@character_set_client = 1.1;
266 --Error ER_UNKNOWN_CHARACTER_SET
267 SET @@character_set_client = -1;
268 --Error ER_UNKNOWN_CHARACTER_SET
269 SET @@character_set_client = '';
270 --Error ER_UNKNOWN_CHARACTER_SET
271 SET @@character_set_client = 'utf';
272 SET @@character_set_client = true;
273 SELECT @@character_set_client AS res_with_true;
274 --Error ER_UNKNOWN_CHARACTER_SET
275 SET @@character_set_client = ON;
276 --Error ER_UNKNOWN_CHARACTER_SET
277 SET @@character_set_client = repeat('e', 256);
278 --Error ER_UNKNOWN_CHARACTER_SET
279 SET @@character_set_client = repeat('e', 1024);
280
281 --echo '#--------------------FN_DYNVARS_010_11-------------------------#'
282 ###############################################################################
283 # Change the value of character_set_client to an invalid value for global #
284 ###############################################################################
285 --Error ER_UNKNOWN_CHARACTER_SET
286 SET @@global.character_set_client = abc;
287 --Error ER_UNKNOWN_CHARACTER_SET
288 SET @@global.character_set_client = 1utf8;
289 --Error ER_UNKNOWN_CHARACTER_SET
290 SET @@global.character_set_client = 0;
291 --Error ER_WRONG_TYPE_FOR_VAR
292 SET @@global.character_set_client = 1.1;
293 --Error ER_UNKNOWN_CHARACTER_SET
294 SET @@global.character_set_client = -1;
295 --Error ER_UNKNOWN_CHARACTER_SET
296 SET @@global.character_set_client = '';
297 --Error ER_UNKNOWN_CHARACTER_SET
298 SET @@global.character_set_client = 'utf';
299
300 SET @@global.character_set_client = true;
301 --Error ER_UNKNOWN_CHARACTER_SET
302 SET @@global.character_set_client = ON;
303 --Error ER_UNKNOWN_CHARACTER_SET
304 SET @@global.character_set_client = repeat('e', 256);
305 --Error ER_UNKNOWN_CHARACTER_SET
306 SET @@global.character_set_client = repeat('e', 1024);
307
308 --echo '#--------------------FN_DYNVARS_010_12-------------------------#'
309 ##########################################################################
310 # Check if the value in GLOBAL Table matches value in variable #
311 ##########################################################################
312 --disable_warnings
313 SELECT @@global.character_set_client =
314 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
315 WHERE VARIABLE_NAME='character_set_client') AS res;
316 --enable_warnings
317 SET @@global.character_set_client = 1;
318 SELECT @@global.character_set_client;
319 --disable_warnings
320 SELECT @@global.character_set_client =
321 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
322 WHERE VARIABLE_NAME='character_set_client') AS res;
323 --enable_warnings
324
325 --echo '#--------------------FN_DYNVARS_010_13-------------------------#'
326 ###############################################################################
327 # Check if the value in SESSION Table matches value in variable #
328 ###############################################################################
329 --disable_warnings
330 SELECT @@character_set_client =
331 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
332 WHERE VARIABLE_NAME='character_set_client') AS res;
333 SELECT @@local.character_set_client =
334 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
335 WHERE VARIABLE_NAME='character_set_client') AS res;
336 SELECT @@session.character_set_client =
337 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
338 WHERE VARIABLE_NAME='character_set_client') AS res;
339 --enable_warnings
340
341 ####################################
342 # Restore initial value #
343 ####################################
344 SET @@global.character_set_client = @global_start_value;
345 SELECT @@global.character_set_client;
346 SET @@session.character_set_client = @session_start_value;
347 SELECT @@session.character_set_client;
348
349 #############################################################
350 # END OF character_set_client TESTS #
351 #############################################################