| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
CREATE TABLE t1 (pk integer auto_increment , primary key (pk)); |
| 4 |
SET SESSION SQL_MODE='traditional'; |
| 5 |
# **** [MASTER] ***** |
| 6 |
# action: raise DUP KEY error (error code should be set in the |
| 7 |
# query log event) |
| 8 |
INSERT INTO t1 (`pk`) VALUES (1), (1); |
| 9 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY' |
| 10 |
DROP TABLE t1; |
| 11 |
# **** [ sync slave with master ] **** |
| 12 |
# assertion: sync slave with master makes slave not to stop with |
| 13 |
# duplicate key error (because it has received event |
| 14 |
# with expected error code). |
| 15 |
connection slave; |
| 16 |
include/rpl_end.inc |