summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl000004.test
blob: b7ab81a055302668d04041733ee0565814d93255 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
source include/master-slave.inc;
connection master;
use test;
set SQL_LOG_BIN=0;
drop table if exists words;
create table words (word char(20) not null, index(word));
load data infile '../../std_data/words.dat' into table words;
drop table if exists words1;
create table words1 (word char(20) not null);
load data infile '../../std_data/words.dat' into table words1;
connection slave;
use test;
drop table if exists words;
load table words from master;
drop table if exists words1;
load table words1 from master;
@r/rpl000004.a.result check table words;
@r/rpl000004.b.result select count(*) from words1;