Bug #62090 | Syntax Error using delimiter with MySqlCommand | ||
---|---|---|---|
Submitted: | 5 Aug 2011 9:25 | Modified: | 8 Aug 2011 17:03 |
Reporter: | Simon Höddels | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Connector / NET | Severity: | S2 (Serious) |
Version: | 6.4.3 | OS: | Windows |
Assigned to: | Fernando Gonzalez.Sanchez | CPU Architecture: | Any |
Tags: | DELIMITER, MySqlCommand |
[5 Aug 2011 9:25]
Simon Höddels
[5 Aug 2011 9:27]
Simon Höddels
Suggested fix is a workaround. Not a suggested fix. Mixed that up. Sorry! Suggested fix would be to make DELIMITER work in MySqlCommand. ;)
[8 Aug 2011 17:03]
Fernando Gonzalez.Sanchez
Hi Simon, Thanks for your report, actually MySqlCommand lack of support of custom delimiter is by design, and it won't be supported. As you suggested (and as stated by the comment in class MySqlScript: Provides a class capable of executing a SQL script containing multiple SQL statements including CREATE PROCEDURE statements that require changing the delimiter.), if you need to use Delimiter, you have stick to MySqlScript. Thanks.