mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
73 lines
1.9 KiB
Text
73 lines
1.9 KiB
Text
# BUG#33862 completely failed DROP USER statement gets replicated
|
|
|
|
--source include/master-slave.inc
|
|
|
|
#
|
|
# remove all users will be used in the test
|
|
#
|
|
connection master;
|
|
set session sql_log_bin=0;
|
|
delete from mysql.user where Host='fakehost';
|
|
set session sql_log_bin=1;
|
|
|
|
connection slave;
|
|
set session sql_log_bin=0;
|
|
delete from mysql.user where Host='fakehost';
|
|
set session sql_log_bin=1;
|
|
|
|
#
|
|
# Test create user
|
|
#
|
|
connection master;
|
|
create user 'foo'@'fakehost';
|
|
--error ER_CANNOT_USER
|
|
create user 'foo'@'fakehost', 'bar'@'fakehost';
|
|
--error ER_CANNOT_USER
|
|
create user 'foo'@'fakehost', 'bar'@'fakehost';
|
|
|
|
sync_slave_with_master;
|
|
select Host,User from mysql.user where Host='fakehost';
|
|
|
|
#
|
|
# Test rename user
|
|
#
|
|
connection master;
|
|
rename user 'foo'@'fakehost' to 'foofoo'@'fakehost';
|
|
--error ER_CANNOT_USER
|
|
rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'bar'@'fakehost' to 'barbar'@'fakehost';
|
|
--error ER_CANNOT_USER
|
|
rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'not_exist_user2'@'fakehost' to 'barfoo'@'fakehost';
|
|
|
|
sync_slave_with_master;
|
|
select Host,User from mysql.user where Host='fakehost';
|
|
|
|
#
|
|
# Test alter user
|
|
#
|
|
connection master;
|
|
alter user 'foofoo'@'fakehost' identified by 'foo';
|
|
--error ER_CANNOT_USER
|
|
alter user 'non_exist_user1'@'fakehost' identified by 'foo', 'barbar'@'fakehost' identified by 'bar';
|
|
--error ER_CANNOT_USER
|
|
alter user 'non_exist_user1'@'fakehost' identified by 'foo', 'non_exist_user2'@'fakehost' identified by 'bar';
|
|
sync_slave_with_master;
|
|
|
|
#
|
|
# Test drop user
|
|
#
|
|
connection master;
|
|
drop user 'foofoo'@'fakehost';
|
|
--error ER_CANNOT_USER
|
|
drop user 'not_exist_user1'@'fakehost', 'barbar'@'fakehost';
|
|
--error ER_CANNOT_USER
|
|
drop user 'not_exist_user1'@'fakehost', 'not_exist_user2'@'fakehost';
|
|
|
|
sync_slave_with_master;
|
|
select Host,User from mysql.user where Host='fakehost';
|
|
|
|
#
|
|
# show the binlog events on the master
|
|
#
|
|
connection master;
|
|
source include/show_binlog_events.inc;
|
|
--source include/rpl_end.inc
|