Debian Codegraph @

mysql-test/suite/rpl/t/rpl_create_drop_role.test

raw
1 --source include/master-slave.inc
2
3 connection master;
4 CREATE ROLE role_1;
5 sync_slave_with_master;
6
7 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
8
9 connection master;
10 CREATE ROLE IF NOT EXISTS role_1;
11 CREATE ROLE IF NOT EXISTS role_2;
12 sync_slave_with_master;
13
14 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
15
16 connection master;
17
18 --error ER_WRONG_USAGE
19 CREATE OR REPLACE ROLE IF NOT EXISTS role_3;
20
21 CREATE OR REPLACE ROLE role_3;
22 CREATE OR REPLACE ROLE role_2;
23 sync_slave_with_master;
24
25 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
26
27 connection master;
28 --error ER_CANNOT_USER
29 CREATE ROLE role_2;
30
31 sync_slave_with_master;
32
33 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
34
35 connection master;
36 DROP ROLE role_1;
37 DROP ROLE IF EXISTS role_2;
38 DROP ROLE IF EXISTS role_3;
39 DROP ROLE IF EXISTS role_4;
40
41 --error ER_CANNOT_USER
42 DROP ROLE role_4;
43
44 sync_slave_with_master;
45
46 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
47
48 --source include/rpl_end.inc