Debian Codegraph @

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

raw
1 ############## mysql-test\t\character_set_server_basic.test ###################
2 # #
3 # Variable Name: character_set_server #
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_server #
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/default_charset.inc
31 --source include/load_sysvars.inc
32
33 ###################################################
34 ## START OF character_set_server TESTS ##
35 ###################################################
36
37 #############################################################
38 # Save initial value #
39 #############################################################
40 SET @global_start_value_collation_server = @@global.collation_server;
41 SET @session_start_value_collation_server = @@session.collation_server;
42
43 SET @global_start_value = @@global.character_set_server;
44 SET @@global.character_set_server=@@character_set_client;
45 SELECT @@global.character_set_server;
46 # Save initial session value
47 SET @session_start_value = @@character_set_server;
48 SELECT @session_start_value;
49 # now save using local access
50 SET @session_start_value = @@local.character_set_server;
51 SELECT @session_start_value;
52 # save using default access (session)
53 SET @session_start_value = @@session.character_set_server;
54 SELECT @session_start_value;
55
56 --echo '#--------------------FN_DYNVARS_009_01------------------#'
57 ###############################################################################
58 # Test Variable access and assignment with and withoud @@ #
59 ###############################################################################
60 # select without @@
61 --error ER_BAD_FIELD_ERROR
62 SELECT character_set_server;
63 # assign value without @@
64 SET character_set_server=utf8;
65 SELECT @@session.character_set_server;
66 # using another syntax for accessing session variable
67 SET session character_set_server=utf8;
68 # accessing variable with scope the wrong way
69 --Error ER_BAD_FIELD_ERROR
70 SELECT session character_set_server;
71 # using another syntax for accessing dynamic variable
72 SET global character_set_server=utf8;
73 --Error ER_BAD_FIELD_ERROR
74 SELECT global character_set_server;
75
76 --error ER_WRONG_VALUE_FOR_VAR
77 SET @@character_set_server = null;
78
79 --echo '#--------------------FN_DYNVARS_009_02-------------------------#'
80 ###############################################################################
81 # Check the DEFAULT value of character_set_server for session and global #
82 ###############################################################################
83 SET @@character_set_server = latin5;
84 SET @@character_set_server = DEFAULT;
85 SELECT @@character_set_server = @@global.character_set_server;
86
87 SET @@global.character_set_server = latin5;
88 SET @@global.character_set_server = DEFAULT;
89 SELECT @@global.character_set_server = @global_start_value;
90
91 --echo '#--------------------FN_DYNVARS_009_03-------------------------#'
92 ###############################################################################
93 # see if setting global value changes session value and vice versa #
94 ###############################################################################
95 SET @@session.character_set_server = utf8;
96 SELECT @@session.character_set_server;
97 SET @@global.character_set_server = latin2;
98 SELECT @@global.character_set_server;
99 SELECT @@session.character_set_server AS res_is_utf8;
100
101 SET @@session.character_set_server = latin5;
102 SELECT @@session.character_set_server;
103 SELECT @@global.character_set_server AS res_is_latin2;
104 # composite check
105 SELECT @@global.character_set_server=@@session.character_set_server
106 AS res_is_false;
107
108 --echo '#--------------------FN_DYNVARS_009_04-------------------------#'
109 ###############################################################################
110 # Check if accessing variable with and without session point #
111 # to session variable #
112 ###############################################################################
113 SELECT @@character_set_server = @@session.character_set_server AS res;
114 SELECT @@character_set_server = @@local.character_set_server AS res;
115
116 --echo '#--------------------FN_DYNVARS_009_05-------------------------#'
117 ###########################################################################
118 # Check if combining character set works #
119 ###########################################################################
120 --Error ER_BAD_FIELD_ERROR
121 SET @@character_set_server = utf8 + latin2;
122
123 --echo '#--------------------FN_DYNVARS_009_06-------------------------#'
124 ###############################################################################
125 # Change the value of character_set_server to a valid value for session #
126 ###############################################################################
127
128 let charset_variable = @@session.character_set_server;
129
130 --source suite/sys_vars/inc/charset_basic.inc
131
132
133 --echo '#--------------------FN_DYNVARS_009_07-------------------------#'
134 ###############################################################################
135 # Change the value of character_set_server to a valid value for global #
136 ###############################################################################
137
138 let charset_variable = @@global.character_set_server;
139 --source suite/sys_vars/inc/charset_basic.inc
140
141
142 --echo '#--------------------FN_DYNVARS_009_08-------------------------#'
143 ###############################################################################
144 # Change the value of character_set_server to a valid value with uppercase, #
145 # lowercase and mixedcase #
146 ###############################################################################
147 SET @@character_set_server = UTF8;
148 SELECT @@character_set_server;
149 SET @@character_set_server = utf8;
150 SELECT @@character_set_server;
151
152 SET @@global.character_set_server = uTf8;
153 SELECT @@global.character_set_server;
154
155 --echo '#--------------------FN_DYNVARS_009_09-------------------------#'
156 ##############################################################
157 # Check if 1,2,3, ... values can be used on variable #
158 ##############################################################
159 SET @@character_set_server = 1;
160 SELECT @@character_set_server;
161
162 --echo # latin2_czech_cs is not a default collation
163 --error ER_UNKNOWN_CHARACTER_SET
164 SET @@character_set_server = 2;
165
166 SET @@character_set_server = 3;
167 SELECT @@character_set_server;
168 SET @@character_set_server = 36;
169 SELECT @@character_set_server;
170
171 --echo # cp1250_polish_ci is not a default collation
172 --error ER_UNKNOWN_CHARACTER_SET
173 SET @@character_set_server = 99;
174
175 --echo # Collation ID 100 does not exist
176 --Error ER_UNKNOWN_CHARACTER_SET
177 SET @@character_set_server = 100;
178
179 SET @@global.character_set_server = 1;
180 SELECT @@global.character_set_server;
181
182 --echo # latin2_czech_cs is not a default collation
183 --error ER_UNKNOWN_CHARACTER_SET
184 SET @@global.character_set_server = 2;
185
186 SET @@global.character_set_server = 36;
187 SELECT @@global.character_set_server;
188
189 --echo # cp1250_polish_ci is not a default collation
190 --error ER_UNKNOWN_CHARACTER_SET
191 SET @@global.character_set_server = 99;
192
193 --echo # Collation ID 100 does not exist
194 --Error ER_UNKNOWN_CHARACTER_SET
195 SET @@global.character_set_server = 100;
196
197 --echo '#--------------------FN_DYNVARS_009_10-------------------------#'
198 ###############################################################################
199 # Change the value of character_set_server to an invalid value for session #
200 ###############################################################################
201 --Error ER_UNKNOWN_CHARACTER_SET
202 SET @@character_set_server = abc;
203 --Error ER_UNKNOWN_CHARACTER_SET
204 SET @@character_set_server = 1utf8;
205 --Error ER_UNKNOWN_CHARACTER_SET
206 SET @@character_set_server = 0;
207 --Error ER_WRONG_TYPE_FOR_VAR
208 SET @@character_set_server = 1.1;
209 --Error ER_UNKNOWN_CHARACTER_SET
210 SET @@character_set_server = -1;
211 --Error ER_UNKNOWN_CHARACTER_SET
212 SET @@character_set_server = '';
213 --Error ER_UNKNOWN_CHARACTER_SET
214 SET @@character_set_server = 'utf';
215 SET @@character_set_server = true;
216 SELECT @@character_set_server AS res_with_true;
217
218 --Error ER_UNKNOWN_CHARACTER_SET
219 SET @@character_set_server = ON;
220
221 --echo '#--------------------FN_DYNVARS_009_11-------------------------#'
222 ###############################################################################
223 # Change the value of character_set_server to an invalid value for global #
224 ###############################################################################
225 --Error ER_UNKNOWN_CHARACTER_SET
226 SET @@global.character_set_server = abc;
227 --Error ER_UNKNOWN_CHARACTER_SET
228 SET @@global.character_set_server = 1utf8;
229 --Error ER_UNKNOWN_CHARACTER_SET
230 SET @@global.character_set_server = 0;
231 --Error ER_WRONG_TYPE_FOR_VAR
232 SET @@global.character_set_server = 1.1;
233 --Error ER_UNKNOWN_CHARACTER_SET
234 SET @@global.character_set_server = -1;
235 --Error ER_UNKNOWN_CHARACTER_SET
236 SET @@global.character_set_server = '';
237 --Error ER_UNKNOWN_CHARACTER_SET
238 SET @@global.character_set_server = 'utf';
239
240 SET @@global.character_set_server = true;
241
242 --Error ER_UNKNOWN_CHARACTER_SET
243 SET @@global.character_set_server = ON;
244
245 --echo '#--------------------FN_DYNVARS_009_12-------------------------#'
246 ###############################################################################
247 # Check if the value in GLOBAL Table matches value in variable #
248 ###############################################################################
249 SELECT @@global.character_set_server =
250 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
251 WHERE VARIABLE_NAME='character_set_server') AS res;
252 SET @@global.character_set_server = 1;
253 SELECT @@global.character_set_server;
254 SELECT @@global.character_set_server =
255 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
256 WHERE VARIABLE_NAME='character_set_server') AS res;
257
258 --echo '#--------------------FN_DYNVARS_009_13-------------------------#'
259 ###############################################################################
260 # Check if the value in SESSION Table matches value in variable #
261 ###############################################################################
262 SELECT @@character_set_server =
263 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
264 WHERE VARIABLE_NAME='character_set_server') AS res;
265 SELECT @@local.character_set_server =
266 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
267 WHERE VARIABLE_NAME='character_set_server') AS res;
268 SELECT @@session.character_set_server =
269 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
270 WHERE VARIABLE_NAME='character_set_server') AS res;
271
272 --echo #
273 --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
274 --echo #
275
276 --error ER_UNKNOWN_CHARACTER_SET
277 SET character_set_server=2/*latin2_czech_cs*/;
278 SET @@pseudo_slave_mode=1;
279 SET character_set_server=2/*latin2_czech_cs*/;
280 SHOW VARIABLES LIKE 'character_set_server';
281 SHOW VARIABLES LIKE 'collation_server';
282 SET @@pseudo_slave_mode=0;
283
284 ####################################
285 # Restore initial value #
286 ####################################
287 SET @@global.collation_server = @global_start_value_collation_server;
288 SET @@session.collation_server = @session_start_value_collation_server;
289
290 #############################################################
291 # END OF character_set_server TESTS #
292 #############################################################