Bug #91648 Numeric literals must be a number between 0 and 9999

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

[16 Jul 2018 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 2018 6:59] MySQL Verification Team

Hello yghmgl yang,

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

Thanks,
Umesh