Bug #101804 program-variables docs still refers to unique option prefixes
Submitted: 30 Nov 2020 15:21 Modified: 1 Dec 2020 20:15
Reporter: Morgan Tocker Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7, 8.0 OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[30 Nov 2020 15:21] Morgan Tocker
See: https://dev.mysql.com/doc/refman/8.0/en/program-variables.html

A variable can be specified by writing it in full or as any unambiguous prefix. For example, the max_allowed_packet variable can be set for mysql as --max_a, but not as --max because the latter is ambiguous:

> shell> mysql --max=1000000
> mysql: ambiguous option '--max=1000000' (max_allowed_packet, max_join_size)

How to repeat:
This no longer works:

$ mysql --max=1000000
mysql: [ERROR] unknown variable 'max=1000000'.

$ mysql --max-allowed-p=1000000
mysql: [ERROR] unknown variable 'max-allowed-p=1000000'.

See https://dev.mysql.com/worklog/task/?id=6978

Suggested fix:
Remove the suggestion.
[30 Nov 2020 16:42] MySQL Verification Team
Hello Morgan,

Thank you for the report and feedback.

[1 Dec 2020 2:54] Jon Stephens
I'll take this one.
[1 Dec 2020 20:15] Jon Stephens
Fixed in the 5.7/8.0 versions of the Manual, in mysqldoc rev 68172.