rpl_loaddata_rule_s.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- # See if the slave logs (in its own binlog, with --log-slave-updates) a
- # replicated LOAD DATA INFILE correctly when it has binlog_*_db rules.
- # This is for BUG#1100 (LOAD DATA INFILE was half-logged).
- source include/master-slave.inc;
- connection slave;
- reset master;
- connection master;
- # 'test' is the current database
- create table t1(a int, b int, unique(b));
- load data infile '../../std_data/rpl_loaddata.dat' into table test.t1;
- # Test logging on slave;
- save_master_pos;
- connection slave;
- sync_with_master;
- select count(*) from t1; # check that LOAD was replicated
- show binlog events from 79; # should be nothing
- # End of 4.1 tests