Create Stored Procedure

[slines]

Bug: Sqlyog crashes immediately and terminates.

There is a two step process to recreate this bug:

1) Post the sql statement below into a query window

2) type set @Offic_ on a new line right above the END WHILE;

DELIMITER $$

USE `raceform`$$

DROP PROCEDURE IF EXISTS `pop_rpt_tmp_crop_stats_crops`$$

CREATE PROCEDURE `(e)setReportCollected`()

BEGIN

UPDATE

`(e)individualreport`

SET

`isCollection`=’1′

WHERE

`InvoiceNumber`

IN

(SELECT `InvoiceNumber` FROM `invoice` WHERE `Collected` = ‘1’ AND (`InvoiceNumber` LIKE ‘%I-13%’ OR `InvoiceNumber` LIKE ‘%I-12%’));

END $$

 

DELIMITER ;

 

If execute above procedure, the error message is appear that you have an error in your SQL syntax in line 4(red color in above), error no. 1064

 

I saw the one forum mentioned that if run in tools and it will appear an error, but run in command line is o.k. Anyone can teach me step by step to fix this problem because I am a novice. 

 

Thanks!

Micklo

 

[sathish]

Hello,

Issue reproducible. This will be fixed and will be available in next public release.

Regards,

Sathish

[S. Lines]

Hi,

Can you give us some insight into the issue, or when you may have a new release of sqlyog out?

We need to complete development of the stored procedure for a client.

Thanks,

Scott

[Jan.S]

Hi,

This is due to an issue in autocomplete where it does not handle insert statements in stored procedures properly. We are working on fixing it right now.

In the meantime, you can go to Tools->Preferences->Power Tools and uncheck the enable autocomplete option. This will enable you to continue working on the stored procedure.

We will let you know once the issue has been fixed.

[Author]

Posts