1# See if the master logs LOAD DATA INFILE correctly when binlog_*_db rules 2# exist. 3# This is for BUG#1100 (LOAD DATA INFILE was half-logged). 4###################################################### 5# Change Author: JBM 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 11 12--disable_warnings 13drop database if exists mysqltest; 14--enable_warnings 15 16connection master; 17# 'test' database should be ignored by the slave 18USE test; 19CREATE TABLE t1(a INT, b INT, UNIQUE(b)); 20LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE test.t1; 21SELECT COUNT(*) FROM test.t1; 22 23# 'mysqltest' database should NOT be ignored by the slave 24CREATE DATABASE mysqltest; 25USE mysqltest; 26CREATE TABLE t1(a INT, b INT, UNIQUE(b)); 27LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE mysqltest.t1; 28SELECT COUNT(*) FROM mysqltest.t1; 29 30# Now lets check the slave to see what we have :-) 31sync_slave_with_master; 32 33SHOW DATABASES; 34 35USE test; 36SHOW TABLES; 37 38USE mysqltest; 39SHOW TABLES; 40SELECT COUNT(*) FROM mysqltest.t1; 41 42#show binlog events; 43 44# Cleanup 45connection master; 46DROP DATABASE mysqltest; 47DROP TABLE IF EXISTS test.t1; 48sync_slave_with_master; 49 50# End of test 51--source include/rpl_end.inc 52