diff options
author | cmiller@zippy.cornsilk.net <> | 2007-10-17 14:05:43 -0400 |
---|---|---|
committer | cmiller@zippy.cornsilk.net <> | 2007-10-17 14:05:43 -0400 |
commit | f3d77c1979bad93a304cbb5b93d672178815df00 (patch) | |
tree | 892096ddfa11f5fea89ad26528d5c64fbc05ffce /mysql-test/suite/rpl/t/rpl_multi_update4.test | |
parent | c6b5c6af86cb7fed9ad86690136d668071b6f6cc (diff) | |
parent | 571200d48750beba84a2936d727afcb347e1b704 (diff) | |
download | mariadb-git-f3d77c1979bad93a304cbb5b93d672178815df00.tar.gz |
Merge zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-comeng-unification
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-recentcommmerge
Diffstat (limited to 'mysql-test/suite/rpl/t/rpl_multi_update4.test')
-rw-r--r-- | mysql-test/suite/rpl/t/rpl_multi_update4.test | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/t/rpl_multi_update4.test b/mysql-test/suite/rpl/t/rpl_multi_update4.test new file mode 100644 index 00000000000..4991a385f6f --- /dev/null +++ b/mysql-test/suite/rpl/t/rpl_multi_update4.test @@ -0,0 +1,45 @@ +# Let's verify that multi-update is not always skipped by slave if +# some replicate-* rules exist. +# (BUG#15699) + +source include/master-slave.inc; + +### Clean-up + +connection master; +--disable_warnings +drop database if exists d1; +drop database if exists d2; + +connection slave; +drop database if exists d2; +--enable_warnings + +### Do on master + +connection master; +create database d1; # accepted by slave +create table d1.t0 (id int); +create database d2; # ignored by slave +use d2; +create table t1 (id int); +create table t2 (id int); +insert into t1 values (1), (2), (3), (4), (5); +insert into t2 select id + 3 from t1; +# a problematic query which must be filter out by slave +update t1 join t2 using (id) set t1.id = 0; +insert into d1.t0 values (0); # replication works + +### Check on slave + +sync_slave_with_master; +use d1; +select * from t0 where id=0; # must find + +### Clean-up +connection master; +drop database d1; +drop database d2; +sync_slave_with_master; + +# End of test |