Edit File: rpl_insert_select.test
# Testcase for BUG#10456 - INSERT INTO ... SELECT violating a primary key # breaks replication -- source include/master-slave.inc connection master; create table t1 (n int not null primary key); insert into t1 values (1); create table t2 (n int); insert into t2 values (1); insert ignore into t1 select * from t2; insert into t1 values (2); sync_slave_with_master; connection slave; select * from t1; connection master; drop table t1,t2; sync_slave_with_master;
Back to File Manager