Debian Codegraph @

mysql-test/suite/auth_sec/t/atomic_create_role.test

raw
1 --source include/have_log_bin.inc
2 --source include/save_binlog_position.inc
3
4 # Save the initial number of concurrent sessions
5 --source include/count_sessions.inc
6
7 --echo # ----------------------------------------------------------------------
8
9 --echo # Begin : Tests for CREATE ROLE
10
11 CREATE USER userX;
12 CREATE ROLE roleX;
13 --source include/save_binlog_position.inc
14
15 --echo # Case 1 : Execute CREATE ROLE for existing users
16
17 --error ER_CANNOT_USER
18 CREATE ROLE userZ, roleZ, userX, roleX;
19
20 --echo # Must not show entries for userZ and roleZ
21 SELECT user FROM mysql.user WHERE user LIKE 'user%';
22 SELECT user FROM mysql.user WHERE user LIKE 'role%';
23
24 --let $invert= 1
25 --let $event= !Q(CREATE ROLE.*userZ.*roleZ.*userX.*roleX.*)
26 --source ../include/auth_sec_assert_binlog_events.inc
27 --let $invert= 0
28 --source include/save_binlog_position.inc
29
30 --echo # Case 2 : Execute CREATE ROLE for non-existing users
31
32 CREATE ROLE roleZ, roleA;
33
34 --echo # Must show entry for roleZ, roleA
35 SELECT user FROM mysql.user WHERE user LIKE 'role%';
36
37 --let $event= !Q(CREATE ROLE.*roleZ.*roleA.*)
38 --source ../include/auth_sec_assert_binlog_events.inc
39
40 DROP USER userX;
41 DROP ROLE roleX, roleZ, roleA;
42 --source include/save_binlog_position.inc
43
44 --echo # End : Tests for CREATE ROLE
45
46 --echo # ----------------------------------------------------------------------
47
48 --echo # Begin : Tests for CREATE ROLE IF NOT EXISTS
49
50 CREATE ROLE roleX;
51 --source include/save_binlog_position.inc
52
53 --echo # Case 1 : Execute CREATE ROLE IF NOT EXISTS for exising and non-existing users
54
55 CREATE ROLE IF NOT EXISTS roleX, roleY, roleZ;
56
57 --echo # Must show entry for roleY and roleZ
58 SELECT user FROM mysql.user WHERE user LIKE 'role%';
59
60 --let $event= !Q(CREATE ROLE IF NOT EXISTS.*roleX.*roleY.*roleZ.*)
61 --source ../include/auth_sec_assert_binlog_events.inc
62 --source include/save_binlog_position.inc
63
64 --echo # case 2 : Execute CREATE ROLE IF NOT EXISTS for existing users
65
66 CREATE ROLE IF NOT EXISTS roleX, roleY, roleZ;
67
68 --let $event= !Q(CREATE ROLE IF NOT EXISTS.*roleX.*roleY.*roleZ.*)
69 --source ../include/auth_sec_assert_binlog_events.inc
70
71 DROP ROLE roleX, roleY, roleZ;
72 --source include/save_binlog_position.inc
73 --echo # End : Tests for CREATE ROLE IF NOT EXISTS
74
75 --echo # ----------------------------------------------------------------------
76
77 # Wait till we reached the initial number of concurrent sessions
78 --source include/wait_until_count_sessions.inc