MySQL Bugs: #10085: Simple stored procedure execution

Bug #10085	Simple stored procedure execution - beta 5
Submitted:	22 Apr 2005 9:22	Modified:	11 Dec 2006 20:01
Reporter:	Kirk Royster	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	5.0 beta	OS:	Windows (Win XP)
Assigned to:	Peter Harvey	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Create simple stored procedure in mysql, "select * from test.wkr" returns two rows of character data.  Can execute it manually, works fine.  But from ODBC client app through your connector, gets the following message:

Error 9900  Select in a stored procedure must have INTO

The stored procedure is:

CREATE PROCEDURE `mysql`.`sp_test`()
BEGIN
select * from test.wkr ;
END

wkr table has two columns, each char 40 type.

How to repeat:
Simply create a new table, then the sp, then test it via ODBC connect.

Duplicate of bug:
http://bugs.mysql.com/bug.php?id=2273

And yeah. Can we please, pretty please, have an update on when to expect MyODBC-3.53?

SP execution is working in 5.00.10 release.