Bug #22230 Size in Bit Data type deleted

• Submitted: 11 Sep 2006 7:38
• Modified: 11 Sep 2006 10:02
• Reporter: Robert Martí
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S2 (Serious)
• Version: 1.1.3 alpha
• OS: Windows (windows XP )
• CPU Architecture: Any
• Tags: bit, export

[11 Sep 2006 7:38] Robert Martí

Description:
In table editor, after creating an attribute of BIT type with a size parameter eg. BIT(8) and updating the table the size parameter is gone in the main view of the database.
This is not just a display issue as when exported to script the (8) does not appear either.

How to repeat:
- Create a table
- Create an attribute of BIT type with a size parameter (eg BIT(8))
- Update table
- The (8) is gone in the main view.

[11 Sep 2006 9:15] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

You can see size of the just created BIT column in the column tab of editor window, so information is not missing. Same behaviour is present for size attribute of any other column type.

[11 Sep 2006 9:29] Robert Martí

I was initially mistaken about the source of the bug. 
I think there's still a bug, but in the export to script for the bit type.
The information in the column editor is not missing, but it is in the export process that the information is lost.

If you declare a bit with size parameter (8) the size of the type is missing in the sql file after exporting it.

[11 Sep 2006 10:02] Sveta Smirnova

Yes, wrong exported SQL is bug. Thank you for additional information.

[11 Sep 2006 10:04] Sveta Smirnova

Update to "How to repeat":
- Create a table
- Create an attribute of BIT type with a size parameter (eg BIT(8))
- Update table
- Export to SQL 
- Examine SQL