Bug #91650 create server with a long server name

• Submitted: 16 Jul 2018 6:44
• Modified: 16 Jul 2018 6:57
• Reporter: yghmgl yang
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.7, 8.0.11, 5.7.22
• OS: Any
• CPU Architecture: Any

[16 Jul 2018 6:44] yghmgl yang

Description:
Create server, let the server name more than 64 characters,the server name will be truncated to to 64 characters, but you can't use the truncated 64 name to delete the server

How to repeat:
create server ABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCD567
foreign data wrapper mysql options(
host 'host',
database 'database',
user 'user',
password 'password',
socket 'socket',
owner 'owner',
port 9999);

select * from mysql.servers;

drop server ABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCD;

drop server ABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCDEFGHIJABCD567;

[16 Jul 2018 6:57] MySQL Verification Team

Hello yghmgl yang,

Thank you for the report.
Observed this with even 8.0.11.

Thanks,
Umesh