------ 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;