Debian Codegraph @

mysql-test/suite/x/r/mysqlxtest_mode_compression.result

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