Bug #66759 Escape character is tripled in comments

• Submitted: 10 Sep 2012 22:34
• Modified: 2 Apr 2013 14:08
• Reporter: David Btm
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.47
• OS: MacOS (10.8.2)
• CPU Architecture: Any
• Tags: backslash, character, comment, create, escaped, export, script, tripled

[10 Sep 2012 22:34] David Btm

Description:
when exporting a sql create script, triple escaped character (\\\) is used to escape symbols in the comments instead of a single one (\).

How to repeat:
- create a table
- add a field
- set comment to "nom de l'utilisateur"
- File > Export > Forward Engineer SQL CREATE script...
- Continue
- Continue
in the Review window you can see that comment appears to:
 'nom de l\\\'utilisateur'
instead of:
 'nom de l\'utilisateur'
- Finish
in the generated script file, same thing.

[11 Sep 2012 0:58] MySQL Verification Team

Thank you for the bug report. Verified on Windows.

[25 Feb 2013 16:57] Armando Lopez Valencia

Hello.
Can you please verify with the latest WB version (5.2.47)?
It appears fixed for me:
CREATE  TABLE IF NOT EXISTS `mydb`.`table1` (

  `idtable1` INT NOT NULL COMMENT 'nom de l\'utilisateur' ,

  PRIMARY KEY (`idtable1`) )

ENGINE = InnoDB;
Thanks.

[26 Mar 2013 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[27 Mar 2013 1:42] David Btm

Yes, fixed for me with WB 5.2.47.

[2 Apr 2013 14:08] Armando Lopez Valencia

Nice!
Thanks a lot for your report.