summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl000008.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/rpl000008.test')
-rw-r--r--mysql-test/t/rpl000008.test22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/rpl000008.test b/mysql-test/t/rpl000008.test
new file mode 100644
index 00000000000..a50016ed9c0
--- /dev/null
+++ b/mysql-test/t/rpl000008.test
@@ -0,0 +1,22 @@
+#this one assumes we are ignoring updates on table foo, but doing
+#the ones on all other tables
+source include/master-slave.inc;
+connection slave;
+use test;
+drop table if exists foo;
+create table foo (n int);
+insert into foo values(4);
+connection master;
+use test;
+drop table if exists foo;
+create table foo (n int);
+insert into foo values(5);
+drop table if exists bar;
+create table bar (m int);
+insert into bar values(15);
+drop table if exists choo;
+create table choo (k int);
+insert into choo values(55);
+connection slave;
+sleep 1;
+@r/rpl000008.result select foo.n,bar.m,choo.k from foo,bar,choo;