Bug #64630 Copy/Paste Row Content doesn't work properly.

• Submitted: 13 Mar 2012 8:27
• Modified: 23 Jul 2012 23:51
• Reporter: Vitaliy Liubezny
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.38 CE
• OS: Any
• CPU Architecture: Any

[13 Mar 2012 8:27] Vitaliy Liubezny

Description:
Copy/Paste Row Content doesn't work properly.

How to repeat:
>Preconditions:
You need a table with string fields (varchar(45)). You can just create it in test DB:

CREATE  TABLE `test`.`new_table` (
  `idnew_table` INT NOT NULL ,
  `my_field` VARCHAR(45) NULL ,
  PRIMARY KEY (`idnew_table`) );

1. Open the table with SQL Editor to edit data.
2. Fill the fist row: 
INSERT INTO `test`.`new_table` (`idnew_table`, `my_field`) VALUES (1, 'Plan \'Light\'');
3. Select this row and press "Copy Row Data"
(Data in clipboard: '1', 'Plan ''Light''')
4. Select new row and press "Paste Row".

Expected:
New row is identical to old one.

Actual:
Column "my_field" has value Plan ''Light'' in new row.
(Should be Plan 'Light')

[13 Mar 2012 8:33] Valeriy Kravchuk

Thank you for the bug report. Verified on Windows XP.

[13 Mar 2012 8:50] Vitaliy Liubezny

Result of Copy/Paste Row Content

Attachment: CopyPaste.PNG (image/x-png, text), 3.64 KiB.

[23 Jul 2012 23:51] Philip Olson

This has been fixed as of the soon-to-be-released Workbench 5.2.41, and 
here's the changelog entry:

Using "Paste Row" after "Copy Row Data" within the SQL editor would insert rows with extra apostrophes. For example, 'hello' would become ''hello''.