1#
2# replication of the DEFINER=current_role
3#
4
5--source include/master-slave.inc
6
7create role role1;
8create role role2;
9grant execute on test.* to role2;
10grant role2 to role1;
11set role role1;
12--sorted_result
13show grants;
14
15create definer=current_user procedure pcu() select current_user;
16create definer=root@localhost procedure pu() select "root@localhost";
17create definer=current_role procedure pcr() select current_role;
18create definer=role1 procedure pr() select "role1";
19
20show create procedure pcu;
21show create procedure pu;
22show create procedure pcr;
23show create procedure pr;
24
25sync_slave_with_master;
26
27set role role1;
28--sorted_result
29show grants;
30
31show create procedure pcu;
32show create procedure pu;
33show create procedure pcr;
34show create procedure pr;
35
36connection master;
37
38drop procedure pcu;
39drop procedure pu;
40drop procedure pcr;
41drop procedure pr;
42drop role role1;
43drop role role2;
44
45--source include/rpl_end.inc
46
47