Bug #6888 Update with joined table not replicated in mysql 4.1.7
Submitted: 30 Nov 2004 7:50 Modified: 24 Jan 2005 14:57
Reporter: jerry nieuviarts
Status: Duplicate
Category:Server: MyISAM Severity:S1 (Critical)
Version:4.1.7 OS:Linux (Linux Mandrake)
Assigned to: Target Version:

[30 Nov 2004 7:50] jerry nieuviarts 
Description:
This kind of update (with a joined table) is not replicated 

update table1 join table2 on table1.id1=table2.id2 set 
table1.description=table2.description

More generally, every "update table join" do not replicate since we upgraded from Mysql
4.1.4 to Mysql 4.1.7
Therefore, the query is present in binary and relay log

How to repeat:
1 - configure a master and slave
2 - make 2 table with a common key
3 - launch this query "update table1 join table2 on table1.id1=table2.id2 set 
table1.description=table2.description"

The update is ok on the master but not replicated on the slave.
[30 Nov 2004 12:19] Victoria Reznichenko 
Hi,

Thank you for the report. What replication options do you use?
[30 Nov 2004 16:19] jerry nieuviarts 
Replication option : nothing very specific : 
log-bin on master and a server id on each slave.

I have "replicate-wild-ignore-table" option activated on slave and "binlog-do-db=" on
master but they did not affect the so called table
[23 Jan 2005 9:46] jerry nieuviarts 
Is there something new with this bug ?
[24 Jan 2005 14:57] Guilhem Bichot 
Hi,
probably a duplicate of http://bugs.mysql.com/bug.php?id=7011 .