create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60));
46
40
insert into t3 select * from t2;
47
41
48
save_master_pos;
49
connection slave;
50
sync_with_master;
42
sync_slave_with_master;
51
43
52
44
select * from t1;
53
45
select * from t3;
59
51
drop table t3;
60
52
create table t1(a int, b int, unique(b));
61
53
62
save_master_pos;
63
connection slave;
64
sync_with_master;
54
sync_slave_with_master;
65
55
66
56
# See if slave stops when there's a duplicate entry for key error in LOAD DATA
67
57
72
62
73
63
save_master_pos;
74
64
connection slave;
75
# The SQL slave thread should be stopped now.
76
--source include/wait_for_slave_sql_to_stop.inc
65
# 1062 = ER_DUP_ENTRY
66
call mtr.add_suppression("Slave SQL.*Error .Duplicate entry .10. for key .b.. on query.* Error_code: 1062");
67
call mtr.add_suppression("Slave SQL.*Query caused different errors on master and slave.*Error on master:.*error code=1062.*Error on slave:.*Error_code: 0");