Bug #91074 INSTANT add column undocumented
Submitted: 30 May 10:13 Modified: 5 Aug 0:31
Reporter: Jaime Crespo (OCA) 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
Tags: ALGORITHM, alter, DDL, INSTANT add column

[30 May 10:13] Jaime Crespo
Description:
Instant add columns seems to have been added to MySQL 8.0 

This is the only official reference I found
https://mysqlserverteam.com/mysql-8-0-innodb-now-supports-instant-add-column/

A search on the documentation (the public version available) reveals no reference to the functionality or syntax.

How to repeat:
In particular, I would expect a reference on:

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

"  | ALGORITHM [=] {DEFAULT|INPLACE|COPY}"

and a full explanation on:

https://dev.mysql.com/doc/refman/8.0/en/innodb-create-index-overview.html
( 15.12.1 Online DDL Operations )

Suggested fix:
It would be nice if, in addition to the explanation, the tables about the "online" nature of each alter where added a new column "Instant"- although it may not make sense if there is no plans to extend it to other actions.
[30 May 10:25] Umesh Shastry
Hello Jaime,

Thank you for the report!

Thanks,
Umesh
[5 Aug 0:31] Paul Dubois
Posted by developer:
 
Added in 8.0.12. See:

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html#alter-table-performance
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-index-overview.html
[5 Aug 12:51] Daniel Price
Posted by developer:
 
Documentation:

(1) Release Note
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-12.html

(2) What's New
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html

(3) ALTER TABLE 
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html#alter-table-performance

(4) Online DDL section (Instant ADD column details, limitations, and examples.
Examples of other INSTANT operations were incorporated into the Online DDL
section as well. 
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-index-overview.html 
(See the Column Operations section for Instant ADD COLUUMN details)

(5) INNODB_TABLES.INSTANT_COLS
https://dev.mysql.com/doc/refman/8.0/en/innodb-tables-table.html

(6) INNODB_COLUMNS.HAS_DEFAULT and DEFAULT_VALUE
https://dev.mysql.com/doc/refman/8.0/en/innodb-columns-table.html