summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorguilhem@mysql.com <>2004-01-29 19:22:29 +0100
committerguilhem@mysql.com <>2004-01-29 19:22:29 +0100
commit5ce227e78a2bc0530c3cab2cbebdd4672a0c40c1 (patch)
treef3f426fbb085bed11fbaa55547d74f9feaec62a8 /mysql-test/r
parent71c6d0c4f9e3047d70c60b3bc2f13efbd9fe3b7e (diff)
downloadmariadb-git-5ce227e78a2bc0530c3cab2cbebdd4672a0c40c1.tar.gz
Fix for BUG#2527 "Multi-Table Delete - Not Replication use replicate-wild-do-table"
(as long as replicate-*-table rules were defined, multi-table DELETE was never replicated by the slave).
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/rpl_multi_delete.result22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_multi_delete.result b/mysql-test/r/rpl_multi_delete.result
new file mode 100644
index 00000000000..fa254d76393
--- /dev/null
+++ b/mysql-test/r/rpl_multi_delete.result
@@ -0,0 +1,22 @@
+slave stop;
+drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
+reset master;
+reset slave;
+drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
+slave start;
+create table t1 (a int);
+create table t2 (a int);
+insert into t1 values (1);
+insert into t2 values (1);
+delete t1.* from t1, t2 where t1.a = t2.a;
+select * from t1;
+a
+select * from t2;
+a
+1
+select * from t1;
+a
+select * from t2;
+a
+1
+drop table t1,t2;