BUG: stored procedure parameter with single quotes

[brnwdrng]

I've noticed that sproc parameters of type ENUM with single quotes (') do not load correctly using MySQLDirect.NET inside VS2005. For example:

Code: Select all

PROCEDURE `mydb`.`mysproc`
(
	IN _Entity_ID CHAR(4), 
	IN _Restriction_For ENUM('OutBound','InBound'),
	IN _Restriction_Type ENUM('White','Black'),
	IN _Number VARCHAR(16),
	IN _Description VARCHAR(100)
)
BEGIN
      --
END

This saves and runs (it's valid MySQL code); however, when the sproc is next opened via DBExplorer, it displays the code like this, which is missing a lot of stuff in the parameter list:

Code: Select all

PROCEDURE `mydb`.`mysproc`(IN _Entity_ID CHAR(4), IN _Restriction_For ENUM(OUTBOUND, IN _Restriction_Type ENUM(WHITE, IN _Number VARCHAR(16), IN _Description VARCHAR(100))
BEGIN
      --
END

This of course errors out, and prevents one from saving mysproc (in fact, it deletes it altogether).

I'm using the DBExplorer/MySQLDirect.NET 3.55 inside VS2005Pro SP1.

[Duke]

We'll fix this problem in the next release of MySQL Developer Tools