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