Debian Codegraph @

mysql-test/suite/rpl/t/rpl_stm_sql_mode.test

raw
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
8 CREATE TABLE t1 (pk integer auto_increment , primary key (pk));
9
10 SET 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
16 INSERT INTO t1 (`pk`) VALUES (1), (1);
17
18 DROP 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