| Bug #11664 | information_schema.ROUTINES does not show mysql builtin functions | ||
|---|---|---|---|
| Submitted: | 30 Jun 2005 12:22 | Modified: | 7 Jul 2005 6:52 |
| Reporter: | Roland Bouman | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.7 | OS: | NA |
| Assigned to: | Sergei Glukhov | CPU Architecture: | Any |
[7 Jul 2005 6:52]
Sergei Glukhov
The section that you quote, which is not in the SQL:2003 version of the foundation document, refers to a feature that does not precisely correspond with the way that MySQL works. Our built-in routines are not in the catalog. For ease of maintenance, we prefer to document them in only one place: the MySQL manual.
[7 Jul 2005 11:23]
Roland Bouman
Ok, fair enough. Thanks for your effort and attention.
Description: The information_schema.ROUTINES does not contain rows for the mysql builtin functions, whereas {ISO 9075:1999 2 / 4.24} does seem to require it, at least for the builtin functions considered standard: 4.24 Built-in functions Certain SQL operators whose invocation employs syntax similar to that of <routine invocation> are designated built-in functions. Those that are so designated are those that appear in the result of the following <query expression>: SELECT DISTINCT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_SCHEMA = ’INFORMATION_SCHEMA’ Some built-in functions are defined in this part of ISO/IEC 9075. It is implementation-defined whether there are built-in functions other than those defined in this part of ISO/IEC 9075. How to repeat: NA Suggested fix: Populate the information_schema.ROUTINES table with the mysql builtin functions. It would make it all more complete and consistent (after all, the information schema does show information about the columns and tables of the information schema itself). Also, query tools etcetera would benefit from this and offer the user a menu or expression builder based on this information.