Debian Codegraph @

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

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