Debian Codegraph @

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

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