rpl_slave_status.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- # Test case for BUG #10780
- --source include/master-slave.inc
- 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;
- connection master;
- --disable_warnings
- drop table if exists t1;
- --enable_warning
- create table t1 (n int);
- insert into t1 values (1);
- save_master_pos;
- connection slave;
- sync_with_master;
- select * from t1;
- connection master;
- delete from mysql.user where user='rpl';
- flush privileges;
- connection slave;
- stop slave;
- start slave;
- --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 #
- --vertical_results
- show slave status;
- # end of 4.1 tests