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 Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.7.25-log OS:Ubuntu
Assigned to: CPU Architecture:Any

[18 Feb 2019 16:58] Paul Cre
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] Umesh Shastry
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.