summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/engines/funcs/t/rpl_loaddata2.test
blob: b357054b4dbe82baf8e08daac69393fe572ee691 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
--source include/master-slave.inc

CREATE TABLE t1 (word CHAR(20) NOT NULL);
LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
SELECT * FROM t1 ORDER BY word;
--sync_slave_with_master

# Check
SELECT * FROM t1 ORDER BY word;

# Cleanup
connection master;
drop table t1;
--sync_slave_with_master
--source include/rpl_end.inc