Bug #59862 Cannot import mwb from Workbench 5.1.18 OSS
Submitted: 1 Feb 2011 2:55 Modified: 29 Jun 2011 18:32
Reporter: Phil Fong Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.34 OS:Windows
Assigned to: CPU Architecture:Any
Tags: 5.1 incompatibility

[1 Feb 2011 2:55] Phil Fong 
Description:
I have a MWB file containing 1 table with 2 columns and some inserts created in MySQL workbench 5.1.18 OSS.  I cannot open this file in 5.2.31 GPL.  It gives an systax error.

I believe this is a S2 bug since it make migrating to 5.2 impossible.

How to repeat:
In 5.2.31, load the given test.mwb.  It will give a syntax error message and then fail to load the file.
[1 Feb 2011 3:00] Phil Fong 
Test mwb file created in 5.1 that fails to load in 5.2

Attachment: test.mwb (application/octet-stream, text), 4.69 KiB.
[1 Feb 2011 4:15] Valeriy Kravchuk 
On Mac OS X it gives me:

"No such table Sequence_def"

error message.
[7 Apr 2011 19:03] Phil Fong 
I updated to 5.2.33 CE and the problem remains.
An error message dialog pops up (which is the same in both versions) with:
  near "Zeus": syntax error

In this file, there is only one table called sequence_def with two columns ID and description.  There is one insert:
INSERT INTO `Sequence_def` (`idSequence_def`, `Description`) VALUES (1, 'Example Zeus sequence def');
[20 Jun 2011 19:12] Paul DuBois 
Noted in 5.2.34 changelog.

Some MWB files created in Workbench 5.1 could not be loaded in 5.2.
[22 Jun 2011 0:25] Phil Fong 
I just tried 5.2.34.  It works with the example I posted before.  But, there are still some files I cannot open.
I've created some more test files using 5.1.18 OSS that I cannot open in 5.2.34.  See additional attachments.
[22 Jun 2011 0:26] Phil Fong 
This gives "unrecognized token: "\" "

Attachment: test1.mwb (application/octet-stream, text), 5.21 KiB.
[22 Jun 2011 0:26] Phil Fong 
This gives "near "1": syntax error"

Attachment: test2.mwb (application/octet-stream, text), 5.00 KiB.
[22 Jun 2011 0:27] Phil Fong 
This gives "near "test": syntax error"

Attachment: test3.mwb (application/octet-stream, text), 4.97 KiB.
[22 Jun 2011 0:28] Phil Fong 
This gives "unrecognized token: "\" "

Attachment: test4.mwb (application/octet-stream, text), 5.10 KiB.
[23 Jun 2011 6:34] Valeriy Kravchuk 
I've got no errors when opening all 4 files with 5.2.34 on Mac OS X.
[23 Jun 2011 22:37] Phil Fong 
I am using 5.2.34 CE Revision 7780 on Windows 7.  This is a 64 bit edition of Windows but I believe the build is 32 bit.  I installed using the installer from http://dev.mysql.com/downloads/workbench/5.2.html
[29 Jun 2011 16:04] Jon Stephens 
Fixed in 5.2.34.
[29 Jun 2011 16:29] Phil Fong 
Why the change in status back to closed?
I have mwb files saved with 5.1.18 that do not open in 5.2.34.  Should I open a new bug?
[29 Jun 2011 18:32] Phil Fong 
I just tested 5.2.34 on Ubuntu 10.04 32 bit.  There test1.mwb fails to open, but test2, test3, and test4 open.
[29 Jun 2011 18:41] Alfredo Kojima 
Hi

Could you please file a new bug mentioning that this one has attached test cases where the load fails?
Technically, this ticket is already fixed, because the reported issue with the provided model works now.

Thanks!
[29 Jun 2011 22:50] MySQL Verification Team 
See bug: http://bugs.mysql.com/bug.php?id=61703.