rpl_replicate_do.test 2.1 KB
Newer Older
unknown's avatar
unknown committed
1 2 3
# This test assumes we are ignoring updates on table t2, but doing
# updates on t1
source include/master-slave.inc;
4
--disable_warnings
unknown's avatar
unknown committed
5 6 7
drop table if exists t11;
connection slave;
drop table if exists t11;
8 9
--enable_warnings

unknown's avatar
unknown committed
10 11 12 13
create table t2 (n int);
insert into t2 values(4);
connection master;
create table t2 (s char(20));
unknown's avatar
unknown committed
14
load data infile '../../std_data/words.dat' into table t2;
unknown's avatar
unknown committed
15 16 17 18 19 20
insert into t2 values('five');
create table t1 (m int);
insert into t1 values(15),(16),(17);
update t1 set m=20 where m=16;
delete from t1 where m=17;
create table t11 select * from t1;
Serge Kozlov's avatar
Serge Kozlov committed
21
sync_slave_with_master;
22
select * from t1 ORDER BY m;
unknown's avatar
unknown committed
23 24 25 26
select * from t2;
--error 1146
select * from t11;
connection master;
27
drop table if exists t1,t2,t11;
Serge Kozlov's avatar
Serge Kozlov committed
28
sync_slave_with_master;
29 30
# show slave status, just to see of it prints replicate-do-table
--replace_result $MASTER_MYPORT MASTER_PORT
31 32
--replace_column 1 # 7 # 8 # 9 # 22 # 23 # 33 # 35 # 36 #
query_vertical SHOW SLAVE STATUS;
33

34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
#
# BUG#12542
# TEST: "SET ONE_SHOT should always be executed on slave"
#
# We could use any timezone different than server default in this test
#
connection master;
create table t1 (ts timestamp);
set one_shot time_zone='met';
insert into t1 values('2005-08-12 00:00:00');
set one_shot time_zone='met';
select * from t1;
sync_slave_with_master;

connection slave;
set one_shot time_zone='met';
select * from t1;

52 53 54 55
connection master;
drop table t1;
sync_slave_with_master;

56
# End of 4.1 tests
57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88

#
# Bug#24478 DROP TRIGGER is not caught by replicate-*-table filters
#
--echo *** master ***
connection master;
create table t1 (a int, b int);
create trigger trg1 before insert on t1 for each row set new.b=2;
create table t2 (a int, b int);
create trigger trg2 before insert on t2 for each row set new.b=2;
show tables;
show triggers;
sync_slave_with_master;
--echo *** slave ***
connection slave;
show tables;
show triggers;
--echo *** master ***
connection master;
drop trigger trg1;
drop trigger trg2;
show triggers;
sync_slave_with_master;
--echo *** slave ***
connection slave;
show tables;
show triggers;
--echo *** master ***
connection master;
drop table t1;
drop table t2;
sync_slave_with_master;