MySQL Bugs: #91074: INSTANT add column undocumented

Bug #91074	INSTANT add column undocumented
Submitted:	30 May 2018 10:13	Modified:	5 Aug 2018 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

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.

Hello Jaime,

Thank you for the report!

Thanks,
Umesh

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

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