| Bug #11323 | Update Join gets silently ignored by the slave | ||
|---|---|---|---|
| Submitted: | 14 Jun 2005 15:59 | Modified: | 17 Jun 2005 18:12 |
| Reporter: | Marco Gergele | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 4.1.9-standard-log | OS: | Linux (Linux Debian sarge) |
| Assigned to: | CPU Architecture: | Any | |
[17 Jun 2005 18:12]
MySQL Verification Team
Duplicate for #7011
Description: An update join is performed on the master, but not on the slave. Even worse, the slave doesn't give an error message and silently continues. slave-skip-errors = 1051,1062,1146 How to repeat: create table upd_join_test1 ( id int(11) not null auto_increment, feld1 char(5), primary key(id)); create table upd_join_test2 ( id int(11) not null auto_increment, feld2 char(5), primary key(id)); insert into upd_join_test1 (feld1) values (''),(''),(''),(''),(''); insert into upd_join_test2 (feld2) values ('a'),('b'),('c'),('d'),('e'); select * from upd_join_test1; select * from upd_join_test2; update upd_join_test1 u1 inner join upd_join_test2 u2 on u1.id = u2.id set u1.feld1 = concat('feld2:', u2.feld2) ;