MySQL Bugs: #13065: Allow multiple resultsets with prepared statement interface

Bug #13065	Allow multiple resultsets with prepared statement interface
Submitted:	8 Sep 2005 14:12	Modified:	29 May 2012 13:39
Reporter:	Anders Karlsson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S4 (Feature request)
Version:	5.0.10	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently, there seems to be now way to use the prepared statement API when calling a Stored Procedure that returns more than one resultset. This is a rather severe limitation for both stored procedures, as one can only have one active at the time. There are additional issues with this, such as the metadata for a result obviously will be different when a new resultset is fetched.

How to repeat:
There is no mysql_stmt_next_result(MYSQL_STMT *) call in libmysql.

This is already implemented. See http://dev.mysql.com/doc/refman/5.5/en/mysql-stmt-next-result.html etc