Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_loaddatalocal.result

raw
1 include/master-slave.inc
2 [connection master]
3 create table t1(a int);
4 select * into outfile 'MYSQLTEST_VARDIR/tmp/rpl_loaddatalocal.select_outfile' from t1;
5 truncate table t1;
6 load data local infile 'MYSQLTEST_VARDIR/tmp/rpl_loaddatalocal.select_outfile' into table t1;
7 connection slave;
8 select a,count(*) from t1 group by a;
9 a count(*)
10 1 10000
11 connection master;
12 drop table t1;
13 connection slave;
14 connection master;
15 create table t1(a int);
16 insert into t1 values (1), (2), (2), (3);
17 select * into outfile 'MYSQLTEST_VARDIR/tmp/rpl_loaddatalocal.select_outfile' from t1;
18 drop table t1;
19 create table t1(a int primary key);
20 load data local infile 'MYSQLTEST_VARDIR/tmp/rpl_loaddatalocal.select_outfile' into table t1;
21 Warnings:
22 Warning 1062 Duplicate entry '2' for key 'PRIMARY'
23 SELECT * FROM t1 ORDER BY a;
24 a
25 1
26 2
27 3
28 connection slave;
29 SELECT * FROM t1 ORDER BY a;
30 a
31 1
32 2
33 3
34 connection master;
35 drop table t1;
36 connection slave;
37 include/rpl_end.inc