Devart Forums

Posted: **Sat 12 Apr 2008 20:30**

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.

Posted: **Sat 12 Apr 2008 20:34**

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

Posted: **Mon 14 Apr 2008 07:07**

We'll work over this problem.

Posted: **Sun 04 May 2008 05:32**

Duke wrote:We'll work over this problem.

Any progress on this, guys ?

Posted: **Mon 05 May 2008 07:25**

We'll notify you when the problem gets solved.

Posted: **Tue 06 May 2008 06:09**

Duke wrote: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

Posted: **Fri 09 May 2008 10:15**

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

Anxiously await a solution!

Kind regards,

Posted: **Wed 14 May 2008 07:36**

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

Devart Forums

"Commands out of sync" issue

"Commands out of sync" issue

Re: "Commands out of sync" issue