Debian Codegraph @

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

raw
1 call mtr.add_suppression("Plugin mysqlx reported: .Error parsing message of type 17:");
2 call mtr.add_suppression("Plugin mysqlx reported: .Setup of socket: '' failed, the socket file path is empty");
3 # restart
4 Bug #21472634
5 RUN show processlist;
6 Id User Host db Command State Info
7 5 event_scheduler localhost null Daemon Waiting on empty queue null
8 $PROC_1_ID root localhost test Sleep null
9 $PROC_2_ID x_root localhost null Query init PLUGIN: show processlist
10 0 rows affected
11 Warnings generated:
12 WARNING | 1287 | 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
13 RUN SELECT id,user,command,state FROM information_schema.processlist ORDER BY id
14 id user command state
15 5 event_scheduler Daemon Waiting on empty queue
16 $PROC_1_ID root Sleep
17 $PROC_2_ID x_root Query executing
18 0 rows affected
19 Mysqlx.Ok {
20 msg: "bye!"
21 }
22 ok
23 Issue MYP-150
24 RUN use test
25
26 0 rows affected
27 RUN create table complexq (age int, name varchar(100))
28
29 0 rows affected
30 RUN insert into complexq values (50, 'blabla')
31
32 1 rows affected
33 send Mysqlx.Crud.Find {
34 collection {
35 name: "complexq"
36 schema: "test"
37 }
38 data_model: TABLE
39 projection {
40 source {
41 type: IDENT
42 identifier {
43 name: "age"
44 }
45 }
46 alias: "age_group"
47 }
48 projection {
49 source {
50 type: FUNC_CALL
51 function_call {
52 name {
53 name: "count"
54 }
55 param {
56 type: IDENT
57 identifier {
58 name: "name"
59 }
60 }
61 }
62 }
63 alias: "cnt"
64 }
65 grouping {
66 type: IDENT
67 identifier {
68 name: "age_group"
69 }
70 }
71 }
72
73 age_group cnt
74 50 1
75 command ok
76 RUN drop table complexq
77
78 0 rows affected
79 Mysqlx.Ok {
80 msg: "bye!"
81 }
82 ok
83 Check whether default db on connect works
84 RUN select schema()
85 schema()
86 test
87 0 rows affected
88 Mysqlx.Ok {
89 msg: "bye!"
90 }
91 ok
92 create user expired@localhost;
93 alter user expired@localhost password expire;
94 Check whether password expired sandbox applies to admin cmds
95 NOTICE: Account password expired
96 Got expected error: You must reset your password using ALTER USER statement before executing this statement. (code 1820)
97 send Mysqlx.Sql.StmtExecute {
98 stmt: "set password=\'a\'"
99 }
100
101
102 0 rows affected
103 client_id user host sql_session
104 N expired localhost N
105 command ok
106 Mysqlx.Ok {
107 msg: "bye!"
108 }
109 ok
110 drop user expired@localhost;
111
112 Bug #21362400 MYSQLXTEST HANG WHEN EXECUTING INSTALL AND UNINSTALL PLUGIN
113 -------------------------------------------------------------------------
114 RUN INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
115 While executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so':
116 Got expected error: Command not supported by pluggable protocols (code 3130)
117 RUN UNINSTALL PLUGIN mysqlx
118 While executing UNINSTALL PLUGIN mysqlx:
119 Got expected error: Command not supported by pluggable protocols (code 3130)
120 RUN INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
121 While executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so':
122 Got expected error: Command not supported by pluggable protocols (code 3130)
123 RUN UNINSTALL PLUGIN mysqlx
124 While executing UNINSTALL PLUGIN mysqlx:
125 Got expected error: Command not supported by pluggable protocols (code 3130)
126 RUN INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
127 While executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so':
128 Got expected error: Command not supported by pluggable protocols (code 3130)
129 Mysqlx.Ok {
130 msg: "bye!"
131 }
132 ok
133
134 Bug Crash when sending an invalid message of type Find, for example
135 -------------------------------------------------------------------
136 connecting...
137 active session is now 'foo'
138 Sending 5 bytes raw data...
139 Got expected error:
140 Mysqlx.Error {
141 severity: FATAL
142 code: 5000
143 msg: "Parse error unserializing protobuf message"
144 sql_state: "HY000"
145 }
146
147 aborting session foo
148 switched to session default
149 connecting...
150 active session is now 'foo'
151 Sending 5 bytes raw data...
152 Got expected error:
153 Mysqlx.Error {
154 severity: FATAL
155 code: 5000
156 msg: "Parse error unserializing protobuf message"
157 sql_state: "HY000"
158 }
159
160 aborting session foo
161 switched to session default
162 connecting...
163 active session is now 'foo'
164 Sending 5 bytes raw data...
165 Got expected error:
166 Mysqlx.Error {
167 severity: FATAL
168 code: 5000
169 msg: "Parse error unserializing protobuf message"
170 sql_state: "HY000"
171 }
172
173 aborting session foo
174 switched to session default
175 connecting...
176 active session is now 'foo'
177 Sending 5 bytes raw data...
178 Got expected error:
179 Mysqlx.Error {
180 severity: FATAL
181 code: 5000
182 msg: "Parse error unserializing protobuf message"
183 sql_state: "HY000"
184 }
185
186 aborting session foo
187 switched to session default
188 connecting...
189 active session is now 'foo'
190 Sending 5 bytes raw data...
191 Got expected error:
192 Mysqlx.Error {
193 severity: FATAL
194 code: 5000
195 msg: "Parse error unserializing protobuf message"
196 sql_state: "HY000"
197 }
198
199 aborting session foo
200 switched to session default
201 connecting...
202 active session is now 'foo'
203 Sending 5 bytes raw data...
204 Got expected error:
205 Mysqlx.Error {
206 severity: FATAL
207 code: 5000
208 msg: "Parse error unserializing protobuf message"
209 sql_state: "HY000"
210 }
211
212 aborting session foo
213 switched to session default
214 connecting...
215 active session is now 'foo'
216 Sending 5 bytes raw data...
217 Got expected error:
218 Mysqlx.Error {
219 severity: FATAL
220 code: 5000
221 msg: "Parse error unserializing protobuf message"
222 sql_state: "HY000"
223 }
224
225 aborting session foo
226 switched to session default
227 connecting...
228 active session is now 'foo'
229 Sending 5 bytes raw data...
230 Got expected error:
231 Mysqlx.Error {
232 severity: FATAL
233 code: 5000
234 msg: "Parse error unserializing protobuf message"
235 sql_state: "HY000"
236 }
237
238 aborting session foo
239 switched to session default
240 connecting...
241 active session is now 'foo'
242 Sending 5 bytes raw data...
243 Got expected error:
244 Mysqlx.Error {
245 severity: FATAL
246 code: 5000
247 msg: "Parse error unserializing protobuf message"
248 sql_state: "HY000"
249 }
250
251 aborting session foo
252 switched to session default
253 connecting...
254 active session is now 'foo'
255 Sending 5 bytes raw data...
256 Got expected error:
257 Mysqlx.Error {
258 severity: FATAL
259 code: 5000
260 msg: "Parse error unserializing protobuf message"
261 sql_state: "HY000"
262 }
263
264 aborting session foo
265 switched to session default
266 connecting...
267 active session is now 'foo'
268 Sending 5 bytes raw data...
269 Got expected error:
270 Mysqlx.Error {
271 severity: FATAL
272 code: 5000
273 msg: "Parse error unserializing protobuf message"
274 sql_state: "HY000"
275 }
276
277 aborting session foo
278 switched to session default
279 connecting...
280 active session is now 'foo'
281 Sending 5 bytes raw data...
282 Got expected error:
283 Mysqlx.Error {
284 severity: FATAL
285 code: 5000
286 msg: "Parse error unserializing protobuf message"
287 sql_state: "HY000"
288 }
289
290 aborting session foo
291 switched to session default
292 connecting...
293 active session is now 'foo'
294 Sending 5 bytes raw data...
295 Got expected error:
296 Mysqlx.Error {
297 severity: FATAL
298 code: 5000
299 msg: "Parse error unserializing protobuf message"
300 sql_state: "HY000"
301 }
302
303 aborting session foo
304 switched to session default
305 connecting...
306 active session is now 'foo'
307 Sending 5 bytes raw data...
308 Got expected error:
309 Mysqlx.Error {
310 severity: FATAL
311 code: 5000
312 msg: "Parse error unserializing protobuf message"
313 sql_state: "HY000"
314 }
315
316 aborting session foo
317 switched to session default
318 connecting...
319 active session is now 'foo'
320 Sending 5 bytes raw data...
321 Got expected error:
322 Mysqlx.Error {
323 severity: FATAL
324 code: 5000
325 msg: "Parse error unserializing protobuf message"
326 sql_state: "HY000"
327 }
328
329 aborting session foo
330 switched to session default
331 connecting...
332 active session is now 'foo'
333 Sending 5 bytes raw data...
334 Got expected error:
335 Mysqlx.Error {
336 severity: FATAL
337 code: 5000
338 msg: "Parse error unserializing protobuf message"
339 sql_state: "HY000"
340 }
341
342 aborting session foo
343 switched to session default
344 connecting...
345 active session is now 'foo'
346 Sending 5 bytes raw data...
347 Got expected error:
348 Mysqlx.Error {
349 severity: FATAL
350 code: 5000
351 msg: "Parse error unserializing protobuf message"
352 sql_state: "HY000"
353 }
354
355 aborting session foo
356 switched to session default
357 connecting...
358 active session is now 'foo'
359 Sending 5 bytes raw data...
360 Got expected error:
361 Mysqlx.Error {
362 severity: FATAL
363 code: 5000
364 msg: "Parse error unserializing protobuf message"
365 sql_state: "HY000"
366 }
367
368 aborting session foo
369 switched to session default
370 connecting...
371 active session is now 'foo'
372 Sending 5 bytes raw data...
373 Got expected error:
374 Mysqlx.Error {
375 severity: FATAL
376 code: 5000
377 msg: "Parse error unserializing protobuf message"
378 sql_state: "HY000"
379 }
380
381 aborting session foo
382 switched to session default
383 connecting...
384 active session is now 'foo'
385 Sending 5 bytes raw data...
386 Got expected error:
387 Mysqlx.Error {
388 severity: FATAL
389 code: 5000
390 msg: "Parse error unserializing protobuf message"
391 sql_state: "HY000"
392 }
393
394 aborting session foo
395 switched to session default
396 Mysqlx.Ok {
397 msg: "bye!"
398 }
399 ok