RISE MySQL Code Generator Error

[ganesan_...@yahoo.com]

Hi,

The SQL script generated by MySQL generator does not work. I am using MySQL workbench 5.2.36 CE, Installed MySQl CE 5.5.
1. It generates double quote, which MySQL throws error at.

See sample generated code below:
a. Errors at DROP PPROCEDURE, Error 1064
=> I remove DROP PROCE.. line, then
b. Errors at CREATE PROCE..,Error 1064, then I remove the double quote, then errors goes to
c. DECLARE "model...

i removed all the double quotes in the generated quote then it works.

Is there a setting so that the double quote is not generated.

I also have the postgreSQL generator installed. That works with PostgresSQL

Hope you can reply.

Thank you,
Ganesan

Sample:
DELIMITER GO
SET SESSION sql_mode = 'ANSI';
GO -- 'end-of-command
DROP PROCEDURE IF EXISTS "sp_install_rise_model";
GO -- 'end-of-command
CREATE PROCEDURE "sp_install_rise_model"()
BEGIN
DECLARE "model_id" INT;
DECLARE "log_id" INT;
DECLARE "completed_timestamp" TIMESTAMP;
DECLARE "start_timestamp" TIMESTA

[zan....@gmail.com]

I have the same error problems. Anyone can help?

[Cameron Rout]

I had some similar problems where it threw an error related to
property names with spaces (usually a sign of a ansi quotation error).
Refactoring worked though, so I didn't mention it.

On 10 July 2012 00:54, <zan....@gmail.com> wrote:
> I have the same error problems. Anyone can help?
>
> On Sunday, January 1, 2012 3:25:50 PM UTC+7, (unknown) wrote:
>>

> --
> You received this message since you subscribe to the "RISE" Google Group.
> To add a message to the group, send an e-mail to risee...@googlegroups.com
> To end the subscription of this group, send an e-mail to
> riseeditor+...@googlegroups.com
> For more alternatives, visit this group at
> http://groups.google.com/group/riseeditor?hl=en

[Joar Swenning]

Hi,

I'm not sure at all but, maybe it is related to the issue discussed in this old thread:

https://groups.google.com/forum/?fromgroups#!topic/riseeditor/mOaDEu4CnDM%5B1-25%5D

Best regards,

Joar