| Bug #13223 | UNSIGNED and ZEROFILL flags not maintained in table editor | ||
|---|---|---|---|
| Submitted: | 15 Sep 2005 14:12 | Modified: | 12 Apr 2006 13:18 |
| Reporter: | David Govek | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench Preview | Severity: | S3 (Non-critical) |
| Version: | 1.0.2 | OS: | Windows (Win2k SP4) |
| Assigned to: | Mike Lischke | CPU Architecture: | Any |
[15 Sep 2005 14:44]
David Govek
Related bug filed as #13224.
[16 Sep 2005 18:08]
Jorge del Conde
Thank you for your bug report. I was able to reproduce this bug using the supplied 'how-to-repeat'
[12 Apr 2006 13:18]
Mike Lischke
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 bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: While reverse engineering a schema and importing a table, the column type flags UNSIGNED and ZEROFILL appear in the table editor as 'not set', regardless of whether they are set in the table definition. How to repeat: 1) Make table if you don't already have one-- use test; drop table if exists `foo`; create table `foo` (`bar` int(4) zerofill unsigned not null); /* Verify state of ZEROFILL and UNSIGNED */ describe `foo` `bar`; 2) Start workbench 3) Menu/Database/Reverse Engineering... Connect, pick `test` database, import using default options. 4) In the layout, click the "pencil" on the `foo` table. Attributes ZEROFILL and UNSIGNED are unchecked. Suggested fix: The desired operation is that the ZEROFILL and UNSIGNED attributes of the Reverse Engineered table in Layout should match the attributes of the TABLE on the server. It is possible this issue is related to the other ZEROFILL/UNSIGNED report I'm about to file.