release/src/router/mysql/mysql-test/suite/rpl/r/rpl_row_corruption.result

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