Debian Codegraph @

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

raw
1 ############## mysql-test\t\character_set_database_basic.test #################
2 # #
3 # Variable Name: character_set_database #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: latin1 (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_database #
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/have_utf8mb4.inc
31 --source include/have_utf16.inc
32 --source include/have_utf32.inc
33 --source include/default_charset.inc
34 --source include/load_sysvars.inc
35 ###################################################
36 ## START OF character_set_database TESTS ##
37 ###################################################
38
39 #############################################################
40 # Save initial value #
41 #############################################################
42 SET @global_collation_database = @@global.collation_database;
43 SET @session_collation_database = @@session.collation_database;
44
45 SET @global_start_value = @@global.character_set_database;
46 SET @@global.character_set_database=@@character_set_client;
47 SELECT @@global.character_set_database;
48 # Save initial session value
49 SET @session_start_value = @@character_set_database;
50 SELECT @session_start_value;
51 # now save using local access
52 SET @session_start_value = @@local.character_set_database;
53 SELECT @session_start_value;
54 # save using default access (session)
55 SET @session_start_value = @@session.character_set_database;
56 SELECT @session_start_value;
57
58 --echo '#--------------------FN_DYNVARS_012_01------------------#'
59 ##############################################################################
60 # Test Variable access and assignment with and withoud @@ #
61 ##############################################################################
62 # select without @@
63 --error ER_BAD_FIELD_ERROR
64 SELECT character_set_database;
65 # assign value without @@
66 SET character_set_database=utf8;
67 SELECT @@session.character_set_database;
68 # assign global variable without @@
69 # using another syntax for accessing session variable
70 SET session character_set_database=utf8;
71 # accessing variable with scope the wrong way
72 --Error ER_BAD_FIELD_ERROR
73 SELECT session character_set_database;
74 # using another syntax for accessing dynamic variable
75 SET global character_set_database=utf8;
76 --Error ER_BAD_FIELD_ERROR
77 SELECT global character_set_database;
78
79 --echo '#--------------------FN_DYNVARS_012_02-------------------------#'
80 ###############################################################################
81 # Check the DEFAULT value of character_set_database for session and global #
82 ###############################################################################
83 SET @@character_set_database = latin5;
84 SET @@character_set_database = DEFAULT;
85 SELECT @@character_set_database AS DEFAULT_VALUE;
86
87 SET @@global.character_set_database = latin5;
88 SET @@global.character_set_database = DEFAULT;
89 SELECT @@global.character_set_database;
90
91 --echo '#--------------------FN_DYNVARS_012_03-------------------------#'
92 ##############################################################################
93 # see if setting global value changes session value and vice versa #
94 ##############################################################################
95 SET @@session.character_set_database = utf8;
96 SELECT @@session.character_set_database;
97 SET @@global.character_set_database = latin2;
98 SELECT @@global.character_set_database;
99 SELECT @@session.character_set_database AS res_is_utf8;
100
101 SET @@session.character_set_database = latin5;
102 SELECT @@session.character_set_database;
103 SELECT @@global.character_set_database AS res_is_latin2;
104 # composite check
105 SELECT @@global.character_set_database=@@session.character_set_database
106 AS res_is_false;
107
108 --echo '#--------------------FN_DYNVARS_012_04-------------------------#'
109 ##############################################################################
110 # Check if accessing variable with and without session point to session #
111 # variable #
112 ##############################################################################
113 SELECT @@character_set_database = @@session.character_set_database AS res;
114 SELECT @@character_set_database = @@local.character_set_database AS res;
115
116 --echo '#--------------------FN_DYNVARS_012_05-------------------------#'
117 ###########################################################################
118 # Check if combining character set works #
119 ###########################################################################
120 --Error ER_BAD_FIELD_ERROR
121 SET @@character_set_database = utf8 + latin2;
122
123 --echo '#--------------------FN_DYNVARS_012_06-------------------------#'
124 #############################################################################
125 # Change the value of character_set_database to a valid value for session #
126 #############################################################################
127
128 let charset_variable = @@session.character_set_database;
129 --source suite/sys_vars/inc/charset_basic.inc
130
131
132 --echo '#--------------------FN_DYNVARS_012_07-------------------------#'
133 ##############################################################################
134 # Change the value of character_set_database to a valid value for global #
135 ##############################################################################
136
137 let charset_variable = @@global.character_set_database;
138 --source suite/sys_vars/inc/charset_basic.inc
139
140
141 --echo '#--------------------FN_DYNVARS_012_08-------------------------#'
142 ##############################################################################
143 # Change the value of character_set_database to a valid value with uppercase,#
144 # lowercase and mixedcase #
145 ##############################################################################
146 SET @@character_set_database = UTF8;
147 SELECT @@character_set_database;
148 SET @@character_set_database = utf8;
149 SELECT @@character_set_database;
150
151 SET @@global.character_set_database = uTf8;
152 SELECT @@global.character_set_database;
153
154 --echo '#--------------------FN_DYNVARS_012_09-------------------------#'
155 ##############################################################
156 # Check if 1,2,3, ... values can be used on variable #
157 ##############################################################
158 SET @@character_set_database = 1;
159 SELECT @@character_set_database;
160
161 --echo # latin2_czech_cs is not a default collation
162 --error ER_UNKNOWN_CHARACTER_SET
163 SET @@character_set_database = 2;
164
165 SET @@character_set_database = 3;
166 SELECT @@character_set_database;
167 SET @@character_set_database = 36;
168 SELECT @@character_set_database;
169
170 --echo # cp1250_polish_ci is not a default collation
171 --error ER_UNKNOWN_CHARACTER_SET
172 SET @@character_set_database = 99;
173
174 --echo # Collation ID 100 does not exist
175 --Error ER_UNKNOWN_CHARACTER_SET
176 SET @@character_set_database = 100;
177
178
179 SET @@global.character_set_database = 1;
180 SELECT @@global.character_set_database;
181
182 --echo # latin2_czech_cs is not a default collation
183 --error ER_UNKNOWN_CHARACTER_SET
184 SET @@global.character_set_database = 2;
185
186 SET @@global.character_set_database = 3;
187 SELECT @@global.character_set_database;
188 SET @@global.character_set_database = 36;
189 SELECT @@global.character_set_database;
190
191 --echo # cp1250_polish_ci is not a default collation
192 --error ER_UNKNOWN_CHARACTER_SET
193 SET @@global.character_set_database = 99;
194
195 --echo # Collation ID 100 does not exist
196 --Error ER_UNKNOWN_CHARACTER_SET
197 SET @@global.character_set_database = 100;
198
199
200 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
201 SELECT @total_charset;
202
203 --echo '#--------------------FN_DYNVARS_012_10-------------------------#'
204 ##############################################################################
205 # Change the value of character_set_database to an invalid value for session #
206 ##############################################################################
207 --Error ER_UNKNOWN_CHARACTER_SET
208 SET @@character_set_database = "grek";
209 --Error ER_PARSE_ERROR
210 SET @@character_set_database = utf 8;
211 --Error ER_UNKNOWN_CHARACTER_SET
212 SET @@character_set_database = 0;
213 --Error ER_WRONG_TYPE_FOR_VAR
214 SET @@character_set_database = 1.1;
215 --Error ER_UNKNOWN_CHARACTER_SET
216 SET @@character_set_database = -1;
217 --Error ER_UNKNOWN_CHARACTER_SET
218 SET @@character_set_database = '';
219 --Error ER_UNKNOWN_CHARACTER_SET
220 SET @@character_set_database = 'latin 2';
221 SET @@character_set_database = true;
222 SELECT @@character_set_database AS res_with_true;
223
224 --Error ER_UNKNOWN_CHARACTER_SET
225 SET @@character_set_database = ON;
226
227 --echo '#--------------------FN_DYNVARS_012_11-------------------------#'
228 ###############################################################################
229 # Change the value of character_set_database to an invalid value for global #
230 ###############################################################################
231 --Error ER_UNKNOWN_CHARACTER_SET
232 SET @@global.character_set_database = abc;
233 --Error ER_UNKNOWN_CHARACTER_SET
234 SET @@global.character_set_database = 1utf8;
235 --Error ER_UNKNOWN_CHARACTER_SET
236 SET @@global.character_set_database = 0;
237 --Error ER_WRONG_TYPE_FOR_VAR
238 SET @@global.character_set_database = 1.1;
239 --Error ER_UNKNOWN_CHARACTER_SET
240 SET @@global.character_set_database = -1;
241 --Error ER_UNKNOWN_CHARACTER_SET
242 SET @@global.character_set_database = '';
243 --Error ER_UNKNOWN_CHARACTER_SET
244 SET @@global.character_set_database = 'utf';
245
246 SET @@global.character_set_database = true;
247
248 --Error ER_UNKNOWN_CHARACTER_SET
249 SET @@global.character_set_database = ON;
250
251 --echo '#--------------------FN_DYNVARS_012_12-------------------------#'
252 ############################################################################
253 # Check if the value in GLOBAL Table matches value in variable #
254 ############################################################################
255 SELECT @@global.character_set_database =
256 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
257 WHERE VARIABLE_NAME='character_set_database') AS res;
258 SET @@global.character_set_database = 1;
259 SELECT @@global.character_set_database;
260 SELECT @@global.character_set_database =
261 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
262 WHERE VARIABLE_NAME='character_set_database') AS res;
263
264 --echo '#--------------------FN_DYNVARS_012_13-------------------------#'
265 ##############################################################################
266 # Check if the value in SESSION Table matches value in variable #
267 ##############################################################################
268 SELECT @@character_set_database =
269 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
270 WHERE VARIABLE_NAME='character_set_database') AS res;
271 SELECT @@local.character_set_database =
272 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
273 WHERE VARIABLE_NAME='character_set_database') AS res;
274 SELECT @@session.character_set_database =
275 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
276 WHERE VARIABLE_NAME='character_set_database') AS res;
277
278 ####################################
279 # Restore initial value #
280 ####################################
281 SET @@global.collation_database = @global_collation_database;
282 SET @@session.collation_database = @session_collation_database;
283
284 #############################################################
285 # END OF character_set_database TESTS #
286 #############################################################