Bug #93972 mysql_upgrade does not process tables containing national characters in the name
Submitted: 18 Jan 2019 6:08 Modified: 21 May 2019 17:03
Reporter: Виталий Климин Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:8.0.13 OS:Debian (9)
Assigned to: CPU Architecture:Any

[18 Jan 2019 6:08] Виталий Климин
Description:
The program mysql_upgrade does not process tables containing national characters in the name.

How to repeat:
Create any table with national characters in the name

USE DB
CREATE TABLE `Я-test` (
  `test` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

Run mysql_upgrade from a terminal:

# mysql_upgrade -uroot -p --force

Get the error:

Checking server version.
Running queries to upgrade MySQL server.
Upgrading system table data.
Checking system database.

<cut>

DB.?-test                                     To be repaired, cause follows:
Server issued Error    : Table 'DB.?-test' doesn't exist
status   : Operation failed

Repairing tables
DB.?-test
Error    : Table 'DB.?-test' doesn't exist
status   : Operation failed
Upgrade process completed successfully.
[18 Jan 2019 8:37] MySQL Verification Team
Hello Виталий,

Thank you for the report and feedback.

regards,
Umesh
[21 May 2019 17:03] Paul DuBois
Posted by developer:
 
Fixed in 8.0.16.

mysql_ugprade is no longer functional, so this bug is no longer relevant.