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