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 Email Updates:
Status: Closed Impact on me:
None 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.