Bug #94132 | The description of "13.1.16 ...CREATE FUNCTION Syntax" chapter is not rigorous | ||
---|---|---|---|
Submitted: | 30 Jan 2019 8:40 | Modified: | 25 Apr 2019 14:29 |
Reporter: | JianJun Shi | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S4 (Feature request) |
Version: | 5.7 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[30 Jan 2019 8:40]
JianJun Shi
[30 Jan 2019 14:05]
MySQL Verification Team
Hi, Thank you for your bug report. I fully agree with your conclusions. Verified as reported.
[30 Jan 2019 14:05]
MySQL Verification Team
A documentation bug.
[25 Apr 2019 14:29]
Paul DuBois
Posted by developer: Added a clarifying final sentence to this paragraph at https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html: The routine_body consists of a valid SQL routine statement. This can be a simple statement such as SELECT or INSERT, or a compound statement written using BEGIN and END. Compound statements can contain declarations, loops, and other control structure statements. The syntax for these statements is described in Section 13.6, “Compound-Statement Syntax”. In practice, stored functions tend to use compound statements, unless the body consists of a single RETURN statement.