Debian Codegraph @

mysql-test/suite/engines/funcs/t/rpl_insert_select.test

raw
1 # Testcase for BUG#10456 - INSERT INTO ... SELECT violating a primary key
2 # breaks replication
3 -- source include/have_binlog_format_mixed_or_row.inc
4 -- source include/master-slave.inc
5 connection master;
6
7 create table t1 (n int not null primary key);
8 insert into t1 values (1);
9 create table t2 (n int);
10 insert into t2 values (1);
11 insert ignore into t1 select * from t2;
12 insert into t1 values (2);
13 --sync_slave_with_master
14 connection slave;
15 select * from t1;
16
17 connection master;
18 drop table t1,t2;
19 --sync_slave_with_master
20 --source include/rpl_end.inc