diff options
author | unknown <mats@mats-laptop.(none)> | 2008-05-15 21:04:13 +0200 |
---|---|---|
committer | unknown <mats@mats-laptop.(none)> | 2008-05-15 21:04:13 +0200 |
commit | 439cbe54cbbceaea54eb1227523cb885a16362d0 (patch) | |
tree | 46bb81f5803cf997aa92066b445669062669922b /mysql-test/suite/rpl/t/rpl_slave_status.test | |
parent | 4f706f3336f7e967216220e7b3e4ee785feec23c (diff) | |
parent | d2a75dc900fb45de27a749d030865e9f95f9e57b (diff) | |
download | mariadb-git-439cbe54cbbceaea54eb1227523cb885a16362d0.tar.gz |
Merge mats-laptop.(none):/home/bkroot/mysql-5.1-bugteam
into mats-laptop.(none):/home/bk/b36197-mysql-5.1-bugteam
Diffstat (limited to 'mysql-test/suite/rpl/t/rpl_slave_status.test')
-rw-r--r-- | mysql-test/suite/rpl/t/rpl_slave_status.test | 59 |
1 files changed, 0 insertions, 59 deletions
diff --git a/mysql-test/suite/rpl/t/rpl_slave_status.test b/mysql-test/suite/rpl/t/rpl_slave_status.test deleted file mode 100644 index 0b1644ab8a0..00000000000 --- a/mysql-test/suite/rpl/t/rpl_slave_status.test +++ /dev/null @@ -1,59 +0,0 @@ ---source include/master-slave.inc - -############################################################################ -# Test case for BUG#10780 -# -# REQUIREMENT -# A slave without replication privileges should have Slave_IO_Running = No - -# 1. Create new replication user -connection master; -grant replication slave on *.* to rpl@127.0.0.1 identified by 'rpl'; - -connection slave; -stop slave; -change master to master_user='rpl',master_password='rpl'; -start slave; - -# 2. Do replication as new user -connection master; ---disable_warnings -drop table if exists t1; ---enable_warnings -create table t1 (n int); -insert into t1 values (1); -save_master_pos; -connection slave; -sync_with_master; -select * from t1; - -# 3. Delete new replication user -connection master; -delete from mysql.user where user='rpl'; -flush privileges; -connection slave; - -# 4. Restart slave without privileges -# (slave.err will contain access denied error for this START SLAVE command) -stop slave; -start slave; - -# 5. Make sure Slave_IO_Running = No ---replace_result $MASTER_MYPORT MASTER_MYPORT -# Column 1 is replaced, since the output can be either -# "Connecting to master" or "Waiting for master update" ---replace_column 1 # 7 # 8 # 9 # 22 # 23 # 35 # 36 # ---vertical_results -show slave status; - -# Cleanup (Note that slave IO thread is not running) -connection slave; -drop table t1; -delete from mysql.user where user='rpl'; -# cleanup: slave io thread has been stopped "irrecoverably" -# so we clean up mess manually - -connection master; -drop table t1; - -# end of 4.1 tests |