Bug #44910 New SQL IDE does not support results from routines
Submitted: 15 May 2009 20:26 Modified: 22 Jun 2009 10:44
Reporter: Marcin Jakubowski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2 Alpha 1 OS:Windows (7 RC)
Assigned to: Sergei Tkachenko CPU Architecture:Any

[15 May 2009 20:26] Marcin Jakubowski 
Description:
The new SQL IDE, introduced in 5.2, does not support returning results from procedures. When any routine is called, there are no results shown in the query editor window, as with any other select statement; log reports "Response: OK". 
When another query is run on the same connection, Response is: "Error Code: 2014
Commands out of sync; you can't run this command now".

Server info:
select version() := 5.0.67-userstats-log

How to repeat:
delimiter $$

create procedure reproduce()
begin
select 1 as "bug";
end $$

delimiter ;

call reproduce()
[16 May 2009 14:50] MySQL Verification Team 
Thank you for the bug report.
[18 May 2009 21:45] Sergei Tkachenko 
Fix was pushed to internal repository.
[22 May 2009 9:21] Sergei Tkachenko 
Fixed in v5.2.1
[22 May 2009 19:16] Marcin Jakubowski 
Reopening the bug. Single result set is returned from the stored routine but same error message appears (2014) when the stored routine returns multiple result sets.

How to repeat:
delimiter $$

create procedure reproduce()
begin
select 1 as "bug";
select 2 as "bug";
end $$

delimiter ;

call reproduce()
[12 Jun 2009 12:41] Johannes Taxacher 
this is fixed in our repository and will go into 5.2.2.
for multiple resultsets WB now creates multiple result-tabs.
[22 Jun 2009 10:44] Tony Bedford 
An entry was added to the 5.2.2 changelog:

The new SQL IDE, introduced in 5.2, did not support returning results from procedures. When any routine was called, there were no results displayed in the query editor window. However, the log contained the message “Response: OK”.

When another query was run on the same connection, the log message was:

Error Code: 2014 Commands out of sync; you can't run this command now