1
# See if the master logs LOAD DATA INFILE correctly when binlog_*_db rules
3
# This is for BUG#1100 (LOAD DATA INFILE was half-logged).
4
######################################################
6
# Change Date: 2005-12-22
7
# Change: Test rewritten to remove show binlog events
8
# and to test the option better + Cleanup
9
######################################################
10
-- source include/master-slave.inc
13
drop database if exists mysqltest;
17
# 'test' database should be ignored by the slave
19
CREATE TABLE t1(a INT, b INT, UNIQUE(b));
20
LOAD DATA INFILE '../std_data_ln/rpl_loaddata.dat' INTO TABLE test.t1;
21
SELECT COUNT(*) FROM test.t1;
23
# 'mysqltest' database should NOT be ignored by the slave
24
CREATE DATABASE mysqltest;
26
CREATE TABLE t1(a INT, b INT, UNIQUE(b));
27
LOAD DATA INFILE '../std_data_ln/rpl_loaddata.dat' INTO TABLE mysqltest.t1;
28
SELECT COUNT(*) FROM mysqltest.t1;
30
# Now lets check the slave to see what we have :-)
42
SELECT COUNT(*) FROM mysqltest.t1;
48
DROP DATABASE mysqltest;
50
sync_slave_with_master;