Debian Codegraph @

mysql-test/suite/service_sys_var_registration/r/sys_var_service_3_comp.result

raw
1 call mtr.add_suppression("duplicate variable name");
2 call mtr.add_suppression("variable name.*not found");
3 INSTALL COMPONENT "file://component_test_sys_var_service";
4 INSTALL COMPONENT "file://component_test_sys_var_service_int";
5 INSTALL COMPONENT "file://component_test_sys_var_service_str";
6 # file://component_test_sys_var_service:
7 SELECT @@test_component.enum_sys_var;
8 @@test_component.enum_sys_var
9 MEDIUM
10 SET GLOBAL test_component.enum_sys_var="LOW";
11 SELECT @@test_component.enum_sys_var;
12 @@test_component.enum_sys_var
13 LOW
14 SELECT @@test_component.str_sys_var;
15 @@test_component.str_sys_var
16 NULL
17 SET GLOBAL test_component.str_sys_var="dictionary.txt";
18 SELECT @@test_component.str_sys_var;
19 @@test_component.str_sys_var
20 dictionary.txt
21 SET GLOBAL test_component.str_sys_var=default;
22 SELECT @@test_component.str_sys_var;
23 @@test_component.str_sys_var
24 NULL
25 # file://component_test_sys_var_service_str:
26 SELECT @@test_component_str.str_sys_var;
27 @@test_component_str.str_sys_var
28 NULL
29 SET GLOBAL test_component_str.str_sys_var="dictionary.txt";
30 SELECT @@test_component_str.str_sys_var;
31 @@test_component_str.str_sys_var
32 dictionary.txt
33 SET GLOBAL test_component_str.str_sys_var=default;
34 SELECT @@test_component_str.str_sys_var;
35 @@test_component_str.str_sys_var
36 NULL
37 # file://component_test_sys_var_service:
38 SELECT @@test_component.uint_sys_var;
39 @@test_component.uint_sys_var
40 1024
41 SET GLOBAL test_component.uint_sys_var=12345678;
42 Warnings:
43 Warning 1292 Truncated incorrect test_component.uint_sys_var value: '12345678'
44 SELECT @@test_component.uint_sys_var;
45 @@test_component.uint_sys_var
46 10241024
47 SET GLOBAL test_component.uint_sys_var=default;
48 SELECT @@test_component.uint_sys_var;
49 @@test_component.uint_sys_var
50 1024
51 # Testing long type variable
52 SELECT @@test_component.long_sys_var;
53 @@test_component.long_sys_var
54 100
55 SET GLOBAL test_component.long_sys_var=1234567890;
56 Warnings:
57 Warning 1292 Truncated incorrect test_component.long_sys_var value: '1234567890'
58 SELECT @@test_component.long_sys_var;
59 @@test_component.long_sys_var
60 100
61 SET GLOBAL test_component.long_sys_var=default;
62 SELECT @@test_component.long_sys_var;
63 @@test_component.long_sys_var
64 100
65 # Testing unsigned long type variable
66 SELECT @@test_component.ulong_sys_var;
67 @@test_component.ulong_sys_var
68 8192
69 SET GLOBAL test_component.ulong_sys_var=1234567890;
70 Warnings:
71 Warning 1292 Truncated incorrect test_component.ulong_sys_var value: '1234567890'
72 SELECT @@test_component.ulong_sys_var;
73 @@test_component.ulong_sys_var
74 81928192
75 SET GLOBAL test_component.ulong_sys_var=default;
76 SELECT @@test_component.ulong_sys_var;
77 @@test_component.ulong_sys_var
78 8192
79 # Testing long long type variable
80 SELECT @@test_component.longlong_sys_var;
81 @@test_component.longlong_sys_var
82 8192
83 SET GLOBAL test_component.longlong_sys_var=1234567890;
84 SELECT @@test_component.longlong_sys_var;
85 @@test_component.longlong_sys_var
86 1234567890
87 SET GLOBAL test_component.longlong_sys_var=default;
88 SELECT @@test_component.longlong_sys_var;
89 @@test_component.longlong_sys_var
90 8192
91 # file://component_test_sys_var_service_int:
92 SELECT @@test_component_int.uint_sys_var;
93 @@test_component_int.uint_sys_var
94 1024
95 SET GLOBAL test_component_int.uint_sys_var=12345678;
96 Warnings:
97 Warning 1292 Truncated incorrect test_component_int.uint_sys_var value: '12345678'
98 SELECT @@test_component_int.uint_sys_var;
99 @@test_component_int.uint_sys_var
100 10241024
101 SET GLOBAL test_component_int.uint_sys_var=default;
102 SELECT @@test_component_int.uint_sys_var;
103 @@test_component_int.uint_sys_var
104 1024
105 SELECT @@test_component_int.int_sys_var;
106 @@test_component_int.int_sys_var
107 8
108 SET GLOBAL test_component_int.int_sys_var=12345678;
109 Warnings:
110 Warning 1292 Truncated incorrect test_component_int.int_sys_var value: '12345678'
111 SELECT @@test_component_int.int_sys_var;
112 @@test_component_int.int_sys_var
113 1024
114 SET GLOBAL test_component_int.int_sys_var=default;
115 SELECT @@test_component_int.int_sys_var;
116 @@test_component_int.int_sys_var
117 8
118 # file://component_test_sys_var_service_str:
119 SELECT @@test_component_str.str_sys_var;
120 @@test_component_str.str_sys_var
121 NULL
122 SET GLOBAL test_component_str.str_sys_var="dictionary.txt";
123 SELECT @@test_component_str.str_sys_var;
124 @@test_component_str.str_sys_var
125 dictionary.txt
126 UNINSTALL COMPONENT "file://component_test_sys_var_service";
127 UNINSTALL COMPONENT "file://component_test_sys_var_service_int";
128 UNINSTALL COMPONENT "file://component_test_sys_var_service_str";
129 ########## test_component_sys_var_service.log:
130 test_component_sys_var init:
131 int register_variable failed.
132 variable value : 8
133 variable value : 1024
134 variable value : 100
135 variable value : 8192
136 variable value : 8192
137 variable value : 8192
138 variable value : ON
139 variable value : MEDIUM
140 variable value :
141 test_component_sys_var end of init:
142 test_component_sys_var deinit:
143 test_component_sys_var end of deinit:
144 test_component_sys_var_int init:
145 test_component_sys_var_int end of init:
146 test_component_sys_var_int deinit:
147 variable value : 8
148 variable value : 1024
149 variable value : 1024
150 get_variable failed.
151 test_component_sys_var_int end of deinit:
152 test_component_sys_var_str init:
153 character_set_server=[utf8mb4]
154 get_variable mysql_server.character_set_server failed. The variable requires buffer 8 bytes long.
155 character_set_server=[utf8mb4]
156 get_variable mysql_server.datadir success.
157 test_component_sys_var_str end of init:
158 test_component_sys_var_str deinit:
159 variable value : dictionary.txt
160 test_component_sys_var_str end of deinit: