Debian Codegraph @

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