Bug #98071 The random_bytes behavior does not match the document

• Submitted: 25 Dec 2019 13:06
• Modified: 13 Jan 2020 12:25
• Reporter: Rustin Liu
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7, 8.0
• OS: Any
• CPU Architecture: Any

[25 Dec 2019 13:06] Rustin Liu

Description:
The random_bytes behavior does not match the document.

If we pass an overflow parameter to random_bytes it will return an error. But in the document it said RANDOM_BYTES() generates a warning.

https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_random-bytes

How to repeat:
Pass 0 or 2333 to RANDOM_BYTES().

Suggested fix:
Update the document.

[25 Dec 2019 13:20] Rustin Liu

The error look like:
ERROR 1690 (22003): length value is out of range in 'random_bytes'

[26 Dec 2019 7:25] MySQL Verification Team

Hello Rustin Liu,

Thank you for the report.

Thanks,
Umesh