Bug #54244 Forward Engineer Save to File contains extra carriage returns
Submitted: 4 Jun 2010 18:03 Modified: 29 Jun 2010 13:14
Reporter: Michael LaBrot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.22 OS:Windows (XP Pro)
Assigned to: Mike Lischke CPU Architecture:Any

[4 Jun 2010 18:03] Michael LaBrot
Description:
The SQL file by clicking the Save to File button during forward engineering produces an extra carriage return on every line (each line ends with 0x0D, 0x0D, 0x0A).

How to repeat:
1.) Open a model.
2.) Database > Forward Engineer...
3.) Click Next.
4.) Click Next.
5.) Click Save to File...
[9 Jun 2010 9:09] Valeriy Kravchuk
Verified just as described. This is what one can see in hex editor:

0000000000:  53 45 54 20 40 4F 4C 44 │ 5F 55 4E 49 51 55 45 5F  SET @OLD_UNIQUE_
0000000010:  43 48 45 43 4B 53 3D 40 │ 40 55 4E 49 51 55 45 5F  CHECKS=@@UNIQUE_
0000000020:  43 48 45 43 4B 53 2C 20 │ 55 4E 49 51 55 45 5F 43  CHECKS, UNIQUE_C
0000000030:  48 45 43 4B 53 3D 30 3B │ 0D 0D 0A 53 45 54 20 40  HECKS=0;♪♪◙SET @
...

File > Export > Forward ... menu item(s) produce more normal file.
[18 Jun 2010 15:31] Mike Lischke
Fixed in repository.
[25 Jun 2010 13:05] Alfredo Kojima
Fix confirmed
[29 Jun 2010 13:14] Tony Bedford
See Bug #54272.