Debian Codegraph @

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

raw
1 ## XPLUGIN: Following test verifies compression-mode used by
2 ## both mysqlxclient and mysqlxtest.
3
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_ssl_warnings_suppression.inc
6 --source include/xplugin_create_user.inc
7
8
9 --write_file $MYSQL_TMP_DIR/compression-none.xpl
10 -->import assert_status_variable.macro
11 SELECT "Send some data which might trigger server side compression" as Column1;
12 -->expecterror 2512
13 -->begin_compress
14 Mysqlx.Sql.StmtExecute{
15 stmt:"SELECT \"some string value\" as column1"
16 }
17 -->end_compress
18
19 -->expecterror 2512
20 -->begin_compress
21 Mysqlx.Sql.StmtExecute{
22 stmt:"SELECT \"some string value\" as column1"
23 }
24 -->end_compress
25
26 -->expecterror 2512
27 -->begin_compress
28 Mysqlx.Sql.StmtExecute{
29 stmt:"SELECT \"some string value\" as column1"
30 }
31 -->end_compress
32
33 callmacro Assert_client_message_count Mysqlx.Connection.Compression == 0;
34
35 EOF
36
37
38 --write_file $MYSQL_TMP_DIR/compression-both.xpl
39 -->import assert_status_variable.macro
40 SELECT "Send some data which might trigger server side compression" as Column1;
41 -->begin_compress
42 Mysqlx.Sql.StmtExecute{
43 stmt:"SELECT \"some string value\" as column1"
44 }
45 -->end_compress
46 recvresult;
47
48 callmacro Assert_client_message_count Mysqlx.Connection.Compression > 0;
49
50 EOF
51
52 --echo
53 --echo ############################################################
54 --echo ## Test verifies "--compression-mode" command line option:
55 --echo #
56 --echo # 1. Try to use any compression when server has enabled all algorithms
57 --echo # a. use "DISABLED" compression mode and verify that neither
58 --echo # client nor server uses it
59 --echo # b. use "REQUIRED" compression mode and verify that client and
60 --echo # server uses compression
61 --echo # c. use "PREFERRED" compression mode and verify that client and
62 --echo # server uses compression
63 --echo # 2. Try to use any algorithm with, still server has disabled all algorithms
64 --echo # a. use "DISABLED" compression mode and verify that neither
65 --echo # client nor server uses it
66 --echo # b. use "REQUIRED" compression mode and verify that client can't
67 --echo # connect to the server
68 --echo # c. use "PREFERRED" compression mode and verify that client may
69 --echo # connect to the server, still can't use selected style
70 --echo # 3. Try to use any algorithm when server has only "lz4" enabled
71 --echo # a. use "DISABLED" compression mode and verify that neither
72 --echo # client nor server uses it
73 --echo # b. use "REQUIRED" compression mode and verify that client and
74 --echo # server uses compression
75 --echo # c. use "PREFERRED" compression mode and verify that client and
76 --echo # server uses compression
77 --echo # 4. Try to use any algorithm when server has only "deflate" enabled
78 --echo # a. use "DISABLED" compression mode and verify that neither
79 --echo # client nor server uses it
80 --echo # b. use "REQUIRED" compression mode and verify that client and
81 --echo # server uses compression
82 --echo # c. use "PREFERRED" compression mode and verify that client and
83 --echo # server uses compression
84 --echo # 5. Try to use any algorithm when server has only "zstd" enabled
85 --echo # a. use "DISABLED" compression mode and verify that neither
86 --echo # client nor server uses it
87 --echo # b. use "REQUIRED" compression mode and verify that client and
88 --echo # server uses compression
89 --echo # c. use "PREFERRED" compression mode and verify that client and
90 --echo # server uses compression
91 --echo # 6. Try to use "deflate" algorithm when server has only "lz4" enabled
92 --echo # a. use "DISABLED" compression mode and verify that neither
93 --echo # client nor server uses it
94 --echo # b. use "REQUIRED" compression mode and verify that client can't
95 --echo # connect to the server
96 --echo # c. use "PREFERRED" compression mode and verify that client may
97 --echo # connect to the server, still can't use selected style
98 --echo # 7. Try to use "lz4" algorithm when server has only "deflate" enabled
99 --echo # a. use "DISABLED" compression mode and verify that neither
100 --echo # client nor server uses it
101 --echo # b. use "REQUIRED" compression mode and verify that client can't
102 --echo # connect to the server
103 --echo # c. use "PREFERRED" compression mode and verify that client may
104 --echo # connect to the server, still can't use selected style
105 --echo # 8. Try to use "lz4" algorithm when server has only "zstd" enabled
106 --echo # a. use "DISABLED" compression mode and verify that neither
107 --echo # client nor server uses it
108 --echo # b. use "REQUIRED" compression mode and verify that client can't
109 --echo # connect to the server
110 --echo # c. use "PREFERRED" compression mode and verify that client may
111 --echo # connect to the server, still can't use selected style
112 --echo # 9. Try to use "lz4" algorithm when server has only "lz4" enabled
113 --echo # a. use "DISABLED" compression mode and verify that neither
114 --echo # client nor server uses it
115 --echo # b. use "REQUIRED" compression mode and verify that client and
116 --echo # server uses compression
117 --echo # c. use "PREFERRED" compression mode and verify that client and
118 --echo # server uses compression
119 --echo # 10. Try to use "deflate" algorithm when server has only "deflate" enabled
120 --echo # a. use "DISABLED" compression mode and verify that neither
121 --echo # client nor server uses it
122 --echo # b. use "REQUIRED" compression mode and verify that client and
123 --echo # server uses compression
124 --echo # c. use "PREFERRED" compression mode and verify that client and
125 --echo # server uses compression
126 --echo # 11. Try to use "zstd" algorithm when server has only "zstd" enabled
127 --echo # a. use "DISABLED" compression mode and verify that neither
128 --echo # client nor server uses it
129 --echo # b. use "REQUIRED" compression mode and verify that client and
130 --echo # server uses compression
131 --echo # c. use "PREFERRED" compression mode and verify that client and
132 --echo # server uses compression
133
134
135 --echo
136 --echo # 1.a
137 --echo #
138 exec $MYSQLXTEST
139 --user=x_root
140 --host=127.0.0.1
141 --schema=test
142 --ssl-mode=REQUIRED
143 --compression-mode=DISABLED
144 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
145
146
147 --echo
148 --echo # 1.b
149 --echo #
150 exec $MYSQLXTEST
151 --user=x_root
152 --host=127.0.0.1
153 --schema=test
154 --ssl-mode=REQUIRED
155 --compression-mode=REQUIRED
156 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
157
158
159 --echo
160 --echo # 1.c
161 --echo #
162 exec $MYSQLXTEST
163 --user=x_root
164 --host=127.0.0.1
165 --schema=test
166 --ssl-mode=REQUIRED
167 --compression-mode=PREFERRED
168 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
169
170
171 --echo
172 --echo # 2.a
173 --echo #
174 SET GLOBAL mysqlx_compression_algorithms="";
175
176 exec $MYSQLXTEST
177 --user=x_root
178 --host=127.0.0.1
179 --schema=test
180 --ssl-mode=REQUIRED
181 --compression-mode=DISABLED
182 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
183
184
185 --echo
186 --echo # 2.b
187 --echo #
188 #
189 # Following option marks that mysqlxtest wont be able to
190 # establish connection, the option "--file" may give an
191 # wrong suggestion that the file will be executed:
192 #
193 # --expect-error=2513
194 #
195 exec $MYSQLXTEST
196 --expect-error=2513
197 --user=x_root
198 --host=127.0.0.1
199 --schema=test
200 --ssl-mode=REQUIRED
201 --compression-mode=REQUIRED
202 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
203
204
205 --echo
206 --echo # 2.c
207 --echo #
208 exec $MYSQLXTEST
209 --user=x_root
210 --host=127.0.0.1
211 --schema=test
212 --ssl-mode=REQUIRED
213 --compression-mode=PREFERRED
214 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
215
216
217 --echo
218 --echo # 3.a
219 --echo #
220 SET GLOBAL mysqlx_compression_algorithms="LZ4_MESSAGE";
221
222 exec $MYSQLXTEST
223 --user=x_root
224 --host=127.0.0.1
225 --schema=test
226 --ssl-mode=REQUIRED
227 --compression-mode=DISABLED
228 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
229
230
231 --echo
232 --echo # 3.b
233 --echo #
234 exec $MYSQLXTEST
235 --user=x_root
236 --host=127.0.0.1
237 --schema=test
238 --ssl-mode=REQUIRED
239 --compression-mode=REQUIRED
240 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
241
242
243 --echo
244 --echo # 3.c
245 --echo #
246 exec $MYSQLXTEST
247 --user=x_root
248 --host=127.0.0.1
249 --schema=test
250 --ssl-mode=REQUIRED
251 --compression-mode=PREFERRED
252 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
253
254
255 --echo
256 --echo # 4.a
257 --echo #
258 SET GLOBAL mysqlx_compression_algorithms="DEFLATE_STREAM";
259
260 exec $MYSQLXTEST
261 --user=x_root
262 --host=127.0.0.1
263 --schema=test
264 --ssl-mode=REQUIRED
265 --compression-mode=DISABLED
266 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
267
268
269 --echo
270 --echo # 4.b
271 --echo #
272 exec $MYSQLXTEST
273 --user=x_root
274 --host=127.0.0.1
275 --schema=test
276 --ssl-mode=REQUIRED
277 --compression-mode=REQUIRED
278 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
279
280
281 --echo
282 --echo # 4.c
283 --echo #
284 exec $MYSQLXTEST
285 --user=x_root
286 --host=127.0.0.1
287 --schema=test
288 --ssl-mode=REQUIRED
289 --compression-mode=PREFERRED
290 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
291
292
293 --echo
294 --echo # 5.a
295 --echo #
296 SET GLOBAL mysqlx_compression_algorithms="ZSTD_STREAM";
297
298 exec $MYSQLXTEST
299 --user=x_root
300 --host=127.0.0.1
301 --schema=test
302 --ssl-mode=REQUIRED
303 --compression-mode=DISABLED
304 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
305
306
307 --echo
308 --echo # 5.b
309 --echo #
310 exec $MYSQLXTEST
311 --user=x_root
312 --host=127.0.0.1
313 --schema=test
314 --ssl-mode=REQUIRED
315 --compression-mode=REQUIRED
316 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
317
318
319 --echo
320 --echo # 5.c
321 --echo #
322 exec $MYSQLXTEST
323 --user=x_root
324 --host=127.0.0.1
325 --schema=test
326 --ssl-mode=REQUIRED
327 --compression-mode=PREFERRED
328 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
329
330 --echo
331 --echo # 6.a
332 --echo #
333 SET GLOBAL mysqlx_compression_algorithms="LZ4_MESSAGE";
334
335 exec $MYSQLXTEST
336 --user=x_root
337 --host=127.0.0.1
338 --schema=test
339 --ssl-mode=REQUIRED
340 --compression-mode=DISABLED
341 --compression-algorithm=deflate_stream
342 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
343
344
345 --echo
346 --echo # 6.b
347 --echo #
348 exec $MYSQLXTEST
349 --expect-error=2513
350 --user=x_root
351 --host=127.0.0.1
352 --schema=test
353 --ssl-mode=REQUIRED
354 --compression-mode=REQUIRED
355 --compression-algorithm=deflate_stream
356 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
357
358
359 --echo
360 --echo # 6.c
361 --echo #
362 exec $MYSQLXTEST
363 --user=x_root
364 --host=127.0.0.1
365 --schema=test
366 --ssl-mode=REQUIRED
367 --compression-mode=PREFERRED
368 --compression-algorithm=deflate_stream
369 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
370
371
372 --echo
373 --echo # 7.a
374 --echo #
375 SET GLOBAL mysqlx_compression_algorithms="DEFLATE_STREAM";
376
377 exec $MYSQLXTEST
378 --user=x_root
379 --host=127.0.0.1
380 --schema=test
381 --ssl-mode=REQUIRED
382 --compression-mode=DISABLED
383 --compression-algorithm=lz4_message
384 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
385
386
387 --echo
388 --echo # 7.b
389 --echo #
390 exec $MYSQLXTEST
391 --expect-error=2513
392 --user=x_root
393 --host=127.0.0.1
394 --schema=test
395 --ssl-mode=REQUIRED
396 --compression-mode=REQUIRED
397 --compression-algorithm=lz4_message
398 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
399
400
401 --echo
402 --echo # 7.c
403 --echo #
404 exec $MYSQLXTEST
405 --user=x_root
406 --host=127.0.0.1
407 --schema=test
408 --ssl-mode=REQUIRED
409 --compression-mode=PREFERRED
410 --compression-algorithm=lz4_message
411 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
412
413
414 --echo
415 --echo # 8.a
416 --echo #
417 SET GLOBAL mysqlx_compression_algorithms="ZSTD_STREAM";
418
419 exec $MYSQLXTEST
420 --user=x_root
421 --host=127.0.0.1
422 --schema=test
423 --ssl-mode=REQUIRED
424 --compression-mode=DISABLED
425 --compression-algorithm=lz4_message
426 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
427
428
429 --echo
430 --echo # 8.b
431 --echo #
432 exec $MYSQLXTEST
433 --expect-error=2513
434 --user=x_root
435 --host=127.0.0.1
436 --schema=test
437 --ssl-mode=REQUIRED
438 --compression-mode=REQUIRED
439 --compression-algorithm=lz4_message
440 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
441
442
443 --echo
444 --echo # 8.c
445 --echo #
446 exec $MYSQLXTEST
447 --user=x_root
448 --host=127.0.0.1
449 --schema=test
450 --ssl-mode=REQUIRED
451 --compression-mode=PREFERRED
452 --compression-algorithm=lz4_message
453 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
454
455
456 --echo
457 --echo # 9.a
458 --echo #
459 SET GLOBAL mysqlx_compression_algorithms="LZ4_MESSAGE";
460
461 exec $MYSQLXTEST
462 --user=x_root
463 --host=127.0.0.1
464 --schema=test
465 --ssl-mode=REQUIRED
466 --compression-mode=DISABLED
467 --compression-algorithm=lz4_message
468 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
469
470
471 --echo
472 --echo # 9.b
473 --echo #
474 exec $MYSQLXTEST
475 --user=x_root
476 --host=127.0.0.1
477 --schema=test
478 --ssl-mode=REQUIRED
479 --compression-mode=REQUIRED
480 --compression-algorithm=lz4_message
481 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
482
483
484 --echo
485 --echo # 9.c
486 --echo #
487 exec $MYSQLXTEST
488 --user=x_root
489 --host=127.0.0.1
490 --schema=test
491 --ssl-mode=REQUIRED
492 --compression-mode=PREFERRED
493 --compression-algorithm=lz4_message
494 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
495
496
497 --echo
498 --echo # 10.a
499 --echo #
500 SET GLOBAL mysqlx_compression_algorithms="LZ4_MESSAGE";
501
502 exec $MYSQLXTEST
503 --user=x_root
504 --host=127.0.0.1
505 --schema=test
506 --ssl-mode=REQUIRED
507 --compression-mode=DISABLED
508 --compression-algorithm=lz4_message
509 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
510
511
512 --echo
513 --echo # 7.b
514 --echo #
515 exec $MYSQLXTEST
516 --user=x_root
517 --host=127.0.0.1
518 --schema=test
519 --ssl-mode=REQUIRED
520 --compression-mode=REQUIRED
521 --compression-algorithm=lz4_message
522 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
523
524
525 --echo
526 --echo # 7.c
527 --echo #
528 exec $MYSQLXTEST
529 --user=x_root
530 --host=127.0.0.1
531 --schema=test
532 --ssl-mode=REQUIRED
533 --compression-mode=PREFERRED
534 --compression-algorithm=lz4_message
535 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
536
537
538 --echo
539 --echo # 8.a
540 --echo #
541 SET GLOBAL mysqlx_compression_algorithms="DEFLATE_STREAM";
542
543 exec $MYSQLXTEST
544 --user=x_root
545 --host=127.0.0.1
546 --schema=test
547 --ssl-mode=REQUIRED
548 --compression-mode=DISABLED
549 --compression-algorithm=deflate_stream
550 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
551
552
553 --echo
554 --echo # 10.b
555 --echo #
556 exec $MYSQLXTEST
557 --user=x_root
558 --host=127.0.0.1
559 --schema=test
560 --ssl-mode=REQUIRED
561 --compression-mode=REQUIRED
562 --compression-algorithm=deflate_stream
563 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
564
565
566 --echo
567 --echo # 10.c
568 --echo #
569 exec $MYSQLXTEST
570 --user=x_root
571 --host=127.0.0.1
572 --schema=test
573 --ssl-mode=REQUIRED
574 --compression-mode=PREFERRED
575 --compression-algorithm=deflate_stream
576 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
577
578
579 --echo
580 --echo # 11.a
581 --echo #
582 SET GLOBAL mysqlx_compression_algorithms="ZSTD_STREAM";
583
584 exec $MYSQLXTEST
585 --user=x_root
586 --host=127.0.0.1
587 --schema=test
588 --ssl-mode=REQUIRED
589 --compression-mode=DISABLED
590 --compression-algorithm=zstd_stream
591 --file=$MYSQL_TMP_DIR/compression-none.xpl 2>&1;
592
593
594 --echo
595 --echo # 11.b
596 --echo #
597 exec $MYSQLXTEST
598 --user=x_root
599 --host=127.0.0.1
600 --schema=test
601 --ssl-mode=REQUIRED
602 --compression-mode=REQUIRED
603 --compression-algorithm=zstd_stream
604 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
605
606
607 --echo
608 --echo # 11.c
609 --echo #
610 exec $MYSQLXTEST
611 --user=x_root
612 --host=127.0.0.1
613 --schema=test
614 --ssl-mode=REQUIRED
615 --compression-mode=PREFERRED
616 --compression-algorithm=zstd_stream
617 --file=$MYSQL_TMP_DIR/compression-both.xpl 2>&1;
618
619
620
621 ## Cleanup
622 SET GLOBAL mysqlx_compression_algorithms=DEFAULT;
623 --source ../include/xplugin_cleanup.inc