Debian Codegraph @

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

raw
1 ############## mysql-test\t\character_set_database_basic.test #################
2 # #
3 # Variable Name: character_set_database #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: latin1 (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_database #
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_database TESTS ##
28 ###################################################
29
30 #############################################################
31 # Save initial value #
32 #############################################################
33 SET @global_start_value = @@global.character_set_database;
34 SELECT @global_start_value;
35 # Save initial session value
36 SET @session_start_value = @@character_set_database;
37 SELECT @session_start_value;
38 # now save using local access
39 SET @session_start_value = @@local.character_set_database;
40 SELECT @session_start_value;
41 # save using default access (session)
42 SET @session_start_value = @@session.character_set_database;
43 SELECT @session_start_value;
44
45 --echo '#--------------------FN_DYNVARS_012_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_database;
52 # assign value without @@
53 SET character_set_database=utf8;
54 SELECT @@session.character_set_database;
55 # assign global variable without @@
56 --Error ER_PARSE_ERROR
57 SET global.character_set_database=utf8;
58 # using another syntax for accessing session variable
59 SET session character_set_database=utf8;
60 # accessing variable with scope the wrong way
61 --Error ER_BAD_FIELD_ERROR
62 SELECT session character_set_database;
63 # using another syntax for accessing dynamic variable
64 SET global character_set_database=utf8;
65 --Error ER_BAD_FIELD_ERROR
66 SELECT global character_set_database;
67
68 --echo '#--------------------FN_DYNVARS_012_02-------------------------#'
69 ###############################################################################
70 # Check the DEFAULT value of character_set_database for session and global #
71 ###############################################################################
72 SET @@character_set_database = latin5;
73 SET @@character_set_database = DEFAULT;
74 SELECT @@character_set_database AS DEFAULT_VALUE;
75
76 SET @@global.character_set_database = latin5;
77 SET @@global.character_set_database = DEFAULT;
78 SELECT @@global.character_set_database;
79
80 --echo '#--------------------FN_DYNVARS_012_03-------------------------#'
81 ##############################################################################
82 # see if setting global value changes session value and vice versa #
83 ##############################################################################
84 SET @@session.character_set_database = utf8;
85 SELECT @@session.character_set_database;
86 SET @@global.character_set_database = latin2;
87 SELECT @@global.character_set_database;
88 SELECT @@session.character_set_database AS res_is_utf8;
89
90 SET @@session.character_set_database = latin5;
91 SELECT @@session.character_set_database;
92 SELECT @@global.character_set_database AS res_is_latin2;
93 # composite check
94 SELECT @@global.character_set_database=@@session.character_set_database
95 AS res_is_false;
96
97 --echo '#--------------------FN_DYNVARS_012_04-------------------------#'
98 ##############################################################################
99 # Check if accessing variable with and without session point to session #
100 # variable #
101 ##############################################################################
102 SELECT @@character_set_database = @@session.character_set_database AS res;
103 SELECT @@character_set_database = @@local.character_set_database AS res;
104
105 --echo '#--------------------FN_DYNVARS_012_05-------------------------#'
106 ###########################################################################
107 # Check if combining character set works #
108 ###########################################################################
109 --Error ER_BAD_FIELD_ERROR
110 SET @@character_set_database = utf8 + latin2;
111
112 --echo '#--------------------FN_DYNVARS_012_06-------------------------#'
113 #############################################################################
114 # Change the value of character_set_database to a valid value for session #
115 #############################################################################
116
117 let charset_variable = @@session.character_set_database;
118 --source suite/sys_vars/inc/charset_basic.inc
119
120
121 --echo '#--------------------FN_DYNVARS_012_07-------------------------#'
122 ##############################################################################
123 # Change the value of character_set_database to a valid value for global #
124 ##############################################################################
125
126 let charset_variable = @@global.character_set_database;
127 --source suite/sys_vars/inc/charset_basic.inc
128
129
130 --echo '#--------------------FN_DYNVARS_012_08-------------------------#'
131 ##############################################################################
132 # Change the value of character_set_database to a valid value with uppercase,#
133 # lowercase and mixedcase #
134 ##############################################################################
135 SET @@character_set_database = UTF8;
136 SELECT @@character_set_database;
137 SET @@character_set_database = utf8;
138 SELECT @@character_set_database;
139
140 SET @@global.character_set_database = uTf8;
141 SELECT @@global.character_set_database;
142
143 --echo '#--------------------FN_DYNVARS_012_09-------------------------#'
144 ##############################################################
145 # Check if 1,2,3, ... values can be used on variable #
146 ##############################################################
147 SET @@character_set_database = 1;
148 SELECT @@character_set_database;
149 SET @@character_set_database = 2;
150 SELECT @@character_set_database;
151 SET @@character_set_database = 3;
152 SELECT @@character_set_database;
153 SET @@character_set_database = 36;
154 SELECT @@character_set_database;
155 SET @@character_set_database = 99;
156 SELECT @@character_set_database;
157
158 --Error ER_UNKNOWN_CHARACTER_SET
159 SET @@character_set_database = 100;
160
161
162 SET @@global.character_set_database = 1;
163 SELECT @@global.character_set_database;
164 SET @@global.character_set_database = 2;
165 SELECT @@global.character_set_database;
166 SET @@global.character_set_database = 3;
167 SELECT @@global.character_set_database;
168 SET @@global.character_set_database = 36;
169 SELECT @@global.character_set_database;
170 SET @@global.character_set_database = 99;
171 SELECT @@global.character_set_database;
172
173 --Error ER_UNKNOWN_CHARACTER_SET
174 SET @@global.character_set_database = 100;
175
176
177 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
178 SELECT @total_charset;
179
180 --echo '#--------------------FN_DYNVARS_012_10-------------------------#'
181 ##############################################################################
182 # Change the value of character_set_database to an invalid value for session #
183 ##############################################################################
184 --Error ER_UNKNOWN_CHARACTER_SET
185 SET @@character_set_database = "grek";
186 --Error ER_PARSE_ERROR
187 SET @@character_set_database = utf 8;
188 --Error ER_UNKNOWN_CHARACTER_SET
189 SET @@character_set_database = 0;
190 --Error ER_WRONG_TYPE_FOR_VAR
191 SET @@character_set_database = 1.1;
192 --Error ER_UNKNOWN_CHARACTER_SET
193 SET @@character_set_database = -1;
194 --Error ER_UNKNOWN_CHARACTER_SET
195 SET @@character_set_database = '';
196 --Error ER_UNKNOWN_CHARACTER_SET
197 SET @@character_set_database = 'latin 2';
198 SET @@character_set_database = true;
199 SELECT @@character_set_database AS res_with_true;
200
201 --Error ER_UNKNOWN_CHARACTER_SET
202 SET @@character_set_database = ON;
203 --Error ER_UNKNOWN_CHARACTER_SET
204 SET @@character_set_database = repeat('e', 256);
205 --Error ER_UNKNOWN_CHARACTER_SET
206 SET @@character_set_database = repeat('e', 1024);
207
208 --echo '#--------------------FN_DYNVARS_012_11-------------------------#'
209 ###############################################################################
210 # Change the value of character_set_database to an invalid value for global #
211 ###############################################################################
212 --Error ER_UNKNOWN_CHARACTER_SET
213 SET @@global.character_set_database = abc;
214 --Error ER_UNKNOWN_CHARACTER_SET
215 SET @@global.character_set_database = 1utf8;
216 --Error ER_UNKNOWN_CHARACTER_SET
217 SET @@global.character_set_database = 0;
218 --Error ER_WRONG_TYPE_FOR_VAR
219 SET @@global.character_set_database = 1.1;
220 --Error ER_UNKNOWN_CHARACTER_SET
221 SET @@global.character_set_database = -1;
222 --Error ER_UNKNOWN_CHARACTER_SET
223 SET @@global.character_set_database = '';
224 --Error ER_UNKNOWN_CHARACTER_SET
225 SET @@global.character_set_database = 'utf';
226
227 SET @@global.character_set_database = true;
228
229 --Error ER_UNKNOWN_CHARACTER_SET
230 SET @@global.character_set_database = ON;
231 --Error ER_UNKNOWN_CHARACTER_SET
232 SET @@global.character_set_database = repeat('e', 256);
233 --Error ER_UNKNOWN_CHARACTER_SET
234 SET @@global.character_set_database = repeat('e', 1024);
235
236 --echo '#--------------------FN_DYNVARS_012_12-------------------------#'
237 ############################################################################
238 # Check if the value in GLOBAL Table matches value in variable #
239 ############################################################################
240 --disable_warnings
241 SELECT @@global.character_set_database =
242 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
243 WHERE VARIABLE_NAME='character_set_database') AS res;
244 --enable_warnings
245 SET @@global.character_set_database = 1;
246 SELECT @@global.character_set_database;
247 --disable_warnings
248 SELECT @@global.character_set_database =
249 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
250 WHERE VARIABLE_NAME='character_set_database') AS res;
251 --enable_warnings
252
253 --echo '#--------------------FN_DYNVARS_012_13-------------------------#'
254 ##############################################################################
255 # Check if the value in SESSION Table matches value in variable #
256 ##############################################################################
257 --disable_warnings
258 SELECT @@character_set_database =
259 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
260 WHERE VARIABLE_NAME='character_set_database') AS res;
261 SELECT @@local.character_set_database =
262 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
263 WHERE VARIABLE_NAME='character_set_database') AS res;
264 SELECT @@session.character_set_database =
265 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
266 WHERE VARIABLE_NAME='character_set_database') AS res;
267 --enable_warnings
268
269 ####################################
270 # Restore initial value #
271 ####################################
272 SET @@global.character_set_database = @global_start_value;
273 SELECT @@global.character_set_database;
274 SET @@session.character_set_database = @session_start_value;
275 SELECT @@session.character_set_database;
276
277 #############################################################
278 # END OF character_set_database TESTS #
279 #############################################################