Debian Codegraph @

mysql-test/suite/group_replication/r/gr_crud_basic.result

raw
1 include/group_replication.inc [rpl_server_count=3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 [connection server1]
7 [connection server2]
8 [connection server3]
9 Starting GR on server 1
10 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-cccc-aaaa-aaaa-aaaaaaaaaaaa'
11
12 0 rows affected
13 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=1
14
15 0 rows affected
16 RUN START GROUP_REPLICATION
17
18 0 rows affected
19 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=0
20
21 0 rows affected
22 Mysqlx.Ok {
23 msg: "bye!"
24 }
25 ok
26 Starting GR on server 2
27 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-cccc-aaaa-aaaa-aaaaaaaaaaaa'
28
29 0 rows affected
30 RUN CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery'
31
32 0 rows affected
33 RUN START GROUP_REPLICATION
34
35 0 rows affected
36 Mysqlx.Ok {
37 msg: "bye!"
38 }
39 ok
40 Starting GR on server 3
41 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-cccc-aaaa-aaaa-aaaaaaaaaaaa'
42
43 0 rows affected
44 RUN CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery'
45
46 0 rows affected
47 RUN START GROUP_REPLICATION
48
49 0 rows affected
50 Mysqlx.Ok {
51 msg: "bye!"
52 }
53 ok
54 Waiting for GR members to come online.
55 Performing DDL/DML operations on server 1
56 RUN USE test
57
58 0 rows affected
59 RUN CREATE TABLE T1 (C1 INT PRIMARY KEY, C2 INT );
60
61 0 rows affected
62 send Mysqlx.Crud.Insert {
63 collection {
64 name: "T1"
65 schema: "test"
66 }
67 data_model: TABLE
68 projection {
69 name: "C1"
70 }
71 projection {
72 name: "C2"
73 }
74 row {
75 field {
76 type: LITERAL
77 literal {
78 type: V_SINT
79 v_signed_int: 1
80 }
81 }
82 field {
83 type: LITERAL
84 literal {
85 type: V_SINT
86 v_signed_int: 12
87 }
88 }
89 }
90 }
91
92
93 1 rows affected
94 send Mysqlx.Crud.Insert {
95 collection {
96 name: "T1"
97 schema: "test"
98 }
99 data_model: TABLE
100 projection {
101 name: "C1"
102 }
103 projection {
104 name: "C2"
105 }
106 row {
107 field {
108 type: LITERAL
109 literal {
110 type: V_SINT
111 v_signed_int: 2
112 }
113 }
114 field {
115 type: LITERAL
116 literal {
117 type: V_SINT
118 v_signed_int: 1234
119 }
120 }
121 }
122 }
123
124
125 1 rows affected
126 send Mysqlx.Crud.Insert {
127 collection {
128 name: "T1"
129 schema: "test"
130 }
131 data_model: TABLE
132 projection {
133 name: "C1"
134 }
135 projection {
136 name: "C2"
137 }
138 row {
139 field {
140 type: LITERAL
141 literal {
142 type: V_SINT
143 v_signed_int: 3
144 }
145 }
146 field {
147 type: LITERAL
148 literal {
149 type: V_SINT
150 v_signed_int: 98765
151 }
152 }
153 }
154 }
155
156
157 1 rows affected
158 send Mysqlx.Crud.Update {
159 collection {
160 name: "T1"
161 schema: "test"
162 }
163 data_model: TABLE
164 operation {
165 source {
166 name: "c1"
167 }
168 operation: SET
169 value {
170 type: OPERATOR
171 operator {
172 name: "+"
173 param {
174 type: IDENT
175 identifier {
176 name: "c1"
177 }
178 }
179 param {
180 type: LITERAL
181 literal {
182 type: V_UINT
183 v_unsigned_int: 10
184 }
185 }
186 }
187 }
188 }
189 }
190
191
192 3 rows affected
193 Rows matched: 3 Changed: 3 Warnings: 0
194 send Mysqlx.Crud.Delete {
195 collection {
196 name: "T1"
197 schema: "test"
198 }
199 data_model: TABLE
200 criteria {
201 type: OPERATOR
202 operator {
203 name: "=="
204 param {
205 type: IDENT
206 identifier {
207 name: "C2"
208 }
209 }
210 param {
211 type: LITERAL
212 literal {
213 type: V_UINT
214 v_unsigned_int: 0
215 }
216 }
217 }
218 }
219 }
220
221
222 0 rows affected
223 Mysqlx.Ok {
224 msg: "bye!"
225 }
226 ok
227 include/rpl_sync.inc
228 Performing DDL/DML operations on server 2
229 RUN USE test
230
231 0 rows affected
232 RUN CREATE TABLE T2 (C1 CHAR(20) PRIMARY KEY, C2 INT );
233
234 0 rows affected
235 send Mysqlx.Crud.Insert {
236 collection {
237 name: "T2"
238 schema: "test"
239 }
240 data_model: TABLE
241 projection {
242 name: "C1"
243 }
244 projection {
245 name: "C2"
246 }
247 row {
248 field {
249 type: LITERAL
250 literal {
251 type: V_STRING
252 v_string {
253 value: "ABC"
254 }
255 }
256 }
257 field {
258 type: LITERAL
259 literal {
260 type: V_SINT
261 v_signed_int: 23
262 }
263 }
264 }
265 }
266
267
268 1 rows affected
269 send Mysqlx.Crud.Update {
270 collection {
271 name: "T2"
272 schema: "test"
273 }
274 data_model: TABLE
275 operation {
276 source {
277 name: "C2"
278 }
279 operation: SET
280 value {
281 type: OPERATOR
282 operator {
283 name: "+"
284 param {
285 type: IDENT
286 identifier {
287 name: "C2"
288 }
289 }
290 param {
291 type: LITERAL
292 literal {
293 type: V_UINT
294 v_unsigned_int: 27
295 }
296 }
297 }
298 }
299 }
300 }
301
302
303 1 rows affected
304 Rows matched: 1 Changed: 1 Warnings: 0
305 send Mysqlx.Crud.Insert {
306 collection {
307 name: "T1"
308 schema: "test"
309 }
310 data_model: TABLE
311 projection {
312 name: "C1"
313 }
314 projection {
315 name: "C2"
316 }
317 row {
318 field {
319 type: LITERAL
320 literal {
321 type: V_SINT
322 v_signed_int: 4
323 }
324 }
325 field {
326 type: LITERAL
327 literal {
328 type: V_SINT
329 v_signed_int: 34
330 }
331 }
332 }
333 }
334
335
336 1 rows affected
337 send Mysqlx.Crud.Insert {
338 collection {
339 name: "T2"
340 schema: "test"
341 }
342 data_model: TABLE
343 projection {
344 name: "C1"
345 }
346 projection {
347 name: "C2"
348 }
349 row {
350 field {
351 type: LITERAL
352 literal {
353 type: V_STRING
354 v_string {
355 value: "ABCDEF"
356 }
357 }
358 }
359 field {
360 type: LITERAL
361 literal {
362 type: V_SINT
363 v_signed_int: 23
364 }
365 }
366 }
367 }
368
369
370 1 rows affected
371 send Mysqlx.Crud.Insert {
372 collection {
373 name: "T1"
374 schema: "test"
375 }
376 data_model: TABLE
377 projection {
378 name: "C1"
379 }
380 projection {
381 name: "C2"
382 }
383 row {
384 field {
385 type: LITERAL
386 literal {
387 type: V_SINT
388 v_signed_int: 5
389 }
390 }
391 field {
392 type: LITERAL
393 literal {
394 type: V_SINT
395 v_signed_int: 1234
396 }
397 }
398 }
399 }
400
401
402 1 rows affected
403 send Mysqlx.Crud.Insert {
404 collection {
405 name: "T2"
406 schema: "test"
407 }
408 data_model: TABLE
409 projection {
410 name: "C1"
411 }
412 projection {
413 name: "C2"
414 }
415 row {
416 field {
417 type: LITERAL
418 literal {
419 type: V_STRING
420 v_string {
421 value: "ABCDEFGHIJ"
422 }
423 }
424 }
425 field {
426 type: LITERAL
427 literal {
428 type: V_SINT
429 v_signed_int: 23
430 }
431 }
432 }
433 }
434
435
436 1 rows affected
437 send Mysqlx.Crud.Delete {
438 collection {
439 name: "T2"
440 schema: "test"
441 }
442 data_model: TABLE
443 criteria {
444 type: OPERATOR
445 operator {
446 name: "=="
447 param {
448 type: IDENT
449 identifier {
450 name: "C1"
451 }
452 }
453 param {
454 type: LITERAL
455 literal {
456 type: V_OCTETS
457 v_octets {
458 value: "ABC"
459 }
460 }
461 }
462 }
463 }
464 }
465
466
467 1 rows affected
468 Mysqlx.Ok {
469 msg: "bye!"
470 }
471 ok
472 include/rpl_sync.inc
473 Performing DDL/DML operations on server 3
474 RUN USE test;
475
476 0 rows affected
477 RUN CREATE TABLE T3 (C1 INT PRIMARY KEY, C2 VARCHAR(20) );
478
479 0 rows affected
480 send Mysqlx.Crud.Delete {
481 collection {
482 name: "T1"
483 schema: "test"
484 }
485 data_model: TABLE
486 }
487
488
489 5 rows affected
490 send Mysqlx.Crud.Insert {
491 collection {
492 name: "T1"
493 schema: "test"
494 }
495 data_model: TABLE
496 projection {
497 name: "C1"
498 }
499 projection {
500 name: "C2"
501 }
502 row {
503 field {
504 type: LITERAL
505 literal {
506 type: V_SINT
507 v_signed_int: 1
508 }
509 }
510 field {
511 type: LITERAL
512 literal {
513 type: V_SINT
514 v_signed_int: 12345
515 }
516 }
517 }
518 }
519
520
521 1 rows affected
522 send Mysqlx.Crud.Insert {
523 collection {
524 name: "T3"
525 schema: "test"
526 }
527 data_model: TABLE
528 projection {
529 name: "C1"
530 }
531 projection {
532 name: "C2"
533 }
534 row {
535 field {
536 type: LITERAL
537 literal {
538 type: V_SINT
539 v_signed_int: 1
540 }
541 }
542 field {
543 type: LITERAL
544 literal {
545 type: V_STRING
546 v_string {
547 value: "1"
548 }
549 }
550 }
551 }
552 }
553
554
555 1 rows affected
556 send Mysqlx.Crud.Insert {
557 collection {
558 name: "T2"
559 schema: "test"
560 }
561 data_model: TABLE
562 projection {
563 name: "C1"
564 }
565 projection {
566 name: "C2"
567 }
568 row {
569 field {
570 type: LITERAL
571 literal {
572 type: V_STRING
573 v_string {
574 value: "1234"
575 }
576 }
577 }
578 field {
579 type: LITERAL
580 literal {
581 type: V_SINT
582 v_signed_int: 1234
583 }
584 }
585 }
586 }
587
588
589 1 rows affected
590 send Mysqlx.Crud.Insert {
591 collection {
592 name: "T1"
593 schema: "test"
594 }
595 data_model: TABLE
596 projection {
597 name: "C1"
598 }
599 projection {
600 name: "C2"
601 }
602 row {
603 field {
604 type: LITERAL
605 literal {
606 type: V_SINT
607 v_signed_int: 7
608 }
609 }
610 field {
611 type: LITERAL
612 literal {
613 type: V_SINT
614 v_signed_int: 98765
615 }
616 }
617 }
618 }
619
620
621 1 rows affected
622 send Mysqlx.Crud.Insert {
623 collection {
624 name: "T2"
625 schema: "test"
626 }
627 data_model: TABLE
628 projection {
629 name: "C1"
630 }
631 projection {
632 name: "C2"
633 }
634 row {
635 field {
636 type: LITERAL
637 literal {
638 type: V_STRING
639 v_string {
640 value: "XYZ"
641 }
642 }
643 }
644 field {
645 type: LITERAL
646 literal {
647 type: V_SINT
648 v_signed_int: 23
649 }
650 }
651 }
652 }
653
654
655 1 rows affected
656 send Mysqlx.Crud.Update {
657 collection {
658 name: "T2"
659 schema: "test"
660 }
661 data_model: TABLE
662 criteria {
663 type: OPERATOR
664 operator {
665 name: "=="
666 param {
667 type: IDENT
668 identifier {
669 name: "C1"
670 }
671 }
672 param {
673 type: LITERAL
674 literal {
675 type: V_OCTETS
676 v_octets {
677 value: "XYZ"
678 }
679 }
680 }
681 }
682 }
683 operation {
684 source {
685 name: "C1"
686 }
687 operation: SET
688 value {
689 type: LITERAL
690 literal {
691 type: V_STRING
692 v_string {
693 value: "ABC"
694 }
695 }
696 }
697 }
698 }
699
700
701 1 rows affected
702 Rows matched: 1 Changed: 1 Warnings: 0
703 send Mysqlx.Crud.Insert {
704 collection {
705 name: "T3"
706 schema: "test"
707 }
708 data_model: TABLE
709 projection {
710 name: "C1"
711 }
712 projection {
713 name: "C2"
714 }
715 row {
716 field {
717 type: LITERAL
718 literal {
719 type: V_SINT
720 v_signed_int: 2
721 }
722 }
723 field {
724 type: LITERAL
725 literal {
726 type: V_STRING
727 v_string {
728 value: "2"
729 }
730 }
731 }
732 }
733 }
734
735
736 1 rows affected
737 send Mysqlx.Crud.Insert {
738 collection {
739 name: "T3"
740 schema: "test"
741 }
742 data_model: TABLE
743 projection {
744 name: "C1"
745 }
746 projection {
747 name: "C2"
748 }
749 row {
750 field {
751 type: LITERAL
752 literal {
753 type: V_SINT
754 v_signed_int: 3
755 }
756 }
757 field {
758 type: LITERAL
759 literal {
760 type: V_STRING
761 v_string {
762 value: "3"
763 }
764 }
765 }
766 }
767 }
768
769
770 1 rows affected
771 send Mysqlx.Crud.Delete {
772 collection {
773 name: "T3"
774 schema: "test"
775 }
776 data_model: TABLE
777 criteria {
778 type: OPERATOR
779 operator {
780 name: ">"
781 param {
782 type: IDENT
783 identifier {
784 name: "C1"
785 }
786 }
787 param {
788 type: LITERAL
789 literal {
790 type: V_UINT
791 v_unsigned_int: 0
792 }
793 }
794 }
795 }
796 }
797
798
799 3 rows affected
800 Mysqlx.Ok {
801 msg: "bye!"
802 }
803 ok
804 include/rpl_sync.inc
805 [connection server2]
806 include/assert.inc ['Checking the Value on T1']
807 include/assert.inc ['Checking the Value on T2']
808 Deleting all the tables.
809 RUN USE test;
810
811 0 rows affected
812 RUN DROP TABLE T1;
813
814 0 rows affected
815 RUN DROP TABLE T2;
816
817 0 rows affected
818 RUN DROP TABLE T3;
819
820 0 rows affected
821 Mysqlx.Ok {
822 msg: "bye!"
823 }
824 ok
825 include/rpl_sync.inc
826 Stopping GR on server 1
827 RUN STOP GROUP_REPLICATION;
828
829 0 rows affected
830 Mysqlx.Ok {
831 msg: "bye!"
832 }
833 ok
834 Stopping GR on server 2
835 RUN STOP GROUP_REPLICATION;
836
837 0 rows affected
838 Mysqlx.Ok {
839 msg: "bye!"
840 }
841 ok
842 Stopping GR on server 3
843 RUN STOP GROUP_REPLICATION;
844
845 0 rows affected
846 Mysqlx.Ok {
847 msg: "bye!"
848 }
849 ok
850 [connection server1]
851 include/stop_group_replication.inc
852 [connection server2]
853 include/stop_group_replication.inc
854 [connection server3]
855 include/stop_group_replication.inc
856 include/group_replication_end.inc