Bug #95559 | Possible to change lower_case_table_names from 5.7 to 8.0 | ||
---|---|---|---|
Submitted: | 29 May 2019 11:41 | Modified: | 14 Nov 2019 17:14 |
Reporter: | Sivert Sørumgård | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Data Dictionary | Severity: | S3 (Non-critical) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[29 May 2019 11:41]
Sivert Sørumgård
[14 Nov 2019 17:14]
Daniel Price
Posted by developer: Fixed as of the upcoming 8.0.19 release, and here's the changelog entry: Changing the lower_case_table_name setting when upgrading from MySQL 5.7 to MySQL 8.0 could cause a failure due to a schema or table name letter case mismatch. If lower_case_table_names=1, table and schema names are now checked by the upgrade process to ensure that all characters are lowercase. If table or schema names are found to contain uppercase characters, the upgrade process fails with an error. For related information, see "Upgrade Prerequisites". Also updated: Upgrade Prerequisites: https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html Changes should appear online soon.