Debian Codegraph @

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

raw
1 CREATE SCHEMA IF NOT EXISTS xtest;
2 USE xtest;
3 CREATE PROCEDURE recreate_tables()
4 BEGIN
5 CREATE TABLE IF NOT EXISTS xtable (phrase VARCHAR(30), prio INTEGER);
6 TRUNCATE TABLE xtable;
7 INSERT INTO xtable (phrase, prio) VALUES ('Alice has a cat', 1);
8 INSERT INTO xtable (phrase, prio) VALUES ('Bob has a dog 1', 2);
9 INSERT INTO xtable (phrase, prio) VALUES ('Peppa has a teddy', 1);
10 INSERT INTO xtable (phrase, prio) VALUES ('Bob has a dog 2', 3);
11 INSERT INTO xtable (phrase, prio) VALUES ('Row to delete', 4);
12 CREATE TABLE IF NOT EXISTS xtable_with_pk (p_id INTEGER AUTO_INCREMENT PRIMARY KEY, description varchar(40));
13 TRUNCATE TABLE xtable_with_pk;
14 INSERT INTO xtable_with_pk (description) VALUES ('MyRow');
15 END //
16 CREATE PROCEDURE two_resultsets()
17 BEGIN
18 SELECT phrase FROM xtable limit 3;
19 SELECT prio FROM xtable limit 2;
20 END //
21 CREATE PROCEDURE two_resultsets_with_errors()
22 BEGIN
23 SELECT 1/prio as col1 FROM xtable;
24 SELECT 1/prio as col1 FROM xtable;
25 END //
26 CREATE PROCEDURE three_resultsets()
27 BEGIN
28 SELECT phrase FROM xtable limit 3;
29 SELECT prio FROM xtable limit 2;
30 SELECT prio FROM xtable ORDER BY prio limit 3;
31 END //
32
33 ## A. Execute the test using zlib/group
34 #
35 CALL recreate_tables();
36
37
38 ## I. Validate simple resultsets
39 #
40 # 1. Assert resultset for delete queries
41 # 2. Assert resultset for update queries
42 # 3. Assert resultset for insert queries (no auto_inc column)
43 # 4. Assert resultset for insert queries (has auto_inc column)
44 # 5. Assert resultset for select queries
45
46 ## II. Validate simple multi-resultsets
47 #
48 # 1. Assert two resultsets for select queries
49 # 2. Assert three resultsets for select queries
50
51 ## III. Validate simple multi/resultsets with warnings
52 #
53 # 1. Assert one resultsets for select queries
54 # 2. Assert two resultsets for select queries
55
56 #
57 # I.1
58 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
59 RUN recvok
60 [Execute]
61 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
62 [ASSERT Mysqlx.Sql.StmtExecuteOk]
63
64 #
65 # I.2
66 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
67 RUN recvok
68 [Execute]
69 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
70 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
71 [ASSERT Mysqlx.Sql.StmtExecuteOk]
72
73 #
74 # I.3
75 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
76 RUN recvok
77 [Execute]
78 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
79 [ASSERT Mysqlx.Sql.StmtExecuteOk]
80
81 #
82 # I.4
83 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
84 RUN recvok
85 [Execute]
86 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
87 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
88 [ASSERT Mysqlx.Sql.StmtExecuteOk]
89
90 #
91 # I.5
92 [PREPARE - SELECT phrase FROM xtest.xtable]
93 RUN recvok
94 [Execute]
95 [ASSERT Mysqlx.Resultset.ColumnMetaData]
96 [ASSERT Mysqlx.Resultset.Row]
97 [ASSERT Mysqlx.Resultset.Row]
98 [ASSERT Mysqlx.Resultset.Row]
99 [ASSERT Mysqlx.Resultset.Row]
100 [ASSERT Mysqlx.Resultset.FetchDone]
101 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
102 [ASSERT Mysqlx.Sql.StmtExecuteOk]
103
104 #
105 # II.1
106 [PREPARE - CALL two_resultsets]
107 RUN recvok
108 [Execute]
109 [ASSERT Mysqlx.Resultset.ColumnMetaData]
110 [ASSERT Mysqlx.Resultset.Row]
111 [ASSERT Mysqlx.Resultset.Row]
112 [ASSERT Mysqlx.Resultset.Row]
113 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
114 [ASSERT Mysqlx.Resultset.ColumnMetaData]
115 [ASSERT Mysqlx.Resultset.Row]
116 [ASSERT Mysqlx.Resultset.Row]
117 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
118 [ASSERT Mysqlx.Resultset.FetchDone]
119 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
120 [ASSERT Mysqlx.Sql.StmtExecuteOk]
121
122 #
123 # II.2
124 [PREPARE - CALL three_resultsets]
125 RUN recvok
126 [Execute]
127 [ASSERT Mysqlx.Resultset.ColumnMetaData]
128 [ASSERT Mysqlx.Resultset.Row]
129 [ASSERT Mysqlx.Resultset.Row]
130 [ASSERT Mysqlx.Resultset.Row]
131 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
132 [ASSERT Mysqlx.Resultset.ColumnMetaData]
133 [ASSERT Mysqlx.Resultset.Row]
134 [ASSERT Mysqlx.Resultset.Row]
135 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
136 [ASSERT Mysqlx.Resultset.ColumnMetaData]
137 [ASSERT Mysqlx.Resultset.Row]
138 [ASSERT Mysqlx.Resultset.Row]
139 [ASSERT Mysqlx.Resultset.Row]
140 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
141 [ASSERT Mysqlx.Resultset.FetchDone]
142 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
143 [ASSERT Mysqlx.Sql.StmtExecuteOk]
144
145 #
146 # III.1
147 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
148 RUN recvok
149 [Execute]
150 [ASSERT Mysqlx.Resultset.ColumnMetaData]
151 [ASSERT Mysqlx.Resultset.Row]
152 [ASSERT Mysqlx.Resultset.Row]
153 [ASSERT Mysqlx.Resultset.Row]
154 [ASSERT Mysqlx.Resultset.Row]
155 [ASSERT Mysqlx.Resultset.FetchDone]
156 [ASSERT notice warning - WARNING, 1365]
157 [ASSERT notice warning - WARNING, 1365]
158 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
159 [ASSERT Mysqlx.Sql.StmtExecuteOk]
160
161 #
162 # III.2
163 [PREPARE - CALL two_resultsets_with_errors]
164 RUN recvok
165 [Execute]
166 [ASSERT Mysqlx.Resultset.ColumnMetaData]
167 [ASSERT Mysqlx.Resultset.Row]
168 [ASSERT Mysqlx.Resultset.Row]
169 [ASSERT Mysqlx.Resultset.Row]
170 [ASSERT Mysqlx.Resultset.Row]
171 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
172 [ASSERT Mysqlx.Resultset.ColumnMetaData]
173 [ASSERT Mysqlx.Resultset.Row]
174 [ASSERT Mysqlx.Resultset.Row]
175 [ASSERT Mysqlx.Resultset.Row]
176 [ASSERT Mysqlx.Resultset.Row]
177 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
178 [ASSERT Mysqlx.Resultset.FetchDone]
179 [ASSERT notice warning - WARNING, 1365]
180 [ASSERT notice warning - WARNING, 1365]
181 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
182 [ASSERT Mysqlx.Sql.StmtExecuteOk]
183 Mysqlx.Ok {
184 msg: "bye!"
185 }
186 ok
187
188 ## B. Execute the test using zlib/multiple
189 #
190 CALL recreate_tables();
191
192
193 ## I. Validate simple resultsets
194 #
195 # 1. Assert resultset for delete queries
196 # 2. Assert resultset for update queries
197 # 3. Assert resultset for insert queries (no auto_inc column)
198 # 4. Assert resultset for insert queries (has auto_inc column)
199 # 5. Assert resultset for select queries
200
201 ## II. Validate simple multi-resultsets
202 #
203 # 1. Assert two resultsets for select queries
204 # 2. Assert three resultsets for select queries
205
206 ## III. Validate simple multi/resultsets with warnings
207 #
208 # 1. Assert one resultsets for select queries
209 # 2. Assert two resultsets for select queries
210
211 #
212 # I.1
213 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
214 RUN recvok
215 [Execute]
216 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
217 [ASSERT Mysqlx.Sql.StmtExecuteOk]
218
219 #
220 # I.2
221 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
222 RUN recvok
223 [Execute]
224 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
225 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
226 [ASSERT Mysqlx.Sql.StmtExecuteOk]
227
228 #
229 # I.3
230 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
231 RUN recvok
232 [Execute]
233 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
234 [ASSERT Mysqlx.Sql.StmtExecuteOk]
235
236 #
237 # I.4
238 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
239 RUN recvok
240 [Execute]
241 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
242 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
243 [ASSERT Mysqlx.Sql.StmtExecuteOk]
244
245 #
246 # I.5
247 [PREPARE - SELECT phrase FROM xtest.xtable]
248 RUN recvok
249 [Execute]
250 [ASSERT Mysqlx.Resultset.ColumnMetaData]
251 [ASSERT Mysqlx.Resultset.Row]
252 [ASSERT Mysqlx.Resultset.Row]
253 [ASSERT Mysqlx.Resultset.Row]
254 [ASSERT Mysqlx.Resultset.Row]
255 [ASSERT Mysqlx.Resultset.FetchDone]
256 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
257 [ASSERT Mysqlx.Sql.StmtExecuteOk]
258
259 #
260 # II.1
261 [PREPARE - CALL two_resultsets]
262 RUN recvok
263 [Execute]
264 [ASSERT Mysqlx.Resultset.ColumnMetaData]
265 [ASSERT Mysqlx.Resultset.Row]
266 [ASSERT Mysqlx.Resultset.Row]
267 [ASSERT Mysqlx.Resultset.Row]
268 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
269 [ASSERT Mysqlx.Resultset.ColumnMetaData]
270 [ASSERT Mysqlx.Resultset.Row]
271 [ASSERT Mysqlx.Resultset.Row]
272 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
273 [ASSERT Mysqlx.Resultset.FetchDone]
274 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
275 [ASSERT Mysqlx.Sql.StmtExecuteOk]
276
277 #
278 # II.2
279 [PREPARE - CALL three_resultsets]
280 RUN recvok
281 [Execute]
282 [ASSERT Mysqlx.Resultset.ColumnMetaData]
283 [ASSERT Mysqlx.Resultset.Row]
284 [ASSERT Mysqlx.Resultset.Row]
285 [ASSERT Mysqlx.Resultset.Row]
286 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
287 [ASSERT Mysqlx.Resultset.ColumnMetaData]
288 [ASSERT Mysqlx.Resultset.Row]
289 [ASSERT Mysqlx.Resultset.Row]
290 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
291 [ASSERT Mysqlx.Resultset.ColumnMetaData]
292 [ASSERT Mysqlx.Resultset.Row]
293 [ASSERT Mysqlx.Resultset.Row]
294 [ASSERT Mysqlx.Resultset.Row]
295 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
296 [ASSERT Mysqlx.Resultset.FetchDone]
297 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
298 [ASSERT Mysqlx.Sql.StmtExecuteOk]
299
300 #
301 # III.1
302 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
303 RUN recvok
304 [Execute]
305 [ASSERT Mysqlx.Resultset.ColumnMetaData]
306 [ASSERT Mysqlx.Resultset.Row]
307 [ASSERT Mysqlx.Resultset.Row]
308 [ASSERT Mysqlx.Resultset.Row]
309 [ASSERT Mysqlx.Resultset.Row]
310 [ASSERT Mysqlx.Resultset.FetchDone]
311 [ASSERT notice warning - WARNING, 1365]
312 [ASSERT notice warning - WARNING, 1365]
313 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
314 [ASSERT Mysqlx.Sql.StmtExecuteOk]
315
316 #
317 # III.2
318 [PREPARE - CALL two_resultsets_with_errors]
319 RUN recvok
320 [Execute]
321 [ASSERT Mysqlx.Resultset.ColumnMetaData]
322 [ASSERT Mysqlx.Resultset.Row]
323 [ASSERT Mysqlx.Resultset.Row]
324 [ASSERT Mysqlx.Resultset.Row]
325 [ASSERT Mysqlx.Resultset.Row]
326 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
327 [ASSERT Mysqlx.Resultset.ColumnMetaData]
328 [ASSERT Mysqlx.Resultset.Row]
329 [ASSERT Mysqlx.Resultset.Row]
330 [ASSERT Mysqlx.Resultset.Row]
331 [ASSERT Mysqlx.Resultset.Row]
332 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
333 [ASSERT Mysqlx.Resultset.FetchDone]
334 [ASSERT notice warning - WARNING, 1365]
335 [ASSERT notice warning - WARNING, 1365]
336 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
337 [ASSERT Mysqlx.Sql.StmtExecuteOk]
338 Mysqlx.Ok {
339 msg: "bye!"
340 }
341 ok
342
343 ## C. Execute the test using zlib/single
344 #
345 CALL recreate_tables();
346
347
348 ## I. Validate simple resultsets
349 #
350 # 1. Assert resultset for delete queries
351 # 2. Assert resultset for update queries
352 # 3. Assert resultset for insert queries (no auto_inc column)
353 # 4. Assert resultset for insert queries (has auto_inc column)
354 # 5. Assert resultset for select queries
355
356 ## II. Validate simple multi-resultsets
357 #
358 # 1. Assert two resultsets for select queries
359 # 2. Assert three resultsets for select queries
360
361 ## III. Validate simple multi/resultsets with warnings
362 #
363 # 1. Assert one resultsets for select queries
364 # 2. Assert two resultsets for select queries
365
366 #
367 # I.1
368 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
369 RUN recvok
370 [Execute]
371 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
372 [ASSERT Mysqlx.Sql.StmtExecuteOk]
373
374 #
375 # I.2
376 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
377 RUN recvok
378 [Execute]
379 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
380 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
381 [ASSERT Mysqlx.Sql.StmtExecuteOk]
382
383 #
384 # I.3
385 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
386 RUN recvok
387 [Execute]
388 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
389 [ASSERT Mysqlx.Sql.StmtExecuteOk]
390
391 #
392 # I.4
393 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
394 RUN recvok
395 [Execute]
396 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
397 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
398 [ASSERT Mysqlx.Sql.StmtExecuteOk]
399
400 #
401 # I.5
402 [PREPARE - SELECT phrase FROM xtest.xtable]
403 RUN recvok
404 [Execute]
405 [ASSERT Mysqlx.Resultset.ColumnMetaData]
406 [ASSERT Mysqlx.Resultset.Row]
407 [ASSERT Mysqlx.Resultset.Row]
408 [ASSERT Mysqlx.Resultset.Row]
409 [ASSERT Mysqlx.Resultset.Row]
410 [ASSERT Mysqlx.Resultset.FetchDone]
411 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
412 [ASSERT Mysqlx.Sql.StmtExecuteOk]
413
414 #
415 # II.1
416 [PREPARE - CALL two_resultsets]
417 RUN recvok
418 [Execute]
419 [ASSERT Mysqlx.Resultset.ColumnMetaData]
420 [ASSERT Mysqlx.Resultset.Row]
421 [ASSERT Mysqlx.Resultset.Row]
422 [ASSERT Mysqlx.Resultset.Row]
423 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
424 [ASSERT Mysqlx.Resultset.ColumnMetaData]
425 [ASSERT Mysqlx.Resultset.Row]
426 [ASSERT Mysqlx.Resultset.Row]
427 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
428 [ASSERT Mysqlx.Resultset.FetchDone]
429 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
430 [ASSERT Mysqlx.Sql.StmtExecuteOk]
431
432 #
433 # II.2
434 [PREPARE - CALL three_resultsets]
435 RUN recvok
436 [Execute]
437 [ASSERT Mysqlx.Resultset.ColumnMetaData]
438 [ASSERT Mysqlx.Resultset.Row]
439 [ASSERT Mysqlx.Resultset.Row]
440 [ASSERT Mysqlx.Resultset.Row]
441 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
442 [ASSERT Mysqlx.Resultset.ColumnMetaData]
443 [ASSERT Mysqlx.Resultset.Row]
444 [ASSERT Mysqlx.Resultset.Row]
445 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
446 [ASSERT Mysqlx.Resultset.ColumnMetaData]
447 [ASSERT Mysqlx.Resultset.Row]
448 [ASSERT Mysqlx.Resultset.Row]
449 [ASSERT Mysqlx.Resultset.Row]
450 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
451 [ASSERT Mysqlx.Resultset.FetchDone]
452 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
453 [ASSERT Mysqlx.Sql.StmtExecuteOk]
454
455 #
456 # III.1
457 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
458 RUN recvok
459 [Execute]
460 [ASSERT Mysqlx.Resultset.ColumnMetaData]
461 [ASSERT Mysqlx.Resultset.Row]
462 [ASSERT Mysqlx.Resultset.Row]
463 [ASSERT Mysqlx.Resultset.Row]
464 [ASSERT Mysqlx.Resultset.Row]
465 [ASSERT Mysqlx.Resultset.FetchDone]
466 [ASSERT notice warning - WARNING, 1365]
467 [ASSERT notice warning - WARNING, 1365]
468 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
469 [ASSERT Mysqlx.Sql.StmtExecuteOk]
470
471 #
472 # III.2
473 [PREPARE - CALL two_resultsets_with_errors]
474 RUN recvok
475 [Execute]
476 [ASSERT Mysqlx.Resultset.ColumnMetaData]
477 [ASSERT Mysqlx.Resultset.Row]
478 [ASSERT Mysqlx.Resultset.Row]
479 [ASSERT Mysqlx.Resultset.Row]
480 [ASSERT Mysqlx.Resultset.Row]
481 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
482 [ASSERT Mysqlx.Resultset.ColumnMetaData]
483 [ASSERT Mysqlx.Resultset.Row]
484 [ASSERT Mysqlx.Resultset.Row]
485 [ASSERT Mysqlx.Resultset.Row]
486 [ASSERT Mysqlx.Resultset.Row]
487 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
488 [ASSERT Mysqlx.Resultset.FetchDone]
489 [ASSERT notice warning - WARNING, 1365]
490 [ASSERT notice warning - WARNING, 1365]
491 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
492 [ASSERT Mysqlx.Sql.StmtExecuteOk]
493 Mysqlx.Ok {
494 msg: "bye!"
495 }
496 ok
497
498 ## D. Execute the test using lz4/group
499 #
500 CALL recreate_tables();
501
502
503 ## I. Validate simple resultsets
504 #
505 # 1. Assert resultset for delete queries
506 # 2. Assert resultset for update queries
507 # 3. Assert resultset for insert queries (no auto_inc column)
508 # 4. Assert resultset for insert queries (has auto_inc column)
509 # 5. Assert resultset for select queries
510
511 ## II. Validate simple multi-resultsets
512 #
513 # 1. Assert two resultsets for select queries
514 # 2. Assert three resultsets for select queries
515
516 ## III. Validate simple multi/resultsets with warnings
517 #
518 # 1. Assert one resultsets for select queries
519 # 2. Assert two resultsets for select queries
520
521 #
522 # I.1
523 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
524 RUN recvok
525 [Execute]
526 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
527 [ASSERT Mysqlx.Sql.StmtExecuteOk]
528
529 #
530 # I.2
531 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
532 RUN recvok
533 [Execute]
534 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
535 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
536 [ASSERT Mysqlx.Sql.StmtExecuteOk]
537
538 #
539 # I.3
540 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
541 RUN recvok
542 [Execute]
543 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
544 [ASSERT Mysqlx.Sql.StmtExecuteOk]
545
546 #
547 # I.4
548 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
549 RUN recvok
550 [Execute]
551 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
552 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
553 [ASSERT Mysqlx.Sql.StmtExecuteOk]
554
555 #
556 # I.5
557 [PREPARE - SELECT phrase FROM xtest.xtable]
558 RUN recvok
559 [Execute]
560 [ASSERT Mysqlx.Resultset.ColumnMetaData]
561 [ASSERT Mysqlx.Resultset.Row]
562 [ASSERT Mysqlx.Resultset.Row]
563 [ASSERT Mysqlx.Resultset.Row]
564 [ASSERT Mysqlx.Resultset.Row]
565 [ASSERT Mysqlx.Resultset.FetchDone]
566 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
567 [ASSERT Mysqlx.Sql.StmtExecuteOk]
568
569 #
570 # II.1
571 [PREPARE - CALL two_resultsets]
572 RUN recvok
573 [Execute]
574 [ASSERT Mysqlx.Resultset.ColumnMetaData]
575 [ASSERT Mysqlx.Resultset.Row]
576 [ASSERT Mysqlx.Resultset.Row]
577 [ASSERT Mysqlx.Resultset.Row]
578 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
579 [ASSERT Mysqlx.Resultset.ColumnMetaData]
580 [ASSERT Mysqlx.Resultset.Row]
581 [ASSERT Mysqlx.Resultset.Row]
582 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
583 [ASSERT Mysqlx.Resultset.FetchDone]
584 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
585 [ASSERT Mysqlx.Sql.StmtExecuteOk]
586
587 #
588 # II.2
589 [PREPARE - CALL three_resultsets]
590 RUN recvok
591 [Execute]
592 [ASSERT Mysqlx.Resultset.ColumnMetaData]
593 [ASSERT Mysqlx.Resultset.Row]
594 [ASSERT Mysqlx.Resultset.Row]
595 [ASSERT Mysqlx.Resultset.Row]
596 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
597 [ASSERT Mysqlx.Resultset.ColumnMetaData]
598 [ASSERT Mysqlx.Resultset.Row]
599 [ASSERT Mysqlx.Resultset.Row]
600 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
601 [ASSERT Mysqlx.Resultset.ColumnMetaData]
602 [ASSERT Mysqlx.Resultset.Row]
603 [ASSERT Mysqlx.Resultset.Row]
604 [ASSERT Mysqlx.Resultset.Row]
605 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
606 [ASSERT Mysqlx.Resultset.FetchDone]
607 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
608 [ASSERT Mysqlx.Sql.StmtExecuteOk]
609
610 #
611 # III.1
612 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
613 RUN recvok
614 [Execute]
615 [ASSERT Mysqlx.Resultset.ColumnMetaData]
616 [ASSERT Mysqlx.Resultset.Row]
617 [ASSERT Mysqlx.Resultset.Row]
618 [ASSERT Mysqlx.Resultset.Row]
619 [ASSERT Mysqlx.Resultset.Row]
620 [ASSERT Mysqlx.Resultset.FetchDone]
621 [ASSERT notice warning - WARNING, 1365]
622 [ASSERT notice warning - WARNING, 1365]
623 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
624 [ASSERT Mysqlx.Sql.StmtExecuteOk]
625
626 #
627 # III.2
628 [PREPARE - CALL two_resultsets_with_errors]
629 RUN recvok
630 [Execute]
631 [ASSERT Mysqlx.Resultset.ColumnMetaData]
632 [ASSERT Mysqlx.Resultset.Row]
633 [ASSERT Mysqlx.Resultset.Row]
634 [ASSERT Mysqlx.Resultset.Row]
635 [ASSERT Mysqlx.Resultset.Row]
636 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
637 [ASSERT Mysqlx.Resultset.ColumnMetaData]
638 [ASSERT Mysqlx.Resultset.Row]
639 [ASSERT Mysqlx.Resultset.Row]
640 [ASSERT Mysqlx.Resultset.Row]
641 [ASSERT Mysqlx.Resultset.Row]
642 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
643 [ASSERT Mysqlx.Resultset.FetchDone]
644 [ASSERT notice warning - WARNING, 1365]
645 [ASSERT notice warning - WARNING, 1365]
646 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
647 [ASSERT Mysqlx.Sql.StmtExecuteOk]
648 Mysqlx.Ok {
649 msg: "bye!"
650 }
651 ok
652
653 ## E. Execute the test using lz4/multiple
654 #
655 CALL recreate_tables();
656
657
658 ## I. Validate simple resultsets
659 #
660 # 1. Assert resultset for delete queries
661 # 2. Assert resultset for update queries
662 # 3. Assert resultset for insert queries (no auto_inc column)
663 # 4. Assert resultset for insert queries (has auto_inc column)
664 # 5. Assert resultset for select queries
665
666 ## II. Validate simple multi-resultsets
667 #
668 # 1. Assert two resultsets for select queries
669 # 2. Assert three resultsets for select queries
670
671 ## III. Validate simple multi/resultsets with warnings
672 #
673 # 1. Assert one resultsets for select queries
674 # 2. Assert two resultsets for select queries
675
676 #
677 # I.1
678 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
679 RUN recvok
680 [Execute]
681 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
682 [ASSERT Mysqlx.Sql.StmtExecuteOk]
683
684 #
685 # I.2
686 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
687 RUN recvok
688 [Execute]
689 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
690 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
691 [ASSERT Mysqlx.Sql.StmtExecuteOk]
692
693 #
694 # I.3
695 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
696 RUN recvok
697 [Execute]
698 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
699 [ASSERT Mysqlx.Sql.StmtExecuteOk]
700
701 #
702 # I.4
703 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
704 RUN recvok
705 [Execute]
706 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
707 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
708 [ASSERT Mysqlx.Sql.StmtExecuteOk]
709
710 #
711 # I.5
712 [PREPARE - SELECT phrase FROM xtest.xtable]
713 RUN recvok
714 [Execute]
715 [ASSERT Mysqlx.Resultset.ColumnMetaData]
716 [ASSERT Mysqlx.Resultset.Row]
717 [ASSERT Mysqlx.Resultset.Row]
718 [ASSERT Mysqlx.Resultset.Row]
719 [ASSERT Mysqlx.Resultset.Row]
720 [ASSERT Mysqlx.Resultset.FetchDone]
721 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
722 [ASSERT Mysqlx.Sql.StmtExecuteOk]
723
724 #
725 # II.1
726 [PREPARE - CALL two_resultsets]
727 RUN recvok
728 [Execute]
729 [ASSERT Mysqlx.Resultset.ColumnMetaData]
730 [ASSERT Mysqlx.Resultset.Row]
731 [ASSERT Mysqlx.Resultset.Row]
732 [ASSERT Mysqlx.Resultset.Row]
733 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
734 [ASSERT Mysqlx.Resultset.ColumnMetaData]
735 [ASSERT Mysqlx.Resultset.Row]
736 [ASSERT Mysqlx.Resultset.Row]
737 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
738 [ASSERT Mysqlx.Resultset.FetchDone]
739 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
740 [ASSERT Mysqlx.Sql.StmtExecuteOk]
741
742 #
743 # II.2
744 [PREPARE - CALL three_resultsets]
745 RUN recvok
746 [Execute]
747 [ASSERT Mysqlx.Resultset.ColumnMetaData]
748 [ASSERT Mysqlx.Resultset.Row]
749 [ASSERT Mysqlx.Resultset.Row]
750 [ASSERT Mysqlx.Resultset.Row]
751 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
752 [ASSERT Mysqlx.Resultset.ColumnMetaData]
753 [ASSERT Mysqlx.Resultset.Row]
754 [ASSERT Mysqlx.Resultset.Row]
755 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
756 [ASSERT Mysqlx.Resultset.ColumnMetaData]
757 [ASSERT Mysqlx.Resultset.Row]
758 [ASSERT Mysqlx.Resultset.Row]
759 [ASSERT Mysqlx.Resultset.Row]
760 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
761 [ASSERT Mysqlx.Resultset.FetchDone]
762 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
763 [ASSERT Mysqlx.Sql.StmtExecuteOk]
764
765 #
766 # III.1
767 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
768 RUN recvok
769 [Execute]
770 [ASSERT Mysqlx.Resultset.ColumnMetaData]
771 [ASSERT Mysqlx.Resultset.Row]
772 [ASSERT Mysqlx.Resultset.Row]
773 [ASSERT Mysqlx.Resultset.Row]
774 [ASSERT Mysqlx.Resultset.Row]
775 [ASSERT Mysqlx.Resultset.FetchDone]
776 [ASSERT notice warning - WARNING, 1365]
777 [ASSERT notice warning - WARNING, 1365]
778 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
779 [ASSERT Mysqlx.Sql.StmtExecuteOk]
780
781 #
782 # III.2
783 [PREPARE - CALL two_resultsets_with_errors]
784 RUN recvok
785 [Execute]
786 [ASSERT Mysqlx.Resultset.ColumnMetaData]
787 [ASSERT Mysqlx.Resultset.Row]
788 [ASSERT Mysqlx.Resultset.Row]
789 [ASSERT Mysqlx.Resultset.Row]
790 [ASSERT Mysqlx.Resultset.Row]
791 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
792 [ASSERT Mysqlx.Resultset.ColumnMetaData]
793 [ASSERT Mysqlx.Resultset.Row]
794 [ASSERT Mysqlx.Resultset.Row]
795 [ASSERT Mysqlx.Resultset.Row]
796 [ASSERT Mysqlx.Resultset.Row]
797 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
798 [ASSERT Mysqlx.Resultset.FetchDone]
799 [ASSERT notice warning - WARNING, 1365]
800 [ASSERT notice warning - WARNING, 1365]
801 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
802 [ASSERT Mysqlx.Sql.StmtExecuteOk]
803 Mysqlx.Ok {
804 msg: "bye!"
805 }
806 ok
807
808 ## F. Execute the test using lz4/single
809 #
810 CALL recreate_tables();
811
812
813 ## I. Validate simple resultsets
814 #
815 # 1. Assert resultset for delete queries
816 # 2. Assert resultset for update queries
817 # 3. Assert resultset for insert queries (no auto_inc column)
818 # 4. Assert resultset for insert queries (has auto_inc column)
819 # 5. Assert resultset for select queries
820
821 ## II. Validate simple multi-resultsets
822 #
823 # 1. Assert two resultsets for select queries
824 # 2. Assert three resultsets for select queries
825
826 ## III. Validate simple multi/resultsets with warnings
827 #
828 # 1. Assert one resultsets for select queries
829 # 2. Assert two resultsets for select queries
830
831 #
832 # I.1
833 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
834 RUN recvok
835 [Execute]
836 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
837 [ASSERT Mysqlx.Sql.StmtExecuteOk]
838
839 #
840 # I.2
841 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
842 RUN recvok
843 [Execute]
844 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
845 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
846 [ASSERT Mysqlx.Sql.StmtExecuteOk]
847
848 #
849 # I.3
850 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
851 RUN recvok
852 [Execute]
853 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
854 [ASSERT Mysqlx.Sql.StmtExecuteOk]
855
856 #
857 # I.4
858 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
859 RUN recvok
860 [Execute]
861 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
862 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
863 [ASSERT Mysqlx.Sql.StmtExecuteOk]
864
865 #
866 # I.5
867 [PREPARE - SELECT phrase FROM xtest.xtable]
868 RUN recvok
869 [Execute]
870 [ASSERT Mysqlx.Resultset.ColumnMetaData]
871 [ASSERT Mysqlx.Resultset.Row]
872 [ASSERT Mysqlx.Resultset.Row]
873 [ASSERT Mysqlx.Resultset.Row]
874 [ASSERT Mysqlx.Resultset.Row]
875 [ASSERT Mysqlx.Resultset.FetchDone]
876 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
877 [ASSERT Mysqlx.Sql.StmtExecuteOk]
878
879 #
880 # II.1
881 [PREPARE - CALL two_resultsets]
882 RUN recvok
883 [Execute]
884 [ASSERT Mysqlx.Resultset.ColumnMetaData]
885 [ASSERT Mysqlx.Resultset.Row]
886 [ASSERT Mysqlx.Resultset.Row]
887 [ASSERT Mysqlx.Resultset.Row]
888 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
889 [ASSERT Mysqlx.Resultset.ColumnMetaData]
890 [ASSERT Mysqlx.Resultset.Row]
891 [ASSERT Mysqlx.Resultset.Row]
892 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
893 [ASSERT Mysqlx.Resultset.FetchDone]
894 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
895 [ASSERT Mysqlx.Sql.StmtExecuteOk]
896
897 #
898 # II.2
899 [PREPARE - CALL three_resultsets]
900 RUN recvok
901 [Execute]
902 [ASSERT Mysqlx.Resultset.ColumnMetaData]
903 [ASSERT Mysqlx.Resultset.Row]
904 [ASSERT Mysqlx.Resultset.Row]
905 [ASSERT Mysqlx.Resultset.Row]
906 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
907 [ASSERT Mysqlx.Resultset.ColumnMetaData]
908 [ASSERT Mysqlx.Resultset.Row]
909 [ASSERT Mysqlx.Resultset.Row]
910 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
911 [ASSERT Mysqlx.Resultset.ColumnMetaData]
912 [ASSERT Mysqlx.Resultset.Row]
913 [ASSERT Mysqlx.Resultset.Row]
914 [ASSERT Mysqlx.Resultset.Row]
915 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
916 [ASSERT Mysqlx.Resultset.FetchDone]
917 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
918 [ASSERT Mysqlx.Sql.StmtExecuteOk]
919
920 #
921 # III.1
922 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
923 RUN recvok
924 [Execute]
925 [ASSERT Mysqlx.Resultset.ColumnMetaData]
926 [ASSERT Mysqlx.Resultset.Row]
927 [ASSERT Mysqlx.Resultset.Row]
928 [ASSERT Mysqlx.Resultset.Row]
929 [ASSERT Mysqlx.Resultset.Row]
930 [ASSERT Mysqlx.Resultset.FetchDone]
931 [ASSERT notice warning - WARNING, 1365]
932 [ASSERT notice warning - WARNING, 1365]
933 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
934 [ASSERT Mysqlx.Sql.StmtExecuteOk]
935
936 #
937 # III.2
938 [PREPARE - CALL two_resultsets_with_errors]
939 RUN recvok
940 [Execute]
941 [ASSERT Mysqlx.Resultset.ColumnMetaData]
942 [ASSERT Mysqlx.Resultset.Row]
943 [ASSERT Mysqlx.Resultset.Row]
944 [ASSERT Mysqlx.Resultset.Row]
945 [ASSERT Mysqlx.Resultset.Row]
946 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
947 [ASSERT Mysqlx.Resultset.ColumnMetaData]
948 [ASSERT Mysqlx.Resultset.Row]
949 [ASSERT Mysqlx.Resultset.Row]
950 [ASSERT Mysqlx.Resultset.Row]
951 [ASSERT Mysqlx.Resultset.Row]
952 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
953 [ASSERT Mysqlx.Resultset.FetchDone]
954 [ASSERT notice warning - WARNING, 1365]
955 [ASSERT notice warning - WARNING, 1365]
956 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
957 [ASSERT Mysqlx.Sql.StmtExecuteOk]
958 Mysqlx.Ok {
959 msg: "bye!"
960 }
961 ok
962
963 ## G. Execute the test using zstd/group
964 #
965 CALL recreate_tables();
966
967
968 ## I. Validate simple resultsets
969 #
970 # 1. Assert resultset for delete queries
971 # 2. Assert resultset for update queries
972 # 3. Assert resultset for insert queries (no auto_inc column)
973 # 4. Assert resultset for insert queries (has auto_inc column)
974 # 5. Assert resultset for select queries
975
976 ## II. Validate simple multi-resultsets
977 #
978 # 1. Assert two resultsets for select queries
979 # 2. Assert three resultsets for select queries
980
981 ## III. Validate simple multi/resultsets with warnings
982 #
983 # 1. Assert one resultsets for select queries
984 # 2. Assert two resultsets for select queries
985
986 #
987 # I.1
988 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
989 RUN recvok
990 [Execute]
991 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
992 [ASSERT Mysqlx.Sql.StmtExecuteOk]
993
994 #
995 # I.2
996 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
997 RUN recvok
998 [Execute]
999 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1000 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
1001 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1002
1003 #
1004 # I.3
1005 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
1006 RUN recvok
1007 [Execute]
1008 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1009 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1010
1011 #
1012 # I.4
1013 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
1014 RUN recvok
1015 [Execute]
1016 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1017 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1018 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1019
1020 #
1021 # I.5
1022 [PREPARE - SELECT phrase FROM xtest.xtable]
1023 RUN recvok
1024 [Execute]
1025 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1026 [ASSERT Mysqlx.Resultset.Row]
1027 [ASSERT Mysqlx.Resultset.Row]
1028 [ASSERT Mysqlx.Resultset.Row]
1029 [ASSERT Mysqlx.Resultset.Row]
1030 [ASSERT Mysqlx.Resultset.FetchDone]
1031 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1032 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1033
1034 #
1035 # II.1
1036 [PREPARE - CALL two_resultsets]
1037 RUN recvok
1038 [Execute]
1039 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1040 [ASSERT Mysqlx.Resultset.Row]
1041 [ASSERT Mysqlx.Resultset.Row]
1042 [ASSERT Mysqlx.Resultset.Row]
1043 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1044 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1045 [ASSERT Mysqlx.Resultset.Row]
1046 [ASSERT Mysqlx.Resultset.Row]
1047 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1048 [ASSERT Mysqlx.Resultset.FetchDone]
1049 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1050 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1051
1052 #
1053 # II.2
1054 [PREPARE - CALL three_resultsets]
1055 RUN recvok
1056 [Execute]
1057 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1058 [ASSERT Mysqlx.Resultset.Row]
1059 [ASSERT Mysqlx.Resultset.Row]
1060 [ASSERT Mysqlx.Resultset.Row]
1061 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1062 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1063 [ASSERT Mysqlx.Resultset.Row]
1064 [ASSERT Mysqlx.Resultset.Row]
1065 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1066 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1067 [ASSERT Mysqlx.Resultset.Row]
1068 [ASSERT Mysqlx.Resultset.Row]
1069 [ASSERT Mysqlx.Resultset.Row]
1070 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1071 [ASSERT Mysqlx.Resultset.FetchDone]
1072 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1073 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1074
1075 #
1076 # III.1
1077 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
1078 RUN recvok
1079 [Execute]
1080 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1081 [ASSERT Mysqlx.Resultset.Row]
1082 [ASSERT Mysqlx.Resultset.Row]
1083 [ASSERT Mysqlx.Resultset.Row]
1084 [ASSERT Mysqlx.Resultset.Row]
1085 [ASSERT Mysqlx.Resultset.FetchDone]
1086 [ASSERT notice warning - WARNING, 1365]
1087 [ASSERT notice warning - WARNING, 1365]
1088 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1089 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1090
1091 #
1092 # III.2
1093 [PREPARE - CALL two_resultsets_with_errors]
1094 RUN recvok
1095 [Execute]
1096 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1097 [ASSERT Mysqlx.Resultset.Row]
1098 [ASSERT Mysqlx.Resultset.Row]
1099 [ASSERT Mysqlx.Resultset.Row]
1100 [ASSERT Mysqlx.Resultset.Row]
1101 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1102 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1103 [ASSERT Mysqlx.Resultset.Row]
1104 [ASSERT Mysqlx.Resultset.Row]
1105 [ASSERT Mysqlx.Resultset.Row]
1106 [ASSERT Mysqlx.Resultset.Row]
1107 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1108 [ASSERT Mysqlx.Resultset.FetchDone]
1109 [ASSERT notice warning - WARNING, 1365]
1110 [ASSERT notice warning - WARNING, 1365]
1111 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1112 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1113 Mysqlx.Ok {
1114 msg: "bye!"
1115 }
1116 ok
1117
1118 ## H. Execute the test using zstd/multiple
1119 #
1120 CALL recreate_tables();
1121
1122
1123 ## I. Validate simple resultsets
1124 #
1125 # 1. Assert resultset for delete queries
1126 # 2. Assert resultset for update queries
1127 # 3. Assert resultset for insert queries (no auto_inc column)
1128 # 4. Assert resultset for insert queries (has auto_inc column)
1129 # 5. Assert resultset for select queries
1130
1131 ## II. Validate simple multi-resultsets
1132 #
1133 # 1. Assert two resultsets for select queries
1134 # 2. Assert three resultsets for select queries
1135
1136 ## III. Validate simple multi/resultsets with warnings
1137 #
1138 # 1. Assert one resultsets for select queries
1139 # 2. Assert two resultsets for select queries
1140
1141 #
1142 # I.1
1143 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
1144 RUN recvok
1145 [Execute]
1146 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
1147 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1148
1149 #
1150 # I.2
1151 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
1152 RUN recvok
1153 [Execute]
1154 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1155 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
1156 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1157
1158 #
1159 # I.3
1160 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
1161 RUN recvok
1162 [Execute]
1163 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1164 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1165
1166 #
1167 # I.4
1168 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
1169 RUN recvok
1170 [Execute]
1171 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1172 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1173 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1174
1175 #
1176 # I.5
1177 [PREPARE - SELECT phrase FROM xtest.xtable]
1178 RUN recvok
1179 [Execute]
1180 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1181 [ASSERT Mysqlx.Resultset.Row]
1182 [ASSERT Mysqlx.Resultset.Row]
1183 [ASSERT Mysqlx.Resultset.Row]
1184 [ASSERT Mysqlx.Resultset.Row]
1185 [ASSERT Mysqlx.Resultset.FetchDone]
1186 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1187 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1188
1189 #
1190 # II.1
1191 [PREPARE - CALL two_resultsets]
1192 RUN recvok
1193 [Execute]
1194 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1195 [ASSERT Mysqlx.Resultset.Row]
1196 [ASSERT Mysqlx.Resultset.Row]
1197 [ASSERT Mysqlx.Resultset.Row]
1198 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1199 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1200 [ASSERT Mysqlx.Resultset.Row]
1201 [ASSERT Mysqlx.Resultset.Row]
1202 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1203 [ASSERT Mysqlx.Resultset.FetchDone]
1204 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1205 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1206
1207 #
1208 # II.2
1209 [PREPARE - CALL three_resultsets]
1210 RUN recvok
1211 [Execute]
1212 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1213 [ASSERT Mysqlx.Resultset.Row]
1214 [ASSERT Mysqlx.Resultset.Row]
1215 [ASSERT Mysqlx.Resultset.Row]
1216 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1217 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1218 [ASSERT Mysqlx.Resultset.Row]
1219 [ASSERT Mysqlx.Resultset.Row]
1220 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1221 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1222 [ASSERT Mysqlx.Resultset.Row]
1223 [ASSERT Mysqlx.Resultset.Row]
1224 [ASSERT Mysqlx.Resultset.Row]
1225 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1226 [ASSERT Mysqlx.Resultset.FetchDone]
1227 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1228 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1229
1230 #
1231 # III.1
1232 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
1233 RUN recvok
1234 [Execute]
1235 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1236 [ASSERT Mysqlx.Resultset.Row]
1237 [ASSERT Mysqlx.Resultset.Row]
1238 [ASSERT Mysqlx.Resultset.Row]
1239 [ASSERT Mysqlx.Resultset.Row]
1240 [ASSERT Mysqlx.Resultset.FetchDone]
1241 [ASSERT notice warning - WARNING, 1365]
1242 [ASSERT notice warning - WARNING, 1365]
1243 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1244 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1245
1246 #
1247 # III.2
1248 [PREPARE - CALL two_resultsets_with_errors]
1249 RUN recvok
1250 [Execute]
1251 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1252 [ASSERT Mysqlx.Resultset.Row]
1253 [ASSERT Mysqlx.Resultset.Row]
1254 [ASSERT Mysqlx.Resultset.Row]
1255 [ASSERT Mysqlx.Resultset.Row]
1256 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1257 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1258 [ASSERT Mysqlx.Resultset.Row]
1259 [ASSERT Mysqlx.Resultset.Row]
1260 [ASSERT Mysqlx.Resultset.Row]
1261 [ASSERT Mysqlx.Resultset.Row]
1262 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1263 [ASSERT Mysqlx.Resultset.FetchDone]
1264 [ASSERT notice warning - WARNING, 1365]
1265 [ASSERT notice warning - WARNING, 1365]
1266 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1267 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1268 Mysqlx.Ok {
1269 msg: "bye!"
1270 }
1271 ok
1272
1273 ## I. Execute the test using zstd/single
1274 #
1275 CALL recreate_tables();
1276
1277
1278 ## I. Validate simple resultsets
1279 #
1280 # 1. Assert resultset for delete queries
1281 # 2. Assert resultset for update queries
1282 # 3. Assert resultset for insert queries (no auto_inc column)
1283 # 4. Assert resultset for insert queries (has auto_inc column)
1284 # 5. Assert resultset for select queries
1285
1286 ## II. Validate simple multi-resultsets
1287 #
1288 # 1. Assert two resultsets for select queries
1289 # 2. Assert three resultsets for select queries
1290
1291 ## III. Validate simple multi/resultsets with warnings
1292 #
1293 # 1. Assert one resultsets for select queries
1294 # 2. Assert two resultsets for select queries
1295
1296 #
1297 # I.1
1298 [PREPARE - DELETE FROM xtest.xtable WHERE prio=4 or prio=3]
1299 RUN recvok
1300 [Execute]
1301 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:2]
1302 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1303
1304 #
1305 # I.2
1306 [PREPARE - UPDATE xtest.xtable SET prio=prio-1]
1307 RUN recvok
1308 [Execute]
1309 [ASSERT notice session state change - PRODUCED_MESSAGE, type: V_STRING]
1310 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:3]
1311 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1312
1313 #
1314 # I.3
1315 [PREPARE - INSERT INTO xtest.xtable(phrase, prio) VALUE('Bob has a dog 2', 3)]
1316 RUN recvok
1317 [Execute]
1318 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1319 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1320
1321 #
1322 # I.4
1323 [PREPARE - INSERT INTO xtest.xtable_with_pk(description) VALUE('MyCustomRow')]
1324 RUN recvok
1325 [Execute]
1326 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:1]
1327 [ASSERT notice session state change - GENERATED_INSERT_ID, v_unsigned_int: 2]
1328 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1329
1330 #
1331 # I.5
1332 [PREPARE - SELECT phrase FROM xtest.xtable]
1333 RUN recvok
1334 [Execute]
1335 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1336 [ASSERT Mysqlx.Resultset.Row]
1337 [ASSERT Mysqlx.Resultset.Row]
1338 [ASSERT Mysqlx.Resultset.Row]
1339 [ASSERT Mysqlx.Resultset.Row]
1340 [ASSERT Mysqlx.Resultset.FetchDone]
1341 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1342 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1343
1344 #
1345 # II.1
1346 [PREPARE - CALL two_resultsets]
1347 RUN recvok
1348 [Execute]
1349 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1350 [ASSERT Mysqlx.Resultset.Row]
1351 [ASSERT Mysqlx.Resultset.Row]
1352 [ASSERT Mysqlx.Resultset.Row]
1353 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1354 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1355 [ASSERT Mysqlx.Resultset.Row]
1356 [ASSERT Mysqlx.Resultset.Row]
1357 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1358 [ASSERT Mysqlx.Resultset.FetchDone]
1359 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1360 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1361
1362 #
1363 # II.2
1364 [PREPARE - CALL three_resultsets]
1365 RUN recvok
1366 [Execute]
1367 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1368 [ASSERT Mysqlx.Resultset.Row]
1369 [ASSERT Mysqlx.Resultset.Row]
1370 [ASSERT Mysqlx.Resultset.Row]
1371 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1372 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1373 [ASSERT Mysqlx.Resultset.Row]
1374 [ASSERT Mysqlx.Resultset.Row]
1375 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1376 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1377 [ASSERT Mysqlx.Resultset.Row]
1378 [ASSERT Mysqlx.Resultset.Row]
1379 [ASSERT Mysqlx.Resultset.Row]
1380 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1381 [ASSERT Mysqlx.Resultset.FetchDone]
1382 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1383 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1384
1385 #
1386 # III.1
1387 [PREPARE - SELECT 1/prio as col1 FROM xtest.xtable]
1388 RUN recvok
1389 [Execute]
1390 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1391 [ASSERT Mysqlx.Resultset.Row]
1392 [ASSERT Mysqlx.Resultset.Row]
1393 [ASSERT Mysqlx.Resultset.Row]
1394 [ASSERT Mysqlx.Resultset.Row]
1395 [ASSERT Mysqlx.Resultset.FetchDone]
1396 [ASSERT notice warning - WARNING, 1365]
1397 [ASSERT notice warning - WARNING, 1365]
1398 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1399 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1400
1401 #
1402 # III.2
1403 [PREPARE - CALL two_resultsets_with_errors]
1404 RUN recvok
1405 [Execute]
1406 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1407 [ASSERT Mysqlx.Resultset.Row]
1408 [ASSERT Mysqlx.Resultset.Row]
1409 [ASSERT Mysqlx.Resultset.Row]
1410 [ASSERT Mysqlx.Resultset.Row]
1411 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1412 [ASSERT Mysqlx.Resultset.ColumnMetaData]
1413 [ASSERT Mysqlx.Resultset.Row]
1414 [ASSERT Mysqlx.Resultset.Row]
1415 [ASSERT Mysqlx.Resultset.Row]
1416 [ASSERT Mysqlx.Resultset.Row]
1417 [ASSERT Mysqlx.Resultset.FetchDoneMoreResultsets]
1418 [ASSERT Mysqlx.Resultset.FetchDone]
1419 [ASSERT notice warning - WARNING, 1365]
1420 [ASSERT notice warning - WARNING, 1365]
1421 [ASSERT notice session state change - ROWS_AFFECTED, v_unsigned_int:0]
1422 [ASSERT Mysqlx.Sql.StmtExecuteOk]
1423 Mysqlx.Ok {
1424 msg: "bye!"
1425 }
1426 ok