Sqlyog 10.2 Bug Regarding Editing And Saving Triggers

[kmak]

We might have located a bug in SQLyog 10.2 (perhaps it exists on previous versions also)

We are using mysql 5.1.63

Since we upgraded in mysql 5.1 we have noticed a problem while editing triggers with sqlyog.

The single quotes are not escaped properly.

Lets suppose we have a code like this in the trigger:

SET vals = CONCAT(vals,','',CAST(NEW.issueDate AS CHAR),''');

When i edit the trigger in SQLyog i see:

SET vals = CONCAT(vals,','',CAST(NEW.issueDate AS CHAR),''');

which is not valid, the backslashes have been removed.

If i do a mysqldump from command line the trigger code is ok.

If i do a backup database as sql dump ( Ctrl+Alt+E) from inside the sqlyog then the code is again without the backslashes, it has syntax error problem.

Only in SQLyog it appears with the backslashes escaped. So if i want to save it again i must add the backslashes again …..

Thank you in advance.

[Author]

Posts