Trouble while debuging stored procedure (2.0.49)

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
soaron
Posts: 10
Joined: Mon 09 Jul 2007 20:49

Trouble while debuging stored procedure (2.0.49)

Post by soaron » Tue 10 Jul 2007 12:11

I try to save and debug procedure in
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html
like that:

PROCEDURE test.test()
BEGIN
PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
SET @a = 3;
SET @b = 4;
EXECUTE stmt1 USING @a, @b;
END

and catch this message:
Image

But in mysql console it works properly.

soaron
Posts: 10
Joined: Mon 09 Jul 2007 20:49

Post by soaron » Tue 10 Jul 2007 13:14

Using Concat function instead Execute...Using can solve this problem.

Duke
Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Post by Duke » Mon 06 Aug 2007 09:27

Try to re-deploy your debug engine.

Post Reply