Debian Codegraph @

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

raw
1 ############## mysql-test\t\collation_server_basic.test #######################
2 # #
3 # Variable Name: collation_server #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: #
8 # Range: NA #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author: Rizwan #
13 # #
14 # Description: Test Cases of Dynamic System Variable collation_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/load_sysvars.inc
26
27 ###################################################
28 ## START OF collation_server TESTS ##
29 ###################################################
30
31 #############################################################
32 # Save initial value #
33 #############################################################
34 SET @global_start_value = @@global.collation_server;
35 SELECT @global_start_value;
36 # Save initial session value
37 SET @session_start_value = @@collation_server;
38 SELECT @session_start_value;
39 # now save using local access
40 SET @session_start_value = @@local.collation_server;
41 SELECT @session_start_value;
42 # save using implicit session scope
43 SET @session_start_value = @@session.collation_server;
44 SELECT @session_start_value;
45
46 --echo '#--------------------FN_DYNVARS_014_01------------------#'
47 ###############################################################################
48 # Test Variable access and assignment with and without @@ #
49 ###############################################################################
50 # select without @@
51 --error ER_BAD_FIELD_ERROR
52 SELECT collation_server;
53 # assign value without @@
54 SET collation_server=utf8_unicode_ci;
55 SELECT @@session.collation_server;
56 # assign global variable without @@
57 --Error ER_PARSE_ERROR
58 SET global.collation_server=utf8_unicode_ci;
59 # using another syntax for accessing session variable
60 SET session collation_server=utf8_unicode_ci;
61 # accessing variable with scope the wrong way
62 --Error ER_BAD_FIELD_ERROR
63 SELECT session collation_server;
64 # using another syntax for accessing dynamic variable
65 SET global collation_server=utf8_unicode_ci;
66 --Error ER_BAD_FIELD_ERROR
67 SELECT global collation_server;
68
69 --echo '#--------------------FN_DYNVARS_014_02-------------------------#'
70 ###############################################################################
71 # Check the DEFAULT value of collation_server for session and global #
72 ###############################################################################
73 SET @@collation_server = latin1_bin;
74 SET @@collation_server = DEFAULT;
75 SELECT @@collation_server AS DEFAULT_VALUE;
76
77 SET @@global.collation_server = latin1_bin;
78 SET @@global.collation_server = DEFAULT;
79 SELECT @@global.collation_server;
80
81 --echo '#--------------------FN_DYNVARS_014_03-------------------------#'
82 ###########################################################################
83 # Check if setting global value changes session value and vice versa #
84 ###########################################################################
85 SET @@session.collation_server = utf8_polish_ci;
86 SELECT @@session.collation_server;
87 SET @@global.collation_server = latin7_general_ci;
88 SELECT @@global.collation_server;
89 SELECT @@session.collation_server AS res_is_utf8_polish_ci;
90
91 SET @@session.collation_server = latin7_bin;
92 SELECT @@session.collation_server;
93 SELECT @@global.collation_server AS res_is_latin7_general_ci;
94 # composite check
95 SELECT @@global.collation_server=@@session.collation_server AS res_is_false;
96
97 --echo '#--------------------FN_DYNVARS_014_04-------------------------#'
98 #############################################################################
99 # Check if accessing variable with and without session point to #
100 # session variable #
101 #############################################################################
102 SELECT @@collation_server = @@session.collation_server AS res;
103 SELECT @@collation_server = @@local.collation_server AS res;
104
105 --echo '#--------------------FN_DYNVARS_014_05-------------------------#'
106 ###########################################################################
107 # Check if combining character set works #
108 ###########################################################################
109 --Error ER_BAD_FIELD_ERROR
110 SET @@collation_server = latin7_general_ci + latin7_general_cs;
111
112 --echo '#--------------------FN_DYNVARS_014_06-------------------------#'
113 ##############################################################################
114 # Change the value of collation_server to a valid value for session #
115 ##############################################################################
116
117 let $collation_variable = @@session.collation_server;
118 --source suite/sys_vars/inc/collation_basic.inc
119
120
121 --echo '#--------------------FN_DYNVARS_014_07-------------------------#'
122 #############################################################################
123 # Change the value of collation_server to a valid value for global #
124 #############################################################################
125
126 let $collation_variable = @@global.collation_server;
127 --source suite/sys_vars/inc/collation_basic.inc
128
129
130 --echo '#--------------------FN_DYNVARS_014_08-------------------------#'
131 #############################################################################
132 # Change the value of collation_server to a valid value with uppercase, #
133 # lowercase and mixedcase #
134 #############################################################################
135
136 SET @@collation_server = LATIN7_GENERAL_CS;
137 SELECT @@collation_server;
138 SET @@collation_server = latin7_general_cs;
139 SELECT @@collation_server;
140
141 SET @@global.collation_server = Latin7_GeneRal_cS;
142 SELECT @@global.collation_server;
143
144
145 --echo '#--------------------FN_DYNVARS_014_09-------------------------#'
146 ##############################################################
147 # Check if 1,2,3, ... values can be used on variable #
148 ##############################################################
149 SET @@collation_server = 1;
150 SELECT @@collation_server;
151 SET @@collation_server = 2;
152 SELECT @@collation_server;
153 SET @@collation_server = 3;
154 SELECT @@collation_server;
155 SET @@collation_server = 99;
156 SELECT @@collation_server;
157 --Error ER_UNKNOWN_COLLATION
158 SET @@collation_server = 100;
159
160
161 SET @@global.collation_server = 1;
162 SELECT @@global.collation_server;
163 SET @@global.collation_server = 2;
164 SELECT @@global.collation_server;
165 SET @@global.collation_server = 3;
166 SELECT @@global.collation_server;
167 SET @@global.collation_server = 99;
168 SELECT @@global.collation_server;
169 --Error ER_UNKNOWN_COLLATION
170 SET @@global.collation_server = 100;
171
172
173 SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS);
174 SELECT @total_collations > 120;
175
176 --echo '#--------------------FN_DYNVARS_014_10-------------------------#'
177 ###############################################################################
178 # Change the value of collation_server to an invalid value for session #
179 ###############################################################################
180 --Error ER_UNKNOWN_COLLATION
181 SET @@collation_server = latin7_binary;
182 --Error ER_UNKNOWN_COLLATION
183 SET @@collation_server = 'eucjpms_japanese_cs';
184 --Error ER_UNKNOWN_COLLATION
185 SET @@collation_server = 0;
186 --Error ER_WRONG_TYPE_FOR_VAR
187 SET @@collation_server = 1.01;
188 --Error ER_UNKNOWN_COLLATION
189 SET @@collation_server = -1;
190 --Error ER_UNKNOWN_COLLATION
191 SET @@collation_server = '';
192 --Error ER_UNKNOWN_COLLATION
193 SET @@collation_server = ' eucjpms_bin';
194 SET @@collation_server = true;
195 SELECT @@collation_server AS res_with_true;
196 --Error ER_UNKNOWN_COLLATION
197 SET @@collation_server = ON;
198 --Error ER_UNKNOWN_COLLATION
199 SET @@collation_server = repeat('e', 256);
200 --Error ER_UNKNOWN_COLLATION
201 SET @@collation_server = repeat('e', 1024);
202
203 --echo '#--------------------FN_DYNVARS_014_11-------------------------#'
204 ###############################################################################
205 # Change the value of collation_server to an invalid value for global #
206 ###############################################################################
207 --Error ER_UNKNOWN_COLLATION
208 SET @@global.collation_server = latin7_binary;
209 --Error ER_UNKNOWN_COLLATION
210 SET @@global.collation_server = 'eucjpms_japanese_cs';
211 --Error ER_UNKNOWN_COLLATION
212 SET @@global.collation_server = 0;
213 --Error ER_WRONG_TYPE_FOR_VAR
214 SET @@global.collation_server = 1.1;
215 --Error ER_UNKNOWN_COLLATION
216 SET @@global.collation_server = -1;
217 --Error ER_UNKNOWN_COLLATION
218 SET @@global.collation_server = "";
219 --Error ER_UNKNOWN_COLLATION
220 SET @@global.collation_server = ' eucjpms_bin';
221
222 SET @@global.collation_server = true;
223
224 --Error ER_UNKNOWN_COLLATION
225 SET @@global.collation_server = ON;
226 --Error ER_UNKNOWN_COLLATION
227 SET @@global.collation_server = repeat('e', 256);
228 --Error ER_UNKNOWN_COLLATION
229 SET @@global.collation_server = repeat('e', 1024);
230
231 --echo '#--------------------FN_DYNVARS_014_12-------------------------#'
232 ###############################################################################
233 # Check if the value in GLOBAL Table matches value in variable #
234 ###############################################################################
235 --disable_warnings
236 SELECT @@global.collation_server =
237 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
238 WHERE VARIABLE_NAME='collation_server') AS res;
239 --enable_warnings
240 SET @@global.collation_server = 1;
241 SELECT @@global.collation_server;
242 --disable_warnings
243 SELECT @@global.collation_server =
244 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
245 WHERE VARIABLE_NAME='collation_server') AS res;
246 --enable_warnings
247
248 --echo '#--------------------FN_DYNVARS_014_13-------------------------#'
249 ###############################################################################
250 # Check if the value in SESSION Table matches value in variable #
251 ###############################################################################
252 --disable_warnings
253 SELECT @@collation_server =
254 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
255 WHERE VARIABLE_NAME='collation_server') AS res;
256 SELECT @@local.collation_server =
257 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
258 WHERE VARIABLE_NAME='collation_server') AS res;
259 SELECT @@session.collation_server =
260 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
261 WHERE VARIABLE_NAME='collation_server') AS res;
262 --enable_warnings
263
264 ####################################
265 # Restore initial value #
266 ####################################
267 SET @@global.collation_server = @global_start_value;
268 SELECT @@global.collation_server;
269 SET @@session.collation_server = @session_start_value;
270 SELECT @@session.collation_server;
271
272 #####################################################
273 # END OF collation_server TESTS #
274 #####################################################