Bug #85785 No mention of persistent clauses in alter table documentation

• Submitted: 4 Apr 2017 13:17
• Modified: 27 Oct 2017 17:18
• Reporter: Hugo Dubois
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6/5.7
• OS: Any
• CPU Architecture: Any
• Tags: alter

[4 Apr 2017 13:17] Hugo Dubois

Description:
In the alter table documentation (
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html), there is no mention of STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses (find in https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html)

How to repeat:
For example, search of this type of statement in https://dev.mysql.com/doc/refman/5.7/en/alter-table.html :
ALTER TABLE tbl_name STATS_PERSISTENT=0

Suggested fix:
Add all persistent clauses on the alter table documentation.

[4 Apr 2017 13:56] MySQL Verification Team

Thank you for the bug report.

[27 Oct 2017 17:18] Paul DuBois

Posted by developer:
 
Clauses now mentioned (they are table_option values).