Bug #18792 DBDesigner Import - datatype conversion
Submitted: 5 Apr 2006 10:01 Modified: 2 May 2006 17:37
Reporter: Klaus Bensch Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench Preview Severity:S3 (Non-critical)
Version:1.0.5 OS:Microsoft Windows (WinXP-SP2)
Assigned to: CPU Architecture:Any

[5 Apr 2006 10:01] Klaus Bensch
Description:
After import of a DBDesigner model keys with INT, VARCHAR, and DECIMAL datatypes are displayed with details in doubled parentheses in the 'Main View'. This is not the case if the table is generated with the Workbench directly. I don't know if this have consequences on functionality.

An analysis of the *.mwb files shows that the imported details are stored in different tags compared to a Workbench generated table:

VARCHAR:
<value type="string" key="datatypeExplicitParams">(50)</value>
but         <value type="int" key="length">50</value>

DECIMAL:
<value type="string" key="datatypeExplicitParams">(10,2)</value>
but          <value type="int" key="precision">10</value>
               <value type="int" key="scale">2</value>

How to repeat:
Use file "aaa-test.xml" for import and store the new Workbench model as "aaa-test.mwb".
Compare to "aaa-new.mwb".

Suggested fix:
Modify your parser.
[5 Apr 2006 10:04] Klaus Bensch
DBDesigner Model

Attachment: aaa-test.xml (text/xml), 18.81 KiB.

[5 Apr 2006 10:05] Klaus Bensch
Workbench model

Attachment: aaa-new.mwb (application/octet-stream, text), 25.44 KiB.

[2 May 2006 17:37] Jorge del Conde
Thanks for your bug report.  I was able to reproduce this under 1.0.6 using the attached files.
[15 Jun 2006 10:05] Tonci Grgin
Can't repeat with 1.0.6 beta.