Debian Codegraph @

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

raw
1 CREATE SCHEMA IF NOT EXISTS xtest;
2 USE xtest;
3 ## A. Execute the test using zlib/group
4 #
5
6
7 ## Test setup
8 RUN DROP TABLE IF EXISTS xtest.coll
9
10 0 rows affected
11
12 command ok
13 send Mysqlx.Crud.Insert {
14 collection {
15 name: "coll"
16 schema: "xtest"
17 }
18 data_model: DOCUMENT
19 row {
20 field {
21 type: LITERAL
22 literal {
23 type: V_OCTETS
24 v_octets {
25 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
26 content_type: 2
27 }
28 }
29 }
30 }
31 upsert: false
32 }
33
34
35 1 rows affected
36 Got expected error (code 0)
37 send Mysqlx.Crud.Insert {
38 collection {
39 name: "coll"
40 schema: "xtest"
41 }
42 data_model: DOCUMENT
43 row {
44 field {
45 type: LITERAL
46 literal {
47 type: V_OCTETS
48 v_octets {
49 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
50 content_type: 2
51 }
52 }
53 }
54 }
55 upsert: false
56 }
57
58
59 1 rows affected
60 Got expected error (code 0)
61 send Mysqlx.Crud.Insert {
62 collection {
63 name: "coll"
64 schema: "xtest"
65 }
66 data_model: DOCUMENT
67 row {
68 field {
69 type: LITERAL
70 literal {
71 type: V_OCTETS
72 v_octets {
73 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
74 content_type: 2
75 }
76 }
77 }
78 }
79 upsert: false
80 }
81
82
83 1 rows affected
84 Got expected error (code 0)
85 send Mysqlx.Crud.Insert {
86 collection {
87 name: "coll"
88 schema: "xtest"
89 }
90 data_model: DOCUMENT
91 row {
92 field {
93 type: LITERAL
94 literal {
95 type: V_OCTETS
96 v_octets {
97 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
98 content_type: 2
99 }
100 }
101 }
102 }
103 upsert: false
104 }
105
106
107 1 rows affected
108 Got expected error (code 0)
109
110
111 ## I. Validate simple resultsets for CRUD messages
112 #
113 # 1. Assert resultset for CRUD-delete message
114 # 2. Assert resultset for CRUD-update message
115 # 3. Assert resultset for CRUD-create message (doc with id)
116 # 4. Assert resultset for CRUD-create message (doc without id)
117 # 5. Assert resultset for CRUD-read message
118
119 ## II. Validate simple resultset with warnings
120 #
121 # 1. Assert one resultsets for select queries
122
123 #
124 # I.1
125 send Mysqlx.Crud.Delete {
126 collection {
127 name: "coll"
128 }
129 data_model: DOCUMENT
130 criteria {
131 type: OPERATOR
132 operator {
133 name: "=="
134 param {
135 type: IDENT
136 identifier {
137 document_path {
138 type: MEMBER
139 value: "name"
140 }
141 }
142 }
143 param {
144 type: LITERAL
145 literal {
146 type: V_OCTETS
147 v_octets {
148 value: "fifth"
149 }
150 }
151 }
152 }
153 }
154 }
155
156 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
157 [ASSERT Mysqlx.Sql.StmtExecuteOk]
158
159 #
160 # I.2
161 send Mysqlx.Crud.Update {
162 collection {
163 name: "coll"
164 }
165 data_model: DOCUMENT
166 operation {
167 source {
168 document_path {
169 type: MEMBER
170 value: "prio"
171 }
172 }
173 operation: ITEM_SET
174 value {
175 type: OPERATOR
176 operator {
177 name: "-"
178 param {
179 type: IDENT
180 identifier {
181 document_path {
182 type: MEMBER
183 value: "prio"
184 }
185 }
186 }
187 param {
188 type: LITERAL
189 literal {
190 type: V_SINT
191 v_signed_int: 1
192 }
193 }
194 }
195 }
196 }
197 }
198
199 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
200 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
201 [ASSERT Mysqlx.Sql.StmtExecuteOk]
202
203 #
204 # I.3
205 send Mysqlx.Crud.Insert {
206 collection {
207 name: "coll"
208 schema: "xtest"
209 }
210 data_model: DOCUMENT
211 row {
212 field {
213 type: LITERAL
214 literal {
215 type: V_OCTETS
216 v_octets {
217 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
218 content_type: 2
219 }
220 }
221 }
222 }
223 upsert: false
224 }
225
226 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
227 [ASSERT Mysqlx.Sql.StmtExecuteOk]
228
229 #
230 # I.4
231 send Mysqlx.Crud.Insert {
232 collection {
233 name: "coll"
234 schema: "xtest"
235 }
236 data_model: DOCUMENT
237 row {
238 field {
239 type: LITERAL
240 literal {
241 type: V_OCTETS
242 v_octets {
243 value: "{\"name\":\"sixth\", \"prio\":3}"
244 content_type: 2
245 }
246 }
247 }
248 }
249 upsert: false
250 }
251
252 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
253 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
254 [ASSERT Mysqlx.Sql.StmtExecuteOk]
255
256 #
257 # I.5
258 send Mysqlx.Crud.Find {
259 collection {
260 name: "coll"
261 }
262 data_model: DOCUMENT
263 projection {
264 source {
265 type: IDENT
266 identifier {
267 document_path {
268 type: MEMBER
269 value: "name"
270 }
271 }
272 }
273 alias: "name"
274 }
275 }
276
277 [ASSERT Mysqlx.Resultset.ColumnMetaData]
278 [ASSERT Mysqlx.Resultset.Row]
279 [ASSERT Mysqlx.Resultset.Row]
280 [ASSERT Mysqlx.Resultset.Row]
281 [ASSERT Mysqlx.Resultset.Row]
282 [ASSERT Mysqlx.Resultset.Row]
283 [ASSERT Mysqlx.Resultset.FetchDone]
284 [ASSERT Mysqlx.Sql.StmtExecuteOk]
285
286 #
287 # II.1
288 send Mysqlx.Crud.Find {
289 collection {
290 name: "coll"
291 }
292 data_model: DOCUMENT
293 projection {
294 source {
295 type: OPERATOR
296 operator {
297 name: "/"
298 param {
299 type: LITERAL
300 literal {
301 type: V_SINT
302 v_signed_int: 1
303 }
304 }
305 param {
306 type: IDENT
307 identifier {
308 document_path {
309 type: MEMBER
310 value: "prio"
311 }
312 }
313 }
314 }
315 }
316 alias: "name"
317 }
318 }
319
320 [ASSERT Mysqlx.Resultset.ColumnMetaData]
321 [ASSERT Mysqlx.Resultset.Row]
322 [ASSERT Mysqlx.Resultset.Row]
323 [ASSERT Mysqlx.Resultset.Row]
324 [ASSERT Mysqlx.Resultset.Row]
325 [ASSERT Mysqlx.Resultset.Row]
326 [ASSERT Mysqlx.Resultset.FetchDone]
327 [ASSERT notice warning - WARNING, 1365]
328 [ASSERT notice warning - WARNING, 1365]
329 [ASSERT Mysqlx.Sql.StmtExecuteOk]
330 Mysqlx.Ok {
331 msg: "bye!"
332 }
333 ok
334 ## B. Execute the test using zlib/multiple
335 #
336
337
338 ## Test setup
339 RUN DROP TABLE IF EXISTS xtest.coll
340
341 0 rows affected
342
343 command ok
344 send Mysqlx.Crud.Insert {
345 collection {
346 name: "coll"
347 schema: "xtest"
348 }
349 data_model: DOCUMENT
350 row {
351 field {
352 type: LITERAL
353 literal {
354 type: V_OCTETS
355 v_octets {
356 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
357 content_type: 2
358 }
359 }
360 }
361 }
362 upsert: false
363 }
364
365
366 1 rows affected
367 Got expected error (code 0)
368 send Mysqlx.Crud.Insert {
369 collection {
370 name: "coll"
371 schema: "xtest"
372 }
373 data_model: DOCUMENT
374 row {
375 field {
376 type: LITERAL
377 literal {
378 type: V_OCTETS
379 v_octets {
380 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
381 content_type: 2
382 }
383 }
384 }
385 }
386 upsert: false
387 }
388
389
390 1 rows affected
391 Got expected error (code 0)
392 send Mysqlx.Crud.Insert {
393 collection {
394 name: "coll"
395 schema: "xtest"
396 }
397 data_model: DOCUMENT
398 row {
399 field {
400 type: LITERAL
401 literal {
402 type: V_OCTETS
403 v_octets {
404 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
405 content_type: 2
406 }
407 }
408 }
409 }
410 upsert: false
411 }
412
413
414 1 rows affected
415 Got expected error (code 0)
416 send Mysqlx.Crud.Insert {
417 collection {
418 name: "coll"
419 schema: "xtest"
420 }
421 data_model: DOCUMENT
422 row {
423 field {
424 type: LITERAL
425 literal {
426 type: V_OCTETS
427 v_octets {
428 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
429 content_type: 2
430 }
431 }
432 }
433 }
434 upsert: false
435 }
436
437
438 1 rows affected
439 Got expected error (code 0)
440
441
442 ## I. Validate simple resultsets for CRUD messages
443 #
444 # 1. Assert resultset for CRUD-delete message
445 # 2. Assert resultset for CRUD-update message
446 # 3. Assert resultset for CRUD-create message (doc with id)
447 # 4. Assert resultset for CRUD-create message (doc without id)
448 # 5. Assert resultset for CRUD-read message
449
450 ## II. Validate simple resultset with warnings
451 #
452 # 1. Assert one resultsets for select queries
453
454 #
455 # I.1
456 send Mysqlx.Crud.Delete {
457 collection {
458 name: "coll"
459 }
460 data_model: DOCUMENT
461 criteria {
462 type: OPERATOR
463 operator {
464 name: "=="
465 param {
466 type: IDENT
467 identifier {
468 document_path {
469 type: MEMBER
470 value: "name"
471 }
472 }
473 }
474 param {
475 type: LITERAL
476 literal {
477 type: V_OCTETS
478 v_octets {
479 value: "fifth"
480 }
481 }
482 }
483 }
484 }
485 }
486
487 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
488 [ASSERT Mysqlx.Sql.StmtExecuteOk]
489
490 #
491 # I.2
492 send Mysqlx.Crud.Update {
493 collection {
494 name: "coll"
495 }
496 data_model: DOCUMENT
497 operation {
498 source {
499 document_path {
500 type: MEMBER
501 value: "prio"
502 }
503 }
504 operation: ITEM_SET
505 value {
506 type: OPERATOR
507 operator {
508 name: "-"
509 param {
510 type: IDENT
511 identifier {
512 document_path {
513 type: MEMBER
514 value: "prio"
515 }
516 }
517 }
518 param {
519 type: LITERAL
520 literal {
521 type: V_SINT
522 v_signed_int: 1
523 }
524 }
525 }
526 }
527 }
528 }
529
530 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
531 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
532 [ASSERT Mysqlx.Sql.StmtExecuteOk]
533
534 #
535 # I.3
536 send Mysqlx.Crud.Insert {
537 collection {
538 name: "coll"
539 schema: "xtest"
540 }
541 data_model: DOCUMENT
542 row {
543 field {
544 type: LITERAL
545 literal {
546 type: V_OCTETS
547 v_octets {
548 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
549 content_type: 2
550 }
551 }
552 }
553 }
554 upsert: false
555 }
556
557 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
558 [ASSERT Mysqlx.Sql.StmtExecuteOk]
559
560 #
561 # I.4
562 send Mysqlx.Crud.Insert {
563 collection {
564 name: "coll"
565 schema: "xtest"
566 }
567 data_model: DOCUMENT
568 row {
569 field {
570 type: LITERAL
571 literal {
572 type: V_OCTETS
573 v_octets {
574 value: "{\"name\":\"sixth\", \"prio\":3}"
575 content_type: 2
576 }
577 }
578 }
579 }
580 upsert: false
581 }
582
583 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
584 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
585 [ASSERT Mysqlx.Sql.StmtExecuteOk]
586
587 #
588 # I.5
589 send Mysqlx.Crud.Find {
590 collection {
591 name: "coll"
592 }
593 data_model: DOCUMENT
594 projection {
595 source {
596 type: IDENT
597 identifier {
598 document_path {
599 type: MEMBER
600 value: "name"
601 }
602 }
603 }
604 alias: "name"
605 }
606 }
607
608 [ASSERT Mysqlx.Resultset.ColumnMetaData]
609 [ASSERT Mysqlx.Resultset.Row]
610 [ASSERT Mysqlx.Resultset.Row]
611 [ASSERT Mysqlx.Resultset.Row]
612 [ASSERT Mysqlx.Resultset.Row]
613 [ASSERT Mysqlx.Resultset.Row]
614 [ASSERT Mysqlx.Resultset.FetchDone]
615 [ASSERT Mysqlx.Sql.StmtExecuteOk]
616
617 #
618 # II.1
619 send Mysqlx.Crud.Find {
620 collection {
621 name: "coll"
622 }
623 data_model: DOCUMENT
624 projection {
625 source {
626 type: OPERATOR
627 operator {
628 name: "/"
629 param {
630 type: LITERAL
631 literal {
632 type: V_SINT
633 v_signed_int: 1
634 }
635 }
636 param {
637 type: IDENT
638 identifier {
639 document_path {
640 type: MEMBER
641 value: "prio"
642 }
643 }
644 }
645 }
646 }
647 alias: "name"
648 }
649 }
650
651 [ASSERT Mysqlx.Resultset.ColumnMetaData]
652 [ASSERT Mysqlx.Resultset.Row]
653 [ASSERT Mysqlx.Resultset.Row]
654 [ASSERT Mysqlx.Resultset.Row]
655 [ASSERT Mysqlx.Resultset.Row]
656 [ASSERT Mysqlx.Resultset.Row]
657 [ASSERT Mysqlx.Resultset.FetchDone]
658 [ASSERT notice warning - WARNING, 1365]
659 [ASSERT notice warning - WARNING, 1365]
660 [ASSERT Mysqlx.Sql.StmtExecuteOk]
661 Mysqlx.Ok {
662 msg: "bye!"
663 }
664 ok
665 ## C. Execute the test using zlib/single
666 #
667
668
669 ## Test setup
670 RUN DROP TABLE IF EXISTS xtest.coll
671
672 0 rows affected
673
674 command ok
675 send Mysqlx.Crud.Insert {
676 collection {
677 name: "coll"
678 schema: "xtest"
679 }
680 data_model: DOCUMENT
681 row {
682 field {
683 type: LITERAL
684 literal {
685 type: V_OCTETS
686 v_octets {
687 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
688 content_type: 2
689 }
690 }
691 }
692 }
693 upsert: false
694 }
695
696
697 1 rows affected
698 Got expected error (code 0)
699 send Mysqlx.Crud.Insert {
700 collection {
701 name: "coll"
702 schema: "xtest"
703 }
704 data_model: DOCUMENT
705 row {
706 field {
707 type: LITERAL
708 literal {
709 type: V_OCTETS
710 v_octets {
711 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
712 content_type: 2
713 }
714 }
715 }
716 }
717 upsert: false
718 }
719
720
721 1 rows affected
722 Got expected error (code 0)
723 send Mysqlx.Crud.Insert {
724 collection {
725 name: "coll"
726 schema: "xtest"
727 }
728 data_model: DOCUMENT
729 row {
730 field {
731 type: LITERAL
732 literal {
733 type: V_OCTETS
734 v_octets {
735 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
736 content_type: 2
737 }
738 }
739 }
740 }
741 upsert: false
742 }
743
744
745 1 rows affected
746 Got expected error (code 0)
747 send Mysqlx.Crud.Insert {
748 collection {
749 name: "coll"
750 schema: "xtest"
751 }
752 data_model: DOCUMENT
753 row {
754 field {
755 type: LITERAL
756 literal {
757 type: V_OCTETS
758 v_octets {
759 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
760 content_type: 2
761 }
762 }
763 }
764 }
765 upsert: false
766 }
767
768
769 1 rows affected
770 Got expected error (code 0)
771
772
773 ## I. Validate simple resultsets for CRUD messages
774 #
775 # 1. Assert resultset for CRUD-delete message
776 # 2. Assert resultset for CRUD-update message
777 # 3. Assert resultset for CRUD-create message (doc with id)
778 # 4. Assert resultset for CRUD-create message (doc without id)
779 # 5. Assert resultset for CRUD-read message
780
781 ## II. Validate simple resultset with warnings
782 #
783 # 1. Assert one resultsets for select queries
784
785 #
786 # I.1
787 send Mysqlx.Crud.Delete {
788 collection {
789 name: "coll"
790 }
791 data_model: DOCUMENT
792 criteria {
793 type: OPERATOR
794 operator {
795 name: "=="
796 param {
797 type: IDENT
798 identifier {
799 document_path {
800 type: MEMBER
801 value: "name"
802 }
803 }
804 }
805 param {
806 type: LITERAL
807 literal {
808 type: V_OCTETS
809 v_octets {
810 value: "fifth"
811 }
812 }
813 }
814 }
815 }
816 }
817
818 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
819 [ASSERT Mysqlx.Sql.StmtExecuteOk]
820
821 #
822 # I.2
823 send Mysqlx.Crud.Update {
824 collection {
825 name: "coll"
826 }
827 data_model: DOCUMENT
828 operation {
829 source {
830 document_path {
831 type: MEMBER
832 value: "prio"
833 }
834 }
835 operation: ITEM_SET
836 value {
837 type: OPERATOR
838 operator {
839 name: "-"
840 param {
841 type: IDENT
842 identifier {
843 document_path {
844 type: MEMBER
845 value: "prio"
846 }
847 }
848 }
849 param {
850 type: LITERAL
851 literal {
852 type: V_SINT
853 v_signed_int: 1
854 }
855 }
856 }
857 }
858 }
859 }
860
861 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
862 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
863 [ASSERT Mysqlx.Sql.StmtExecuteOk]
864
865 #
866 # I.3
867 send Mysqlx.Crud.Insert {
868 collection {
869 name: "coll"
870 schema: "xtest"
871 }
872 data_model: DOCUMENT
873 row {
874 field {
875 type: LITERAL
876 literal {
877 type: V_OCTETS
878 v_octets {
879 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
880 content_type: 2
881 }
882 }
883 }
884 }
885 upsert: false
886 }
887
888 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
889 [ASSERT Mysqlx.Sql.StmtExecuteOk]
890
891 #
892 # I.4
893 send Mysqlx.Crud.Insert {
894 collection {
895 name: "coll"
896 schema: "xtest"
897 }
898 data_model: DOCUMENT
899 row {
900 field {
901 type: LITERAL
902 literal {
903 type: V_OCTETS
904 v_octets {
905 value: "{\"name\":\"sixth\", \"prio\":3}"
906 content_type: 2
907 }
908 }
909 }
910 }
911 upsert: false
912 }
913
914 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
915 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
916 [ASSERT Mysqlx.Sql.StmtExecuteOk]
917
918 #
919 # I.5
920 send Mysqlx.Crud.Find {
921 collection {
922 name: "coll"
923 }
924 data_model: DOCUMENT
925 projection {
926 source {
927 type: IDENT
928 identifier {
929 document_path {
930 type: MEMBER
931 value: "name"
932 }
933 }
934 }
935 alias: "name"
936 }
937 }
938
939 [ASSERT Mysqlx.Resultset.ColumnMetaData]
940 [ASSERT Mysqlx.Resultset.Row]
941 [ASSERT Mysqlx.Resultset.Row]
942 [ASSERT Mysqlx.Resultset.Row]
943 [ASSERT Mysqlx.Resultset.Row]
944 [ASSERT Mysqlx.Resultset.Row]
945 [ASSERT Mysqlx.Resultset.FetchDone]
946 [ASSERT Mysqlx.Sql.StmtExecuteOk]
947
948 #
949 # II.1
950 send Mysqlx.Crud.Find {
951 collection {
952 name: "coll"
953 }
954 data_model: DOCUMENT
955 projection {
956 source {
957 type: OPERATOR
958 operator {
959 name: "/"
960 param {
961 type: LITERAL
962 literal {
963 type: V_SINT
964 v_signed_int: 1
965 }
966 }
967 param {
968 type: IDENT
969 identifier {
970 document_path {
971 type: MEMBER
972 value: "prio"
973 }
974 }
975 }
976 }
977 }
978 alias: "name"
979 }
980 }
981
982 [ASSERT Mysqlx.Resultset.ColumnMetaData]
983 [ASSERT Mysqlx.Resultset.Row]
984 [ASSERT Mysqlx.Resultset.Row]
985 [ASSERT Mysqlx.Resultset.Row]
986 [ASSERT Mysqlx.Resultset.Row]
987 [ASSERT Mysqlx.Resultset.Row]
988 [ASSERT Mysqlx.Resultset.FetchDone]
989 [ASSERT notice warning - WARNING, 1365]
990 [ASSERT notice warning - WARNING, 1365]
991 [ASSERT Mysqlx.Sql.StmtExecuteOk]
992 Mysqlx.Ok {
993 msg: "bye!"
994 }
995 ok
996 ## D. Execute the test using lz4/group
997 #
998
999
1000 ## Test setup
1001 RUN DROP TABLE IF EXISTS xtest.coll
1002
1003 0 rows affected
1004
1005 command ok
1006 send Mysqlx.Crud.Insert {
1007 collection {
1008 name: "coll"
1009 schema: "xtest"
1010 }
1011 data_model: DOCUMENT
1012 row {
1013 field {
1014 type: LITERAL
1015 literal {
1016 type: V_OCTETS
1017 v_octets {
1018 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
1019 content_type: 2
1020 }
1021 }
1022 }
1023 }
1024 upsert: false
1025 }
1026
1027
1028 1 rows affected
1029 Got expected error (code 0)
1030 send Mysqlx.Crud.Insert {
1031 collection {
1032 name: "coll"
1033 schema: "xtest"
1034 }
1035 data_model: DOCUMENT
1036 row {
1037 field {
1038 type: LITERAL
1039 literal {
1040 type: V_OCTETS
1041 v_octets {
1042 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
1043 content_type: 2
1044 }
1045 }
1046 }
1047 }
1048 upsert: false
1049 }
1050
1051
1052 1 rows affected
1053 Got expected error (code 0)
1054 send Mysqlx.Crud.Insert {
1055 collection {
1056 name: "coll"
1057 schema: "xtest"
1058 }
1059 data_model: DOCUMENT
1060 row {
1061 field {
1062 type: LITERAL
1063 literal {
1064 type: V_OCTETS
1065 v_octets {
1066 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
1067 content_type: 2
1068 }
1069 }
1070 }
1071 }
1072 upsert: false
1073 }
1074
1075
1076 1 rows affected
1077 Got expected error (code 0)
1078 send Mysqlx.Crud.Insert {
1079 collection {
1080 name: "coll"
1081 schema: "xtest"
1082 }
1083 data_model: DOCUMENT
1084 row {
1085 field {
1086 type: LITERAL
1087 literal {
1088 type: V_OCTETS
1089 v_octets {
1090 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
1091 content_type: 2
1092 }
1093 }
1094 }
1095 }
1096 upsert: false
1097 }
1098
1099
1100 1 rows affected
1101 Got expected error (code 0)
1102
1103
1104 ## I. Validate simple resultsets for CRUD messages
1105 #
1106 # 1. Assert resultset for CRUD-delete message
1107 # 2. Assert resultset for CRUD-update message
1108 # 3. Assert resultset for CRUD-create message (doc with id)
1109 # 4. Assert resultset for CRUD-create message (doc without id)
1110 # 5. Assert resultset for CRUD-read message
1111
1112 ## II. Validate simple resultset with warnings
1113 #
1114 # 1. Assert one resultsets for select queries
1115
1116 #
1117 # I.1
1118 send Mysqlx.Crud.Delete {
1119 collection {
1120 name: "coll"
1121 }
1122 data_model: DOCUMENT
1123 criteria {
1124 type: OPERATOR
1125 operator {
1126 name: "=="
1127 param {
1128 type: IDENT
1129 identifier {
1130 document_path {
1131 type: MEMBER
1132 value: "name"
1133 }
1134 }
1135 }
1136 param {
1137 type: LITERAL
1138 literal {
1139 type: V_OCTETS
1140 v_octets {
1141 value: "fifth"
1142 }
1143 }
1144 }
1145 }
1146 }
1147 }
1148
1149 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1150 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1151
1152 #
1153 # I.2
1154 send Mysqlx.Crud.Update {
1155 collection {
1156 name: "coll"
1157 }
1158 data_model: DOCUMENT
1159 operation {
1160 source {
1161 document_path {
1162 type: MEMBER
1163 value: "prio"
1164 }
1165 }
1166 operation: ITEM_SET
1167 value {
1168 type: OPERATOR
1169 operator {
1170 name: "-"
1171 param {
1172 type: IDENT
1173 identifier {
1174 document_path {
1175 type: MEMBER
1176 value: "prio"
1177 }
1178 }
1179 }
1180 param {
1181 type: LITERAL
1182 literal {
1183 type: V_SINT
1184 v_signed_int: 1
1185 }
1186 }
1187 }
1188 }
1189 }
1190 }
1191
1192 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1193 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
1194 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1195
1196 #
1197 # I.3
1198 send Mysqlx.Crud.Insert {
1199 collection {
1200 name: "coll"
1201 schema: "xtest"
1202 }
1203 data_model: DOCUMENT
1204 row {
1205 field {
1206 type: LITERAL
1207 literal {
1208 type: V_OCTETS
1209 v_octets {
1210 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
1211 content_type: 2
1212 }
1213 }
1214 }
1215 }
1216 upsert: false
1217 }
1218
1219 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1220 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1221
1222 #
1223 # I.4
1224 send Mysqlx.Crud.Insert {
1225 collection {
1226 name: "coll"
1227 schema: "xtest"
1228 }
1229 data_model: DOCUMENT
1230 row {
1231 field {
1232 type: LITERAL
1233 literal {
1234 type: V_OCTETS
1235 v_octets {
1236 value: "{\"name\":\"sixth\", \"prio\":3}"
1237 content_type: 2
1238 }
1239 }
1240 }
1241 }
1242 upsert: false
1243 }
1244
1245 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1246 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
1247 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1248
1249 #
1250 # I.5
1251 send Mysqlx.Crud.Find {
1252 collection {
1253 name: "coll"
1254 }
1255 data_model: DOCUMENT
1256 projection {
1257 source {
1258 type: IDENT
1259 identifier {
1260 document_path {
1261 type: MEMBER
1262 value: "name"
1263 }
1264 }
1265 }
1266 alias: "name"
1267 }
1268 }
1269
1270 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1271 [ASSERT Mysqlx.Resultset.Row]
1272 [ASSERT Mysqlx.Resultset.Row]
1273 [ASSERT Mysqlx.Resultset.Row]
1274 [ASSERT Mysqlx.Resultset.Row]
1275 [ASSERT Mysqlx.Resultset.Row]
1276 [ASSERT Mysqlx.Resultset.FetchDone]
1277 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1278
1279 #
1280 # II.1
1281 send Mysqlx.Crud.Find {
1282 collection {
1283 name: "coll"
1284 }
1285 data_model: DOCUMENT
1286 projection {
1287 source {
1288 type: OPERATOR
1289 operator {
1290 name: "/"
1291 param {
1292 type: LITERAL
1293 literal {
1294 type: V_SINT
1295 v_signed_int: 1
1296 }
1297 }
1298 param {
1299 type: IDENT
1300 identifier {
1301 document_path {
1302 type: MEMBER
1303 value: "prio"
1304 }
1305 }
1306 }
1307 }
1308 }
1309 alias: "name"
1310 }
1311 }
1312
1313 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1314 [ASSERT Mysqlx.Resultset.Row]
1315 [ASSERT Mysqlx.Resultset.Row]
1316 [ASSERT Mysqlx.Resultset.Row]
1317 [ASSERT Mysqlx.Resultset.Row]
1318 [ASSERT Mysqlx.Resultset.Row]
1319 [ASSERT Mysqlx.Resultset.FetchDone]
1320 [ASSERT notice warning - WARNING, 1365]
1321 [ASSERT notice warning - WARNING, 1365]
1322 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1323 Mysqlx.Ok {
1324 msg: "bye!"
1325 }
1326 ok
1327 ## E. Execute the test using lz4/multiple
1328 #
1329
1330
1331 ## Test setup
1332 RUN DROP TABLE IF EXISTS xtest.coll
1333
1334 0 rows affected
1335
1336 command ok
1337 send Mysqlx.Crud.Insert {
1338 collection {
1339 name: "coll"
1340 schema: "xtest"
1341 }
1342 data_model: DOCUMENT
1343 row {
1344 field {
1345 type: LITERAL
1346 literal {
1347 type: V_OCTETS
1348 v_octets {
1349 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
1350 content_type: 2
1351 }
1352 }
1353 }
1354 }
1355 upsert: false
1356 }
1357
1358
1359 1 rows affected
1360 Got expected error (code 0)
1361 send Mysqlx.Crud.Insert {
1362 collection {
1363 name: "coll"
1364 schema: "xtest"
1365 }
1366 data_model: DOCUMENT
1367 row {
1368 field {
1369 type: LITERAL
1370 literal {
1371 type: V_OCTETS
1372 v_octets {
1373 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
1374 content_type: 2
1375 }
1376 }
1377 }
1378 }
1379 upsert: false
1380 }
1381
1382
1383 1 rows affected
1384 Got expected error (code 0)
1385 send Mysqlx.Crud.Insert {
1386 collection {
1387 name: "coll"
1388 schema: "xtest"
1389 }
1390 data_model: DOCUMENT
1391 row {
1392 field {
1393 type: LITERAL
1394 literal {
1395 type: V_OCTETS
1396 v_octets {
1397 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
1398 content_type: 2
1399 }
1400 }
1401 }
1402 }
1403 upsert: false
1404 }
1405
1406
1407 1 rows affected
1408 Got expected error (code 0)
1409 send Mysqlx.Crud.Insert {
1410 collection {
1411 name: "coll"
1412 schema: "xtest"
1413 }
1414 data_model: DOCUMENT
1415 row {
1416 field {
1417 type: LITERAL
1418 literal {
1419 type: V_OCTETS
1420 v_octets {
1421 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
1422 content_type: 2
1423 }
1424 }
1425 }
1426 }
1427 upsert: false
1428 }
1429
1430
1431 1 rows affected
1432 Got expected error (code 0)
1433
1434
1435 ## I. Validate simple resultsets for CRUD messages
1436 #
1437 # 1. Assert resultset for CRUD-delete message
1438 # 2. Assert resultset for CRUD-update message
1439 # 3. Assert resultset for CRUD-create message (doc with id)
1440 # 4. Assert resultset for CRUD-create message (doc without id)
1441 # 5. Assert resultset for CRUD-read message
1442
1443 ## II. Validate simple resultset with warnings
1444 #
1445 # 1. Assert one resultsets for select queries
1446
1447 #
1448 # I.1
1449 send Mysqlx.Crud.Delete {
1450 collection {
1451 name: "coll"
1452 }
1453 data_model: DOCUMENT
1454 criteria {
1455 type: OPERATOR
1456 operator {
1457 name: "=="
1458 param {
1459 type: IDENT
1460 identifier {
1461 document_path {
1462 type: MEMBER
1463 value: "name"
1464 }
1465 }
1466 }
1467 param {
1468 type: LITERAL
1469 literal {
1470 type: V_OCTETS
1471 v_octets {
1472 value: "fifth"
1473 }
1474 }
1475 }
1476 }
1477 }
1478 }
1479
1480 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1481 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1482
1483 #
1484 # I.2
1485 send Mysqlx.Crud.Update {
1486 collection {
1487 name: "coll"
1488 }
1489 data_model: DOCUMENT
1490 operation {
1491 source {
1492 document_path {
1493 type: MEMBER
1494 value: "prio"
1495 }
1496 }
1497 operation: ITEM_SET
1498 value {
1499 type: OPERATOR
1500 operator {
1501 name: "-"
1502 param {
1503 type: IDENT
1504 identifier {
1505 document_path {
1506 type: MEMBER
1507 value: "prio"
1508 }
1509 }
1510 }
1511 param {
1512 type: LITERAL
1513 literal {
1514 type: V_SINT
1515 v_signed_int: 1
1516 }
1517 }
1518 }
1519 }
1520 }
1521 }
1522
1523 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1524 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
1525 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1526
1527 #
1528 # I.3
1529 send Mysqlx.Crud.Insert {
1530 collection {
1531 name: "coll"
1532 schema: "xtest"
1533 }
1534 data_model: DOCUMENT
1535 row {
1536 field {
1537 type: LITERAL
1538 literal {
1539 type: V_OCTETS
1540 v_octets {
1541 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
1542 content_type: 2
1543 }
1544 }
1545 }
1546 }
1547 upsert: false
1548 }
1549
1550 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1551 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1552
1553 #
1554 # I.4
1555 send Mysqlx.Crud.Insert {
1556 collection {
1557 name: "coll"
1558 schema: "xtest"
1559 }
1560 data_model: DOCUMENT
1561 row {
1562 field {
1563 type: LITERAL
1564 literal {
1565 type: V_OCTETS
1566 v_octets {
1567 value: "{\"name\":\"sixth\", \"prio\":3}"
1568 content_type: 2
1569 }
1570 }
1571 }
1572 }
1573 upsert: false
1574 }
1575
1576 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1577 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
1578 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1579
1580 #
1581 # I.5
1582 send Mysqlx.Crud.Find {
1583 collection {
1584 name: "coll"
1585 }
1586 data_model: DOCUMENT
1587 projection {
1588 source {
1589 type: IDENT
1590 identifier {
1591 document_path {
1592 type: MEMBER
1593 value: "name"
1594 }
1595 }
1596 }
1597 alias: "name"
1598 }
1599 }
1600
1601 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1602 [ASSERT Mysqlx.Resultset.Row]
1603 [ASSERT Mysqlx.Resultset.Row]
1604 [ASSERT Mysqlx.Resultset.Row]
1605 [ASSERT Mysqlx.Resultset.Row]
1606 [ASSERT Mysqlx.Resultset.Row]
1607 [ASSERT Mysqlx.Resultset.FetchDone]
1608 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1609
1610 #
1611 # II.1
1612 send Mysqlx.Crud.Find {
1613 collection {
1614 name: "coll"
1615 }
1616 data_model: DOCUMENT
1617 projection {
1618 source {
1619 type: OPERATOR
1620 operator {
1621 name: "/"
1622 param {
1623 type: LITERAL
1624 literal {
1625 type: V_SINT
1626 v_signed_int: 1
1627 }
1628 }
1629 param {
1630 type: IDENT
1631 identifier {
1632 document_path {
1633 type: MEMBER
1634 value: "prio"
1635 }
1636 }
1637 }
1638 }
1639 }
1640 alias: "name"
1641 }
1642 }
1643
1644 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1645 [ASSERT Mysqlx.Resultset.Row]
1646 [ASSERT Mysqlx.Resultset.Row]
1647 [ASSERT Mysqlx.Resultset.Row]
1648 [ASSERT Mysqlx.Resultset.Row]
1649 [ASSERT Mysqlx.Resultset.Row]
1650 [ASSERT Mysqlx.Resultset.FetchDone]
1651 [ASSERT notice warning - WARNING, 1365]
1652 [ASSERT notice warning - WARNING, 1365]
1653 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1654 Mysqlx.Ok {
1655 msg: "bye!"
1656 }
1657 ok
1658 ## F. Execute the test using lz4/single
1659 #
1660
1661
1662 ## Test setup
1663 RUN DROP TABLE IF EXISTS xtest.coll
1664
1665 0 rows affected
1666
1667 command ok
1668 send Mysqlx.Crud.Insert {
1669 collection {
1670 name: "coll"
1671 schema: "xtest"
1672 }
1673 data_model: DOCUMENT
1674 row {
1675 field {
1676 type: LITERAL
1677 literal {
1678 type: V_OCTETS
1679 v_octets {
1680 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
1681 content_type: 2
1682 }
1683 }
1684 }
1685 }
1686 upsert: false
1687 }
1688
1689
1690 1 rows affected
1691 Got expected error (code 0)
1692 send Mysqlx.Crud.Insert {
1693 collection {
1694 name: "coll"
1695 schema: "xtest"
1696 }
1697 data_model: DOCUMENT
1698 row {
1699 field {
1700 type: LITERAL
1701 literal {
1702 type: V_OCTETS
1703 v_octets {
1704 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
1705 content_type: 2
1706 }
1707 }
1708 }
1709 }
1710 upsert: false
1711 }
1712
1713
1714 1 rows affected
1715 Got expected error (code 0)
1716 send Mysqlx.Crud.Insert {
1717 collection {
1718 name: "coll"
1719 schema: "xtest"
1720 }
1721 data_model: DOCUMENT
1722 row {
1723 field {
1724 type: LITERAL
1725 literal {
1726 type: V_OCTETS
1727 v_octets {
1728 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
1729 content_type: 2
1730 }
1731 }
1732 }
1733 }
1734 upsert: false
1735 }
1736
1737
1738 1 rows affected
1739 Got expected error (code 0)
1740 send Mysqlx.Crud.Insert {
1741 collection {
1742 name: "coll"
1743 schema: "xtest"
1744 }
1745 data_model: DOCUMENT
1746 row {
1747 field {
1748 type: LITERAL
1749 literal {
1750 type: V_OCTETS
1751 v_octets {
1752 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
1753 content_type: 2
1754 }
1755 }
1756 }
1757 }
1758 upsert: false
1759 }
1760
1761
1762 1 rows affected
1763 Got expected error (code 0)
1764
1765
1766 ## I. Validate simple resultsets for CRUD messages
1767 #
1768 # 1. Assert resultset for CRUD-delete message
1769 # 2. Assert resultset for CRUD-update message
1770 # 3. Assert resultset for CRUD-create message (doc with id)
1771 # 4. Assert resultset for CRUD-create message (doc without id)
1772 # 5. Assert resultset for CRUD-read message
1773
1774 ## II. Validate simple resultset with warnings
1775 #
1776 # 1. Assert one resultsets for select queries
1777
1778 #
1779 # I.1
1780 send Mysqlx.Crud.Delete {
1781 collection {
1782 name: "coll"
1783 }
1784 data_model: DOCUMENT
1785 criteria {
1786 type: OPERATOR
1787 operator {
1788 name: "=="
1789 param {
1790 type: IDENT
1791 identifier {
1792 document_path {
1793 type: MEMBER
1794 value: "name"
1795 }
1796 }
1797 }
1798 param {
1799 type: LITERAL
1800 literal {
1801 type: V_OCTETS
1802 v_octets {
1803 value: "fifth"
1804 }
1805 }
1806 }
1807 }
1808 }
1809 }
1810
1811 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1812 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1813
1814 #
1815 # I.2
1816 send Mysqlx.Crud.Update {
1817 collection {
1818 name: "coll"
1819 }
1820 data_model: DOCUMENT
1821 operation {
1822 source {
1823 document_path {
1824 type: MEMBER
1825 value: "prio"
1826 }
1827 }
1828 operation: ITEM_SET
1829 value {
1830 type: OPERATOR
1831 operator {
1832 name: "-"
1833 param {
1834 type: IDENT
1835 identifier {
1836 document_path {
1837 type: MEMBER
1838 value: "prio"
1839 }
1840 }
1841 }
1842 param {
1843 type: LITERAL
1844 literal {
1845 type: V_SINT
1846 v_signed_int: 1
1847 }
1848 }
1849 }
1850 }
1851 }
1852 }
1853
1854 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1855 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
1856 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1857
1858 #
1859 # I.3
1860 send Mysqlx.Crud.Insert {
1861 collection {
1862 name: "coll"
1863 schema: "xtest"
1864 }
1865 data_model: DOCUMENT
1866 row {
1867 field {
1868 type: LITERAL
1869 literal {
1870 type: V_OCTETS
1871 v_octets {
1872 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
1873 content_type: 2
1874 }
1875 }
1876 }
1877 }
1878 upsert: false
1879 }
1880
1881 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1882 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1883
1884 #
1885 # I.4
1886 send Mysqlx.Crud.Insert {
1887 collection {
1888 name: "coll"
1889 schema: "xtest"
1890 }
1891 data_model: DOCUMENT
1892 row {
1893 field {
1894 type: LITERAL
1895 literal {
1896 type: V_OCTETS
1897 v_octets {
1898 value: "{\"name\":\"sixth\", \"prio\":3}"
1899 content_type: 2
1900 }
1901 }
1902 }
1903 }
1904 upsert: false
1905 }
1906
1907 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1908 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
1909 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1910
1911 #
1912 # I.5
1913 send Mysqlx.Crud.Find {
1914 collection {
1915 name: "coll"
1916 }
1917 data_model: DOCUMENT
1918 projection {
1919 source {
1920 type: IDENT
1921 identifier {
1922 document_path {
1923 type: MEMBER
1924 value: "name"
1925 }
1926 }
1927 }
1928 alias: "name"
1929 }
1930 }
1931
1932 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1933 [ASSERT Mysqlx.Resultset.Row]
1934 [ASSERT Mysqlx.Resultset.Row]
1935 [ASSERT Mysqlx.Resultset.Row]
1936 [ASSERT Mysqlx.Resultset.Row]
1937 [ASSERT Mysqlx.Resultset.Row]
1938 [ASSERT Mysqlx.Resultset.FetchDone]
1939 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1940
1941 #
1942 # II.1
1943 send Mysqlx.Crud.Find {
1944 collection {
1945 name: "coll"
1946 }
1947 data_model: DOCUMENT
1948 projection {
1949 source {
1950 type: OPERATOR
1951 operator {
1952 name: "/"
1953 param {
1954 type: LITERAL
1955 literal {
1956 type: V_SINT
1957 v_signed_int: 1
1958 }
1959 }
1960 param {
1961 type: IDENT
1962 identifier {
1963 document_path {
1964 type: MEMBER
1965 value: "prio"
1966 }
1967 }
1968 }
1969 }
1970 }
1971 alias: "name"
1972 }
1973 }
1974
1975 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1976 [ASSERT Mysqlx.Resultset.Row]
1977 [ASSERT Mysqlx.Resultset.Row]
1978 [ASSERT Mysqlx.Resultset.Row]
1979 [ASSERT Mysqlx.Resultset.Row]
1980 [ASSERT Mysqlx.Resultset.Row]
1981 [ASSERT Mysqlx.Resultset.FetchDone]
1982 [ASSERT notice warning - WARNING, 1365]
1983 [ASSERT notice warning - WARNING, 1365]
1984 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1985 Mysqlx.Ok {
1986 msg: "bye!"
1987 }
1988 ok
1989 ## G. Execute the test using zstd/group
1990 #
1991
1992
1993 ## Test setup
1994 RUN DROP TABLE IF EXISTS xtest.coll
1995
1996 0 rows affected
1997
1998 command ok
1999 send Mysqlx.Crud.Insert {
2000 collection {
2001 name: "coll"
2002 schema: "xtest"
2003 }
2004 data_model: DOCUMENT
2005 row {
2006 field {
2007 type: LITERAL
2008 literal {
2009 type: V_OCTETS
2010 v_octets {
2011 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
2012 content_type: 2
2013 }
2014 }
2015 }
2016 }
2017 upsert: false
2018 }
2019
2020
2021 1 rows affected
2022 Got expected error (code 0)
2023 send Mysqlx.Crud.Insert {
2024 collection {
2025 name: "coll"
2026 schema: "xtest"
2027 }
2028 data_model: DOCUMENT
2029 row {
2030 field {
2031 type: LITERAL
2032 literal {
2033 type: V_OCTETS
2034 v_octets {
2035 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
2036 content_type: 2
2037 }
2038 }
2039 }
2040 }
2041 upsert: false
2042 }
2043
2044
2045 1 rows affected
2046 Got expected error (code 0)
2047 send Mysqlx.Crud.Insert {
2048 collection {
2049 name: "coll"
2050 schema: "xtest"
2051 }
2052 data_model: DOCUMENT
2053 row {
2054 field {
2055 type: LITERAL
2056 literal {
2057 type: V_OCTETS
2058 v_octets {
2059 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
2060 content_type: 2
2061 }
2062 }
2063 }
2064 }
2065 upsert: false
2066 }
2067
2068
2069 1 rows affected
2070 Got expected error (code 0)
2071 send Mysqlx.Crud.Insert {
2072 collection {
2073 name: "coll"
2074 schema: "xtest"
2075 }
2076 data_model: DOCUMENT
2077 row {
2078 field {
2079 type: LITERAL
2080 literal {
2081 type: V_OCTETS
2082 v_octets {
2083 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
2084 content_type: 2
2085 }
2086 }
2087 }
2088 }
2089 upsert: false
2090 }
2091
2092
2093 1 rows affected
2094 Got expected error (code 0)
2095
2096
2097 ## I. Validate simple resultsets for CRUD messages
2098 #
2099 # 1. Assert resultset for CRUD-delete message
2100 # 2. Assert resultset for CRUD-update message
2101 # 3. Assert resultset for CRUD-create message (doc with id)
2102 # 4. Assert resultset for CRUD-create message (doc without id)
2103 # 5. Assert resultset for CRUD-read message
2104
2105 ## II. Validate simple resultset with warnings
2106 #
2107 # 1. Assert one resultsets for select queries
2108
2109 #
2110 # I.1
2111 send Mysqlx.Crud.Delete {
2112 collection {
2113 name: "coll"
2114 }
2115 data_model: DOCUMENT
2116 criteria {
2117 type: OPERATOR
2118 operator {
2119 name: "=="
2120 param {
2121 type: IDENT
2122 identifier {
2123 document_path {
2124 type: MEMBER
2125 value: "name"
2126 }
2127 }
2128 }
2129 param {
2130 type: LITERAL
2131 literal {
2132 type: V_OCTETS
2133 v_octets {
2134 value: "fifth"
2135 }
2136 }
2137 }
2138 }
2139 }
2140 }
2141
2142 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2143 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2144
2145 #
2146 # I.2
2147 send Mysqlx.Crud.Update {
2148 collection {
2149 name: "coll"
2150 }
2151 data_model: DOCUMENT
2152 operation {
2153 source {
2154 document_path {
2155 type: MEMBER
2156 value: "prio"
2157 }
2158 }
2159 operation: ITEM_SET
2160 value {
2161 type: OPERATOR
2162 operator {
2163 name: "-"
2164 param {
2165 type: IDENT
2166 identifier {
2167 document_path {
2168 type: MEMBER
2169 value: "prio"
2170 }
2171 }
2172 }
2173 param {
2174 type: LITERAL
2175 literal {
2176 type: V_SINT
2177 v_signed_int: 1
2178 }
2179 }
2180 }
2181 }
2182 }
2183 }
2184
2185 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
2186 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
2187 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2188
2189 #
2190 # I.3
2191 send Mysqlx.Crud.Insert {
2192 collection {
2193 name: "coll"
2194 schema: "xtest"
2195 }
2196 data_model: DOCUMENT
2197 row {
2198 field {
2199 type: LITERAL
2200 literal {
2201 type: V_OCTETS
2202 v_octets {
2203 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
2204 content_type: 2
2205 }
2206 }
2207 }
2208 }
2209 upsert: false
2210 }
2211
2212 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2213 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2214
2215 #
2216 # I.4
2217 send Mysqlx.Crud.Insert {
2218 collection {
2219 name: "coll"
2220 schema: "xtest"
2221 }
2222 data_model: DOCUMENT
2223 row {
2224 field {
2225 type: LITERAL
2226 literal {
2227 type: V_OCTETS
2228 v_octets {
2229 value: "{\"name\":\"sixth\", \"prio\":3}"
2230 content_type: 2
2231 }
2232 }
2233 }
2234 }
2235 upsert: false
2236 }
2237
2238 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2239 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
2240 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2241
2242 #
2243 # I.5
2244 send Mysqlx.Crud.Find {
2245 collection {
2246 name: "coll"
2247 }
2248 data_model: DOCUMENT
2249 projection {
2250 source {
2251 type: IDENT
2252 identifier {
2253 document_path {
2254 type: MEMBER
2255 value: "name"
2256 }
2257 }
2258 }
2259 alias: "name"
2260 }
2261 }
2262
2263 [ASSERT Mysqlx.Resultset.ColumnMetaData]
2264 [ASSERT Mysqlx.Resultset.Row]
2265 [ASSERT Mysqlx.Resultset.Row]
2266 [ASSERT Mysqlx.Resultset.Row]
2267 [ASSERT Mysqlx.Resultset.Row]
2268 [ASSERT Mysqlx.Resultset.Row]
2269 [ASSERT Mysqlx.Resultset.FetchDone]
2270 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2271
2272 #
2273 # II.1
2274 send Mysqlx.Crud.Find {
2275 collection {
2276 name: "coll"
2277 }
2278 data_model: DOCUMENT
2279 projection {
2280 source {
2281 type: OPERATOR
2282 operator {
2283 name: "/"
2284 param {
2285 type: LITERAL
2286 literal {
2287 type: V_SINT
2288 v_signed_int: 1
2289 }
2290 }
2291 param {
2292 type: IDENT
2293 identifier {
2294 document_path {
2295 type: MEMBER
2296 value: "prio"
2297 }
2298 }
2299 }
2300 }
2301 }
2302 alias: "name"
2303 }
2304 }
2305
2306 [ASSERT Mysqlx.Resultset.ColumnMetaData]
2307 [ASSERT Mysqlx.Resultset.Row]
2308 [ASSERT Mysqlx.Resultset.Row]
2309 [ASSERT Mysqlx.Resultset.Row]
2310 [ASSERT Mysqlx.Resultset.Row]
2311 [ASSERT Mysqlx.Resultset.Row]
2312 [ASSERT Mysqlx.Resultset.FetchDone]
2313 [ASSERT notice warning - WARNING, 1365]
2314 [ASSERT notice warning - WARNING, 1365]
2315 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2316 Mysqlx.Ok {
2317 msg: "bye!"
2318 }
2319 ok
2320 ## H. Execute the test using zstd/multiple
2321 #
2322
2323
2324 ## Test setup
2325 RUN DROP TABLE IF EXISTS xtest.coll
2326
2327 0 rows affected
2328
2329 command ok
2330 send Mysqlx.Crud.Insert {
2331 collection {
2332 name: "coll"
2333 schema: "xtest"
2334 }
2335 data_model: DOCUMENT
2336 row {
2337 field {
2338 type: LITERAL
2339 literal {
2340 type: V_OCTETS
2341 v_octets {
2342 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
2343 content_type: 2
2344 }
2345 }
2346 }
2347 }
2348 upsert: false
2349 }
2350
2351
2352 1 rows affected
2353 Got expected error (code 0)
2354 send Mysqlx.Crud.Insert {
2355 collection {
2356 name: "coll"
2357 schema: "xtest"
2358 }
2359 data_model: DOCUMENT
2360 row {
2361 field {
2362 type: LITERAL
2363 literal {
2364 type: V_OCTETS
2365 v_octets {
2366 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
2367 content_type: 2
2368 }
2369 }
2370 }
2371 }
2372 upsert: false
2373 }
2374
2375
2376 1 rows affected
2377 Got expected error (code 0)
2378 send Mysqlx.Crud.Insert {
2379 collection {
2380 name: "coll"
2381 schema: "xtest"
2382 }
2383 data_model: DOCUMENT
2384 row {
2385 field {
2386 type: LITERAL
2387 literal {
2388 type: V_OCTETS
2389 v_octets {
2390 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
2391 content_type: 2
2392 }
2393 }
2394 }
2395 }
2396 upsert: false
2397 }
2398
2399
2400 1 rows affected
2401 Got expected error (code 0)
2402 send Mysqlx.Crud.Insert {
2403 collection {
2404 name: "coll"
2405 schema: "xtest"
2406 }
2407 data_model: DOCUMENT
2408 row {
2409 field {
2410 type: LITERAL
2411 literal {
2412 type: V_OCTETS
2413 v_octets {
2414 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
2415 content_type: 2
2416 }
2417 }
2418 }
2419 }
2420 upsert: false
2421 }
2422
2423
2424 1 rows affected
2425 Got expected error (code 0)
2426
2427
2428 ## I. Validate simple resultsets for CRUD messages
2429 #
2430 # 1. Assert resultset for CRUD-delete message
2431 # 2. Assert resultset for CRUD-update message
2432 # 3. Assert resultset for CRUD-create message (doc with id)
2433 # 4. Assert resultset for CRUD-create message (doc without id)
2434 # 5. Assert resultset for CRUD-read message
2435
2436 ## II. Validate simple resultset with warnings
2437 #
2438 # 1. Assert one resultsets for select queries
2439
2440 #
2441 # I.1
2442 send Mysqlx.Crud.Delete {
2443 collection {
2444 name: "coll"
2445 }
2446 data_model: DOCUMENT
2447 criteria {
2448 type: OPERATOR
2449 operator {
2450 name: "=="
2451 param {
2452 type: IDENT
2453 identifier {
2454 document_path {
2455 type: MEMBER
2456 value: "name"
2457 }
2458 }
2459 }
2460 param {
2461 type: LITERAL
2462 literal {
2463 type: V_OCTETS
2464 v_octets {
2465 value: "fifth"
2466 }
2467 }
2468 }
2469 }
2470 }
2471 }
2472
2473 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2474 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2475
2476 #
2477 # I.2
2478 send Mysqlx.Crud.Update {
2479 collection {
2480 name: "coll"
2481 }
2482 data_model: DOCUMENT
2483 operation {
2484 source {
2485 document_path {
2486 type: MEMBER
2487 value: "prio"
2488 }
2489 }
2490 operation: ITEM_SET
2491 value {
2492 type: OPERATOR
2493 operator {
2494 name: "-"
2495 param {
2496 type: IDENT
2497 identifier {
2498 document_path {
2499 type: MEMBER
2500 value: "prio"
2501 }
2502 }
2503 }
2504 param {
2505 type: LITERAL
2506 literal {
2507 type: V_SINT
2508 v_signed_int: 1
2509 }
2510 }
2511 }
2512 }
2513 }
2514 }
2515
2516 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
2517 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
2518 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2519
2520 #
2521 # I.3
2522 send Mysqlx.Crud.Insert {
2523 collection {
2524 name: "coll"
2525 schema: "xtest"
2526 }
2527 data_model: DOCUMENT
2528 row {
2529 field {
2530 type: LITERAL
2531 literal {
2532 type: V_OCTETS
2533 v_octets {
2534 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
2535 content_type: 2
2536 }
2537 }
2538 }
2539 }
2540 upsert: false
2541 }
2542
2543 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2544 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2545
2546 #
2547 # I.4
2548 send Mysqlx.Crud.Insert {
2549 collection {
2550 name: "coll"
2551 schema: "xtest"
2552 }
2553 data_model: DOCUMENT
2554 row {
2555 field {
2556 type: LITERAL
2557 literal {
2558 type: V_OCTETS
2559 v_octets {
2560 value: "{\"name\":\"sixth\", \"prio\":3}"
2561 content_type: 2
2562 }
2563 }
2564 }
2565 }
2566 upsert: false
2567 }
2568
2569 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2570 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
2571 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2572
2573 #
2574 # I.5
2575 send Mysqlx.Crud.Find {
2576 collection {
2577 name: "coll"
2578 }
2579 data_model: DOCUMENT
2580 projection {
2581 source {
2582 type: IDENT
2583 identifier {
2584 document_path {
2585 type: MEMBER
2586 value: "name"
2587 }
2588 }
2589 }
2590 alias: "name"
2591 }
2592 }
2593
2594 [ASSERT Mysqlx.Resultset.ColumnMetaData]
2595 [ASSERT Mysqlx.Resultset.Row]
2596 [ASSERT Mysqlx.Resultset.Row]
2597 [ASSERT Mysqlx.Resultset.Row]
2598 [ASSERT Mysqlx.Resultset.Row]
2599 [ASSERT Mysqlx.Resultset.Row]
2600 [ASSERT Mysqlx.Resultset.FetchDone]
2601 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2602
2603 #
2604 # II.1
2605 send Mysqlx.Crud.Find {
2606 collection {
2607 name: "coll"
2608 }
2609 data_model: DOCUMENT
2610 projection {
2611 source {
2612 type: OPERATOR
2613 operator {
2614 name: "/"
2615 param {
2616 type: LITERAL
2617 literal {
2618 type: V_SINT
2619 v_signed_int: 1
2620 }
2621 }
2622 param {
2623 type: IDENT
2624 identifier {
2625 document_path {
2626 type: MEMBER
2627 value: "prio"
2628 }
2629 }
2630 }
2631 }
2632 }
2633 alias: "name"
2634 }
2635 }
2636
2637 [ASSERT Mysqlx.Resultset.ColumnMetaData]
2638 [ASSERT Mysqlx.Resultset.Row]
2639 [ASSERT Mysqlx.Resultset.Row]
2640 [ASSERT Mysqlx.Resultset.Row]
2641 [ASSERT Mysqlx.Resultset.Row]
2642 [ASSERT Mysqlx.Resultset.Row]
2643 [ASSERT Mysqlx.Resultset.FetchDone]
2644 [ASSERT notice warning - WARNING, 1365]
2645 [ASSERT notice warning - WARNING, 1365]
2646 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2647 Mysqlx.Ok {
2648 msg: "bye!"
2649 }
2650 ok
2651 ## I. Execute the test using zstd/single
2652 #
2653
2654
2655 ## Test setup
2656 RUN DROP TABLE IF EXISTS xtest.coll
2657
2658 0 rows affected
2659
2660 command ok
2661 send Mysqlx.Crud.Insert {
2662 collection {
2663 name: "coll"
2664 schema: "xtest"
2665 }
2666 data_model: DOCUMENT
2667 row {
2668 field {
2669 type: LITERAL
2670 literal {
2671 type: V_OCTETS
2672 v_octets {
2673 value: "{\"_id\": \"1\", \"name\":\"first\", \"prio\":1}"
2674 content_type: 2
2675 }
2676 }
2677 }
2678 }
2679 upsert: false
2680 }
2681
2682
2683 1 rows affected
2684 Got expected error (code 0)
2685 send Mysqlx.Crud.Insert {
2686 collection {
2687 name: "coll"
2688 schema: "xtest"
2689 }
2690 data_model: DOCUMENT
2691 row {
2692 field {
2693 type: LITERAL
2694 literal {
2695 type: V_OCTETS
2696 v_octets {
2697 value: "{\"_id\": \"2\", \"name\":\"second\", \"prio\":2}"
2698 content_type: 2
2699 }
2700 }
2701 }
2702 }
2703 upsert: false
2704 }
2705
2706
2707 1 rows affected
2708 Got expected error (code 0)
2709 send Mysqlx.Crud.Insert {
2710 collection {
2711 name: "coll"
2712 schema: "xtest"
2713 }
2714 data_model: DOCUMENT
2715 row {
2716 field {
2717 type: LITERAL
2718 literal {
2719 type: V_OCTETS
2720 v_octets {
2721 value: "{\"_id\": \"3\", \"name\":\"third\", \"prio\":1}"
2722 content_type: 2
2723 }
2724 }
2725 }
2726 }
2727 upsert: false
2728 }
2729
2730
2731 1 rows affected
2732 Got expected error (code 0)
2733 send Mysqlx.Crud.Insert {
2734 collection {
2735 name: "coll"
2736 schema: "xtest"
2737 }
2738 data_model: DOCUMENT
2739 row {
2740 field {
2741 type: LITERAL
2742 literal {
2743 type: V_OCTETS
2744 v_octets {
2745 value: "{\"_id\": \"5\", \"name\":\"fifth\", \"prio\":4}"
2746 content_type: 2
2747 }
2748 }
2749 }
2750 }
2751 upsert: false
2752 }
2753
2754
2755 1 rows affected
2756 Got expected error (code 0)
2757
2758
2759 ## I. Validate simple resultsets for CRUD messages
2760 #
2761 # 1. Assert resultset for CRUD-delete message
2762 # 2. Assert resultset for CRUD-update message
2763 # 3. Assert resultset for CRUD-create message (doc with id)
2764 # 4. Assert resultset for CRUD-create message (doc without id)
2765 # 5. Assert resultset for CRUD-read message
2766
2767 ## II. Validate simple resultset with warnings
2768 #
2769 # 1. Assert one resultsets for select queries
2770
2771 #
2772 # I.1
2773 send Mysqlx.Crud.Delete {
2774 collection {
2775 name: "coll"
2776 }
2777 data_model: DOCUMENT
2778 criteria {
2779 type: OPERATOR
2780 operator {
2781 name: "=="
2782 param {
2783 type: IDENT
2784 identifier {
2785 document_path {
2786 type: MEMBER
2787 value: "name"
2788 }
2789 }
2790 }
2791 param {
2792 type: LITERAL
2793 literal {
2794 type: V_OCTETS
2795 v_octets {
2796 value: "fifth"
2797 }
2798 }
2799 }
2800 }
2801 }
2802 }
2803
2804 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2805 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2806
2807 #
2808 # I.2
2809 send Mysqlx.Crud.Update {
2810 collection {
2811 name: "coll"
2812 }
2813 data_model: DOCUMENT
2814 operation {
2815 source {
2816 document_path {
2817 type: MEMBER
2818 value: "prio"
2819 }
2820 }
2821 operation: ITEM_SET
2822 value {
2823 type: OPERATOR
2824 operator {
2825 name: "-"
2826 param {
2827 type: IDENT
2828 identifier {
2829 document_path {
2830 type: MEMBER
2831 value: "prio"
2832 }
2833 }
2834 }
2835 param {
2836 type: LITERAL
2837 literal {
2838 type: V_SINT
2839 v_signed_int: 1
2840 }
2841 }
2842 }
2843 }
2844 }
2845 }
2846
2847 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
2848 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
2849 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2850
2851 #
2852 # I.3
2853 send Mysqlx.Crud.Insert {
2854 collection {
2855 name: "coll"
2856 schema: "xtest"
2857 }
2858 data_model: DOCUMENT
2859 row {
2860 field {
2861 type: LITERAL
2862 literal {
2863 type: V_OCTETS
2864 v_octets {
2865 value: "{\"_id\": \"6\", \"name\":\"sixth\", \"prio\":3}"
2866 content_type: 2
2867 }
2868 }
2869 }
2870 }
2871 upsert: false
2872 }
2873
2874 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2875 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2876
2877 #
2878 # I.4
2879 send Mysqlx.Crud.Insert {
2880 collection {
2881 name: "coll"
2882 schema: "xtest"
2883 }
2884 data_model: DOCUMENT
2885 row {
2886 field {
2887 type: LITERAL
2888 literal {
2889 type: V_OCTETS
2890 v_octets {
2891 value: "{\"name\":\"sixth\", \"prio\":3}"
2892 content_type: 2
2893 }
2894 }
2895 }
2896 }
2897 upsert: false
2898 }
2899
2900 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
2901 [ASSERT notice session state change - GENERATED_DOCUMENT_IDS, type: V_OCTETS]
2902 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2903
2904 #
2905 # I.5
2906 send Mysqlx.Crud.Find {
2907 collection {
2908 name: "coll"
2909 }
2910 data_model: DOCUMENT
2911 projection {
2912 source {
2913 type: IDENT
2914 identifier {
2915 document_path {
2916 type: MEMBER
2917 value: "name"
2918 }
2919 }
2920 }
2921 alias: "name"
2922 }
2923 }
2924
2925 [ASSERT Mysqlx.Resultset.ColumnMetaData]
2926 [ASSERT Mysqlx.Resultset.Row]
2927 [ASSERT Mysqlx.Resultset.Row]
2928 [ASSERT Mysqlx.Resultset.Row]
2929 [ASSERT Mysqlx.Resultset.Row]
2930 [ASSERT Mysqlx.Resultset.Row]
2931 [ASSERT Mysqlx.Resultset.FetchDone]
2932 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2933
2934 #
2935 # II.1
2936 send Mysqlx.Crud.Find {
2937 collection {
2938 name: "coll"
2939 }
2940 data_model: DOCUMENT
2941 projection {
2942 source {
2943 type: OPERATOR
2944 operator {
2945 name: "/"
2946 param {
2947 type: LITERAL
2948 literal {
2949 type: V_SINT
2950 v_signed_int: 1
2951 }
2952 }
2953 param {
2954 type: IDENT
2955 identifier {
2956 document_path {
2957 type: MEMBER
2958 value: "prio"
2959 }
2960 }
2961 }
2962 }
2963 }
2964 alias: "name"
2965 }
2966 }
2967
2968 [ASSERT Mysqlx.Resultset.ColumnMetaData]
2969 [ASSERT Mysqlx.Resultset.Row]
2970 [ASSERT Mysqlx.Resultset.Row]
2971 [ASSERT Mysqlx.Resultset.Row]
2972 [ASSERT Mysqlx.Resultset.Row]
2973 [ASSERT Mysqlx.Resultset.Row]
2974 [ASSERT Mysqlx.Resultset.FetchDone]
2975 [ASSERT notice warning - WARNING, 1365]
2976 [ASSERT notice warning - WARNING, 1365]
2977 [ASSERT Mysqlx.Sql.StmtExecuteOk]
2978 Mysqlx.Ok {
2979 msg: "bye!"
2980 }
2981 ok