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
Triage: Triaged: D5 (Feature request)

[2 Nov 2004 18:03] Paul Dubois
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.
[8 Feb 2006 12:45] Valeriy Kravchuk
Thank you for a reasonable feature request. We should be consistent with clauses of all the SHOW statements, whenever possible.