Bug #26109 multi-table update will broke replication if replicate-do-table is in use

• Submitted: 6 Feb 2007 9:30
• Modified: 6 Feb 2007 11:48
• Reporter: Alexander Y. Fomichev
• Status: Duplicate
• Category: MySQL Server: Replication
• Severity: S2 (Serious)
• Version: 5.0.33
• OS: Linux (linux)
• CPU Architecture: Any

[6 Feb 2007 9:30] Alexander Y. Fomichev

Description:
Multiple tables update will broke replication even if tables restricted by 
'replicate-do-table' were not updated.
very similar to http://bugs.mysql.com/bug.php?id=3989

How to repeat:
The slave settings are: 
... 
replicate-do-db                 = test 
replicate-do-table              = test.a
...

DROP TABLE IF EXISTS a;
DROP TABLE IF EXISTS b;
CREATE TABLE a (i int);
CREATE TABLE b (i int, m int);
UPDATE b LEFT JOIN a USING(i) SET m=1;

ends up with:
Last_Error: Error 'Table 'test.b' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE b LEFT JOIN a USING(i) SET m=1'

[6 Feb 2007 11:48] Sveta Smirnova

Thank you for the report.

It is indeed duplicate of bug #3989.

So I marked it as "Duplicate"