Bug #103540 Typo spotted in Replication docs
Submitted: 30 Apr 2021 3:46 Modified: 16 May 2021 18:27
Reporter: Jason Liu (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 and 8.0 OS:Any
Assigned to: CPU Architecture:Any

[30 Apr 2021 3:46] Jason Liu
Description:
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html

In the last paragraph of this page:
“If you need to use this method of skipping a transaction when MASTER_AUTO_POSITION=1 is normally set, you can change the setting to MASTER_AUTO_POSITION=1 while issuing the statement, then change it back again afterwards. ”

I think the second 'MASTER_AUTO_POSITION' word should be equal to 0,to correspond to the following command.

How to repeat:
see description

Suggested fix:
what I'd suggest to write instead

“If you need to use this method of skipping a transaction when MASTER_AUTO_POSITION=1 is normally set, you can change the setting to MASTER_AUTO_POSITION=0 while issuing the statement, then change it back again afterwards. ”
[30 Apr 2021 5:19] MySQL Verification Team
Hello Jason Liu,

Thank you for the report and feedback.

regards,
Umesh
[16 May 2021 18:27] Margaret Fisher
Posted by developer:
 
Thanks for spotting this! I've made the correction.