Debian Codegraph @

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

raw
1 CREATE TABLE test_table(data TEXT);
2 INSERT INTO test_table(data) VALUES
3 ("my first row"),
4 ("my second row"),
5 ("my third row"),
6 ("my fourth row"),
7 ("my fifth row"),
8 ("my sixth row"),
9 ("my seventh row"),
10 ("my eighth row"),
11 ("my ninth row"),
12 ( "my tenth row");
13
14 ## I. Execute the test using: ZSTD_STREAM + max_combine=1
15 #
16
17
18 ## Execute same query two times, which should return resultset of 10 rows
19 # 1. Observe that the resultset if its correctly uncompressed
20 # 2. Observe that the resultset if its correctly encapsulated
21 # into compression messages
22 connecting...
23 active session is now 'SomeSession'
24 RUN recvok
25 Login OK
26
27 #
28 # 1
29 RUN SELECT * FROM test.test_table
30 [ASSERT Mysqlx.Resultset.ColumnMetaData]
31 [ASSERT Mysqlx.Resultset.Row]
32 [ASSERT Mysqlx.Resultset.Row]
33 [ASSERT Mysqlx.Resultset.Row]
34 [ASSERT Mysqlx.Resultset.Row]
35 [ASSERT Mysqlx.Resultset.Row]
36 [ASSERT Mysqlx.Resultset.Row]
37 [ASSERT Mysqlx.Resultset.Row]
38 [ASSERT Mysqlx.Resultset.Row]
39 [ASSERT Mysqlx.Resultset.Row]
40 [ASSERT Mysqlx.Resultset.Row]
41 [ASSERT Mysqlx.Resultset.FetchDone]
42 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
43 [ASSERT Mysqlx.Sql.StmtExecuteOk]
44
45 #
46 # 2
47 RUN SELECT * FROM test.test_table
48 [ASSERT COMPRESSION]
49 [ASSERT COMPRESSION]
50 [ASSERT COMPRESSION]
51 [ASSERT COMPRESSION]
52 [ASSERT COMPRESSION]
53 [ASSERT COMPRESSION]
54 [ASSERT COMPRESSION]
55 [ASSERT COMPRESSION]
56 [ASSERT COMPRESSION]
57 [ASSERT COMPRESSION]
58 [ASSERT COMPRESSION]
59 [ASSERT COMPRESSION]
60 [ASSERT COMPRESSION]
61 [ASSERT Mysqlx.Sql.StmtExecuteOk]
62 closing session SomeSession
63 Mysqlx.Ok {
64 msg: "bye!"
65 }
66 ok
67
68 ## II. Execute the test using: ZSTD_STREAM + max_combine=2
69 #
70
71
72 ## Execute same query two times, which should return resultset of 10 rows
73 # 1. Observe that the resultset if its correctly uncompressed
74 # 2. Observe that the resultset if its correctly encapsulated
75 # into compression messages
76 connecting...
77 active session is now 'SomeSession'
78 RUN recvok
79 Login OK
80
81 #
82 # 1
83 RUN SELECT * FROM test.test_table
84 [ASSERT Mysqlx.Resultset.ColumnMetaData]
85 [ASSERT Mysqlx.Resultset.Row]
86 [ASSERT Mysqlx.Resultset.Row]
87 [ASSERT Mysqlx.Resultset.Row]
88 [ASSERT Mysqlx.Resultset.Row]
89 [ASSERT Mysqlx.Resultset.Row]
90 [ASSERT Mysqlx.Resultset.Row]
91 [ASSERT Mysqlx.Resultset.Row]
92 [ASSERT Mysqlx.Resultset.Row]
93 [ASSERT Mysqlx.Resultset.Row]
94 [ASSERT Mysqlx.Resultset.Row]
95 [ASSERT Mysqlx.Resultset.FetchDone]
96 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
97 [ASSERT Mysqlx.Sql.StmtExecuteOk]
98
99 #
100 # 2
101 RUN SELECT * FROM test.test_table
102 [ASSERT COMPRESSION]
103 [ASSERT COMPRESSION]
104 [ASSERT COMPRESSION]
105 [ASSERT COMPRESSION]
106 [ASSERT COMPRESSION]
107 [ASSERT COMPRESSION]
108 [ASSERT COMPRESSION]
109 [ASSERT Mysqlx.Sql.StmtExecuteOk]
110 closing session SomeSession
111 Mysqlx.Ok {
112 msg: "bye!"
113 }
114 ok
115
116 ## III. Execute the test using: ZSTD_STREAM + max_combine=3
117 #
118
119
120 ## Execute same query two times, which should return resultset of 10 rows
121 # 1. Observe that the resultset if its correctly uncompressed
122 # 2. Observe that the resultset if its correctly encapsulated
123 # into compression messages
124 connecting...
125 active session is now 'SomeSession'
126 RUN recvok
127 Login OK
128
129 #
130 # 1
131 RUN SELECT * FROM test.test_table
132 [ASSERT Mysqlx.Resultset.ColumnMetaData]
133 [ASSERT Mysqlx.Resultset.Row]
134 [ASSERT Mysqlx.Resultset.Row]
135 [ASSERT Mysqlx.Resultset.Row]
136 [ASSERT Mysqlx.Resultset.Row]
137 [ASSERT Mysqlx.Resultset.Row]
138 [ASSERT Mysqlx.Resultset.Row]
139 [ASSERT Mysqlx.Resultset.Row]
140 [ASSERT Mysqlx.Resultset.Row]
141 [ASSERT Mysqlx.Resultset.Row]
142 [ASSERT Mysqlx.Resultset.Row]
143 [ASSERT Mysqlx.Resultset.FetchDone]
144 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
145 [ASSERT Mysqlx.Sql.StmtExecuteOk]
146
147 #
148 # 2
149 RUN SELECT * FROM test.test_table
150 [ASSERT COMPRESSION]
151 [ASSERT COMPRESSION]
152 [ASSERT COMPRESSION]
153 [ASSERT COMPRESSION]
154 [ASSERT COMPRESSION]
155 [ASSERT Mysqlx.Sql.StmtExecuteOk]
156 closing session SomeSession
157 Mysqlx.Ok {
158 msg: "bye!"
159 }
160 ok
161
162 ## IV. Execute the test using: ZSTD_STREAM + max_combine=6
163 #
164
165
166 ## Execute same query two times, which should return resultset of 10 rows
167 # 1. Observe that the resultset if its correctly uncompressed
168 # 2. Observe that the resultset if its correctly encapsulated
169 # into compression messages
170 connecting...
171 active session is now 'SomeSession'
172 RUN recvok
173 Login OK
174
175 #
176 # 1
177 RUN SELECT * FROM test.test_table
178 [ASSERT Mysqlx.Resultset.ColumnMetaData]
179 [ASSERT Mysqlx.Resultset.Row]
180 [ASSERT Mysqlx.Resultset.Row]
181 [ASSERT Mysqlx.Resultset.Row]
182 [ASSERT Mysqlx.Resultset.Row]
183 [ASSERT Mysqlx.Resultset.Row]
184 [ASSERT Mysqlx.Resultset.Row]
185 [ASSERT Mysqlx.Resultset.Row]
186 [ASSERT Mysqlx.Resultset.Row]
187 [ASSERT Mysqlx.Resultset.Row]
188 [ASSERT Mysqlx.Resultset.Row]
189 [ASSERT Mysqlx.Resultset.FetchDone]
190 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
191 [ASSERT Mysqlx.Sql.StmtExecuteOk]
192
193 #
194 # 2
195 RUN SELECT * FROM test.test_table
196 [ASSERT COMPRESSION]
197 [ASSERT COMPRESSION]
198 [ASSERT COMPRESSION]
199 [ASSERT Mysqlx.Sql.StmtExecuteOk]
200 closing session SomeSession
201 Mysqlx.Ok {
202 msg: "bye!"
203 }
204 ok
205
206 ## V. Execute the test using: ZSTD_STREAM + max_combine=1000000
207 #
208
209
210 ## Execute same query two times, which should return resultset of 10 rows
211 # 1. Observe that the resultset if its correctly uncompressed
212 # 2. Observe that the resultset if its correctly encapsulated
213 # into compression messages
214 connecting...
215 active session is now 'SomeSession'
216 RUN recvok
217 Login OK
218
219 #
220 # 1
221 RUN SELECT * FROM test.test_table
222 [ASSERT Mysqlx.Resultset.ColumnMetaData]
223 [ASSERT Mysqlx.Resultset.Row]
224 [ASSERT Mysqlx.Resultset.Row]
225 [ASSERT Mysqlx.Resultset.Row]
226 [ASSERT Mysqlx.Resultset.Row]
227 [ASSERT Mysqlx.Resultset.Row]
228 [ASSERT Mysqlx.Resultset.Row]
229 [ASSERT Mysqlx.Resultset.Row]
230 [ASSERT Mysqlx.Resultset.Row]
231 [ASSERT Mysqlx.Resultset.Row]
232 [ASSERT Mysqlx.Resultset.Row]
233 [ASSERT Mysqlx.Resultset.FetchDone]
234 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
235 [ASSERT Mysqlx.Sql.StmtExecuteOk]
236
237 #
238 # 2
239 RUN SELECT * FROM test.test_table
240 [ASSERT COMPRESSION]
241 [ASSERT Mysqlx.Sql.StmtExecuteOk]
242 closing session SomeSession
243 Mysqlx.Ok {
244 msg: "bye!"
245 }
246 ok
247
248 ## VI. Execute the test using: ZSTD_STREAM + max_combine=9223372036854775807
249 #
250
251
252 ## Execute same query two times, which should return resultset of 10 rows
253 # 1. Observe that the resultset if its correctly uncompressed
254 # 2. Observe that the resultset if its correctly encapsulated
255 # into compression messages
256 connecting...
257 active session is now 'SomeSession'
258 RUN recvok
259 Login OK
260
261 #
262 # 1
263 RUN SELECT * FROM test.test_table
264 [ASSERT Mysqlx.Resultset.ColumnMetaData]
265 [ASSERT Mysqlx.Resultset.Row]
266 [ASSERT Mysqlx.Resultset.Row]
267 [ASSERT Mysqlx.Resultset.Row]
268 [ASSERT Mysqlx.Resultset.Row]
269 [ASSERT Mysqlx.Resultset.Row]
270 [ASSERT Mysqlx.Resultset.Row]
271 [ASSERT Mysqlx.Resultset.Row]
272 [ASSERT Mysqlx.Resultset.Row]
273 [ASSERT Mysqlx.Resultset.Row]
274 [ASSERT Mysqlx.Resultset.Row]
275 [ASSERT Mysqlx.Resultset.FetchDone]
276 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
277 [ASSERT Mysqlx.Sql.StmtExecuteOk]
278
279 #
280 # 2
281 RUN SELECT * FROM test.test_table
282 [ASSERT COMPRESSION]
283 [ASSERT Mysqlx.Sql.StmtExecuteOk]
284 closing session SomeSession
285 Mysqlx.Ok {
286 msg: "bye!"
287 }
288 ok
289
290 ## I. Execute the test using: LZ4_MESSAGE + max_combine=1
291 #
292
293
294 ## Execute same query two times, which should return resultset of 10 rows
295 # 1. Observe that the resultset if its correctly uncompressed
296 # 2. Observe that the resultset if its correctly encapsulated
297 # into compression messages
298 connecting...
299 active session is now 'SomeSession'
300 RUN recvok
301 Login OK
302
303 #
304 # 1
305 RUN SELECT * FROM test.test_table
306 [ASSERT Mysqlx.Resultset.ColumnMetaData]
307 [ASSERT Mysqlx.Resultset.Row]
308 [ASSERT Mysqlx.Resultset.Row]
309 [ASSERT Mysqlx.Resultset.Row]
310 [ASSERT Mysqlx.Resultset.Row]
311 [ASSERT Mysqlx.Resultset.Row]
312 [ASSERT Mysqlx.Resultset.Row]
313 [ASSERT Mysqlx.Resultset.Row]
314 [ASSERT Mysqlx.Resultset.Row]
315 [ASSERT Mysqlx.Resultset.Row]
316 [ASSERT Mysqlx.Resultset.Row]
317 [ASSERT Mysqlx.Resultset.FetchDone]
318 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
319 [ASSERT Mysqlx.Sql.StmtExecuteOk]
320
321 #
322 # 2
323 RUN SELECT * FROM test.test_table
324 [ASSERT COMPRESSION]
325 [ASSERT COMPRESSION]
326 [ASSERT COMPRESSION]
327 [ASSERT COMPRESSION]
328 [ASSERT COMPRESSION]
329 [ASSERT COMPRESSION]
330 [ASSERT COMPRESSION]
331 [ASSERT COMPRESSION]
332 [ASSERT COMPRESSION]
333 [ASSERT COMPRESSION]
334 [ASSERT COMPRESSION]
335 [ASSERT COMPRESSION]
336 [ASSERT COMPRESSION]
337 [ASSERT Mysqlx.Sql.StmtExecuteOk]
338 closing session SomeSession
339 Mysqlx.Ok {
340 msg: "bye!"
341 }
342 ok
343
344 ## II. Execute the test using: LZ4_MESSAGE + max_combine=2
345 #
346
347
348 ## Execute same query two times, which should return resultset of 10 rows
349 # 1. Observe that the resultset if its correctly uncompressed
350 # 2. Observe that the resultset if its correctly encapsulated
351 # into compression messages
352 connecting...
353 active session is now 'SomeSession'
354 RUN recvok
355 Login OK
356
357 #
358 # 1
359 RUN SELECT * FROM test.test_table
360 [ASSERT Mysqlx.Resultset.ColumnMetaData]
361 [ASSERT Mysqlx.Resultset.Row]
362 [ASSERT Mysqlx.Resultset.Row]
363 [ASSERT Mysqlx.Resultset.Row]
364 [ASSERT Mysqlx.Resultset.Row]
365 [ASSERT Mysqlx.Resultset.Row]
366 [ASSERT Mysqlx.Resultset.Row]
367 [ASSERT Mysqlx.Resultset.Row]
368 [ASSERT Mysqlx.Resultset.Row]
369 [ASSERT Mysqlx.Resultset.Row]
370 [ASSERT Mysqlx.Resultset.Row]
371 [ASSERT Mysqlx.Resultset.FetchDone]
372 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
373 [ASSERT Mysqlx.Sql.StmtExecuteOk]
374
375 #
376 # 2
377 RUN SELECT * FROM test.test_table
378 [ASSERT COMPRESSION]
379 [ASSERT COMPRESSION]
380 [ASSERT COMPRESSION]
381 [ASSERT COMPRESSION]
382 [ASSERT COMPRESSION]
383 [ASSERT COMPRESSION]
384 [ASSERT COMPRESSION]
385 [ASSERT Mysqlx.Sql.StmtExecuteOk]
386 closing session SomeSession
387 Mysqlx.Ok {
388 msg: "bye!"
389 }
390 ok
391
392 ## III. Execute the test using: LZ4_MESSAGE + max_combine=3
393 #
394
395
396 ## Execute same query two times, which should return resultset of 10 rows
397 # 1. Observe that the resultset if its correctly uncompressed
398 # 2. Observe that the resultset if its correctly encapsulated
399 # into compression messages
400 connecting...
401 active session is now 'SomeSession'
402 RUN recvok
403 Login OK
404
405 #
406 # 1
407 RUN SELECT * FROM test.test_table
408 [ASSERT Mysqlx.Resultset.ColumnMetaData]
409 [ASSERT Mysqlx.Resultset.Row]
410 [ASSERT Mysqlx.Resultset.Row]
411 [ASSERT Mysqlx.Resultset.Row]
412 [ASSERT Mysqlx.Resultset.Row]
413 [ASSERT Mysqlx.Resultset.Row]
414 [ASSERT Mysqlx.Resultset.Row]
415 [ASSERT Mysqlx.Resultset.Row]
416 [ASSERT Mysqlx.Resultset.Row]
417 [ASSERT Mysqlx.Resultset.Row]
418 [ASSERT Mysqlx.Resultset.Row]
419 [ASSERT Mysqlx.Resultset.FetchDone]
420 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
421 [ASSERT Mysqlx.Sql.StmtExecuteOk]
422
423 #
424 # 2
425 RUN SELECT * FROM test.test_table
426 [ASSERT COMPRESSION]
427 [ASSERT COMPRESSION]
428 [ASSERT COMPRESSION]
429 [ASSERT COMPRESSION]
430 [ASSERT COMPRESSION]
431 [ASSERT Mysqlx.Sql.StmtExecuteOk]
432 closing session SomeSession
433 Mysqlx.Ok {
434 msg: "bye!"
435 }
436 ok
437
438 ## IV. Execute the test using: LZ4_MESSAGE + max_combine=6
439 #
440
441
442 ## Execute same query two times, which should return resultset of 10 rows
443 # 1. Observe that the resultset if its correctly uncompressed
444 # 2. Observe that the resultset if its correctly encapsulated
445 # into compression messages
446 connecting...
447 active session is now 'SomeSession'
448 RUN recvok
449 Login OK
450
451 #
452 # 1
453 RUN SELECT * FROM test.test_table
454 [ASSERT Mysqlx.Resultset.ColumnMetaData]
455 [ASSERT Mysqlx.Resultset.Row]
456 [ASSERT Mysqlx.Resultset.Row]
457 [ASSERT Mysqlx.Resultset.Row]
458 [ASSERT Mysqlx.Resultset.Row]
459 [ASSERT Mysqlx.Resultset.Row]
460 [ASSERT Mysqlx.Resultset.Row]
461 [ASSERT Mysqlx.Resultset.Row]
462 [ASSERT Mysqlx.Resultset.Row]
463 [ASSERT Mysqlx.Resultset.Row]
464 [ASSERT Mysqlx.Resultset.Row]
465 [ASSERT Mysqlx.Resultset.FetchDone]
466 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
467 [ASSERT Mysqlx.Sql.StmtExecuteOk]
468
469 #
470 # 2
471 RUN SELECT * FROM test.test_table
472 [ASSERT COMPRESSION]
473 [ASSERT COMPRESSION]
474 [ASSERT COMPRESSION]
475 [ASSERT Mysqlx.Sql.StmtExecuteOk]
476 closing session SomeSession
477 Mysqlx.Ok {
478 msg: "bye!"
479 }
480 ok
481
482 ## V. Execute the test using: LZ4_MESSAGE + max_combine=1000000
483 #
484
485
486 ## Execute same query two times, which should return resultset of 10 rows
487 # 1. Observe that the resultset if its correctly uncompressed
488 # 2. Observe that the resultset if its correctly encapsulated
489 # into compression messages
490 connecting...
491 active session is now 'SomeSession'
492 RUN recvok
493 Login OK
494
495 #
496 # 1
497 RUN SELECT * FROM test.test_table
498 [ASSERT Mysqlx.Resultset.ColumnMetaData]
499 [ASSERT Mysqlx.Resultset.Row]
500 [ASSERT Mysqlx.Resultset.Row]
501 [ASSERT Mysqlx.Resultset.Row]
502 [ASSERT Mysqlx.Resultset.Row]
503 [ASSERT Mysqlx.Resultset.Row]
504 [ASSERT Mysqlx.Resultset.Row]
505 [ASSERT Mysqlx.Resultset.Row]
506 [ASSERT Mysqlx.Resultset.Row]
507 [ASSERT Mysqlx.Resultset.Row]
508 [ASSERT Mysqlx.Resultset.Row]
509 [ASSERT Mysqlx.Resultset.FetchDone]
510 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
511 [ASSERT Mysqlx.Sql.StmtExecuteOk]
512
513 #
514 # 2
515 RUN SELECT * FROM test.test_table
516 [ASSERT COMPRESSION]
517 [ASSERT Mysqlx.Sql.StmtExecuteOk]
518 closing session SomeSession
519 Mysqlx.Ok {
520 msg: "bye!"
521 }
522 ok
523
524 ## VI. Execute the test using: LZ4_MESSAGE + max_combine=9223372036854775807
525 #
526
527
528 ## Execute same query two times, which should return resultset of 10 rows
529 # 1. Observe that the resultset if its correctly uncompressed
530 # 2. Observe that the resultset if its correctly encapsulated
531 # into compression messages
532 connecting...
533 active session is now 'SomeSession'
534 RUN recvok
535 Login OK
536
537 #
538 # 1
539 RUN SELECT * FROM test.test_table
540 [ASSERT Mysqlx.Resultset.ColumnMetaData]
541 [ASSERT Mysqlx.Resultset.Row]
542 [ASSERT Mysqlx.Resultset.Row]
543 [ASSERT Mysqlx.Resultset.Row]
544 [ASSERT Mysqlx.Resultset.Row]
545 [ASSERT Mysqlx.Resultset.Row]
546 [ASSERT Mysqlx.Resultset.Row]
547 [ASSERT Mysqlx.Resultset.Row]
548 [ASSERT Mysqlx.Resultset.Row]
549 [ASSERT Mysqlx.Resultset.Row]
550 [ASSERT Mysqlx.Resultset.Row]
551 [ASSERT Mysqlx.Resultset.FetchDone]
552 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
553 [ASSERT Mysqlx.Sql.StmtExecuteOk]
554
555 #
556 # 2
557 RUN SELECT * FROM test.test_table
558 [ASSERT COMPRESSION]
559 [ASSERT Mysqlx.Sql.StmtExecuteOk]
560 closing session SomeSession
561 Mysqlx.Ok {
562 msg: "bye!"
563 }
564 ok
565
566 ## I. Execute the test using: DEFLATE_STREAM + max_combine=1
567 #
568
569
570 ## Execute same query two times, which should return resultset of 10 rows
571 # 1. Observe that the resultset if its correctly uncompressed
572 # 2. Observe that the resultset if its correctly encapsulated
573 # into compression messages
574 connecting...
575 active session is now 'SomeSession'
576 RUN recvok
577 Login OK
578
579 #
580 # 1
581 RUN SELECT * FROM test.test_table
582 [ASSERT Mysqlx.Resultset.ColumnMetaData]
583 [ASSERT Mysqlx.Resultset.Row]
584 [ASSERT Mysqlx.Resultset.Row]
585 [ASSERT Mysqlx.Resultset.Row]
586 [ASSERT Mysqlx.Resultset.Row]
587 [ASSERT Mysqlx.Resultset.Row]
588 [ASSERT Mysqlx.Resultset.Row]
589 [ASSERT Mysqlx.Resultset.Row]
590 [ASSERT Mysqlx.Resultset.Row]
591 [ASSERT Mysqlx.Resultset.Row]
592 [ASSERT Mysqlx.Resultset.Row]
593 [ASSERT Mysqlx.Resultset.FetchDone]
594 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
595 [ASSERT Mysqlx.Sql.StmtExecuteOk]
596
597 #
598 # 2
599 RUN SELECT * FROM test.test_table
600 [ASSERT COMPRESSION]
601 [ASSERT COMPRESSION]
602 [ASSERT COMPRESSION]
603 [ASSERT COMPRESSION]
604 [ASSERT COMPRESSION]
605 [ASSERT COMPRESSION]
606 [ASSERT COMPRESSION]
607 [ASSERT COMPRESSION]
608 [ASSERT COMPRESSION]
609 [ASSERT COMPRESSION]
610 [ASSERT COMPRESSION]
611 [ASSERT COMPRESSION]
612 [ASSERT COMPRESSION]
613 [ASSERT Mysqlx.Sql.StmtExecuteOk]
614 closing session SomeSession
615 Mysqlx.Ok {
616 msg: "bye!"
617 }
618 ok
619
620 ## II. Execute the test using: DEFLATE_STREAM + max_combine=2
621 #
622
623
624 ## Execute same query two times, which should return resultset of 10 rows
625 # 1. Observe that the resultset if its correctly uncompressed
626 # 2. Observe that the resultset if its correctly encapsulated
627 # into compression messages
628 connecting...
629 active session is now 'SomeSession'
630 RUN recvok
631 Login OK
632
633 #
634 # 1
635 RUN SELECT * FROM test.test_table
636 [ASSERT Mysqlx.Resultset.ColumnMetaData]
637 [ASSERT Mysqlx.Resultset.Row]
638 [ASSERT Mysqlx.Resultset.Row]
639 [ASSERT Mysqlx.Resultset.Row]
640 [ASSERT Mysqlx.Resultset.Row]
641 [ASSERT Mysqlx.Resultset.Row]
642 [ASSERT Mysqlx.Resultset.Row]
643 [ASSERT Mysqlx.Resultset.Row]
644 [ASSERT Mysqlx.Resultset.Row]
645 [ASSERT Mysqlx.Resultset.Row]
646 [ASSERT Mysqlx.Resultset.Row]
647 [ASSERT Mysqlx.Resultset.FetchDone]
648 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
649 [ASSERT Mysqlx.Sql.StmtExecuteOk]
650
651 #
652 # 2
653 RUN SELECT * FROM test.test_table
654 [ASSERT COMPRESSION]
655 [ASSERT COMPRESSION]
656 [ASSERT COMPRESSION]
657 [ASSERT COMPRESSION]
658 [ASSERT COMPRESSION]
659 [ASSERT COMPRESSION]
660 [ASSERT COMPRESSION]
661 [ASSERT Mysqlx.Sql.StmtExecuteOk]
662 closing session SomeSession
663 Mysqlx.Ok {
664 msg: "bye!"
665 }
666 ok
667
668 ## III. Execute the test using: DEFLATE_STREAM + max_combine=3
669 #
670
671
672 ## Execute same query two times, which should return resultset of 10 rows
673 # 1. Observe that the resultset if its correctly uncompressed
674 # 2. Observe that the resultset if its correctly encapsulated
675 # into compression messages
676 connecting...
677 active session is now 'SomeSession'
678 RUN recvok
679 Login OK
680
681 #
682 # 1
683 RUN SELECT * FROM test.test_table
684 [ASSERT Mysqlx.Resultset.ColumnMetaData]
685 [ASSERT Mysqlx.Resultset.Row]
686 [ASSERT Mysqlx.Resultset.Row]
687 [ASSERT Mysqlx.Resultset.Row]
688 [ASSERT Mysqlx.Resultset.Row]
689 [ASSERT Mysqlx.Resultset.Row]
690 [ASSERT Mysqlx.Resultset.Row]
691 [ASSERT Mysqlx.Resultset.Row]
692 [ASSERT Mysqlx.Resultset.Row]
693 [ASSERT Mysqlx.Resultset.Row]
694 [ASSERT Mysqlx.Resultset.Row]
695 [ASSERT Mysqlx.Resultset.FetchDone]
696 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
697 [ASSERT Mysqlx.Sql.StmtExecuteOk]
698
699 #
700 # 2
701 RUN SELECT * FROM test.test_table
702 [ASSERT COMPRESSION]
703 [ASSERT COMPRESSION]
704 [ASSERT COMPRESSION]
705 [ASSERT COMPRESSION]
706 [ASSERT COMPRESSION]
707 [ASSERT Mysqlx.Sql.StmtExecuteOk]
708 closing session SomeSession
709 Mysqlx.Ok {
710 msg: "bye!"
711 }
712 ok
713
714 ## IV. Execute the test using: DEFLATE_STREAM + max_combine=6
715 #
716
717
718 ## Execute same query two times, which should return resultset of 10 rows
719 # 1. Observe that the resultset if its correctly uncompressed
720 # 2. Observe that the resultset if its correctly encapsulated
721 # into compression messages
722 connecting...
723 active session is now 'SomeSession'
724 RUN recvok
725 Login OK
726
727 #
728 # 1
729 RUN SELECT * FROM test.test_table
730 [ASSERT Mysqlx.Resultset.ColumnMetaData]
731 [ASSERT Mysqlx.Resultset.Row]
732 [ASSERT Mysqlx.Resultset.Row]
733 [ASSERT Mysqlx.Resultset.Row]
734 [ASSERT Mysqlx.Resultset.Row]
735 [ASSERT Mysqlx.Resultset.Row]
736 [ASSERT Mysqlx.Resultset.Row]
737 [ASSERT Mysqlx.Resultset.Row]
738 [ASSERT Mysqlx.Resultset.Row]
739 [ASSERT Mysqlx.Resultset.Row]
740 [ASSERT Mysqlx.Resultset.Row]
741 [ASSERT Mysqlx.Resultset.FetchDone]
742 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
743 [ASSERT Mysqlx.Sql.StmtExecuteOk]
744
745 #
746 # 2
747 RUN SELECT * FROM test.test_table
748 [ASSERT COMPRESSION]
749 [ASSERT COMPRESSION]
750 [ASSERT COMPRESSION]
751 [ASSERT Mysqlx.Sql.StmtExecuteOk]
752 closing session SomeSession
753 Mysqlx.Ok {
754 msg: "bye!"
755 }
756 ok
757
758 ## V. Execute the test using: DEFLATE_STREAM + max_combine=1000000
759 #
760
761
762 ## Execute same query two times, which should return resultset of 10 rows
763 # 1. Observe that the resultset if its correctly uncompressed
764 # 2. Observe that the resultset if its correctly encapsulated
765 # into compression messages
766 connecting...
767 active session is now 'SomeSession'
768 RUN recvok
769 Login OK
770
771 #
772 # 1
773 RUN SELECT * FROM test.test_table
774 [ASSERT Mysqlx.Resultset.ColumnMetaData]
775 [ASSERT Mysqlx.Resultset.Row]
776 [ASSERT Mysqlx.Resultset.Row]
777 [ASSERT Mysqlx.Resultset.Row]
778 [ASSERT Mysqlx.Resultset.Row]
779 [ASSERT Mysqlx.Resultset.Row]
780 [ASSERT Mysqlx.Resultset.Row]
781 [ASSERT Mysqlx.Resultset.Row]
782 [ASSERT Mysqlx.Resultset.Row]
783 [ASSERT Mysqlx.Resultset.Row]
784 [ASSERT Mysqlx.Resultset.Row]
785 [ASSERT Mysqlx.Resultset.FetchDone]
786 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
787 [ASSERT Mysqlx.Sql.StmtExecuteOk]
788
789 #
790 # 2
791 RUN SELECT * FROM test.test_table
792 [ASSERT COMPRESSION]
793 [ASSERT Mysqlx.Sql.StmtExecuteOk]
794 closing session SomeSession
795 Mysqlx.Ok {
796 msg: "bye!"
797 }
798 ok
799
800 ## VI. Execute the test using: DEFLATE_STREAM + max_combine=9223372036854775807
801 #
802
803
804 ## Execute same query two times, which should return resultset of 10 rows
805 # 1. Observe that the resultset if its correctly uncompressed
806 # 2. Observe that the resultset if its correctly encapsulated
807 # into compression messages
808 connecting...
809 active session is now 'SomeSession'
810 RUN recvok
811 Login OK
812
813 #
814 # 1
815 RUN SELECT * FROM test.test_table
816 [ASSERT Mysqlx.Resultset.ColumnMetaData]
817 [ASSERT Mysqlx.Resultset.Row]
818 [ASSERT Mysqlx.Resultset.Row]
819 [ASSERT Mysqlx.Resultset.Row]
820 [ASSERT Mysqlx.Resultset.Row]
821 [ASSERT Mysqlx.Resultset.Row]
822 [ASSERT Mysqlx.Resultset.Row]
823 [ASSERT Mysqlx.Resultset.Row]
824 [ASSERT Mysqlx.Resultset.Row]
825 [ASSERT Mysqlx.Resultset.Row]
826 [ASSERT Mysqlx.Resultset.Row]
827 [ASSERT Mysqlx.Resultset.FetchDone]
828 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
829 [ASSERT Mysqlx.Sql.StmtExecuteOk]
830
831 #
832 # 2
833 RUN SELECT * FROM test.test_table
834 [ASSERT COMPRESSION]
835 [ASSERT Mysqlx.Sql.StmtExecuteOk]
836 closing session SomeSession
837 Mysqlx.Ok {
838 msg: "bye!"
839 }
840 ok
841 DROP TABLE test_table;