"Commands out of sync" issue

[ruslanv]

Hey guys. I found another bug. MyDeveloper Studio is getting stuck with "Commands out of sync" error. Here are steps to reproduce:

1) Create new stored procedure with following code:

Code: Select all

CREATE PROCEDURE GetTest(IN nTestId INT(11))
BEGIN
    select 0, 1, 3
    union
    select 4, 5, 6;
    select "A", "B";
END

2) Call it using query "call GetTest(0);".
3) You will see first resultset with numbers.
4) Now you're screwed. Any further queries will cause "Commands out of sync" error. All you can do is to restart MyDeveloper Studio which obviously sucks.

As I see here

http://dev.mysql.com/doc/refman/5.0/en/ ... -sync.html

it's client-side problem (MyDeveloper Studio in this case) which doesn't fetch all returned recordsets or at least doesn't cleanup statement object. I tested same SP in Aqua Data Studio and it works fine. I know that I can see both recordsets if I switch to Card View mode, but still mysql_free_result() needs to be called.

Thank you.

[ruslanv]

I was little bit incorrect. After step #3 you have to reconnect to DB, but sometime it makes MyDeveloper Studio process frozen.

[Duke]

We'll work over this problem.

[ruslanv]

We'll work over this problem.

Any progress on this, guys ?

[Duke]

We'll notify you when the problem gets solved.

[earlati]

We'll notify you when the problem gets solved.

I will be interested in such issue, though I have similar problem.
Please notify also me about the priblem solution


regards, Enzo

[richardvk]

I appreciate that this problem is being looked into, it is causing me many problems.

Anxiously await a solution!

Kind regards,

[Duke]

We have fixed the problem. Look forward for the next build.