Debian Codegraph @

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

raw
1 # X Protocol allows multiple changes of compression settings
2 # before authentication, where the last successful change
3 # is going to be used:
4 #
5 # client->server: CapSet(compression{algorightm=lz4})
6 # client<-server: Ok
7 # client->server: CapSet(compression{algorightm=delfate})
8 # client<-server: Ok
9 # client->server: CapSet(compression{algorightm=unknown})
10 # client<-server: Fail (not know algorithm)
11 # ... authentication ...
12 # ... deflate compression activated ...
13 #
14 #
15 --source include/xplugin_preamble.inc
16 --source include/xplugin_create_user.inc
17
18 ## Test starts here
19 --write_file $MYSQL_TMP_DIR/multi_capset.xpl
20 -->import assert_select.macro
21 -->import assert_messages.macro
22 -->import connection.macro
23 -->import wait_until_disconnect.macro
24
25 -->macro Assert_session_status_is %VNAME% %OP% %VAL%
26 echo # Asserting [ %VNAME% %OP% %VAL% ];
27 quiet;
28 noquery_result;
29 callmacro Assert_select0 1 SELECT VARIABLE_VALUE %OP% %VAL% FROM performance_schema.session_status WHERE VARIABLE_NAME LIKE '%VNAME%';
30 noquiet;
31 query_result;
32 -->endmacro
33
34 -->macro Set_commpresion_capabilities_2 %KEY1% %VALUE1% %KEY2% %VALUE2% %RESULT%
35 quiet;
36 noquery_result;
37 -->echo ##########################################################
38 -->echo ## Scenario: %KEY1%=%VALUE1%, %KEY2%=%VALUE2%
39
40 Mysqlx.Connection.CapabilitiesSet {
41 capabilities {
42 capabilities {
43 name: "compression"
44 value {
45 type: OBJECT
46 obj {
47 fld {
48 key: "%KEY1%"
49 value {
50 type: SCALAR
51 scalar {
52 type: V_STRING
53 v_string {
54 value: "%VALUE1%"
55 }
56 }
57 }
58 }
59 fld {
60 key: "%KEY2%"
61 value {
62 type: SCALAR
63 scalar {
64 type: V_SINT
65 v_signed_int: %VALUE2%
66 }
67 }
68 }
69 }
70 }
71 }
72 }
73 }
74 -->recvtype %RESULT%
75 noquiet;
76 query_result;
77 -->endmacro
78
79 -->macro Set_commpresion_capabilities_1 %KEY1% %VALUE1% %RESULT%
80 quiet;
81 noquery_result;
82 -->echo ##########################################################
83 -->echo ## Scenario: %KEY1%=%VALUE1%
84
85 Mysqlx.Connection.CapabilitiesSet {
86 capabilities {
87 capabilities {
88 name: "compression"
89 value {
90 type: OBJECT
91 obj {
92 fld {
93 key: "%KEY1%"
94 value {
95 type: SCALAR
96 scalar {
97 type: V_STRING
98 v_string {
99 value: "%VALUE1%"
100 }
101 }
102 }
103 }
104 }
105 }
106 }
107 }
108 }
109 -->recvtype %RESULT%
110 noquiet;
111 query_result;
112 -->endmacro
113
114
115 -->echo
116 -->echo
117 -->echo ## I. Validate multiple compression-configuration changes
118 -->echo #
119 -->echo # 1. Set first lz4, then deflate, and verify that deflate is the final algorithm that server uses
120 -->echo # 2. Set first lz4, then deflate, and verify that deflate is the final algorithm that client uses
121 -->echo # 3. Set first server_combine_mixed_msg to true, then set it to false, and verify that server places
122 -->echo # only concrete message types into the compressed message
123 -->echo # 4. Set first server_combine_limit to 10, then set it to 3, and verify that server compresses max
124 -->echo # three X messages per compression message
125 -->echo # 5. Set first server_combine_limit to 1, then set server_combine_mixed_msg to true, and verify that
126 -->echo # server uses second mixed_msg and sends single compressed message which contains whole resultset
127 -->echo
128 -->echo ## II. Verify that compression is not used before authentication
129 -->echo #
130 -->echo # 1. Enable compression, send compressed frame before authentication
131 -->echo # 2. Enable compression, check that server didn't send any compressed frames before authentication
132 -->echo
133
134
135 -->echo
136 -->echo #
137 -->echo # I.1
138 newsession s1.1 -;
139 callmacro Verify_its_xprotocol_connection;
140 callmacro Set_commpresion_capabilities_1 algorithm lz4_message Mysqlx.Ok;
141 callmacro Set_commpresion_capabilities_1 algorithm deflate_stream Mysqlx.Ok;
142 enable_compression deflate_stream;
143 login x_root;
144 # Trigger some traffic on the server, to be able to check its response
145 # if it was compressed or not.
146 SELECT 1;
147
148 callmacro Assert_session_status_is Mysqlx_bytes_sent_compressed_payload > 0;
149 callmacro Assert_session_status_is Mysqlx_bytes_received_compressed_payload = 0;
150
151
152 -->echo
153 -->echo #
154 -->echo # I.2
155 newsession s1.2 -;
156 callmacro Verify_its_xprotocol_connection;
157 callmacro Set_commpresion_capabilities_1 algorithm lz4_message Mysqlx.Ok;
158 callmacro Set_commpresion_capabilities_1 algorithm deflate_stream Mysqlx.Ok;
159 enable_compression deflate_stream;
160 login x_root;
161 -->begin_compress
162 Mysqlx.Sql.StmtExecute {
163 stmt: "SELECT 1;"
164 }
165 -->end_compress
166 recvresult;
167 #callmacro Assert_session_status_is Mysqlx_bytes_sent_compressed_payload = 0;
168 callmacro Assert_session_status_is Mysqlx_bytes_received_compressed_payload > 0;
169
170
171 -->echo
172 -->echo #
173 -->echo # I.3
174 newsession s1.3 -;
175 callmacro Verify_its_xprotocol_connection;
176 callmacro Set_commpresion_capabilities_2 algorithm lz4_message server_combine_mixed_messages 1 Mysqlx.Ok;
177 callmacro Set_commpresion_capabilities_2 algorithm lz4_message server_combine_mixed_messages 0 Mysqlx.Ok;
178 enable_compression lz4_message;
179 login x_root;
180 stmtsql SELECT 1,2,3;
181 # ColumnMetdata * 3
182 callmacro Assert_frame COMPRESSION;
183 # Row * 1
184 callmacro Assert_frame COMPRESSION;
185 # Notice * 2
186 callmacro Assert_frame COMPRESSION;
187 # FetchDone
188 callmacro Assert_frame COMPRESSION;
189 callmacro Assert_message Mysqlx.Sql.StmtExecuteOk;
190 callmacro Assert_session_status_is Mysqlx_bytes_sent_compressed_payload > 0;
191 callmacro Assert_session_status_is Mysqlx_bytes_received_compressed_payload = 0;
192 -->begin_compress
193 Mysqlx.Sql.StmtExecute {
194 stmt: "SELECT 1;"
195 }
196 -->end_compress
197 recvresult;
198
199
200 -->echo
201 -->echo #
202 -->echo # I.4
203 newsession s1.4 -;
204 callmacro Verify_its_xprotocol_connection;
205 callmacro Set_commpresion_capabilities_2 algorithm lz4_message server_max_combine_messages 10 Mysqlx.Ok;
206 callmacro Set_commpresion_capabilities_2 algorithm lz4_message server_max_combine_messages 3 Mysqlx.Ok;
207 enable_compression lz4_message;
208 login x_root;
209 stmtsql SELECT 1,2,3;
210 # ColumnMetdata * 3
211 callmacro Assert_frame COMPRESSION;
212 # Row * 1, FetchDone * 1, Notice * 1
213 callmacro Assert_frame COMPRESSION;
214 callmacro Assert_message Mysqlx.Sql.StmtExecuteOk;
215
216 -->begin_compress
217 Mysqlx.Sql.StmtExecute {
218 stmt: "SELECT 1;"
219 }
220 -->end_compress
221 recvresult;
222 callmacro Assert_session_status_is Mysqlx_bytes_received_compressed_payload > 0;
223 #callmacro Assert_session_status_is Mysqlx_bytes_sent_compressed_payload = 0;
224
225
226 -->echo
227 -->echo #
228 -->echo # I.5
229 newsession s1.5 -;
230 callmacro Verify_its_xprotocol_connection;
231 callmacro Set_commpresion_capabilities_2 algorithm lz4_message server_max_combine_messages 1 Mysqlx.Ok;
232 callmacro Set_commpresion_capabilities_2 algorithm lz4_message server_combine_mixed_messages 1 Mysqlx.Ok;
233 enable_compression lz4_message;
234 login x_root;
235 stmtsql SELECT 1,2,3;
236 # ColumnMetdata * 3, Row * 1, Notices * 2, FetchDone *1
237 callmacro Assert_frame COMPRESSION;
238 callmacro Assert_message Mysqlx.Sql.StmtExecuteOk;
239
240 -->begin_compress
241 Mysqlx.Sql.StmtExecute {
242 stmt: "SELECT 1;"
243 }
244 -->end_compress
245 recvresult;
246 callmacro Assert_session_status_is Mysqlx_bytes_received_compressed_payload > 0;
247 #callmacro Assert_session_status_is Mysqlx_bytes_sent_compressed_payload = 0;
248
249
250 -->echo
251 -->echo #
252 -->echo # II.1
253 newsession s2.1 -;
254 callmacro Verify_its_xprotocol_connection;
255 callmacro Set_commpresion_capabilities_1 algorithm lz4_message Mysqlx.Ok;
256 enable_compression lz4_message;
257 -->begin_compress
258 Mysqlx.Connection.CapabilitiesGet {
259 }
260 -->end_compress
261 recverror ER_X_FRAME_COMPRESSION_DISABLED;
262 callmacro Wait_until_disconnect;
263
264
265 -->echo
266 -->echo #
267 -->echo # II.2
268 newsession s2.2 -;
269 callmacro Verify_its_xprotocol_connection;
270 callmacro Set_commpresion_capabilities_1 algorithm lz4_message Mysqlx.Ok;
271 enable_compression lz4_message;
272 login x_root;
273 callmacro Assert_session_status_is Mysqlx_bytes_sent_compressed_payload = 0;
274 callmacro Assert_session_status_is Mysqlx_bytes_received_compressed_payload = 0;
275
276 EOF
277
278 exec $MYSQLXTEST
279 -ux_root --password=''
280 --file=$MYSQL_TMP_DIR/multi_capset.xpl 2>&1;
281
282
283 ## Cleanup
284 --source ../include/xplugin_cleanup.inc