Debian Codegraph @

mysql-test/suite/rpl/r/rpl_create_drop_role.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE ROLE role_1;
5 connection slave;
6 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
7 User
8 role_1
9 connection master;
10 CREATE ROLE IF NOT EXISTS role_1;
11 Warnings:
12 Note 1975 Can't create role 'role_1'; it already exists
13 CREATE ROLE IF NOT EXISTS role_2;
14 connection slave;
15 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
16 User
17 role_1
18 role_2
19 connection master;
20 CREATE OR REPLACE ROLE IF NOT EXISTS role_3;
21 ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS
22 CREATE OR REPLACE ROLE role_3;
23 CREATE OR REPLACE ROLE role_2;
24 connection slave;
25 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
26 User
27 role_1
28 role_2
29 role_3
30 connection master;
31 CREATE ROLE role_2;
32 ERROR HY000: Operation CREATE ROLE failed for 'role_2'
33 connection slave;
34 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
35 User
36 role_1
37 role_2
38 role_3
39 connection master;
40 DROP ROLE role_1;
41 DROP ROLE IF EXISTS role_2;
42 DROP ROLE IF EXISTS role_3;
43 DROP ROLE IF EXISTS role_4;
44 Warnings:
45 Note 1976 Can't drop role 'role_4'; it doesn't exist
46 DROP ROLE role_4;
47 ERROR HY000: Operation DROP ROLE failed for 'role_4'
48 connection slave;
49 SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User;
50 User
51 include/rpl_end.inc