[Maria-discuss] install plugin “if not installed”?
Hello,
Is there any way to install a plugin via SQL but to trap the error that comes up if the plugin is already installed?
I’d like to do it without creating a “throwaway” procedure, if that’s possible.
Thank you!
-Felipe Gasper Mississauga, Ontario
Hi, Felipe!
On Mar 29, Felipe Gasper wrote:
Hello,
Is there any way to install a plugin via SQL but to trap the error that comes up if the plugin is already installed?
I’d like to do it without creating a “throwaway” procedure, if that’s possible.
Yes. There's more than one way to do it:
* INSTALL PLUGIN IF NOT EXISTS is available since 10.4.0
* INSTALL SONAME doesn't error out if the plugin is installed
* compound statements offer a generic way to avoid a throwaway procedure:
BEGIN NOT ATOMIC DECLARE EXIT HANDLER FOR 1968 DO 1 INSTALL PLUGIN ... END
or
IF NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME='...') THEN INSTALL PLUGIN ...; END IF
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
participants (2)
-
Felipe Gasper
-
Sergei Golubchik