MySQL Bugs: #6390: SHOW PROCEDURE/FUNCTION STATUS does not support FROM db

Bug #6390	SHOW PROCEDURE/FUNCTION STATUS does not support FROM db_name clause
Submitted:	2 Nov 2004 18:03	Modified:	8 Feb 2006 12:45
Reporter:	Paul DuBois	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	5.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS
statements do not support a FROM db_name clause the way
that SHOW TABLES does.  Makes it hard to list all routines
for any database other than the current database.

How to repeat:
See above.

Thank you for a reasonable feature request. We should be consistent with clauses of all the SHOW statements, whenever possible.