Bug #93265 ADD COLUMN marked as table-rebuilding operation in MySQL 8.0 manual
Submitted: 21 Nov 2018 8:47 Modified: 25 Nov 2018 7:03
Reporter: Alexey Kopytov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[21 Nov 2018 8:47] Alexey Kopytov
Description:
It is not clear why adding a column is categorized as an unconditionally
table-rebuilding operation at
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html#online-ddl-colum...

Whether adding a column actually rebuilds the table depends on whether
the INSTANT algorithm is used. If the operation is marked as "Instant
with comments"@ (denoted by the asterisk near "Yes" in the "Instant"
column), then it should also be marked as "non-rebuilding with comments",
i.e. say "No*" in the "Rebuilds Table" column.

How to repeat:
Look at the "Adding a column" row at 
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html#online-ddl-colum...
[21 Nov 2018 9:36] Umesh Shastry
Hello Alexey,

Thank you for the report!

regards,
Umesh
[24 Nov 2018 17:53] Daniel Price
Posted by developer:
 
The documentation has been updated as suggested. Changes should appear online soon.

Thank you for the bug report.
[25 Nov 2018 7:03] Alexey Kopytov
Sorry, I realized soon after posting it that "Only Modifies Metadata" for "Adding a column" should also say "Yes*", but I was hoping that part will also be reviewed along with "Rebuilds Table".