MySQL Bugs: #33026: Old flags after datatype is changed

Bug #33026	Old flags after datatype is changed
Submitted:	5 Dec 2007 23:58	Modified:	7 Dec 2007 22:31
Reporter:	Sergey Romanov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.10 SE Beta	OS:	Windows (XP SP2)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Column have old flags if datatype is changed and impossible to see this.

How to repeat:
1. Create any column with flags. For example column with INT datatype and UNSIGNED flag.
2. Change datatype to VARCHAR
3. File > Export > Reverse Engineer SQL CREATE Script
4. In file you will see that VARCHAR column have UNSIGNED

Suggested fix:
Changes of datatype should clear flags.
But this should be smart. I.e. should clear flags which is not compatible with new datatype.

Thank you for the bug report.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html