~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-proposed

1.4.1 by Marc Deslauriers
Import upstream version 5.1.61
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