Debian Codegraph @

mysql-test/suite/rpl/r/rpl_insert_delayed,stmt.rdiff

raw
1 --- suite/rpl/r/rpl_insert_delayed.result
2 +++ suite/rpl/r/rpl_insert_delayed,stmt.reject
3 @@ -18,19 +18,19 @@
4 insert delayed into t1 values(10, "my name");
5 flush table t1;
6 insert delayed into t1 values(10, "is Bond"), (20, "James Bond");
7 +ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
8 flush table t1;
9 select * from t1;
10 id name
11 10 my name
12 -20 James Bond
13 connection slave;
14 select * from t1;
15 id name
16 10 my name
17 -20 James Bond
18 connection master;
19 delete from t1 where id!=10;
20 insert delayed into t1 values(20, "is Bond"), (10, "James Bond");
21 +ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
22 flush table t1;
23 select * from t1;
24 id name
25 @@ -47,21 +47,38 @@
26 connection slave;
27 use test;
28 connection master;
29 +connection slave;
30 +FLUSH LOGS;
31 +connection master;
32 +FLUSH LOGS;
33 CREATE TABLE t1(a int, UNIQUE(a));
34 INSERT DELAYED IGNORE INTO t1 VALUES(1);
35 INSERT DELAYED IGNORE INTO t1 VALUES(1);
36 flush table t1;
37 +use `test`; INSERT IGNORE INTO t1 VALUES(1)
38 +use `test`; INSERT IGNORE INTO t1 VALUES(1)
39 select * from t1;
40 a
41 1
42 connection slave;
43 On slave
44 +include/show_binlog_events.inc
45 +Log_name Pos Event_type Server_id End_log_pos Info
46 +slave-bin.000002 # Gtid # # BEGIN GTID #-#-#
47 +slave-bin.000002 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES(1)
48 +slave-bin.000002 # Query # # COMMIT
49 +slave-bin.000002 # Gtid # # BEGIN GTID #-#-#
50 +slave-bin.000002 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES(1)
51 +slave-bin.000002 # Query # # COMMIT
52 select * from t1;
53 a
54 1
55 connection master;
56 drop table t1;
57 connection slave;
58 +FLUSH LOGS;
59 +connection master;
60 +FLUSH LOGS;
61 connection master;
62 End of 5.0 tests
63 include/rpl_end.inc