mirror of
https://github.com/MariaDB/server.git
synced 2025-09-15 05:41:27 +03:00
39 lines
1016 B
Plaintext
39 lines
1016 B
Plaintext
# Test to see what slave says when master is updating a table it does
|
|
# not have
|
|
--source include/have_binlog_format_row.inc
|
|
|
|
--source include/master-slave.inc
|
|
|
|
connection master;
|
|
create table t1 (a int not null primary key);
|
|
insert into t1 values (1);
|
|
create table t2 (a int);
|
|
insert into t2 values (1);
|
|
update t1, t2 set t1.a = 0 where t1.a = t2.a;
|
|
|
|
--sync_slave_with_master
|
|
# t2 should not have been replicated
|
|
# t1 should have been properly updated
|
|
show tables;
|
|
select * from t1;
|
|
drop table t1;
|
|
|
|
connection master;
|
|
insert into t1 values (1);
|
|
|
|
connection slave;
|
|
# slave should have stopped because can't find table t1
|
|
# 1146 = ER_NO_SUCH_TABLE
|
|
call mtr.add_suppression("Slave SQL.*Error executing row event: .Table .test.t1. doesn.t exist., error.* 1146");
|
|
--let $slave_sql_errno= 1146
|
|
--source include/wait_for_slave_sql_error.inc
|
|
|
|
--echo ==== Clean up ====
|
|
--source include/stop_slave_io.inc
|
|
RESET SLAVE;
|
|
|
|
connection master;
|
|
drop table t1, t2;
|
|
--let $rpl_only_running_threads= 1
|
|
--source include/rpl_end.inc
|