rpl_rewrite_db.test 2.08 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
source include/master-slave.inc;
--disable_warnings
drop database if exists mysqltest1;
--enable_warnings
create database mysqltest1;

use mysqltest1;
create table t1 (a int);
insert into t1 values(9);
select * from mysqltest1.t1;
sync_slave_with_master;
show databases like 'mysqltest1'; # should be empty
select * from test.t1;
# cleanup
connection master;
drop table t1;
drop database mysqltest1;
sync_slave_with_master;

unknown's avatar
unknown committed
20 21 22 23 24 25 26 27 28 29 30 31 32 33
#
# BUG#6353:
#   Option --replicate-rewrite-db should work together with LOAD DATA INFILE
#

connection slave;
--disable_warnings
drop database if exists rewrite;
--enable_warnings
create database rewrite;

connection master;
use test;
create table t1 (a date, b date, c date not null, d date);
34 35
load data infile '../std_data_ln/loaddata1.dat' into table t1 fields terminated by ',';
load data infile '../std_data_ln/loaddata1.dat' into table t1 fields terminated by ',' IGNORE 2 LINES;
unknown's avatar
unknown committed
36 37 38 39 40 41 42
sync_slave_with_master;

connection slave;
select * from rewrite.t1;

connection master;
truncate table t1;
43
load data infile '../std_data_ln/loaddata1.dat' into table t1 fields terminated by ',' LINES STARTING BY ',' (b,c,d);
unknown's avatar
unknown committed
44 45 46 47 48 49 50 51
sync_slave_with_master;

connection slave;
select * from rewrite.t1;

connection master;
drop table t1;
create table t1 (a text, b text);
52
load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''';
unknown's avatar
unknown committed
53 54 55 56 57 58 59 60
sync_slave_with_master;

connection slave;
select concat('|',a,'|'), concat('|',b,'|') from rewrite.t1;

connection master;
drop table t1;
create table t1 (a int, b char(10));
61
load data infile '../std_data_ln/loaddata3.dat' into table t1 fields terminated by '' enclosed by '' ignore 1 lines;
unknown's avatar
unknown committed
62 63 64 65 66 67 68
sync_slave_with_master;

connection slave;
select * from rewrite.t1;

connection master;
truncate table t1;
69
load data infile '../std_data_ln/loaddata4.dat' into table t1 fields terminated by '' enclosed by '' lines terminated by '' ignore 1 lines;
unknown's avatar
unknown committed
70 71 72 73 74 75
sync_slave_with_master;

connection slave;
# The empty line last comes from the end line field in the file
select * from rewrite.t1;

unknown's avatar
unknown committed
76 77
drop database rewrite;

unknown's avatar
unknown committed
78 79
connection master;
drop table t1;
unknown's avatar
unknown committed
80

81
# End of 4.1 tests