Bug #11345 Pregenerated code of function "CREATE PROCEDURE" uses inconsistent delimiters

• Submitted: 15 Jun 2005 9:10
• Modified: 29 Jun 2005 17:16
• Reporter: Kai Sautter (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.10
• OS: Windows (Windows XP (SP2))
• Assigned to: Vladimir Kolesnikov
• CPU Architecture: Any

[15 Jun 2005 9:10] Kai Sautter

Description:
Using the menu function

Script | Create stored procedure / function

results in a pregenerated code that has inconsistent delimiters:

DELIMITER $$

DROP PROCEDURE IF EXISTS `testdb`.`test`\\
CREATE PROCEDURE `testdb`.`test` ()
BEGIN

END$$

DELIMITER ;

The delimiter is set to "$$", but the delimiter used after the DROP PROCEDURE statement is "\\".

The same applies if you want to create a function this way.

This seams to result from a change in the delimiter used by this functionality, which - if i remember it correctly - used to be "\\" in earlier versions.

How to repeat:
(1) Execute function Script| Create stored procedure / function
(2) Enter a procedure or function name
(3) Select either Create PROCEDURE or Create FUNCTION