1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
------ Run plugin ------------------------------------------------
INSTALL PLUGIN test_services_command_services SONAME 'TEST_SERVICES_COMMAND_SERVICES_PLUGIN';
------ Show status of plugin -------------------------------------
SELECT PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS
WHERE PLUGIN_NAME='test_services_command_services';
PLUGIN_STATUS
ACTIVE
# Test : must return '2' the output of SELECT 1+1;
SELECT test_command_service_udf("select 1+1");
test_command_service_udf("select 1+1")
2
# Test : must return '2.5' the output of SELECT 1.3+1.2;
SELECT test_command_service_udf("select 1.3+1.2");
test_command_service_udf("select 1.3+1.2")
2.5
# Test : must return error message
SELECT test_command_service_udf("SELECT * FROM mysql.plugin ORDER BY name");
ERROR HY000: Error in command service backend interface, because of : "SELECT command denied to user 'mysql.session'@'localhost' for table 'plugin'"
SELECT test_command_service_udf();
test_command_service_udf()
NULL
------ Stop plugin -----------------------------------------------
UNINSTALL PLUGIN test_services_command_services;
|
