Debian Codegraph @

mysql-test/suite/x/t/stmtexecute_query_result.test

raw
1 ## generated
2 ## Test query with resultset
3
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6 ## Test starts here
7 --write_file $MYSQL_TMP_DIR/stmtexecute_query_result.xpl
8 ## Test data
9 -->sql
10 drop schema if exists xtest;
11 create schema xtest;
12 use xtest;
13 create table mytable (pk int primary key auto_increment, data varchar(100));
14 delimiter //
15 create procedure result_and_error ()
16 begin
17 select 1;
18 select * from invalid_table;
19 end//
20 -->endsql
21 Mysqlx.Sql.StmtExecute {
22 stmt: "insert into mytable values (DEFAULT, \'one\')"
23 }
24
25 ## expect Mysqlx.Sql.StmtExecuteOk
26 -->recvresult
27 Mysqlx.Sql.StmtExecute {
28 stmt: "insert into mytable values (DEFAULT, \'two\')"
29 }
30
31 ## expect Mysqlx.Sql.StmtExecuteOk
32 -->recvresult
33 Mysqlx.Sql.StmtExecute {
34 stmt: "insert into mytable values (DEFAULT, \'three\')"
35 }
36
37 ## expect Mysqlx.Sql.StmtExecuteOk
38 -->recvresult
39 Mysqlx.Sql.StmtExecute {
40 stmt: "select * from mytable"
41 }
42
43 ## expect Mysqlx.Resultset.ColumnMetaData
44 -->recv
45 ## expect Mysqlx.Resultset.ColumnMetaData
46 -->recv
47 ## expect Mysqlx.Resultset.Row
48 -->recv
49 ## expect Mysqlx.Resultset.Row
50 -->recv
51 ## expect Mysqlx.Resultset.Row
52 -->recv
53 ## expect Mysqlx.Resultset.FetchDone
54 -->recv
55 ## expect Notice
56 -->recv
57 ## expect Mysqlx.Sql.StmtExecuteOk
58 -->recv
59
60 ## Cleanup
61 -->sql
62 drop schema if exists xtest;
63 -->endsql
64 EOF
65
66 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/stmtexecute_query_result.xpl 2>&1
67
68 ## Cleanup
69 --source ../include/xplugin_cleanup.inc