mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
41 lines
1.1 KiB
Text
41 lines
1.1 KiB
Text
--source include/not_embedded.inc
|
|
--source include/have_example_plugin.inc
|
|
|
|
--echo #
|
|
--echo # Bug#51770: UNINSTALL PLUGIN requires no privileges
|
|
--echo #
|
|
|
|
CREATE USER bug51770@localhost;
|
|
GRANT INSERT ON mysql.plugin TO bug51770@localhost;
|
|
connect(con1,localhost,bug51770,,);
|
|
--replace_regex /\.dll/.so/
|
|
eval INSTALL PLUGIN example SONAME '$HA_EXAMPLE_SO';
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
UNINSTALL PLUGIN example;
|
|
connection default;
|
|
GRANT DELETE ON mysql.plugin TO bug51770@localhost;
|
|
connection con1;
|
|
UNINSTALL PLUGIN example;
|
|
disconnect con1;
|
|
connection default;
|
|
DROP USER bug51770@localhost;
|
|
|
|
#
|
|
# BUG#58246: INSTALL PLUGIN not secure & crashable
|
|
#
|
|
# The bug consisted of not recognizing / on Windows, so checking / on
|
|
# all platforms should cover this case.
|
|
|
|
let $path = `select CONCAT_WS('/', '..', '$HA_EXAMPLE_SO')`;
|
|
--replace_regex /\.dll/.so/
|
|
--error ER_UDF_NO_PATHS
|
|
eval INSTALL PLUGIN example SONAME '$path';
|
|
|
|
#
|
|
# Bug#27302459: EMPTY VALUE IN MYSQL.PLUGIN TABLE CAUSES SERVER TO EXIT ON STARTUP
|
|
#
|
|
insert mysql.plugin values ();
|
|
source include/restart_mysqld.inc;
|
|
delete from mysql.plugin where name = '';
|
|
|
|
--echo # End of 5.5 tests
|