Bug #115874 MID(str,pos) is missing from function docs

Submitted: 20 Aug 2024 14:04 Modified: 27 Aug 2024 9:29
Reporter: Daniël van Eeden Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.4.0, 9.0.1 OS:Any
Assigned to: CPU Architecture:Any

[20 Aug 2024 14:04] Daniël van Eeden
Description:
The MID() function can be used with 2 or 3 arguments. Only the version with 3 arguments is in the docs.

How to repeat:
mysql-9.0.1> SELECT MID('abc',2);
+--------------+
| MID('abc',2) |
+--------------+
| bc           |
+--------------+
1 row in set (0.00 sec)

Suggested fix:
Add MID(str,pos) or change to MID(str,pos,[len])
[21 Aug 2024 5:38] MySQL Verification Team
Hello Daniël,

Thank you for the report and feedback.

regards,
Umesh
[27 Aug 2024 9:29] Edward Gilmore
Posted by developer:
 
The documentation is updated. Thank you for the bug report.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.