Debian Codegraph @

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

raw
1 ## generated
2 ## Test query with no 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_no_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
40 ## Cleanup
41 -->sql
42 drop schema if exists xtest;
43 -->endsql
44 EOF
45
46 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/stmtexecute_query_no_result.xpl 2>&1
47
48 ## Cleanup
49 --source ../include/xplugin_cleanup.inc