Bug #67971 Column comments double escaped
Submitted: 24 Dec 2012 8:40 Modified: 28 Dec 2012 4:54
Reporter: MaxiM Basunov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.44 OS:Linux (Ubuntu 12.04 LTS amd64)
Assigned to: CPU Architecture:Any
Tags: double escape, escape, export

[24 Dec 2012 8:40] MaxiM Basunov
Description:
Table's column comments is double-escaped:
CREATE  TABLE IF NOT EXISTS `mydb`.`table1` (
  `table1_id` INT NOT NULL COMMENT 'test\\\'s test' ,
  PRIMARY KEY (`table1_id`) )
ENGINE = MyISAM
COMMENT = 'test\'s test';

How to repeat:
Create new model.
Create new table.
Create new column in table.
Set column comment to "test's test" without double quotation.
Set table comment to same text as in field comment.
File -> Export -> Forward Engineer SQL Create script.
Leave all options by default (specify only target file name where to save contents).

Result:
In contents of generated file and in dialog box, a field's comment has been double escaped.

Expected result: single escaped comment.
[24 Dec 2012 8:42] MaxiM Basunov
Tried versions from 5.2.41 thru 5.2.44 - bug present in all these versions.
[24 Dec 2012 9:10] MaxiM Basunov
Confirmed on CentOS 6.3 x86_64 (WB 5.2.44)
[27 Dec 2012 14:42] Ruben Dario Morquecho Valdez
Hi, 
Thanks for bug opened. Its being analyzing.

Thanks for insterest in mysql!
[28 Dec 2012 4:54] Alfredo Kojima
Duplicate of bug #66680