MySQL Bugs: #13940: ERwin generation bugs

Bug #13940	ERwin generation bugs
Submitted:	12 Oct 2005 0:29	Modified:	16 Feb 2008 22:07
Reporter:	Serghey Parhomenko
Status:	Analyzing
Category:	Connector/ODBC	Severity:	S3 (Non-critical)
Version:	3.51.11	OS:	Microsoft Windows (Windows XP SP2 Pro VL En :))
Assigned to:	Georg Richter	Target Version:

Description:
I used MySQL database with AllFusion ERwin Data Modeler, which, like it was said in
manual, is tested for compatibility with MyODBC. But: when using ERwin Forward Engineer
tool (allows to generate&execute SQL code for designed database), following elements were
generated incorrectly:
- NOT NULL flag;
- Comments for tables and columns.
In short, this elements were not included in ERwin generated code, possibly because when
connecting to MyODBC driver, ERwin incorrectly recognizes MySQL's possibilities (ERwin
believes MySQL does not support NOT NULL flag and comments) - copied from ERwin help:
"ERwin queries the database to determine the datatypes and physical properties it
supports and displays them in the ERwin dialogs."
Software versions:
AllFusion ERwin Data Modeler 4.1.4.3907 (SP1)
MySQL 4.1.14
MyODBC 3.51.11

Please help me to find a solution for this case... I believe it is
MyODBC driver fault.

How to repeat:
- Install MySQL
- Install MyODBC
- Create MySQL database and MyODBC User DSN for this database
- Create ERwin physical model, selecting ODBC/Generic 3.0 as target database
- In connection window, enter root login\password and selected USer DSN early created
- Create in ERwin a table and a column in it. Set the "NOT NULL" flag, enter some
comments for the table and the column
- ERwin: Tools->Forward Engineer->Generate.
- Check in MySQL (I was checking with MySQL-Front): the table&column were created, but
comments are empty and the "NULL allowed" flag is ON, which is incorrect.

Suggested fix:
If it is MyODBC fault, it would be great to fix it's behaviour for correctly explaining
ERwin MySQL capabilities.

Also: not all datatypes are available in ERwin. I didn't found boolean, datetime, year,
many text types and some others.

I was able to reproduce this problem with Erwin 4.1.4

This should get re-verified with a current driver and version of ERwin. A free trial of
ERwin can be downloaded from CA's website.

http://www.ca.com/smb/collateral.aspx?cid=72121&cct=19506

Re-verifying.

Even Erwin installation expires after some time so I'm unable to install it at all... Very
weird behavior, never seen anything like this. Plus, I spent several hours
installing/reinstalling since only after installation one is notified that Erwin will not
start... Weird. Asking Miguel to help.

The latest version of Erwin (7.2.5) tells that MySQL support (via the ODBC driver) was
added (I don't know what it means, seems MySQL was supported via ODBC even in previous
releases).