Bug #78636 Documentation bug for CHANGE REPLICATION FILTER in MySQL 5.7

• Submitted: 30 Sep 2015 7:31
• Modified: 1 Oct 2015 9:02
• Reporter: Muhammad Irfan
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: MySQL 5.7
• OS: Any
• CPU Architecture: Any
• Tags: MySQL 5.7

[30 Sep 2015 7:31] Muhammad Irfan

Description:
I found documentation bug in MySQL manual on CHANGE REPLICATION FILTER page can be found here http://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html

CHANGE REPLICATION FILTER 
REPLICATION_DO_DB = (db1, db2), REPLICATE_DO_DB = (db3, db4);

It describes same multiple filters can't be applied. I found syntax error.

How to repeat:
mysql> CHANGE REPLICATION FILTER
    -> REPLICATION_DO_DB = (db1, db2), REPLICATE_DO_DB = (db3, db4);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPLICATION_DO_DB = (db1, db2), REPLICATE_DO_DB = (db3, db4)' at line 2

Suggested fix:
mysql> CHANGE REPLICATION FILTER
    -> REPLICATE_DO_DB = (db1, db2), REPLICATE_DO_DB = (db3, db4);

[30 Sep 2015 8:27] MySQL Verification Team

Hello Muhammad Irfan,

Thank you for the report.

Thanks,
Umesh

[1 Oct 2015 9:02] Stefan Hinz

Posted by developer:
 
Thanks for your report! The issue is fixed in the docs; the updated docs will appear in a little while.