Debian Codegraph @

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

raw
1 RUN drop schema if exists xtest
2
3 0 rows affected
4 RUN create schema xtest
5
6 1 rows affected
7 RUN use xtest
8
9 0 rows affected
10 RUN create table mytable (pk int primary key auto_increment, data varchar(100))
11
12 0 rows affected
13 RUN create procedure result_and_error ()
14 begin
15 select 1;
16 select * from invalid_table;
17 end
18
19 0 rows affected
20 send Mysqlx.Sql.StmtExecute {
21 stmt: "insert into mytable values (DEFAULT, \'one\')"
22 }
23
24
25 1 rows affected
26 last insert id: 1
27 send Mysqlx.Sql.StmtExecute {
28 stmt: "insert into mytable values (DEFAULT, \'two\')"
29 }
30
31
32 1 rows affected
33 last insert id: 2
34 send Mysqlx.Sql.StmtExecute {
35 stmt: "insert into mytable values (DEFAULT, \'three\')"
36 }
37
38
39 1 rows affected
40 last insert id: 3
41 RUN drop schema if exists xtest
42
43 1 rows affected
44 Mysqlx.Ok {
45 msg: "bye!"
46 }
47 ok