Debian Codegraph @

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

raw
1 =============================================
2 CRUD UPDATE ARRAY_APPEND SCENARIOS
3 =============================================
4
5 ================================================================================
6 PREAMBLE
7 ================================================================================
8 create user updateitemremove@localhost identified by 'updateitemremove';
9 grant all on *.* to updateitemremove@localhost;
10 CREATE SCHEMA mysqlxcoll;
11 ================================================================================
12 TEST START
13 ================================================================================
14
15 command ok
16 RUN SET SQL_SAFE_UPDATES = 0
17
18 0 rows affected
19 RUN USE mysqlxcoll
20
21 0 rows affected
22 RUN INSERT INTO maincoll (doc) values ('{"_id": "1", "name": "Victor", "last_name": "Otero","amount": 4.99}')
23
24 1 rows affected
25 RUN INSERT INTO maincoll (doc) values ('{"_id": "2", "name": "Gonzalo", "last_name": "Chrystens","amount": 120.57}')
26
27 1 rows affected
28 RUN INSERT INTO maincoll (doc) values ('{"_id": "3", "name": "Abraham", "last_name": "Vega","amount": 74.56}')
29
30 1 rows affected
31 RUN INSERT INTO maincoll (doc) values ('{"_id": "4", "name": "Jennifer", "last_name": "Leon","amount": 387.14}')
32
33 1 rows affected
34 RUN INSERT INTO maincoll (doc) values ('{"_id": "5", "name": "Jhonny", "last_name": "Test","amount": 125.45}')
35
36 1 rows affected
37 RUN INSERT INTO maincoll (doc) values ('{"_id": "6","name":null}')
38
39 1 rows affected
40 RUN INSERT INTO maincoll (doc) values ('{"_id": "7"}')
41
42 1 rows affected
43 Update a valid collection with == operator
44 send Mysqlx.Crud.Update {
45 collection {
46 name: "maincoll"
47 schema: "mysqlxcoll"
48 }
49 data_model: DOCUMENT
50 criteria {
51 type: OPERATOR
52 operator {
53 name: "=="
54 param {
55 type: IDENT
56 identifier {
57 name: "_id"
58 }
59 }
60 param {
61 type: LITERAL
62 literal {
63 type: V_OCTETS
64 v_octets {
65 value: "1"
66 }
67 }
68 }
69 }
70 }
71 operation {
72 source {
73 document_path {
74 type: MEMBER
75 value: "name"
76 }
77 }
78 operation: ARRAY_APPEND
79 value {
80 type: LITERAL
81 literal {
82 type: V_STRING
83 v_string {
84 value: "\"VictorArrayAppend\""
85 }
86 }
87 }
88 }
89 }
90
91
92 1 rows affected
93 Rows matched: 1 Changed: 1 Warnings: 0
94 RUN select doc from maincoll
95 doc
96 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\""], "amount": 4.99, "last_name": "Otero"}
97 {"_id": "2", "name": "Gonzalo", "amount": 120.57, "last_name": "Chrystens"}
98 {"_id": "3", "name": "Abraham", "amount": 74.56, "last_name": "Vega"}
99 {"_id": "4", "name": "Jennifer", "amount": 387.14, "last_name": "Leon"}
100 {"_id": "5", "name": "Jhonny", "amount": 125.45, "last_name": "Test"}
101 {"_id": "6", "name": null}
102 {"_id": "7"}
103 0 rows affected
104 Update a valid collection with string value and > operator for multiple docs
105 send Mysqlx.Crud.Update {
106 collection {
107 name: "maincoll"
108 schema: "mysqlxcoll"
109 }
110 data_model: DOCUMENT
111 criteria {
112 type: OPERATOR
113 operator {
114 name: ">"
115 param {
116 type: IDENT
117 identifier {
118 name: "_id"
119 }
120 }
121 param {
122 type: LITERAL
123 literal {
124 type: V_OCTETS
125 v_octets {
126 value: "3"
127 }
128 }
129 }
130 }
131 }
132 operation {
133 source {
134 document_path {
135 type: MEMBER
136 value: "name"
137 }
138 }
139 operation: ARRAY_APPEND
140 value {
141 type: LITERAL
142 literal {
143 type: V_STRING
144 v_string {
145 value: "\"ExtraName_>\""
146 }
147 }
148 }
149 }
150 }
151
152
153 3 rows affected
154 Rows matched: 4 Changed: 3 Warnings: 0
155 RUN select doc from maincoll
156 doc
157 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\""], "amount": 4.99, "last_name": "Otero"}
158 {"_id": "2", "name": "Gonzalo", "amount": 120.57, "last_name": "Chrystens"}
159 {"_id": "3", "name": "Abraham", "amount": 74.56, "last_name": "Vega"}
160 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": 387.14, "last_name": "Leon"}
161 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": 125.45, "last_name": "Test"}
162 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
163 {"_id": "7"}
164 0 rows affected
165 Update a valid collection with string value and < operator for multiple docs
166 send Mysqlx.Crud.Update {
167 collection {
168 name: "maincoll"
169 schema: "mysqlxcoll"
170 }
171 data_model: DOCUMENT
172 criteria {
173 type: OPERATOR
174 operator {
175 name: "<"
176 param {
177 type: IDENT
178 identifier {
179 name: "_id"
180 }
181 }
182 param {
183 type: LITERAL
184 literal {
185 type: V_OCTETS
186 v_octets {
187 value: "3"
188 }
189 }
190 }
191 }
192 }
193 operation {
194 source {
195 document_path {
196 type: MEMBER
197 value: "name"
198 }
199 }
200 operation: ARRAY_APPEND
201 value {
202 type: LITERAL
203 literal {
204 type: V_STRING
205 v_string {
206 value: "\"ExtraName_<\""
207 }
208 }
209 }
210 }
211 }
212
213
214 2 rows affected
215 Rows matched: 2 Changed: 2 Warnings: 0
216 RUN select doc from maincoll
217 doc
218 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": "Otero"}
219 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": 120.57, "last_name": "Chrystens"}
220 {"_id": "3", "name": "Abraham", "amount": 74.56, "last_name": "Vega"}
221 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": 387.14, "last_name": "Leon"}
222 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": 125.45, "last_name": "Test"}
223 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
224 {"_id": "7"}
225 0 rows affected
226 Update a valid collection with string value and <= operator for multiple docs
227 send Mysqlx.Crud.Update {
228 collection {
229 name: "maincoll"
230 schema: "mysqlxcoll"
231 }
232 data_model: DOCUMENT
233 criteria {
234 type: OPERATOR
235 operator {
236 name: "<="
237 param {
238 type: IDENT
239 identifier {
240 name: "_id"
241 }
242 }
243 param {
244 type: LITERAL
245 literal {
246 type: V_OCTETS
247 v_octets {
248 value: "3"
249 }
250 }
251 }
252 }
253 }
254 operation {
255 source {
256 document_path {
257 type: MEMBER
258 value: "last_name"
259 }
260 }
261 operation: ARRAY_APPEND
262 value {
263 type: LITERAL
264 literal {
265 type: V_STRING
266 v_string {
267 value: "\"ExtraLastName_<=\""
268 }
269 }
270 }
271 }
272 }
273
274
275 3 rows affected
276 Rows matched: 3 Changed: 3 Warnings: 0
277 RUN select doc from maincoll
278 doc
279 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": ["Otero", "\"ExtraLastName_<=\""]}
280 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": 120.57, "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
281 {"_id": "3", "name": "Abraham", "amount": 74.56, "last_name": ["Vega", "\"ExtraLastName_<=\""]}
282 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": 387.14, "last_name": "Leon"}
283 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": 125.45, "last_name": "Test"}
284 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
285 {"_id": "7"}
286 0 rows affected
287 Update a valid collection with string value and >= operator for multiple docs
288 send Mysqlx.Crud.Update {
289 collection {
290 name: "maincoll"
291 schema: "mysqlxcoll"
292 }
293 data_model: DOCUMENT
294 criteria {
295 type: OPERATOR
296 operator {
297 name: ">="
298 param {
299 type: IDENT
300 identifier {
301 name: "_id"
302 }
303 }
304 param {
305 type: LITERAL
306 literal {
307 type: V_OCTETS
308 v_octets {
309 value: "4"
310 }
311 }
312 }
313 }
314 }
315 operation {
316 source {
317 document_path {
318 type: MEMBER
319 value: "last_name"
320 }
321 }
322 operation: ARRAY_APPEND
323 value {
324 type: LITERAL
325 literal {
326 type: V_STRING
327 v_string {
328 value: "\"ExtraLastName_>=\""
329 }
330 }
331 }
332 }
333 }
334
335
336 2 rows affected
337 Rows matched: 4 Changed: 2 Warnings: 0
338 RUN select doc from maincoll
339 doc
340 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": ["Otero", "\"ExtraLastName_<=\""]}
341 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": 120.57, "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
342 {"_id": "3", "name": "Abraham", "amount": 74.56, "last_name": ["Vega", "\"ExtraLastName_<=\""]}
343 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": 387.14, "last_name": ["Leon", "\"ExtraLastName_>=\""]}
344 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": 125.45, "last_name": ["Test", "\"ExtraLastName_>=\""]}
345 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
346 {"_id": "7"}
347 0 rows affected
348 Update a valid collection with string value and != operator for multiple docs
349 send Mysqlx.Crud.Update {
350 collection {
351 name: "maincoll"
352 schema: "mysqlxcoll"
353 }
354 data_model: DOCUMENT
355 criteria {
356 type: OPERATOR
357 operator {
358 name: "!="
359 param {
360 type: IDENT
361 identifier {
362 name: "_id"
363 }
364 }
365 param {
366 type: LITERAL
367 literal {
368 type: V_OCTETS
369 v_octets {
370 value: "1"
371 }
372 }
373 }
374 }
375 }
376 operation {
377 source {
378 document_path {
379 type: MEMBER
380 value: "amount"
381 }
382 }
383 operation: ARRAY_APPEND
384 value {
385 type: LITERAL
386 literal {
387 type: V_UINT
388 v_unsigned_int: 10
389 }
390 }
391 }
392 }
393
394
395 4 rows affected
396 Rows matched: 6 Changed: 4 Warnings: 0
397 RUN select doc from maincoll
398 doc
399 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": ["Otero", "\"ExtraLastName_<=\""]}
400 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
401 {"_id": "3", "name": "Abraham", "amount": [74.56, 10], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
402 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
403 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": [125.45, 10], "last_name": ["Test", "\"ExtraLastName_>=\""]}
404 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
405 {"_id": "7"}
406 0 rows affected
407 Update append a Double
408 send Mysqlx.Crud.Update {
409 collection {
410 name: "maincoll"
411 schema: "mysqlxcoll"
412 }
413 data_model: DOCUMENT
414 criteria {
415 type: OPERATOR
416 operator {
417 name: "=="
418 param {
419 type: IDENT
420 identifier {
421 name: "_id"
422 }
423 }
424 param {
425 type: LITERAL
426 literal {
427 type: V_OCTETS
428 v_octets {
429 value: "4"
430 }
431 }
432 }
433 }
434 }
435 operation {
436 source {
437 document_path {
438 type: MEMBER
439 value: "amount"
440 }
441 }
442 operation: ARRAY_APPEND
443 value {
444 type: LITERAL
445 literal {
446 type: V_DOUBLE
447 v_double: 156.59874665
448 }
449 }
450 }
451 }
452
453
454 1 rows affected
455 Rows matched: 1 Changed: 1 Warnings: 0
456 RUN select doc from maincoll
457 doc
458 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": ["Otero", "\"ExtraLastName_<=\""]}
459 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
460 {"_id": "3", "name": "Abraham", "amount": [74.56, 10], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
461 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
462 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": [125.45, 10], "last_name": ["Test", "\"ExtraLastName_>=\""]}
463 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
464 {"_id": "7"}
465 0 rows affected
466 Update append a Float
467 send Mysqlx.Crud.Update {
468 collection {
469 name: "maincoll"
470 schema: "mysqlxcoll"
471 }
472 data_model: DOCUMENT
473 criteria {
474 type: OPERATOR
475 operator {
476 name: "=="
477 param {
478 type: IDENT
479 identifier {
480 name: "_id"
481 }
482 }
483 param {
484 type: LITERAL
485 literal {
486 type: V_OCTETS
487 v_octets {
488 value: "4"
489 }
490 }
491 }
492 }
493 }
494 operation {
495 source {
496 document_path {
497 type: MEMBER
498 value: "amount"
499 }
500 }
501 operation: ARRAY_APPEND
502 value {
503 type: LITERAL
504 literal {
505 type: V_FLOAT
506 v_float: 78445.5
507 }
508 }
509 }
510 }
511
512
513 1 rows affected
514 Rows matched: 1 Changed: 1 Warnings: 0
515 RUN select doc from maincoll
516 doc
517 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": ["Otero", "\"ExtraLastName_<=\""]}
518 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
519 {"_id": "3", "name": "Abraham", "amount": [74.56, 10], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
520 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
521 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": [125.45, 10], "last_name": ["Test", "\"ExtraLastName_>=\""]}
522 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
523 {"_id": "7"}
524 0 rows affected
525 Update append a NULL
526 send Mysqlx.Crud.Update {
527 collection {
528 name: "maincoll"
529 schema: "mysqlxcoll"
530 }
531 data_model: DOCUMENT
532 criteria {
533 type: OPERATOR
534 operator {
535 name: "=="
536 param {
537 type: IDENT
538 identifier {
539 name: "_id"
540 }
541 }
542 param {
543 type: LITERAL
544 literal {
545 type: V_OCTETS
546 v_octets {
547 value: "4"
548 }
549 }
550 }
551 }
552 }
553 operation {
554 source {
555 document_path {
556 type: MEMBER
557 value: "amount"
558 }
559 }
560 operation: ARRAY_APPEND
561 value {
562 type: LITERAL
563 literal {
564 type: V_NULL
565 }
566 }
567 }
568 }
569
570
571 1 rows affected
572 Rows matched: 1 Changed: 1 Warnings: 0
573 RUN select doc from maincoll
574 doc
575 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": ["Otero", "\"ExtraLastName_<=\""]}
576 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
577 {"_id": "3", "name": "Abraham", "amount": [74.56, 10], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
578 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
579 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": [125.45, 10], "last_name": ["Test", "\"ExtraLastName_>=\""]}
580 {"_id": "6", "name": [null, "\"ExtraName_>\""]}
581 {"_id": "7"}
582 0 rows affected
583 RUN delete from maincoll where _id in (6,7)
584
585 2 rows affected
586 Update with order clause update last _id in desc order (_id = 5)
587 send Mysqlx.Crud.Update {
588 collection {
589 name: "maincoll"
590 schema: "mysqlxcoll"
591 }
592 data_model: DOCUMENT
593 criteria {
594 type: OPERATOR
595 operator {
596 name: "!="
597 param {
598 type: IDENT
599 identifier {
600 name: "_id"
601 }
602 }
603 param {
604 type: LITERAL
605 literal {
606 type: V_OCTETS
607 v_octets {
608 value: "0"
609 }
610 }
611 }
612 }
613 }
614 limit {
615 row_count: 1
616 }
617 order {
618 expr {
619 type: IDENT
620 identifier {
621 name: "_id"
622 }
623 }
624 direction: DESC
625 }
626 operation {
627 source {
628 document_path {
629 type: MEMBER
630 value: "amount"
631 }
632 }
633 operation: ARRAY_APPEND
634 value {
635 type: LITERAL
636 literal {
637 type: V_DOUBLE
638 v_double: 1234.56
639 }
640 }
641 }
642 }
643
644
645 1 rows affected
646 Rows matched: 1 Changed: 1 Warnings: 0
647 RUN select doc from maincoll
648 doc
649 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": 4.99, "last_name": ["Otero", "\"ExtraLastName_<=\""]}
650 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
651 {"_id": "3", "name": "Abraham", "amount": [74.56, 10], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
652 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
653 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
654 0 rows affected
655 Update with order clause update first two _id in asc order (_id = 1,2)
656 send Mysqlx.Crud.Update {
657 collection {
658 name: "maincoll"
659 schema: "mysqlxcoll"
660 }
661 data_model: DOCUMENT
662 criteria {
663 type: OPERATOR
664 operator {
665 name: "!="
666 param {
667 type: IDENT
668 identifier {
669 name: "_id"
670 }
671 }
672 param {
673 type: LITERAL
674 literal {
675 type: V_OCTETS
676 v_octets {
677 value: "0"
678 }
679 }
680 }
681 }
682 }
683 limit {
684 row_count: 2
685 }
686 order {
687 expr {
688 type: IDENT
689 identifier {
690 name: "_id"
691 }
692 }
693 direction: ASC
694 }
695 operation {
696 source {
697 document_path {
698 type: MEMBER
699 value: "amount"
700 }
701 }
702 operation: ARRAY_APPEND
703 value {
704 type: LITERAL
705 literal {
706 type: V_DOUBLE
707 v_double: 9876.543
708 }
709 }
710 }
711 }
712
713
714 2 rows affected
715 Rows matched: 2 Changed: 2 Warnings: 0
716 RUN select doc from maincoll
717 doc
718 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": [4.99, 9876.543], "last_name": ["Otero", "\"ExtraLastName_<=\""]}
719 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10, 9876.543], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
720 {"_id": "3", "name": "Abraham", "amount": [74.56, 10], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
721 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
722 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
723 0 rows affected
724 Update append a String into a only numbers member
725 send Mysqlx.Crud.Update {
726 collection {
727 name: "maincoll"
728 schema: "mysqlxcoll"
729 }
730 data_model: DOCUMENT
731 criteria {
732 type: OPERATOR
733 operator {
734 name: "=="
735 param {
736 type: IDENT
737 identifier {
738 name: "_id"
739 }
740 }
741 param {
742 type: LITERAL
743 literal {
744 type: V_OCTETS
745 v_octets {
746 value: "3"
747 }
748 }
749 }
750 }
751 }
752 operation {
753 source {
754 document_path {
755 type: MEMBER
756 value: "amount"
757 }
758 }
759 operation: ARRAY_APPEND
760 value {
761 type: LITERAL
762 literal {
763 type: V_STRING
764 v_string {
765 value: "\"notanumber\""
766 }
767 }
768 }
769 }
770 }
771
772
773 1 rows affected
774 Rows matched: 1 Changed: 1 Warnings: 0
775 RUN select doc from maincoll
776 doc
777 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": [4.99, 9876.543], "last_name": ["Otero", "\"ExtraLastName_<=\""]}
778 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10, 9876.543], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
779 {"_id": "3", "name": "Abraham", "amount": [74.56, 10, "\"notanumber\""], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
780 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
781 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\""], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
782 0 rows affected
783 Update append a number into a only String member
784 send Mysqlx.Crud.Update {
785 collection {
786 name: "maincoll"
787 schema: "mysqlxcoll"
788 }
789 data_model: DOCUMENT
790 criteria {
791 type: OPERATOR
792 operator {
793 name: "=="
794 param {
795 type: IDENT
796 identifier {
797 name: "_id"
798 }
799 }
800 param {
801 type: LITERAL
802 literal {
803 type: V_OCTETS
804 v_octets {
805 value: "5"
806 }
807 }
808 }
809 }
810 }
811 operation {
812 source {
813 document_path {
814 type: MEMBER
815 value: "name"
816 }
817 }
818 operation: ARRAY_APPEND
819 value {
820 type: LITERAL
821 literal {
822 type: V_UINT
823 v_unsigned_int: 536
824 }
825 }
826 }
827 }
828
829
830 1 rows affected
831 Rows matched: 1 Changed: 1 Warnings: 0
832 RUN select doc from maincoll
833 doc
834 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": [4.99, 9876.543], "last_name": ["Otero", "\"ExtraLastName_<=\""]}
835 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10, 9876.543], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
836 {"_id": "3", "name": "Abraham", "amount": [74.56, 10, "\"notanumber\""], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
837 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
838 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\"", 536], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
839 0 rows affected
840 RUN START TRANSACTION
841
842 0 rows affected
843 Update transaction rollback
844 send Mysqlx.Crud.Update {
845 collection {
846 name: "maincoll"
847 schema: "mysqlxcoll"
848 }
849 data_model: DOCUMENT
850 criteria {
851 type: OPERATOR
852 operator {
853 name: "=="
854 param {
855 type: IDENT
856 identifier {
857 name: "_id"
858 }
859 }
860 param {
861 type: LITERAL
862 literal {
863 type: V_OCTETS
864 v_octets {
865 value: "5"
866 }
867 }
868 }
869 }
870 }
871 operation {
872 source {
873 document_path {
874 type: MEMBER
875 value: "name"
876 }
877 }
878 operation: ARRAY_APPEND
879 value {
880 type: LITERAL
881 literal {
882 type: V_STRING
883 v_string {
884 value: "\"Iam_rollback\""
885 }
886 }
887 }
888 }
889 }
890
891
892 1 rows affected
893 Rows matched: 1 Changed: 1 Warnings: 0
894 RUN select doc from maincoll
895 doc
896 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": [4.99, 9876.543], "last_name": ["Otero", "\"ExtraLastName_<=\""]}
897 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10, 9876.543], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
898 {"_id": "3", "name": "Abraham", "amount": [74.56, 10, "\"notanumber\""], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
899 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
900 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\"", 536, "\"Iam_rollback\""], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
901 0 rows affected
902 RUN ROLLBACK
903
904 0 rows affected
905 RUN select doc from maincoll
906 doc
907 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": [4.99, 9876.543], "last_name": ["Otero", "\"ExtraLastName_<=\""]}
908 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10, 9876.543], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
909 {"_id": "3", "name": "Abraham", "amount": [74.56, 10, "\"notanumber\""], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
910 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
911 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\"", 536], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
912 0 rows affected
913 Update transaction commit
914 send Mysqlx.Crud.Update {
915 collection {
916 name: "maincoll"
917 schema: "mysqlxcoll"
918 }
919 data_model: DOCUMENT
920 criteria {
921 type: OPERATOR
922 operator {
923 name: "=="
924 param {
925 type: IDENT
926 identifier {
927 name: "_id"
928 }
929 }
930 param {
931 type: LITERAL
932 literal {
933 type: V_OCTETS
934 v_octets {
935 value: "5"
936 }
937 }
938 }
939 }
940 }
941 operation {
942 source {
943 document_path {
944 type: MEMBER
945 value: "name"
946 }
947 }
948 operation: ARRAY_APPEND
949 value {
950 type: LITERAL
951 literal {
952 type: V_STRING
953 v_string {
954 value: "\"Iam_rollback\""
955 }
956 }
957 }
958 }
959 }
960
961
962 1 rows affected
963 Rows matched: 1 Changed: 1 Warnings: 0
964 RUN COMMIT
965
966 0 rows affected
967 RUN select doc from maincoll
968 doc
969 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": [4.99, 9876.543], "last_name": ["Otero", "\"ExtraLastName_<=\""]}
970 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10, 9876.543], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
971 {"_id": "3", "name": "Abraham", "amount": [74.56, 10, "\"notanumber\""], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
972 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
973 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\"", 536, "\"Iam_rollback\""], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
974 0 rows affected
975 Update with non existing doc member
976 send Mysqlx.Crud.Update {
977 collection {
978 name: "maincoll"
979 schema: "mysqlxcoll"
980 }
981 data_model: DOCUMENT
982 criteria {
983 type: OPERATOR
984 operator {
985 name: "!="
986 param {
987 type: IDENT
988 identifier {
989 name: "_id"
990 }
991 }
992 param {
993 type: LITERAL
994 literal {
995 type: V_OCTETS
996 v_octets {
997 value: "1"
998 }
999 }
1000 }
1001 }
1002 }
1003 operation {
1004 source {
1005 document_path {
1006 type: MEMBER
1007 value: "notadocmember"
1008 }
1009 }
1010 operation: ARRAY_APPEND
1011 value {
1012 type: LITERAL
1013 literal {
1014 type: V_UINT
1015 v_unsigned_int: 10
1016 }
1017 }
1018 }
1019 }
1020
1021
1022 0 rows affected
1023 Rows matched: 4 Changed: 0 Warnings: 0
1024 RUN select doc from maincoll
1025 doc
1026 {"_id": "1", "name": ["Victor", "\"VictorArrayAppend\"", "\"ExtraName_<\""], "amount": [4.99, 9876.543], "last_name": ["Otero", "\"ExtraLastName_<=\""]}
1027 {"_id": "2", "name": ["Gonzalo", "\"ExtraName_<\""], "amount": [120.57, 10, 9876.543], "last_name": ["Chrystens", "\"ExtraLastName_<=\""]}
1028 {"_id": "3", "name": "Abraham", "amount": [74.56, 10, "\"notanumber\""], "last_name": ["Vega", "\"ExtraLastName_<=\""]}
1029 {"_id": "4", "name": ["Jennifer", "\"ExtraName_>\""], "amount": [387.14, 10, 156.59874665, 78445.5, null], "last_name": ["Leon", "\"ExtraLastName_>=\""]}
1030 {"_id": "5", "name": ["Jhonny", "\"ExtraName_>\"", 536, "\"Iam_rollback\""], "amount": [125.45, 10, 1234.56], "last_name": ["Test", "\"ExtraLastName_>=\""]}
1031 0 rows affected
1032 Invalid type of update for Document
1033 send Mysqlx.Crud.Update {
1034 collection {
1035 name: "maincoll"
1036 schema: "mysqlxcoll"
1037 }
1038 data_model: DOCUMENT
1039 criteria {
1040 type: OPERATOR
1041 operator {
1042 name: "!="
1043 param {
1044 type: IDENT
1045 identifier {
1046 name: "_id"
1047 }
1048 }
1049 param {
1050 type: LITERAL
1051 literal {
1052 type: V_OCTETS
1053 v_octets {
1054 value: "1"
1055 }
1056 }
1057 }
1058 }
1059 }
1060 operation {
1061 source {
1062 document_path {
1063 type: MEMBER
1064 value: "notadocmember"
1065 }
1066 }
1067 operation: SET
1068 value {
1069 type: LITERAL
1070 literal {
1071 type: V_UINT
1072 v_unsigned_int: 10
1073 }
1074 }
1075 }
1076 }
1077
1078 Got expected error: Invalid type of update operation for document (code 5051)
1079 ================================================================================
1080 CLEAN UP
1081 ================================================================================
1082 RUN DROP USER updateitemremove@localhost
1083
1084 0 rows affected
1085 RUN SET SQL_SAFE_UPDATES = 1
1086
1087 0 rows affected
1088 Mysqlx.Ok {
1089 msg: "bye!"
1090 }
1091 ok
1092 DROP SCHEMA if EXISTS mysqlxcoll;