1############################################################################# 2# Original Author: JBM # 3# Original Date: Aug/18/2005 # 4############################################################################# 5# TEST: To test the LOAD DATA INFILE in rbr # 6############################################################################# 7 8# Includes 9-- source include/master-slave.inc 10 11# Begin clean up test section 12--disable_warnings 13connection master; 14DROP TABLE IF EXISTS test.t1; 15--enable_warnings 16 17# Section 1 test 18CREATE TABLE test.t1 (a VARCHAR(255), PRIMARY KEY(a)); 19LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1; 20DELETE FROM test.t1 WHERE a = 'abashed'; 21DELETE FROM test.t1; 22LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1; 23 24 25SELECT * FROM test.t1 ORDER BY a DESC; 26save_master_pos; 27sync_slave_with_master; 28connection slave; 29SELECT * FROM test.t1 ORDER BY a DESC; 30 31# Cleanup 32#show binlog events; 33connection master; 34DROP TABLE test.t1; 35sync_slave_with_master; 36 37# End of 5.0 test case 38 39--source include/rpl_end.inc 40