|
1
by brian
clean slate |
1 |
# Testcase for BUG#10456 - INSERT INTO ... SELECT violating a primary key |
2 |
# breaks replication |
|
3 |
||
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; |