1-- source include/have_binlog_format_statement.inc 2-- source include/master-slave.inc 3 4# 5# Bug #51055 Replication failure on duplicate key + traditional SQL mode 6# 7 8CREATE TABLE t1 (pk integer auto_increment , primary key (pk)); 9 10SET SESSION SQL_MODE='traditional'; 11 12-- echo # **** [MASTER] ***** 13-- echo # action: raise DUP KEY error (error code should be set in the 14-- echo # query log event) 15-- error ER_DUP_ENTRY 16INSERT INTO t1 (`pk`) VALUES (1), (1); 17 18DROP TABLE t1; 19 20-- echo # **** [ sync slave with master ] **** 21-- echo # assertion: sync slave with master makes slave not to stop with 22-- echo # duplicate key error (because it has received event 23-- echo # with expected error code). 24-- sync_slave_with_master 25--source include/rpl_end.inc 26