Debian Codegraph @

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

raw
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
13 connection master;
14 DROP TABLE IF EXISTS test.t1;
15 --enable_warnings
16
17 # Section 1 test
18 CREATE TABLE test.t1 (a VARCHAR(255), PRIMARY KEY(a)) CHARSET=latin1;
19 LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1;
20 DELETE FROM test.t1 WHERE a = 'abashed';
21 DELETE FROM test.t1;
22 LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1;
23
24
25 SELECT * FROM test.t1 ORDER BY a DESC;
26 save_master_pos;
27 sync_slave_with_master;
28 connection slave;
29 SELECT * FROM test.t1 ORDER BY a DESC;
30
31 # Cleanup
32 #show binlog events;
33 connection master;
34 DROP TABLE test.t1;
35 sync_slave_with_master;
36
37 # End of 5.0 test case
38
39 --source include/rpl_end.inc