Debian Codegraph @

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

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