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: Виталий Климин
• Status: Closed
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 8.0.13
• OS: Debian (9)
• 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.