Bug #34699 Calling a stored procedure with allow user variables set to false fails
| Submitted: | 20 Feb 2008 18:17 | Modified: | 1 Mar 2008 10:19 |
|---|---|---|---|
| Reporter: | Reggie Burnett | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / NET | Severity: | S3 (Non-critical) |
| Version: | 5.2 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[20 Feb 2008 18:17]
Reggie Burnett
[21 Feb 2008 17:07]
Stefan Gottschalk
Hello, i have a similar exception with the Connector.NET v5.2. I insert a row to a Table with a Trigger "after insert". In this Trigger I set a variable @new_id. When I execute the Query "insert into `table` ...; Select @new_id;" i get the same exception. In the earlier versions of Connector.Net it works fine.
[21 Feb 2008 21:38]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/42789
[21 Feb 2008 21:38]
Reggie Burnett
Fixed in 5.2.1
[1 Mar 2008 10:19]
MC Brown
A note has been added to the 5.2.1 changelog: When executing statements that used stored procedures and functions, the new parameter code could fail to identify the correct parameter format.
[17 Oct 2008 15:21]
Stefan Gottschalk
Hello,
i just installed the Connector.net 5.2.3 and the Problem is still the same.
I insert a row to a Table with a Trigger "after insert". In this Trigger I set a variable @new_id like this:
CREATE TRIGGER tr_TestTable_after_insert AFTER INSERT ON TestTable
FOR EACH ROW BEGIN
SET @new_id = NEW.id;
END IF;
END
When I execute the Query "insert into `TestTable` ...; Select @new_id;" i get the same exception:
"Parameter '@new_id' must be defined."
In the earlier versions of Connector.Net it works fine.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.