Debian Codegraph @

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

raw
1 CREATE SCHEMA IF NOT EXISTS xtest;
2 USE xtest;
3 CREATE PROCEDURE recreate_tables()
4 BEGIN
5 CREATE TABLE IF NOT EXISTS xtable (phrase VARCHAR(30), prio INTEGER);
6 TRUNCATE TABLE xtable;
7 INSERT INTO xtable (phrase, prio) VALUES ('Alice has a cat', 1);
8 INSERT INTO xtable (phrase, prio) VALUES ('Bob has a dog 1', 2);
9 INSERT INTO xtable (phrase, prio) VALUES ('Peppa has a teddy', 1);
10 INSERT INTO xtable (phrase, prio) VALUES ('Bob has a dog 2', 3);
11 INSERT INTO xtable (phrase, prio) VALUES ('Row to delete', 4);
12 CREATE TABLE IF NOT EXISTS xtable_with_pk (p_id INTEGER AUTO_INCREMENT PRIMARY KEY, description varchar(40));
13 TRUNCATE TABLE xtable_with_pk;
14 INSERT INTO xtable_with_pk (description) VALUES ('MyRow');
15 END //
16 ## A. Execute the test using zlib/group
17 #
18 CALL recreate_tables();
19
20
21 ## Test setup
22
23
24 ## I. Validate simple resultsets for CRUD messages
25 #
26 # 1. Assert resultset for CRUD-delete message
27 # 2. Assert resultset for CRUD-update message
28 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
29 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
30 # 5. Assert resultset for CRUD-read message
31
32 ## II. Validate simple resultset with warnings
33 #
34 # 1. Assert one resultsets for select queries
35
36 #
37 # I.1
38 send Mysqlx.Crud.Delete {
39 collection {
40 name: "xtable"
41 }
42 data_model: TABLE
43 criteria {
44 type: OPERATOR
45 operator {
46 name: "=="
47 param {
48 type: IDENT
49 identifier {
50 name: "prio"
51 }
52 }
53 param {
54 type: LITERAL
55 literal {
56 type: V_SINT
57 v_signed_int: 3
58 }
59 }
60 }
61 }
62 }
63
64 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
65 [ASSERT Mysqlx.Sql.StmtExecuteOk]
66
67 #
68 # I.2
69 send Mysqlx.Crud.Update {
70 collection {
71 name: "xtable"
72 }
73 data_model: TABLE
74 operation {
75 source {
76 name: "prio"
77 }
78 operation: SET
79 value {
80 type: OPERATOR
81 operator {
82 name: "-"
83 param {
84 type: IDENT
85 identifier {
86 name: "prio"
87 }
88 }
89 param {
90 type: LITERAL
91 literal {
92 type: V_SINT
93 v_signed_int: 1
94 }
95 }
96 }
97 }
98 }
99 }
100
101 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
102 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
103 [ASSERT Mysqlx.Sql.StmtExecuteOk]
104
105 #
106 # I.3
107 send Mysqlx.Crud.Insert {
108 collection {
109 name: "xtable"
110 }
111 data_model: TABLE
112 row {
113 field {
114 type: LITERAL
115 literal {
116 type: V_STRING
117 v_string {
118 value: "sixth"
119 }
120 }
121 }
122 field {
123 type: LITERAL
124 literal {
125 type: V_SINT
126 v_signed_int: 3
127 }
128 }
129 }
130 upsert: false
131 }
132
133 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
134 [ASSERT Mysqlx.Sql.StmtExecuteOk]
135
136 #
137 # I.4
138 send Mysqlx.Crud.Insert {
139 collection {
140 name: "xtable_with_pk"
141 }
142 data_model: TABLE
143 projection {
144 name: "description"
145 }
146 row {
147 field {
148 type: LITERAL
149 literal {
150 type: V_STRING
151 v_string {
152 value: "test"
153 }
154 }
155 }
156 }
157 upsert: false
158 }
159
160 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
161 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
162 [ASSERT Mysqlx.Sql.StmtExecuteOk]
163
164 #
165 # I.5
166 send Mysqlx.Crud.Find {
167 collection {
168 name: "xtable"
169 }
170 data_model: TABLE
171 projection {
172 source {
173 type: IDENT
174 identifier {
175 name: "prio"
176 }
177 }
178 alias: "prio"
179 }
180 }
181
182 [ASSERT Mysqlx.Resultset.ColumnMetaData]
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.FetchDone]
189 [ASSERT Mysqlx.Sql.StmtExecuteOk]
190
191 #
192 # II.1
193 send Mysqlx.Crud.Find {
194 collection {
195 name: "xtable"
196 }
197 data_model: TABLE
198 projection {
199 source {
200 type: OPERATOR
201 operator {
202 name: "/"
203 param {
204 type: LITERAL
205 literal {
206 type: V_SINT
207 v_signed_int: 1
208 }
209 }
210 param {
211 type: IDENT
212 identifier {
213 name: "prio"
214 }
215 }
216 }
217 }
218 alias: "name"
219 }
220 }
221
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.FetchDone]
229 [ASSERT notice warning - WARNING, 1365]
230 [ASSERT notice warning - WARNING, 1365]
231 [ASSERT Mysqlx.Sql.StmtExecuteOk]
232 Mysqlx.Ok {
233 msg: "bye!"
234 }
235 ok
236 ## B. Execute the test using zlib/multiple
237 #
238 CALL recreate_tables();
239
240
241 ## Test setup
242
243
244 ## I. Validate simple resultsets for CRUD messages
245 #
246 # 1. Assert resultset for CRUD-delete message
247 # 2. Assert resultset for CRUD-update message
248 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
249 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
250 # 5. Assert resultset for CRUD-read message
251
252 ## II. Validate simple resultset with warnings
253 #
254 # 1. Assert one resultsets for select queries
255
256 #
257 # I.1
258 send Mysqlx.Crud.Delete {
259 collection {
260 name: "xtable"
261 }
262 data_model: TABLE
263 criteria {
264 type: OPERATOR
265 operator {
266 name: "=="
267 param {
268 type: IDENT
269 identifier {
270 name: "prio"
271 }
272 }
273 param {
274 type: LITERAL
275 literal {
276 type: V_SINT
277 v_signed_int: 3
278 }
279 }
280 }
281 }
282 }
283
284 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
285 [ASSERT Mysqlx.Sql.StmtExecuteOk]
286
287 #
288 # I.2
289 send Mysqlx.Crud.Update {
290 collection {
291 name: "xtable"
292 }
293 data_model: TABLE
294 operation {
295 source {
296 name: "prio"
297 }
298 operation: SET
299 value {
300 type: OPERATOR
301 operator {
302 name: "-"
303 param {
304 type: IDENT
305 identifier {
306 name: "prio"
307 }
308 }
309 param {
310 type: LITERAL
311 literal {
312 type: V_SINT
313 v_signed_int: 1
314 }
315 }
316 }
317 }
318 }
319 }
320
321 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
322 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
323 [ASSERT Mysqlx.Sql.StmtExecuteOk]
324
325 #
326 # I.3
327 send Mysqlx.Crud.Insert {
328 collection {
329 name: "xtable"
330 }
331 data_model: TABLE
332 row {
333 field {
334 type: LITERAL
335 literal {
336 type: V_STRING
337 v_string {
338 value: "sixth"
339 }
340 }
341 }
342 field {
343 type: LITERAL
344 literal {
345 type: V_SINT
346 v_signed_int: 3
347 }
348 }
349 }
350 upsert: false
351 }
352
353 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
354 [ASSERT Mysqlx.Sql.StmtExecuteOk]
355
356 #
357 # I.4
358 send Mysqlx.Crud.Insert {
359 collection {
360 name: "xtable_with_pk"
361 }
362 data_model: TABLE
363 projection {
364 name: "description"
365 }
366 row {
367 field {
368 type: LITERAL
369 literal {
370 type: V_STRING
371 v_string {
372 value: "test"
373 }
374 }
375 }
376 }
377 upsert: false
378 }
379
380 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
381 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
382 [ASSERT Mysqlx.Sql.StmtExecuteOk]
383
384 #
385 # I.5
386 send Mysqlx.Crud.Find {
387 collection {
388 name: "xtable"
389 }
390 data_model: TABLE
391 projection {
392 source {
393 type: IDENT
394 identifier {
395 name: "prio"
396 }
397 }
398 alias: "prio"
399 }
400 }
401
402 [ASSERT Mysqlx.Resultset.ColumnMetaData]
403 [ASSERT Mysqlx.Resultset.Row]
404 [ASSERT Mysqlx.Resultset.Row]
405 [ASSERT Mysqlx.Resultset.Row]
406 [ASSERT Mysqlx.Resultset.Row]
407 [ASSERT Mysqlx.Resultset.Row]
408 [ASSERT Mysqlx.Resultset.FetchDone]
409 [ASSERT Mysqlx.Sql.StmtExecuteOk]
410
411 #
412 # II.1
413 send Mysqlx.Crud.Find {
414 collection {
415 name: "xtable"
416 }
417 data_model: TABLE
418 projection {
419 source {
420 type: OPERATOR
421 operator {
422 name: "/"
423 param {
424 type: LITERAL
425 literal {
426 type: V_SINT
427 v_signed_int: 1
428 }
429 }
430 param {
431 type: IDENT
432 identifier {
433 name: "prio"
434 }
435 }
436 }
437 }
438 alias: "name"
439 }
440 }
441
442 [ASSERT Mysqlx.Resultset.ColumnMetaData]
443 [ASSERT Mysqlx.Resultset.Row]
444 [ASSERT Mysqlx.Resultset.Row]
445 [ASSERT Mysqlx.Resultset.Row]
446 [ASSERT Mysqlx.Resultset.Row]
447 [ASSERT Mysqlx.Resultset.Row]
448 [ASSERT Mysqlx.Resultset.FetchDone]
449 [ASSERT notice warning - WARNING, 1365]
450 [ASSERT notice warning - WARNING, 1365]
451 [ASSERT Mysqlx.Sql.StmtExecuteOk]
452 Mysqlx.Ok {
453 msg: "bye!"
454 }
455 ok
456 ## C. Execute the test using zlib/single
457 #
458 CALL recreate_tables();
459
460
461 ## Test setup
462
463
464 ## I. Validate simple resultsets for CRUD messages
465 #
466 # 1. Assert resultset for CRUD-delete message
467 # 2. Assert resultset for CRUD-update message
468 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
469 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
470 # 5. Assert resultset for CRUD-read message
471
472 ## II. Validate simple resultset with warnings
473 #
474 # 1. Assert one resultsets for select queries
475
476 #
477 # I.1
478 send Mysqlx.Crud.Delete {
479 collection {
480 name: "xtable"
481 }
482 data_model: TABLE
483 criteria {
484 type: OPERATOR
485 operator {
486 name: "=="
487 param {
488 type: IDENT
489 identifier {
490 name: "prio"
491 }
492 }
493 param {
494 type: LITERAL
495 literal {
496 type: V_SINT
497 v_signed_int: 3
498 }
499 }
500 }
501 }
502 }
503
504 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
505 [ASSERT Mysqlx.Sql.StmtExecuteOk]
506
507 #
508 # I.2
509 send Mysqlx.Crud.Update {
510 collection {
511 name: "xtable"
512 }
513 data_model: TABLE
514 operation {
515 source {
516 name: "prio"
517 }
518 operation: SET
519 value {
520 type: OPERATOR
521 operator {
522 name: "-"
523 param {
524 type: IDENT
525 identifier {
526 name: "prio"
527 }
528 }
529 param {
530 type: LITERAL
531 literal {
532 type: V_SINT
533 v_signed_int: 1
534 }
535 }
536 }
537 }
538 }
539 }
540
541 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
542 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
543 [ASSERT Mysqlx.Sql.StmtExecuteOk]
544
545 #
546 # I.3
547 send Mysqlx.Crud.Insert {
548 collection {
549 name: "xtable"
550 }
551 data_model: TABLE
552 row {
553 field {
554 type: LITERAL
555 literal {
556 type: V_STRING
557 v_string {
558 value: "sixth"
559 }
560 }
561 }
562 field {
563 type: LITERAL
564 literal {
565 type: V_SINT
566 v_signed_int: 3
567 }
568 }
569 }
570 upsert: false
571 }
572
573 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
574 [ASSERT Mysqlx.Sql.StmtExecuteOk]
575
576 #
577 # I.4
578 send Mysqlx.Crud.Insert {
579 collection {
580 name: "xtable_with_pk"
581 }
582 data_model: TABLE
583 projection {
584 name: "description"
585 }
586 row {
587 field {
588 type: LITERAL
589 literal {
590 type: V_STRING
591 v_string {
592 value: "test"
593 }
594 }
595 }
596 }
597 upsert: false
598 }
599
600 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
601 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
602 [ASSERT Mysqlx.Sql.StmtExecuteOk]
603
604 #
605 # I.5
606 send Mysqlx.Crud.Find {
607 collection {
608 name: "xtable"
609 }
610 data_model: TABLE
611 projection {
612 source {
613 type: IDENT
614 identifier {
615 name: "prio"
616 }
617 }
618 alias: "prio"
619 }
620 }
621
622 [ASSERT Mysqlx.Resultset.ColumnMetaData]
623 [ASSERT Mysqlx.Resultset.Row]
624 [ASSERT Mysqlx.Resultset.Row]
625 [ASSERT Mysqlx.Resultset.Row]
626 [ASSERT Mysqlx.Resultset.Row]
627 [ASSERT Mysqlx.Resultset.Row]
628 [ASSERT Mysqlx.Resultset.FetchDone]
629 [ASSERT Mysqlx.Sql.StmtExecuteOk]
630
631 #
632 # II.1
633 send Mysqlx.Crud.Find {
634 collection {
635 name: "xtable"
636 }
637 data_model: TABLE
638 projection {
639 source {
640 type: OPERATOR
641 operator {
642 name: "/"
643 param {
644 type: LITERAL
645 literal {
646 type: V_SINT
647 v_signed_int: 1
648 }
649 }
650 param {
651 type: IDENT
652 identifier {
653 name: "prio"
654 }
655 }
656 }
657 }
658 alias: "name"
659 }
660 }
661
662 [ASSERT Mysqlx.Resultset.ColumnMetaData]
663 [ASSERT Mysqlx.Resultset.Row]
664 [ASSERT Mysqlx.Resultset.Row]
665 [ASSERT Mysqlx.Resultset.Row]
666 [ASSERT Mysqlx.Resultset.Row]
667 [ASSERT Mysqlx.Resultset.Row]
668 [ASSERT Mysqlx.Resultset.FetchDone]
669 [ASSERT notice warning - WARNING, 1365]
670 [ASSERT notice warning - WARNING, 1365]
671 [ASSERT Mysqlx.Sql.StmtExecuteOk]
672 Mysqlx.Ok {
673 msg: "bye!"
674 }
675 ok
676 ## D. Execute the test using lz4/group
677 #
678 CALL recreate_tables();
679
680
681 ## Test setup
682
683
684 ## I. Validate simple resultsets for CRUD messages
685 #
686 # 1. Assert resultset for CRUD-delete message
687 # 2. Assert resultset for CRUD-update message
688 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
689 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
690 # 5. Assert resultset for CRUD-read message
691
692 ## II. Validate simple resultset with warnings
693 #
694 # 1. Assert one resultsets for select queries
695
696 #
697 # I.1
698 send Mysqlx.Crud.Delete {
699 collection {
700 name: "xtable"
701 }
702 data_model: TABLE
703 criteria {
704 type: OPERATOR
705 operator {
706 name: "=="
707 param {
708 type: IDENT
709 identifier {
710 name: "prio"
711 }
712 }
713 param {
714 type: LITERAL
715 literal {
716 type: V_SINT
717 v_signed_int: 3
718 }
719 }
720 }
721 }
722 }
723
724 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
725 [ASSERT Mysqlx.Sql.StmtExecuteOk]
726
727 #
728 # I.2
729 send Mysqlx.Crud.Update {
730 collection {
731 name: "xtable"
732 }
733 data_model: TABLE
734 operation {
735 source {
736 name: "prio"
737 }
738 operation: SET
739 value {
740 type: OPERATOR
741 operator {
742 name: "-"
743 param {
744 type: IDENT
745 identifier {
746 name: "prio"
747 }
748 }
749 param {
750 type: LITERAL
751 literal {
752 type: V_SINT
753 v_signed_int: 1
754 }
755 }
756 }
757 }
758 }
759 }
760
761 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
762 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
763 [ASSERT Mysqlx.Sql.StmtExecuteOk]
764
765 #
766 # I.3
767 send Mysqlx.Crud.Insert {
768 collection {
769 name: "xtable"
770 }
771 data_model: TABLE
772 row {
773 field {
774 type: LITERAL
775 literal {
776 type: V_STRING
777 v_string {
778 value: "sixth"
779 }
780 }
781 }
782 field {
783 type: LITERAL
784 literal {
785 type: V_SINT
786 v_signed_int: 3
787 }
788 }
789 }
790 upsert: false
791 }
792
793 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
794 [ASSERT Mysqlx.Sql.StmtExecuteOk]
795
796 #
797 # I.4
798 send Mysqlx.Crud.Insert {
799 collection {
800 name: "xtable_with_pk"
801 }
802 data_model: TABLE
803 projection {
804 name: "description"
805 }
806 row {
807 field {
808 type: LITERAL
809 literal {
810 type: V_STRING
811 v_string {
812 value: "test"
813 }
814 }
815 }
816 }
817 upsert: false
818 }
819
820 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
821 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
822 [ASSERT Mysqlx.Sql.StmtExecuteOk]
823
824 #
825 # I.5
826 send Mysqlx.Crud.Find {
827 collection {
828 name: "xtable"
829 }
830 data_model: TABLE
831 projection {
832 source {
833 type: IDENT
834 identifier {
835 name: "prio"
836 }
837 }
838 alias: "prio"
839 }
840 }
841
842 [ASSERT Mysqlx.Resultset.ColumnMetaData]
843 [ASSERT Mysqlx.Resultset.Row]
844 [ASSERT Mysqlx.Resultset.Row]
845 [ASSERT Mysqlx.Resultset.Row]
846 [ASSERT Mysqlx.Resultset.Row]
847 [ASSERT Mysqlx.Resultset.Row]
848 [ASSERT Mysqlx.Resultset.FetchDone]
849 [ASSERT Mysqlx.Sql.StmtExecuteOk]
850
851 #
852 # II.1
853 send Mysqlx.Crud.Find {
854 collection {
855 name: "xtable"
856 }
857 data_model: TABLE
858 projection {
859 source {
860 type: OPERATOR
861 operator {
862 name: "/"
863 param {
864 type: LITERAL
865 literal {
866 type: V_SINT
867 v_signed_int: 1
868 }
869 }
870 param {
871 type: IDENT
872 identifier {
873 name: "prio"
874 }
875 }
876 }
877 }
878 alias: "name"
879 }
880 }
881
882 [ASSERT Mysqlx.Resultset.ColumnMetaData]
883 [ASSERT Mysqlx.Resultset.Row]
884 [ASSERT Mysqlx.Resultset.Row]
885 [ASSERT Mysqlx.Resultset.Row]
886 [ASSERT Mysqlx.Resultset.Row]
887 [ASSERT Mysqlx.Resultset.Row]
888 [ASSERT Mysqlx.Resultset.FetchDone]
889 [ASSERT notice warning - WARNING, 1365]
890 [ASSERT notice warning - WARNING, 1365]
891 [ASSERT Mysqlx.Sql.StmtExecuteOk]
892 Mysqlx.Ok {
893 msg: "bye!"
894 }
895 ok
896 ## E. Execute the test using lz4/multiple
897 #
898 CALL recreate_tables();
899
900
901 ## Test setup
902
903
904 ## I. Validate simple resultsets for CRUD messages
905 #
906 # 1. Assert resultset for CRUD-delete message
907 # 2. Assert resultset for CRUD-update message
908 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
909 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
910 # 5. Assert resultset for CRUD-read message
911
912 ## II. Validate simple resultset with warnings
913 #
914 # 1. Assert one resultsets for select queries
915
916 #
917 # I.1
918 send Mysqlx.Crud.Delete {
919 collection {
920 name: "xtable"
921 }
922 data_model: TABLE
923 criteria {
924 type: OPERATOR
925 operator {
926 name: "=="
927 param {
928 type: IDENT
929 identifier {
930 name: "prio"
931 }
932 }
933 param {
934 type: LITERAL
935 literal {
936 type: V_SINT
937 v_signed_int: 3
938 }
939 }
940 }
941 }
942 }
943
944 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
945 [ASSERT Mysqlx.Sql.StmtExecuteOk]
946
947 #
948 # I.2
949 send Mysqlx.Crud.Update {
950 collection {
951 name: "xtable"
952 }
953 data_model: TABLE
954 operation {
955 source {
956 name: "prio"
957 }
958 operation: SET
959 value {
960 type: OPERATOR
961 operator {
962 name: "-"
963 param {
964 type: IDENT
965 identifier {
966 name: "prio"
967 }
968 }
969 param {
970 type: LITERAL
971 literal {
972 type: V_SINT
973 v_signed_int: 1
974 }
975 }
976 }
977 }
978 }
979 }
980
981 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
982 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
983 [ASSERT Mysqlx.Sql.StmtExecuteOk]
984
985 #
986 # I.3
987 send Mysqlx.Crud.Insert {
988 collection {
989 name: "xtable"
990 }
991 data_model: TABLE
992 row {
993 field {
994 type: LITERAL
995 literal {
996 type: V_STRING
997 v_string {
998 value: "sixth"
999 }
1000 }
1001 }
1002 field {
1003 type: LITERAL
1004 literal {
1005 type: V_SINT
1006 v_signed_int: 3
1007 }
1008 }
1009 }
1010 upsert: false
1011 }
1012
1013 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1014 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1015
1016 #
1017 # I.4
1018 send Mysqlx.Crud.Insert {
1019 collection {
1020 name: "xtable_with_pk"
1021 }
1022 data_model: TABLE
1023 projection {
1024 name: "description"
1025 }
1026 row {
1027 field {
1028 type: LITERAL
1029 literal {
1030 type: V_STRING
1031 v_string {
1032 value: "test"
1033 }
1034 }
1035 }
1036 }
1037 upsert: false
1038 }
1039
1040 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1041 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1042 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1043
1044 #
1045 # I.5
1046 send Mysqlx.Crud.Find {
1047 collection {
1048 name: "xtable"
1049 }
1050 data_model: TABLE
1051 projection {
1052 source {
1053 type: IDENT
1054 identifier {
1055 name: "prio"
1056 }
1057 }
1058 alias: "prio"
1059 }
1060 }
1061
1062 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1063 [ASSERT Mysqlx.Resultset.Row]
1064 [ASSERT Mysqlx.Resultset.Row]
1065 [ASSERT Mysqlx.Resultset.Row]
1066 [ASSERT Mysqlx.Resultset.Row]
1067 [ASSERT Mysqlx.Resultset.Row]
1068 [ASSERT Mysqlx.Resultset.FetchDone]
1069 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1070
1071 #
1072 # II.1
1073 send Mysqlx.Crud.Find {
1074 collection {
1075 name: "xtable"
1076 }
1077 data_model: TABLE
1078 projection {
1079 source {
1080 type: OPERATOR
1081 operator {
1082 name: "/"
1083 param {
1084 type: LITERAL
1085 literal {
1086 type: V_SINT
1087 v_signed_int: 1
1088 }
1089 }
1090 param {
1091 type: IDENT
1092 identifier {
1093 name: "prio"
1094 }
1095 }
1096 }
1097 }
1098 alias: "name"
1099 }
1100 }
1101
1102 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1103 [ASSERT Mysqlx.Resultset.Row]
1104 [ASSERT Mysqlx.Resultset.Row]
1105 [ASSERT Mysqlx.Resultset.Row]
1106 [ASSERT Mysqlx.Resultset.Row]
1107 [ASSERT Mysqlx.Resultset.Row]
1108 [ASSERT Mysqlx.Resultset.FetchDone]
1109 [ASSERT notice warning - WARNING, 1365]
1110 [ASSERT notice warning - WARNING, 1365]
1111 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1112 Mysqlx.Ok {
1113 msg: "bye!"
1114 }
1115 ok
1116 ## F. Execute the test using lz4/single
1117 #
1118 CALL recreate_tables();
1119
1120
1121 ## Test setup
1122
1123
1124 ## I. Validate simple resultsets for CRUD messages
1125 #
1126 # 1. Assert resultset for CRUD-delete message
1127 # 2. Assert resultset for CRUD-update message
1128 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
1129 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
1130 # 5. Assert resultset for CRUD-read message
1131
1132 ## II. Validate simple resultset with warnings
1133 #
1134 # 1. Assert one resultsets for select queries
1135
1136 #
1137 # I.1
1138 send Mysqlx.Crud.Delete {
1139 collection {
1140 name: "xtable"
1141 }
1142 data_model: TABLE
1143 criteria {
1144 type: OPERATOR
1145 operator {
1146 name: "=="
1147 param {
1148 type: IDENT
1149 identifier {
1150 name: "prio"
1151 }
1152 }
1153 param {
1154 type: LITERAL
1155 literal {
1156 type: V_SINT
1157 v_signed_int: 3
1158 }
1159 }
1160 }
1161 }
1162 }
1163
1164 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1165 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1166
1167 #
1168 # I.2
1169 send Mysqlx.Crud.Update {
1170 collection {
1171 name: "xtable"
1172 }
1173 data_model: TABLE
1174 operation {
1175 source {
1176 name: "prio"
1177 }
1178 operation: SET
1179 value {
1180 type: OPERATOR
1181 operator {
1182 name: "-"
1183 param {
1184 type: IDENT
1185 identifier {
1186 name: "prio"
1187 }
1188 }
1189 param {
1190 type: LITERAL
1191 literal {
1192 type: V_SINT
1193 v_signed_int: 1
1194 }
1195 }
1196 }
1197 }
1198 }
1199 }
1200
1201 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1202 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
1203 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1204
1205 #
1206 # I.3
1207 send Mysqlx.Crud.Insert {
1208 collection {
1209 name: "xtable"
1210 }
1211 data_model: TABLE
1212 row {
1213 field {
1214 type: LITERAL
1215 literal {
1216 type: V_STRING
1217 v_string {
1218 value: "sixth"
1219 }
1220 }
1221 }
1222 field {
1223 type: LITERAL
1224 literal {
1225 type: V_SINT
1226 v_signed_int: 3
1227 }
1228 }
1229 }
1230 upsert: false
1231 }
1232
1233 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1234 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1235
1236 #
1237 # I.4
1238 send Mysqlx.Crud.Insert {
1239 collection {
1240 name: "xtable_with_pk"
1241 }
1242 data_model: TABLE
1243 projection {
1244 name: "description"
1245 }
1246 row {
1247 field {
1248 type: LITERAL
1249 literal {
1250 type: V_STRING
1251 v_string {
1252 value: "test"
1253 }
1254 }
1255 }
1256 }
1257 upsert: false
1258 }
1259
1260 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1261 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1262 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1263
1264 #
1265 # I.5
1266 send Mysqlx.Crud.Find {
1267 collection {
1268 name: "xtable"
1269 }
1270 data_model: TABLE
1271 projection {
1272 source {
1273 type: IDENT
1274 identifier {
1275 name: "prio"
1276 }
1277 }
1278 alias: "prio"
1279 }
1280 }
1281
1282 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1283 [ASSERT Mysqlx.Resultset.Row]
1284 [ASSERT Mysqlx.Resultset.Row]
1285 [ASSERT Mysqlx.Resultset.Row]
1286 [ASSERT Mysqlx.Resultset.Row]
1287 [ASSERT Mysqlx.Resultset.Row]
1288 [ASSERT Mysqlx.Resultset.FetchDone]
1289 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1290
1291 #
1292 # II.1
1293 send Mysqlx.Crud.Find {
1294 collection {
1295 name: "xtable"
1296 }
1297 data_model: TABLE
1298 projection {
1299 source {
1300 type: OPERATOR
1301 operator {
1302 name: "/"
1303 param {
1304 type: LITERAL
1305 literal {
1306 type: V_SINT
1307 v_signed_int: 1
1308 }
1309 }
1310 param {
1311 type: IDENT
1312 identifier {
1313 name: "prio"
1314 }
1315 }
1316 }
1317 }
1318 alias: "name"
1319 }
1320 }
1321
1322 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1323 [ASSERT Mysqlx.Resultset.Row]
1324 [ASSERT Mysqlx.Resultset.Row]
1325 [ASSERT Mysqlx.Resultset.Row]
1326 [ASSERT Mysqlx.Resultset.Row]
1327 [ASSERT Mysqlx.Resultset.Row]
1328 [ASSERT Mysqlx.Resultset.FetchDone]
1329 [ASSERT notice warning - WARNING, 1365]
1330 [ASSERT notice warning - WARNING, 1365]
1331 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1332 Mysqlx.Ok {
1333 msg: "bye!"
1334 }
1335 ok
1336 ## G. Execute the test using zstd/group
1337 #
1338 CALL recreate_tables();
1339
1340
1341 ## Test setup
1342
1343
1344 ## I. Validate simple resultsets for CRUD messages
1345 #
1346 # 1. Assert resultset for CRUD-delete message
1347 # 2. Assert resultset for CRUD-update message
1348 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
1349 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
1350 # 5. Assert resultset for CRUD-read message
1351
1352 ## II. Validate simple resultset with warnings
1353 #
1354 # 1. Assert one resultsets for select queries
1355
1356 #
1357 # I.1
1358 send Mysqlx.Crud.Delete {
1359 collection {
1360 name: "xtable"
1361 }
1362 data_model: TABLE
1363 criteria {
1364 type: OPERATOR
1365 operator {
1366 name: "=="
1367 param {
1368 type: IDENT
1369 identifier {
1370 name: "prio"
1371 }
1372 }
1373 param {
1374 type: LITERAL
1375 literal {
1376 type: V_SINT
1377 v_signed_int: 3
1378 }
1379 }
1380 }
1381 }
1382 }
1383
1384 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1385 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1386
1387 #
1388 # I.2
1389 send Mysqlx.Crud.Update {
1390 collection {
1391 name: "xtable"
1392 }
1393 data_model: TABLE
1394 operation {
1395 source {
1396 name: "prio"
1397 }
1398 operation: SET
1399 value {
1400 type: OPERATOR
1401 operator {
1402 name: "-"
1403 param {
1404 type: IDENT
1405 identifier {
1406 name: "prio"
1407 }
1408 }
1409 param {
1410 type: LITERAL
1411 literal {
1412 type: V_SINT
1413 v_signed_int: 1
1414 }
1415 }
1416 }
1417 }
1418 }
1419 }
1420
1421 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1422 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
1423 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1424
1425 #
1426 # I.3
1427 send Mysqlx.Crud.Insert {
1428 collection {
1429 name: "xtable"
1430 }
1431 data_model: TABLE
1432 row {
1433 field {
1434 type: LITERAL
1435 literal {
1436 type: V_STRING
1437 v_string {
1438 value: "sixth"
1439 }
1440 }
1441 }
1442 field {
1443 type: LITERAL
1444 literal {
1445 type: V_SINT
1446 v_signed_int: 3
1447 }
1448 }
1449 }
1450 upsert: false
1451 }
1452
1453 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1454 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1455
1456 #
1457 # I.4
1458 send Mysqlx.Crud.Insert {
1459 collection {
1460 name: "xtable_with_pk"
1461 }
1462 data_model: TABLE
1463 projection {
1464 name: "description"
1465 }
1466 row {
1467 field {
1468 type: LITERAL
1469 literal {
1470 type: V_STRING
1471 v_string {
1472 value: "test"
1473 }
1474 }
1475 }
1476 }
1477 upsert: false
1478 }
1479
1480 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1481 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1482 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1483
1484 #
1485 # I.5
1486 send Mysqlx.Crud.Find {
1487 collection {
1488 name: "xtable"
1489 }
1490 data_model: TABLE
1491 projection {
1492 source {
1493 type: IDENT
1494 identifier {
1495 name: "prio"
1496 }
1497 }
1498 alias: "prio"
1499 }
1500 }
1501
1502 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1503 [ASSERT Mysqlx.Resultset.Row]
1504 [ASSERT Mysqlx.Resultset.Row]
1505 [ASSERT Mysqlx.Resultset.Row]
1506 [ASSERT Mysqlx.Resultset.Row]
1507 [ASSERT Mysqlx.Resultset.Row]
1508 [ASSERT Mysqlx.Resultset.FetchDone]
1509 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1510
1511 #
1512 # II.1
1513 send Mysqlx.Crud.Find {
1514 collection {
1515 name: "xtable"
1516 }
1517 data_model: TABLE
1518 projection {
1519 source {
1520 type: OPERATOR
1521 operator {
1522 name: "/"
1523 param {
1524 type: LITERAL
1525 literal {
1526 type: V_SINT
1527 v_signed_int: 1
1528 }
1529 }
1530 param {
1531 type: IDENT
1532 identifier {
1533 name: "prio"
1534 }
1535 }
1536 }
1537 }
1538 alias: "name"
1539 }
1540 }
1541
1542 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1543 [ASSERT Mysqlx.Resultset.Row]
1544 [ASSERT Mysqlx.Resultset.Row]
1545 [ASSERT Mysqlx.Resultset.Row]
1546 [ASSERT Mysqlx.Resultset.Row]
1547 [ASSERT Mysqlx.Resultset.Row]
1548 [ASSERT Mysqlx.Resultset.FetchDone]
1549 [ASSERT notice warning - WARNING, 1365]
1550 [ASSERT notice warning - WARNING, 1365]
1551 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1552 Mysqlx.Ok {
1553 msg: "bye!"
1554 }
1555 ok
1556 ## H. Execute the test using zstd/multiple
1557 #
1558 CALL recreate_tables();
1559
1560
1561 ## Test setup
1562
1563
1564 ## I. Validate simple resultsets for CRUD messages
1565 #
1566 # 1. Assert resultset for CRUD-delete message
1567 # 2. Assert resultset for CRUD-update message
1568 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
1569 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
1570 # 5. Assert resultset for CRUD-read message
1571
1572 ## II. Validate simple resultset with warnings
1573 #
1574 # 1. Assert one resultsets for select queries
1575
1576 #
1577 # I.1
1578 send Mysqlx.Crud.Delete {
1579 collection {
1580 name: "xtable"
1581 }
1582 data_model: TABLE
1583 criteria {
1584 type: OPERATOR
1585 operator {
1586 name: "=="
1587 param {
1588 type: IDENT
1589 identifier {
1590 name: "prio"
1591 }
1592 }
1593 param {
1594 type: LITERAL
1595 literal {
1596 type: V_SINT
1597 v_signed_int: 3
1598 }
1599 }
1600 }
1601 }
1602 }
1603
1604 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1605 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1606
1607 #
1608 # I.2
1609 send Mysqlx.Crud.Update {
1610 collection {
1611 name: "xtable"
1612 }
1613 data_model: TABLE
1614 operation {
1615 source {
1616 name: "prio"
1617 }
1618 operation: SET
1619 value {
1620 type: OPERATOR
1621 operator {
1622 name: "-"
1623 param {
1624 type: IDENT
1625 identifier {
1626 name: "prio"
1627 }
1628 }
1629 param {
1630 type: LITERAL
1631 literal {
1632 type: V_SINT
1633 v_signed_int: 1
1634 }
1635 }
1636 }
1637 }
1638 }
1639 }
1640
1641 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1642 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
1643 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1644
1645 #
1646 # I.3
1647 send Mysqlx.Crud.Insert {
1648 collection {
1649 name: "xtable"
1650 }
1651 data_model: TABLE
1652 row {
1653 field {
1654 type: LITERAL
1655 literal {
1656 type: V_STRING
1657 v_string {
1658 value: "sixth"
1659 }
1660 }
1661 }
1662 field {
1663 type: LITERAL
1664 literal {
1665 type: V_SINT
1666 v_signed_int: 3
1667 }
1668 }
1669 }
1670 upsert: false
1671 }
1672
1673 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1674 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1675
1676 #
1677 # I.4
1678 send Mysqlx.Crud.Insert {
1679 collection {
1680 name: "xtable_with_pk"
1681 }
1682 data_model: TABLE
1683 projection {
1684 name: "description"
1685 }
1686 row {
1687 field {
1688 type: LITERAL
1689 literal {
1690 type: V_STRING
1691 v_string {
1692 value: "test"
1693 }
1694 }
1695 }
1696 }
1697 upsert: false
1698 }
1699
1700 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1701 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1702 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1703
1704 #
1705 # I.5
1706 send Mysqlx.Crud.Find {
1707 collection {
1708 name: "xtable"
1709 }
1710 data_model: TABLE
1711 projection {
1712 source {
1713 type: IDENT
1714 identifier {
1715 name: "prio"
1716 }
1717 }
1718 alias: "prio"
1719 }
1720 }
1721
1722 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1723 [ASSERT Mysqlx.Resultset.Row]
1724 [ASSERT Mysqlx.Resultset.Row]
1725 [ASSERT Mysqlx.Resultset.Row]
1726 [ASSERT Mysqlx.Resultset.Row]
1727 [ASSERT Mysqlx.Resultset.Row]
1728 [ASSERT Mysqlx.Resultset.FetchDone]
1729 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1730
1731 #
1732 # II.1
1733 send Mysqlx.Crud.Find {
1734 collection {
1735 name: "xtable"
1736 }
1737 data_model: TABLE
1738 projection {
1739 source {
1740 type: OPERATOR
1741 operator {
1742 name: "/"
1743 param {
1744 type: LITERAL
1745 literal {
1746 type: V_SINT
1747 v_signed_int: 1
1748 }
1749 }
1750 param {
1751 type: IDENT
1752 identifier {
1753 name: "prio"
1754 }
1755 }
1756 }
1757 }
1758 alias: "name"
1759 }
1760 }
1761
1762 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1763 [ASSERT Mysqlx.Resultset.Row]
1764 [ASSERT Mysqlx.Resultset.Row]
1765 [ASSERT Mysqlx.Resultset.Row]
1766 [ASSERT Mysqlx.Resultset.Row]
1767 [ASSERT Mysqlx.Resultset.Row]
1768 [ASSERT Mysqlx.Resultset.FetchDone]
1769 [ASSERT notice warning - WARNING, 1365]
1770 [ASSERT notice warning - WARNING, 1365]
1771 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1772 Mysqlx.Ok {
1773 msg: "bye!"
1774 }
1775 ok
1776 ## I. Execute the test using zstd/single
1777 #
1778 CALL recreate_tables();
1779
1780
1781 ## Test setup
1782
1783
1784 ## I. Validate simple resultsets for CRUD messages
1785 #
1786 # 1. Assert resultset for CRUD-delete message
1787 # 2. Assert resultset for CRUD-update message
1788 # 3. Assert resultset for CRUD-create message (table with auto_inc column)
1789 # 4. Assert resultset for CRUD-create message (table without auto_inc column)
1790 # 5. Assert resultset for CRUD-read message
1791
1792 ## II. Validate simple resultset with warnings
1793 #
1794 # 1. Assert one resultsets for select queries
1795
1796 #
1797 # I.1
1798 send Mysqlx.Crud.Delete {
1799 collection {
1800 name: "xtable"
1801 }
1802 data_model: TABLE
1803 criteria {
1804 type: OPERATOR
1805 operator {
1806 name: "=="
1807 param {
1808 type: IDENT
1809 identifier {
1810 name: "prio"
1811 }
1812 }
1813 param {
1814 type: LITERAL
1815 literal {
1816 type: V_SINT
1817 v_signed_int: 3
1818 }
1819 }
1820 }
1821 }
1822 }
1823
1824 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1825 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1826
1827 #
1828 # I.2
1829 send Mysqlx.Crud.Update {
1830 collection {
1831 name: "xtable"
1832 }
1833 data_model: TABLE
1834 operation {
1835 source {
1836 name: "prio"
1837 }
1838 operation: SET
1839 value {
1840 type: OPERATOR
1841 operator {
1842 name: "-"
1843 param {
1844 type: IDENT
1845 identifier {
1846 name: "prio"
1847 }
1848 }
1849 param {
1850 type: LITERAL
1851 literal {
1852 type: V_SINT
1853 v_signed_int: 1
1854 }
1855 }
1856 }
1857 }
1858 }
1859 }
1860
1861 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1862 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:4]
1863 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1864
1865 #
1866 # I.3
1867 send Mysqlx.Crud.Insert {
1868 collection {
1869 name: "xtable"
1870 }
1871 data_model: TABLE
1872 row {
1873 field {
1874 type: LITERAL
1875 literal {
1876 type: V_STRING
1877 v_string {
1878 value: "sixth"
1879 }
1880 }
1881 }
1882 field {
1883 type: LITERAL
1884 literal {
1885 type: V_SINT
1886 v_signed_int: 3
1887 }
1888 }
1889 }
1890 upsert: false
1891 }
1892
1893 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1894 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1895
1896 #
1897 # I.4
1898 send Mysqlx.Crud.Insert {
1899 collection {
1900 name: "xtable_with_pk"
1901 }
1902 data_model: TABLE
1903 projection {
1904 name: "description"
1905 }
1906 row {
1907 field {
1908 type: LITERAL
1909 literal {
1910 type: V_STRING
1911 v_string {
1912 value: "test"
1913 }
1914 }
1915 }
1916 }
1917 upsert: false
1918 }
1919
1920 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1921 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1922 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1923
1924 #
1925 # I.5
1926 send Mysqlx.Crud.Find {
1927 collection {
1928 name: "xtable"
1929 }
1930 data_model: TABLE
1931 projection {
1932 source {
1933 type: IDENT
1934 identifier {
1935 name: "prio"
1936 }
1937 }
1938 alias: "prio"
1939 }
1940 }
1941
1942 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1943 [ASSERT Mysqlx.Resultset.Row]
1944 [ASSERT Mysqlx.Resultset.Row]
1945 [ASSERT Mysqlx.Resultset.Row]
1946 [ASSERT Mysqlx.Resultset.Row]
1947 [ASSERT Mysqlx.Resultset.Row]
1948 [ASSERT Mysqlx.Resultset.FetchDone]
1949 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1950
1951 #
1952 # II.1
1953 send Mysqlx.Crud.Find {
1954 collection {
1955 name: "xtable"
1956 }
1957 data_model: TABLE
1958 projection {
1959 source {
1960 type: OPERATOR
1961 operator {
1962 name: "/"
1963 param {
1964 type: LITERAL
1965 literal {
1966 type: V_SINT
1967 v_signed_int: 1
1968 }
1969 }
1970 param {
1971 type: IDENT
1972 identifier {
1973 name: "prio"
1974 }
1975 }
1976 }
1977 }
1978 alias: "name"
1979 }
1980 }
1981
1982 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1983 [ASSERT Mysqlx.Resultset.Row]
1984 [ASSERT Mysqlx.Resultset.Row]
1985 [ASSERT Mysqlx.Resultset.Row]
1986 [ASSERT Mysqlx.Resultset.Row]
1987 [ASSERT Mysqlx.Resultset.Row]
1988 [ASSERT Mysqlx.Resultset.FetchDone]
1989 [ASSERT notice warning - WARNING, 1365]
1990 [ASSERT notice warning - WARNING, 1365]
1991 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1992 Mysqlx.Ok {
1993 msg: "bye!"
1994 }
1995 ok