Bug #45579 copyToClipboard produces excess newlines
Submitted: 18 Jun 2009 6:56 Modified: 15 Oct 2009 10:14
Reporter: Karsten Wutzke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.16 OS:Windows (XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: copytoclipboard, newline, TTREV

[18 Jun 2009 6:56] Karsten Wutzke 
Description:
copyToClipboard produces another newline per line, effectively resulting in two two newlines per line.

This is most disturbing for plugins that generate code! The export to a file still works though.

This bug is Windows XP only right now, other OS's might be affected, too.

How to repeat:
Install a plugin that generates code, like

http://code.google.com/p/mysql-workbench-doctrine-plugin/

Taking any test model, using "copy to file" works as expected, "copy to clipboard" produces excess newlines.

Also see:

http://bugs.mysql.com/bug.php?id=44461
[18 Jun 2009 7:16] Karsten Wutzke 
Note that on Windows, the copied clipboard code looks OK in regular Notepad. The problem is visible only after saving. In other editors like Notepad++ the result is immediately visible after pasting.

I checked the newlines: they are double hex codes 0A.

Not sure if the copyToClipboard code handles the LF, CR, and CRLF problem correctly.
[22 Jun 2009 14:09] MySQL Verification Team 
Could you please try version 5.1.14 and comment the result here. Thanks in advance.
[23 Jun 2009 10:46] Karsten Wutzke 
Still double newlines. You should look at the output with a hex editor. You can clearly see that there are two 0A bytes for each line. This is wrong on Windows, Linux and probably any other OS. It should at least be 0D 0A (CR LF) on Win. Though using "\n" is usually the way to go...
[26 Jun 2009 12:11] Karsten Wutzke 
I just forward engineered two tables of a model. At the end when a window is shown with the generated CREATE TABLE statements, the code is correctly displayed. However, when copying it out of that window, there's one newline too much per line, too...
[3 Jul 2009 17:23] Karsten Wutzke 
Still not working.
[6 Jul 2009 15:02] Valeriy Kravchuk 
Verified based on last comment. Indeed, "Copy to Clipboard" during forward engineering produces double 0D0A "newlines" on Windows after each line of generated script. Looks like they are the result of double 0As being "converted" to DOS fromat of newline.
[28 Aug 2009 13:25] Alfredo Kojima 
Changing priority and target version, this is annoying and shouldn't take much effort.
[15 Oct 2009 6:58] Mike Lischke 
Seems to be fixed already for a while.
[15 Oct 2009 8:13] Johannes Taxacher 
I cannot reproduce this issue starting with 5.1.17 and 5.2.3. 
So i'll close it as fixed in 5.1.17 and 5.2.3
[15 Oct 2009 10:14] Tony Bedford 
An entry has been added to the 5.1.17 and 5.2.3 changelogs:

During Forward Engineering, clicking the Copy to Clipboard button generated code that contained an extra newline per line.