1Variable_name Value 2have_dynamic_loading YES 3### 4# Test for loading two plugins both with full path 5### 6SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'EXAMPLE'; 7COUNT(*) 81 9SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'test_plugin_server'; 10COUNT(*) 111 12SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'cleartext_plugin_server'; 13COUNT(*) 141 15### 16# Test for loading two plugins one with full path and another with 17# just filename 18### 19SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'EXAMPLE'; 20COUNT(*) 211 22SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'test_plugin_server'; 23COUNT(*) 241 25SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'cleartext_plugin_server'; 26COUNT(*) 271 28### 29# Test for loading the same plugin two times - both with path and 30# without one 31### 32SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'EXAMPLE'; 33COUNT(*) 341 35### 36# Test for loading plugins with 'INSTALL PLUGIN' 37### 38INSTALL PLUGIN example SONAME 'wrong_name.so'; 39INSTALL PLUGIN example SONAME 'EXAMPLE_PLUGIN_DIR/EXAMPLE_PLUGIN'; 40ERROR HY000: No paths allowed for shared library 41INSTALL PLUGIN test_plugin_server SONAME 'auth_test_plugin.so'; 42INSTALL PLUGIN cleartext_plugin_server SONAME 'auth_test_plugin.so'; 43SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'EXAMPLE'; 44COUNT(*) 450 46SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'test_plugin_server'; 47COUNT(*) 481 49SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'cleartext_plugin_server'; 50COUNT(*) 511 52UNINSTALL PLUGIN test_plugin_server; 53UNINSTALL PLUGIN cleartext_plugin_server; 54### 55# Test for path in UDF library loading 56### 57CREATE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB"; 58DROP FUNCTION metaphon; 59CREATE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB_DIR/UDF_EXAMPLE_LIB"; 60ERROR HY000: No paths allowed for shared library 61