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/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 collation_connection TESTS ##
35 ###################################################
36
37 #############################################################
38 # Save initial value #
39 #############################################################
40 SET @global_start_value = @@global.collation_connection;
41 SET @@global.collation_connection=@@collation_connection;
42 SELECT @@global.collation_connection;
43 # Save initial session value
44 SET @session_start_value = @@collation_connection;
45 SELECT @session_start_value;
46 # now save using local access
47 SET @session_start_value = @@local.collation_connection;
48 SELECT @session_start_value;
49 # save using implicit session scope
50 SET @session_start_value = @@session.collation_connection;
51 SELECT @session_start_value;
52
53 --echo '#--------------------FN_DYNVARS_015_01------------------#'
54 ###############################################################################
55 # Test Variable access and assignment with and without @@ #
56 ###############################################################################
57 # select without @@
58 --error ER_BAD_FIELD_ERROR
59 SELECT collation_connection;
60 # assign value without @@
61 SET collation_connection=utf8_unicode_ci;
62 SELECT @@session.collation_connection;
63 # using another syntax for accessing session variable
64 SET session collation_connection=utf8_unicode_ci;
65 # accessing variable with scope the wrong way
66 --Error ER_BAD_FIELD_ERROR
67 SELECT session collation_connection;
68 # using another syntax for accessing dynamic variable
69 SET global collation_connection=utf8_unicode_ci;
70 --Error ER_BAD_FIELD_ERROR
71 SELECT global collation_connection;
72
73 --echo '#--------------------FN_DYNVARS_015_02-------------------------#'
74 ###############################################################################
75 # Check the DEFAULT value of collation_connection for session and global #
76 ###############################################################################
77 SET @@collation_connection = latin1_bin;
78 SET @@collation_connection = DEFAULT;
79 SELECT @@collation_connection = @@global.collation_connection;
80
81 SET @@global.collation_connection = latin1_bin;
82 SET @@global.collation_connection = DEFAULT;
83 SELECT @@global.collation_connection = @global_start_value;
84
85 --echo '#--------------------FN_DYNVARS_015_03-------------------------#'
86 ##############################################################################
87 # see if setting global value changes session value and vice versa #
88 ##############################################################################
89 SET @@session.collation_connection = utf8_polish_ci;
90 SELECT @@session.collation_connection;
91 SET @@global.collation_connection = latin7_general_ci;
92 SELECT @@global.collation_connection;
93 SELECT @@session.collation_connection AS res_is_utf8_polish_ci;
94
95 SET @@session.collation_connection = latin7_bin;
96 SELECT @@session.collation_connection;
97 SELECT @@global.collation_connection AS res_is_latin7_general_ci;
98 # composite check
99 SELECT @@global.collation_connection=@@session.collation_connection
100 AS res_is_false;
101
102 --echo '#--------------------FN_DYNVARS_015_04-------------------------#'
103 ###############################################################################
104 # Check if accessing variable with and without session point to session #
105 # variable #
106 ###############################################################################
107 SELECT @@collation_connection = @@session.collation_connection AS res;
108 SELECT @@collation_connection = @@local.collation_connection AS res;
109
110 --echo '#--------------------FN_DYNVARS_015_05-------------------------#'
111 ###########################################################################
112 # Check if combining character set works #
113 ###########################################################################
114 --Error ER_BAD_FIELD_ERROR
115 SET @@collation_connection = latin7_general_ci + latin7_general_cs;
116
117 --echo '#--------------------FN_DYNVARS_015_06-------------------------#'
118 ###############################################################################
119 # Change the value of collation_connection to a valid value for session #
120 ###############################################################################
121
122 let $collation_variable = @@session.collation_connection;
123 --source suite/sys_vars/inc/collation_basic.inc
124
125
126 --echo '#--------------------FN_DYNVARS_015_07-------------------------#'
127 ###############################################################################
128 # Change the value of collation_connection to a valid value for global #
129 ###############################################################################
130
131 let $collation_variable = @@global.collation_connection;
132 --source suite/sys_vars/inc/collation_basic.inc
133
134
135 --echo '#--------------------FN_DYNVARS_015_08-------------------------#'
136 ##############################################################################
137 # Change the value of collation_connection to a valid value with uppercase, #
138 # lowercase and mixedcase #
139 ##############################################################################
140 SET @@collation_connection = LATIN7_GENERAL_CS;
141 SELECT @@collation_connection;
142 SET @@collation_connection = latin7_general_cs;
143 SELECT @@collation_connection;
144
145 SET @@global.collation_connection = Latin7_GeneRal_cS;
146 SELECT @@global.collation_connection;
147
148
149 --echo '#--------------------FN_DYNVARS_015_09-------------------------#'
150 ##############################################################
151 # Check if 1,2,3, ... values can be used on variable #
152 ##############################################################
153 SET @@collation_connection = 1;
154 SELECT @@collation_connection;
155 SET @@collation_connection = 2;
156 SELECT @@collation_connection;
157 SET @@collation_connection = 3;
158 SELECT @@collation_connection;
159 SET @@collation_connection = 99;
160 SELECT @@collation_connection;
161 --Error ER_UNKNOWN_COLLATION
162 SET @@collation_connection = 100;
163
164 SET @@global.collation_connection = 1;
165 SELECT @@global.collation_connection;
166 SET @@global.collation_connection = 2;
167 SELECT @@global.collation_connection;
168 SET @@global.collation_connection = 3;
169 SELECT @@global.collation_connection;
170 SET @@global.collation_connection = 99;
171 SELECT @@global.collation_connection;
172 --Error ER_UNKNOWN_COLLATION
173 SET @@global.collation_connection = 100;
174
175 SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS);
176 SELECT @total_collations > 120;
177
178 --echo '#--------------------FN_DYNVARS_015_10-------------------------#'
179 ###############################################################################
180 # Change the value of collation_connection to an invalid value for session #
181 ###############################################################################
182 --Error ER_UNKNOWN_COLLATION
183 SET @@collation_connection = latin7_binary;
184 --Error ER_UNKNOWN_COLLATION
185 SET @@collation_connection = 'eucjpms_japanese_cs';
186 --Error ER_UNKNOWN_COLLATION
187 SET @@collation_connection = 0;
188 --Error ER_WRONG_TYPE_FOR_VAR
189 SET @@collation_connection = 1.01;
190 --Error ER_UNKNOWN_COLLATION
191 SET @@collation_connection = -1;
192 --Error ER_UNKNOWN_COLLATION
193 SET @@collation_connection = '';
194 --Error ER_UNKNOWN_COLLATION
195 SET @@collation_connection = ' eucjpms_bin';
196 SET @@collation_connection = true;
197 SELECT @@collation_connection AS res_with_true;
198
199 --Error ER_UNKNOWN_COLLATION
200 SET @@collation_connection = ON;
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
226 --echo '#--------------------FN_DYNVARS_015_12-------------------------#'
227 ##############################################################################
228 # Check if the value in GLOBAL Table matches value in variable #
229 ##############################################################################
230 SELECT @@global.collation_connection =
231 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
232 WHERE VARIABLE_NAME='collation_connection') AS res;
233 SET @@global.collation_connection = 1;
234 SELECT @@global.collation_connection;
235 SELECT @@global.collation_connection =
236 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
237 WHERE VARIABLE_NAME='collation_connection') AS res;
238
239 --echo '#--------------------FN_DYNVARS_015_13-------------------------#'
240 ###############################################################################
241 # Check if the value in SESSION Table matches value in variable #
242 ###############################################################################
243 SELECT @@collation_connection =
244 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
245 WHERE VARIABLE_NAME='collation_connection') AS res;
246 SELECT @@local.collation_connection =
247 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
248 WHERE VARIABLE_NAME='collation_connection') AS res;
249 SELECT @@session.collation_connection =
250 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
251 WHERE VARIABLE_NAME='collation_connection') AS res;
252
253 ####################################
254 # Restore initial value #
255 ####################################
256 SET @@global.collation_connection = @global_start_value;
257 SET @@session.collation_connection = @session_start_value;
258
259 #############################################################
260 # END OF collation_connection TESTS #
261 #############################################################