1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
include/save_binlog_position.inc
# ----------------------------------------------------------------------
# Begin : Tests for CREATE ROLE
CREATE USER userX;
CREATE ROLE roleX;
include/save_binlog_position.inc
# Case 1 : Execute CREATE ROLE for existing users
CREATE ROLE userZ, roleZ, userX, roleX;
ERROR HY000: Operation CREATE ROLE failed for 'userX'@'%','roleX'@'%'
# Must not show entries for userZ and roleZ
SELECT user FROM mysql.user WHERE user LIKE 'user%';
user
userX
SELECT user FROM mysql.user WHERE user LIKE 'role%';
user
roleX
# This event sequence pattern MUST NOT be present in binlog: !Q(CREATE ROLE.*userZ.*roleZ.*userX.*roleX.*)
include/assert_binlog_events.inc
include/save_binlog_position.inc
# Case 2 : Execute CREATE ROLE for non-existing users
CREATE ROLE roleZ, roleA;
# Must show entry for roleZ, roleA
SELECT user FROM mysql.user WHERE user LIKE 'role%';
user
roleA
roleX
roleZ
# This event sequence pattern MUST be present in binlog: !Q(CREATE ROLE.*roleZ.*roleA.*)
include/assert_binlog_events.inc
DROP USER userX;
DROP ROLE roleX, roleZ, roleA;
include/save_binlog_position.inc
# End : Tests for CREATE ROLE
# ----------------------------------------------------------------------
# Begin : Tests for CREATE ROLE IF NOT EXISTS
CREATE ROLE roleX;
include/save_binlog_position.inc
# Case 1 : Execute CREATE ROLE IF NOT EXISTS for exising and non-existing users
CREATE ROLE IF NOT EXISTS roleX, roleY, roleZ;
Warnings:
Note 3163 Authorization ID 'roleX'@'%' already exists.
# Must show entry for roleY and roleZ
SELECT user FROM mysql.user WHERE user LIKE 'role%';
user
roleX
roleY
roleZ
# This event sequence pattern MUST be present in binlog: !Q(CREATE ROLE IF NOT EXISTS.*roleX.*roleY.*roleZ.*)
include/assert_binlog_events.inc
include/save_binlog_position.inc
# case 2 : Execute CREATE ROLE IF NOT EXISTS for existing users
CREATE ROLE IF NOT EXISTS roleX, roleY, roleZ;
Warnings:
Note 3163 Authorization ID 'roleX'@'%' already exists.
Note 3163 Authorization ID 'roleY'@'%' already exists.
Note 3163 Authorization ID 'roleZ'@'%' already exists.
# This event sequence pattern MUST be present in binlog: !Q(CREATE ROLE IF NOT EXISTS.*roleX.*roleY.*roleZ.*)
include/assert_binlog_events.inc
DROP ROLE roleX, roleY, roleZ;
include/save_binlog_position.inc
# End : Tests for CREATE ROLE IF NOT EXISTS
# ----------------------------------------------------------------------
|
