MySQL Bugs: #43276: Schemata qualifiers always generated for Stored Procedures

Bug #43276	Schemata qualifiers always generated for Stored Procedures
Submitted:	28 Feb 2009 12:56	Modified:	12 Nov 2009 11:54
Reporter:	Petr Vones	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.30	OS:	Windows (Windows Server 2003 Std)
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	PROCEDURE, schema qualifier, TTREV

Description:
Forward Engineer to SQL Script function always generates schema qualifier for Stored Procedure names regardless of "Omit schemata qualifiers from output" checkbox is checked or not. 

Note: it works correctly for table names

How to repeat:
1. Create new Routine with default name "routine1"

DELIMITER //

CREATE PROCEDURE `mydb`.`routine1` ()
BEGIN
  SELECT * FROM MyTable
END//

2. File | Export | Forward Engineer to SQL Script
3. Check "Omit schemata qualifiers from output" option in the dialog
4. Enter an output file Name
5. Next
6. Finish

Expected: The procedure name is generated without "mydb" schema prefix in resulted SQL script file.

Actual: The procedure name has "mydb" schema prefix in resulted SQL script file.

Thank you for bug report. Related to the bug report: http://bugs.mysql.com/bug.php?id=43058

fixed in sourcecode. fix will be included in 5.2.7

An entry was added to the 5.2.7 changelog:

Forward Engineer SQL CREATE Script generated schema qualifiers for Stored Procedure names regardless of the setting of the Omit schemata qualifiers from output checkbox. This resulted in the generated script containing Stored Procedure names prefixed by the schema name.