Debian Codegraph @

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

raw
1 CREATE TABLE `scalar_types`(`number_uint` INTEGER UNSIGNED DEFAULT 10, `number_sint` INTEGER DEFAULT -10, `value_bool` BOOLEAN DEFAULT 0, `value_string` VARCHAR(255) default NULL, `number_float` FLOAT DEFAULT 1.1, `number_double` DOUBLE DEFAULT 2.2, `value_blob` TINYBLOB DEFAULT NULL);
2 RUN SHOW STATUS like 'Mysqlx_stmt_execute_sql%'
3 Variable_name Value
4 Mysqlx_stmt_execute_sql 1
5 0 rows affected
6 RUN SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx%'
7 Variable_name Value
8 Mysqlx_stmt_execute_mysqlx 0
9 0 rows affected
10
11 command ok
12 send Mysqlx.Sql.StmtExecute {
13 stmt: "INSERT INTO `xplugintest`.`scalar_types`(`number_sint`, `number_uint`, `value_string`) VALUES(0, ?, \'First inserted row\'),(?, 1,\'Second inserted row\'), (-1, 0,?)"
14 args {
15 type: SCALAR
16 scalar {
17 type: V_UINT
18 v_unsigned_int: 1
19 }
20 }
21 args {
22 type: SCALAR
23 scalar {
24 type: V_SINT
25 v_signed_int: -1
26 }
27 }
28 args {
29 type: SCALAR
30 scalar {
31 type: V_STRING
32 v_string {
33 value: "\"Thrid\" inserted \'row\'"
34 }
35 }
36 }
37 }
38
39
40 3 rows affected
41 Records: 3 Duplicates: 0 Warnings: 0
42 send Mysqlx.Sql.StmtExecute {
43 stmt: "INSERT INTO `xplugintest`.`scalar_types`(`number_float`, `number_double`, `value_blob`) VALUES(0.1, ?, \'First inserted blob\'),(?, 200.01,\'Second inserted blob\'), (10.11, 2.2, ?), (111, 222, ?)"
44 args {
45 type: SCALAR
46 scalar {
47 type: V_DOUBLE
48 v_double: 200.01
49 }
50 }
51 args {
52 type: SCALAR
53 scalar {
54 type: V_DOUBLE
55 v_double: 10.11
56 }
57 }
58 args {
59 type: SCALAR
60 scalar {
61 type: V_STRING
62 v_string {
63 value: "\"Thrid\" inserted \'blob\'"
64 }
65 }
66 }
67 args {
68 type: SCALAR
69 scalar {
70 type: V_NULL
71 }
72 }
73 }
74
75
76 4 rows affected
77 Records: 4 Duplicates: 0 Warnings: 0
78 RUN SHOW STATUS like 'Mysqlx_stmt_execute_sql%'
79 Variable_name Value
80 Mysqlx_stmt_execute_sql 5
81 0 rows affected
82 RUN SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx%'
83 Variable_name Value
84 Mysqlx_stmt_execute_mysqlx 1
85 0 rows affected
86 Mysqlx.Ok {
87 msg: "bye!"
88 }
89 ok
90 RUN SHOW STATUS like 'Mysqlx_stmt_execute_sql%'
91 Variable_name Value
92 Mysqlx_stmt_execute_sql 1
93 0 rows affected
94 RUN SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx%'
95 Variable_name Value
96 Mysqlx_stmt_execute_mysqlx 0
97 0 rows affected
98 Mysqlx.Ok {
99 msg: "bye!"
100 }
101 ok
102 SELECT * FROM `xplugintest`.`scalar_types`;
103 number_uint number_sint value_bool value_string number_float number_double value_blob
104 1 0 0 First inserted row 1.1 2.2 NULL
105 1 -1 0 Second inserted row 1.1 2.2 NULL
106 0 -1 0 "Thrid" inserted 'row' 1.1 2.2 NULL
107 10 -10 0 NULL 0.1 200.01 First inserted blob
108 10 -10 0 NULL 10.11 200.01 Second inserted blob
109 10 -10 0 NULL 10.11 2.2 "Thrid" inserted 'blob'
110 10 -10 0 NULL 111 222 NULL
111 RUN SHOW STATUS like 'Mysqlx_stmt_execute_sql%'
112 Variable_name Value
113 Mysqlx_stmt_execute_sql 1
114 0 rows affected
115 RUN SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx%'
116 Variable_name Value
117 Mysqlx_stmt_execute_mysqlx 0
118 0 rows affected
119 Filter data by unsigned int
120 send Mysqlx.Sql.StmtExecute {
121 stmt: "SELECT * FROM `xplugintest`.`scalar_types` WHERE `number_uint`=?"
122 args {
123 type: SCALAR
124 scalar {
125 type: V_UINT
126 v_unsigned_int: 1
127 }
128 }
129 }
130
131 number_uint number_sint value_bool value_string number_float number_double value_blob
132 1 0 0 First inserted row 1.1 2.2 null
133 1 -1 0 Second inserted row 1.1 2.2 null
134 0 rows affected
135 Filter data by signed int
136 send Mysqlx.Sql.StmtExecute {
137 stmt: "SELECT * FROM `xplugintest`.`scalar_types` WHERE `number_sint`=?"
138 args {
139 type: SCALAR
140 scalar {
141 type: V_SINT
142 v_signed_int: -1
143 }
144 }
145 }
146
147 number_uint number_sint value_bool value_string number_float number_double value_blob
148 1 -1 0 Second inserted row 1.1 2.2 null
149 0 -1 0 "Thrid" inserted 'row' 1.1 2.2 null
150 0 rows affected
151 RUN SHOW STATUS like 'Mysqlx_stmt_execute_sql%'
152 Variable_name Value
153 Mysqlx_stmt_execute_sql 5
154 0 rows affected
155 RUN SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx%'
156 Variable_name Value
157 Mysqlx_stmt_execute_mysqlx 0
158 0 rows affected
159 Mysqlx.Ok {
160 msg: "bye!"
161 }
162 ok
163 RUN SHOW STATUS like 'Mysqlx_stmt_execute_sql%'
164 Variable_name Value
165 Mysqlx_stmt_execute_sql 1
166 0 rows affected
167 RUN SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx%'
168 Variable_name Value
169 Mysqlx_stmt_execute_mysqlx 0
170 0 rows affected
171 Insert multiple rows into a Document column
172 send Mysqlx.Crud.Insert {
173 collection {
174 name: "table2"
175 schema: "xplugintest"
176 }
177 data_model: DOCUMENT
178 row {
179 field {
180 type: LITERAL
181 literal {
182 type: V_STRING
183 v_string {
184 value: "\n{\n \"_id\": \"1\",\n \"name\": \"Omar Bras\", \"id\": \"1\"\n}"
185 }
186 }
187 }
188 }
189 row {
190 field {
191 type: LITERAL
192 literal {
193 type: V_STRING
194 v_string {
195 value: "\n{\n \"_id\": \"2\",\n \"name\": \"Omar Mex\", \"id\": \"2\"\n}"
196 }
197 }
198 }
199 }
200 }
201
202
203 2 rows affected
204 Records: 2 Duplicates: 0 Warnings: 0
205 send Mysqlx.Crud.Insert {
206 collection {
207 name: "table2"
208 schema: "xplugintest"
209 }
210 data_model: DOCUMENT
211 row {
212 field {
213 type: LITERAL
214 literal {
215 type: V_STRING
216 v_string {
217 value: "\n{\n \"_id\": \"3\",\n \"name\": \"Omar Peru\", \"id\": \"3\"\n}"
218 }
219 }
220 }
221 }
222 }
223
224
225 1 rows affected
226 name type
227 scalar_types TABLE
228 table2 COLLECTION
229 command ok
230 send Mysqlx.Sql.StmtExecute {
231 stmt: "errorstatement"
232 args {
233 type: SCALAR
234 scalar {
235 type: V_STRING
236 v_string {
237 value: "nodatabase"
238 }
239 }
240 }
241 namespace: "mysqlx"
242 }
243
244 Got expected error: Unknown database 'nodatabase' (code 1049)
245 Got expected error: Invalid mysqlx command errorstatement (code 5157)
246 RUN SHOW STATUS like 'Mysqlx_stmt_execute_sql%'
247 Variable_name Value
248 Mysqlx_stmt_execute_sql 3
249 0 rows affected
250 RUN SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx%'
251 Variable_name Value
252 Mysqlx_stmt_execute_mysqlx 3
253 0 rows affected
254 RUN SHOW STATUS like 'Mysqlx_crud_insert%'
255 Variable_name Value
256 Mysqlx_crud_insert 2
257 0 rows affected
258 RUN SHOW STATUS like 'Mysqlx_stmt_list_objects%'
259 Variable_name Value
260 Mysqlx_stmt_list_objects 2
261 0 rows affected
262 Mysqlx.Ok {
263 msg: "bye!"
264 }
265 ok
266 DROP DATABASE xplugintest;
267 DROP DATABASE xplugintest_1;
268 CREATE TABLE `scalar_types`(`number_uint` INTEGER UNSIGNED DEFAULT 10, `number_sint` INTEGER DEFAULT -10, `value_bool` BOOLEAN DEFAULT 0, `value_string` VARCHAR(255) default NULL, `number_float` FLOAT DEFAULT 1.1, `number_double` DOUBLE DEFAULT 2.2, `value_blob` TINYBLOB DEFAULT NULL);
269 RUN SHOW STATUS like 'Mysqlx_stmt_create_collection'
270 Variable_name Value
271 Mysqlx_stmt_create_collection 0
272 0 rows affected
273 RUN SHOW STATUS like 'Mysqlx_stmt_create_collection_index%'
274 Variable_name Value
275 Mysqlx_stmt_create_collection_index 0
276 0 rows affected
277 RUN SHOW STATUS like 'Mysqlx_rows_sent%'
278 Variable_name Value
279 Mysqlx_rows_sent 2
280 0 rows affected
281 RUN SHOW STATUS like 'Mysqlx_bytes_sent'
282 Variable_name Value
283 Mysqlx_bytes_sent 828
284 0 rows affected
285
286 command ok
287 Command is valid but returns error so its counted in status variable
288 Got expected error: Invalid collection name (code 5113)
289 Parse error , so its not counted in status variable
290 send Mysqlx.Sql.StmtExecute {
291 stmt: "create_collection"
292 }
293
294 Mysqlx.Error {
295 severity: ERROR
296 code: 1064
297 msg: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'create_collection\' at line 1"
298 sql_state: "42000"
299 }
300
301 "Index with unique(true), index column NOT NULL (true)" counted in index status variable
302 Mysqlx.Sql.StmtExecuteOk {
303 }
304
305 Command is parsed , returns error. Counted in status variable
306 Mysqlx.Error {
307 severity: ERROR
308 code: 5113
309 msg: "Invalid collection name: xplugintest.table_non_existing"
310 sql_state: "HY000"
311 }
312
313 Invalid index command. Not able to parse so not counted in status variable
314 send Mysqlx.Sql.StmtExecute {
315 stmt: "create_collection_index"
316 }
317
318 Mysqlx.Error {
319 severity: ERROR
320 code: 1064
321 msg: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'create_collection_index\' at line 1"
322 sql_state: "42000"
323 }
324
325 "Create table table3 in xplugintest "
326
327 command ok
328 send Mysqlx.Sql.StmtExecute {
329 stmt: "INSERT INTO `xplugintest`.`scalar_types`(`number_sint`, `number_uint`, `value_string`) VALUES(0, ?, \'First inserted row\'),(?, 1,\'Second inserted row\'), (-1, 0,?)"
330 args {
331 type: SCALAR
332 scalar {
333 type: V_UINT
334 v_unsigned_int: 1
335 }
336 }
337 args {
338 type: SCALAR
339 scalar {
340 type: V_SINT
341 v_signed_int: -1
342 }
343 }
344 args {
345 type: SCALAR
346 scalar {
347 type: V_STRING
348 v_string {
349 value: "\"Thrid\" inserted \'row\'"
350 }
351 }
352 }
353 }
354
355
356 3 rows affected
357 Records: 3 Duplicates: 0 Warnings: 0
358 send Mysqlx.Sql.StmtExecute {
359 stmt: "INSERT INTO `xplugintest`.`scalar_types`(`number_float`, `number_double`, `value_blob`) VALUES(0.1, ?, \'First inserted blob\'),(?, 200.01,\'Second inserted blob\'), (10.11, 2.2, ?), (111, 222, ?)"
360 args {
361 type: SCALAR
362 scalar {
363 type: V_DOUBLE
364 v_double: 200.01
365 }
366 }
367 args {
368 type: SCALAR
369 scalar {
370 type: V_DOUBLE
371 v_double: 10.11
372 }
373 }
374 args {
375 type: SCALAR
376 scalar {
377 type: V_STRING
378 v_string {
379 value: "\"Thrid\" inserted \'blob\'"
380 }
381 }
382 }
383 args {
384 type: SCALAR
385 scalar {
386 type: V_NULL
387 }
388 }
389 }
390
391
392 4 rows affected
393 Records: 4 Duplicates: 0 Warnings: 0
394 RUN USE xplugintest
395
396 0 rows affected
397 RUN SHOW STATUS like 'Mysqlx_stmt_create_collection'
398 Variable_name Value
399 Mysqlx_stmt_create_collection 3
400 0 rows affected
401 RUN CREATE TABLE `table4` (`number_uint` INTEGER UNSIGNED DEFAULT 10, `number_sint` INTEGER DEFAULT -10, `value_bool` BOOLEAN DEFAULT 0, `value_string` VARCHAR(255) default NULL, `number_float` FLOAT DEFAULT 1.1, `number_double` DOUBLE DEFAULT 2.2, `value_blob` TINYBLOB DEFAULT NULL)
402
403 0 rows affected
404 RUN ALTER TABLE xplugintest.table4 ADD FULLTEXT INDEX `fulltext_idx_1` (value_string)
405
406 0 rows affected
407 Records: 0 Duplicates: 0 Warnings: 1
408 RUN SHOW STATUS like 'Mysqlx_stmt_create_collection'
409 Variable_name Value
410 Mysqlx_stmt_create_collection 3
411 0 rows affected
412 RUN SHOW STATUS like 'Mysqlx_stmt_create_collection_index%'
413 Variable_name Value
414 Mysqlx_stmt_create_collection_index 2
415 0 rows affected
416 RUN SHOW STATUS like 'Mysqlx_rows_sent%'
417 Variable_name Value
418 Mysqlx_rows_sent 7
419 0 rows affected
420 RUN SHOW STATUS like 'Mysqlx_bytes_sent'
421 Variable_name Value
422 Mysqlx_bytes_sent 2983
423 0 rows affected
424 Filter data by unsigned int
425 send Mysqlx.Sql.StmtExecute {
426 stmt: "SELECT * FROM `xplugintest`.`scalar_types` WHERE `number_uint`=?"
427 args {
428 type: SCALAR
429 scalar {
430 type: V_UINT
431 v_unsigned_int: 1
432 }
433 }
434 }
435
436 number_uint number_sint value_bool value_string number_float number_double value_blob
437 1 0 0 First inserted row 1.1 2.2 null
438 1 -1 0 Second inserted row 1.1 2.2 null
439 0 rows affected
440 Filter data by signed int
441 send Mysqlx.Sql.StmtExecute {
442 stmt: "SELECT * FROM `xplugintest`.`scalar_types` WHERE `number_sint`=?"
443 args {
444 type: SCALAR
445 scalar {
446 type: V_SINT
447 v_signed_int: -1
448 }
449 }
450 }
451
452 number_uint number_sint value_bool value_string number_float number_double value_blob
453 1 -1 0 Second inserted row 1.1 2.2 null
454 0 -1 0 "Thrid" inserted 'row' 1.1 2.2 null
455 0 rows affected
456 RUN SHOW STATUS like 'Mysqlx_stmt_create_collection'
457 Variable_name Value
458 Mysqlx_stmt_create_collection 3
459 0 rows affected
460 RUN SHOW STATUS like 'Mysqlx_stmt_create_collection_index%'
461 Variable_name Value
462 Mysqlx_stmt_create_collection_index 2
463 0 rows affected
464 RUN SHOW STATUS like 'Mysqlx_rows_sent%'
465 Variable_name Value
466 Mysqlx_rows_sent 15
467 0 rows affected
468 RUN SHOW STATUS like 'Mysqlx_bytes_sent'
469 Variable_name Value
470 Mysqlx_bytes_sent 5432
471 0 rows affected
472 RUN SHOW STATUS like 'Mysqlx_stmt_drop_collection'
473 Variable_name Value
474 Mysqlx_stmt_drop_collection 0
475 0 rows affected
476 RUN SHOW STATUS like 'Mysqlx_stmt_drop_collection_index%'
477 Variable_name Value
478 Mysqlx_stmt_drop_collection_index 0
479 0 rows affected
480 RUN SHOW STATUS like 'Mysqlx_stmt_ping%'
481 Variable_name Value
482 Mysqlx_stmt_ping 0
483 0 rows affected
484 # drop index counted in status variable
485 Mysqlx.Sql.StmtExecuteOk {
486 }
487
488 "drop index with error counted in status variable"
489 Mysqlx.Error {
490 severity: ERROR
491 code: 1091
492 msg: "Can\'t DROP \'non_existing_index\'; check that column/key exists"
493 sql_state: "42000"
494 }
495
496 "Parse error not counted in status variable"
497 send Mysqlx.Sql.StmtExecute {
498 stmt: "drop_collection_index"
499 }
500
501 Mysqlx.Error {
502 severity: ERROR
503 code: 1064
504 msg: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'drop_collection_index\' at line 1"
505 sql_state: "42000"
506 }
507
508 # drop collection , index sql not counted in status variable
509 RUN DROP TABLE xplugintest.table3
510
511 0 rows affected
512 RUN ALTER TABLE xplugintest.table4 DROP INDEX `fulltext_idx_1`
513
514 0 rows affected
515 Records: 0 Duplicates: 0 Warnings: 0
516 "Drop table created using create_collection message"
517
518 command ok
519 "Non existing Drop table counted in status variable"
520 Got expected error: Unknown table 'xplugintest.table_non_existing' (code 1051)
521 "Drop table parse error NOT counted in status variable"
522 send Mysqlx.Sql.StmtExecute {
523 stmt: "drop_collection"
524 }
525
526 Mysqlx.Error {
527 severity: ERROR
528 code: 1064
529 msg: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'drop_collection\' at line 1"
530 sql_state: "42000"
531 }
532
533 "Drop table created using create_collection message"
534
535 command ok
536 RUN SHOW STATUS like 'Mysqlx_stmt_drop_collection'
537 Variable_name Value
538 Mysqlx_stmt_drop_collection 3
539 0 rows affected
540 RUN SHOW STATUS like 'Mysqlx_stmt_drop_collection_index%'
541 Variable_name Value
542 Mysqlx_stmt_drop_collection_index 2
543 0 rows affected
544 Mysqlx.Sql.StmtExecuteOk {
545 }
546
547 send Mysqlx.Sql.StmtExecute {
548 stmt: "ping"
549 namespace: "bla"
550 }
551
552 Mysqlx.Error {
553 severity: ERROR
554 code: 5162
555 msg: "Unknown namespace bla"
556 sql_state: "HY000"
557 }
558
559 Mysqlx.Sql.StmtExecuteOk {
560 }
561
562 RUN SHOW STATUS like 'Mysqlx_stmt_ping%'
563 Variable_name Value
564 Mysqlx_stmt_ping 2
565 0 rows affected
566 Check - expect.open and expect.close status variable
567 RUN SHOW STATUS like 'Mysqlx_expect_close%'
568 Variable_name Value
569 Mysqlx_expect_close 0
570 0 rows affected
571 RUN SHOW STATUS like 'Mysqlx_expect_open%'
572 Variable_name Value
573 Mysqlx_expect_open 0
574 0 rows affected
575 send Mysqlx.Expect.Open {
576 cond {
577 condition_key: 1
578 }
579 }
580
581 Mysqlx.Ok {
582 }
583
584 send Mysqlx.Expect.Open {
585 }
586
587 Mysqlx.Ok {
588 }
589
590 RUN SHOW STATUS like 'Mysqlx_expect_close%'
591 Variable_name Value
592 Mysqlx_expect_close 0
593 0 rows affected
594 RUN SHOW STATUS like 'Mysqlx_expect_open%'
595 Variable_name Value
596 Mysqlx_expect_open 2
597 0 rows affected
598 send Mysqlx.Expect.Close {
599 }
600
601 Mysqlx.Ok {
602 }
603
604 RUN SHOW STATUS like 'Mysqlx_expect_close%'
605 Variable_name Value
606 Mysqlx_expect_close 1
607 0 rows affected
608 RUN SHOW STATUS like 'Mysqlx_expect_open%'
609 Variable_name Value
610 Mysqlx_expect_open 2
611 0 rows affected
612 send Mysqlx.Expect.Close {
613 }
614
615 Mysqlx.Ok {
616 }
617
618 RUN SHOW STATUS like 'Mysqlx_expect_close%'
619 Variable_name Value
620 Mysqlx_expect_close 2
621 0 rows affected
622 RUN SHOW STATUS like 'Mysqlx_expect_open%'
623 Variable_name Value
624 Mysqlx_expect_open 2
625 0 rows affected
626 Mysqlx.Ok {
627 msg: "bye!"
628 }
629 ok
630 DROP DATABASE xplugintest;
631 DROP DATABASE xplugintest_1;