Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest;
2 CREATE TABLE xtest.xtable (doc JSON);
3 INSERT INTO xtest.xtable (doc) VALUES
4 ('{"scalar_10":10,
5 "scalar_40":40,
6 "scalar_red":"red",
7 "scalar_banana":"banana",
8 "scalar_true":true,
9 "array_10_20_30":[10,20,30],
10 "array_red_green_pear":["red","green","pear"],
11 "array_true_false":[true, false],
12 "object_scalar_10":{"scalar_10":10},
13 "object_scalar_red":{"scalar_red":"red"}}');
14
15 Numeric literal in numeric literal
16 ----------------------------------
17 send Mysqlx.Crud.Find {
18 collection {
19 name: "xtable"
20 schema: "xtest"
21 }
22 data_model: TABLE
23 projection {
24 source {
25 type: OPERATOR
26 operator {
27 name: "cont_in"
28 param {
29 type: LITERAL
30 literal {
31 type: V_SINT
32 v_signed_int: 10
33 }
34 }
35 param {
36 type: LITERAL
37 literal {
38 type: V_SINT
39 v_signed_int: 10
40 }
41 }
42 }
43 }
44 alias: "cont_in"
45 }
46 projection {
47 source {
48 type: OPERATOR
49 operator {
50 name: "not_cont_in"
51 param {
52 type: LITERAL
53 literal {
54 type: V_SINT
55 v_signed_int: 10
56 }
57 }
58 param {
59 type: LITERAL
60 literal {
61 type: V_SINT
62 v_signed_int: 10
63 }
64 }
65 }
66 }
67 alias: "not_cont_in"
68 }
69 }
70
71 cont_in not_cont_in
72 1 0
73 command ok
74 Got expected error (code 0)
75 send Mysqlx.Crud.Find {
76 collection {
77 name: "xtable"
78 schema: "xtest"
79 }
80 data_model: TABLE
81 projection {
82 source {
83 type: OPERATOR
84 operator {
85 name: "cont_in"
86 param {
87 type: LITERAL
88 literal {
89 type: V_SINT
90 v_signed_int: 40
91 }
92 }
93 param {
94 type: LITERAL
95 literal {
96 type: V_SINT
97 v_signed_int: 10
98 }
99 }
100 }
101 }
102 alias: "cont_in"
103 }
104 projection {
105 source {
106 type: OPERATOR
107 operator {
108 name: "not_cont_in"
109 param {
110 type: LITERAL
111 literal {
112 type: V_SINT
113 v_signed_int: 40
114 }
115 }
116 param {
117 type: LITERAL
118 literal {
119 type: V_SINT
120 v_signed_int: 10
121 }
122 }
123 }
124 }
125 alias: "not_cont_in"
126 }
127 }
128
129 cont_in not_cont_in
130 0 1
131 command ok
132 Got expected error (code 0)
133
134 Numeric literal in literal array
135 --------------------------------
136 send Mysqlx.Crud.Find {
137 collection {
138 name: "xtable"
139 schema: "xtest"
140 }
141 data_model: TABLE
142 projection {
143 source {
144 type: OPERATOR
145 operator {
146 name: "cont_in"
147 param {
148 type: LITERAL
149 literal {
150 type: V_SINT
151 v_signed_int: 10
152 }
153 }
154 param {
155 type: ARRAY
156 array {
157 value {
158 type: LITERAL
159 literal {
160 type: V_SINT
161 v_signed_int: 10
162 }
163 }
164 value {
165 type: LITERAL
166 literal {
167 type: V_SINT
168 v_signed_int: 20
169 }
170 }
171 value {
172 type: LITERAL
173 literal {
174 type: V_SINT
175 v_signed_int: 30
176 }
177 }
178 }
179 }
180 }
181 }
182 alias: "cont_in"
183 }
184 projection {
185 source {
186 type: OPERATOR
187 operator {
188 name: "not_cont_in"
189 param {
190 type: LITERAL
191 literal {
192 type: V_SINT
193 v_signed_int: 10
194 }
195 }
196 param {
197 type: ARRAY
198 array {
199 value {
200 type: LITERAL
201 literal {
202 type: V_SINT
203 v_signed_int: 10
204 }
205 }
206 value {
207 type: LITERAL
208 literal {
209 type: V_SINT
210 v_signed_int: 20
211 }
212 }
213 value {
214 type: LITERAL
215 literal {
216 type: V_SINT
217 v_signed_int: 30
218 }
219 }
220 }
221 }
222 }
223 }
224 alias: "not_cont_in"
225 }
226 }
227
228 cont_in not_cont_in
229 1 0
230 command ok
231 Got expected error (code 0)
232 send Mysqlx.Crud.Find {
233 collection {
234 name: "xtable"
235 schema: "xtest"
236 }
237 data_model: TABLE
238 projection {
239 source {
240 type: OPERATOR
241 operator {
242 name: "cont_in"
243 param {
244 type: LITERAL
245 literal {
246 type: V_SINT
247 v_signed_int: 40
248 }
249 }
250 param {
251 type: ARRAY
252 array {
253 value {
254 type: LITERAL
255 literal {
256 type: V_SINT
257 v_signed_int: 10
258 }
259 }
260 value {
261 type: LITERAL
262 literal {
263 type: V_SINT
264 v_signed_int: 20
265 }
266 }
267 value {
268 type: LITERAL
269 literal {
270 type: V_SINT
271 v_signed_int: 30
272 }
273 }
274 }
275 }
276 }
277 }
278 alias: "cont_in"
279 }
280 projection {
281 source {
282 type: OPERATOR
283 operator {
284 name: "not_cont_in"
285 param {
286 type: LITERAL
287 literal {
288 type: V_SINT
289 v_signed_int: 40
290 }
291 }
292 param {
293 type: ARRAY
294 array {
295 value {
296 type: LITERAL
297 literal {
298 type: V_SINT
299 v_signed_int: 10
300 }
301 }
302 value {
303 type: LITERAL
304 literal {
305 type: V_SINT
306 v_signed_int: 20
307 }
308 }
309 value {
310 type: LITERAL
311 literal {
312 type: V_SINT
313 v_signed_int: 30
314 }
315 }
316 }
317 }
318 }
319 }
320 alias: "not_cont_in"
321 }
322 }
323
324 cont_in not_cont_in
325 0 1
326 command ok
327 Got expected error (code 0)
328
329 Bool literal in literal array
330 -----------------------------
331 send Mysqlx.Crud.Find {
332 collection {
333 name: "xtable"
334 schema: "xtest"
335 }
336 data_model: TABLE
337 projection {
338 source {
339 type: OPERATOR
340 operator {
341 name: "cont_in"
342 param {
343 type: LITERAL
344 literal {
345 type: V_BOOL
346 v_bool: true
347 }
348 }
349 param {
350 type: ARRAY
351 array {
352 value {
353 type: LITERAL
354 literal {
355 type: V_BOOL
356 v_bool: true
357 }
358 }
359 value {
360 type: LITERAL
361 literal {
362 type: V_BOOL
363 v_bool: false
364 }
365 }
366 }
367 }
368 }
369 }
370 alias: "cont_in"
371 }
372 projection {
373 source {
374 type: OPERATOR
375 operator {
376 name: "not_cont_in"
377 param {
378 type: LITERAL
379 literal {
380 type: V_BOOL
381 v_bool: true
382 }
383 }
384 param {
385 type: ARRAY
386 array {
387 value {
388 type: LITERAL
389 literal {
390 type: V_BOOL
391 v_bool: true
392 }
393 }
394 value {
395 type: LITERAL
396 literal {
397 type: V_BOOL
398 v_bool: false
399 }
400 }
401 }
402 }
403 }
404 }
405 alias: "not_cont_in"
406 }
407 }
408
409 cont_in not_cont_in
410 1 0
411 command ok
412 Got expected error (code 0)
413 send Mysqlx.Crud.Find {
414 collection {
415 name: "xtable"
416 schema: "xtest"
417 }
418 data_model: TABLE
419 projection {
420 source {
421 type: OPERATOR
422 operator {
423 name: "cont_in"
424 param {
425 type: LITERAL
426 literal {
427 type: V_SINT
428 v_signed_int: 40
429 }
430 }
431 param {
432 type: ARRAY
433 array {
434 value {
435 type: LITERAL
436 literal {
437 type: V_BOOL
438 v_bool: true
439 }
440 }
441 value {
442 type: LITERAL
443 literal {
444 type: V_BOOL
445 v_bool: false
446 }
447 }
448 }
449 }
450 }
451 }
452 alias: "cont_in"
453 }
454 projection {
455 source {
456 type: OPERATOR
457 operator {
458 name: "not_cont_in"
459 param {
460 type: LITERAL
461 literal {
462 type: V_SINT
463 v_signed_int: 40
464 }
465 }
466 param {
467 type: ARRAY
468 array {
469 value {
470 type: LITERAL
471 literal {
472 type: V_BOOL
473 v_bool: true
474 }
475 }
476 value {
477 type: LITERAL
478 literal {
479 type: V_BOOL
480 v_bool: false
481 }
482 }
483 }
484 }
485 }
486 }
487 alias: "not_cont_in"
488 }
489 }
490
491 cont_in not_cont_in
492 0 1
493 command ok
494 Got expected error (code 0)
495
496 String literal in string literal
497 --------------------------------
498 send Mysqlx.Crud.Find {
499 collection {
500 name: "xtable"
501 schema: "xtest"
502 }
503 data_model: TABLE
504 projection {
505 source {
506 type: OPERATOR
507 operator {
508 name: "cont_in"
509 param {
510 type: LITERAL
511 literal {
512 type: V_STRING
513 v_string {
514 value: "blue"
515 }
516 }
517 }
518 param {
519 type: LITERAL
520 literal {
521 type: V_STRING
522 v_string {
523 value: "blue"
524 }
525 }
526 }
527 }
528 }
529 alias: "cont_in"
530 }
531 projection {
532 source {
533 type: OPERATOR
534 operator {
535 name: "not_cont_in"
536 param {
537 type: LITERAL
538 literal {
539 type: V_STRING
540 v_string {
541 value: "blue"
542 }
543 }
544 }
545 param {
546 type: LITERAL
547 literal {
548 type: V_STRING
549 v_string {
550 value: "blue"
551 }
552 }
553 }
554 }
555 }
556 alias: "not_cont_in"
557 }
558 }
559
560 cont_in not_cont_in
561 1 0
562 command ok
563 Got expected error (code 0)
564 send Mysqlx.Crud.Find {
565 collection {
566 name: "xtable"
567 schema: "xtest"
568 }
569 data_model: TABLE
570 projection {
571 source {
572 type: OPERATOR
573 operator {
574 name: "cont_in"
575 param {
576 type: LITERAL
577 literal {
578 type: V_STRING
579 v_string {
580 value: "white"
581 }
582 }
583 }
584 param {
585 type: LITERAL
586 literal {
587 type: V_STRING
588 v_string {
589 value: "blue"
590 }
591 }
592 }
593 }
594 }
595 alias: "cont_in"
596 }
597 projection {
598 source {
599 type: OPERATOR
600 operator {
601 name: "not_cont_in"
602 param {
603 type: LITERAL
604 literal {
605 type: V_STRING
606 v_string {
607 value: "white"
608 }
609 }
610 }
611 param {
612 type: LITERAL
613 literal {
614 type: V_STRING
615 v_string {
616 value: "blue"
617 }
618 }
619 }
620 }
621 }
622 alias: "not_cont_in"
623 }
624 }
625
626 cont_in not_cont_in
627 0 1
628 command ok
629 Got expected error (code 0)
630
631 String literal in literal array
632 -------------------------------
633 send Mysqlx.Crud.Find {
634 collection {
635 name: "xtable"
636 schema: "xtest"
637 }
638 data_model: TABLE
639 projection {
640 source {
641 type: OPERATOR
642 operator {
643 name: "cont_in"
644 param {
645 type: LITERAL
646 literal {
647 type: V_STRING
648 v_string {
649 value: "blue"
650 }
651 }
652 }
653 param {
654 type: ARRAY
655 array {
656 value {
657 type: LITERAL
658 literal {
659 type: V_STRING
660 v_string {
661 value: "red"
662 }
663 }
664 }
665 value {
666 type: LITERAL
667 literal {
668 type: V_STRING
669 v_string {
670 value: "green"
671 }
672 }
673 }
674 value {
675 type: LITERAL
676 literal {
677 type: V_STRING
678 v_string {
679 value: "blue"
680 }
681 }
682 }
683 }
684 }
685 }
686 }
687 alias: "cont_in"
688 }
689 projection {
690 source {
691 type: OPERATOR
692 operator {
693 name: "not_cont_in"
694 param {
695 type: LITERAL
696 literal {
697 type: V_STRING
698 v_string {
699 value: "blue"
700 }
701 }
702 }
703 param {
704 type: ARRAY
705 array {
706 value {
707 type: LITERAL
708 literal {
709 type: V_STRING
710 v_string {
711 value: "red"
712 }
713 }
714 }
715 value {
716 type: LITERAL
717 literal {
718 type: V_STRING
719 v_string {
720 value: "green"
721 }
722 }
723 }
724 value {
725 type: LITERAL
726 literal {
727 type: V_STRING
728 v_string {
729 value: "blue"
730 }
731 }
732 }
733 }
734 }
735 }
736 }
737 alias: "not_cont_in"
738 }
739 }
740
741 cont_in not_cont_in
742 1 0
743 command ok
744 Got expected error (code 0)
745 send Mysqlx.Crud.Find {
746 collection {
747 name: "xtable"
748 schema: "xtest"
749 }
750 data_model: TABLE
751 projection {
752 source {
753 type: OPERATOR
754 operator {
755 name: "cont_in"
756 param {
757 type: LITERAL
758 literal {
759 type: V_STRING
760 v_string {
761 value: "white"
762 }
763 }
764 }
765 param {
766 type: ARRAY
767 array {
768 value {
769 type: LITERAL
770 literal {
771 type: V_STRING
772 v_string {
773 value: "red"
774 }
775 }
776 }
777 value {
778 type: LITERAL
779 literal {
780 type: V_STRING
781 v_string {
782 value: "green"
783 }
784 }
785 }
786 value {
787 type: LITERAL
788 literal {
789 type: V_STRING
790 v_string {
791 value: "blue"
792 }
793 }
794 }
795 }
796 }
797 }
798 }
799 alias: "cont_in"
800 }
801 projection {
802 source {
803 type: OPERATOR
804 operator {
805 name: "not_cont_in"
806 param {
807 type: LITERAL
808 literal {
809 type: V_STRING
810 v_string {
811 value: "white"
812 }
813 }
814 }
815 param {
816 type: ARRAY
817 array {
818 value {
819 type: LITERAL
820 literal {
821 type: V_STRING
822 v_string {
823 value: "red"
824 }
825 }
826 }
827 value {
828 type: LITERAL
829 literal {
830 type: V_STRING
831 v_string {
832 value: "green"
833 }
834 }
835 }
836 value {
837 type: LITERAL
838 literal {
839 type: V_STRING
840 v_string {
841 value: "blue"
842 }
843 }
844 }
845 }
846 }
847 }
848 }
849 alias: "not_cont_in"
850 }
851 }
852
853 cont_in not_cont_in
854 0 1
855 command ok
856 Got expected error (code 0)
857
858 Plain octets literal in literal array
859 -------------------------------------
860 send Mysqlx.Crud.Find {
861 collection {
862 name: "xtable"
863 schema: "xtest"
864 }
865 data_model: TABLE
866 projection {
867 source {
868 type: OPERATOR
869 operator {
870 name: "cont_in"
871 param {
872 type: LITERAL
873 literal {
874 type: V_OCTETS
875 v_octets {
876 value: "pear"
877 content_type: 0
878 }
879 }
880 }
881 param {
882 type: ARRAY
883 array {
884 value {
885 type: LITERAL
886 literal {
887 type: V_OCTETS
888 v_octets {
889 value: "apple"
890 content_type: 0
891 }
892 }
893 }
894 value {
895 type: LITERAL
896 literal {
897 type: V_OCTETS
898 v_octets {
899 value: "pear"
900 content_type: 0
901 }
902 }
903 }
904 value {
905 type: LITERAL
906 literal {
907 type: V_OCTETS
908 v_octets {
909 value: "plum"
910 content_type: 0
911 }
912 }
913 }
914 }
915 }
916 }
917 }
918 alias: "cont_in"
919 }
920 projection {
921 source {
922 type: OPERATOR
923 operator {
924 name: "not_cont_in"
925 param {
926 type: LITERAL
927 literal {
928 type: V_OCTETS
929 v_octets {
930 value: "pear"
931 content_type: 0
932 }
933 }
934 }
935 param {
936 type: ARRAY
937 array {
938 value {
939 type: LITERAL
940 literal {
941 type: V_OCTETS
942 v_octets {
943 value: "apple"
944 content_type: 0
945 }
946 }
947 }
948 value {
949 type: LITERAL
950 literal {
951 type: V_OCTETS
952 v_octets {
953 value: "pear"
954 content_type: 0
955 }
956 }
957 }
958 value {
959 type: LITERAL
960 literal {
961 type: V_OCTETS
962 v_octets {
963 value: "plum"
964 content_type: 0
965 }
966 }
967 }
968 }
969 }
970 }
971 }
972 alias: "not_cont_in"
973 }
974 }
975
976 cont_in not_cont_in
977 1 0
978 command ok
979 Got expected error (code 0)
980 send Mysqlx.Crud.Find {
981 collection {
982 name: "xtable"
983 schema: "xtest"
984 }
985 data_model: TABLE
986 projection {
987 source {
988 type: OPERATOR
989 operator {
990 name: "cont_in"
991 param {
992 type: LITERAL
993 literal {
994 type: V_OCTETS
995 v_octets {
996 value: "banana"
997 content_type: 0
998 }
999 }
1000 }
1001 param {
1002 type: ARRAY
1003 array {
1004 value {
1005 type: LITERAL
1006 literal {
1007 type: V_OCTETS
1008 v_octets {
1009 value: "apple"
1010 content_type: 0
1011 }
1012 }
1013 }
1014 value {
1015 type: LITERAL
1016 literal {
1017 type: V_OCTETS
1018 v_octets {
1019 value: "pear"
1020 content_type: 0
1021 }
1022 }
1023 }
1024 value {
1025 type: LITERAL
1026 literal {
1027 type: V_OCTETS
1028 v_octets {
1029 value: "plum"
1030 content_type: 0
1031 }
1032 }
1033 }
1034 }
1035 }
1036 }
1037 }
1038 alias: "cont_in"
1039 }
1040 projection {
1041 source {
1042 type: OPERATOR
1043 operator {
1044 name: "not_cont_in"
1045 param {
1046 type: LITERAL
1047 literal {
1048 type: V_OCTETS
1049 v_octets {
1050 value: "banana"
1051 content_type: 0
1052 }
1053 }
1054 }
1055 param {
1056 type: ARRAY
1057 array {
1058 value {
1059 type: LITERAL
1060 literal {
1061 type: V_OCTETS
1062 v_octets {
1063 value: "apple"
1064 content_type: 0
1065 }
1066 }
1067 }
1068 value {
1069 type: LITERAL
1070 literal {
1071 type: V_OCTETS
1072 v_octets {
1073 value: "pear"
1074 content_type: 0
1075 }
1076 }
1077 }
1078 value {
1079 type: LITERAL
1080 literal {
1081 type: V_OCTETS
1082 v_octets {
1083 value: "plum"
1084 content_type: 0
1085 }
1086 }
1087 }
1088 }
1089 }
1090 }
1091 }
1092 alias: "not_cont_in"
1093 }
1094 }
1095
1096 cont_in not_cont_in
1097 0 1
1098 command ok
1099 Got expected error (code 0)
1100
1101 Plain octets literal in literal octets
1102 --------------------------------------
1103 send Mysqlx.Crud.Find {
1104 collection {
1105 name: "xtable"
1106 schema: "xtest"
1107 }
1108 data_model: TABLE
1109 projection {
1110 source {
1111 type: OPERATOR
1112 operator {
1113 name: "cont_in"
1114 param {
1115 type: LITERAL
1116 literal {
1117 type: V_OCTETS
1118 v_octets {
1119 value: "pear"
1120 content_type: 0
1121 }
1122 }
1123 }
1124 param {
1125 type: LITERAL
1126 literal {
1127 type: V_OCTETS
1128 v_octets {
1129 value: "pear"
1130 content_type: 0
1131 }
1132 }
1133 }
1134 }
1135 }
1136 alias: "cont_in"
1137 }
1138 projection {
1139 source {
1140 type: OPERATOR
1141 operator {
1142 name: "not_cont_in"
1143 param {
1144 type: LITERAL
1145 literal {
1146 type: V_OCTETS
1147 v_octets {
1148 value: "pear"
1149 content_type: 0
1150 }
1151 }
1152 }
1153 param {
1154 type: LITERAL
1155 literal {
1156 type: V_OCTETS
1157 v_octets {
1158 value: "pear"
1159 content_type: 0
1160 }
1161 }
1162 }
1163 }
1164 }
1165 alias: "not_cont_in"
1166 }
1167 }
1168
1169 cont_in not_cont_in
1170 1 0
1171 command ok
1172 Got expected error (code 0)
1173 send Mysqlx.Crud.Find {
1174 collection {
1175 name: "xtable"
1176 schema: "xtest"
1177 }
1178 data_model: TABLE
1179 projection {
1180 source {
1181 type: OPERATOR
1182 operator {
1183 name: "cont_in"
1184 param {
1185 type: LITERAL
1186 literal {
1187 type: V_OCTETS
1188 v_octets {
1189 value: "banana"
1190 content_type: 0
1191 }
1192 }
1193 }
1194 param {
1195 type: LITERAL
1196 literal {
1197 type: V_OCTETS
1198 v_octets {
1199 value: "pear"
1200 content_type: 0
1201 }
1202 }
1203 }
1204 }
1205 }
1206 alias: "cont_in"
1207 }
1208 projection {
1209 source {
1210 type: OPERATOR
1211 operator {
1212 name: "not_cont_in"
1213 param {
1214 type: LITERAL
1215 literal {
1216 type: V_OCTETS
1217 v_octets {
1218 value: "banana"
1219 content_type: 0
1220 }
1221 }
1222 }
1223 param {
1224 type: LITERAL
1225 literal {
1226 type: V_OCTETS
1227 v_octets {
1228 value: "pear"
1229 content_type: 0
1230 }
1231 }
1232 }
1233 }
1234 }
1235 alias: "not_cont_in"
1236 }
1237 }
1238
1239 cont_in not_cont_in
1240 0 1
1241 command ok
1242 Got expected error (code 0)
1243
1244 Literal bool literal in literal bool
1245 ------------------------------------
1246 send Mysqlx.Crud.Find {
1247 collection {
1248 name: "xtable"
1249 schema: "xtest"
1250 }
1251 data_model: TABLE
1252 projection {
1253 source {
1254 type: OPERATOR
1255 operator {
1256 name: "cont_in"
1257 param {
1258 type: LITERAL
1259 literal {
1260 type: V_BOOL
1261 v_bool: true
1262 }
1263 }
1264 param {
1265 type: LITERAL
1266 literal {
1267 type: V_BOOL
1268 v_bool: true
1269 }
1270 }
1271 }
1272 }
1273 alias: "cont_in"
1274 }
1275 projection {
1276 source {
1277 type: OPERATOR
1278 operator {
1279 name: "not_cont_in"
1280 param {
1281 type: LITERAL
1282 literal {
1283 type: V_BOOL
1284 v_bool: true
1285 }
1286 }
1287 param {
1288 type: LITERAL
1289 literal {
1290 type: V_BOOL
1291 v_bool: true
1292 }
1293 }
1294 }
1295 }
1296 alias: "not_cont_in"
1297 }
1298 }
1299
1300 cont_in not_cont_in
1301 1 0
1302 command ok
1303 Got expected error (code 0)
1304 send Mysqlx.Crud.Find {
1305 collection {
1306 name: "xtable"
1307 schema: "xtest"
1308 }
1309 data_model: TABLE
1310 projection {
1311 source {
1312 type: OPERATOR
1313 operator {
1314 name: "cont_in"
1315 param {
1316 type: LITERAL
1317 literal {
1318 type: V_BOOL
1319 v_bool: false
1320 }
1321 }
1322 param {
1323 type: LITERAL
1324 literal {
1325 type: V_BOOL
1326 v_bool: true
1327 }
1328 }
1329 }
1330 }
1331 alias: "cont_in"
1332 }
1333 projection {
1334 source {
1335 type: OPERATOR
1336 operator {
1337 name: "not_cont_in"
1338 param {
1339 type: LITERAL
1340 literal {
1341 type: V_BOOL
1342 v_bool: false
1343 }
1344 }
1345 param {
1346 type: LITERAL
1347 literal {
1348 type: V_BOOL
1349 v_bool: true
1350 }
1351 }
1352 }
1353 }
1354 alias: "not_cont_in"
1355 }
1356 }
1357
1358 cont_in not_cont_in
1359 0 1
1360 command ok
1361 Got expected error (code 0)
1362
1363 Numeric literal in json octets array
1364 ------------------------------------
1365 send Mysqlx.Crud.Find {
1366 collection {
1367 name: "xtable"
1368 schema: "xtest"
1369 }
1370 data_model: TABLE
1371 projection {
1372 source {
1373 type: OPERATOR
1374 operator {
1375 name: "cont_in"
1376 param {
1377 type: LITERAL
1378 literal {
1379 type: V_SINT
1380 v_signed_int: 10
1381 }
1382 }
1383 param {
1384 type: LITERAL
1385 literal {
1386 type: V_OCTETS
1387 v_octets {
1388 value: "[10, 20, 30]"
1389 content_type: 2
1390 }
1391 }
1392 }
1393 }
1394 }
1395 alias: "cont_in"
1396 }
1397 projection {
1398 source {
1399 type: OPERATOR
1400 operator {
1401 name: "not_cont_in"
1402 param {
1403 type: LITERAL
1404 literal {
1405 type: V_SINT
1406 v_signed_int: 10
1407 }
1408 }
1409 param {
1410 type: LITERAL
1411 literal {
1412 type: V_OCTETS
1413 v_octets {
1414 value: "[10, 20, 30]"
1415 content_type: 2
1416 }
1417 }
1418 }
1419 }
1420 }
1421 alias: "not_cont_in"
1422 }
1423 }
1424
1425 cont_in not_cont_in
1426 1 0
1427 command ok
1428 Got expected error (code 0)
1429 send Mysqlx.Crud.Find {
1430 collection {
1431 name: "xtable"
1432 schema: "xtest"
1433 }
1434 data_model: TABLE
1435 projection {
1436 source {
1437 type: OPERATOR
1438 operator {
1439 name: "cont_in"
1440 param {
1441 type: LITERAL
1442 literal {
1443 type: V_SINT
1444 v_signed_int: 40
1445 }
1446 }
1447 param {
1448 type: LITERAL
1449 literal {
1450 type: V_OCTETS
1451 v_octets {
1452 value: "[10, 20, 30]"
1453 content_type: 2
1454 }
1455 }
1456 }
1457 }
1458 }
1459 alias: "cont_in"
1460 }
1461 projection {
1462 source {
1463 type: OPERATOR
1464 operator {
1465 name: "not_cont_in"
1466 param {
1467 type: LITERAL
1468 literal {
1469 type: V_SINT
1470 v_signed_int: 40
1471 }
1472 }
1473 param {
1474 type: LITERAL
1475 literal {
1476 type: V_OCTETS
1477 v_octets {
1478 value: "[10, 20, 30]"
1479 content_type: 2
1480 }
1481 }
1482 }
1483 }
1484 }
1485 alias: "not_cont_in"
1486 }
1487 }
1488
1489 cont_in not_cont_in
1490 0 1
1491 command ok
1492 Got expected error (code 0)
1493
1494 Bool literal in json octets array
1495 ---------------------------------
1496 send Mysqlx.Crud.Find {
1497 collection {
1498 name: "xtable"
1499 schema: "xtest"
1500 }
1501 data_model: TABLE
1502 projection {
1503 source {
1504 type: OPERATOR
1505 operator {
1506 name: "cont_in"
1507 param {
1508 type: LITERAL
1509 literal {
1510 type: V_BOOL
1511 v_bool: true
1512 }
1513 }
1514 param {
1515 type: LITERAL
1516 literal {
1517 type: V_OCTETS
1518 v_octets {
1519 value: "[true, false]"
1520 content_type: 2
1521 }
1522 }
1523 }
1524 }
1525 }
1526 alias: "cont_in"
1527 }
1528 projection {
1529 source {
1530 type: OPERATOR
1531 operator {
1532 name: "not_cont_in"
1533 param {
1534 type: LITERAL
1535 literal {
1536 type: V_BOOL
1537 v_bool: true
1538 }
1539 }
1540 param {
1541 type: LITERAL
1542 literal {
1543 type: V_OCTETS
1544 v_octets {
1545 value: "[true, false]"
1546 content_type: 2
1547 }
1548 }
1549 }
1550 }
1551 }
1552 alias: "not_cont_in"
1553 }
1554 }
1555
1556 cont_in not_cont_in
1557 1 0
1558 command ok
1559 Got expected error (code 0)
1560 send Mysqlx.Crud.Find {
1561 collection {
1562 name: "xtable"
1563 schema: "xtest"
1564 }
1565 data_model: TABLE
1566 projection {
1567 source {
1568 type: OPERATOR
1569 operator {
1570 name: "cont_in"
1571 param {
1572 type: LITERAL
1573 literal {
1574 type: V_SINT
1575 v_signed_int: 10
1576 }
1577 }
1578 param {
1579 type: LITERAL
1580 literal {
1581 type: V_OCTETS
1582 v_octets {
1583 value: "[true, false]"
1584 content_type: 2
1585 }
1586 }
1587 }
1588 }
1589 }
1590 alias: "cont_in"
1591 }
1592 projection {
1593 source {
1594 type: OPERATOR
1595 operator {
1596 name: "not_cont_in"
1597 param {
1598 type: LITERAL
1599 literal {
1600 type: V_SINT
1601 v_signed_int: 10
1602 }
1603 }
1604 param {
1605 type: LITERAL
1606 literal {
1607 type: V_OCTETS
1608 v_octets {
1609 value: "[true, false]"
1610 content_type: 2
1611 }
1612 }
1613 }
1614 }
1615 }
1616 alias: "not_cont_in"
1617 }
1618 }
1619
1620 cont_in not_cont_in
1621 0 1
1622 command ok
1623 Got expected error (code 0)
1624
1625 String literal in json octets array
1626 -----------------------------------
1627 send Mysqlx.Crud.Find {
1628 collection {
1629 name: "xtable"
1630 schema: "xtest"
1631 }
1632 data_model: TABLE
1633 projection {
1634 source {
1635 type: OPERATOR
1636 operator {
1637 name: "cont_in"
1638 param {
1639 type: LITERAL
1640 literal {
1641 type: V_STRING
1642 v_string {
1643 value: "blue"
1644 }
1645 }
1646 }
1647 param {
1648 type: LITERAL
1649 literal {
1650 type: V_OCTETS
1651 v_octets {
1652 value: "[\"red\", \"green\", \"blue\"]"
1653 content_type: 2
1654 }
1655 }
1656 }
1657 }
1658 }
1659 alias: "cont_in"
1660 }
1661 projection {
1662 source {
1663 type: OPERATOR
1664 operator {
1665 name: "not_cont_in"
1666 param {
1667 type: LITERAL
1668 literal {
1669 type: V_STRING
1670 v_string {
1671 value: "blue"
1672 }
1673 }
1674 }
1675 param {
1676 type: LITERAL
1677 literal {
1678 type: V_OCTETS
1679 v_octets {
1680 value: "[\"red\", \"green\", \"blue\"]"
1681 content_type: 2
1682 }
1683 }
1684 }
1685 }
1686 }
1687 alias: "not_cont_in"
1688 }
1689 }
1690
1691 cont_in not_cont_in
1692 1 0
1693 command ok
1694 Got expected error (code 0)
1695 send Mysqlx.Crud.Find {
1696 collection {
1697 name: "xtable"
1698 schema: "xtest"
1699 }
1700 data_model: TABLE
1701 projection {
1702 source {
1703 type: OPERATOR
1704 operator {
1705 name: "cont_in"
1706 param {
1707 type: LITERAL
1708 literal {
1709 type: V_STRING
1710 v_string {
1711 value: "white"
1712 }
1713 }
1714 }
1715 param {
1716 type: LITERAL
1717 literal {
1718 type: V_OCTETS
1719 v_octets {
1720 value: "[\"red\", \"green\", \"blue\"]"
1721 content_type: 2
1722 }
1723 }
1724 }
1725 }
1726 }
1727 alias: "cont_in"
1728 }
1729 projection {
1730 source {
1731 type: OPERATOR
1732 operator {
1733 name: "not_cont_in"
1734 param {
1735 type: LITERAL
1736 literal {
1737 type: V_STRING
1738 v_string {
1739 value: "white"
1740 }
1741 }
1742 }
1743 param {
1744 type: LITERAL
1745 literal {
1746 type: V_OCTETS
1747 v_octets {
1748 value: "[\"red\", \"green\", \"blue\"]"
1749 content_type: 2
1750 }
1751 }
1752 }
1753 }
1754 }
1755 alias: "not_cont_in"
1756 }
1757 }
1758
1759 cont_in not_cont_in
1760 0 1
1761 command ok
1762 Got expected error (code 0)
1763
1764 Numeric literal in member
1765 -------------------------
1766 send Mysqlx.Crud.Find {
1767 collection {
1768 name: "xtable"
1769 schema: "xtest"
1770 }
1771 data_model: TABLE
1772 projection {
1773 source {
1774 type: OPERATOR
1775 operator {
1776 name: "cont_in"
1777 param {
1778 type: LITERAL
1779 literal {
1780 type: V_SINT
1781 v_signed_int: 10
1782 }
1783 }
1784 param {
1785 type: IDENT
1786 identifier {
1787 document_path {
1788 type: MEMBER
1789 value: "scalar_10"
1790 }
1791 name: "doc"
1792 }
1793 }
1794 }
1795 }
1796 alias: "cont_in"
1797 }
1798 projection {
1799 source {
1800 type: OPERATOR
1801 operator {
1802 name: "not_cont_in"
1803 param {
1804 type: LITERAL
1805 literal {
1806 type: V_SINT
1807 v_signed_int: 10
1808 }
1809 }
1810 param {
1811 type: IDENT
1812 identifier {
1813 document_path {
1814 type: MEMBER
1815 value: "scalar_10"
1816 }
1817 name: "doc"
1818 }
1819 }
1820 }
1821 }
1822 alias: "not_cont_in"
1823 }
1824 }
1825
1826 cont_in not_cont_in
1827 1 0
1828 command ok
1829 Got expected error (code 0)
1830 send Mysqlx.Crud.Find {
1831 collection {
1832 name: "xtable"
1833 schema: "xtest"
1834 }
1835 data_model: TABLE
1836 projection {
1837 source {
1838 type: OPERATOR
1839 operator {
1840 name: "cont_in"
1841 param {
1842 type: LITERAL
1843 literal {
1844 type: V_SINT
1845 v_signed_int: 20
1846 }
1847 }
1848 param {
1849 type: IDENT
1850 identifier {
1851 document_path {
1852 type: MEMBER
1853 value: "scalar_10"
1854 }
1855 name: "doc"
1856 }
1857 }
1858 }
1859 }
1860 alias: "cont_in"
1861 }
1862 projection {
1863 source {
1864 type: OPERATOR
1865 operator {
1866 name: "not_cont_in"
1867 param {
1868 type: LITERAL
1869 literal {
1870 type: V_SINT
1871 v_signed_int: 20
1872 }
1873 }
1874 param {
1875 type: IDENT
1876 identifier {
1877 document_path {
1878 type: MEMBER
1879 value: "scalar_10"
1880 }
1881 name: "doc"
1882 }
1883 }
1884 }
1885 }
1886 alias: "not_cont_in"
1887 }
1888 }
1889
1890 cont_in not_cont_in
1891 0 1
1892 command ok
1893 Got expected error (code 0)
1894
1895 Numeric member in literal scalar
1896 --------------------------------
1897 send Mysqlx.Crud.Find {
1898 collection {
1899 name: "xtable"
1900 schema: "xtest"
1901 }
1902 data_model: TABLE
1903 projection {
1904 source {
1905 type: OPERATOR
1906 operator {
1907 name: "cont_in"
1908 param {
1909 type: IDENT
1910 identifier {
1911 document_path {
1912 type: MEMBER
1913 value: "scalar_10"
1914 }
1915 name: "doc"
1916 }
1917 }
1918 param {
1919 type: LITERAL
1920 literal {
1921 type: V_SINT
1922 v_signed_int: 10
1923 }
1924 }
1925 }
1926 }
1927 alias: "cont_in"
1928 }
1929 projection {
1930 source {
1931 type: OPERATOR
1932 operator {
1933 name: "not_cont_in"
1934 param {
1935 type: IDENT
1936 identifier {
1937 document_path {
1938 type: MEMBER
1939 value: "scalar_10"
1940 }
1941 name: "doc"
1942 }
1943 }
1944 param {
1945 type: LITERAL
1946 literal {
1947 type: V_SINT
1948 v_signed_int: 10
1949 }
1950 }
1951 }
1952 }
1953 alias: "not_cont_in"
1954 }
1955 }
1956
1957 cont_in not_cont_in
1958 1 0
1959 command ok
1960 Got expected error (code 0)
1961 send Mysqlx.Crud.Find {
1962 collection {
1963 name: "xtable"
1964 schema: "xtest"
1965 }
1966 data_model: TABLE
1967 projection {
1968 source {
1969 type: OPERATOR
1970 operator {
1971 name: "cont_in"
1972 param {
1973 type: IDENT
1974 identifier {
1975 document_path {
1976 type: MEMBER
1977 value: "scalar_40"
1978 }
1979 name: "doc"
1980 }
1981 }
1982 param {
1983 type: LITERAL
1984 literal {
1985 type: V_SINT
1986 v_signed_int: 10
1987 }
1988 }
1989 }
1990 }
1991 alias: "cont_in"
1992 }
1993 projection {
1994 source {
1995 type: OPERATOR
1996 operator {
1997 name: "not_cont_in"
1998 param {
1999 type: IDENT
2000 identifier {
2001 document_path {
2002 type: MEMBER
2003 value: "scalar_40"
2004 }
2005 name: "doc"
2006 }
2007 }
2008 param {
2009 type: LITERAL
2010 literal {
2011 type: V_SINT
2012 v_signed_int: 10
2013 }
2014 }
2015 }
2016 }
2017 alias: "not_cont_in"
2018 }
2019 }
2020
2021 cont_in not_cont_in
2022 0 1
2023 command ok
2024 Got expected error (code 0)
2025
2026 Numeric member in literal array
2027 -------------------------------
2028 send Mysqlx.Crud.Find {
2029 collection {
2030 name: "xtable"
2031 schema: "xtest"
2032 }
2033 data_model: TABLE
2034 projection {
2035 source {
2036 type: OPERATOR
2037 operator {
2038 name: "cont_in"
2039 param {
2040 type: IDENT
2041 identifier {
2042 document_path {
2043 type: MEMBER
2044 value: "scalar_10"
2045 }
2046 name: "doc"
2047 }
2048 }
2049 param {
2050 type: ARRAY
2051 array {
2052 value {
2053 type: LITERAL
2054 literal {
2055 type: V_SINT
2056 v_signed_int: 10
2057 }
2058 }
2059 value {
2060 type: LITERAL
2061 literal {
2062 type: V_SINT
2063 v_signed_int: 20
2064 }
2065 }
2066 value {
2067 type: LITERAL
2068 literal {
2069 type: V_SINT
2070 v_signed_int: 30
2071 }
2072 }
2073 }
2074 }
2075 }
2076 }
2077 alias: "cont_in"
2078 }
2079 projection {
2080 source {
2081 type: OPERATOR
2082 operator {
2083 name: "not_cont_in"
2084 param {
2085 type: IDENT
2086 identifier {
2087 document_path {
2088 type: MEMBER
2089 value: "scalar_10"
2090 }
2091 name: "doc"
2092 }
2093 }
2094 param {
2095 type: ARRAY
2096 array {
2097 value {
2098 type: LITERAL
2099 literal {
2100 type: V_SINT
2101 v_signed_int: 10
2102 }
2103 }
2104 value {
2105 type: LITERAL
2106 literal {
2107 type: V_SINT
2108 v_signed_int: 20
2109 }
2110 }
2111 value {
2112 type: LITERAL
2113 literal {
2114 type: V_SINT
2115 v_signed_int: 30
2116 }
2117 }
2118 }
2119 }
2120 }
2121 }
2122 alias: "not_cont_in"
2123 }
2124 }
2125
2126 cont_in not_cont_in
2127 1 0
2128 command ok
2129 Got expected error (code 0)
2130 send Mysqlx.Crud.Find {
2131 collection {
2132 name: "xtable"
2133 schema: "xtest"
2134 }
2135 data_model: TABLE
2136 projection {
2137 source {
2138 type: OPERATOR
2139 operator {
2140 name: "cont_in"
2141 param {
2142 type: IDENT
2143 identifier {
2144 document_path {
2145 type: MEMBER
2146 value: "scalar_40"
2147 }
2148 name: "doc"
2149 }
2150 }
2151 param {
2152 type: ARRAY
2153 array {
2154 value {
2155 type: LITERAL
2156 literal {
2157 type: V_SINT
2158 v_signed_int: 10
2159 }
2160 }
2161 value {
2162 type: LITERAL
2163 literal {
2164 type: V_SINT
2165 v_signed_int: 20
2166 }
2167 }
2168 value {
2169 type: LITERAL
2170 literal {
2171 type: V_SINT
2172 v_signed_int: 30
2173 }
2174 }
2175 }
2176 }
2177 }
2178 }
2179 alias: "cont_in"
2180 }
2181 projection {
2182 source {
2183 type: OPERATOR
2184 operator {
2185 name: "not_cont_in"
2186 param {
2187 type: IDENT
2188 identifier {
2189 document_path {
2190 type: MEMBER
2191 value: "scalar_40"
2192 }
2193 name: "doc"
2194 }
2195 }
2196 param {
2197 type: ARRAY
2198 array {
2199 value {
2200 type: LITERAL
2201 literal {
2202 type: V_SINT
2203 v_signed_int: 10
2204 }
2205 }
2206 value {
2207 type: LITERAL
2208 literal {
2209 type: V_SINT
2210 v_signed_int: 20
2211 }
2212 }
2213 value {
2214 type: LITERAL
2215 literal {
2216 type: V_SINT
2217 v_signed_int: 30
2218 }
2219 }
2220 }
2221 }
2222 }
2223 }
2224 alias: "not_cont_in"
2225 }
2226 }
2227
2228 cont_in not_cont_in
2229 0 1
2230 command ok
2231 Got expected error (code 0)
2232
2233 Numeric member in json octets array
2234 -----------------------------------
2235 send Mysqlx.Crud.Find {
2236 collection {
2237 name: "xtable"
2238 schema: "xtest"
2239 }
2240 data_model: TABLE
2241 projection {
2242 source {
2243 type: OPERATOR
2244 operator {
2245 name: "cont_in"
2246 param {
2247 type: IDENT
2248 identifier {
2249 document_path {
2250 type: MEMBER
2251 value: "scalar_10"
2252 }
2253 name: "doc"
2254 }
2255 }
2256 param {
2257 type: LITERAL
2258 literal {
2259 type: V_OCTETS
2260 v_octets {
2261 value: "[10, 20, 30]"
2262 content_type: 2
2263 }
2264 }
2265 }
2266 }
2267 }
2268 alias: "cont_in"
2269 }
2270 projection {
2271 source {
2272 type: OPERATOR
2273 operator {
2274 name: "not_cont_in"
2275 param {
2276 type: IDENT
2277 identifier {
2278 document_path {
2279 type: MEMBER
2280 value: "scalar_10"
2281 }
2282 name: "doc"
2283 }
2284 }
2285 param {
2286 type: LITERAL
2287 literal {
2288 type: V_OCTETS
2289 v_octets {
2290 value: "[10, 20, 30]"
2291 content_type: 2
2292 }
2293 }
2294 }
2295 }
2296 }
2297 alias: "not_cont_in"
2298 }
2299 }
2300
2301 cont_in not_cont_in
2302 1 0
2303 command ok
2304 Got expected error (code 0)
2305 send Mysqlx.Crud.Find {
2306 collection {
2307 name: "xtable"
2308 schema: "xtest"
2309 }
2310 data_model: TABLE
2311 projection {
2312 source {
2313 type: OPERATOR
2314 operator {
2315 name: "cont_in"
2316 param {
2317 type: IDENT
2318 identifier {
2319 document_path {
2320 type: MEMBER
2321 value: "scalar_40"
2322 }
2323 name: "doc"
2324 }
2325 }
2326 param {
2327 type: LITERAL
2328 literal {
2329 type: V_OCTETS
2330 v_octets {
2331 value: "[10, 20, 30]"
2332 content_type: 2
2333 }
2334 }
2335 }
2336 }
2337 }
2338 alias: "cont_in"
2339 }
2340 projection {
2341 source {
2342 type: OPERATOR
2343 operator {
2344 name: "not_cont_in"
2345 param {
2346 type: IDENT
2347 identifier {
2348 document_path {
2349 type: MEMBER
2350 value: "scalar_40"
2351 }
2352 name: "doc"
2353 }
2354 }
2355 param {
2356 type: LITERAL
2357 literal {
2358 type: V_OCTETS
2359 v_octets {
2360 value: "[10, 20, 30]"
2361 content_type: 2
2362 }
2363 }
2364 }
2365 }
2366 }
2367 alias: "not_cont_in"
2368 }
2369 }
2370
2371 cont_in not_cont_in
2372 0 1
2373 command ok
2374 Got expected error (code 0)
2375
2376 Bool literal in member
2377 ----------------------
2378 send Mysqlx.Crud.Find {
2379 collection {
2380 name: "xtable"
2381 schema: "xtest"
2382 }
2383 data_model: TABLE
2384 projection {
2385 source {
2386 type: OPERATOR
2387 operator {
2388 name: "cont_in"
2389 param {
2390 type: LITERAL
2391 literal {
2392 type: V_BOOL
2393 v_bool: true
2394 }
2395 }
2396 param {
2397 type: IDENT
2398 identifier {
2399 document_path {
2400 type: MEMBER
2401 value: "scalar_true"
2402 }
2403 name: "doc"
2404 }
2405 }
2406 }
2407 }
2408 alias: "cont_in"
2409 }
2410 projection {
2411 source {
2412 type: OPERATOR
2413 operator {
2414 name: "not_cont_in"
2415 param {
2416 type: LITERAL
2417 literal {
2418 type: V_BOOL
2419 v_bool: true
2420 }
2421 }
2422 param {
2423 type: IDENT
2424 identifier {
2425 document_path {
2426 type: MEMBER
2427 value: "scalar_true"
2428 }
2429 name: "doc"
2430 }
2431 }
2432 }
2433 }
2434 alias: "not_cont_in"
2435 }
2436 }
2437
2438 cont_in not_cont_in
2439 1 0
2440 command ok
2441 Got expected error (code 0)
2442 send Mysqlx.Crud.Find {
2443 collection {
2444 name: "xtable"
2445 schema: "xtest"
2446 }
2447 data_model: TABLE
2448 projection {
2449 source {
2450 type: OPERATOR
2451 operator {
2452 name: "cont_in"
2453 param {
2454 type: LITERAL
2455 literal {
2456 type: V_BOOL
2457 v_bool: false
2458 }
2459 }
2460 param {
2461 type: IDENT
2462 identifier {
2463 document_path {
2464 type: MEMBER
2465 value: "scalar_true"
2466 }
2467 name: "doc"
2468 }
2469 }
2470 }
2471 }
2472 alias: "cont_in"
2473 }
2474 projection {
2475 source {
2476 type: OPERATOR
2477 operator {
2478 name: "not_cont_in"
2479 param {
2480 type: LITERAL
2481 literal {
2482 type: V_BOOL
2483 v_bool: false
2484 }
2485 }
2486 param {
2487 type: IDENT
2488 identifier {
2489 document_path {
2490 type: MEMBER
2491 value: "scalar_true"
2492 }
2493 name: "doc"
2494 }
2495 }
2496 }
2497 }
2498 alias: "not_cont_in"
2499 }
2500 }
2501
2502 cont_in not_cont_in
2503 0 1
2504 command ok
2505 Got expected error (code 0)
2506
2507 Bool member in literal scalar
2508 -----------------------------
2509 send Mysqlx.Crud.Find {
2510 collection {
2511 name: "xtable"
2512 schema: "xtest"
2513 }
2514 data_model: TABLE
2515 projection {
2516 source {
2517 type: OPERATOR
2518 operator {
2519 name: "cont_in"
2520 param {
2521 type: IDENT
2522 identifier {
2523 document_path {
2524 type: MEMBER
2525 value: "scalar_true"
2526 }
2527 name: "doc"
2528 }
2529 }
2530 param {
2531 type: LITERAL
2532 literal {
2533 type: V_BOOL
2534 v_bool: true
2535 }
2536 }
2537 }
2538 }
2539 alias: "cont_in"
2540 }
2541 projection {
2542 source {
2543 type: OPERATOR
2544 operator {
2545 name: "not_cont_in"
2546 param {
2547 type: IDENT
2548 identifier {
2549 document_path {
2550 type: MEMBER
2551 value: "scalar_true"
2552 }
2553 name: "doc"
2554 }
2555 }
2556 param {
2557 type: LITERAL
2558 literal {
2559 type: V_BOOL
2560 v_bool: true
2561 }
2562 }
2563 }
2564 }
2565 alias: "not_cont_in"
2566 }
2567 }
2568
2569 cont_in not_cont_in
2570 1 0
2571 command ok
2572 Got expected error (code 0)
2573 send Mysqlx.Crud.Find {
2574 collection {
2575 name: "xtable"
2576 schema: "xtest"
2577 }
2578 data_model: TABLE
2579 projection {
2580 source {
2581 type: OPERATOR
2582 operator {
2583 name: "cont_in"
2584 param {
2585 type: IDENT
2586 identifier {
2587 document_path {
2588 type: MEMBER
2589 value: "scalar_40"
2590 }
2591 name: "doc"
2592 }
2593 }
2594 param {
2595 type: LITERAL
2596 literal {
2597 type: V_BOOL
2598 v_bool: true
2599 }
2600 }
2601 }
2602 }
2603 alias: "cont_in"
2604 }
2605 projection {
2606 source {
2607 type: OPERATOR
2608 operator {
2609 name: "not_cont_in"
2610 param {
2611 type: IDENT
2612 identifier {
2613 document_path {
2614 type: MEMBER
2615 value: "scalar_40"
2616 }
2617 name: "doc"
2618 }
2619 }
2620 param {
2621 type: LITERAL
2622 literal {
2623 type: V_BOOL
2624 v_bool: true
2625 }
2626 }
2627 }
2628 }
2629 alias: "not_cont_in"
2630 }
2631 }
2632
2633 cont_in not_cont_in
2634 0 1
2635 command ok
2636 Got expected error (code 0)
2637
2638 Bool member in literal array
2639 ----------------------------
2640 send Mysqlx.Crud.Find {
2641 collection {
2642 name: "xtable"
2643 schema: "xtest"
2644 }
2645 data_model: TABLE
2646 projection {
2647 source {
2648 type: OPERATOR
2649 operator {
2650 name: "cont_in"
2651 param {
2652 type: IDENT
2653 identifier {
2654 document_path {
2655 type: MEMBER
2656 value: "scalar_true"
2657 }
2658 name: "doc"
2659 }
2660 }
2661 param {
2662 type: ARRAY
2663 array {
2664 value {
2665 type: LITERAL
2666 literal {
2667 type: V_BOOL
2668 v_bool: true
2669 }
2670 }
2671 value {
2672 type: LITERAL
2673 literal {
2674 type: V_BOOL
2675 v_bool: false
2676 }
2677 }
2678 }
2679 }
2680 }
2681 }
2682 alias: "cont_in"
2683 }
2684 projection {
2685 source {
2686 type: OPERATOR
2687 operator {
2688 name: "not_cont_in"
2689 param {
2690 type: IDENT
2691 identifier {
2692 document_path {
2693 type: MEMBER
2694 value: "scalar_true"
2695 }
2696 name: "doc"
2697 }
2698 }
2699 param {
2700 type: ARRAY
2701 array {
2702 value {
2703 type: LITERAL
2704 literal {
2705 type: V_BOOL
2706 v_bool: true
2707 }
2708 }
2709 value {
2710 type: LITERAL
2711 literal {
2712 type: V_BOOL
2713 v_bool: false
2714 }
2715 }
2716 }
2717 }
2718 }
2719 }
2720 alias: "not_cont_in"
2721 }
2722 }
2723
2724 cont_in not_cont_in
2725 1 0
2726 command ok
2727 Got expected error (code 0)
2728 send Mysqlx.Crud.Find {
2729 collection {
2730 name: "xtable"
2731 schema: "xtest"
2732 }
2733 data_model: TABLE
2734 projection {
2735 source {
2736 type: OPERATOR
2737 operator {
2738 name: "cont_in"
2739 param {
2740 type: IDENT
2741 identifier {
2742 document_path {
2743 type: MEMBER
2744 value: "scalar_40"
2745 }
2746 name: "doc"
2747 }
2748 }
2749 param {
2750 type: ARRAY
2751 array {
2752 value {
2753 type: LITERAL
2754 literal {
2755 type: V_BOOL
2756 v_bool: true
2757 }
2758 }
2759 value {
2760 type: LITERAL
2761 literal {
2762 type: V_BOOL
2763 v_bool: false
2764 }
2765 }
2766 }
2767 }
2768 }
2769 }
2770 alias: "cont_in"
2771 }
2772 projection {
2773 source {
2774 type: OPERATOR
2775 operator {
2776 name: "not_cont_in"
2777 param {
2778 type: IDENT
2779 identifier {
2780 document_path {
2781 type: MEMBER
2782 value: "scalar_40"
2783 }
2784 name: "doc"
2785 }
2786 }
2787 param {
2788 type: ARRAY
2789 array {
2790 value {
2791 type: LITERAL
2792 literal {
2793 type: V_BOOL
2794 v_bool: true
2795 }
2796 }
2797 value {
2798 type: LITERAL
2799 literal {
2800 type: V_BOOL
2801 v_bool: false
2802 }
2803 }
2804 }
2805 }
2806 }
2807 }
2808 alias: "not_cont_in"
2809 }
2810 }
2811
2812 cont_in not_cont_in
2813 0 1
2814 command ok
2815 Got expected error (code 0)
2816
2817 Bool member in json octets array
2818 --------------------------------
2819 send Mysqlx.Crud.Find {
2820 collection {
2821 name: "xtable"
2822 schema: "xtest"
2823 }
2824 data_model: TABLE
2825 projection {
2826 source {
2827 type: OPERATOR
2828 operator {
2829 name: "cont_in"
2830 param {
2831 type: IDENT
2832 identifier {
2833 document_path {
2834 type: MEMBER
2835 value: "scalar_true"
2836 }
2837 name: "doc"
2838 }
2839 }
2840 param {
2841 type: LITERAL
2842 literal {
2843 type: V_OCTETS
2844 v_octets {
2845 value: "[true, false]"
2846 content_type: 2
2847 }
2848 }
2849 }
2850 }
2851 }
2852 alias: "cont_in"
2853 }
2854 projection {
2855 source {
2856 type: OPERATOR
2857 operator {
2858 name: "not_cont_in"
2859 param {
2860 type: IDENT
2861 identifier {
2862 document_path {
2863 type: MEMBER
2864 value: "scalar_true"
2865 }
2866 name: "doc"
2867 }
2868 }
2869 param {
2870 type: LITERAL
2871 literal {
2872 type: V_OCTETS
2873 v_octets {
2874 value: "[true, false]"
2875 content_type: 2
2876 }
2877 }
2878 }
2879 }
2880 }
2881 alias: "not_cont_in"
2882 }
2883 }
2884
2885 cont_in not_cont_in
2886 1 0
2887 command ok
2888 Got expected error (code 0)
2889 send Mysqlx.Crud.Find {
2890 collection {
2891 name: "xtable"
2892 schema: "xtest"
2893 }
2894 data_model: TABLE
2895 projection {
2896 source {
2897 type: OPERATOR
2898 operator {
2899 name: "cont_in"
2900 param {
2901 type: IDENT
2902 identifier {
2903 document_path {
2904 type: MEMBER
2905 value: "scalar_40"
2906 }
2907 name: "doc"
2908 }
2909 }
2910 param {
2911 type: LITERAL
2912 literal {
2913 type: V_OCTETS
2914 v_octets {
2915 value: "[true, false]"
2916 content_type: 2
2917 }
2918 }
2919 }
2920 }
2921 }
2922 alias: "cont_in"
2923 }
2924 projection {
2925 source {
2926 type: OPERATOR
2927 operator {
2928 name: "not_cont_in"
2929 param {
2930 type: IDENT
2931 identifier {
2932 document_path {
2933 type: MEMBER
2934 value: "scalar_40"
2935 }
2936 name: "doc"
2937 }
2938 }
2939 param {
2940 type: LITERAL
2941 literal {
2942 type: V_OCTETS
2943 v_octets {
2944 value: "[true, false]"
2945 content_type: 2
2946 }
2947 }
2948 }
2949 }
2950 }
2951 alias: "not_cont_in"
2952 }
2953 }
2954
2955 cont_in not_cont_in
2956 0 1
2957 command ok
2958 Got expected error (code 0)
2959
2960 String literal in member
2961 ------------------------
2962 send Mysqlx.Crud.Find {
2963 collection {
2964 name: "xtable"
2965 schema: "xtest"
2966 }
2967 data_model: TABLE
2968 projection {
2969 source {
2970 type: OPERATOR
2971 operator {
2972 name: "cont_in"
2973 param {
2974 type: LITERAL
2975 literal {
2976 type: V_STRING
2977 v_string {
2978 value: "red"
2979 }
2980 }
2981 }
2982 param {
2983 type: IDENT
2984 identifier {
2985 document_path {
2986 type: MEMBER
2987 value: "scalar_red"
2988 }
2989 name: "doc"
2990 }
2991 }
2992 }
2993 }
2994 alias: "cont_in"
2995 }
2996 projection {
2997 source {
2998 type: OPERATOR
2999 operator {
3000 name: "not_cont_in"
3001 param {
3002 type: LITERAL
3003 literal {
3004 type: V_STRING
3005 v_string {
3006 value: "red"
3007 }
3008 }
3009 }
3010 param {
3011 type: IDENT
3012 identifier {
3013 document_path {
3014 type: MEMBER
3015 value: "scalar_red"
3016 }
3017 name: "doc"
3018 }
3019 }
3020 }
3021 }
3022 alias: "not_cont_in"
3023 }
3024 }
3025
3026 cont_in not_cont_in
3027 1 0
3028 command ok
3029 Got expected error (code 0)
3030 send Mysqlx.Crud.Find {
3031 collection {
3032 name: "xtable"
3033 schema: "xtest"
3034 }
3035 data_model: TABLE
3036 projection {
3037 source {
3038 type: OPERATOR
3039 operator {
3040 name: "cont_in"
3041 param {
3042 type: LITERAL
3043 literal {
3044 type: V_STRING
3045 v_string {
3046 value: "white"
3047 }
3048 }
3049 }
3050 param {
3051 type: IDENT
3052 identifier {
3053 document_path {
3054 type: MEMBER
3055 value: "scalar_red"
3056 }
3057 name: "doc"
3058 }
3059 }
3060 }
3061 }
3062 alias: "cont_in"
3063 }
3064 projection {
3065 source {
3066 type: OPERATOR
3067 operator {
3068 name: "not_cont_in"
3069 param {
3070 type: LITERAL
3071 literal {
3072 type: V_STRING
3073 v_string {
3074 value: "white"
3075 }
3076 }
3077 }
3078 param {
3079 type: IDENT
3080 identifier {
3081 document_path {
3082 type: MEMBER
3083 value: "scalar_red"
3084 }
3085 name: "doc"
3086 }
3087 }
3088 }
3089 }
3090 alias: "not_cont_in"
3091 }
3092 }
3093
3094 cont_in not_cont_in
3095 0 1
3096 command ok
3097 Got expected error (code 0)
3098
3099 String member in literal scalar
3100 -------------------------------
3101 send Mysqlx.Crud.Find {
3102 collection {
3103 name: "xtable"
3104 schema: "xtest"
3105 }
3106 data_model: TABLE
3107 projection {
3108 source {
3109 type: OPERATOR
3110 operator {
3111 name: "cont_in"
3112 param {
3113 type: IDENT
3114 identifier {
3115 document_path {
3116 type: MEMBER
3117 value: "scalar_red"
3118 }
3119 name: "doc"
3120 }
3121 }
3122 param {
3123 type: LITERAL
3124 literal {
3125 type: V_STRING
3126 v_string {
3127 value: "red"
3128 }
3129 }
3130 }
3131 }
3132 }
3133 alias: "cont_in"
3134 }
3135 projection {
3136 source {
3137 type: OPERATOR
3138 operator {
3139 name: "not_cont_in"
3140 param {
3141 type: IDENT
3142 identifier {
3143 document_path {
3144 type: MEMBER
3145 value: "scalar_red"
3146 }
3147 name: "doc"
3148 }
3149 }
3150 param {
3151 type: LITERAL
3152 literal {
3153 type: V_STRING
3154 v_string {
3155 value: "red"
3156 }
3157 }
3158 }
3159 }
3160 }
3161 alias: "not_cont_in"
3162 }
3163 }
3164
3165 cont_in not_cont_in
3166 1 0
3167 command ok
3168 Got expected error (code 0)
3169 send Mysqlx.Crud.Find {
3170 collection {
3171 name: "xtable"
3172 schema: "xtest"
3173 }
3174 data_model: TABLE
3175 projection {
3176 source {
3177 type: OPERATOR
3178 operator {
3179 name: "cont_in"
3180 param {
3181 type: IDENT
3182 identifier {
3183 document_path {
3184 type: MEMBER
3185 value: "scalar_banana"
3186 }
3187 name: "doc"
3188 }
3189 }
3190 param {
3191 type: LITERAL
3192 literal {
3193 type: V_STRING
3194 v_string {
3195 value: "red"
3196 }
3197 }
3198 }
3199 }
3200 }
3201 alias: "cont_in"
3202 }
3203 projection {
3204 source {
3205 type: OPERATOR
3206 operator {
3207 name: "not_cont_in"
3208 param {
3209 type: IDENT
3210 identifier {
3211 document_path {
3212 type: MEMBER
3213 value: "scalar_banana"
3214 }
3215 name: "doc"
3216 }
3217 }
3218 param {
3219 type: LITERAL
3220 literal {
3221 type: V_STRING
3222 v_string {
3223 value: "red"
3224 }
3225 }
3226 }
3227 }
3228 }
3229 alias: "not_cont_in"
3230 }
3231 }
3232
3233 cont_in not_cont_in
3234 0 1
3235 command ok
3236 Got expected error (code 0)
3237
3238 String member in literal array
3239 ------------------------------
3240 send Mysqlx.Crud.Find {
3241 collection {
3242 name: "xtable"
3243 schema: "xtest"
3244 }
3245 data_model: TABLE
3246 projection {
3247 source {
3248 type: OPERATOR
3249 operator {
3250 name: "cont_in"
3251 param {
3252 type: IDENT
3253 identifier {
3254 document_path {
3255 type: MEMBER
3256 value: "scalar_red"
3257 }
3258 name: "doc"
3259 }
3260 }
3261 param {
3262 type: ARRAY
3263 array {
3264 value {
3265 type: LITERAL
3266 literal {
3267 type: V_STRING
3268 v_string {
3269 value: "red"
3270 }
3271 }
3272 }
3273 value {
3274 type: LITERAL
3275 literal {
3276 type: V_STRING
3277 v_string {
3278 value: "green"
3279 }
3280 }
3281 }
3282 value {
3283 type: LITERAL
3284 literal {
3285 type: V_STRING
3286 v_string {
3287 value: "blue"
3288 }
3289 }
3290 }
3291 }
3292 }
3293 }
3294 }
3295 alias: "cont_in"
3296 }
3297 projection {
3298 source {
3299 type: OPERATOR
3300 operator {
3301 name: "not_cont_in"
3302 param {
3303 type: IDENT
3304 identifier {
3305 document_path {
3306 type: MEMBER
3307 value: "scalar_red"
3308 }
3309 name: "doc"
3310 }
3311 }
3312 param {
3313 type: ARRAY
3314 array {
3315 value {
3316 type: LITERAL
3317 literal {
3318 type: V_STRING
3319 v_string {
3320 value: "red"
3321 }
3322 }
3323 }
3324 value {
3325 type: LITERAL
3326 literal {
3327 type: V_STRING
3328 v_string {
3329 value: "green"
3330 }
3331 }
3332 }
3333 value {
3334 type: LITERAL
3335 literal {
3336 type: V_STRING
3337 v_string {
3338 value: "blue"
3339 }
3340 }
3341 }
3342 }
3343 }
3344 }
3345 }
3346 alias: "not_cont_in"
3347 }
3348 }
3349
3350 cont_in not_cont_in
3351 1 0
3352 command ok
3353 Got expected error (code 0)
3354 send Mysqlx.Crud.Find {
3355 collection {
3356 name: "xtable"
3357 schema: "xtest"
3358 }
3359 data_model: TABLE
3360 projection {
3361 source {
3362 type: OPERATOR
3363 operator {
3364 name: "cont_in"
3365 param {
3366 type: IDENT
3367 identifier {
3368 document_path {
3369 type: MEMBER
3370 value: "scalar_banana"
3371 }
3372 name: "doc"
3373 }
3374 }
3375 param {
3376 type: ARRAY
3377 array {
3378 value {
3379 type: LITERAL
3380 literal {
3381 type: V_STRING
3382 v_string {
3383 value: "red"
3384 }
3385 }
3386 }
3387 value {
3388 type: LITERAL
3389 literal {
3390 type: V_STRING
3391 v_string {
3392 value: "green"
3393 }
3394 }
3395 }
3396 value {
3397 type: LITERAL
3398 literal {
3399 type: V_STRING
3400 v_string {
3401 value: "blue"
3402 }
3403 }
3404 }
3405 }
3406 }
3407 }
3408 }
3409 alias: "cont_in"
3410 }
3411 projection {
3412 source {
3413 type: OPERATOR
3414 operator {
3415 name: "not_cont_in"
3416 param {
3417 type: IDENT
3418 identifier {
3419 document_path {
3420 type: MEMBER
3421 value: "scalar_banana"
3422 }
3423 name: "doc"
3424 }
3425 }
3426 param {
3427 type: ARRAY
3428 array {
3429 value {
3430 type: LITERAL
3431 literal {
3432 type: V_STRING
3433 v_string {
3434 value: "red"
3435 }
3436 }
3437 }
3438 value {
3439 type: LITERAL
3440 literal {
3441 type: V_STRING
3442 v_string {
3443 value: "green"
3444 }
3445 }
3446 }
3447 value {
3448 type: LITERAL
3449 literal {
3450 type: V_STRING
3451 v_string {
3452 value: "blue"
3453 }
3454 }
3455 }
3456 }
3457 }
3458 }
3459 }
3460 alias: "not_cont_in"
3461 }
3462 }
3463
3464 cont_in not_cont_in
3465 0 1
3466 command ok
3467 Got expected error (code 0)
3468
3469 String member in json octets array
3470 ----------------------------------
3471 send Mysqlx.Crud.Find {
3472 collection {
3473 name: "xtable"
3474 schema: "xtest"
3475 }
3476 data_model: TABLE
3477 projection {
3478 source {
3479 type: OPERATOR
3480 operator {
3481 name: "cont_in"
3482 param {
3483 type: IDENT
3484 identifier {
3485 document_path {
3486 type: MEMBER
3487 value: "scalar_red"
3488 }
3489 name: "doc"
3490 }
3491 }
3492 param {
3493 type: LITERAL
3494 literal {
3495 type: V_OCTETS
3496 v_octets {
3497 value: "[\"red\", \"green\", \"blue\"]"
3498 content_type: 2
3499 }
3500 }
3501 }
3502 }
3503 }
3504 alias: "cont_in"
3505 }
3506 projection {
3507 source {
3508 type: OPERATOR
3509 operator {
3510 name: "not_cont_in"
3511 param {
3512 type: IDENT
3513 identifier {
3514 document_path {
3515 type: MEMBER
3516 value: "scalar_red"
3517 }
3518 name: "doc"
3519 }
3520 }
3521 param {
3522 type: LITERAL
3523 literal {
3524 type: V_OCTETS
3525 v_octets {
3526 value: "[\"red\", \"green\", \"blue\"]"
3527 content_type: 2
3528 }
3529 }
3530 }
3531 }
3532 }
3533 alias: "not_cont_in"
3534 }
3535 }
3536
3537 cont_in not_cont_in
3538 1 0
3539 command ok
3540 Got expected error (code 0)
3541 send Mysqlx.Crud.Find {
3542 collection {
3543 name: "xtable"
3544 schema: "xtest"
3545 }
3546 data_model: TABLE
3547 projection {
3548 source {
3549 type: OPERATOR
3550 operator {
3551 name: "cont_in"
3552 param {
3553 type: IDENT
3554 identifier {
3555 document_path {
3556 type: MEMBER
3557 value: "scalar_banana"
3558 }
3559 name: "doc"
3560 }
3561 }
3562 param {
3563 type: LITERAL
3564 literal {
3565 type: V_OCTETS
3566 v_octets {
3567 value: "[\"red\", \"green\", \"blue\"]"
3568 content_type: 2
3569 }
3570 }
3571 }
3572 }
3573 }
3574 alias: "cont_in"
3575 }
3576 projection {
3577 source {
3578 type: OPERATOR
3579 operator {
3580 name: "not_cont_in"
3581 param {
3582 type: IDENT
3583 identifier {
3584 document_path {
3585 type: MEMBER
3586 value: "scalar_banana"
3587 }
3588 name: "doc"
3589 }
3590 }
3591 param {
3592 type: LITERAL
3593 literal {
3594 type: V_OCTETS
3595 v_octets {
3596 value: "[\"red\", \"green\", \"blue\"]"
3597 content_type: 2
3598 }
3599 }
3600 }
3601 }
3602 }
3603 alias: "not_cont_in"
3604 }
3605 }
3606
3607 cont_in not_cont_in
3608 0 1
3609 command ok
3610 Got expected error (code 0)
3611
3612 Plain octets literal in member
3613 ------------------------------
3614 send Mysqlx.Crud.Find {
3615 collection {
3616 name: "xtable"
3617 schema: "xtest"
3618 }
3619 data_model: TABLE
3620 projection {
3621 source {
3622 type: OPERATOR
3623 operator {
3624 name: "cont_in"
3625 param {
3626 type: LITERAL
3627 literal {
3628 type: V_OCTETS
3629 v_octets {
3630 value: "banana"
3631 content_type: 0
3632 }
3633 }
3634 }
3635 param {
3636 type: IDENT
3637 identifier {
3638 document_path {
3639 type: MEMBER
3640 value: "scalar_banana"
3641 }
3642 name: "doc"
3643 }
3644 }
3645 }
3646 }
3647 alias: "cont_in"
3648 }
3649 projection {
3650 source {
3651 type: OPERATOR
3652 operator {
3653 name: "not_cont_in"
3654 param {
3655 type: LITERAL
3656 literal {
3657 type: V_OCTETS
3658 v_octets {
3659 value: "banana"
3660 content_type: 0
3661 }
3662 }
3663 }
3664 param {
3665 type: IDENT
3666 identifier {
3667 document_path {
3668 type: MEMBER
3669 value: "scalar_banana"
3670 }
3671 name: "doc"
3672 }
3673 }
3674 }
3675 }
3676 alias: "not_cont_in"
3677 }
3678 }
3679
3680 cont_in not_cont_in
3681 1 0
3682 command ok
3683 Got expected error (code 0)
3684 send Mysqlx.Crud.Find {
3685 collection {
3686 name: "xtable"
3687 schema: "xtest"
3688 }
3689 data_model: TABLE
3690 projection {
3691 source {
3692 type: OPERATOR
3693 operator {
3694 name: "cont_in"
3695 param {
3696 type: LITERAL
3697 literal {
3698 type: V_OCTETS
3699 v_octets {
3700 value: "pear"
3701 content_type: 0
3702 }
3703 }
3704 }
3705 param {
3706 type: IDENT
3707 identifier {
3708 document_path {
3709 type: MEMBER
3710 value: "scalar_banana"
3711 }
3712 name: "doc"
3713 }
3714 }
3715 }
3716 }
3717 alias: "cont_in"
3718 }
3719 projection {
3720 source {
3721 type: OPERATOR
3722 operator {
3723 name: "not_cont_in"
3724 param {
3725 type: LITERAL
3726 literal {
3727 type: V_OCTETS
3728 v_octets {
3729 value: "pear"
3730 content_type: 0
3731 }
3732 }
3733 }
3734 param {
3735 type: IDENT
3736 identifier {
3737 document_path {
3738 type: MEMBER
3739 value: "scalar_banana"
3740 }
3741 name: "doc"
3742 }
3743 }
3744 }
3745 }
3746 alias: "not_cont_in"
3747 }
3748 }
3749
3750 cont_in not_cont_in
3751 0 1
3752 command ok
3753 Got expected error (code 0)
3754
3755 String member in plain octets literal
3756 -------------------------------------
3757 send Mysqlx.Crud.Find {
3758 collection {
3759 name: "xtable"
3760 schema: "xtest"
3761 }
3762 data_model: TABLE
3763 projection {
3764 source {
3765 type: OPERATOR
3766 operator {
3767 name: "cont_in"
3768 param {
3769 type: IDENT
3770 identifier {
3771 document_path {
3772 type: MEMBER
3773 value: "scalar_red"
3774 }
3775 name: "doc"
3776 }
3777 }
3778 param {
3779 type: LITERAL
3780 literal {
3781 type: V_STRING
3782 v_string {
3783 value: "red"
3784 }
3785 }
3786 }
3787 }
3788 }
3789 alias: "cont_in"
3790 }
3791 projection {
3792 source {
3793 type: OPERATOR
3794 operator {
3795 name: "not_cont_in"
3796 param {
3797 type: IDENT
3798 identifier {
3799 document_path {
3800 type: MEMBER
3801 value: "scalar_red"
3802 }
3803 name: "doc"
3804 }
3805 }
3806 param {
3807 type: LITERAL
3808 literal {
3809 type: V_STRING
3810 v_string {
3811 value: "red"
3812 }
3813 }
3814 }
3815 }
3816 }
3817 alias: "not_cont_in"
3818 }
3819 }
3820
3821 cont_in not_cont_in
3822 1 0
3823 command ok
3824 Got expected error (code 0)
3825 send Mysqlx.Crud.Find {
3826 collection {
3827 name: "xtable"
3828 schema: "xtest"
3829 }
3830 data_model: TABLE
3831 projection {
3832 source {
3833 type: OPERATOR
3834 operator {
3835 name: "cont_in"
3836 param {
3837 type: IDENT
3838 identifier {
3839 document_path {
3840 type: MEMBER
3841 value: "scalar_banana"
3842 }
3843 name: "doc"
3844 }
3845 }
3846 param {
3847 type: LITERAL
3848 literal {
3849 type: V_STRING
3850 v_string {
3851 value: "red"
3852 }
3853 }
3854 }
3855 }
3856 }
3857 alias: "cont_in"
3858 }
3859 projection {
3860 source {
3861 type: OPERATOR
3862 operator {
3863 name: "not_cont_in"
3864 param {
3865 type: IDENT
3866 identifier {
3867 document_path {
3868 type: MEMBER
3869 value: "scalar_banana"
3870 }
3871 name: "doc"
3872 }
3873 }
3874 param {
3875 type: LITERAL
3876 literal {
3877 type: V_STRING
3878 v_string {
3879 value: "red"
3880 }
3881 }
3882 }
3883 }
3884 }
3885 alias: "not_cont_in"
3886 }
3887 }
3888
3889 cont_in not_cont_in
3890 0 1
3891 command ok
3892 Got expected error (code 0)
3893
3894 Numeric literal in member array
3895 -------------------------------
3896 send Mysqlx.Crud.Find {
3897 collection {
3898 name: "xtable"
3899 schema: "xtest"
3900 }
3901 data_model: TABLE
3902 projection {
3903 source {
3904 type: OPERATOR
3905 operator {
3906 name: "cont_in"
3907 param {
3908 type: LITERAL
3909 literal {
3910 type: V_SINT
3911 v_signed_int: 10
3912 }
3913 }
3914 param {
3915 type: IDENT
3916 identifier {
3917 document_path {
3918 type: MEMBER
3919 value: "array_10_20_30"
3920 }
3921 name: "doc"
3922 }
3923 }
3924 }
3925 }
3926 alias: "cont_in"
3927 }
3928 projection {
3929 source {
3930 type: OPERATOR
3931 operator {
3932 name: "not_cont_in"
3933 param {
3934 type: LITERAL
3935 literal {
3936 type: V_SINT
3937 v_signed_int: 10
3938 }
3939 }
3940 param {
3941 type: IDENT
3942 identifier {
3943 document_path {
3944 type: MEMBER
3945 value: "array_10_20_30"
3946 }
3947 name: "doc"
3948 }
3949 }
3950 }
3951 }
3952 alias: "not_cont_in"
3953 }
3954 }
3955
3956 cont_in not_cont_in
3957 1 0
3958 command ok
3959 Got expected error (code 0)
3960 send Mysqlx.Crud.Find {
3961 collection {
3962 name: "xtable"
3963 schema: "xtest"
3964 }
3965 data_model: TABLE
3966 projection {
3967 source {
3968 type: OPERATOR
3969 operator {
3970 name: "cont_in"
3971 param {
3972 type: LITERAL
3973 literal {
3974 type: V_SINT
3975 v_signed_int: 40
3976 }
3977 }
3978 param {
3979 type: IDENT
3980 identifier {
3981 document_path {
3982 type: MEMBER
3983 value: "array_10_20_30"
3984 }
3985 name: "doc"
3986 }
3987 }
3988 }
3989 }
3990 alias: "cont_in"
3991 }
3992 projection {
3993 source {
3994 type: OPERATOR
3995 operator {
3996 name: "not_cont_in"
3997 param {
3998 type: LITERAL
3999 literal {
4000 type: V_SINT
4001 v_signed_int: 40
4002 }
4003 }
4004 param {
4005 type: IDENT
4006 identifier {
4007 document_path {
4008 type: MEMBER
4009 value: "array_10_20_30"
4010 }
4011 name: "doc"
4012 }
4013 }
4014 }
4015 }
4016 alias: "not_cont_in"
4017 }
4018 }
4019
4020 cont_in not_cont_in
4021 0 1
4022 command ok
4023 Got expected error (code 0)
4024
4025 Numeric member in member array
4026 ------------------------------
4027 send Mysqlx.Crud.Find {
4028 collection {
4029 name: "xtable"
4030 schema: "xtest"
4031 }
4032 data_model: TABLE
4033 projection {
4034 source {
4035 type: OPERATOR
4036 operator {
4037 name: "cont_in"
4038 param {
4039 type: IDENT
4040 identifier {
4041 document_path {
4042 type: MEMBER
4043 value: "scalar_10"
4044 }
4045 name: "doc"
4046 }
4047 }
4048 param {
4049 type: IDENT
4050 identifier {
4051 document_path {
4052 type: MEMBER
4053 value: "array_10_20_30"
4054 }
4055 name: "doc"
4056 }
4057 }
4058 }
4059 }
4060 alias: "cont_in"
4061 }
4062 projection {
4063 source {
4064 type: OPERATOR
4065 operator {
4066 name: "not_cont_in"
4067 param {
4068 type: IDENT
4069 identifier {
4070 document_path {
4071 type: MEMBER
4072 value: "scalar_10"
4073 }
4074 name: "doc"
4075 }
4076 }
4077 param {
4078 type: IDENT
4079 identifier {
4080 document_path {
4081 type: MEMBER
4082 value: "array_10_20_30"
4083 }
4084 name: "doc"
4085 }
4086 }
4087 }
4088 }
4089 alias: "not_cont_in"
4090 }
4091 }
4092
4093 cont_in not_cont_in
4094 1 0
4095 command ok
4096 Got expected error (code 0)
4097 send Mysqlx.Crud.Find {
4098 collection {
4099 name: "xtable"
4100 schema: "xtest"
4101 }
4102 data_model: TABLE
4103 projection {
4104 source {
4105 type: OPERATOR
4106 operator {
4107 name: "cont_in"
4108 param {
4109 type: IDENT
4110 identifier {
4111 document_path {
4112 type: MEMBER
4113 value: "scalar_40"
4114 }
4115 name: "doc"
4116 }
4117 }
4118 param {
4119 type: IDENT
4120 identifier {
4121 document_path {
4122 type: MEMBER
4123 value: "array_10_20_30"
4124 }
4125 name: "doc"
4126 }
4127 }
4128 }
4129 }
4130 alias: "cont_in"
4131 }
4132 projection {
4133 source {
4134 type: OPERATOR
4135 operator {
4136 name: "not_cont_in"
4137 param {
4138 type: IDENT
4139 identifier {
4140 document_path {
4141 type: MEMBER
4142 value: "scalar_40"
4143 }
4144 name: "doc"
4145 }
4146 }
4147 param {
4148 type: IDENT
4149 identifier {
4150 document_path {
4151 type: MEMBER
4152 value: "array_10_20_30"
4153 }
4154 name: "doc"
4155 }
4156 }
4157 }
4158 }
4159 alias: "not_cont_in"
4160 }
4161 }
4162
4163 cont_in not_cont_in
4164 0 1
4165 command ok
4166 Got expected error (code 0)
4167
4168 Bool literal in member array
4169 ----------------------------
4170 send Mysqlx.Crud.Find {
4171 collection {
4172 name: "xtable"
4173 schema: "xtest"
4174 }
4175 data_model: TABLE
4176 projection {
4177 source {
4178 type: OPERATOR
4179 operator {
4180 name: "cont_in"
4181 param {
4182 type: LITERAL
4183 literal {
4184 type: V_BOOL
4185 v_bool: false
4186 }
4187 }
4188 param {
4189 type: IDENT
4190 identifier {
4191 document_path {
4192 type: MEMBER
4193 value: "array_true_false"
4194 }
4195 name: "doc"
4196 }
4197 }
4198 }
4199 }
4200 alias: "cont_in"
4201 }
4202 projection {
4203 source {
4204 type: OPERATOR
4205 operator {
4206 name: "not_cont_in"
4207 param {
4208 type: LITERAL
4209 literal {
4210 type: V_BOOL
4211 v_bool: false
4212 }
4213 }
4214 param {
4215 type: IDENT
4216 identifier {
4217 document_path {
4218 type: MEMBER
4219 value: "array_true_false"
4220 }
4221 name: "doc"
4222 }
4223 }
4224 }
4225 }
4226 alias: "not_cont_in"
4227 }
4228 }
4229
4230 cont_in not_cont_in
4231 1 0
4232 command ok
4233 Got expected error (code 0)
4234 send Mysqlx.Crud.Find {
4235 collection {
4236 name: "xtable"
4237 schema: "xtest"
4238 }
4239 data_model: TABLE
4240 projection {
4241 source {
4242 type: OPERATOR
4243 operator {
4244 name: "cont_in"
4245 param {
4246 type: LITERAL
4247 literal {
4248 type: V_SINT
4249 v_signed_int: 10
4250 }
4251 }
4252 param {
4253 type: IDENT
4254 identifier {
4255 document_path {
4256 type: MEMBER
4257 value: "array_true_false"
4258 }
4259 name: "doc"
4260 }
4261 }
4262 }
4263 }
4264 alias: "cont_in"
4265 }
4266 projection {
4267 source {
4268 type: OPERATOR
4269 operator {
4270 name: "not_cont_in"
4271 param {
4272 type: LITERAL
4273 literal {
4274 type: V_SINT
4275 v_signed_int: 10
4276 }
4277 }
4278 param {
4279 type: IDENT
4280 identifier {
4281 document_path {
4282 type: MEMBER
4283 value: "array_true_false"
4284 }
4285 name: "doc"
4286 }
4287 }
4288 }
4289 }
4290 alias: "not_cont_in"
4291 }
4292 }
4293
4294 cont_in not_cont_in
4295 0 1
4296 command ok
4297 Got expected error (code 0)
4298
4299 Bool member in member array
4300 ---------------------------
4301 send Mysqlx.Crud.Find {
4302 collection {
4303 name: "xtable"
4304 schema: "xtest"
4305 }
4306 data_model: TABLE
4307 projection {
4308 source {
4309 type: OPERATOR
4310 operator {
4311 name: "cont_in"
4312 param {
4313 type: IDENT
4314 identifier {
4315 document_path {
4316 type: MEMBER
4317 value: "scalar_true"
4318 }
4319 name: "doc"
4320 }
4321 }
4322 param {
4323 type: IDENT
4324 identifier {
4325 document_path {
4326 type: MEMBER
4327 value: "array_true_false"
4328 }
4329 name: "doc"
4330 }
4331 }
4332 }
4333 }
4334 alias: "cont_in"
4335 }
4336 projection {
4337 source {
4338 type: OPERATOR
4339 operator {
4340 name: "not_cont_in"
4341 param {
4342 type: IDENT
4343 identifier {
4344 document_path {
4345 type: MEMBER
4346 value: "scalar_true"
4347 }
4348 name: "doc"
4349 }
4350 }
4351 param {
4352 type: IDENT
4353 identifier {
4354 document_path {
4355 type: MEMBER
4356 value: "array_true_false"
4357 }
4358 name: "doc"
4359 }
4360 }
4361 }
4362 }
4363 alias: "not_cont_in"
4364 }
4365 }
4366
4367 cont_in not_cont_in
4368 1 0
4369 command ok
4370 Got expected error (code 0)
4371 send Mysqlx.Crud.Find {
4372 collection {
4373 name: "xtable"
4374 schema: "xtest"
4375 }
4376 data_model: TABLE
4377 projection {
4378 source {
4379 type: OPERATOR
4380 operator {
4381 name: "cont_in"
4382 param {
4383 type: IDENT
4384 identifier {
4385 document_path {
4386 type: MEMBER
4387 value: "scalar_40"
4388 }
4389 name: "doc"
4390 }
4391 }
4392 param {
4393 type: IDENT
4394 identifier {
4395 document_path {
4396 type: MEMBER
4397 value: "array_true_false"
4398 }
4399 name: "doc"
4400 }
4401 }
4402 }
4403 }
4404 alias: "cont_in"
4405 }
4406 projection {
4407 source {
4408 type: OPERATOR
4409 operator {
4410 name: "not_cont_in"
4411 param {
4412 type: IDENT
4413 identifier {
4414 document_path {
4415 type: MEMBER
4416 value: "scalar_40"
4417 }
4418 name: "doc"
4419 }
4420 }
4421 param {
4422 type: IDENT
4423 identifier {
4424 document_path {
4425 type: MEMBER
4426 value: "array_true_false"
4427 }
4428 name: "doc"
4429 }
4430 }
4431 }
4432 }
4433 alias: "not_cont_in"
4434 }
4435 }
4436
4437 cont_in not_cont_in
4438 0 1
4439 command ok
4440 Got expected error (code 0)
4441
4442 String literal in member array
4443 ------------------------------
4444 send Mysqlx.Crud.Find {
4445 collection {
4446 name: "xtable"
4447 schema: "xtest"
4448 }
4449 data_model: TABLE
4450 projection {
4451 source {
4452 type: OPERATOR
4453 operator {
4454 name: "cont_in"
4455 param {
4456 type: LITERAL
4457 literal {
4458 type: V_STRING
4459 v_string {
4460 value: "red"
4461 }
4462 }
4463 }
4464 param {
4465 type: IDENT
4466 identifier {
4467 document_path {
4468 type: MEMBER
4469 value: "array_red_green_pear"
4470 }
4471 name: "doc"
4472 }
4473 }
4474 }
4475 }
4476 alias: "cont_in"
4477 }
4478 projection {
4479 source {
4480 type: OPERATOR
4481 operator {
4482 name: "not_cont_in"
4483 param {
4484 type: LITERAL
4485 literal {
4486 type: V_STRING
4487 v_string {
4488 value: "red"
4489 }
4490 }
4491 }
4492 param {
4493 type: IDENT
4494 identifier {
4495 document_path {
4496 type: MEMBER
4497 value: "array_red_green_pear"
4498 }
4499 name: "doc"
4500 }
4501 }
4502 }
4503 }
4504 alias: "not_cont_in"
4505 }
4506 }
4507
4508 cont_in not_cont_in
4509 1 0
4510 command ok
4511 Got expected error (code 0)
4512 send Mysqlx.Crud.Find {
4513 collection {
4514 name: "xtable"
4515 schema: "xtest"
4516 }
4517 data_model: TABLE
4518 projection {
4519 source {
4520 type: OPERATOR
4521 operator {
4522 name: "cont_in"
4523 param {
4524 type: LITERAL
4525 literal {
4526 type: V_STRING
4527 v_string {
4528 value: "white"
4529 }
4530 }
4531 }
4532 param {
4533 type: IDENT
4534 identifier {
4535 document_path {
4536 type: MEMBER
4537 value: "array_red_green_pear"
4538 }
4539 name: "doc"
4540 }
4541 }
4542 }
4543 }
4544 alias: "cont_in"
4545 }
4546 projection {
4547 source {
4548 type: OPERATOR
4549 operator {
4550 name: "not_cont_in"
4551 param {
4552 type: LITERAL
4553 literal {
4554 type: V_STRING
4555 v_string {
4556 value: "white"
4557 }
4558 }
4559 }
4560 param {
4561 type: IDENT
4562 identifier {
4563 document_path {
4564 type: MEMBER
4565 value: "array_red_green_pear"
4566 }
4567 name: "doc"
4568 }
4569 }
4570 }
4571 }
4572 alias: "not_cont_in"
4573 }
4574 }
4575
4576 cont_in not_cont_in
4577 0 1
4578 command ok
4579 Got expected error (code 0)
4580
4581 String member in member array
4582 -----------------------------
4583 send Mysqlx.Crud.Find {
4584 collection {
4585 name: "xtable"
4586 schema: "xtest"
4587 }
4588 data_model: TABLE
4589 projection {
4590 source {
4591 type: OPERATOR
4592 operator {
4593 name: "cont_in"
4594 param {
4595 type: IDENT
4596 identifier {
4597 document_path {
4598 type: MEMBER
4599 value: "scalar_red"
4600 }
4601 name: "doc"
4602 }
4603 }
4604 param {
4605 type: IDENT
4606 identifier {
4607 document_path {
4608 type: MEMBER
4609 value: "array_red_green_pear"
4610 }
4611 name: "doc"
4612 }
4613 }
4614 }
4615 }
4616 alias: "cont_in"
4617 }
4618 projection {
4619 source {
4620 type: OPERATOR
4621 operator {
4622 name: "not_cont_in"
4623 param {
4624 type: IDENT
4625 identifier {
4626 document_path {
4627 type: MEMBER
4628 value: "scalar_red"
4629 }
4630 name: "doc"
4631 }
4632 }
4633 param {
4634 type: IDENT
4635 identifier {
4636 document_path {
4637 type: MEMBER
4638 value: "array_red_green_pear"
4639 }
4640 name: "doc"
4641 }
4642 }
4643 }
4644 }
4645 alias: "not_cont_in"
4646 }
4647 }
4648
4649 cont_in not_cont_in
4650 1 0
4651 command ok
4652 Got expected error (code 0)
4653 send Mysqlx.Crud.Find {
4654 collection {
4655 name: "xtable"
4656 schema: "xtest"
4657 }
4658 data_model: TABLE
4659 projection {
4660 source {
4661 type: OPERATOR
4662 operator {
4663 name: "cont_in"
4664 param {
4665 type: IDENT
4666 identifier {
4667 document_path {
4668 type: MEMBER
4669 value: "scalar_banana"
4670 }
4671 name: "doc"
4672 }
4673 }
4674 param {
4675 type: IDENT
4676 identifier {
4677 document_path {
4678 type: MEMBER
4679 value: "array_red_green_pear"
4680 }
4681 name: "doc"
4682 }
4683 }
4684 }
4685 }
4686 alias: "cont_in"
4687 }
4688 projection {
4689 source {
4690 type: OPERATOR
4691 operator {
4692 name: "not_cont_in"
4693 param {
4694 type: IDENT
4695 identifier {
4696 document_path {
4697 type: MEMBER
4698 value: "scalar_banana"
4699 }
4700 name: "doc"
4701 }
4702 }
4703 param {
4704 type: IDENT
4705 identifier {
4706 document_path {
4707 type: MEMBER
4708 value: "array_red_green_pear"
4709 }
4710 name: "doc"
4711 }
4712 }
4713 }
4714 }
4715 alias: "not_cont_in"
4716 }
4717 }
4718
4719 cont_in not_cont_in
4720 0 1
4721 command ok
4722 Got expected error (code 0)
4723
4724 Plain octets literal in member array
4725 ------------------------------------
4726 send Mysqlx.Crud.Find {
4727 collection {
4728 name: "xtable"
4729 schema: "xtest"
4730 }
4731 data_model: TABLE
4732 projection {
4733 source {
4734 type: OPERATOR
4735 operator {
4736 name: "cont_in"
4737 param {
4738 type: LITERAL
4739 literal {
4740 type: V_OCTETS
4741 v_octets {
4742 value: "pear"
4743 content_type: 0
4744 }
4745 }
4746 }
4747 param {
4748 type: IDENT
4749 identifier {
4750 document_path {
4751 type: MEMBER
4752 value: "array_red_green_pear"
4753 }
4754 name: "doc"
4755 }
4756 }
4757 }
4758 }
4759 alias: "cont_in"
4760 }
4761 projection {
4762 source {
4763 type: OPERATOR
4764 operator {
4765 name: "not_cont_in"
4766 param {
4767 type: LITERAL
4768 literal {
4769 type: V_OCTETS
4770 v_octets {
4771 value: "pear"
4772 content_type: 0
4773 }
4774 }
4775 }
4776 param {
4777 type: IDENT
4778 identifier {
4779 document_path {
4780 type: MEMBER
4781 value: "array_red_green_pear"
4782 }
4783 name: "doc"
4784 }
4785 }
4786 }
4787 }
4788 alias: "not_cont_in"
4789 }
4790 }
4791
4792 cont_in not_cont_in
4793 1 0
4794 command ok
4795 Got expected error (code 0)
4796 send Mysqlx.Crud.Find {
4797 collection {
4798 name: "xtable"
4799 schema: "xtest"
4800 }
4801 data_model: TABLE
4802 projection {
4803 source {
4804 type: OPERATOR
4805 operator {
4806 name: "cont_in"
4807 param {
4808 type: LITERAL
4809 literal {
4810 type: V_OCTETS
4811 v_octets {
4812 value: "banana"
4813 content_type: 0
4814 }
4815 }
4816 }
4817 param {
4818 type: IDENT
4819 identifier {
4820 document_path {
4821 type: MEMBER
4822 value: "array_red_green_pear"
4823 }
4824 name: "doc"
4825 }
4826 }
4827 }
4828 }
4829 alias: "cont_in"
4830 }
4831 projection {
4832 source {
4833 type: OPERATOR
4834 operator {
4835 name: "not_cont_in"
4836 param {
4837 type: LITERAL
4838 literal {
4839 type: V_OCTETS
4840 v_octets {
4841 value: "banana"
4842 content_type: 0
4843 }
4844 }
4845 }
4846 param {
4847 type: IDENT
4848 identifier {
4849 document_path {
4850 type: MEMBER
4851 value: "array_red_green_pear"
4852 }
4853 name: "doc"
4854 }
4855 }
4856 }
4857 }
4858 alias: "not_cont_in"
4859 }
4860 }
4861
4862 cont_in not_cont_in
4863 0 1
4864 command ok
4865 Got expected error (code 0)
4866
4867 Json octets object in literal object
4868 ------------------------------------
4869 send Mysqlx.Crud.Find {
4870 collection {
4871 name: "xtable"
4872 schema: "xtest"
4873 }
4874 data_model: TABLE
4875 projection {
4876 source {
4877 type: OPERATOR
4878 operator {
4879 name: "cont_in"
4880 param {
4881 type: LITERAL
4882 literal {
4883 type: V_OCTETS
4884 v_octets {
4885 value: "{\"scalar_10\":10}"
4886 content_type: 2
4887 }
4888 }
4889 }
4890 param {
4891 type: OBJECT
4892 object {
4893 fld {
4894 key: "scalar_10"
4895 value {
4896 type: LITERAL
4897 literal {
4898 type: V_SINT
4899 v_signed_int: 10
4900 }
4901 }
4902 }
4903 }
4904 }
4905 }
4906 }
4907 alias: "cont_in"
4908 }
4909 projection {
4910 source {
4911 type: OPERATOR
4912 operator {
4913 name: "not_cont_in"
4914 param {
4915 type: LITERAL
4916 literal {
4917 type: V_OCTETS
4918 v_octets {
4919 value: "{\"scalar_10\":10}"
4920 content_type: 2
4921 }
4922 }
4923 }
4924 param {
4925 type: OBJECT
4926 object {
4927 fld {
4928 key: "scalar_10"
4929 value {
4930 type: LITERAL
4931 literal {
4932 type: V_SINT
4933 v_signed_int: 10
4934 }
4935 }
4936 }
4937 }
4938 }
4939 }
4940 }
4941 alias: "not_cont_in"
4942 }
4943 }
4944
4945 cont_in not_cont_in
4946 1 0
4947 command ok
4948 Got expected error (code 0)
4949 send Mysqlx.Crud.Find {
4950 collection {
4951 name: "xtable"
4952 schema: "xtest"
4953 }
4954 data_model: TABLE
4955 projection {
4956 source {
4957 type: OPERATOR
4958 operator {
4959 name: "cont_in"
4960 param {
4961 type: LITERAL
4962 literal {
4963 type: V_OCTETS
4964 v_octets {
4965 value: "{\"scalar_blue\":\"blue\"}"
4966 content_type: 2
4967 }
4968 }
4969 }
4970 param {
4971 type: OBJECT
4972 object {
4973 fld {
4974 key: "scalar_10"
4975 value {
4976 type: LITERAL
4977 literal {
4978 type: V_SINT
4979 v_signed_int: 10
4980 }
4981 }
4982 }
4983 }
4984 }
4985 }
4986 }
4987 alias: "cont_in"
4988 }
4989 projection {
4990 source {
4991 type: OPERATOR
4992 operator {
4993 name: "not_cont_in"
4994 param {
4995 type: LITERAL
4996 literal {
4997 type: V_OCTETS
4998 v_octets {
4999 value: "{\"scalar_blue\":\"blue\"}"
5000 content_type: 2
5001 }
5002 }
5003 }
5004 param {
5005 type: OBJECT
5006 object {
5007 fld {
5008 key: "scalar_10"
5009 value {
5010 type: LITERAL
5011 literal {
5012 type: V_SINT
5013 v_signed_int: 10
5014 }
5015 }
5016 }
5017 }
5018 }
5019 }
5020 }
5021 alias: "not_cont_in"
5022 }
5023 }
5024
5025 cont_in not_cont_in
5026 0 1
5027 command ok
5028 Got expected error (code 0)
5029
5030 Literal object in json octets object
5031 ------------------------------------
5032 send Mysqlx.Crud.Find {
5033 collection {
5034 name: "xtable"
5035 schema: "xtest"
5036 }
5037 data_model: TABLE
5038 projection {
5039 source {
5040 type: OPERATOR
5041 operator {
5042 name: "cont_in"
5043 param {
5044 type: OBJECT
5045 object {
5046 fld {
5047 key: "scalar_10"
5048 value {
5049 type: LITERAL
5050 literal {
5051 type: V_SINT
5052 v_signed_int: 10
5053 }
5054 }
5055 }
5056 }
5057 }
5058 param {
5059 type: LITERAL
5060 literal {
5061 type: V_OCTETS
5062 v_octets {
5063 value: "{\"scalar_10\":10}"
5064 content_type: 2
5065 }
5066 }
5067 }
5068 }
5069 }
5070 alias: "cont_in"
5071 }
5072 projection {
5073 source {
5074 type: OPERATOR
5075 operator {
5076 name: "not_cont_in"
5077 param {
5078 type: OBJECT
5079 object {
5080 fld {
5081 key: "scalar_10"
5082 value {
5083 type: LITERAL
5084 literal {
5085 type: V_SINT
5086 v_signed_int: 10
5087 }
5088 }
5089 }
5090 }
5091 }
5092 param {
5093 type: LITERAL
5094 literal {
5095 type: V_OCTETS
5096 v_octets {
5097 value: "{\"scalar_10\":10}"
5098 content_type: 2
5099 }
5100 }
5101 }
5102 }
5103 }
5104 alias: "not_cont_in"
5105 }
5106 }
5107
5108 cont_in not_cont_in
5109 1 0
5110 command ok
5111 Got expected error (code 0)
5112 send Mysqlx.Crud.Find {
5113 collection {
5114 name: "xtable"
5115 schema: "xtest"
5116 }
5117 data_model: TABLE
5118 projection {
5119 source {
5120 type: OPERATOR
5121 operator {
5122 name: "cont_in"
5123 param {
5124 type: OBJECT
5125 object {
5126 fld {
5127 key: "scalar_blue"
5128 value {
5129 type: LITERAL
5130 literal {
5131 type: V_STRING
5132 v_string {
5133 value: "blue"
5134 }
5135 }
5136 }
5137 }
5138 }
5139 }
5140 param {
5141 type: LITERAL
5142 literal {
5143 type: V_OCTETS
5144 v_octets {
5145 value: "{\"scalar_10\":10}"
5146 content_type: 2
5147 }
5148 }
5149 }
5150 }
5151 }
5152 alias: "cont_in"
5153 }
5154 projection {
5155 source {
5156 type: OPERATOR
5157 operator {
5158 name: "not_cont_in"
5159 param {
5160 type: OBJECT
5161 object {
5162 fld {
5163 key: "scalar_blue"
5164 value {
5165 type: LITERAL
5166 literal {
5167 type: V_STRING
5168 v_string {
5169 value: "blue"
5170 }
5171 }
5172 }
5173 }
5174 }
5175 }
5176 param {
5177 type: LITERAL
5178 literal {
5179 type: V_OCTETS
5180 v_octets {
5181 value: "{\"scalar_10\":10}"
5182 content_type: 2
5183 }
5184 }
5185 }
5186 }
5187 }
5188 alias: "not_cont_in"
5189 }
5190 }
5191
5192 cont_in not_cont_in
5193 0 1
5194 command ok
5195 Got expected error (code 0)
5196
5197 Json octets object in literal array
5198 -----------------------------------
5199 send Mysqlx.Crud.Find {
5200 collection {
5201 name: "xtable"
5202 schema: "xtest"
5203 }
5204 data_model: TABLE
5205 projection {
5206 source {
5207 type: OPERATOR
5208 operator {
5209 name: "cont_in"
5210 param {
5211 type: LITERAL
5212 literal {
5213 type: V_OCTETS
5214 v_octets {
5215 value: "{\"scalar_10\":10}"
5216 content_type: 2
5217 }
5218 }
5219 }
5220 param {
5221 type: ARRAY
5222 array {
5223 value {
5224 type: LITERAL
5225 literal {
5226 type: V_SINT
5227 v_signed_int: 30
5228 }
5229 }
5230 value {
5231 type: OBJECT
5232 object {
5233 fld {
5234 key: "scalar_10"
5235 value {
5236 type: LITERAL
5237 literal {
5238 type: V_SINT
5239 v_signed_int: 10
5240 }
5241 }
5242 }
5243 }
5244 }
5245 value {
5246 type: LITERAL
5247 literal {
5248 type: V_STRING
5249 v_string {
5250 value: "white"
5251 }
5252 }
5253 }
5254 }
5255 }
5256 }
5257 }
5258 alias: "cont_in"
5259 }
5260 projection {
5261 source {
5262 type: OPERATOR
5263 operator {
5264 name: "not_cont_in"
5265 param {
5266 type: LITERAL
5267 literal {
5268 type: V_OCTETS
5269 v_octets {
5270 value: "{\"scalar_10\":10}"
5271 content_type: 2
5272 }
5273 }
5274 }
5275 param {
5276 type: ARRAY
5277 array {
5278 value {
5279 type: LITERAL
5280 literal {
5281 type: V_SINT
5282 v_signed_int: 30
5283 }
5284 }
5285 value {
5286 type: OBJECT
5287 object {
5288 fld {
5289 key: "scalar_10"
5290 value {
5291 type: LITERAL
5292 literal {
5293 type: V_SINT
5294 v_signed_int: 10
5295 }
5296 }
5297 }
5298 }
5299 }
5300 value {
5301 type: LITERAL
5302 literal {
5303 type: V_STRING
5304 v_string {
5305 value: "white"
5306 }
5307 }
5308 }
5309 }
5310 }
5311 }
5312 }
5313 alias: "not_cont_in"
5314 }
5315 }
5316
5317 cont_in not_cont_in
5318 1 0
5319 command ok
5320 Got expected error (code 0)
5321 send Mysqlx.Crud.Find {
5322 collection {
5323 name: "xtable"
5324 schema: "xtest"
5325 }
5326 data_model: TABLE
5327 projection {
5328 source {
5329 type: OPERATOR
5330 operator {
5331 name: "cont_in"
5332 param {
5333 type: LITERAL
5334 literal {
5335 type: V_OCTETS
5336 v_octets {
5337 value: "{\"scalar_blue\":\"blue\"}"
5338 content_type: 2
5339 }
5340 }
5341 }
5342 param {
5343 type: ARRAY
5344 array {
5345 value {
5346 type: LITERAL
5347 literal {
5348 type: V_SINT
5349 v_signed_int: 30
5350 }
5351 }
5352 value {
5353 type: OBJECT
5354 object {
5355 fld {
5356 key: "scalar_10"
5357 value {
5358 type: LITERAL
5359 literal {
5360 type: V_SINT
5361 v_signed_int: 10
5362 }
5363 }
5364 }
5365 }
5366 }
5367 value {
5368 type: LITERAL
5369 literal {
5370 type: V_STRING
5371 v_string {
5372 value: "white"
5373 }
5374 }
5375 }
5376 }
5377 }
5378 }
5379 }
5380 alias: "cont_in"
5381 }
5382 projection {
5383 source {
5384 type: OPERATOR
5385 operator {
5386 name: "not_cont_in"
5387 param {
5388 type: LITERAL
5389 literal {
5390 type: V_OCTETS
5391 v_octets {
5392 value: "{\"scalar_blue\":\"blue\"}"
5393 content_type: 2
5394 }
5395 }
5396 }
5397 param {
5398 type: ARRAY
5399 array {
5400 value {
5401 type: LITERAL
5402 literal {
5403 type: V_SINT
5404 v_signed_int: 30
5405 }
5406 }
5407 value {
5408 type: OBJECT
5409 object {
5410 fld {
5411 key: "scalar_10"
5412 value {
5413 type: LITERAL
5414 literal {
5415 type: V_SINT
5416 v_signed_int: 10
5417 }
5418 }
5419 }
5420 }
5421 }
5422 value {
5423 type: LITERAL
5424 literal {
5425 type: V_STRING
5426 v_string {
5427 value: "white"
5428 }
5429 }
5430 }
5431 }
5432 }
5433 }
5434 }
5435 alias: "not_cont_in"
5436 }
5437 }
5438
5439 cont_in not_cont_in
5440 0 1
5441 command ok
5442 Got expected error (code 0)
5443
5444 Literal object in literal array
5445 -------------------------------
5446 send Mysqlx.Crud.Find {
5447 collection {
5448 name: "xtable"
5449 schema: "xtest"
5450 }
5451 data_model: TABLE
5452 projection {
5453 source {
5454 type: OPERATOR
5455 operator {
5456 name: "cont_in"
5457 param {
5458 type: OBJECT
5459 object {
5460 fld {
5461 key: "scalar_10"
5462 value {
5463 type: LITERAL
5464 literal {
5465 type: V_SINT
5466 v_signed_int: 10
5467 }
5468 }
5469 }
5470 }
5471 }
5472 param {
5473 type: ARRAY
5474 array {
5475 value {
5476 type: LITERAL
5477 literal {
5478 type: V_SINT
5479 v_signed_int: 30
5480 }
5481 }
5482 value {
5483 type: OBJECT
5484 object {
5485 fld {
5486 key: "scalar_10"
5487 value {
5488 type: LITERAL
5489 literal {
5490 type: V_SINT
5491 v_signed_int: 10
5492 }
5493 }
5494 }
5495 }
5496 }
5497 value {
5498 type: LITERAL
5499 literal {
5500 type: V_STRING
5501 v_string {
5502 value: "white"
5503 }
5504 }
5505 }
5506 }
5507 }
5508 }
5509 }
5510 alias: "cont_in"
5511 }
5512 projection {
5513 source {
5514 type: OPERATOR
5515 operator {
5516 name: "not_cont_in"
5517 param {
5518 type: OBJECT
5519 object {
5520 fld {
5521 key: "scalar_10"
5522 value {
5523 type: LITERAL
5524 literal {
5525 type: V_SINT
5526 v_signed_int: 10
5527 }
5528 }
5529 }
5530 }
5531 }
5532 param {
5533 type: ARRAY
5534 array {
5535 value {
5536 type: LITERAL
5537 literal {
5538 type: V_SINT
5539 v_signed_int: 30
5540 }
5541 }
5542 value {
5543 type: OBJECT
5544 object {
5545 fld {
5546 key: "scalar_10"
5547 value {
5548 type: LITERAL
5549 literal {
5550 type: V_SINT
5551 v_signed_int: 10
5552 }
5553 }
5554 }
5555 }
5556 }
5557 value {
5558 type: LITERAL
5559 literal {
5560 type: V_STRING
5561 v_string {
5562 value: "white"
5563 }
5564 }
5565 }
5566 }
5567 }
5568 }
5569 }
5570 alias: "not_cont_in"
5571 }
5572 }
5573
5574 cont_in not_cont_in
5575 1 0
5576 command ok
5577 Got expected error (code 0)
5578 send Mysqlx.Crud.Find {
5579 collection {
5580 name: "xtable"
5581 schema: "xtest"
5582 }
5583 data_model: TABLE
5584 projection {
5585 source {
5586 type: OPERATOR
5587 operator {
5588 name: "cont_in"
5589 param {
5590 type: OBJECT
5591 object {
5592 fld {
5593 key: "scalar_blue"
5594 value {
5595 type: LITERAL
5596 literal {
5597 type: V_STRING
5598 v_string {
5599 value: "blue"
5600 }
5601 }
5602 }
5603 }
5604 }
5605 }
5606 param {
5607 type: ARRAY
5608 array {
5609 value {
5610 type: LITERAL
5611 literal {
5612 type: V_SINT
5613 v_signed_int: 30
5614 }
5615 }
5616 value {
5617 type: OBJECT
5618 object {
5619 fld {
5620 key: "scalar_10"
5621 value {
5622 type: LITERAL
5623 literal {
5624 type: V_SINT
5625 v_signed_int: 10
5626 }
5627 }
5628 }
5629 }
5630 }
5631 value {
5632 type: LITERAL
5633 literal {
5634 type: V_STRING
5635 v_string {
5636 value: "white"
5637 }
5638 }
5639 }
5640 }
5641 }
5642 }
5643 }
5644 alias: "cont_in"
5645 }
5646 projection {
5647 source {
5648 type: OPERATOR
5649 operator {
5650 name: "not_cont_in"
5651 param {
5652 type: OBJECT
5653 object {
5654 fld {
5655 key: "scalar_blue"
5656 value {
5657 type: LITERAL
5658 literal {
5659 type: V_STRING
5660 v_string {
5661 value: "blue"
5662 }
5663 }
5664 }
5665 }
5666 }
5667 }
5668 param {
5669 type: ARRAY
5670 array {
5671 value {
5672 type: LITERAL
5673 literal {
5674 type: V_SINT
5675 v_signed_int: 30
5676 }
5677 }
5678 value {
5679 type: OBJECT
5680 object {
5681 fld {
5682 key: "scalar_10"
5683 value {
5684 type: LITERAL
5685 literal {
5686 type: V_SINT
5687 v_signed_int: 10
5688 }
5689 }
5690 }
5691 }
5692 }
5693 value {
5694 type: LITERAL
5695 literal {
5696 type: V_STRING
5697 v_string {
5698 value: "white"
5699 }
5700 }
5701 }
5702 }
5703 }
5704 }
5705 }
5706 alias: "not_cont_in"
5707 }
5708 }
5709
5710 cont_in not_cont_in
5711 0 1
5712 command ok
5713 Got expected error (code 0)
5714
5715 Literal object in document
5716 --------------------------
5717 send Mysqlx.Crud.Find {
5718 collection {
5719 name: "xtable"
5720 schema: "xtest"
5721 }
5722 data_model: TABLE
5723 projection {
5724 source {
5725 type: OPERATOR
5726 operator {
5727 name: "cont_in"
5728 param {
5729 type: OBJECT
5730 object {
5731 fld {
5732 key: "scalar_10"
5733 value {
5734 type: LITERAL
5735 literal {
5736 type: V_SINT
5737 v_signed_int: 10
5738 }
5739 }
5740 }
5741 }
5742 }
5743 param {
5744 type: IDENT
5745 identifier {
5746 document_path {
5747 type: MEMBER
5748 }
5749 name: "doc"
5750 }
5751 }
5752 }
5753 }
5754 alias: "cont_in"
5755 }
5756 projection {
5757 source {
5758 type: OPERATOR
5759 operator {
5760 name: "not_cont_in"
5761 param {
5762 type: OBJECT
5763 object {
5764 fld {
5765 key: "scalar_10"
5766 value {
5767 type: LITERAL
5768 literal {
5769 type: V_SINT
5770 v_signed_int: 10
5771 }
5772 }
5773 }
5774 }
5775 }
5776 param {
5777 type: IDENT
5778 identifier {
5779 document_path {
5780 type: MEMBER
5781 }
5782 name: "doc"
5783 }
5784 }
5785 }
5786 }
5787 alias: "not_cont_in"
5788 }
5789 }
5790
5791 cont_in not_cont_in
5792 1 0
5793 command ok
5794 Got expected error (code 0)
5795 send Mysqlx.Crud.Find {
5796 collection {
5797 name: "xtable"
5798 schema: "xtest"
5799 }
5800 data_model: TABLE
5801 projection {
5802 source {
5803 type: OPERATOR
5804 operator {
5805 name: "cont_in"
5806 param {
5807 type: OBJECT
5808 object {
5809 fld {
5810 key: "scalar_blue"
5811 value {
5812 type: LITERAL
5813 literal {
5814 type: V_STRING
5815 v_string {
5816 value: "blue"
5817 }
5818 }
5819 }
5820 }
5821 }
5822 }
5823 param {
5824 type: IDENT
5825 identifier {
5826 document_path {
5827 type: MEMBER
5828 }
5829 name: "doc"
5830 }
5831 }
5832 }
5833 }
5834 alias: "cont_in"
5835 }
5836 projection {
5837 source {
5838 type: OPERATOR
5839 operator {
5840 name: "not_cont_in"
5841 param {
5842 type: OBJECT
5843 object {
5844 fld {
5845 key: "scalar_blue"
5846 value {
5847 type: LITERAL
5848 literal {
5849 type: V_STRING
5850 v_string {
5851 value: "blue"
5852 }
5853 }
5854 }
5855 }
5856 }
5857 }
5858 param {
5859 type: IDENT
5860 identifier {
5861 document_path {
5862 type: MEMBER
5863 }
5864 name: "doc"
5865 }
5866 }
5867 }
5868 }
5869 alias: "not_cont_in"
5870 }
5871 }
5872
5873 cont_in not_cont_in
5874 0 1
5875 command ok
5876 Got expected error (code 0)
5877
5878 Json octets object in document
5879 ------------------------------
5880 send Mysqlx.Crud.Find {
5881 collection {
5882 name: "xtable"
5883 schema: "xtest"
5884 }
5885 data_model: TABLE
5886 projection {
5887 source {
5888 type: OPERATOR
5889 operator {
5890 name: "cont_in"
5891 param {
5892 type: LITERAL
5893 literal {
5894 type: V_OCTETS
5895 v_octets {
5896 value: "{\"scalar_10\":10}"
5897 content_type: 2
5898 }
5899 }
5900 }
5901 param {
5902 type: IDENT
5903 identifier {
5904 document_path {
5905 type: MEMBER
5906 }
5907 name: "doc"
5908 }
5909 }
5910 }
5911 }
5912 alias: "cont_in"
5913 }
5914 projection {
5915 source {
5916 type: OPERATOR
5917 operator {
5918 name: "not_cont_in"
5919 param {
5920 type: LITERAL
5921 literal {
5922 type: V_OCTETS
5923 v_octets {
5924 value: "{\"scalar_10\":10}"
5925 content_type: 2
5926 }
5927 }
5928 }
5929 param {
5930 type: IDENT
5931 identifier {
5932 document_path {
5933 type: MEMBER
5934 }
5935 name: "doc"
5936 }
5937 }
5938 }
5939 }
5940 alias: "not_cont_in"
5941 }
5942 }
5943
5944 cont_in not_cont_in
5945 1 0
5946 command ok
5947 Got expected error (code 0)
5948 send Mysqlx.Crud.Find {
5949 collection {
5950 name: "xtable"
5951 schema: "xtest"
5952 }
5953 data_model: TABLE
5954 projection {
5955 source {
5956 type: OPERATOR
5957 operator {
5958 name: "cont_in"
5959 param {
5960 type: LITERAL
5961 literal {
5962 type: V_OCTETS
5963 v_octets {
5964 value: "{\"scalar_blue\":\"blue\"}"
5965 content_type: 2
5966 }
5967 }
5968 }
5969 param {
5970 type: IDENT
5971 identifier {
5972 document_path {
5973 type: MEMBER
5974 }
5975 name: "doc"
5976 }
5977 }
5978 }
5979 }
5980 alias: "cont_in"
5981 }
5982 projection {
5983 source {
5984 type: OPERATOR
5985 operator {
5986 name: "not_cont_in"
5987 param {
5988 type: LITERAL
5989 literal {
5990 type: V_OCTETS
5991 v_octets {
5992 value: "{\"scalar_blue\":\"blue\"}"
5993 content_type: 2
5994 }
5995 }
5996 }
5997 param {
5998 type: IDENT
5999 identifier {
6000 document_path {
6001 type: MEMBER
6002 }
6003 name: "doc"
6004 }
6005 }
6006 }
6007 }
6008 alias: "not_cont_in"
6009 }
6010 }
6011
6012 cont_in not_cont_in
6013 0 1
6014 command ok
6015 Got expected error (code 0)
6016
6017 Literal object in member object
6018 -------------------------------
6019 send Mysqlx.Crud.Find {
6020 collection {
6021 name: "xtable"
6022 schema: "xtest"
6023 }
6024 data_model: TABLE
6025 projection {
6026 source {
6027 type: OPERATOR
6028 operator {
6029 name: "cont_in"
6030 param {
6031 type: OBJECT
6032 object {
6033 fld {
6034 key: "scalar_10"
6035 value {
6036 type: LITERAL
6037 literal {
6038 type: V_SINT
6039 v_signed_int: 10
6040 }
6041 }
6042 }
6043 }
6044 }
6045 param {
6046 type: IDENT
6047 identifier {
6048 document_path {
6049 type: MEMBER
6050 value: "object_scalar_10"
6051 }
6052 name: "doc"
6053 }
6054 }
6055 }
6056 }
6057 alias: "cont_in"
6058 }
6059 projection {
6060 source {
6061 type: OPERATOR
6062 operator {
6063 name: "not_cont_in"
6064 param {
6065 type: OBJECT
6066 object {
6067 fld {
6068 key: "scalar_10"
6069 value {
6070 type: LITERAL
6071 literal {
6072 type: V_SINT
6073 v_signed_int: 10
6074 }
6075 }
6076 }
6077 }
6078 }
6079 param {
6080 type: IDENT
6081 identifier {
6082 document_path {
6083 type: MEMBER
6084 value: "object_scalar_10"
6085 }
6086 name: "doc"
6087 }
6088 }
6089 }
6090 }
6091 alias: "not_cont_in"
6092 }
6093 }
6094
6095 cont_in not_cont_in
6096 1 0
6097 command ok
6098 Got expected error (code 0)
6099 send Mysqlx.Crud.Find {
6100 collection {
6101 name: "xtable"
6102 schema: "xtest"
6103 }
6104 data_model: TABLE
6105 projection {
6106 source {
6107 type: OPERATOR
6108 operator {
6109 name: "cont_in"
6110 param {
6111 type: OBJECT
6112 object {
6113 fld {
6114 key: "scalar_blue"
6115 value {
6116 type: LITERAL
6117 literal {
6118 type: V_STRING
6119 v_string {
6120 value: "blue"
6121 }
6122 }
6123 }
6124 }
6125 }
6126 }
6127 param {
6128 type: IDENT
6129 identifier {
6130 document_path {
6131 type: MEMBER
6132 value: "object_scalar_10"
6133 }
6134 name: "doc"
6135 }
6136 }
6137 }
6138 }
6139 alias: "cont_in"
6140 }
6141 projection {
6142 source {
6143 type: OPERATOR
6144 operator {
6145 name: "not_cont_in"
6146 param {
6147 type: OBJECT
6148 object {
6149 fld {
6150 key: "scalar_blue"
6151 value {
6152 type: LITERAL
6153 literal {
6154 type: V_STRING
6155 v_string {
6156 value: "blue"
6157 }
6158 }
6159 }
6160 }
6161 }
6162 }
6163 param {
6164 type: IDENT
6165 identifier {
6166 document_path {
6167 type: MEMBER
6168 value: "object_scalar_10"
6169 }
6170 name: "doc"
6171 }
6172 }
6173 }
6174 }
6175 alias: "not_cont_in"
6176 }
6177 }
6178
6179 cont_in not_cont_in
6180 0 1
6181 command ok
6182 Got expected error (code 0)
6183
6184 Json octets object in member object
6185 -----------------------------------
6186 send Mysqlx.Crud.Find {
6187 collection {
6188 name: "xtable"
6189 schema: "xtest"
6190 }
6191 data_model: TABLE
6192 projection {
6193 source {
6194 type: OPERATOR
6195 operator {
6196 name: "cont_in"
6197 param {
6198 type: LITERAL
6199 literal {
6200 type: V_OCTETS
6201 v_octets {
6202 value: "{\"scalar_10\":10}"
6203 content_type: 2
6204 }
6205 }
6206 }
6207 param {
6208 type: IDENT
6209 identifier {
6210 document_path {
6211 type: MEMBER
6212 value: "object_scalar_10"
6213 }
6214 name: "doc"
6215 }
6216 }
6217 }
6218 }
6219 alias: "cont_in"
6220 }
6221 projection {
6222 source {
6223 type: OPERATOR
6224 operator {
6225 name: "not_cont_in"
6226 param {
6227 type: LITERAL
6228 literal {
6229 type: V_OCTETS
6230 v_octets {
6231 value: "{\"scalar_10\":10}"
6232 content_type: 2
6233 }
6234 }
6235 }
6236 param {
6237 type: IDENT
6238 identifier {
6239 document_path {
6240 type: MEMBER
6241 value: "object_scalar_10"
6242 }
6243 name: "doc"
6244 }
6245 }
6246 }
6247 }
6248 alias: "not_cont_in"
6249 }
6250 }
6251
6252 cont_in not_cont_in
6253 1 0
6254 command ok
6255 Got expected error (code 0)
6256 send Mysqlx.Crud.Find {
6257 collection {
6258 name: "xtable"
6259 schema: "xtest"
6260 }
6261 data_model: TABLE
6262 projection {
6263 source {
6264 type: OPERATOR
6265 operator {
6266 name: "cont_in"
6267 param {
6268 type: LITERAL
6269 literal {
6270 type: V_OCTETS
6271 v_octets {
6272 value: "{\"scalar_blue\":\"blue\"}"
6273 content_type: 2
6274 }
6275 }
6276 }
6277 param {
6278 type: IDENT
6279 identifier {
6280 document_path {
6281 type: MEMBER
6282 value: "object_scalar_10"
6283 }
6284 name: "doc"
6285 }
6286 }
6287 }
6288 }
6289 alias: "cont_in"
6290 }
6291 projection {
6292 source {
6293 type: OPERATOR
6294 operator {
6295 name: "not_cont_in"
6296 param {
6297 type: LITERAL
6298 literal {
6299 type: V_OCTETS
6300 v_octets {
6301 value: "{\"scalar_blue\":\"blue\"}"
6302 content_type: 2
6303 }
6304 }
6305 }
6306 param {
6307 type: IDENT
6308 identifier {
6309 document_path {
6310 type: MEMBER
6311 value: "object_scalar_10"
6312 }
6313 name: "doc"
6314 }
6315 }
6316 }
6317 }
6318 alias: "not_cont_in"
6319 }
6320 }
6321
6322 cont_in not_cont_in
6323 0 1
6324 command ok
6325 Got expected error (code 0)
6326
6327 Member object in literal object
6328 -------------------------------
6329 send Mysqlx.Crud.Find {
6330 collection {
6331 name: "xtable"
6332 schema: "xtest"
6333 }
6334 data_model: TABLE
6335 projection {
6336 source {
6337 type: OPERATOR
6338 operator {
6339 name: "cont_in"
6340 param {
6341 type: IDENT
6342 identifier {
6343 document_path {
6344 type: MEMBER
6345 value: "object_scalar_10"
6346 }
6347 name: "doc"
6348 }
6349 }
6350 param {
6351 type: OBJECT
6352 object {
6353 fld {
6354 key: "scalar_10"
6355 value {
6356 type: LITERAL
6357 literal {
6358 type: V_SINT
6359 v_signed_int: 10
6360 }
6361 }
6362 }
6363 }
6364 }
6365 }
6366 }
6367 alias: "cont_in"
6368 }
6369 projection {
6370 source {
6371 type: OPERATOR
6372 operator {
6373 name: "not_cont_in"
6374 param {
6375 type: IDENT
6376 identifier {
6377 document_path {
6378 type: MEMBER
6379 value: "object_scalar_10"
6380 }
6381 name: "doc"
6382 }
6383 }
6384 param {
6385 type: OBJECT
6386 object {
6387 fld {
6388 key: "scalar_10"
6389 value {
6390 type: LITERAL
6391 literal {
6392 type: V_SINT
6393 v_signed_int: 10
6394 }
6395 }
6396 }
6397 }
6398 }
6399 }
6400 }
6401 alias: "not_cont_in"
6402 }
6403 }
6404
6405 cont_in not_cont_in
6406 1 0
6407 command ok
6408 Got expected error (code 0)
6409 send Mysqlx.Crud.Find {
6410 collection {
6411 name: "xtable"
6412 schema: "xtest"
6413 }
6414 data_model: TABLE
6415 projection {
6416 source {
6417 type: OPERATOR
6418 operator {
6419 name: "cont_in"
6420 param {
6421 type: IDENT
6422 identifier {
6423 document_path {
6424 type: MEMBER
6425 value: "object_scalar_red"
6426 }
6427 name: "doc"
6428 }
6429 }
6430 param {
6431 type: OBJECT
6432 object {
6433 fld {
6434 key: "scalar_10"
6435 value {
6436 type: LITERAL
6437 literal {
6438 type: V_SINT
6439 v_signed_int: 10
6440 }
6441 }
6442 }
6443 }
6444 }
6445 }
6446 }
6447 alias: "cont_in"
6448 }
6449 projection {
6450 source {
6451 type: OPERATOR
6452 operator {
6453 name: "not_cont_in"
6454 param {
6455 type: IDENT
6456 identifier {
6457 document_path {
6458 type: MEMBER
6459 value: "object_scalar_red"
6460 }
6461 name: "doc"
6462 }
6463 }
6464 param {
6465 type: OBJECT
6466 object {
6467 fld {
6468 key: "scalar_10"
6469 value {
6470 type: LITERAL
6471 literal {
6472 type: V_SINT
6473 v_signed_int: 10
6474 }
6475 }
6476 }
6477 }
6478 }
6479 }
6480 }
6481 alias: "not_cont_in"
6482 }
6483 }
6484
6485 cont_in not_cont_in
6486 0 1
6487 command ok
6488 Got expected error (code 0)
6489
6490 Member object in json octets object
6491 -----------------------------------
6492 send Mysqlx.Crud.Find {
6493 collection {
6494 name: "xtable"
6495 schema: "xtest"
6496 }
6497 data_model: TABLE
6498 projection {
6499 source {
6500 type: OPERATOR
6501 operator {
6502 name: "cont_in"
6503 param {
6504 type: IDENT
6505 identifier {
6506 document_path {
6507 type: MEMBER
6508 value: "object_scalar_10"
6509 }
6510 name: "doc"
6511 }
6512 }
6513 param {
6514 type: LITERAL
6515 literal {
6516 type: V_OCTETS
6517 v_octets {
6518 value: "{\"scalar_10\":10}"
6519 content_type: 2
6520 }
6521 }
6522 }
6523 }
6524 }
6525 alias: "cont_in"
6526 }
6527 projection {
6528 source {
6529 type: OPERATOR
6530 operator {
6531 name: "not_cont_in"
6532 param {
6533 type: IDENT
6534 identifier {
6535 document_path {
6536 type: MEMBER
6537 value: "object_scalar_10"
6538 }
6539 name: "doc"
6540 }
6541 }
6542 param {
6543 type: LITERAL
6544 literal {
6545 type: V_OCTETS
6546 v_octets {
6547 value: "{\"scalar_10\":10}"
6548 content_type: 2
6549 }
6550 }
6551 }
6552 }
6553 }
6554 alias: "not_cont_in"
6555 }
6556 }
6557
6558 cont_in not_cont_in
6559 1 0
6560 command ok
6561 Got expected error (code 0)
6562 send Mysqlx.Crud.Find {
6563 collection {
6564 name: "xtable"
6565 schema: "xtest"
6566 }
6567 data_model: TABLE
6568 projection {
6569 source {
6570 type: OPERATOR
6571 operator {
6572 name: "cont_in"
6573 param {
6574 type: IDENT
6575 identifier {
6576 document_path {
6577 type: MEMBER
6578 value: "object_scalar_red"
6579 }
6580 name: "doc"
6581 }
6582 }
6583 param {
6584 type: LITERAL
6585 literal {
6586 type: V_OCTETS
6587 v_octets {
6588 value: "{\"scalar_10\":10}"
6589 content_type: 2
6590 }
6591 }
6592 }
6593 }
6594 }
6595 alias: "cont_in"
6596 }
6597 projection {
6598 source {
6599 type: OPERATOR
6600 operator {
6601 name: "not_cont_in"
6602 param {
6603 type: IDENT
6604 identifier {
6605 document_path {
6606 type: MEMBER
6607 value: "object_scalar_red"
6608 }
6609 name: "doc"
6610 }
6611 }
6612 param {
6613 type: LITERAL
6614 literal {
6615 type: V_OCTETS
6616 v_octets {
6617 value: "{\"scalar_10\":10}"
6618 content_type: 2
6619 }
6620 }
6621 }
6622 }
6623 }
6624 alias: "not_cont_in"
6625 }
6626 }
6627
6628 cont_in not_cont_in
6629 0 1
6630 command ok
6631 Got expected error (code 0)
6632
6633 Member object in literal array
6634 ------------------------------
6635 send Mysqlx.Crud.Find {
6636 collection {
6637 name: "xtable"
6638 schema: "xtest"
6639 }
6640 data_model: TABLE
6641 projection {
6642 source {
6643 type: OPERATOR
6644 operator {
6645 name: "cont_in"
6646 param {
6647 type: IDENT
6648 identifier {
6649 document_path {
6650 type: MEMBER
6651 value: "object_scalar_10"
6652 }
6653 name: "doc"
6654 }
6655 }
6656 param {
6657 type: ARRAY
6658 array {
6659 value {
6660 type: LITERAL
6661 literal {
6662 type: V_SINT
6663 v_signed_int: 30
6664 }
6665 }
6666 value {
6667 type: OBJECT
6668 object {
6669 fld {
6670 key: "scalar_10"
6671 value {
6672 type: LITERAL
6673 literal {
6674 type: V_SINT
6675 v_signed_int: 10
6676 }
6677 }
6678 }
6679 }
6680 }
6681 value {
6682 type: LITERAL
6683 literal {
6684 type: V_STRING
6685 v_string {
6686 value: "white"
6687 }
6688 }
6689 }
6690 }
6691 }
6692 }
6693 }
6694 alias: "cont_in"
6695 }
6696 projection {
6697 source {
6698 type: OPERATOR
6699 operator {
6700 name: "not_cont_in"
6701 param {
6702 type: IDENT
6703 identifier {
6704 document_path {
6705 type: MEMBER
6706 value: "object_scalar_10"
6707 }
6708 name: "doc"
6709 }
6710 }
6711 param {
6712 type: ARRAY
6713 array {
6714 value {
6715 type: LITERAL
6716 literal {
6717 type: V_SINT
6718 v_signed_int: 30
6719 }
6720 }
6721 value {
6722 type: OBJECT
6723 object {
6724 fld {
6725 key: "scalar_10"
6726 value {
6727 type: LITERAL
6728 literal {
6729 type: V_SINT
6730 v_signed_int: 10
6731 }
6732 }
6733 }
6734 }
6735 }
6736 value {
6737 type: LITERAL
6738 literal {
6739 type: V_STRING
6740 v_string {
6741 value: "white"
6742 }
6743 }
6744 }
6745 }
6746 }
6747 }
6748 }
6749 alias: "not_cont_in"
6750 }
6751 }
6752
6753 cont_in not_cont_in
6754 1 0
6755 command ok
6756 Got expected error (code 0)
6757 send Mysqlx.Crud.Find {
6758 collection {
6759 name: "xtable"
6760 schema: "xtest"
6761 }
6762 data_model: TABLE
6763 projection {
6764 source {
6765 type: OPERATOR
6766 operator {
6767 name: "cont_in"
6768 param {
6769 type: IDENT
6770 identifier {
6771 document_path {
6772 type: MEMBER
6773 value: "object_scalar_red"
6774 }
6775 name: "doc"
6776 }
6777 }
6778 param {
6779 type: ARRAY
6780 array {
6781 value {
6782 type: LITERAL
6783 literal {
6784 type: V_SINT
6785 v_signed_int: 30
6786 }
6787 }
6788 value {
6789 type: OBJECT
6790 object {
6791 fld {
6792 key: "scalar_10"
6793 value {
6794 type: LITERAL
6795 literal {
6796 type: V_SINT
6797 v_signed_int: 10
6798 }
6799 }
6800 }
6801 }
6802 }
6803 value {
6804 type: LITERAL
6805 literal {
6806 type: V_STRING
6807 v_string {
6808 value: "white"
6809 }
6810 }
6811 }
6812 }
6813 }
6814 }
6815 }
6816 alias: "cont_in"
6817 }
6818 projection {
6819 source {
6820 type: OPERATOR
6821 operator {
6822 name: "not_cont_in"
6823 param {
6824 type: IDENT
6825 identifier {
6826 document_path {
6827 type: MEMBER
6828 value: "object_scalar_red"
6829 }
6830 name: "doc"
6831 }
6832 }
6833 param {
6834 type: ARRAY
6835 array {
6836 value {
6837 type: LITERAL
6838 literal {
6839 type: V_SINT
6840 v_signed_int: 30
6841 }
6842 }
6843 value {
6844 type: OBJECT
6845 object {
6846 fld {
6847 key: "scalar_10"
6848 value {
6849 type: LITERAL
6850 literal {
6851 type: V_SINT
6852 v_signed_int: 10
6853 }
6854 }
6855 }
6856 }
6857 }
6858 value {
6859 type: LITERAL
6860 literal {
6861 type: V_STRING
6862 v_string {
6863 value: "white"
6864 }
6865 }
6866 }
6867 }
6868 }
6869 }
6870 }
6871 alias: "not_cont_in"
6872 }
6873 }
6874
6875 cont_in not_cont_in
6876 0 1
6877 command ok
6878 Got expected error (code 0)
6879
6880 op+ directly to cont_in in literal array
6881 ----------------------------------------
6882 send Mysqlx.Crud.Find {
6883 collection {
6884 name: "xtable"
6885 schema: "xtest"
6886 }
6887 data_model: TABLE
6888 projection {
6889 source {
6890 type: OPERATOR
6891 operator {
6892 name: "cont_in"
6893 param {
6894 type: OPERATOR
6895 operator {
6896 name: "+"
6897 param {
6898 type: LITERAL
6899 literal {
6900 type: V_SINT
6901 v_signed_int: 10
6902 }
6903 }
6904 param {
6905 type: LITERAL
6906 literal {
6907 type: V_SINT
6908 v_signed_int: 20
6909 }
6910 }
6911 }
6912 }
6913 param {
6914 type: ARRAY
6915 array {
6916 value {
6917 type: LITERAL
6918 literal {
6919 type: V_SINT
6920 v_signed_int: 10
6921 }
6922 }
6923 value {
6924 type: LITERAL
6925 literal {
6926 type: V_SINT
6927 v_signed_int: 20
6928 }
6929 }
6930 value {
6931 type: LITERAL
6932 literal {
6933 type: V_SINT
6934 v_signed_int: 30
6935 }
6936 }
6937 }
6938 }
6939 }
6940 }
6941 alias: "cont_in"
6942 }
6943 projection {
6944 source {
6945 type: OPERATOR
6946 operator {
6947 name: "not_cont_in"
6948 param {
6949 type: OPERATOR
6950 operator {
6951 name: "+"
6952 param {
6953 type: LITERAL
6954 literal {
6955 type: V_SINT
6956 v_signed_int: 10
6957 }
6958 }
6959 param {
6960 type: LITERAL
6961 literal {
6962 type: V_SINT
6963 v_signed_int: 20
6964 }
6965 }
6966 }
6967 }
6968 param {
6969 type: ARRAY
6970 array {
6971 value {
6972 type: LITERAL
6973 literal {
6974 type: V_SINT
6975 v_signed_int: 10
6976 }
6977 }
6978 value {
6979 type: LITERAL
6980 literal {
6981 type: V_SINT
6982 v_signed_int: 20
6983 }
6984 }
6985 value {
6986 type: LITERAL
6987 literal {
6988 type: V_SINT
6989 v_signed_int: 30
6990 }
6991 }
6992 }
6993 }
6994 }
6995 }
6996 alias: "not_cont_in"
6997 }
6998 }
6999
7000 Got expected error: CONT_IN expression requires operator that produce a JSON value. (code 5154)
7001
7002 op+ casted to uint in literal array
7003 -----------------------------------
7004 send Mysqlx.Crud.Find {
7005 collection {
7006 name: "xtable"
7007 schema: "xtest"
7008 }
7009 data_model: TABLE
7010 projection {
7011 source {
7012 type: OPERATOR
7013 operator {
7014 name: "cont_in"
7015 param {
7016 type: OPERATOR
7017 operator {
7018 name: "cast"
7019 param {
7020 type: OPERATOR
7021 operator {
7022 name: "+"
7023 param {
7024 type: LITERAL
7025 literal {
7026 type: V_SINT
7027 v_signed_int: 10
7028 }
7029 }
7030 param {
7031 type: LITERAL
7032 literal {
7033 type: V_SINT
7034 v_signed_int: 20
7035 }
7036 }
7037 }
7038 }
7039 param {
7040 type: LITERAL
7041 literal {
7042 type: V_OCTETS
7043 v_octets {
7044 value: "UNSIGNED INTEGER"
7045 }
7046 }
7047 }
7048 }
7049 }
7050 param {
7051 type: ARRAY
7052 array {
7053 value {
7054 type: LITERAL
7055 literal {
7056 type: V_SINT
7057 v_signed_int: 10
7058 }
7059 }
7060 value {
7061 type: LITERAL
7062 literal {
7063 type: V_SINT
7064 v_signed_int: 20
7065 }
7066 }
7067 value {
7068 type: LITERAL
7069 literal {
7070 type: V_SINT
7071 v_signed_int: 30
7072 }
7073 }
7074 }
7075 }
7076 }
7077 }
7078 alias: "cont_in"
7079 }
7080 projection {
7081 source {
7082 type: OPERATOR
7083 operator {
7084 name: "not_cont_in"
7085 param {
7086 type: OPERATOR
7087 operator {
7088 name: "cast"
7089 param {
7090 type: OPERATOR
7091 operator {
7092 name: "+"
7093 param {
7094 type: LITERAL
7095 literal {
7096 type: V_SINT
7097 v_signed_int: 10
7098 }
7099 }
7100 param {
7101 type: LITERAL
7102 literal {
7103 type: V_SINT
7104 v_signed_int: 20
7105 }
7106 }
7107 }
7108 }
7109 param {
7110 type: LITERAL
7111 literal {
7112 type: V_OCTETS
7113 v_octets {
7114 value: "UNSIGNED INTEGER"
7115 }
7116 }
7117 }
7118 }
7119 }
7120 param {
7121 type: ARRAY
7122 array {
7123 value {
7124 type: LITERAL
7125 literal {
7126 type: V_SINT
7127 v_signed_int: 10
7128 }
7129 }
7130 value {
7131 type: LITERAL
7132 literal {
7133 type: V_SINT
7134 v_signed_int: 20
7135 }
7136 }
7137 value {
7138 type: LITERAL
7139 literal {
7140 type: V_SINT
7141 v_signed_int: 30
7142 }
7143 }
7144 }
7145 }
7146 }
7147 }
7148 alias: "not_cont_in"
7149 }
7150 }
7151
7152 Got expected error: CONT_IN expression requires operator that produce a JSON value. (code 5154)
7153
7154 literal uint in op+ casted to uint
7155 ----------------------------------
7156 send Mysqlx.Crud.Find {
7157 collection {
7158 name: "xtable"
7159 schema: "xtest"
7160 }
7161 data_model: TABLE
7162 projection {
7163 source {
7164 type: OPERATOR
7165 operator {
7166 name: "cont_in"
7167 param {
7168 type: LITERAL
7169 literal {
7170 type: V_SINT
7171 v_signed_int: 30
7172 }
7173 }
7174 param {
7175 type: OPERATOR
7176 operator {
7177 name: "cast"
7178 param {
7179 type: OPERATOR
7180 operator {
7181 name: "+"
7182 param {
7183 type: LITERAL
7184 literal {
7185 type: V_SINT
7186 v_signed_int: 10
7187 }
7188 }
7189 param {
7190 type: LITERAL
7191 literal {
7192 type: V_SINT
7193 v_signed_int: 20
7194 }
7195 }
7196 }
7197 }
7198 param {
7199 type: LITERAL
7200 literal {
7201 type: V_OCTETS
7202 v_octets {
7203 value: "UNSIGNED INTEGER"
7204 }
7205 }
7206 }
7207 }
7208 }
7209 }
7210 }
7211 alias: "cont_in"
7212 }
7213 projection {
7214 source {
7215 type: OPERATOR
7216 operator {
7217 name: "not_cont_in"
7218 param {
7219 type: LITERAL
7220 literal {
7221 type: V_SINT
7222 v_signed_int: 30
7223 }
7224 }
7225 param {
7226 type: OPERATOR
7227 operator {
7228 name: "cast"
7229 param {
7230 type: OPERATOR
7231 operator {
7232 name: "+"
7233 param {
7234 type: LITERAL
7235 literal {
7236 type: V_SINT
7237 v_signed_int: 10
7238 }
7239 }
7240 param {
7241 type: LITERAL
7242 literal {
7243 type: V_SINT
7244 v_signed_int: 20
7245 }
7246 }
7247 }
7248 }
7249 param {
7250 type: LITERAL
7251 literal {
7252 type: V_OCTETS
7253 v_octets {
7254 value: "UNSIGNED INTEGER"
7255 }
7256 }
7257 }
7258 }
7259 }
7260 }
7261 }
7262 alias: "not_cont_in"
7263 }
7264 }
7265
7266 Got expected error: CONT_IN expression requires operator that produce a JSON value. (code 5154)
7267
7268 op+ casted to json in literal array
7269 -----------------------------------
7270 send Mysqlx.Crud.Find {
7271 collection {
7272 name: "xtable"
7273 schema: "xtest"
7274 }
7275 data_model: TABLE
7276 projection {
7277 source {
7278 type: OPERATOR
7279 operator {
7280 name: "cont_in"
7281 param {
7282 type: OPERATOR
7283 operator {
7284 name: "cast"
7285 param {
7286 type: OPERATOR
7287 operator {
7288 name: "+"
7289 param {
7290 type: LITERAL
7291 literal {
7292 type: V_SINT
7293 v_signed_int: 10
7294 }
7295 }
7296 param {
7297 type: LITERAL
7298 literal {
7299 type: V_SINT
7300 v_signed_int: 20
7301 }
7302 }
7303 }
7304 }
7305 param {
7306 type: LITERAL
7307 literal {
7308 type: V_OCTETS
7309 v_octets {
7310 value: "JSON"
7311 }
7312 }
7313 }
7314 }
7315 }
7316 param {
7317 type: ARRAY
7318 array {
7319 value {
7320 type: LITERAL
7321 literal {
7322 type: V_SINT
7323 v_signed_int: 10
7324 }
7325 }
7326 value {
7327 type: LITERAL
7328 literal {
7329 type: V_SINT
7330 v_signed_int: 20
7331 }
7332 }
7333 value {
7334 type: LITERAL
7335 literal {
7336 type: V_SINT
7337 v_signed_int: 30
7338 }
7339 }
7340 }
7341 }
7342 }
7343 }
7344 alias: "cont_in"
7345 }
7346 projection {
7347 source {
7348 type: OPERATOR
7349 operator {
7350 name: "not_cont_in"
7351 param {
7352 type: OPERATOR
7353 operator {
7354 name: "cast"
7355 param {
7356 type: OPERATOR
7357 operator {
7358 name: "+"
7359 param {
7360 type: LITERAL
7361 literal {
7362 type: V_SINT
7363 v_signed_int: 10
7364 }
7365 }
7366 param {
7367 type: LITERAL
7368 literal {
7369 type: V_SINT
7370 v_signed_int: 20
7371 }
7372 }
7373 }
7374 }
7375 param {
7376 type: LITERAL
7377 literal {
7378 type: V_OCTETS
7379 v_octets {
7380 value: "JSON"
7381 }
7382 }
7383 }
7384 }
7385 }
7386 param {
7387 type: ARRAY
7388 array {
7389 value {
7390 type: LITERAL
7391 literal {
7392 type: V_SINT
7393 v_signed_int: 10
7394 }
7395 }
7396 value {
7397 type: LITERAL
7398 literal {
7399 type: V_SINT
7400 v_signed_int: 20
7401 }
7402 }
7403 value {
7404 type: LITERAL
7405 literal {
7406 type: V_SINT
7407 v_signed_int: 30
7408 }
7409 }
7410 }
7411 }
7412 }
7413 }
7414 alias: "not_cont_in"
7415 }
7416 }
7417
7418 cont_in not_cont_in
7419 1 0
7420 command ok
7421 Got expected error (code 0)
7422
7423 literal uint in op+ casted to json
7424 ----------------------------------
7425 send Mysqlx.Crud.Find {
7426 collection {
7427 name: "xtable"
7428 schema: "xtest"
7429 }
7430 data_model: TABLE
7431 projection {
7432 source {
7433 type: OPERATOR
7434 operator {
7435 name: "cont_in"
7436 param {
7437 type: LITERAL
7438 literal {
7439 type: V_SINT
7440 v_signed_int: 30
7441 }
7442 }
7443 param {
7444 type: OPERATOR
7445 operator {
7446 name: "cast"
7447 param {
7448 type: OPERATOR
7449 operator {
7450 name: "+"
7451 param {
7452 type: LITERAL
7453 literal {
7454 type: V_SINT
7455 v_signed_int: 10
7456 }
7457 }
7458 param {
7459 type: LITERAL
7460 literal {
7461 type: V_SINT
7462 v_signed_int: 20
7463 }
7464 }
7465 }
7466 }
7467 param {
7468 type: LITERAL
7469 literal {
7470 type: V_OCTETS
7471 v_octets {
7472 value: "JSON"
7473 }
7474 }
7475 }
7476 }
7477 }
7478 }
7479 }
7480 alias: "cont_in"
7481 }
7482 projection {
7483 source {
7484 type: OPERATOR
7485 operator {
7486 name: "not_cont_in"
7487 param {
7488 type: LITERAL
7489 literal {
7490 type: V_SINT
7491 v_signed_int: 30
7492 }
7493 }
7494 param {
7495 type: OPERATOR
7496 operator {
7497 name: "cast"
7498 param {
7499 type: OPERATOR
7500 operator {
7501 name: "+"
7502 param {
7503 type: LITERAL
7504 literal {
7505 type: V_SINT
7506 v_signed_int: 10
7507 }
7508 }
7509 param {
7510 type: LITERAL
7511 literal {
7512 type: V_SINT
7513 v_signed_int: 20
7514 }
7515 }
7516 }
7517 }
7518 param {
7519 type: LITERAL
7520 literal {
7521 type: V_OCTETS
7522 v_octets {
7523 value: "JSON"
7524 }
7525 }
7526 }
7527 }
7528 }
7529 }
7530 }
7531 alias: "not_cont_in"
7532 }
7533 }
7534
7535 cont_in not_cont_in
7536 1 0
7537 command ok
7538 Got expected error (code 0)
7539
7540 Literal NULL literal in literal NULL
7541 ------------------------------------
7542 send Mysqlx.Crud.Find {
7543 collection {
7544 name: "xtable"
7545 schema: "xtest"
7546 }
7547 data_model: TABLE
7548 projection {
7549 source {
7550 type: OPERATOR
7551 operator {
7552 name: "cont_in"
7553 param {
7554 type: LITERAL
7555 literal {
7556 type: V_NULL
7557 }
7558 }
7559 param {
7560 type: LITERAL
7561 literal {
7562 type: V_SINT
7563 v_signed_int: 10
7564 }
7565 }
7566 }
7567 }
7568 alias: "cont_in"
7569 }
7570 projection {
7571 source {
7572 type: OPERATOR
7573 operator {
7574 name: "not_cont_in"
7575 param {
7576 type: LITERAL
7577 literal {
7578 type: V_NULL
7579 }
7580 }
7581 param {
7582 type: LITERAL
7583 literal {
7584 type: V_SINT
7585 v_signed_int: 10
7586 }
7587 }
7588 }
7589 }
7590 alias: "not_cont_in"
7591 }
7592 }
7593
7594 cont_in not_cont_in
7595 0 1
7596 command ok
7597 Got expected error (code 0)
7598 send Mysqlx.Crud.Find {
7599 collection {
7600 name: "xtable"
7601 schema: "xtest"
7602 }
7603 data_model: TABLE
7604 projection {
7605 source {
7606 type: OPERATOR
7607 operator {
7608 name: "cont_in"
7609 param {
7610 type: LITERAL
7611 literal {
7612 type: V_SINT
7613 v_signed_int: 10
7614 }
7615 }
7616 param {
7617 type: LITERAL
7618 literal {
7619 type: V_NULL
7620 }
7621 }
7622 }
7623 }
7624 alias: "cont_in"
7625 }
7626 projection {
7627 source {
7628 type: OPERATOR
7629 operator {
7630 name: "not_cont_in"
7631 param {
7632 type: LITERAL
7633 literal {
7634 type: V_SINT
7635 v_signed_int: 10
7636 }
7637 }
7638 param {
7639 type: LITERAL
7640 literal {
7641 type: V_NULL
7642 }
7643 }
7644 }
7645 }
7646 alias: "not_cont_in"
7647 }
7648 }
7649
7650 cont_in not_cont_in
7651 0 1
7652 command ok
7653 Got expected error (code 0)
7654
7655 literal NULL in literal array
7656 -----------------------------
7657 send Mysqlx.Crud.Find {
7658 collection {
7659 name: "xtable"
7660 schema: "xtest"
7661 }
7662 data_model: TABLE
7663 projection {
7664 source {
7665 type: OPERATOR
7666 operator {
7667 name: "cont_in"
7668 param {
7669 type: LITERAL
7670 literal {
7671 type: V_NULL
7672 }
7673 }
7674 param {
7675 type: ARRAY
7676 array {
7677 value {
7678 type: LITERAL
7679 literal {
7680 type: V_SINT
7681 v_signed_int: 10
7682 }
7683 }
7684 value {
7685 type: LITERAL
7686 literal {
7687 type: V_SINT
7688 v_signed_int: 20
7689 }
7690 }
7691 value {
7692 type: LITERAL
7693 literal {
7694 type: V_SINT
7695 v_signed_int: 30
7696 }
7697 }
7698 }
7699 }
7700 }
7701 }
7702 alias: "cont_in"
7703 }
7704 projection {
7705 source {
7706 type: OPERATOR
7707 operator {
7708 name: "not_cont_in"
7709 param {
7710 type: LITERAL
7711 literal {
7712 type: V_NULL
7713 }
7714 }
7715 param {
7716 type: ARRAY
7717 array {
7718 value {
7719 type: LITERAL
7720 literal {
7721 type: V_SINT
7722 v_signed_int: 10
7723 }
7724 }
7725 value {
7726 type: LITERAL
7727 literal {
7728 type: V_SINT
7729 v_signed_int: 20
7730 }
7731 }
7732 value {
7733 type: LITERAL
7734 literal {
7735 type: V_SINT
7736 v_signed_int: 30
7737 }
7738 }
7739 }
7740 }
7741 }
7742 }
7743 alias: "not_cont_in"
7744 }
7745 }
7746
7747 cont_in not_cont_in
7748 0 1
7749 command ok
7750 Got expected error (code 0)
7751 send Mysqlx.Crud.Find {
7752 collection {
7753 name: "xtable"
7754 schema: "xtest"
7755 }
7756 data_model: TABLE
7757 projection {
7758 source {
7759 type: OPERATOR
7760 operator {
7761 name: "cont_in"
7762 param {
7763 type: LITERAL
7764 literal {
7765 type: V_NULL
7766 }
7767 }
7768 param {
7769 type: ARRAY
7770 array {
7771 value {
7772 type: LITERAL
7773 literal {
7774 type: V_SINT
7775 v_signed_int: 10
7776 }
7777 }
7778 value {
7779 type: LITERAL
7780 literal {
7781 type: V_NULL
7782 }
7783 }
7784 value {
7785 type: LITERAL
7786 literal {
7787 type: V_SINT
7788 v_signed_int: 30
7789 }
7790 }
7791 }
7792 }
7793 }
7794 }
7795 alias: "cont_in"
7796 }
7797 projection {
7798 source {
7799 type: OPERATOR
7800 operator {
7801 name: "not_cont_in"
7802 param {
7803 type: LITERAL
7804 literal {
7805 type: V_NULL
7806 }
7807 }
7808 param {
7809 type: ARRAY
7810 array {
7811 value {
7812 type: LITERAL
7813 literal {
7814 type: V_SINT
7815 v_signed_int: 10
7816 }
7817 }
7818 value {
7819 type: LITERAL
7820 literal {
7821 type: V_NULL
7822 }
7823 }
7824 value {
7825 type: LITERAL
7826 literal {
7827 type: V_SINT
7828 v_signed_int: 30
7829 }
7830 }
7831 }
7832 }
7833 }
7834 }
7835 alias: "not_cont_in"
7836 }
7837 }
7838
7839 cont_in not_cont_in
7840 1 0
7841 command ok
7842 Got expected error (code 0)
7843
7844 literal NULL in literal object
7845 ------------------------------
7846 send Mysqlx.Crud.Find {
7847 collection {
7848 name: "xtable"
7849 schema: "xtest"
7850 }
7851 data_model: TABLE
7852 projection {
7853 source {
7854 type: OPERATOR
7855 operator {
7856 name: "cont_in"
7857 param {
7858 type: LITERAL
7859 literal {
7860 type: V_NULL
7861 }
7862 }
7863 param {
7864 type: OBJECT
7865 object {
7866 fld {
7867 key: "scalar_10"
7868 value {
7869 type: LITERAL
7870 literal {
7871 type: V_SINT
7872 v_signed_int: 10
7873 }
7874 }
7875 }
7876 }
7877 }
7878 }
7879 }
7880 alias: "cont_in"
7881 }
7882 projection {
7883 source {
7884 type: OPERATOR
7885 operator {
7886 name: "not_cont_in"
7887 param {
7888 type: LITERAL
7889 literal {
7890 type: V_NULL
7891 }
7892 }
7893 param {
7894 type: OBJECT
7895 object {
7896 fld {
7897 key: "scalar_10"
7898 value {
7899 type: LITERAL
7900 literal {
7901 type: V_SINT
7902 v_signed_int: 10
7903 }
7904 }
7905 }
7906 }
7907 }
7908 }
7909 }
7910 alias: "not_cont_in"
7911 }
7912 }
7913
7914 cont_in not_cont_in
7915 0 1
7916 command ok
7917 Got expected error (code 0)
7918 send Mysqlx.Crud.Find {
7919 collection {
7920 name: "xtable"
7921 schema: "xtest"
7922 }
7923 data_model: TABLE
7924 projection {
7925 source {
7926 type: OPERATOR
7927 operator {
7928 name: "cont_in"
7929 param {
7930 type: LITERAL
7931 literal {
7932 type: V_NULL
7933 }
7934 }
7935 param {
7936 type: OBJECT
7937 object {
7938 fld {
7939 key: "scalar_null"
7940 value {
7941 type: LITERAL
7942 literal {
7943 type: V_NULL
7944 }
7945 }
7946 }
7947 }
7948 }
7949 }
7950 }
7951 alias: "cont_in"
7952 }
7953 projection {
7954 source {
7955 type: OPERATOR
7956 operator {
7957 name: "not_cont_in"
7958 param {
7959 type: LITERAL
7960 literal {
7961 type: V_NULL
7962 }
7963 }
7964 param {
7965 type: OBJECT
7966 object {
7967 fld {
7968 key: "scalar_null"
7969 value {
7970 type: LITERAL
7971 literal {
7972 type: V_NULL
7973 }
7974 }
7975 }
7976 }
7977 }
7978 }
7979 }
7980 alias: "not_cont_in"
7981 }
7982 }
7983
7984 cont_in not_cont_in
7985 0 1
7986 command ok
7987 Got expected error (code 0)
7988
7989 literal NULL in member object
7990 ------------------------------
7991 send Mysqlx.Crud.Find {
7992 collection {
7993 name: "xtable"
7994 schema: "xtest"
7995 }
7996 data_model: TABLE
7997 projection {
7998 source {
7999 type: OPERATOR
8000 operator {
8001 name: "cont_in"
8002 param {
8003 type: LITERAL
8004 literal {
8005 type: V_NULL
8006 }
8007 }
8008 param {
8009 type: IDENT
8010 identifier {
8011 document_path {
8012 type: MEMBER
8013 value: "object_scalar_10"
8014 }
8015 name: "doc"
8016 }
8017 }
8018 }
8019 }
8020 alias: "cont_in"
8021 }
8022 projection {
8023 source {
8024 type: OPERATOR
8025 operator {
8026 name: "not_cont_in"
8027 param {
8028 type: LITERAL
8029 literal {
8030 type: V_NULL
8031 }
8032 }
8033 param {
8034 type: IDENT
8035 identifier {
8036 document_path {
8037 type: MEMBER
8038 value: "object_scalar_10"
8039 }
8040 name: "doc"
8041 }
8042 }
8043 }
8044 }
8045 alias: "not_cont_in"
8046 }
8047 }
8048
8049 cont_in not_cont_in
8050 0 1
8051 command ok
8052 Got expected error (code 0)
8053
8054 literal NULL in root document
8055 ------------------------------
8056 send Mysqlx.Crud.Find {
8057 collection {
8058 name: "xtable"
8059 schema: "xtest"
8060 }
8061 data_model: TABLE
8062 projection {
8063 source {
8064 type: OPERATOR
8065 operator {
8066 name: "cont_in"
8067 param {
8068 type: LITERAL
8069 literal {
8070 type: V_NULL
8071 }
8072 }
8073 param {
8074 type: IDENT
8075 identifier {
8076 document_path {
8077 type: MEMBER
8078 }
8079 name: "doc"
8080 }
8081 }
8082 }
8083 }
8084 alias: "cont_in"
8085 }
8086 projection {
8087 source {
8088 type: OPERATOR
8089 operator {
8090 name: "not_cont_in"
8091 param {
8092 type: LITERAL
8093 literal {
8094 type: V_NULL
8095 }
8096 }
8097 param {
8098 type: IDENT
8099 identifier {
8100 document_path {
8101 type: MEMBER
8102 }
8103 name: "doc"
8104 }
8105 }
8106 }
8107 }
8108 alias: "not_cont_in"
8109 }
8110 }
8111
8112 cont_in not_cont_in
8113 0 1
8114 command ok
8115 Got expected error (code 0)
8116
8117 Function concat in string literal
8118 ---------------------------------
8119 send Mysqlx.Crud.Find {
8120 collection {
8121 name: "xtable"
8122 schema: "xtest"
8123 }
8124 data_model: TABLE
8125 projection {
8126 source {
8127 type: OPERATOR
8128 operator {
8129 name: "cont_in"
8130 param {
8131 type: FUNC_CALL
8132 function_call {
8133 name {
8134 name: "concat"
8135 }
8136 param {
8137 type: LITERAL
8138 literal {
8139 type: V_STRING
8140 v_string {
8141 value: "red"
8142 }
8143 }
8144 }
8145 param {
8146 type: LITERAL
8147 literal {
8148 type: V_STRING
8149 v_string {
8150 value: "green"
8151 }
8152 }
8153 }
8154 }
8155 }
8156 param {
8157 type: LITERAL
8158 literal {
8159 type: V_STRING
8160 v_string {
8161 value: "red"
8162 }
8163 }
8164 }
8165 }
8166 }
8167 alias: "cont_in"
8168 }
8169 projection {
8170 source {
8171 type: OPERATOR
8172 operator {
8173 name: "not_cont_in"
8174 param {
8175 type: FUNC_CALL
8176 function_call {
8177 name {
8178 name: "concat"
8179 }
8180 param {
8181 type: LITERAL
8182 literal {
8183 type: V_STRING
8184 v_string {
8185 value: "red"
8186 }
8187 }
8188 }
8189 param {
8190 type: LITERAL
8191 literal {
8192 type: V_STRING
8193 v_string {
8194 value: "green"
8195 }
8196 }
8197 }
8198 }
8199 }
8200 param {
8201 type: LITERAL
8202 literal {
8203 type: V_STRING
8204 v_string {
8205 value: "red"
8206 }
8207 }
8208 }
8209 }
8210 }
8211 alias: "not_cont_in"
8212 }
8213 }
8214
8215 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
8216
8217 String literal in function concat
8218 ---------------------------------
8219 send Mysqlx.Crud.Find {
8220 collection {
8221 name: "xtable"
8222 schema: "xtest"
8223 }
8224 data_model: TABLE
8225 projection {
8226 source {
8227 type: OPERATOR
8228 operator {
8229 name: "cont_in"
8230 param {
8231 type: LITERAL
8232 literal {
8233 type: V_STRING
8234 v_string {
8235 value: "red"
8236 }
8237 }
8238 }
8239 param {
8240 type: FUNC_CALL
8241 function_call {
8242 name {
8243 name: "concat"
8244 }
8245 param {
8246 type: LITERAL
8247 literal {
8248 type: V_STRING
8249 v_string {
8250 value: "red"
8251 }
8252 }
8253 }
8254 param {
8255 type: LITERAL
8256 literal {
8257 type: V_STRING
8258 v_string {
8259 value: "green"
8260 }
8261 }
8262 }
8263 }
8264 }
8265 }
8266 }
8267 alias: "cont_in"
8268 }
8269 projection {
8270 source {
8271 type: OPERATOR
8272 operator {
8273 name: "not_cont_in"
8274 param {
8275 type: LITERAL
8276 literal {
8277 type: V_STRING
8278 v_string {
8279 value: "red"
8280 }
8281 }
8282 }
8283 param {
8284 type: FUNC_CALL
8285 function_call {
8286 name {
8287 name: "concat"
8288 }
8289 param {
8290 type: LITERAL
8291 literal {
8292 type: V_STRING
8293 v_string {
8294 value: "red"
8295 }
8296 }
8297 }
8298 param {
8299 type: LITERAL
8300 literal {
8301 type: V_STRING
8302 v_string {
8303 value: "green"
8304 }
8305 }
8306 }
8307 }
8308 }
8309 }
8310 }
8311 alias: "not_cont_in"
8312 }
8313 }
8314
8315 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
8316
8317 Quoted function concat in string literal
8318 ----------------------------------------
8319 send Mysqlx.Crud.Find {
8320 collection {
8321 name: "xtable"
8322 schema: "xtest"
8323 }
8324 data_model: TABLE
8325 projection {
8326 source {
8327 type: OPERATOR
8328 operator {
8329 name: "cont_in"
8330 param {
8331 type: FUNC_CALL
8332 function_call {
8333 name {
8334 name: "json_quote"
8335 }
8336 param {
8337 type: FUNC_CALL
8338 function_call {
8339 name {
8340 name: "concat"
8341 }
8342 param {
8343 type: LITERAL
8344 literal {
8345 type: V_STRING
8346 v_string {
8347 value: "red"
8348 }
8349 }
8350 }
8351 param {
8352 type: LITERAL
8353 literal {
8354 type: V_STRING
8355 v_string {
8356 value: "green"
8357 }
8358 }
8359 }
8360 }
8361 }
8362 }
8363 }
8364 param {
8365 type: LITERAL
8366 literal {
8367 type: V_STRING
8368 v_string {
8369 value: "red"
8370 }
8371 }
8372 }
8373 }
8374 }
8375 alias: "cont_in"
8376 }
8377 projection {
8378 source {
8379 type: OPERATOR
8380 operator {
8381 name: "not_cont_in"
8382 param {
8383 type: FUNC_CALL
8384 function_call {
8385 name {
8386 name: "json_quote"
8387 }
8388 param {
8389 type: FUNC_CALL
8390 function_call {
8391 name {
8392 name: "concat"
8393 }
8394 param {
8395 type: LITERAL
8396 literal {
8397 type: V_STRING
8398 v_string {
8399 value: "red"
8400 }
8401 }
8402 }
8403 param {
8404 type: LITERAL
8405 literal {
8406 type: V_STRING
8407 v_string {
8408 value: "green"
8409 }
8410 }
8411 }
8412 }
8413 }
8414 }
8415 }
8416 param {
8417 type: LITERAL
8418 literal {
8419 type: V_STRING
8420 v_string {
8421 value: "red"
8422 }
8423 }
8424 }
8425 }
8426 }
8427 alias: "not_cont_in"
8428 }
8429 }
8430
8431 cont_in not_cont_in
8432 0 1
8433 command ok
8434 Got expected error (code 0)
8435
8436 String literal in quoted function concat
8437 ----------------------------------------
8438 send Mysqlx.Crud.Find {
8439 collection {
8440 name: "xtable"
8441 schema: "xtest"
8442 }
8443 data_model: TABLE
8444 projection {
8445 source {
8446 type: OPERATOR
8447 operator {
8448 name: "cont_in"
8449 param {
8450 type: LITERAL
8451 literal {
8452 type: V_STRING
8453 v_string {
8454 value: "red"
8455 }
8456 }
8457 }
8458 param {
8459 type: FUNC_CALL
8460 function_call {
8461 name {
8462 name: "json_quote"
8463 }
8464 param {
8465 type: FUNC_CALL
8466 function_call {
8467 name {
8468 name: "concat"
8469 }
8470 param {
8471 type: LITERAL
8472 literal {
8473 type: V_STRING
8474 v_string {
8475 value: "red"
8476 }
8477 }
8478 }
8479 param {
8480 type: LITERAL
8481 literal {
8482 type: V_STRING
8483 v_string {
8484 value: "green"
8485 }
8486 }
8487 }
8488 }
8489 }
8490 }
8491 }
8492 }
8493 }
8494 alias: "cont_in"
8495 }
8496 projection {
8497 source {
8498 type: OPERATOR
8499 operator {
8500 name: "not_cont_in"
8501 param {
8502 type: LITERAL
8503 literal {
8504 type: V_STRING
8505 v_string {
8506 value: "red"
8507 }
8508 }
8509 }
8510 param {
8511 type: FUNC_CALL
8512 function_call {
8513 name {
8514 name: "json_quote"
8515 }
8516 param {
8517 type: FUNC_CALL
8518 function_call {
8519 name {
8520 name: "concat"
8521 }
8522 param {
8523 type: LITERAL
8524 literal {
8525 type: V_STRING
8526 v_string {
8527 value: "red"
8528 }
8529 }
8530 }
8531 param {
8532 type: LITERAL
8533 literal {
8534 type: V_STRING
8535 v_string {
8536 value: "green"
8537 }
8538 }
8539 }
8540 }
8541 }
8542 }
8543 }
8544 }
8545 }
8546 alias: "not_cont_in"
8547 }
8548 }
8549
8550 cont_in not_cont_in
8551 0 1
8552 command ok
8553 Got expected error (code 0)
8554
8555 JSON_ARRAY - Create JSON array
8556 ------------------------------
8557 send Mysqlx.Crud.Find {
8558 collection {
8559 name: "xtable"
8560 schema: "xtest"
8561 }
8562 data_model: TABLE
8563 projection {
8564 source {
8565 type: OPERATOR
8566 operator {
8567 name: "cont_in"
8568 param {
8569 type: LITERAL
8570 literal {
8571 type: V_STRING
8572 v_string {
8573 value: "red"
8574 }
8575 }
8576 }
8577 param {
8578 type: FUNC_CALL
8579 function_call {
8580 name {
8581 name: "json_array"
8582 }
8583 param {
8584 type: LITERAL
8585 literal {
8586 type: V_SINT
8587 v_signed_int: 10
8588 }
8589 }
8590 param {
8591 type: LITERAL
8592 literal {
8593 type: V_STRING
8594 v_string {
8595 value: "red"
8596 }
8597 }
8598 }
8599 param {
8600 type: LITERAL
8601 literal {
8602 type: V_BOOL
8603 v_bool: true
8604 }
8605 }
8606 }
8607 }
8608 }
8609 }
8610 alias: "cont_in"
8611 }
8612 projection {
8613 source {
8614 type: OPERATOR
8615 operator {
8616 name: "not_cont_in"
8617 param {
8618 type: LITERAL
8619 literal {
8620 type: V_STRING
8621 v_string {
8622 value: "red"
8623 }
8624 }
8625 }
8626 param {
8627 type: FUNC_CALL
8628 function_call {
8629 name {
8630 name: "json_array"
8631 }
8632 param {
8633 type: LITERAL
8634 literal {
8635 type: V_SINT
8636 v_signed_int: 10
8637 }
8638 }
8639 param {
8640 type: LITERAL
8641 literal {
8642 type: V_STRING
8643 v_string {
8644 value: "red"
8645 }
8646 }
8647 }
8648 param {
8649 type: LITERAL
8650 literal {
8651 type: V_BOOL
8652 v_bool: true
8653 }
8654 }
8655 }
8656 }
8657 }
8658 }
8659 alias: "not_cont_in"
8660 }
8661 }
8662
8663 cont_in not_cont_in
8664 1 0
8665 command ok
8666 Got expected error (code 0)
8667
8668 JSON_ARRAY_APPEND - Append data to JSON document
8669 ------------------------------------------------
8670 send Mysqlx.Crud.Find {
8671 collection {
8672 name: "xtable"
8673 schema: "xtest"
8674 }
8675 data_model: TABLE
8676 projection {
8677 source {
8678 type: OPERATOR
8679 operator {
8680 name: "cont_in"
8681 param {
8682 type: LITERAL
8683 literal {
8684 type: V_STRING
8685 v_string {
8686 value: "red"
8687 }
8688 }
8689 }
8690 param {
8691 type: FUNC_CALL
8692 function_call {
8693 name {
8694 name: "json_array_append"
8695 }
8696 param {
8697 type: ARRAY
8698 array {
8699 value {
8700 type: LITERAL
8701 literal {
8702 type: V_SINT
8703 v_signed_int: 10
8704 }
8705 }
8706 value {
8707 type: LITERAL
8708 literal {
8709 type: V_SINT
8710 v_signed_int: 20
8711 }
8712 }
8713 value {
8714 type: LITERAL
8715 literal {
8716 type: V_SINT
8717 v_signed_int: 30
8718 }
8719 }
8720 }
8721 }
8722 param {
8723 type: LITERAL
8724 literal {
8725 type: V_OCTETS
8726 v_octets {
8727 value: "$"
8728 }
8729 }
8730 }
8731 param {
8732 type: LITERAL
8733 literal {
8734 type: V_STRING
8735 v_string {
8736 value: "red"
8737 }
8738 }
8739 }
8740 }
8741 }
8742 }
8743 }
8744 alias: "cont_in"
8745 }
8746 projection {
8747 source {
8748 type: OPERATOR
8749 operator {
8750 name: "not_cont_in"
8751 param {
8752 type: LITERAL
8753 literal {
8754 type: V_STRING
8755 v_string {
8756 value: "red"
8757 }
8758 }
8759 }
8760 param {
8761 type: FUNC_CALL
8762 function_call {
8763 name {
8764 name: "json_array_append"
8765 }
8766 param {
8767 type: ARRAY
8768 array {
8769 value {
8770 type: LITERAL
8771 literal {
8772 type: V_SINT
8773 v_signed_int: 10
8774 }
8775 }
8776 value {
8777 type: LITERAL
8778 literal {
8779 type: V_SINT
8780 v_signed_int: 20
8781 }
8782 }
8783 value {
8784 type: LITERAL
8785 literal {
8786 type: V_SINT
8787 v_signed_int: 30
8788 }
8789 }
8790 }
8791 }
8792 param {
8793 type: LITERAL
8794 literal {
8795 type: V_OCTETS
8796 v_octets {
8797 value: "$"
8798 }
8799 }
8800 }
8801 param {
8802 type: LITERAL
8803 literal {
8804 type: V_STRING
8805 v_string {
8806 value: "red"
8807 }
8808 }
8809 }
8810 }
8811 }
8812 }
8813 }
8814 alias: "not_cont_in"
8815 }
8816 }
8817
8818 cont_in not_cont_in
8819 1 0
8820 command ok
8821 Got expected error (code 0)
8822
8823 JSON_ARRAY_INSERT - Insert into JSON array
8824 ------------------------------------------
8825 send Mysqlx.Crud.Find {
8826 collection {
8827 name: "xtable"
8828 schema: "xtest"
8829 }
8830 data_model: TABLE
8831 projection {
8832 source {
8833 type: OPERATOR
8834 operator {
8835 name: "cont_in"
8836 param {
8837 type: LITERAL
8838 literal {
8839 type: V_STRING
8840 v_string {
8841 value: "red"
8842 }
8843 }
8844 }
8845 param {
8846 type: FUNC_CALL
8847 function_call {
8848 name {
8849 name: "json_array_insert"
8850 }
8851 param {
8852 type: ARRAY
8853 array {
8854 value {
8855 type: LITERAL
8856 literal {
8857 type: V_SINT
8858 v_signed_int: 10
8859 }
8860 }
8861 value {
8862 type: LITERAL
8863 literal {
8864 type: V_SINT
8865 v_signed_int: 20
8866 }
8867 }
8868 value {
8869 type: LITERAL
8870 literal {
8871 type: V_SINT
8872 v_signed_int: 30
8873 }
8874 }
8875 }
8876 }
8877 param {
8878 type: LITERAL
8879 literal {
8880 type: V_OCTETS
8881 v_octets {
8882 value: "$[1]"
8883 }
8884 }
8885 }
8886 param {
8887 type: LITERAL
8888 literal {
8889 type: V_STRING
8890 v_string {
8891 value: "red"
8892 }
8893 }
8894 }
8895 }
8896 }
8897 }
8898 }
8899 alias: "cont_in"
8900 }
8901 projection {
8902 source {
8903 type: OPERATOR
8904 operator {
8905 name: "not_cont_in"
8906 param {
8907 type: LITERAL
8908 literal {
8909 type: V_STRING
8910 v_string {
8911 value: "red"
8912 }
8913 }
8914 }
8915 param {
8916 type: FUNC_CALL
8917 function_call {
8918 name {
8919 name: "json_array_insert"
8920 }
8921 param {
8922 type: ARRAY
8923 array {
8924 value {
8925 type: LITERAL
8926 literal {
8927 type: V_SINT
8928 v_signed_int: 10
8929 }
8930 }
8931 value {
8932 type: LITERAL
8933 literal {
8934 type: V_SINT
8935 v_signed_int: 20
8936 }
8937 }
8938 value {
8939 type: LITERAL
8940 literal {
8941 type: V_SINT
8942 v_signed_int: 30
8943 }
8944 }
8945 }
8946 }
8947 param {
8948 type: LITERAL
8949 literal {
8950 type: V_OCTETS
8951 v_octets {
8952 value: "$[1]"
8953 }
8954 }
8955 }
8956 param {
8957 type: LITERAL
8958 literal {
8959 type: V_STRING
8960 v_string {
8961 value: "red"
8962 }
8963 }
8964 }
8965 }
8966 }
8967 }
8968 }
8969 alias: "not_cont_in"
8970 }
8971 }
8972
8973 cont_in not_cont_in
8974 1 0
8975 command ok
8976 Got expected error (code 0)
8977
8978 JSON_CONTAINS - Whether JSON document contains specific object at path
8979 ----------------------------------------------------------------------
8980 send Mysqlx.Crud.Find {
8981 collection {
8982 name: "xtable"
8983 schema: "xtest"
8984 }
8985 data_model: TABLE
8986 projection {
8987 source {
8988 type: OPERATOR
8989 operator {
8990 name: "cont_in"
8991 param {
8992 type: LITERAL
8993 literal {
8994 type: V_STRING
8995 v_string {
8996 value: "red"
8997 }
8998 }
8999 }
9000 param {
9001 type: FUNC_CALL
9002 function_call {
9003 name {
9004 name: "json_contains"
9005 }
9006 param {
9007 type: ARRAY
9008 array {
9009 value {
9010 type: LITERAL
9011 literal {
9012 type: V_SINT
9013 v_signed_int: 10
9014 }
9015 }
9016 value {
9017 type: LITERAL
9018 literal {
9019 type: V_SINT
9020 v_signed_int: 20
9021 }
9022 }
9023 value {
9024 type: LITERAL
9025 literal {
9026 type: V_SINT
9027 v_signed_int: 30
9028 }
9029 }
9030 }
9031 }
9032 param {
9033 type: LITERAL
9034 literal {
9035 type: V_STRING
9036 v_string {
9037 value: "red"
9038 }
9039 }
9040 }
9041 }
9042 }
9043 }
9044 }
9045 alias: "cont_in"
9046 }
9047 projection {
9048 source {
9049 type: OPERATOR
9050 operator {
9051 name: "not_cont_in"
9052 param {
9053 type: LITERAL
9054 literal {
9055 type: V_STRING
9056 v_string {
9057 value: "red"
9058 }
9059 }
9060 }
9061 param {
9062 type: FUNC_CALL
9063 function_call {
9064 name {
9065 name: "json_contains"
9066 }
9067 param {
9068 type: ARRAY
9069 array {
9070 value {
9071 type: LITERAL
9072 literal {
9073 type: V_SINT
9074 v_signed_int: 10
9075 }
9076 }
9077 value {
9078 type: LITERAL
9079 literal {
9080 type: V_SINT
9081 v_signed_int: 20
9082 }
9083 }
9084 value {
9085 type: LITERAL
9086 literal {
9087 type: V_SINT
9088 v_signed_int: 30
9089 }
9090 }
9091 }
9092 }
9093 param {
9094 type: LITERAL
9095 literal {
9096 type: V_STRING
9097 v_string {
9098 value: "red"
9099 }
9100 }
9101 }
9102 }
9103 }
9104 }
9105 }
9106 alias: "not_cont_in"
9107 }
9108 }
9109
9110 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
9111
9112 JSON_CONTAINS_PATH - Whether JSON document contains any data at path
9113 --------------------------------------------------------------------
9114 send Mysqlx.Crud.Find {
9115 collection {
9116 name: "xtable"
9117 schema: "xtest"
9118 }
9119 data_model: TABLE
9120 projection {
9121 source {
9122 type: OPERATOR
9123 operator {
9124 name: "cont_in"
9125 param {
9126 type: LITERAL
9127 literal {
9128 type: V_STRING
9129 v_string {
9130 value: "red"
9131 }
9132 }
9133 }
9134 param {
9135 type: FUNC_CALL
9136 function_call {
9137 name {
9138 name: "json_contains_path"
9139 }
9140 param {
9141 type: ARRAY
9142 array {
9143 value {
9144 type: LITERAL
9145 literal {
9146 type: V_SINT
9147 v_signed_int: 10
9148 }
9149 }
9150 value {
9151 type: LITERAL
9152 literal {
9153 type: V_SINT
9154 v_signed_int: 20
9155 }
9156 }
9157 value {
9158 type: LITERAL
9159 literal {
9160 type: V_SINT
9161 v_signed_int: 30
9162 }
9163 }
9164 }
9165 }
9166 param {
9167 type: LITERAL
9168 literal {
9169 type: V_OCTETS
9170 v_octets {
9171 value: "$[1]"
9172 }
9173 }
9174 }
9175 }
9176 }
9177 }
9178 }
9179 alias: "cont_in"
9180 }
9181 projection {
9182 source {
9183 type: OPERATOR
9184 operator {
9185 name: "not_cont_in"
9186 param {
9187 type: LITERAL
9188 literal {
9189 type: V_STRING
9190 v_string {
9191 value: "red"
9192 }
9193 }
9194 }
9195 param {
9196 type: FUNC_CALL
9197 function_call {
9198 name {
9199 name: "json_contains_path"
9200 }
9201 param {
9202 type: ARRAY
9203 array {
9204 value {
9205 type: LITERAL
9206 literal {
9207 type: V_SINT
9208 v_signed_int: 10
9209 }
9210 }
9211 value {
9212 type: LITERAL
9213 literal {
9214 type: V_SINT
9215 v_signed_int: 20
9216 }
9217 }
9218 value {
9219 type: LITERAL
9220 literal {
9221 type: V_SINT
9222 v_signed_int: 30
9223 }
9224 }
9225 }
9226 }
9227 param {
9228 type: LITERAL
9229 literal {
9230 type: V_OCTETS
9231 v_octets {
9232 value: "$[1]"
9233 }
9234 }
9235 }
9236 }
9237 }
9238 }
9239 }
9240 alias: "not_cont_in"
9241 }
9242 }
9243
9244 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
9245
9246 JSON_DEPTH - Maximum depth of JSON document
9247 -------------------------------------------
9248 send Mysqlx.Crud.Find {
9249 collection {
9250 name: "xtable"
9251 schema: "xtest"
9252 }
9253 data_model: TABLE
9254 projection {
9255 source {
9256 type: OPERATOR
9257 operator {
9258 name: "cont_in"
9259 param {
9260 type: LITERAL
9261 literal {
9262 type: V_STRING
9263 v_string {
9264 value: "red"
9265 }
9266 }
9267 }
9268 param {
9269 type: FUNC_CALL
9270 function_call {
9271 name {
9272 name: "json_depth"
9273 }
9274 param {
9275 type: ARRAY
9276 array {
9277 value {
9278 type: LITERAL
9279 literal {
9280 type: V_SINT
9281 v_signed_int: 10
9282 }
9283 }
9284 value {
9285 type: LITERAL
9286 literal {
9287 type: V_SINT
9288 v_signed_int: 20
9289 }
9290 }
9291 value {
9292 type: LITERAL
9293 literal {
9294 type: V_SINT
9295 v_signed_int: 30
9296 }
9297 }
9298 }
9299 }
9300 }
9301 }
9302 }
9303 }
9304 alias: "cont_in"
9305 }
9306 projection {
9307 source {
9308 type: OPERATOR
9309 operator {
9310 name: "not_cont_in"
9311 param {
9312 type: LITERAL
9313 literal {
9314 type: V_STRING
9315 v_string {
9316 value: "red"
9317 }
9318 }
9319 }
9320 param {
9321 type: FUNC_CALL
9322 function_call {
9323 name {
9324 name: "json_depth"
9325 }
9326 param {
9327 type: ARRAY
9328 array {
9329 value {
9330 type: LITERAL
9331 literal {
9332 type: V_SINT
9333 v_signed_int: 10
9334 }
9335 }
9336 value {
9337 type: LITERAL
9338 literal {
9339 type: V_SINT
9340 v_signed_int: 20
9341 }
9342 }
9343 value {
9344 type: LITERAL
9345 literal {
9346 type: V_SINT
9347 v_signed_int: 30
9348 }
9349 }
9350 }
9351 }
9352 }
9353 }
9354 }
9355 }
9356 alias: "not_cont_in"
9357 }
9358 }
9359
9360 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
9361
9362 JSON_EXTRACT - Return data from JSON document
9363 ---------------------------------------------
9364 send Mysqlx.Crud.Find {
9365 collection {
9366 name: "xtable"
9367 schema: "xtest"
9368 }
9369 data_model: TABLE
9370 projection {
9371 source {
9372 type: OPERATOR
9373 operator {
9374 name: "cont_in"
9375 param {
9376 type: OBJECT
9377 object {
9378 fld {
9379 key: "scalar_10"
9380 value {
9381 type: LITERAL
9382 literal {
9383 type: V_SINT
9384 v_signed_int: 10
9385 }
9386 }
9387 }
9388 }
9389 }
9390 param {
9391 type: FUNC_CALL
9392 function_call {
9393 name {
9394 name: "json_extract"
9395 }
9396 param {
9397 type: ARRAY
9398 array {
9399 value {
9400 type: LITERAL
9401 literal {
9402 type: V_SINT
9403 v_signed_int: 30
9404 }
9405 }
9406 value {
9407 type: OBJECT
9408 object {
9409 fld {
9410 key: "scalar_10"
9411 value {
9412 type: LITERAL
9413 literal {
9414 type: V_SINT
9415 v_signed_int: 10
9416 }
9417 }
9418 }
9419 }
9420 }
9421 value {
9422 type: LITERAL
9423 literal {
9424 type: V_STRING
9425 v_string {
9426 value: "white"
9427 }
9428 }
9429 }
9430 }
9431 }
9432 param {
9433 type: LITERAL
9434 literal {
9435 type: V_OCTETS
9436 v_octets {
9437 value: "$[1]"
9438 }
9439 }
9440 }
9441 }
9442 }
9443 }
9444 }
9445 alias: "cont_in"
9446 }
9447 projection {
9448 source {
9449 type: OPERATOR
9450 operator {
9451 name: "not_cont_in"
9452 param {
9453 type: OBJECT
9454 object {
9455 fld {
9456 key: "scalar_10"
9457 value {
9458 type: LITERAL
9459 literal {
9460 type: V_SINT
9461 v_signed_int: 10
9462 }
9463 }
9464 }
9465 }
9466 }
9467 param {
9468 type: FUNC_CALL
9469 function_call {
9470 name {
9471 name: "json_extract"
9472 }
9473 param {
9474 type: ARRAY
9475 array {
9476 value {
9477 type: LITERAL
9478 literal {
9479 type: V_SINT
9480 v_signed_int: 30
9481 }
9482 }
9483 value {
9484 type: OBJECT
9485 object {
9486 fld {
9487 key: "scalar_10"
9488 value {
9489 type: LITERAL
9490 literal {
9491 type: V_SINT
9492 v_signed_int: 10
9493 }
9494 }
9495 }
9496 }
9497 }
9498 value {
9499 type: LITERAL
9500 literal {
9501 type: V_STRING
9502 v_string {
9503 value: "white"
9504 }
9505 }
9506 }
9507 }
9508 }
9509 param {
9510 type: LITERAL
9511 literal {
9512 type: V_OCTETS
9513 v_octets {
9514 value: "$[1]"
9515 }
9516 }
9517 }
9518 }
9519 }
9520 }
9521 }
9522 alias: "not_cont_in"
9523 }
9524 }
9525
9526 cont_in not_cont_in
9527 1 0
9528 command ok
9529 Got expected error (code 0)
9530
9531 JSON_INSERT - Insert data into JSON document
9532 --------------------------------------------
9533 send Mysqlx.Crud.Find {
9534 collection {
9535 name: "xtable"
9536 schema: "xtest"
9537 }
9538 data_model: TABLE
9539 projection {
9540 source {
9541 type: OPERATOR
9542 operator {
9543 name: "cont_in"
9544 param {
9545 type: OBJECT
9546 object {
9547 fld {
9548 key: "scalar_10"
9549 value {
9550 type: LITERAL
9551 literal {
9552 type: V_SINT
9553 v_signed_int: 10
9554 }
9555 }
9556 }
9557 }
9558 }
9559 param {
9560 type: FUNC_CALL
9561 function_call {
9562 name {
9563 name: "json_insert"
9564 }
9565 param {
9566 type: OBJECT
9567 object {
9568 fld {
9569 key: "scalar_blue"
9570 value {
9571 type: LITERAL
9572 literal {
9573 type: V_STRING
9574 v_string {
9575 value: "blue"
9576 }
9577 }
9578 }
9579 }
9580 }
9581 }
9582 param {
9583 type: LITERAL
9584 literal {
9585 type: V_OCTETS
9586 v_octets {
9587 value: "$.scalar_10"
9588 }
9589 }
9590 }
9591 param {
9592 type: LITERAL
9593 literal {
9594 type: V_SINT
9595 v_signed_int: 10
9596 }
9597 }
9598 }
9599 }
9600 }
9601 }
9602 alias: "cont_in"
9603 }
9604 projection {
9605 source {
9606 type: OPERATOR
9607 operator {
9608 name: "not_cont_in"
9609 param {
9610 type: OBJECT
9611 object {
9612 fld {
9613 key: "scalar_10"
9614 value {
9615 type: LITERAL
9616 literal {
9617 type: V_SINT
9618 v_signed_int: 10
9619 }
9620 }
9621 }
9622 }
9623 }
9624 param {
9625 type: FUNC_CALL
9626 function_call {
9627 name {
9628 name: "json_insert"
9629 }
9630 param {
9631 type: OBJECT
9632 object {
9633 fld {
9634 key: "scalar_blue"
9635 value {
9636 type: LITERAL
9637 literal {
9638 type: V_STRING
9639 v_string {
9640 value: "blue"
9641 }
9642 }
9643 }
9644 }
9645 }
9646 }
9647 param {
9648 type: LITERAL
9649 literal {
9650 type: V_OCTETS
9651 v_octets {
9652 value: "$.scalar_10"
9653 }
9654 }
9655 }
9656 param {
9657 type: LITERAL
9658 literal {
9659 type: V_SINT
9660 v_signed_int: 10
9661 }
9662 }
9663 }
9664 }
9665 }
9666 }
9667 alias: "not_cont_in"
9668 }
9669 }
9670
9671 cont_in not_cont_in
9672 1 0
9673 command ok
9674 Got expected error (code 0)
9675
9676 JSON_KEYS - Array of keys from JSON document
9677 --------------------------------------------
9678 send Mysqlx.Crud.Find {
9679 collection {
9680 name: "xtable"
9681 schema: "xtest"
9682 }
9683 data_model: TABLE
9684 projection {
9685 source {
9686 type: OPERATOR
9687 operator {
9688 name: "cont_in"
9689 param {
9690 type: LITERAL
9691 literal {
9692 type: V_OCTETS
9693 v_octets {
9694 value: "scalar_10"
9695 }
9696 }
9697 }
9698 param {
9699 type: FUNC_CALL
9700 function_call {
9701 name {
9702 name: "json_keys"
9703 }
9704 param {
9705 type: IDENT
9706 identifier {
9707 document_path {
9708 type: MEMBER
9709 }
9710 name: "doc"
9711 }
9712 }
9713 }
9714 }
9715 }
9716 }
9717 alias: "cont_in"
9718 }
9719 projection {
9720 source {
9721 type: OPERATOR
9722 operator {
9723 name: "not_cont_in"
9724 param {
9725 type: LITERAL
9726 literal {
9727 type: V_OCTETS
9728 v_octets {
9729 value: "scalar_10"
9730 }
9731 }
9732 }
9733 param {
9734 type: FUNC_CALL
9735 function_call {
9736 name {
9737 name: "json_keys"
9738 }
9739 param {
9740 type: IDENT
9741 identifier {
9742 document_path {
9743 type: MEMBER
9744 }
9745 name: "doc"
9746 }
9747 }
9748 }
9749 }
9750 }
9751 }
9752 alias: "not_cont_in"
9753 }
9754 }
9755
9756 cont_in not_cont_in
9757 1 0
9758 command ok
9759 Got expected error (code 0)
9760
9761 JSON_LENGTH - Number of elements in JSON document
9762 -------------------------------------------------
9763 send Mysqlx.Crud.Find {
9764 collection {
9765 name: "xtable"
9766 schema: "xtest"
9767 }
9768 data_model: TABLE
9769 projection {
9770 source {
9771 type: OPERATOR
9772 operator {
9773 name: "cont_in"
9774 param {
9775 type: LITERAL
9776 literal {
9777 type: V_SINT
9778 v_signed_int: 10
9779 }
9780 }
9781 param {
9782 type: FUNC_CALL
9783 function_call {
9784 name {
9785 name: "json_length"
9786 }
9787 param {
9788 type: IDENT
9789 identifier {
9790 document_path {
9791 type: MEMBER
9792 }
9793 name: "doc"
9794 }
9795 }
9796 }
9797 }
9798 }
9799 }
9800 alias: "cont_in"
9801 }
9802 projection {
9803 source {
9804 type: OPERATOR
9805 operator {
9806 name: "not_cont_in"
9807 param {
9808 type: LITERAL
9809 literal {
9810 type: V_SINT
9811 v_signed_int: 10
9812 }
9813 }
9814 param {
9815 type: FUNC_CALL
9816 function_call {
9817 name {
9818 name: "json_length"
9819 }
9820 param {
9821 type: IDENT
9822 identifier {
9823 document_path {
9824 type: MEMBER
9825 }
9826 name: "doc"
9827 }
9828 }
9829 }
9830 }
9831 }
9832 }
9833 alias: "not_cont_in"
9834 }
9835 }
9836
9837 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
9838
9839 JSON_MERGE - Merge JSON documents
9840 ---------------------------------
9841 send Mysqlx.Crud.Find {
9842 collection {
9843 name: "xtable"
9844 schema: "xtest"
9845 }
9846 data_model: TABLE
9847 projection {
9848 source {
9849 type: OPERATOR
9850 operator {
9851 name: "cont_in"
9852 param {
9853 type: OBJECT
9854 object {
9855 fld {
9856 key: "scalar_blue"
9857 value {
9858 type: LITERAL
9859 literal {
9860 type: V_STRING
9861 v_string {
9862 value: "blue"
9863 }
9864 }
9865 }
9866 }
9867 }
9868 }
9869 param {
9870 type: FUNC_CALL
9871 function_call {
9872 name {
9873 name: "json_merge"
9874 }
9875 param {
9876 type: OBJECT
9877 object {
9878 fld {
9879 key: "scalar_10"
9880 value {
9881 type: LITERAL
9882 literal {
9883 type: V_SINT
9884 v_signed_int: 10
9885 }
9886 }
9887 }
9888 }
9889 }
9890 param {
9891 type: OBJECT
9892 object {
9893 fld {
9894 key: "scalar_blue"
9895 value {
9896 type: LITERAL
9897 literal {
9898 type: V_STRING
9899 v_string {
9900 value: "blue"
9901 }
9902 }
9903 }
9904 }
9905 }
9906 }
9907 }
9908 }
9909 }
9910 }
9911 alias: "cont_in"
9912 }
9913 projection {
9914 source {
9915 type: OPERATOR
9916 operator {
9917 name: "not_cont_in"
9918 param {
9919 type: OBJECT
9920 object {
9921 fld {
9922 key: "scalar_blue"
9923 value {
9924 type: LITERAL
9925 literal {
9926 type: V_STRING
9927 v_string {
9928 value: "blue"
9929 }
9930 }
9931 }
9932 }
9933 }
9934 }
9935 param {
9936 type: FUNC_CALL
9937 function_call {
9938 name {
9939 name: "json_merge"
9940 }
9941 param {
9942 type: OBJECT
9943 object {
9944 fld {
9945 key: "scalar_10"
9946 value {
9947 type: LITERAL
9948 literal {
9949 type: V_SINT
9950 v_signed_int: 10
9951 }
9952 }
9953 }
9954 }
9955 }
9956 param {
9957 type: OBJECT
9958 object {
9959 fld {
9960 key: "scalar_blue"
9961 value {
9962 type: LITERAL
9963 literal {
9964 type: V_STRING
9965 v_string {
9966 value: "blue"
9967 }
9968 }
9969 }
9970 }
9971 }
9972 }
9973 }
9974 }
9975 }
9976 }
9977 alias: "not_cont_in"
9978 }
9979 }
9980
9981 cont_in not_cont_in
9982 1 0
9983 command ok
9984 Warnings generated:
9985 WARNING | 1287 | 'JSON_MERGE' is deprecated and will be removed in a future release. Please use JSON_MERGE_PRESERVE/JSON_MERGE_PATCH instead
9986 WARNING | 1287 | 'JSON_MERGE' is deprecated and will be removed in a future release. Please use JSON_MERGE_PRESERVE/JSON_MERGE_PATCH instead
9987 Got expected error (code 0)
9988
9989 JSON_OBJECT - Create JSON object
9990 --------------------------------
9991 send Mysqlx.Crud.Find {
9992 collection {
9993 name: "xtable"
9994 schema: "xtest"
9995 }
9996 data_model: TABLE
9997 projection {
9998 source {
9999 type: OPERATOR
10000 operator {
10001 name: "cont_in"
10002 param {
10003 type: OBJECT
10004 object {
10005 fld {
10006 key: "scalar_10"
10007 value {
10008 type: LITERAL
10009 literal {
10010 type: V_SINT
10011 v_signed_int: 10
10012 }
10013 }
10014 }
10015 }
10016 }
10017 param {
10018 type: FUNC_CALL
10019 function_call {
10020 name {
10021 name: "json_object"
10022 }
10023 param {
10024 type: LITERAL
10025 literal {
10026 type: V_OCTETS
10027 v_octets {
10028 value: "scalar_10"
10029 }
10030 }
10031 }
10032 param {
10033 type: LITERAL
10034 literal {
10035 type: V_SINT
10036 v_signed_int: 10
10037 }
10038 }
10039 }
10040 }
10041 }
10042 }
10043 alias: "cont_in"
10044 }
10045 projection {
10046 source {
10047 type: OPERATOR
10048 operator {
10049 name: "not_cont_in"
10050 param {
10051 type: OBJECT
10052 object {
10053 fld {
10054 key: "scalar_10"
10055 value {
10056 type: LITERAL
10057 literal {
10058 type: V_SINT
10059 v_signed_int: 10
10060 }
10061 }
10062 }
10063 }
10064 }
10065 param {
10066 type: FUNC_CALL
10067 function_call {
10068 name {
10069 name: "json_object"
10070 }
10071 param {
10072 type: LITERAL
10073 literal {
10074 type: V_OCTETS
10075 v_octets {
10076 value: "scalar_10"
10077 }
10078 }
10079 }
10080 param {
10081 type: LITERAL
10082 literal {
10083 type: V_SINT
10084 v_signed_int: 10
10085 }
10086 }
10087 }
10088 }
10089 }
10090 }
10091 alias: "not_cont_in"
10092 }
10093 }
10094
10095 cont_in not_cont_in
10096 1 0
10097 command ok
10098 Got expected error (code 0)
10099
10100 JSON_QUOTE - Quote JSON document
10101 --------------------------------
10102 send Mysqlx.Crud.Find {
10103 collection {
10104 name: "xtable"
10105 schema: "xtest"
10106 }
10107 data_model: TABLE
10108 projection {
10109 source {
10110 type: OPERATOR
10111 operator {
10112 name: "cont_in"
10113 param {
10114 type: FUNC_CALL
10115 function_call {
10116 name {
10117 name: "json_quote"
10118 }
10119 param {
10120 type: LITERAL
10121 literal {
10122 type: V_STRING
10123 v_string {
10124 value: "red"
10125 }
10126 }
10127 }
10128 }
10129 }
10130 param {
10131 type: ARRAY
10132 array {
10133 value {
10134 type: LITERAL
10135 literal {
10136 type: V_STRING
10137 v_string {
10138 value: "red"
10139 }
10140 }
10141 }
10142 value {
10143 type: LITERAL
10144 literal {
10145 type: V_STRING
10146 v_string {
10147 value: "green"
10148 }
10149 }
10150 }
10151 value {
10152 type: LITERAL
10153 literal {
10154 type: V_STRING
10155 v_string {
10156 value: "blue"
10157 }
10158 }
10159 }
10160 }
10161 }
10162 }
10163 }
10164 alias: "cont_in"
10165 }
10166 projection {
10167 source {
10168 type: OPERATOR
10169 operator {
10170 name: "not_cont_in"
10171 param {
10172 type: FUNC_CALL
10173 function_call {
10174 name {
10175 name: "json_quote"
10176 }
10177 param {
10178 type: LITERAL
10179 literal {
10180 type: V_STRING
10181 v_string {
10182 value: "red"
10183 }
10184 }
10185 }
10186 }
10187 }
10188 param {
10189 type: ARRAY
10190 array {
10191 value {
10192 type: LITERAL
10193 literal {
10194 type: V_STRING
10195 v_string {
10196 value: "red"
10197 }
10198 }
10199 }
10200 value {
10201 type: LITERAL
10202 literal {
10203 type: V_STRING
10204 v_string {
10205 value: "green"
10206 }
10207 }
10208 }
10209 value {
10210 type: LITERAL
10211 literal {
10212 type: V_STRING
10213 v_string {
10214 value: "blue"
10215 }
10216 }
10217 }
10218 }
10219 }
10220 }
10221 }
10222 alias: "not_cont_in"
10223 }
10224 }
10225
10226 cont_in not_cont_in
10227 1 0
10228 command ok
10229 Got expected error (code 0)
10230
10231 JSON_REMOVE - Remove data from JSON document
10232 --------------------------------------------
10233 send Mysqlx.Crud.Find {
10234 collection {
10235 name: "xtable"
10236 schema: "xtest"
10237 }
10238 data_model: TABLE
10239 projection {
10240 source {
10241 type: OPERATOR
10242 operator {
10243 name: "cont_in"
10244 param {
10245 type: LITERAL
10246 literal {
10247 type: V_SINT
10248 v_signed_int: 20
10249 }
10250 }
10251 param {
10252 type: FUNC_CALL
10253 function_call {
10254 name {
10255 name: "json_remove"
10256 }
10257 param {
10258 type: ARRAY
10259 array {
10260 value {
10261 type: LITERAL
10262 literal {
10263 type: V_SINT
10264 v_signed_int: 10
10265 }
10266 }
10267 value {
10268 type: LITERAL
10269 literal {
10270 type: V_SINT
10271 v_signed_int: 20
10272 }
10273 }
10274 value {
10275 type: LITERAL
10276 literal {
10277 type: V_SINT
10278 v_signed_int: 30
10279 }
10280 }
10281 }
10282 }
10283 param {
10284 type: LITERAL
10285 literal {
10286 type: V_OCTETS
10287 v_octets {
10288 value: "$[1]"
10289 }
10290 }
10291 }
10292 }
10293 }
10294 }
10295 }
10296 alias: "cont_in"
10297 }
10298 projection {
10299 source {
10300 type: OPERATOR
10301 operator {
10302 name: "not_cont_in"
10303 param {
10304 type: LITERAL
10305 literal {
10306 type: V_SINT
10307 v_signed_int: 20
10308 }
10309 }
10310 param {
10311 type: FUNC_CALL
10312 function_call {
10313 name {
10314 name: "json_remove"
10315 }
10316 param {
10317 type: ARRAY
10318 array {
10319 value {
10320 type: LITERAL
10321 literal {
10322 type: V_SINT
10323 v_signed_int: 10
10324 }
10325 }
10326 value {
10327 type: LITERAL
10328 literal {
10329 type: V_SINT
10330 v_signed_int: 20
10331 }
10332 }
10333 value {
10334 type: LITERAL
10335 literal {
10336 type: V_SINT
10337 v_signed_int: 30
10338 }
10339 }
10340 }
10341 }
10342 param {
10343 type: LITERAL
10344 literal {
10345 type: V_OCTETS
10346 v_octets {
10347 value: "$[1]"
10348 }
10349 }
10350 }
10351 }
10352 }
10353 }
10354 }
10355 alias: "not_cont_in"
10356 }
10357 }
10358
10359 cont_in not_cont_in
10360 0 1
10361 command ok
10362 Got expected error (code 0)
10363
10364 JSON_REPLACE - Replace values in JSON document
10365 ----------------------------------------------
10366 send Mysqlx.Crud.Find {
10367 collection {
10368 name: "xtable"
10369 schema: "xtest"
10370 }
10371 data_model: TABLE
10372 projection {
10373 source {
10374 type: OPERATOR
10375 operator {
10376 name: "cont_in"
10377 param {
10378 type: LITERAL
10379 literal {
10380 type: V_SINT
10381 v_signed_int: 40
10382 }
10383 }
10384 param {
10385 type: FUNC_CALL
10386 function_call {
10387 name {
10388 name: "json_replace"
10389 }
10390 param {
10391 type: ARRAY
10392 array {
10393 value {
10394 type: LITERAL
10395 literal {
10396 type: V_SINT
10397 v_signed_int: 10
10398 }
10399 }
10400 value {
10401 type: LITERAL
10402 literal {
10403 type: V_SINT
10404 v_signed_int: 20
10405 }
10406 }
10407 value {
10408 type: LITERAL
10409 literal {
10410 type: V_SINT
10411 v_signed_int: 30
10412 }
10413 }
10414 }
10415 }
10416 param {
10417 type: LITERAL
10418 literal {
10419 type: V_OCTETS
10420 v_octets {
10421 value: "$[1]"
10422 }
10423 }
10424 }
10425 param {
10426 type: LITERAL
10427 literal {
10428 type: V_SINT
10429 v_signed_int: 40
10430 }
10431 }
10432 }
10433 }
10434 }
10435 }
10436 alias: "cont_in"
10437 }
10438 projection {
10439 source {
10440 type: OPERATOR
10441 operator {
10442 name: "not_cont_in"
10443 param {
10444 type: LITERAL
10445 literal {
10446 type: V_SINT
10447 v_signed_int: 40
10448 }
10449 }
10450 param {
10451 type: FUNC_CALL
10452 function_call {
10453 name {
10454 name: "json_replace"
10455 }
10456 param {
10457 type: ARRAY
10458 array {
10459 value {
10460 type: LITERAL
10461 literal {
10462 type: V_SINT
10463 v_signed_int: 10
10464 }
10465 }
10466 value {
10467 type: LITERAL
10468 literal {
10469 type: V_SINT
10470 v_signed_int: 20
10471 }
10472 }
10473 value {
10474 type: LITERAL
10475 literal {
10476 type: V_SINT
10477 v_signed_int: 30
10478 }
10479 }
10480 }
10481 }
10482 param {
10483 type: LITERAL
10484 literal {
10485 type: V_OCTETS
10486 v_octets {
10487 value: "$[1]"
10488 }
10489 }
10490 }
10491 param {
10492 type: LITERAL
10493 literal {
10494 type: V_SINT
10495 v_signed_int: 40
10496 }
10497 }
10498 }
10499 }
10500 }
10501 }
10502 alias: "not_cont_in"
10503 }
10504 }
10505
10506 cont_in not_cont_in
10507 1 0
10508 command ok
10509 Got expected error (code 0)
10510
10511 JSON_SEARCH - Path to value within JSON document
10512 ------------------------------------------------
10513 send Mysqlx.Crud.Find {
10514 collection {
10515 name: "xtable"
10516 schema: "xtest"
10517 }
10518 data_model: TABLE
10519 projection {
10520 source {
10521 type: OPERATOR
10522 operator {
10523 name: "cont_in"
10524 param {
10525 type: LITERAL
10526 literal {
10527 type: V_OCTETS
10528 v_octets {
10529 value: "$[1]"
10530 }
10531 }
10532 }
10533 param {
10534 type: FUNC_CALL
10535 function_call {
10536 name {
10537 name: "json_search"
10538 }
10539 param {
10540 type: ARRAY
10541 array {
10542 value {
10543 type: LITERAL
10544 literal {
10545 type: V_STRING
10546 v_string {
10547 value: "red"
10548 }
10549 }
10550 }
10551 value {
10552 type: LITERAL
10553 literal {
10554 type: V_STRING
10555 v_string {
10556 value: "green"
10557 }
10558 }
10559 }
10560 value {
10561 type: LITERAL
10562 literal {
10563 type: V_STRING
10564 v_string {
10565 value: "blue"
10566 }
10567 }
10568 }
10569 }
10570 }
10571 param {
10572 type: LITERAL
10573 literal {
10574 type: V_OCTETS
10575 v_octets {
10576 value: "one"
10577 }
10578 }
10579 }
10580 param {
10581 type: LITERAL
10582 literal {
10583 type: V_STRING
10584 v_string {
10585 value: "green"
10586 }
10587 }
10588 }
10589 }
10590 }
10591 }
10592 }
10593 alias: "cont_in"
10594 }
10595 projection {
10596 source {
10597 type: OPERATOR
10598 operator {
10599 name: "not_cont_in"
10600 param {
10601 type: LITERAL
10602 literal {
10603 type: V_OCTETS
10604 v_octets {
10605 value: "$[1]"
10606 }
10607 }
10608 }
10609 param {
10610 type: FUNC_CALL
10611 function_call {
10612 name {
10613 name: "json_search"
10614 }
10615 param {
10616 type: ARRAY
10617 array {
10618 value {
10619 type: LITERAL
10620 literal {
10621 type: V_STRING
10622 v_string {
10623 value: "red"
10624 }
10625 }
10626 }
10627 value {
10628 type: LITERAL
10629 literal {
10630 type: V_STRING
10631 v_string {
10632 value: "green"
10633 }
10634 }
10635 }
10636 value {
10637 type: LITERAL
10638 literal {
10639 type: V_STRING
10640 v_string {
10641 value: "blue"
10642 }
10643 }
10644 }
10645 }
10646 }
10647 param {
10648 type: LITERAL
10649 literal {
10650 type: V_OCTETS
10651 v_octets {
10652 value: "one"
10653 }
10654 }
10655 }
10656 param {
10657 type: LITERAL
10658 literal {
10659 type: V_STRING
10660 v_string {
10661 value: "green"
10662 }
10663 }
10664 }
10665 }
10666 }
10667 }
10668 }
10669 alias: "not_cont_in"
10670 }
10671 }
10672
10673 cont_in not_cont_in
10674 1 0
10675 command ok
10676 Got expected error (code 0)
10677
10678 JSON_SET - Insert data into JSON document
10679 -----------------------------------------
10680 send Mysqlx.Crud.Find {
10681 collection {
10682 name: "xtable"
10683 schema: "xtest"
10684 }
10685 data_model: TABLE
10686 projection {
10687 source {
10688 type: OPERATOR
10689 operator {
10690 name: "cont_in"
10691 param {
10692 type: OBJECT
10693 object {
10694 fld {
10695 key: "scalar_10"
10696 value {
10697 type: LITERAL
10698 literal {
10699 type: V_SINT
10700 v_signed_int: 10
10701 }
10702 }
10703 }
10704 }
10705 }
10706 param {
10707 type: FUNC_CALL
10708 function_call {
10709 name {
10710 name: "json_set"
10711 }
10712 param {
10713 type: OBJECT
10714 object {
10715 fld {
10716 key: "scalar_blue"
10717 value {
10718 type: LITERAL
10719 literal {
10720 type: V_STRING
10721 v_string {
10722 value: "blue"
10723 }
10724 }
10725 }
10726 }
10727 }
10728 }
10729 param {
10730 type: LITERAL
10731 literal {
10732 type: V_OCTETS
10733 v_octets {
10734 value: "$.scalar_10"
10735 }
10736 }
10737 }
10738 param {
10739 type: LITERAL
10740 literal {
10741 type: V_SINT
10742 v_signed_int: 10
10743 }
10744 }
10745 }
10746 }
10747 }
10748 }
10749 alias: "cont_in"
10750 }
10751 projection {
10752 source {
10753 type: OPERATOR
10754 operator {
10755 name: "not_cont_in"
10756 param {
10757 type: OBJECT
10758 object {
10759 fld {
10760 key: "scalar_10"
10761 value {
10762 type: LITERAL
10763 literal {
10764 type: V_SINT
10765 v_signed_int: 10
10766 }
10767 }
10768 }
10769 }
10770 }
10771 param {
10772 type: FUNC_CALL
10773 function_call {
10774 name {
10775 name: "json_set"
10776 }
10777 param {
10778 type: OBJECT
10779 object {
10780 fld {
10781 key: "scalar_blue"
10782 value {
10783 type: LITERAL
10784 literal {
10785 type: V_STRING
10786 v_string {
10787 value: "blue"
10788 }
10789 }
10790 }
10791 }
10792 }
10793 }
10794 param {
10795 type: LITERAL
10796 literal {
10797 type: V_OCTETS
10798 v_octets {
10799 value: "$.scalar_10"
10800 }
10801 }
10802 }
10803 param {
10804 type: LITERAL
10805 literal {
10806 type: V_SINT
10807 v_signed_int: 10
10808 }
10809 }
10810 }
10811 }
10812 }
10813 }
10814 alias: "not_cont_in"
10815 }
10816 }
10817
10818 cont_in not_cont_in
10819 1 0
10820 command ok
10821 Got expected error (code 0)
10822
10823 JSON_TYPE - Type of JSON value
10824 ------------------------------
10825 send Mysqlx.Crud.Find {
10826 collection {
10827 name: "xtable"
10828 schema: "xtest"
10829 }
10830 data_model: TABLE
10831 projection {
10832 source {
10833 type: OPERATOR
10834 operator {
10835 name: "cont_in"
10836 param {
10837 type: FUNC_CALL
10838 function_call {
10839 name {
10840 name: "json_type"
10841 }
10842 param {
10843 type: OBJECT
10844 object {
10845 fld {
10846 key: "scalar_blue"
10847 value {
10848 type: LITERAL
10849 literal {
10850 type: V_STRING
10851 v_string {
10852 value: "blue"
10853 }
10854 }
10855 }
10856 }
10857 }
10858 }
10859 }
10860 }
10861 param {
10862 type: ARRAY
10863 array {
10864 value {
10865 type: LITERAL
10866 literal {
10867 type: V_STRING
10868 v_string {
10869 value: "red"
10870 }
10871 }
10872 }
10873 value {
10874 type: LITERAL
10875 literal {
10876 type: V_STRING
10877 v_string {
10878 value: "green"
10879 }
10880 }
10881 }
10882 value {
10883 type: LITERAL
10884 literal {
10885 type: V_STRING
10886 v_string {
10887 value: "blue"
10888 }
10889 }
10890 }
10891 }
10892 }
10893 }
10894 }
10895 alias: "cont_in"
10896 }
10897 projection {
10898 source {
10899 type: OPERATOR
10900 operator {
10901 name: "not_cont_in"
10902 param {
10903 type: FUNC_CALL
10904 function_call {
10905 name {
10906 name: "json_type"
10907 }
10908 param {
10909 type: OBJECT
10910 object {
10911 fld {
10912 key: "scalar_blue"
10913 value {
10914 type: LITERAL
10915 literal {
10916 type: V_STRING
10917 v_string {
10918 value: "blue"
10919 }
10920 }
10921 }
10922 }
10923 }
10924 }
10925 }
10926 }
10927 param {
10928 type: ARRAY
10929 array {
10930 value {
10931 type: LITERAL
10932 literal {
10933 type: V_STRING
10934 v_string {
10935 value: "red"
10936 }
10937 }
10938 }
10939 value {
10940 type: LITERAL
10941 literal {
10942 type: V_STRING
10943 v_string {
10944 value: "green"
10945 }
10946 }
10947 }
10948 value {
10949 type: LITERAL
10950 literal {
10951 type: V_STRING
10952 v_string {
10953 value: "blue"
10954 }
10955 }
10956 }
10957 }
10958 }
10959 }
10960 }
10961 alias: "not_cont_in"
10962 }
10963 }
10964
10965 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
10966
10967 JSON_UNQUOTE - Unquote JSON value
10968 ---------------------------------
10969 send Mysqlx.Crud.Find {
10970 collection {
10971 name: "xtable"
10972 schema: "xtest"
10973 }
10974 data_model: TABLE
10975 projection {
10976 source {
10977 type: OPERATOR
10978 operator {
10979 name: "cont_in"
10980 param {
10981 type: FUNC_CALL
10982 function_call {
10983 name {
10984 name: "json_unquote"
10985 }
10986 param {
10987 type: IDENT
10988 identifier {
10989 document_path {
10990 type: MEMBER
10991 value: "scalar_red"
10992 }
10993 name: "doc"
10994 }
10995 }
10996 }
10997 }
10998 param {
10999 type: ARRAY
11000 array {
11001 value {
11002 type: LITERAL
11003 literal {
11004 type: V_STRING
11005 v_string {
11006 value: "red"
11007 }
11008 }
11009 }
11010 value {
11011 type: LITERAL
11012 literal {
11013 type: V_STRING
11014 v_string {
11015 value: "green"
11016 }
11017 }
11018 }
11019 value {
11020 type: LITERAL
11021 literal {
11022 type: V_STRING
11023 v_string {
11024 value: "blue"
11025 }
11026 }
11027 }
11028 }
11029 }
11030 }
11031 }
11032 alias: "cont_in"
11033 }
11034 projection {
11035 source {
11036 type: OPERATOR
11037 operator {
11038 name: "not_cont_in"
11039 param {
11040 type: FUNC_CALL
11041 function_call {
11042 name {
11043 name: "json_unquote"
11044 }
11045 param {
11046 type: IDENT
11047 identifier {
11048 document_path {
11049 type: MEMBER
11050 value: "scalar_red"
11051 }
11052 name: "doc"
11053 }
11054 }
11055 }
11056 }
11057 param {
11058 type: ARRAY
11059 array {
11060 value {
11061 type: LITERAL
11062 literal {
11063 type: V_STRING
11064 v_string {
11065 value: "red"
11066 }
11067 }
11068 }
11069 value {
11070 type: LITERAL
11071 literal {
11072 type: V_STRING
11073 v_string {
11074 value: "green"
11075 }
11076 }
11077 }
11078 value {
11079 type: LITERAL
11080 literal {
11081 type: V_STRING
11082 v_string {
11083 value: "blue"
11084 }
11085 }
11086 }
11087 }
11088 }
11089 }
11090 }
11091 alias: "not_cont_in"
11092 }
11093 }
11094
11095 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
11096
11097 JSON_VALID - Whether JSON value is valid
11098 ----------------------------------------
11099 send Mysqlx.Crud.Find {
11100 collection {
11101 name: "xtable"
11102 schema: "xtest"
11103 }
11104 data_model: TABLE
11105 projection {
11106 source {
11107 type: OPERATOR
11108 operator {
11109 name: "cont_in"
11110 param {
11111 type: FUNC_CALL
11112 function_call {
11113 name {
11114 name: "json_valid"
11115 }
11116 param {
11117 type: OBJECT
11118 object {
11119 fld {
11120 key: "scalar_blue"
11121 value {
11122 type: LITERAL
11123 literal {
11124 type: V_STRING
11125 v_string {
11126 value: "blue"
11127 }
11128 }
11129 }
11130 }
11131 }
11132 }
11133 }
11134 }
11135 param {
11136 type: ARRAY
11137 array {
11138 value {
11139 type: LITERAL
11140 literal {
11141 type: V_SINT
11142 v_signed_int: 10
11143 }
11144 }
11145 value {
11146 type: LITERAL
11147 literal {
11148 type: V_SINT
11149 v_signed_int: 20
11150 }
11151 }
11152 value {
11153 type: LITERAL
11154 literal {
11155 type: V_SINT
11156 v_signed_int: 30
11157 }
11158 }
11159 }
11160 }
11161 }
11162 }
11163 alias: "cont_in"
11164 }
11165 projection {
11166 source {
11167 type: OPERATOR
11168 operator {
11169 name: "not_cont_in"
11170 param {
11171 type: FUNC_CALL
11172 function_call {
11173 name {
11174 name: "json_valid"
11175 }
11176 param {
11177 type: OBJECT
11178 object {
11179 fld {
11180 key: "scalar_blue"
11181 value {
11182 type: LITERAL
11183 literal {
11184 type: V_STRING
11185 v_string {
11186 value: "blue"
11187 }
11188 }
11189 }
11190 }
11191 }
11192 }
11193 }
11194 }
11195 param {
11196 type: ARRAY
11197 array {
11198 value {
11199 type: LITERAL
11200 literal {
11201 type: V_SINT
11202 v_signed_int: 10
11203 }
11204 }
11205 value {
11206 type: LITERAL
11207 literal {
11208 type: V_SINT
11209 v_signed_int: 20
11210 }
11211 }
11212 value {
11213 type: LITERAL
11214 literal {
11215 type: V_SINT
11216 v_signed_int: 30
11217 }
11218 }
11219 }
11220 }
11221 }
11222 }
11223 alias: "not_cont_in"
11224 }
11225 }
11226
11227 Got expected error: CONT_IN expression requires function that produce a JSON value. (code 5154)
11228
11229 Number of parameters
11230 --------------------
11231 send Mysqlx.Crud.Find {
11232 collection {
11233 name: "xtable"
11234 schema: "xtest"
11235 }
11236 data_model: TABLE
11237 projection {
11238 source {
11239 type: OPERATOR
11240 operator {
11241 name: "cont_in"
11242 }
11243 }
11244 alias: "cont_in"
11245 }
11246 }
11247
11248 Got expected error: CONT_IN expression requires two parameters. (code 5151)
11249 send Mysqlx.Crud.Find {
11250 collection {
11251 name: "xtable"
11252 schema: "xtest"
11253 }
11254 data_model: TABLE
11255 projection {
11256 source {
11257 type: OPERATOR
11258 operator {
11259 name: "cont_in"
11260 param {
11261 type: LITERAL
11262 literal {
11263 type: V_SINT
11264 v_signed_int: 10
11265 }
11266 }
11267 }
11268 }
11269 alias: "cont_in"
11270 }
11271 }
11272
11273 Got expected error: CONT_IN expression requires two parameters. (code 5151)
11274 send Mysqlx.Crud.Find {
11275 collection {
11276 name: "xtable"
11277 schema: "xtest"
11278 }
11279 data_model: TABLE
11280 projection {
11281 source {
11282 type: OPERATOR
11283 operator {
11284 name: "cont_in"
11285 param {
11286 type: LITERAL
11287 literal {
11288 type: V_SINT
11289 v_signed_int: 10
11290 }
11291 }
11292 param {
11293 type: LITERAL
11294 literal {
11295 type: V_SINT
11296 v_signed_int: 20
11297 }
11298 }
11299 }
11300 }
11301 alias: "cont_in"
11302 }
11303 }
11304
11305 cont_in
11306 0
11307 command ok
11308 Got expected error (code 0)
11309 send Mysqlx.Crud.Find {
11310 collection {
11311 name: "xtable"
11312 schema: "xtest"
11313 }
11314 data_model: TABLE
11315 projection {
11316 source {
11317 type: OPERATOR
11318 operator {
11319 name: "cont_in"
11320 param {
11321 type: LITERAL
11322 literal {
11323 type: V_SINT
11324 v_signed_int: 10
11325 }
11326 }
11327 param {
11328 type: LITERAL
11329 literal {
11330 type: V_SINT
11331 v_signed_int: 20
11332 }
11333 }
11334 param {
11335 type: LITERAL
11336 literal {
11337 type: V_SINT
11338 v_signed_int: 30
11339 }
11340 }
11341 }
11342 }
11343 alias: "cont_in"
11344 }
11345 }
11346
11347 Got expected error: CONT_IN expression requires two parameters. (code 5151)
11348 Mysqlx.Ok {
11349 msg: "bye!"
11350 }
11351 ok