Bug #91650 create server with a long server name
Submitted: 16 Jul 2018 6:44 Modified: 16 Jul 2018 6:57
Reporter: yghmgl yang Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.7, 8.0.11, 5.7.22 OS:Any
Assigned to: 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] Umesh Shastry
Hello yghmgl yang,

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

Thanks,
Umesh