Debian Codegraph @

mysql-test/suite/auth_sec/t/atomic_drop_user.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 DROP USER
10
11 CREATE USER userX, userY, userZ;
12
13 DROP USER userZ;
14
15 --source include/save_binlog_position.inc
16
17 SELECT user from mysql.user WHERE user LIKE 'user%';
18
19 --echo # Case 1 : Try removing a non-existing user
20 --error ER_CANNOT_USER
21 DROP USER userX, userY, userZ;
22
23 --echo # Must show userX and userY
24 SELECT user FROM mysql.user WHERE user LIKE 'user%';
25 --let $invert= 1
26 --let $event= !Q(DROP USER.*userX.*userY.*userZ)
27 --source ../include/auth_sec_assert_binlog_events.inc
28 --let $invert= 0
29
30 --echo # Case 2 : DROP USER after deleting entry from mysql.user tables
31 DELETE FROM mysql.user WHERE user LIKE 'userY';
32
33 --source include/save_binlog_position.inc
34
35 --echo # Must succeed
36 DROP USER userX, userY;
37
38 --echo # Must not show any entries
39 SELECT user FROM mysql.user WHERE user LIKE 'user%';
40 --let $event= !Q(DROP USER.*userX.*userY.*)
41 --source ../include/auth_sec_assert_binlog_events.inc
42 --source include/save_binlog_position.inc
43
44 --echo # End : Tests for DROP USER
45
46 --echo # -----------------------------------------------------------------------
47
48 --echo # Begin : Tests for DROP USER IF EXISTS
49
50 CREATE USER userX, userY, userZ;
51 DROP USER userZ;
52
53 --source include/save_binlog_position.inc
54
55 --echo # Case 1 : DROP USER IF EXISTS for non-existing user
56 DROP USER IF EXISTS userX, userY, userZ;
57
58 --echo # Must not show any entries
59 SELECT user FROM mysql.user WHERE user LIKE 'user%';
60 --echo #check binlog : Must show DROP USER IF EXISTS as it is
61 --source ../include/auth_sec_assert_binlog_events.inc
62 --source include/save_binlog_position.inc
63
64 --echo # Case 2 : DROP USER IF EXISTS should be logged in binlog
65 --echo # even if non of the users were present.
66 DROP USER IF EXISTS userX, userY, userZ;
67 --source ../include/auth_sec_assert_binlog_events.inc
68 --source include/save_binlog_position.inc
69
70 --echo # End : Test for DROP USER IF EXISTS
71
72 --echo # -----------------------------------------------------------------------
73
74 # Wait till we reached the initial number of concurrent sessions
75 --source include/wait_until_count_sessions.inc