Bug #216 Replication issues with 'UPDATE database.table'

• Submitted: 1 Apr 2003 2:36
• Modified: 1 Apr 2003 6:29
• Reporter: Simon Dixey
• Status: Not a Bug
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 4.0.12-nt
• OS: Windows (Windows 2000 SP3)
• Assigned to: Guilhem Bichot
• CPU Architecture: Any

[1 Apr 2003 2:36] Simon Dixey

Description:
I am using MySQL Replication with a Master and one Slave.

Using the command-line client and doing:
UPDATE database.table
..changes are made to master only, however..
USE database
UPDATE table
..replicates on both sources.

How to repeat:
d:\mysql\bin\mysql -e "UPDATE enquiry.details SET dMake = 'Panasonic' WHERE dID = 7;"
..causes the master table to update, but not the slave.

Changing the syntax to:
d:\mysql\bin\mysql -e "USE enquiry; UPDATE details SET dMake = 'Panasonic' WHERE dID = 7;"
..works.

[1 Apr 2003 6:29] Peter Zaitsev

This does not seems like a bug but using
replicate-do-db=database  or similar option.

If you still feel like this is a bug please provide us with full master and slave configuration files as well as complete 
set of statements required to repeat the problem.