Bug #68456 Errors in the use of variables from the execution of the connector net

• Submitted: 21 Feb 2013 14:26
• Modified: 21 Feb 2013 20:52
• Reporter: Sebastian Pratto
• Status: Not a Bug
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 6.6.5
• OS: Any
• Assigned to: Fernando Gonzalez.Sanchez
• CPU Architecture: Any
• Tags: connector net, variables

[21 Feb 2013 14:26] Sebastian Pratto

Description:
The net connector reports an error when using the symbol ":" in assigning values ​​to variables when necessary to accumulate such balances.

Example:

SET @a=0;
SELECT numero, referencia, importe, @a:=@a + importe FROM asientos;

How to repeat:
Always

Suggested fix:
Urgent...

[21 Feb 2013 20:52] Fernando Gonzalez.Sanchez

Hi,

You need to add ";AllowUserVariables=true;" to the ConnectionString
(see http://dev.mysql.com/doc/refman/5.0/en/connector-net-connection-options.html for more details).

that should fix it, otherwise let us know.