diff options
Diffstat (limited to 'mysql-test/suite/roles/rename_user.result')
| -rw-r--r-- | mysql-test/suite/roles/rename_user.result | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/suite/roles/rename_user.result b/mysql-test/suite/roles/rename_user.result new file mode 100644 index 00000000..367f6e4b --- /dev/null +++ b/mysql-test/suite/roles/rename_user.result @@ -0,0 +1,36 @@ +create user test_user@localhost; +create role test_role1; +grant test_role1 to test_user@localhost; +create role test_role2; +grant test_role2 to test_role1; +use mysql; +select * from roles_mapping; +Host User Role Admin_option + test_role1 test_role2 N +localhost root test_role1 Y +localhost root test_role2 Y +localhost test_user test_role1 N +rename user 'test_user'@'localhost' to 'test_user_rm'@'newhost'; +select user, host from user where user like 'test%'; +User Host +test_role1 +test_role2 +test_user_rm newhost +select * from roles_mapping; +Host User Role Admin_option + test_role1 test_role2 N +localhost root test_role1 Y +localhost root test_role2 Y +newhost test_user_rm test_role1 N +delete from mysql.roles_mapping; +delete from mysql.user where user like 'test%'; +flush privileges; +# +# MDEV-29131 Assertion `status == 0' failed when renaming user after deleting table roles_mapping +# +create role r; +rename table mysql.roles_mapping to test.t1; +rename user current_user to a@a; +rename user a@a to root@localhost; +rename table test.t1 to mysql.roles_mapping; +drop role r; |