1
# Test to see what slave says when master is updating a table it does
3
--source include/have_binlog_format_row.inc
5
source include/master-slave.inc;
8
create table t1 (a int not null primary key);
9
insert into t1 values (1);
10
create table t2 (a int);
11
insert into t2 values (1);
12
update t1, t2 set t1.a = 0 where t1.a = t2.a;
14
sync_slave_with_master;
15
# t2 should not have been replicated
16
# t1 should have been properly updated
22
insert into t1 values (1);
25
# slave should have stopped because can't find table t1
26
wait_for_slave_to_stop;
27
# see if we have a good error message:
28
--replace_result $MASTER_MYPORT MASTER_MYPORT
29
--replace_column 1 # 7 # 8 # 9 # 22 # 23 # 33 #