Debian Codegraph @

mysql-test/suite/x/t/session_connect_attributes.test

raw
1 ## Test of general functionality of session_connect_attrs capability
2
3 ## Preamble
4 --source ../include/have_performance_schema_statements.inc
5 --source include/xplugin_preamble.inc
6 --source include/xplugin_create_user.inc
7 ## Test starts here
8
9 CREATE USER xtest_client1@localhost;
10 CREATE USER xtest_client2@localhost;
11 GRANT ALL ON *.* TO xtest_client1@localhost;
12 GRANT ALL ON *.* TO xtest_client2@localhost;
13
14 --write_file $MYSQL_TMP_DIR/session_connect_attrs.xpl
15 -->varlet %TEST_KEY% custom_test_key
16 -->import connection_attributes.macro
17 -->import connection.macro
18 -->import assert_status_variable.macro
19
20 -->echo
21 -->echo
22 -->echo ## I. Check valid uses of the session_connect_attrs capability only.
23 -->echo #
24 -->echo # 1. Set the session_connect_attrs capability once and verify it in the PFS.
25 -->echo # 2. Set the session_connect_attrs capability with some duplicated conneection attribute keys and verify that the duplicated keys are present in the PFS.
26 -->echo # 3. Set the session_connect_attrs capability twice and verify that only the last set is present in the PFS.
27 -->echo # 4. Set the session_connect_attrs capability with two distinct attributes and verify if they are in the PFS.
28 -->echo
29 -->echo ## II. Check session_connect_attrs capability with invalid contents.
30 -->echo #
31 -->echo # 1. Assert that session_connect_attrs which contains value with length exceeding 1024 character limit triggers an error.
32 -->echo # a. Send just the invalid capability.
33 -->echo # b. Send the invalid capability followed by a valid one.
34 -->echo # 2. Assert that session_connect_attrs which contains key with length exceeding 32 character limit triggers an error.
35 -->echo # a. Send just the invalid capability.
36 -->echo # b. Send the invalid capability followed by a valid one.
37 -->echo # 3. Assert that session_connect_attrs which contains an empty key triggers an error.
38 -->echo # a. Send just the invalid capability.
39 -->echo # b. Send the invalid capability followed by a valid one.
40 -->echo # 4. Assert that session_connect_attrs which contains both key and value with lengths exceeding their limits triggers an error.
41 -->echo # a. Send just the invalid capability.
42 -->echo # b. Send the invalid capability followed by a valid one.
43 -->echo # 5. Assert that session_connect_attrs which contains a message that after decoding exceeds 64k size limit triggers an error.
44 -->echo # a. Send just the invalid capability.
45 -->echo # b. Send the invalid capability followed by a valid one.
46 -->echo
47 -->echo ## III. Check session_connect_attrs capability when used with other capabilities.
48 -->echo #
49 -->echo # 1. Set the session_connect_attrs capability and other valid capability.
50 -->echo # 2. Set the session_connect_attrs capability and other capability, one of which is invalid. Verify that none of the capabilities are not set in the PFS.
51 -->echo # a. The session_connect_attrs capability is invalid.
52 -->echo # b. The additional capability is invalid.
53 -->echo
54 -->echo ## IV. Check session connect attributes after client disconnects.
55 -->echo #
56 -->echo # 1. Verify that new client cannot see the session connection attibutes of a previously disconnected client.
57 -->echo # 2. Verify that new client can see the session connection attibutes of another connected client.
58 -->echo
59 -->echo ## V. Check that it is not possible to send session connection attributes after the authentication.
60 -->echo
61 -->echo ## VI. Check that malformed session connection attributes capability triggers an error.
62
63
64 -->echo
65 -->echo #
66 -->echo # I.1
67 -->newsession test_session.I.1 -
68 -->callmacro Verify_its_xprotocol_connection
69 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "someOS"
70 -->recvok
71 -->callmacro Check_connect_attributes_and_close_session "%TEST_KEY%" "someOS"
72
73 -->echo
74 -->echo #
75 -->echo # I.2
76 -->newsession test_session.I.2 -
77 -->callmacro Verify_its_xprotocol_connection
78 -->callmacro Send_session_connect_attrs_2 "%TEST_KEY%" "someOS" "%TEST_KEY%" "otherOS"
79 -->recvok
80 -->login x_root
81 -->callmacro Check_connect_attributes "%TEST_KEY%" "someOS"
82 -->callmacro Check_connect_attributes "%TEST_KEY%" "otherOS"
83 -->closesession
84
85 -->echo
86 -->echo #
87 -->echo # I.3
88 -->newsession test_session.I.3 -
89 -->callmacro Verify_its_xprotocol_connection
90 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "not_shownOS"
91 -->recvok
92 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "shownOS"
93 -->recvok
94 -->callmacro Check_connect_attributes_and_close_session "%TEST_KEY%" "shownOS"
95
96 -->echo
97 -->echo #
98 -->echo # I.4
99 -->newsession test_session.I.4 -
100 -->callmacro Verify_its_xprotocol_connection
101 -->varlet %KEY1% test_key1
102 -->varlet %KEY2% test_key2
103 -->callmacro Send_session_connect_attrs_2 "%KEY1%" "value1" "%KEY2%" "value2"
104 -->recvok
105 -->login x_root
106 -->callmacro Check_connect_attributes "%KEY1%" "value1"
107 -->callmacro Check_connect_attributes "%KEY2%" "value2"
108 -->closesession
109
110 -->echo
111 -->echo #
112 -->echo # II.1.a
113 -->newsession test_session.II.1.a -
114 -->callmacro Verify_its_xprotocol_connection
115 -->vargen %INVALID_VALUE% x 1025
116 -->callmacro Send_session_connect_attrs_2 "%TEST_KEY%" "%INVALID_VALUE%" "%TEST_KEY%" "valid_value"
117 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_VALUE_LENGTH
118 -->callmacro Assert_no_attribute_inserted %TEST_KEY%
119 -->closesession
120
121 -->echo
122 -->echo #
123 -->echo # II.1.b
124 -->newsession test_session.II.1.b -
125 -->callmacro Verify_its_xprotocol_connection
126 -->vargen %INVALID_VALUE% x 1025
127 -->callmacro Send_session_connect_attrs_2 "%TEST_KEY%" "%INVALID_VALUE%" "%TEST_KEY%" "valid_value"
128 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_VALUE_LENGTH
129 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "valid_value"
130 -->recvok
131 -->login x_root
132 -->callmacro Check_connect_attributes "%TEST_KEY%" "valid_value"
133 -->closesession
134
135 -->echo
136 -->echo #
137 -->echo # II.2.a
138 -->newsession test_session.II.2.a -
139 -->callmacro Verify_its_xprotocol_connection
140 -->vargen %INVALID_KEY% x 33
141 -->callmacro Send_session_connect_attrs_2 "%INVALID_KEY%" "valid_value" "%TEST_KEY%" "valid_value"
142 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_KEY_LENGTH
143 -->callmacro Assert_no_attribute_inserted %TEST_KEY%
144 -->closesession
145
146 -->echo
147 -->echo #
148 -->echo # II.2.b
149 -->newsession test_session.II.2.b -
150 -->callmacro Verify_its_xprotocol_connection
151 -->vargen %INVALID_KEY% x 33
152 -->callmacro Send_session_connect_attrs_2 "%INVALID_KEY%" "valid_value" "%TEST_KEY%" "valid_value"
153 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_KEY_LENGTH
154 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "valid_value"
155 -->recvok
156 -->login x_root
157 -->callmacro Check_connect_attributes "%TEST_KEY%" "valid_value"
158 -->closesession
159
160 -->echo
161 -->echo #
162 -->echo # II.3.a
163 -->newsession test_session.II.3.a -
164 -->callmacro Verify_its_xprotocol_connection
165 -->callmacro Send_session_connect_attrs_2 "%TEST_KEY%" "valid_value" "" "valid_value"
166 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_EMPTY_KEY
167 -->callmacro Assert_no_attribute_inserted %TEST_KEY%
168 -->closesession
169
170 -->echo
171 -->echo #
172 -->echo # II.3.b
173 -->newsession test_session.II.3.b -
174 -->callmacro Verify_its_xprotocol_connection
175 -->callmacro Send_session_connect_attrs_2 "%TEST_KEY%" "valid_value" "" "valid_value"
176 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_EMPTY_KEY
177 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "valid_value"
178 -->recvok
179 -->login x_root
180 -->callmacro Check_connect_attributes "%TEST_KEY%" "valid_value"
181 -->closesession
182
183 -->echo
184 -->echo #
185 -->echo # II.4.a
186 -->newsession test_session.II.4.a -
187 -->callmacro Verify_its_xprotocol_connection
188 -->vargen %INVALID_KEY% x 33
189 -->vargen %INVALID_VALUE% x 1025
190 -->callmacro Send_session_connect_attrs_2 "%TEST_KEY%" "valid_value" "%INVALID_KEY%" "%INVALID_VALUE%"
191 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_KEY_LENGTH
192 -->callmacro Assert_no_attribute_inserted %TEST_KEY%
193 -->closesession
194
195 -->echo
196 -->echo #
197 -->echo # II.4.b
198 -->newsession test_session.II.4.b -
199 -->callmacro Verify_its_xprotocol_connection
200 -->vargen %INVALID_KEY% x 33
201 -->vargen %INVALID_VALUE% x 1025
202 -->callmacro Send_session_connect_attrs_2 "%TEST_KEY%" "valid_value" "%INVALID_KEY%" "%INVALID_VALUE%"
203 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_KEY_LENGTH
204 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "valid_value"
205 -->recvok
206 -->login x_root
207 -->callmacro Check_connect_attributes "%TEST_KEY%" "valid_value"
208 -->closesession
209
210 -->echo
211 -->echo #
212 -->echo # II.5.a
213 -->newsession test_session.II.5.a -
214 -->callmacro Verify_its_xprotocol_connection
215 -->callmacro Send_connect_capability_with_too_long_payload
216 -->callmacro Assert_no_attribute_inserted %TEST_KEY%
217 -->closesession
218
219 -->echo
220 -->echo #
221 -->echo # II.5.b
222 -->newsession test_session.II.5.b -
223 -->callmacro Verify_its_xprotocol_connection
224 -->callmacro Send_connect_capability_with_too_long_payload
225 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "valid_value"
226 -->recvok
227 -->login x_root
228 -->callmacro Check_connect_attributes "%TEST_KEY%" "valid_value"
229 -->closesession
230
231 -->echo
232 -->echo #
233 -->echo # III.1
234 -->newsession test_session.III.1 -
235 -->callmacro Verify_its_xprotocol_connection
236 -->varlet %SCALAR1% type: V_STRING v_string { value: "valid_value" }
237 -->varlet %SCALAR2% type: V_BOOL v_bool: 1
238 -->callmacro Send_two_different_capabilities %SCALAR1% %SCALAR2%
239 -->recvok
240 -->callmacro Check_connect_attributes_and_close_session "%TEST_KEY%" "valid_value"
241
242 -->echo
243 -->echo #
244 -->echo # III.2.a
245 -->newsession test_session.III.2.a -
246 -->callmacro Verify_its_xprotocol_connection
247 -->vargen %INVALID_VALUE% x 1025
248 -->varlet %SCALAR1% type: V_STRING v_string { value: "%INVALID_VALUE%" }
249 -->varlet %SCALAR2% type: V_BOOL v_bool: 1
250 -->callmacro Send_two_different_capabilities %SCALAR1% %SCALAR2%
251 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_VALUE_LENGTH
252 -->callmacro Assert_no_attribute_inserted %TEST_KEY%
253 -->closesession
254
255 -->echo
256 -->echo #
257 -->echo # III.2.b
258 -->newsession test_session.III.2.b -
259 -->callmacro Verify_its_xprotocol_connection
260 -->varlet %SCALAR1% type: V_STRING v_string { value: "value" }
261 -->varlet %SCALAR2% type: V_NULL
262 -->callmacro Send_two_different_capabilities %SCALAR1% %SCALAR2%
263 -->recverror ER_X_CAPABILITIES_PREPARE_FAILED
264 -->callmacro Assert_no_attribute_inserted %TEST_KEY%
265 -->closesession
266
267 -->echo
268 -->echo #
269 -->echo # IV.1
270 -->newsession test_session.IV.1_xtest_client_1 -
271 -->callmacro Verify_its_xprotocol_connection
272 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "client1OS"
273 -->recvok
274 -->login xtest_client1
275 -->callmacro Check_connect_attributes "%TEST_KEY%" "client1OS"
276 -->closesession
277 -->newsession test_session.IV.1_xtest_client_2 -
278 -->callmacro Verify_its_xprotocol_connection
279 -->login xtest_client2
280
281 -->callmacro Wait_for_global_status_variable Mysqlx_sessions 2
282 -->quiet
283
284 -->stmtsql SELECT COUNT(ATTR_VALUE) FROM performance_schema.session_connect_attrs WHERE ATTR_NAME="%TEST_KEY%";
285 -->recvtovar %COUNT%
286 -->echo [Assert that no session connect attributes were inserted]
287 -->assert_eq %COUNT% 0
288 -->closesession
289
290 -->echo
291 -->echo #
292 -->echo # IV.2
293 -->newsession test_session.IV.2_xtest_client_1 -
294 -->callmacro Verify_its_xprotocol_connection
295 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "client_1_OS"
296 -->recvok
297 -->login xtest_client1
298 -->callmacro Check_connect_attributes "%TEST_KEY%" "client_1_OS"
299 -->newsession test_session.IV.2_xtest_client_2 -
300 -->callmacro Verify_its_xprotocol_connection
301 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "client_2_OS"
302 -->recvok
303 -->login xtest_client2
304 -->callmacro Check_connect_attributes "%TEST_KEY%" "client_1_OS"
305 -->callmacro Check_connect_attributes "%TEST_KEY%" "client_2_OS"
306 -->closesession
307
308 -->echo
309 -->echo #
310 -->echo # V
311 -->newsession test_session.V_xtest_client_1 -
312 -->callmacro Verify_its_xprotocol_connection
313 -->login xtest_client1
314 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "client_2_OS"
315 -->recverror 1047
316 -->closesession
317
318 -->echo
319 -->echo #
320 -->echo # VI
321 -->newsession test_session.VI_xtest_client_1 -
322 -->callmacro Verify_its_xprotocol_connection
323 Mysqlx.Connection.CapabilitiesSet {
324 capabilities {
325 capabilities {
326 name: "session_connect_attrs"
327 value {
328 type: OBJECT
329 obj {
330 fld {
331 key: "some_key"
332 value {
333 type: SCALAR
334 scalar {
335 type: V_BOOL
336 v_bool: true
337 }
338 }
339 }
340 }
341 }
342 }
343 }
344 }
345 -->recverror ER_X_BAD_CONNECTION_SESSION_ATTRIBUTE_TYPE
346 -->callmacro Send_session_connect_attrs_1 "%TEST_KEY%" "valid_value"
347 -->recvok
348 -->login x_root
349 -->callmacro Check_connect_attributes "%TEST_KEY%" "valid_value"
350 -->closesession
351
352 EOF
353
354 exec $MYSQLXTEST
355 -ux_root --password=''
356 --file=$MYSQL_TMP_DIR/session_connect_attrs.xpl 2>&1;
357
358 ## Cleanup
359 DROP USER xtest_client1@localhost;
360 DROP USER xtest_client2@localhost;
361 --source ../include/xplugin_cleanup.inc