Bug #91648 Numeric literals must be a number between 0 and 9999
Submitted: 16 Jul 6:30 Modified: 16 Jul 6:59
Reporter: yghmgl yang Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7, 8.0.11 OS:Any
Assigned to: CPU Architecture:Any

[16 Jul 6:30] yghmgl yang
Description:
Doc said that Numeric literals must be a number between 0 and 9999 in https://dev.mysql.com/doc/refman/5.7/en/create-server.html, bug we can set the options to bigger than 9999, it still worked.

How to repeat:
create server SERVER_TEST_01
foreign data wrapper mysql options(
host 'host',
database 'database',
user 'user',
password 'password',
socket 'socket',
owner 'owner',
port 10000
);
create server SERVER_TEST_02
foreign data wrapper mysql options(
host 'host',
database 'database',
user 'user',
password 'password',
socket 'socket',
owner 'owner',
port 99999
);

select * from mysql.servers;
[16 Jul 6:59] Umesh Shastry
Hello yghmgl yang,

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

Thanks,
Umesh