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

[24 Jun 2009 0:36] Mikiya Okuno
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