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