MDEV-16294: postfix - INSTALL PLUGIN IF NOT EXISTS

Fix also UNINSTALL SONAME IF EXISTS

Complete test case to INSTALL/UNINSTALL errors are generated

1 files changed, 30 insertions, 7 deletions

diff --git a/mysql-test/main/plugin.test b/mysql-test/main/plugin.test
index 3dad1ab2f73..ca33516fc85 100644
--- a/mysql-test/main/plugin.test
+++ b/mysql-test/main/plugin.test
@@ -272,15 +272,38 @@ DROP TABLE t1;
 --echo #
 --echo #
 
-select plugin_name from information_schema.plugins where plugin_library like 'ha_example%';
+select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
+INSTALL PLUGIN IF NOT EXISTS example SONAME 'ha_example';
+select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
+
+--replace_regex /\.dll/.so/
+--error ER_PLUGIN_INSTALLED
+INSTALL PLUGIN example SONAME 'ha_example';
+
 INSTALL PLUGIN IF NOT EXISTS example SONAME 'ha_example';
-select plugin_name from information_schema.plugins where plugin_library like 'ha_example%';
-INSTALL PLUGIN IF NOT EXISTS EXAMPLE SONAME 'ha_example';
-SHOW WARNINGS;
-INSTALL SONAME IF NOT EXISTS 'ha_example';
 SHOW WARNINGS;
+
 UNINSTALL PLUGIN IF EXISTS example;
-select plugin_name from information_schema.plugins where plugin_library like 'ha_example%';
+select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
+
+UNINSTALL PLUGIN IF EXISTS example;
+SHOW WARNINGS;
+
+--error 1305
+UNINSTALL PLUGIN example;
+
+INSTALL SONAME IF NOT EXISTS 'ha_example';
+
+select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
+
+# note: installing soname multiple times doesn't cause errors or warnings
+INSTALL SONAME IF NOT EXISTS 'ha_example';
+
+UNINSTALL SONAME IF EXISTS 'ha_example';
+
 UNINSTALL SONAME IF EXISTS 'ha_example';
 SHOW WARNINGS;
-select plugin_name from information_schema.plugins where plugin_library like 'ha_example%';
+select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
+
+--error 1305
+UNINSTALL SONAME 'ha_example';