Debian Codegraph @

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

raw
1 # System Variables Testing
2 SET GLOBAL mysqlx_idle_worker_thread_timeout=7;
3 SET @@global.mysqlx_idle_worker_thread_timeout=7;
4 show variables like 'mysqlx_idle_worker_thread_timeout';
5 Variable_name Value
6 mysqlx_idle_worker_thread_timeout 7
7 SET @@global.mysqlx_idle_worker_thread_timeout=3600;
8 show variables like 'mysqlx_idle_worker_thread_timeout';
9 Variable_name Value
10 mysqlx_idle_worker_thread_timeout 3600
11 SET mysqlx_idle_worker_thread_timeout=7;
12 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
13 SET @@local.mysqlx_idle_worker_thread_timeout=7;
14 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
15 SET @@mysqlx_idle_worker_thread_timeout=7;
16 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
17 SET @@session.mysqlx_idle_worker_thread_timeout=7;
18 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
19 SET SESSION mysqlx_idle_worker_thread_timeout=7;
20 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
21 SET @@global.mysqlx_idle_worker_thread_timeout=3601;
22 Warnings:
23 Warning 1292 Truncated incorrect mysqlx_idle_worker_thread_timeout value: '3601'
24 SET GLOBAL mysqlx_idle_worker_thread_timeout=0;
25 SET GLOBAL mysqlx_idle_worker_thread_timeout=-1;
26 Warnings:
27 Warning 1292 Truncated incorrect mysqlx_idle_worker_thread_timeout value: '-1'
28 SET GLOBAL mysqlx_idle_worker_thread_timeout='invaid%char';
29 ERROR 42000: Incorrect argument type to variable 'mysqlx_idle_worker_thread_timeout'
30 show variables like 'mysqlx_idle_worker_thread_timeout';
31 Variable_name Value
32 mysqlx_idle_worker_thread_timeout 0
33 SET GLOBAL mysqlx_idle_worker_thread_timeout=60;
34 SET GLOBAL mysqlx_max_allowed_packet=5000000;
35 SET @@global.mysqlx_max_allowed_packet=7000000;
36 show variables like 'mysqlx_max_allowed_packet';
37 Variable_name Value
38 mysqlx_max_allowed_packet 7000000
39 SET mysqlx_max_allowed_packet=5000000;
40 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
41 SET @@local.mysqlx_max_allowed_packet=5000000;
42 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
43 SET @@mysqlx_max_allowed_packet=5000000;
44 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
45 SET @@session.mysqlx_max_allowed_packet=5000000;
46 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
47 SET SESSION mysqlx_max_allowed_packet=5000000;
48 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
49 SET @@global.mysqlx_max_allowed_packet=0;
50 Warnings:
51 Warning 1292 Truncated incorrect mysqlx_max_allowed_packet value: '0'
52 SET @@global.mysqlx_max_allowed_packet=-123;
53 Warnings:
54 Warning 1292 Truncated incorrect mysqlx_max_allowed_packet value: '-123'
55 SET @@global.mysqlx_max_allowed_packet='crash#$%';
56 ERROR 42000: Incorrect argument type to variable 'mysqlx_max_allowed_packet'
57 show variables like 'mysqlx_max_allowed_packet';
58 Variable_name Value
59 mysqlx_max_allowed_packet 512
60 SET @@global.mysqlx_max_allowed_packet=1048576;
61 SET GLOBAL mysqlx_max_connections=150;
62 show variables like 'mysqlx_max_connections';
63 Variable_name Value
64 mysqlx_max_connections 150
65 SET @@global.mysqlx_max_connections=500;
66 show variables like 'mysqlx_max_connections';
67 Variable_name Value
68 mysqlx_max_connections 500
69 SET mysqlx_max_connections=150;
70 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
71 SET @@local.mysqlx_max_connections=150;
72 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
73 SET @@mysqlx_max_connections=150;
74 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
75 SET @@session.mysqlx_max_connections=150;
76 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
77 SET SESSION mysqlx_max_connections=150;
78 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
79 SET GLOBAL mysqlx_max_connections=0;
80 Warnings:
81 Warning 1292 Truncated incorrect mysqlx_max_connections value: '0'
82 SET GLOBAL mysqlx_max_connections=-848;
83 Warnings:
84 Warning 1292 Truncated incorrect mysqlx_max_connections value: '-848'
85 SET GLOBAL mysqlx_max_connections='%45*#in';
86 ERROR 42000: Incorrect argument type to variable 'mysqlx_max_connections'
87 show variables like 'mysqlx_max_connections';
88 Variable_name Value
89 mysqlx_max_connections 1
90 SET @@global.mysqlx_max_connections=151;
91 SET GLOBAL mysqlx_min_worker_threads=150;
92 Warnings:
93 Warning 1292 Truncated incorrect mysqlx_min_worker_threads value: '150'
94 SET @@global.mysqlx_min_worker_threads=15;
95 show variables like 'mysqlx_min_worker_threads';
96 Variable_name Value
97 mysqlx_min_worker_threads 15
98 SET mysqlx_min_worker_threads=15;
99 ERROR HY000: Variable 'mysqlx_min_worker_threads' is a GLOBAL variable and should be set with SET GLOBAL
100 SET @@local.mysqlx_min_worker_threads=15;
101 ERROR HY000: Variable 'mysqlx_min_worker_threads' is a GLOBAL variable and should be set with SET GLOBAL
102 SET @@mysqlx_min_worker_threads=15;
103 ERROR HY000: Variable 'mysqlx_min_worker_threads' is a GLOBAL variable and should be set with SET GLOBAL
104 SET @@session.mysqlx_min_worker_threads=15;
105 ERROR HY000: Variable 'mysqlx_min_worker_threads' is a GLOBAL variable and should be set with SET GLOBAL
106 SET SESSION mysqlx_min_worker_threads=15;
107 ERROR HY000: Variable 'mysqlx_min_worker_threads' is a GLOBAL variable and should be set with SET GLOBAL
108 SET @@global.mysqlx_min_worker_threads=0;
109 Warnings:
110 Warning 1292 Truncated incorrect mysqlx_min_worker_threads value: '0'
111 SET @@global.mysqlx_min_worker_threads=-4324;
112 Warnings:
113 Warning 1292 Truncated incorrect mysqlx_min_worker_threads value: '-4324'
114 SET GLOBAL mysqlx_min_worker_threads=+23766;
115 Warnings:
116 Warning 1292 Truncated incorrect mysqlx_min_worker_threads value: '23766'
117 SET GLOBAL mysqlx_min_worker_threads='USDSI75u';
118 ERROR 42000: Incorrect argument type to variable 'mysqlx_min_worker_threads'
119 show variables like 'mysqlx_min_worker_threads';
120 Variable_name Value
121 mysqlx_min_worker_threads 100
122 SET GLOBAL mysqlx_min_worker_threads=10;
123 SET GLOBAL mysqlx_connect_timeout=20;
124 SET @@global.mysqlx_connect_timeout=500;
125 show variables like 'mysqlx_connect_timeout';
126 Variable_name Value
127 mysqlx_connect_timeout 500
128 SET mysqlx_connect_timeout=20;
129 ERROR HY000: Variable 'mysqlx_connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
130 SET @@local.mysqlx_connect_timeout=20;
131 ERROR HY000: Variable 'mysqlx_connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
132 SET @@mysqlx_connect_timeout=20;
133 ERROR HY000: Variable 'mysqlx_connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
134 SET @@session.mysqlx_connect_timeout=20;
135 ERROR HY000: Variable 'mysqlx_connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
136 SET SESSION mysqlx_connect_timeout=20;
137 ERROR HY000: Variable 'mysqlx_connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
138 SET GLOBAL mysqlx_connect_timeout=0;
139 Warnings:
140 Warning 1292 Truncated incorrect mysqlx_connect_timeout value: '0'
141 SET GLOBAL mysqlx_connect_timeout=1;
142 SET GLOBAL mysqlx_connect_timeout=-4686234;
143 Warnings:
144 Warning 1292 Truncated incorrect mysqlx_connect_timeout value: '-4686234'
145 SET GLOBAL mysqlx_connect_timeout='gduges7';
146 ERROR 42000: Incorrect argument type to variable 'mysqlx_connect_timeout'
147 show variables like 'mysqlx_connect_timeout';
148 Variable_name Value
149 mysqlx_connect_timeout 1
150 SET GLOBAL mysqlx_connect_timeout=300;
151 SET GLOBAL mysqlx_wait_timeout=20;
152 SET @@global.mysqlx_wait_timeout=500;
153 SET mysqlx_wait_timeout=30;
154 SET @@local.mysqlx_wait_timeout=40;
155 SET @@mysqlx_wait_timeout=50;
156 SET @@session.mysqlx_wait_timeout=60;
157 SET SESSION mysqlx_wait_timeout=70;
158 SET @@global.mysqlx_wait_timeout=2147483;
159 show variables like 'mysqlx_wait_timeout';
160 Variable_name Value
161 mysqlx_wait_timeout 70
162 SET GLOBAL mysqlx_wait_timeout=0;
163 Warnings:
164 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '0'
165 SET GLOBAL mysqlx_wait_timeout=1;
166 SET GLOBAL mysqlx_wait_timeout=-4686234;
167 Warnings:
168 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '-4686234'
169 SET GLOBAL mysqlx_wait_timeout='gduges7';
170 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
171 show variables like 'mysqlx_wait_timeout';
172 Variable_name Value
173 mysqlx_wait_timeout 70
174 SET GLOBAL mysqlx_wait_timeout=28800;
175 SET SESSION mysqlx_wait_timeout=28800;
176 SET GLOBAL mysqlx_interactive_timeout=20;
177 SET @@global.mysqlx_interactive_timeout=500;
178 SET mysqlx_interactive_timeout=30;
179 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
180 SET @@local.mysqlx_interactive_timeout=40;
181 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
182 SET @@mysqlx_interactive_timeout=50;
183 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
184 SET @@session.mysqlx_interactive_timeout=60;
185 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
186 SET SESSION mysqlx_interactive_timeout=70;
187 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
188 SET @@global.mysqlx_interactive_timeout=2147483;
189 show variables like 'mysqlx_interactive_timeout';
190 Variable_name Value
191 mysqlx_interactive_timeout 2147483
192 SET GLOBAL mysqlx_interactive_timeout=0;
193 Warnings:
194 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '0'
195 SET GLOBAL mysqlx_interactive_timeout=1;
196 SET GLOBAL mysqlx_interactive_timeout=-4686234;
197 Warnings:
198 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '-4686234'
199 SET GLOBAL mysqlx_interactive_timeout='gduges7';
200 ERROR 42000: Incorrect argument type to variable 'mysqlx_interactive_timeout'
201 show variables like 'mysqlx_interactive_timeout';
202 Variable_name Value
203 mysqlx_interactive_timeout 1
204 SET GLOBAL mysqlx_interactive_timeout=28800;
205 SET GLOBAL mysqlx_read_timeout=20;
206 SET @@global.mysqlx_read_timeout=500;
207 SET mysqlx_read_timeout=30;
208 SET @@local.mysqlx_read_timeout=40;
209 SET @@mysqlx_read_timeout=50;
210 SET @@session.mysqlx_read_timeout=60;
211 SET SESSION mysqlx_read_timeout=70;
212 SET @@global.mysqlx_read_timeout=2147483;
213 show variables like 'mysqlx_read_timeout';
214 Variable_name Value
215 mysqlx_read_timeout 70
216 SET GLOBAL mysqlx_read_timeout=0;
217 Warnings:
218 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '0'
219 SET GLOBAL mysqlx_read_timeout=1;
220 SET GLOBAL mysqlx_read_timeout=-4686234;
221 Warnings:
222 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '-4686234'
223 SET GLOBAL mysqlx_read_timeout='gduges7';
224 ERROR 42000: Incorrect argument type to variable 'mysqlx_read_timeout'
225 show variables like 'mysqlx_read_timeout';
226 Variable_name Value
227 mysqlx_read_timeout 70
228 SET GLOBAL mysqlx_read_timeout=30;
229 SET SESSION mysqlx_read_timeout=30;
230 SET GLOBAL mysqlx_write_timeout=20;
231 SET @@global.mysqlx_write_timeout=500;
232 SET mysqlx_write_timeout=300;
233 SET @@local.mysqlx_write_timeout=400;
234 SET @@mysqlx_write_timeout=500;
235 SET @@session.mysqlx_write_timeout=600;
236 SET SESSION mysqlx_write_timeout=700;
237 SET @@global.mysqlx_write_timeout=2147483;
238 show variables like 'mysqlx_write_timeout';
239 Variable_name Value
240 mysqlx_write_timeout 700
241 SET GLOBAL mysqlx_write_timeout=0;
242 Warnings:
243 Warning 1292 Truncated incorrect mysqlx_write_timeout value: '0'
244 SET GLOBAL mysqlx_write_timeout=1;
245 SET GLOBAL mysqlx_write_timeout=-4686234;
246 Warnings:
247 Warning 1292 Truncated incorrect mysqlx_write_timeout value: '-4686234'
248 SET GLOBAL mysqlx_write_timeout='gduges7';
249 ERROR 42000: Incorrect argument type to variable 'mysqlx_write_timeout'
250 show variables like 'mysqlx_write_timeout';
251 Variable_name Value
252 mysqlx_write_timeout 700
253 SET GLOBAL mysqlx_write_timeout=60;
254 SET SESSION mysqlx_write_timeout=60;
255 SET GLOBAL mysqlx_port=33060;
256 ERROR HY000: Variable 'mysqlx_port' is a read only variable
257 RUN SET GLOBAL mysqlx_idle_worker_thread_timeout=7
258
259 0 rows affected
260 RUN SET @@global.mysqlx_idle_worker_thread_timeout=7
261
262 0 rows affected
263 RUN SET GLOBAL mysqlx_max_allowed_packet=5000000
264
265 0 rows affected
266 RUN SET @@global.mysqlx_max_allowed_packet=7000000
267
268 0 rows affected
269 RUN SET GLOBAL mysqlx_max_connections=150
270
271 0 rows affected
272 RUN SET @@global.mysqlx_max_connections=500
273
274 0 rows affected
275 RUN SET GLOBAL mysqlx_min_worker_threads=15
276
277 0 rows affected
278 RUN SET @@global.mysqlx_min_worker_threads=15
279
280 0 rows affected
281 RUN SET GLOBAL mysqlx_connect_timeout=20
282
283 0 rows affected
284 RUN SET @@global.mysqlx_connect_timeout=500
285
286 0 rows affected
287 Mysqlx.Ok {
288 msg: "bye!"
289 }
290 ok
291 SET GLOBAL mysqlx_idle_worker_thread_timeout= DEFAULT;
292 SET GLOBAL mysqlx_max_allowed_packet= DEFAULT;
293 SET GLOBAL mysqlx_max_connections= DEFAULT;
294 SET GLOBAL mysqlx_min_worker_threads= DEFAULT;
295 SET GLOBAL mysqlx_connect_timeout= DEFAULT;