Debian Codegraph @

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

raw
1 # BUG#33862 completely failed DROP USER statement gets replicated
2
3 --source include/master-slave.inc
4
5 #
6 # remove all users will be used in the test
7 #
8 connection master;
9 set session sql_log_bin=0;
10 delete from mysql.user where Host='fakehost';
11 set session sql_log_bin=1;
12
13 connection slave;
14 set session sql_log_bin=0;
15 delete from mysql.user where Host='fakehost';
16 set session sql_log_bin=1;
17
18 #
19 # Test create user
20 #
21 connection master;
22 create user 'foo'@'fakehost';
23 --error ER_CANNOT_USER
24 create user 'foo'@'fakehost', 'bar'@'fakehost';
25 --error ER_CANNOT_USER
26 create user 'foo'@'fakehost', 'bar'@'fakehost';
27
28 sync_slave_with_master;
29 select Host,User from mysql.user where Host='fakehost';
30
31 #
32 # Test rename user
33 #
34 connection master;
35 rename user 'foo'@'fakehost' to 'foofoo'@'fakehost';
36 --error ER_CANNOT_USER
37 rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'bar'@'fakehost' to 'barbar'@'fakehost';
38 --error ER_CANNOT_USER
39 rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'not_exist_user2'@'fakehost' to 'barfoo'@'fakehost';
40
41 sync_slave_with_master;
42 select Host,User from mysql.user where Host='fakehost';
43
44 #
45 # Test alter user
46 #
47 connection master;
48 alter user 'foofoo'@'fakehost' identified by 'foo';
49 --error ER_CANNOT_USER
50 alter user 'non_exist_user1'@'fakehost' identified by 'foo', 'barbar'@'fakehost' identified by 'bar';
51 --error ER_CANNOT_USER
52 alter user 'non_exist_user1'@'fakehost' identified by 'foo', 'non_exist_user2'@'fakehost' identified by 'bar';
53 sync_slave_with_master;
54
55 #
56 # Test drop user
57 #
58 connection master;
59 drop user 'foofoo'@'fakehost';
60 --error ER_CANNOT_USER
61 drop user 'not_exist_user1'@'fakehost', 'barbar'@'fakehost';
62 --error ER_CANNOT_USER
63 drop user 'not_exist_user1'@'fakehost', 'not_exist_user2'@'fakehost';
64
65 sync_slave_with_master;
66 select Host,User from mysql.user where Host='fakehost';
67
68 #
69 # show the binlog events on the master
70 #
71 connection master;
72 source include/show_binlog_events.inc;
73 --source include/rpl_end.inc