Debian Codegraph @

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

raw
1 # See if the slave logs (in its own binlog, with --log-slave-updates) a
2 # replicated LOAD DATA INFILE correctly when it has binlog_*_db rules.
3 # This is for BUG#1100 (LOAD DATA INFILE was half-logged).
4
5 -- source include/have_binlog_format_mixed_or_statement.inc
6 -- source include/master-slave.inc
7
8 connection slave;
9 # Not sure why we connect to slave and then try to reset master, but I will leave it [JBM]
10 reset master;
11
12 connection master;
13 # 'test' is the current database
14 create table test.t1(a int, b int, unique(b));
15 load data infile '../../std_data/rpl_loaddata.dat' into table test.t1;
16
17 # Test logging on slave;
18
19 sync_slave_with_master;
20 select count(*) from test.t1; # check that LOAD was replicated
21 source include/show_binlog_events.inc;
22
23 # Cleanup
24 connection master;
25 drop table test.t1;
26 sync_slave_with_master;
27 --source include/rpl_end.inc