diff options
Diffstat (limited to 'mysql-test/suite/rpl/include/rpl_stm_EE_err2.test')
-rw-r--r-- | mysql-test/suite/rpl/include/rpl_stm_EE_err2.test | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/include/rpl_stm_EE_err2.test b/mysql-test/suite/rpl/include/rpl_stm_EE_err2.test new file mode 100644 index 00000000000..2f4435357ff --- /dev/null +++ b/mysql-test/suite/rpl/include/rpl_stm_EE_err2.test @@ -0,0 +1,41 @@ +################################### +# Author: JBM +# Date: 2006-01-11 +# Purpose: Second test case from +# rpl_EE_err.test split out +# from orginal to make the +# first work with both RBR and SBR +################################### +#REQUIREMENT: An INSERT with a faked duplicate entry error on +#master should be replicated to slave and force the slave to stop +#(since the slave can't cause a faked error to re-occur). +################################### + +-- source include/master-slave.inc + +connection master; +eval create table t1 (a int, unique(a)) engine=$engine_type; +set sql_log_bin=0; +insert into t1 values(2); +set sql_log_bin=1; + +--error ER_DUP_ENTRY +insert into t1 values(1),(2); +drop table t1; + +connection slave; +--source include/wait_for_slave_sql_to_stop.inc +call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.* error code=1062.*Error on slave:.* error.* 0"); +let $error= query_get_value(SHOW SLAVE STATUS, Last_SQL_Error, 1); +let $errno= query_get_value(SHOW SLAVE STATUS, Last_SQL_Errno, 1); +--echo Error: "$error" (expected different error codes on master and slave) +--echo Errno: "$errno" (expected 0) +drop table t1; +--source include/stop_slave.inc +# Clear error messages. +RESET SLAVE; + +# End of 4.1 tests + +--let $rpl_only_running_threads= 1 +--source include/rpl_end.inc |