MySQL Bugs: #7133: Invalid query string when using inout parameters

Bug #7133	Invalid query string when using inout parameters
Submitted:	9 Dec 2004 17:15	Modified:	9 Dec 2004 21:46
Reporter:	Paul Hyman
Status:	Closed
Category:	Connector/Net	Severity:	S2 (Serious)
Version:	1.0.2	OS:	Microsoft Windows (Windows2000)
Assigned to:	Reggie Burnett	Target Version:

Description:
When calling a stored procedure with inout parameters, connector/net constructs a query
consisting of a SET statement followed by the call.  However, an extra semicolon is
placed in the string, which looks something like:
SET ?12345parameter=value;;call procedure(...);

This is happening because when the SET string is being built, after each parameter is
added to the set statement a semicolon is placed at the end of the string and when the
entire SET string has been constructed another semicolon is added.  This last semicolon
is not needed and causes the query to fail.

How to repeat:
Create a stored procedure with an inout parameter and call it from .NET code.

Suggested fix:
remove the statement adding the final semicolon.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html