Debian Codegraph @

mysql-test/suite/test_services/t/test_mysql_command_services_plugin.test

raw
1 --echo ------ Run plugin ------------------------------------------------
2 --replace_result $TEST_SERVICES_COMMAND_SERVICES_PLUGIN TEST_SERVICES_COMMAND_SERVICES_PLUGIN
3 eval INSTALL PLUGIN test_services_command_services SONAME '$TEST_SERVICES_COMMAND_SERVICES_PLUGIN';
4
5 --echo ------ Show status of plugin -------------------------------------
6 SELECT PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS
7 WHERE PLUGIN_NAME='test_services_command_services';
8
9 --echo # Test : must return '2' the output of SELECT 1+1;
10 SELECT test_command_service_udf("select 1+1");
11
12 --echo # Test : must return '2.5' the output of SELECT 1.3+1.2;
13 SELECT test_command_service_udf("select 1.3+1.2");
14
15 --echo # Test : must return error message
16 --error ER_COMMAND_SERVICE_BACKEND_FAILED
17 SELECT test_command_service_udf("SELECT * FROM mysql.plugin ORDER BY name");
18
19 SELECT test_command_service_udf();
20 --echo ------ Stop plugin -----------------------------------------------
21 UNINSTALL PLUGIN test_services_command_services;