Debian Codegraph @

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

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