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));
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 --source include/sync_slave_sql_with_master.inc
27 connection slave;
28 SELECT * FROM test.t1 ORDER BY a DESC;
29
30 # Cleanup
31 #show binlog events;
32 connection master;
33 DROP TABLE test.t1;
34 --source include/sync_slave_sql_with_master.inc
35
36 # End of 5.0 test case
37
38 --source include/rpl_end.inc