Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_corruption.result

raw
1 include/master-slave.inc
2 [connection master]
3 CREATE TABLE t1_11753004 (c1 INT);
4 CREATE TABLE t2_11753004 (c1 INT);
5 INSERT INTO t1_11753004 VALUES (1);
6 INSERT INTO t2_11753004 VALUES (2);
7 connection slave;
8 call mtr.add_suppression(".*Found table map event mapping table id 0 which was already mapped but with different settings.*");
9 include/stop_slave.inc
10 SET @saved_debug= @@global.debug_dbug;
11 SET @@global.debug_dbug="d,inject_tblmap_same_id_maps_diff_table";
12 include/start_slave.inc
13 connection master;
14 UPDATE t1_11753004, t2_11753004 SET t1_11753004.c1=3, t2_11753004.c1=4 WHERE t1_11753004.c1=1 OR t2_11753004.c1=2;
15 connection slave;
16 include/wait_for_slave_sql_error.inc [errno=1593 ]
17 include/stop_slave_io.inc
18 SET @@global.debug_dbug=@saved_debug;
19 include/start_slave.inc
20 connection master;
21 include/rpl_reset.inc
22 DROP TABLE t1_11753004, t2_11753004;
23 connection slave;
24 connection slave;
25 include/stop_slave.inc
26 SET @@global.debug_dbug="d,inject_tblmap_same_id_maps_diff_table";
27 include/start_slave.inc
28 include/rpl_reset.inc
29 connection master;
30 CREATE TABLE t1_11753004 (c1 INT);
31 CREATE TABLE t2_11753004_ign (c1 INT);
32 INSERT INTO t1_11753004 VALUES (1);
33 INSERT INTO t2_11753004_ign VALUES (2);
34 UPDATE t1_11753004, t2_11753004_ign SET t1_11753004.c1=3, t2_11753004_ign.c1=4 WHERE t1_11753004.c1=1 OR t2_11753004_ign.c1=2;
35 connection slave;
36 CREATE TABLE t1 (c1 INT);
37 CREATE TABLE t2 (c1 INT);
38 INSERT INTO t1 VALUES (1);
39 INSERT INTO t2 VALUES (1);
40 BINLOG '
41 SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA
42 AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=
43 '/*!*/;
44 SET @@global.debug_dbug="d,inject_tblmap_same_id_maps_diff_table";
45 BINLOG '
46 SOgWThMBAAAAKQAAAAYDAAAAAEIAAAAAAAEABHRlc3QAAnQxAAEDAAE=
47 SOgWThMBAAAAKQAAAC8DAAAAAEMAAAAAAAEABHRlc3QAAnQyAAEDAAE=
48 SOgWThgBAAAAKAAAAFcDAAAAAEIAAAAAAAAAAf///gEAAAD+AwAAAA==
49 SOgWThgBAAAAKAAAAH8DAAAAAEMAAAAAAAEAAf///gEAAAD+BAAAAA==
50 '/*!*/;
51 ERROR HY000: Fatal error: Found table map event mapping table id 0 which was already mapped but with different settings.
52 DROP TABLE t1,t2;
53 connection slave;
54 SET @@global.debug_dbug=@saved_debug;
55 connection master;
56 DROP TABLE t1_11753004;
57 DROP TABLE t2_11753004_ign;
58 connection slave;
59 SET @@global.debug_dbug= @save_debug;
60 include/rpl_end.inc