Bug #6888 Update with joined table not replicated in mysql 4.1.7

• Submitted: 30 Nov 2004 6:50
• Modified: 24 Jan 2005 13:57
• Reporter: jerry nieuviarts
• Status: Duplicate
• Category: MySQL Server: MyISAM storage engine
• Severity: S1 (Critical)
• Version: 4.1.7
• OS: Linux (Linux Mandrake)
• CPU Architecture: Any

[30 Nov 2004 6: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 11:19] MySQL Verification Team

Hi,

Thank you for the report. What replication options do you use?

[30 Nov 2004 15: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 8:46] jerry nieuviarts

Is there something new with this bug ?

[24 Jan 2005 13:57] Guilhem Bichot

Hi,
probably a duplicate of http://bugs.mysql.com/bug.php?id=7011 .