1## Forbiddend sql commands
2
3## Preamble
4--source include/xplugin_preamble.inc
5--source include/xplugin_create_user.inc
6## Test starts here
7--write_file $MYSQL_TMP_DIR/forbidden_sql_cmd.tmp
8
9## Test data
10-->sql
11DROP SCHEMA IF EXISTS xtest;
12CREATE SCHEMA xtest;
13USE xtest;
14
15DROP PROCEDURE IF EXISTS xtest.uninstall_plugin;
16DROP PROCEDURE IF EXISTS xtest.install_plugin;
17DROP PROCEDURE IF EXISTS xtest.shutdown_server;
18
19DELIMITER //
20CREATE PROCEDURE xtest.uninstall_plugin()
21BEGIN
22UNINSTALL PLUGIN `mysqlx`;
23END
24//
25
26CREATE PROCEDURE xtest.install_plugin()
27BEGIN
28INSTALL PLUGIN `mysqlx` SONAME "$MYSQLXPLUGIN";
29END
30//
31
32CREATE PROCEDURE xtest.shutdown_server()
33BEGIN
34SHUTDOWN;
35END
36//
37DELIMITER ;
38
39-->endsql
40-->expecterror 3130
41-->sql
42UNINSTALL PLUGIN `mysqlx`;
43-->endsql
44-->expecterror 3130
45-->sql
46INSTALL PLUGIN `mysqlx` SONAME "$MYSQLXPLUGIN";
47-->endsql
48-->expecterror 3130
49-->sql
50SHUTDOWN;
51
52-->endsql
53-->expecterror 3130
54-->sql
55CALL xtest.uninstall_plugin();
56-->endsql
57-->expecterror 3130
58-->sql
59CALL xtest.install_plugin();
60-->endsql
61-->expecterror 3130
62-->sql
63CALL xtest.shutdown_server();
64-->endsql
65
66## Cleanup
67-->sql
68DROP SCHEMA IF EXISTS xtest;
69-->endsql
70EOF
71
72--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/forbidden_sql_cmd.tmp 2>&1
73
74## Cleanup
75--remove_file $MYSQL_TMP_DIR/forbidden_sql_cmd.tmp
76--source include/xplugin_drop_user.inc
77
78