MySQL Bugs: #45693: Please Add New I_S Table Named FUNCTIONS And SHOW FUNCTIONS Command

Bug #45693	Please Add New I_S Table Named FUNCTIONS And SHOW FUNCTIONS Command
Submitted:	24 Jun 2009 0:36
Reporter:	Mikiya Okuno	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	any	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
There's no way to list all available UDFs in the system, except for seeing mysql.func table. Yes, this is very simple and easy way. But the table doesn't indicate that the function is really available on the system or not. Some .so files might be removed while the server is offline.

We need a way to see the all available UDFS in the running system. I propose adding two ways:

o INFORMATION_SCHEMA.FUNCTIONS table
o SHOW FUNCTIONS command

If they can list native functions as well as UDFs, it would be great! It would come in handy because people don't need to consult with the reference manual to see what functions mysql has ;)

How to repeat:
n/a

Suggested fix:
n/a