Bug #80832 | ALTER TABLE MODYIFY COLUMN does not set ALTER_CHANGE_COLUMN_DEFAULT flag | ||
---|---|---|---|
Submitted: | 23 Mar 2016 8:46 | Modified: | 16 Nov 2016 19:19 |
Reporter: | Olav Sandstå | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
Version: | 5.7.13 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[23 Mar 2016 8:46]
Olav Sandstå
[16 Nov 2016 19:19]
Paul DuBois
Posted by developer: Noted in 8.0.1 changelog. In-place ALTER TABLE operations are now possible for column modifications of tables containing generated columns that depend on columns with a DEFAULT value if the modified columns are not involved in the generated column expressions. For example, changing the NULL property of a separate column can be done in place without a table rebuild.