diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-04 17:01:00 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-04 17:01:00 +0200 |
| commit | a2fc36989e13c6f322fd22791f67e0d1275461d7 (patch) | |
| tree | 9cba675c50883e2e45c61a94b631d8875d16ddf9 /mysql-test/main/create_drop_role.test | |
| parent | 82da98556cf58f0fbb43c82e9c6ae1a887b6cf3d (diff) | |
| parent | 74d648db12e100c628548fb2e5aa67de718bd1fb (diff) | |
| download | mariadb-git-a2fc36989e13c6f322fd22791f67e0d1275461d7.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/create_drop_role.test')
| -rw-r--r-- | mysql-test/main/create_drop_role.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/create_drop_role.test b/mysql-test/main/create_drop_role.test index be33083e6c4..11bc832c6e9 100644 --- a/mysql-test/main/create_drop_role.test +++ b/mysql-test/main/create_drop_role.test @@ -54,3 +54,14 @@ DROP ROLE IF EXISTS role_1; DROP ROLE role_1; DROP USER u1@localhost; + +# MDEV-17942 +CREATE ROLE r; +GRANT SHOW DATABASES ON *.* TO r; +CREATE USER foo; +CREATE USER bar; +GRANT r TO foo; +--error ER_PLUGIN_IS_NOT_LOADED +CREATE OR REPLACE USER foo IDENTIFIED WITH non_existing_plugin; +DROP ROLE r; +DROP USER bar; |