Debian Codegraph @

mysql-test/suite/roles/rename_user.test

raw
1 source include/not_embedded.inc;
2
3 #create a user with no privileges
4 create user test_user@localhost;
5 create role test_role1;
6 grant test_role1 to test_user@localhost;
7 create role test_role2;
8 grant test_role2 to test_role1;
9
10 use mysql;
11 --sorted_result
12 select * from roles_mapping;
13
14 #regular user rename
15 rename user 'test_user'@'localhost' to 'test_user_rm'@'newhost';
16 --sorted_result
17 select user, host from user where user like 'test%';
18 --sorted_result
19 select * from roles_mapping;
20
21 ######### role rename does not work yet
22 #rename user 'test_role2'@'' to 'test_role2_rm'@'';
23 #--sorted_result
24 #select user, host from user where user like 'test%';
25 #--sorted_result
26 #select * from roles_mapping;
27 #
28 ##role rename
29 #rename user 'test_role1'@'' to 'test_role1_rm'@'';
30 #--sorted_result
31 #select user, host from user where user like 'test%';
32 #--sorted_result
33 #select * from roles_mapping;
34
35 delete from mysql.roles_mapping;
36 delete from mysql.user where user like 'test%';
37 flush privileges;
38
39 --echo #
40 --echo # MDEV-29131 Assertion `status == 0' failed when renaming user after deleting table roles_mapping
41 --echo #
42 create role r;
43 rename table mysql.roles_mapping to test.t1;
44 rename user current_user to a@a;
45 rename user a@a to root@localhost;
46 rename table test.t1 to mysql.roles_mapping;
47 drop role r;
48