BUG: stored procedure parameter with single quotes
Posted: Tue 06 Feb 2007 19:03
I've noticed that sproc parameters of type ENUM with single quotes (') do not load correctly using MySQLDirect.NET inside VS2005. For example:
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:
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.
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
--
ENDCode: 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
--
ENDI'm using the DBExplorer/MySQLDirect.NET 3.55 inside VS2005Pro SP1.