Debian Codegraph @

mysql-test/suite/component_keyring_file/r/udf_test.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # ----------------------------------------------------------------------
8 # Setting up Keyring UDFs
9 INSTALL PLUGIN keyring_udf SONAME 'keyring_udf.so';
10 CREATE FUNCTION keyring_key_store RETURNS INTEGER SONAME 'keyring_udf.so';
11 CREATE FUNCTION keyring_key_generate RETURNS INTEGER SONAME 'keyring_udf.so';
12 CREATE FUNCTION keyring_key_fetch RETURNS sTRING SONAME 'keyring_udf.so';
13 CREATE FUNCTION keyring_key_type_fetch RETURNS STRING SONAME 'keyring_udf.so';
14 CREATE FUNCTION keyring_key_length_fetch RETURNS INTEGER SONAME 'keyring_udf.so';
15 CREATE FUNCTION keyring_key_remove RETURNS INTEGER SONAME 'keyring_udf.so';
16 # ----------------------------------------------------------------------
17 # Tests for AES key type
18 # keyring_key_generate tests
19 SELECT keyring_key_generate('AES_g1', 'AES', 16);
20 keyring_key_generate('AES_g1', 'AES', 16)
21 1
22 SELECT keyring_key_generate('AES_g2', 'AES', 32);
23 keyring_key_generate('AES_g2', 'AES', 32)
24 1
25 SELECT keyring_key_generate('AES_g3', 'AES', 64);
26 keyring_key_generate('AES_g3', 'AES', 64)
27 1
28 # keyring_key_store tests
29 SELECT keyring_key_store('AES_s1', 'AES', 'Quick brown fox jumped over the lazy dog');
30 keyring_key_store('AES_s1', 'AES', 'Quick brown fox jumped over the lazy dog')
31 1
32 SELECT keyring_key_store('AES_s2', 'AES', 'Old MacDonald had a farm');
33 keyring_key_store('AES_s2', 'AES', 'Old MacDonald had a farm')
34 1
35 SELECT keyring_key_store('AES_s3', 'AES', 'Quis custodiet ipsos custodes');
36 keyring_key_store('AES_s3', 'AES', 'Quis custodiet ipsos custodes')
37 1
38 # keyring_key_fetch tests
39 SELECT keyring_key_fetch('AES_g1') INTO @aes_g1_fetched;
40 SELECT keyring_key_fetch('AES_g2') INTO @aes_g2_fetched;
41 SELECT keyring_key_fetch('AES_g3') INTO @aes_g3_fetched;
42 SELECT LENGTH(@aes_g1_fetched);
43 LENGTH(@aes_g1_fetched)
44 16
45 SELECT LENGTH(@aes_g2_fetched);
46 LENGTH(@aes_g2_fetched)
47 32
48 SELECT LENGTH(@aes_g3_fetched);
49 LENGTH(@aes_g3_fetched)
50 64
51 SELECT keyring_key_fetch('AES_s1');
52 keyring_key_fetch('AES_s1')
53 Quick brown fox jumped over the lazy dog
54 SELECT keyring_key_fetch('AES_s2');
55 keyring_key_fetch('AES_s2')
56 Old MacDonald had a farm
57 SELECT keyring_key_fetch('AES_s3');
58 keyring_key_fetch('AES_s3')
59 Quis custodiet ipsos custodes
60 # keyring key_type_fetch tests
61 SELECT keyring_key_type_fetch('AES_g1');
62 keyring_key_type_fetch('AES_g1')
63 AES
64 SELECT keyring_key_type_fetch('AES_g2');
65 keyring_key_type_fetch('AES_g2')
66 AES
67 SELECT keyring_key_type_fetch('AES_g3');
68 keyring_key_type_fetch('AES_g3')
69 AES
70 SELECT keyring_key_type_fetch('AES_s1');
71 keyring_key_type_fetch('AES_s1')
72 AES
73 SELECT keyring_key_type_fetch('AES_s2');
74 keyring_key_type_fetch('AES_s2')
75 AES
76 SELECT keyring_key_type_fetch('AES_s3');
77 keyring_key_type_fetch('AES_s3')
78 AES
79 # keyring key_length_fetch tests
80 SELECT keyring_key_length_fetch('AES_g1');
81 keyring_key_length_fetch('AES_g1')
82 16
83 SELECT keyring_key_length_fetch('AES_g2');
84 keyring_key_length_fetch('AES_g2')
85 32
86 SELECT keyring_key_length_fetch('AES_g3');
87 keyring_key_length_fetch('AES_g3')
88 64
89 SELECT keyring_key_length_fetch('AES_s1');
90 keyring_key_length_fetch('AES_s1')
91 40
92 SELECT keyring_key_length_fetch('AES_s2');
93 keyring_key_length_fetch('AES_s2')
94 24
95 SELECT keyring_key_length_fetch('AES_s3');
96 keyring_key_length_fetch('AES_s3')
97 29
98 # Restarting the server
99 # keyring_key_fetch tests after restart
100 SELECT keyring_key_fetch('AES_g1') INTO @aes_g1_fetched_after_restart;
101 SELECT keyring_key_fetch('AES_g2') INTO @aes_g2_fetched_after_restart;
102 SELECT keyring_key_fetch('AES_g3') INTO @aes_g3_fetched_after_restart;
103 SELECT LENGTH(@aes_g1_fetched_after_restart);
104 LENGTH(@aes_g1_fetched_after_restart)
105 16
106 SELECT LENGTH(@aes_g2_fetched_after_restart);
107 LENGTH(@aes_g2_fetched_after_restart)
108 32
109 SELECT LENGTH(@aes_g3_fetched_after_restart);
110 LENGTH(@aes_g3_fetched_after_restart)
111 64
112 SELECT keyring_key_fetch('AES_s1');
113 keyring_key_fetch('AES_s1')
114 Quick brown fox jumped over the lazy dog
115 SELECT keyring_key_fetch('AES_s2');
116 keyring_key_fetch('AES_s2')
117 Old MacDonald had a farm
118 SELECT keyring_key_fetch('AES_s3');
119 keyring_key_fetch('AES_s3')
120 Quis custodiet ipsos custodes
121 # keyring key_type_fetch tests after restart
122 SELECT keyring_key_type_fetch('AES_g1');
123 keyring_key_type_fetch('AES_g1')
124 AES
125 SELECT keyring_key_type_fetch('AES_g2');
126 keyring_key_type_fetch('AES_g2')
127 AES
128 SELECT keyring_key_type_fetch('AES_g3');
129 keyring_key_type_fetch('AES_g3')
130 AES
131 # keyring key_length_fetch tests after restart
132 SELECT keyring_key_length_fetch('AES_g1');
133 keyring_key_length_fetch('AES_g1')
134 16
135 SELECT keyring_key_length_fetch('AES_g2');
136 keyring_key_length_fetch('AES_g2')
137 32
138 SELECT keyring_key_length_fetch('AES_g3');
139 keyring_key_length_fetch('AES_g3')
140 64
141 # keyring_key_remove tests
142 SELECT keyring_key_remove('AES_g1');
143 keyring_key_remove('AES_g1')
144 1
145 SELECT keyring_key_remove('AES_g2');
146 keyring_key_remove('AES_g2')
147 1
148 SELECT keyring_key_remove('AES_g3');
149 keyring_key_remove('AES_g3')
150 1
151 SELECT keyring_key_remove('AES_s1');
152 keyring_key_remove('AES_s1')
153 1
154 SELECT keyring_key_remove('AES_s2');
155 keyring_key_remove('AES_s2')
156 1
157 SELECT keyring_key_remove('AES_s3');
158 keyring_key_remove('AES_s3')
159 1
160 # Tests for SECRET key type
161 # keyring_key_generate tests
162 SELECT keyring_key_generate('SECRET_g1', 'SECRET', 16);
163 keyring_key_generate('SECRET_g1', 'SECRET', 16)
164 1
165 SELECT keyring_key_generate('SECRET_g2', 'SECRET', 32);
166 keyring_key_generate('SECRET_g2', 'SECRET', 32)
167 1
168 SELECT keyring_key_generate('SECRET_g3', 'SECRET', 64);
169 keyring_key_generate('SECRET_g3', 'SECRET', 64)
170 1
171 # keyring_key_store tests
172 SELECT keyring_key_store('SECRET_s1', 'SECRET', 'Quick brown fox jumped over the lazy dog');
173 keyring_key_store('SECRET_s1', 'SECRET', 'Quick brown fox jumped over the lazy dog')
174 1
175 SELECT keyring_key_store('SECRET_s2', 'SECRET', 'Old MacDonald had a farm');
176 keyring_key_store('SECRET_s2', 'SECRET', 'Old MacDonald had a farm')
177 1
178 SELECT keyring_key_store('SECRET_s3', 'SECRET', 'Quis custodiet ipsos custodes');
179 keyring_key_store('SECRET_s3', 'SECRET', 'Quis custodiet ipsos custodes')
180 1
181 # keyring_key_fetch tests
182 SELECT keyring_key_fetch('SECRET_g1') INTO @secret_g1_fetched;
183 SELECT keyring_key_fetch('SECRET_g2') INTO @secret_g2_fetched;
184 SELECT keyring_key_fetch('SECRET_g3') INTO @secret_g3_fetched;
185 SELECT LENGTH(@secret_g1_fetched);
186 LENGTH(@secret_g1_fetched)
187 16
188 SELECT LENGTH(@secret_g2_fetched);
189 LENGTH(@secret_g2_fetched)
190 32
191 SELECT LENGTH(@secret_g3_fetched);
192 LENGTH(@secret_g3_fetched)
193 64
194 SELECT keyring_key_fetch('SECRET_s1');
195 keyring_key_fetch('SECRET_s1')
196 Quick brown fox jumped over the lazy dog
197 SELECT keyring_key_fetch('SECRET_s2');
198 keyring_key_fetch('SECRET_s2')
199 Old MacDonald had a farm
200 SELECT keyring_key_fetch('SECRET_s3');
201 keyring_key_fetch('SECRET_s3')
202 Quis custodiet ipsos custodes
203 # keyring key_type_fetch tests
204 SELECT keyring_key_type_fetch('SECRET_g1');
205 keyring_key_type_fetch('SECRET_g1')
206 SECRET
207 SELECT keyring_key_type_fetch('SECRET_g2');
208 keyring_key_type_fetch('SECRET_g2')
209 SECRET
210 SELECT keyring_key_type_fetch('SECRET_g3');
211 keyring_key_type_fetch('SECRET_g3')
212 SECRET
213 SELECT keyring_key_type_fetch('SECRET_s1');
214 keyring_key_type_fetch('SECRET_s1')
215 SECRET
216 SELECT keyring_key_type_fetch('SECRET_s2');
217 keyring_key_type_fetch('SECRET_s2')
218 SECRET
219 SELECT keyring_key_type_fetch('SECRET_s3');
220 keyring_key_type_fetch('SECRET_s3')
221 SECRET
222 # keyring key_length_fetch tests
223 SELECT keyring_key_length_fetch('SECRET_g1');
224 keyring_key_length_fetch('SECRET_g1')
225 16
226 SELECT keyring_key_length_fetch('SECRET_g2');
227 keyring_key_length_fetch('SECRET_g2')
228 32
229 SELECT keyring_key_length_fetch('SECRET_g3');
230 keyring_key_length_fetch('SECRET_g3')
231 64
232 SELECT keyring_key_length_fetch('SECRET_s1');
233 keyring_key_length_fetch('SECRET_s1')
234 40
235 SELECT keyring_key_length_fetch('SECRET_s2');
236 keyring_key_length_fetch('SECRET_s2')
237 24
238 SELECT keyring_key_length_fetch('SECRET_s3');
239 keyring_key_length_fetch('SECRET_s3')
240 29
241 # Restarting the server
242 # keyring_key_fetch tests after restart
243 SELECT keyring_key_fetch('SECRET_g1') INTO @secret_g1_fetched_after_restart;
244 SELECT keyring_key_fetch('SECRET_g2') INTO @secret_g2_fetched_after_restart;
245 SELECT keyring_key_fetch('SECRET_g3') INTO @secret_g3_fetched_after_restart;
246 SELECT LENGTH(@secret_g1_fetched_after_restart);
247 LENGTH(@secret_g1_fetched_after_restart)
248 16
249 SELECT LENGTH(@secret_g2_fetched_after_restart);
250 LENGTH(@secret_g2_fetched_after_restart)
251 32
252 SELECT LENGTH(@secret_g3_fetched_after_restart);
253 LENGTH(@secret_g3_fetched_after_restart)
254 64
255 SELECT keyring_key_fetch('SECRET_s1');
256 keyring_key_fetch('SECRET_s1')
257 Quick brown fox jumped over the lazy dog
258 SELECT keyring_key_fetch('SECRET_s2');
259 keyring_key_fetch('SECRET_s2')
260 Old MacDonald had a farm
261 SELECT keyring_key_fetch('SECRET_s3');
262 keyring_key_fetch('SECRET_s3')
263 Quis custodiet ipsos custodes
264 # keyring key_type_fetch tests after restart
265 SELECT keyring_key_type_fetch('SECRET_g1');
266 keyring_key_type_fetch('SECRET_g1')
267 SECRET
268 SELECT keyring_key_type_fetch('SECRET_g2');
269 keyring_key_type_fetch('SECRET_g2')
270 SECRET
271 SELECT keyring_key_type_fetch('SECRET_g3');
272 keyring_key_type_fetch('SECRET_g3')
273 SECRET
274 # keyring key_length_fetch tests after restart
275 SELECT keyring_key_length_fetch('SECRET_g1');
276 keyring_key_length_fetch('SECRET_g1')
277 16
278 SELECT keyring_key_length_fetch('SECRET_g2');
279 keyring_key_length_fetch('SECRET_g2')
280 32
281 SELECT keyring_key_length_fetch('SECRET_g3');
282 keyring_key_length_fetch('SECRET_g3')
283 64
284 # keyring_key_remove tests
285 SELECT keyring_key_remove('SECRET_g1');
286 keyring_key_remove('SECRET_g1')
287 1
288 SELECT keyring_key_remove('SECRET_g2');
289 keyring_key_remove('SECRET_g2')
290 1
291 SELECT keyring_key_remove('SECRET_g3');
292 keyring_key_remove('SECRET_g3')
293 1
294 SELECT keyring_key_remove('SECRET_s1');
295 keyring_key_remove('SECRET_s1')
296 1
297 SELECT keyring_key_remove('SECRET_s2');
298 keyring_key_remove('SECRET_s2')
299 1
300 SELECT keyring_key_remove('SECRET_s3');
301 keyring_key_remove('SECRET_s3')
302 1
303 # ----------------------------------------------------------------------
304 # Clean-up
305 DROP FUNCTION keyring_key_store;
306 DROP FUNCTION keyring_key_fetch;
307 DROP FUNCTION keyring_key_remove;
308 DROP FUNCTION keyring_key_generate;
309 DROP FUNCTION keyring_key_type_fetch;
310 DROP FUNCTION keyring_key_length_fetch;
311 UNINSTALL PLUGIN keyring_udf;
312 # ----------------------------------------------------------------------
313 # ----------------------------------------------------------------------
314 # Teardown
315 # Removing manifest file for current MySQL server instance
316 # Removing local keyring file for keyring component: component_keyring_file
317 # Removing local configuration file for keyring component: component_keyring_file
318 # Restarting server without the manifest file
319 # ----------------------------------------------------------------------