Bug #94385 Using DEFAULT to insert rows in to a table a generated column for insert select

• Submitted: 18 Feb 2019 16:58
• Modified: 19 Feb 2019 4:53
• Reporter: Paul Cre
• Status: Not a Bug
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 5.7.25-log
• OS: Ubuntu
• CPU Architecture: Any

[18 Feb 2019 16:58] Paul Cre

Description:
I cannot find a way to insert rows into a table with a generated column using insert select command without specifying all the none generated columns, e.g. 

insert into `table1` select `column`, `column2`, DEFAULT from `table2`;

How to repeat:
Try commands.

[19 Feb 2019 4:53] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. 
Please check our official manual page for more details - https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.