Bug #46107 copy row values with single quotes

• Submitted: 10 Jul 2009 10:04
• Modified: 20 Oct 2009 6:02
• Reporter: Laurent Yin
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.2.16, 1.2.17
• OS: Any
• CPU Architecture: Any

[10 Jul 2009 10:04] Laurent Yin

Description:
When we use copy row values after double clicking on a cell in the results of a query, it copies in the clipboard the values of each column for this row, separated by commas. We expect it to be usable later for another query, but when one of the text cell contains a single quote " ' ",  it is not correctly escaped like it should be " '' ".

How to repeat:
use a table with a text column
insert a row containing a text containing an hyphen in the text column
do a select query displaying this row
right click on a cell of this row and click "copy row values"
paste in the query area to see it's not correctly escaped

Suggested fix:
replace ' by '' in strings.

[10 Jul 2009 10:36] Valeriy Kravchuk

Thank you for the bug report. Verified just as described with QB 1.2.17 on Windows.

[20 Oct 2009 6:02] Susanne Ebrecht

Many thanks for writing a bug report. We are on the way to implement full functionality of
MySQL Query Browser into MySQL Workbench. We won't fix this anymore.

Lots of functionalities of MySQL Query Browser are already implemented in Workbench 5.2
which will get GA soon.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/