Bug #95921 | Prefix index length ignored while upgrading partitioned tables. | ||
---|---|---|---|
Submitted: | 21 Jun 2019 11:33 | Modified: | 26 Nov 2019 3:49 |
Reporter: | Sivert Sørumgård | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Enterprise Backup Documentation | Severity: | S3 (Non-critical) |
Version: | 8.0.17 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[21 Jun 2019 11:33]
Sivert Sørumgård
[26 Nov 2019 3:49]
Paul DuBois
Posted by developer: Fixed in 8.0.19. During upgrade of partitioned tables from MySQL 5.7 to 8.0, when a prefix key was used by the partitioning function, the prefix length was ignored, and the full column length was considered instead. Consequently, the table might incorrectly be rejected from being upgraded because its partition field length was found to be too large.