1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
--source include/not_group_replication_plugin.inc
source include/force_myisam_default.inc;
source include/have_myisam.inc;
source include/master-slave.inc;
--echo # Verify the statements can be binlogged correctly when error happens
--echo # ------------------------------------------------------------------
CREATE TABLE t1(c1 INT KEY) ENGINE=MyISAM;
CREATE TABLE t2(c1 INT KEY) ENGINE=MyISAM;
INSERT INTO t1 VALUES(1);
INSERT INTO t2 VALUES(1);
--echo
--echo # Nothing is inserted.
let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1);
--error 1062
INSERT INTO t1 VALUES(1),(2);
source include/show_binlog_events.inc;
--echo
--echo # A row is inserted.
--error 1062
INSERT INTO t1 VALUES(2),(1);
--source include/sync_slave_sql_with_master.inc
let $diff_tables= master:test.t1, slave:test.t1;
source include/diff_tables.inc;
--echo
--echo # Nothing is inserted.
connection master;
let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1);
--error 1062
INSERT INTO t1 SELECT 1 UNION SELECT 2;
source include/show_binlog_events.inc;
--echo
--echo # A row is inserted.
--error 1062
INSERT INTO t1 SELECT 3 UNION SELECT 2;
--source include/sync_slave_sql_with_master.inc
source include/diff_tables.inc;
--echo
--echo # A row is updated.
connection master;
let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1);
--error 1062
UPDATE t1 SET c1=4;
--source include/sync_slave_sql_with_master.inc
source include/diff_tables.inc;
--echo # Nothing is updated.
connection master;
let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1);
--error 1062
UPDATE t1 SET c1=4;
source include/show_binlog_events.inc;
--echo
--echo # A row is updated.
connection master;
--error 1062
UPDATE t1, t2 SET t1.c1= 5, t2.c1=5;
--source include/sync_slave_sql_with_master.inc
source include/diff_tables.inc;
--echo
--echo Nothing is updated.
connection master;
let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1);
--error 1062
UPDATE t1, t2 SET t1.c1= 5, t2.c1=5;
source include/show_binlog_events.inc;
DROP TABLE t1, t2;
source include/rpl_end.inc;
|
