Bug #12939 Can't retrieve INOUT parameters from stored procedures
Submitted: 1 Sep 2005 21:38 Modified: 7 Sep 2005 15:23
Reporter: Mark Matthews Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.13 (from BK, AUG 31) OS:Linux (RHEL4/FC3)
Assigned to: Assigned Account CPU Architecture:Any

[1 Sep 2005 21:38] Mark Matthews
Description:
The following sequence of queries in "How to repeat" using stored procedures fails to return a result (and thus fails our JDBC unit tests dealing with stored procedures).

The same sequence works on 5.0.12.

How to repeat:
DROP PROCEDURE IF EXISTS testInOutParam;

DELIMITER |
create procedure testInOutParam(INOUT foo VARCHAR(15))
begin
select concat(foo, foo) INTO foo;
end
|
DELIMITER ;

SET @com_mysql_jdbc_outparam_foo='abcd';
CALL testInOutParam(@com_mysql_jdbc_outparam_foo);
SELECT @com_mysql_jdbc_outparam_foo;
DROP PROCEDURE testInOutParam;
[2 Sep 2005 3:37] Jorge del Conde
Verified w/5.0.13bk

mysql> SELECT @com_mysql_jdbc_outparam_foo;
+------------------------------+
| @com_mysql_jdbc_outparam_foo |
+------------------------------+
|                              |
+------------------------------+
1 row in set (0.00 sec)

mysql>
[2 Sep 2005 13:44] Matthias Leich
It looks like this bug is a duplicate of Bug#12849.
Please have a look on my comment to Bug#12849.
[7 Sep 2005 15:23] Petr Chardin
This is a duplicate of Bug #12849 "Stored Procedure: Crash on procedure call with CHAR type 'INOUT' parameter"
[8 Sep 2005 15:28] 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/internals/29508