Debian Codegraph @

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

raw
1 ############## mysql-test\t\block_encryption_mode_basic.test ###################
2 # #
3 # Variable Name: block_encryption_mode #
4 # Scope: GLOBAL & SESSION #
5 # Access Type: Dynamic #
6 # Data Type: Enum #
7 # Default Value: aes-128-ecb #
8 # #
9 # #
10 # #
11 # #
12 ################################################################################
13
14 --source include/load_sysvars.inc
15
16 #####################################################################
17 # START OF block_encryption_mode TESTS #
18 #####################################################################
19
20 #############################################################
21 # Save initial value #
22 #############################################################
23
24 SET @start_global_value = @@global.block_encryption_mode;
25 SELECT @start_global_value;
26 SET @start_session_value = @@session.block_encryption_mode;
27 SELECT @start_session_value;
28
29
30 --echo '#--------------------FN_DYNVARS_002_01-------------------------#'
31 #####################################################################
32 # Display the DEFAULT value of block_encryption_mode #
33 #####################################################################
34
35 SET @@global.block_encryption_mode = 'aes-192-ecb';
36 SET @@global.block_encryption_mode = DEFAULT;
37 SELECT @@global.block_encryption_mode;
38
39 SET @@session.block_encryption_mode = 'aes-192-ecb';
40 SET @@session.block_encryption_mode = DEFAULT;
41 SELECT @@session.block_encryption_mode;
42
43
44 --echo '#--------------------FN_DYNVARS_002_02-------------------------#'
45 #####################################################################
46 # Check the DEFAULT value of block_encryption_mode #
47 #####################################################################
48
49 SET @@global.block_encryption_mode = @start_global_value;
50 SELECT @@global.block_encryption_mode = 'aes-128-ecb';
51 SET @@session.block_encryption_mode = @start_session_value;
52 SELECT @@session.block_encryption_mode = 'aes-128-ecb';
53
54
55 --echo '#--------------------FN_DYNVARS_002_03-------------------------#'
56 ###############################################################################
57 # Change the value of block_encryption_mode to a valid value for GLOBAL Scope #
58 ###############################################################################
59
60 SET @@global.block_encryption_mode = 'aes-128-ecb';
61 SELECT @@global.block_encryption_mode;
62 SET @@global.block_encryption_mode = 'aes-256-ecb';
63 SELECT @@global.block_encryption_mode;
64 SET @@global.block_encryption_mode = 'aes-256-cbc';
65 SELECT @@global.block_encryption_mode;
66
67
68 --echo '#--------------------FN_DYNVARS_002_04-------------------------#'
69 ###############################################################################
70 # Change the value of block_encryption_mode to a valid value for SESSION Scope#
71 ###############################################################################
72
73 SET @@session.block_encryption_mode = 'aes-128-ecb';
74 SELECT @@session.block_encryption_mode;
75 SET @@session.block_encryption_mode = 'aes-256-ecb';
76 SELECT @@session.block_encryption_mode;
77 SET @@session.block_encryption_mode = 'aes-256-cbc';
78 SELECT @@session.block_encryption_mode;
79
80
81 --echo '#------------------FN_DYNVARS_002_05-----------------------#'
82 #################################################################
83 # Change the value of block_encryption_mode to an invalid value #
84 #################################################################
85 # for global scope
86 SET @@global.block_encryption_mode = 0;
87 SELECT @@global.block_encryption_mode;
88 --error ER_WRONG_VALUE_FOR_VAR
89 SET @@global.block_encryption_mode = -1024;
90 SELECT @@global.block_encryption_mode;
91 --error ER_WRONG_VALUE_FOR_VAR
92 SET @@global.block_encryption_mode = 65536;
93 SELECT @@global.block_encryption_mode;
94 --error ER_WRONG_VALUE_FOR_VAR
95 SET @@global.block_encryption_mode = 4294967295;
96 SELECT @@global.block_encryption_mode;
97 --Error ER_WRONG_TYPE_FOR_VAR
98 SET @@global.block_encryption_mode = 65535.4;
99 SELECT @@global.block_encryption_mode;
100 --Error ER_WRONG_VALUE_FOR_VAR
101 SET @@global.block_encryption_mode = ON;
102 SELECT @@global.block_encryption_mode;
103 --Error ER_WRONG_VALUE_FOR_VAR
104 SET @@global.block_encryption_mode = OFF;
105 SELECT @@global.block_encryption_mode;
106 --Error ER_WRONG_VALUE_FOR_VAR
107 SET @@global.block_encryption_mode = test;
108 SELECT @@global.block_encryption_mode;
109 --Error ER_WRONG_VALUE_FOR_VAR
110 SET @@global.block_encryption_mode = 'des-128-ecb';
111 SELECT @@global.block_encryption_mode;
112 # for session scope
113 SET @@session.block_encryption_mode = 0;
114 SELECT @@session.block_encryption_mode;
115 --Error ER_WRONG_VALUE_FOR_VAR
116 SET @@session.block_encryption_mode = -1024;
117 SELECT @@session.block_encryption_mode;
118 --Error ER_WRONG_VALUE_FOR_VAR
119 SET @@session.block_encryption_mode = 65536;
120 SELECT @@session.block_encryption_mode;
121 --Error ER_WRONG_VALUE_FOR_VAR
122 SET @@session.block_encryption_mode = 4294967295;
123 SELECT @@session.block_encryption_mode;
124 --Error ER_WRONG_TYPE_FOR_VAR
125 SET @@session.block_encryption_mode = 65535.4;
126 SELECT @@session.block_encryption_mode;
127 --Error ER_WRONG_VALUE_FOR_VAR
128 SET @@session.block_encryption_mode = ON;
129 SELECT @@session.block_encryption_mode;
130 --Error ER_WRONG_VALUE_FOR_VAR
131 SET @@session.block_encryption_mode = OFF;
132 SELECT @@session.block_encryption_mode;
133 --Error ER_WRONG_VALUE_FOR_VAR
134 SET @@session.block_encryption_mode = test;
135 SELECT @@session.block_encryption_mode;
136 --Error ER_WRONG_VALUE_FOR_VAR
137 SET @@session.block_encryption_mode = 'des-128-ecb';
138 SELECT @@session.block_encryption_mode;
139
140
141
142 --echo '#------------------FN_DYNVARS_002_06-----------------------#'
143 ####################################################################
144 # Check if the value in GLOBAL Table matches value in variable #
145 ####################################################################
146
147 --disable_warnings
148 SELECT @@global.block_encryption_mode = VARIABLE_VALUE
149 FROM performance_schema.global_variables
150 WHERE VARIABLE_NAME='block_encryption_mode';
151 --enable_warnings
152
153
154 --echo '#------------------FN_DYNVARS_002_07-----------------------#'
155 ####################################################################
156 # Check if the value in SESSION Table matches value in variable #
157 ####################################################################
158
159 --disable_warnings
160 SELECT @@session.block_encryption_mode = VARIABLE_VALUE
161 FROM performance_schema.session_variables
162 WHERE VARIABLE_NAME='block_encryption_mode';
163 --enable_warnings
164
165
166 --echo '#------------------FN_DYNVARS_002_08-----------------------#'
167 ####################################################################
168 # Check if TRUE and FALSE values can be used on variable #
169 ####################################################################
170
171 SET @@global.block_encryption_mode = TRUE;
172 SELECT @@global.block_encryption_mode;
173 SET @@global.block_encryption_mode = FALSE;
174 SELECT @@global.block_encryption_mode;
175
176
177 --echo '#---------------------FN_DYNVARS_001_09----------------------#'
178 ###############################################################################
179 # Check if global and session variables are independant of each other #
180 ###############################################################################
181
182 SET @@global.block_encryption_mode = 'aes-192-ecb';
183 SET @@session.block_encryption_mode = 'aes-256-cbc';
184 SELECT @@block_encryption_mode = @@global.block_encryption_mode;
185
186
187 --echo '#---------------------FN_DYNVARS_001_10----------------------#'
188 ##############################################################################
189 # Check if accessing variable with SESSION,LOCAL and without SCOPE points #
190 # to same session variable #
191 ##############################################################################
192
193 SET @@block_encryption_mode = 'aes-192-cbc';
194 SELECT @@block_encryption_mode = @@local.block_encryption_mode;
195 SELECT @@local.block_encryption_mode = @@session.block_encryption_mode;
196
197
198 --echo '#---------------------FN_DYNVARS_001_11----------------------#'
199 ###############################################################################
200 # Check if block_encryption_mode can be accessed with and without @@ sign #
201 ###############################################################################
202
203 SET block_encryption_mode = 'aes-128-cbc';
204 SELECT @@block_encryption_mode;
205 --Error ER_UNKNOWN_TABLE
206 SELECT local.block_encryption_mode;
207 --Error ER_UNKNOWN_TABLE
208 SELECT session.block_encryption_mode;
209 --Error ER_BAD_FIELD_ERROR
210 SELECT block_encryption_mode = @@session.block_encryption_mode;
211
212
213 ####################################
214 # Restore initial value #
215 ####################################
216
217 SET @@global.block_encryption_mode = @start_global_value;
218 SELECT @@global.block_encryption_mode;
219 SET @@session.block_encryption_mode = @start_session_value;
220 SELECT @@session.block_encryption_mode;
221
222
223 ###################################################
224 # END OF block_encryption_mode TESTS #
225 ###################################################
226
227 --echo #
228 --echo # End of 5.7 tests
229 --echo #