Debian Codegraph @

mysql-test/suite/x/r/stmtexecute_query_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 send Mysqlx.Sql.StmtExecute {
42 stmt: "select * from mytable"
43 }
44
45 Mysqlx.Resultset.ColumnMetaData {
46 type: SINT
47 name: "pk"
48 original_name: "pk"
49 table: "mytable"
50 original_table: "mytable"
51 schema: "xtest"
52 catalog: "def"
53 length: 11
54 flags: 304
55 }
56
57 Mysqlx.Resultset.ColumnMetaData {
58 type: BYTES
59 name: "data"
60 original_name: "data"
61 table: "mytable"
62 original_table: "mytable"
63 schema: "xtest"
64 catalog: "def"
65 collation: 255
66 length: 400
67 }
68
69 Mysqlx.Resultset.Row {
70 field: "\002"
71 field: "one\000"
72 }
73
74 Mysqlx.Resultset.Row {
75 field: "\004"
76 field: "two\000"
77 }
78
79 Mysqlx.Resultset.Row {
80 field: "\006"
81 field: "three\000"
82 }
83
84 Mysqlx.Resultset.FetchDone {
85 }
86
87 Mysqlx.Notice.Frame {
88 type: 3
89 scope: LOCAL
90 payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n type: V_UINT\n v_unsigned_int: 0\n}\n }"
91 }
92
93 Mysqlx.Sql.StmtExecuteOk {
94 }
95
96 RUN drop schema if exists xtest
97
98 1 rows affected
99 Mysqlx.Ok {
100 msg: "bye!"
101 }
102 ok