Bug #101043 Incorrect syntax for multiple-table updates on the binary log filters page
Submitted: 2 Oct 2020 20:33 Modified: 14 Oct 2020 15:34
Reporter: Sveta Smirnova (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0.21 OS:Any
Assigned to: CPU Architecture:Any

[2 Oct 2020 20:33] Sveta Smirnova
Manual for binary log and replication *-do-db filters has the wrong syntax for multiple-table updates examples.

How to repeat:
Open https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#option_mysqld_... or https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#option_mysqld_rep..., then check multiple-table updates examples:

mysql> UPDATE db1.table1 SET col1 = 10, db2.table2 SET col2 = 20;
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 'SET col2 = 20' at line 1

Correct syntax:

mysql> UPDATE db1.table1, db2.table2 SET col1 = 10, col2 = 20;


mysql> UPDATE db1.table1, db2.table2 SET db1.table1.col1 = 10, db2.table2.col2 = 20;

Suggested fix:
Fix examples.
[2 Oct 2020 20:53] MySQL Verification Team
Thank you for the bug report.
[14 Oct 2020 15:34] Margaret Fisher
Posted by developer:
Thanks for pointing this out! I have fixed the examples.