| 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: | |
| 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: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.
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.