Bug #39476 Copy SQL to clipboard can't be pasted to MySQL command line client directly

• Submitted: 16 Sep 2008 13:09
• Modified: 11 Nov 2008 11:33
• Reporter: Roland Bouman
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.0.25
• OS: Windows (XP)
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[16 Sep 2008 13:09] Roland Bouman

Description:
"Copy SQL to Clipboard" action (right click menu on table) seems to be using the wrong line ends.

How to repeat:
Right click on a table. Choose "Copy SQL to Clipboard". Paste directly in MySQL command line client.

Line ends are gone, I get for example:

...ENGINE = InnoDBDefault CHARACTER SET ...

which results in a syntax error.

(Pasting in an editor like notepad first does somehow result in correct line endings)

Suggested fix:
please use proper (windows) line endings

[16 Sep 2008 13:48] Valeriy Kravchuk

Thank you for a bug report.

[31 Oct 2008 22:54] Alfredo Kojima

converting all data copied to clipboard to windows style newlines (in windows). 5.0 and 5.1 trees updated

[31 Oct 2008 22:54] Alfredo Kojima

converting all data copied to clipboard to windows style newlines (in windows). 5.0 and 5.1 trees updated

[31 Oct 2008 22:54] Alfredo Kojima

converting all data copied to clipboard to windows style newlines (in windows). 5.0 and 5.1 trees updated

[3 Nov 2008 12:45] Johannes Taxacher

fixed as described by developer. fix will be in 5.0.27

[11 Nov 2008 11:33] Tony Bedford

An entry was added to the 5.0.27 changelog:

The Copy SQL to Clipboard action (right click menu on table) did not use Windows-compatible line endings.