Debian Codegraph @

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

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