Bug #56368 Add a seperate section in Object Browser for Functions
Submitted: 30 Aug 2010 14:01 Modified: 31 Jul 2013 1:56
Reporter: charl retief Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.26 OS:Any
Assigned to: CPU Architecture:Any

[30 Aug 2010 14:01] charl retief
Description:
I have a big database with lots of stored functions and routines.
Currently all 150+ stored routines and functions are located under 'Routines' section of the 'Object Browser'.

As stored functions and routines are 2 completely different things, I want them listed under separate sections.

PS: 'Functions' and 'Routines' can be distinguished by these queries:
SHOW FUNCTION STATUS WHERE `Db`='test123';
SHOW PROCEDURE STATUS WHERE `Db`='test123';

How to repeat:
N/A

Suggested fix:
Add a extra section under the 'Tables', 'Views' and 'Routines' for 'Functions'.
All stored functions of a database must be located in the section.

Also when you right click on the 'Functions' section the right click menu should have a 'Create Function...' item.

Here is a sample of a 'Function DDL' statement for 'Create Function...':

-- --------------------------------------------------------------------------------
-- Function DDL
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE FUNCTION `dbname`.`new_function`(`param1` INT)
RETURNS VARCHAR(255) 
BEGIN

END$$
[30 Aug 2010 14:02] charl retief
Functions sections

Attachment: mysql_functions_feature_request.jpg (image/jpeg, text), 29.49 KiB.

[30 Aug 2010 14:33] Valeriy Kravchuk
Thank you for the feature request.
[31 Jul 2013 1:56] Philip Olson
Fixed as of MySQL Workbench 6.0.4, and here's the changelog entry:

A "Functions" section was added to the "SCHEMAS" viewer in the Object
Browser, to go along with the current "Tables", "Views", and "Stored
Procedures" sections.

Thank you for the bug report.