Debian Codegraph @

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

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