2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT,
9
INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10;
20
Master_Log_File master-bin.000001
24
Relay_Master_Log_File master-bin.000001
30
Replicate_Ignore_Table
31
Replicate_Wild_Do_Table
32
Replicate_Wild_Ignore_Table
34
Last_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10'
36
Exec_Master_Log_Pos 246
47
Seconds_Behind_Master #
48
Master_SSL_Verify_Server_Cert No
52
Last_SQL_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10'
61
id bigint(20) unsigned NOT NULL auto_increment,
62
field_1 int(10) unsigned NOT NULL,
63
field_2 varchar(255) NOT NULL,
64
field_3 varchar(255) NOT NULL,
66
UNIQUE KEY field_1 (field_1, field_2)
69
field_a int(10) unsigned NOT NULL,
70
field_b varchar(255) NOT NULL,
71
field_c varchar(255) NOT NULL
73
INSERT INTO t2 (field_a, field_b, field_c) VALUES (1, 'a', '1a');
74
INSERT INTO t2 (field_a, field_b, field_c) VALUES (2, 'b', '2b');
75
INSERT INTO t2 (field_a, field_b, field_c) VALUES (3, 'c', '3c');
76
INSERT INTO t2 (field_a, field_b, field_c) VALUES (4, 'd', '4d');
77
INSERT INTO t2 (field_a, field_b, field_c) VALUES (5, 'e', '5e');
78
INSERT INTO t1 (field_1, field_2, field_3)
79
SELECT t2.field_a, t2.field_b, t2.field_c
81
ON DUPLICATE KEY UPDATE
82
t1.field_3 = t2.field_c;
83
INSERT INTO t2 (field_a, field_b, field_c) VALUES (6, 'f', '6f');
84
INSERT INTO t1 (field_1, field_2, field_3)
85
SELECT t2.field_a, t2.field_b, t2.field_c
87
ON DUPLICATE KEY UPDATE
88
t1.field_3 = t2.field_c;
90
id field_1 field_2 field_3
103
Master_Log_File master-bin.000001
104
Read_Master_Log_Pos #
107
Relay_Master_Log_File master-bin.000001
113
Replicate_Ignore_Table
114
Replicate_Wild_Do_Table
115
Replicate_Wild_Ignore_Table
117
Last_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1 (field_1, field_2, field_3)
118
SELECT t2.field_a, t2.field_b, t2.field_c
120
ON DUPLICATE KEY UPDATE
121
t1.field_3 = t2.field_c'
123
Exec_Master_Log_Pos 1278
128
Master_SSL_Allowed No
134
Seconds_Behind_Master #
135
Master_SSL_Verify_Server_Cert No
139
Last_SQL_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1 (field_1, field_2, field_3)
140
SELECT t2.field_a, t2.field_b, t2.field_c
142
ON DUPLICATE KEY UPDATE
143
t1.field_3 = t2.field_c'
145
id field_1 field_2 field_3