Bug #95918 Insufficient error messages while upgrading tables with generated columns
Submitted: 21 Jun 2019 11:13 Modified: 4 Sep 2019 18:19
Reporter: Sivert Sørumgård Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Data Dictionary Severity:S3 (Non-critical)
Version:8.0.17 OS:Any
Assigned to: CPU Architecture:Any

[21 Jun 2019 11:13] Sivert Sørumgård
While upgrading a table using generated columns from 5.7 to 8.x, if the column expression is invalid due to e.g. deprecations, the error message should mention not only the table name, but also the column name, and perhaps even more detailed information if possible.

How to repeat:
Upgrade e.g. a table with a generated column referring the 'password()' function.

Suggested fix:
Extend error message.
[4 Sep 2019 18:19] Daniel Price
Posted by developer:
Fixed as of the upcoming 8.0.19 release, and here's the changelog entry:

The error message reported when attempting to upgrade tables with invalid
expressions for generated columns did not provided sufficient information.
The error message now includes the generated column name and the
expression used to create the generated column.