Bug #44872 datatype integer get none unsigned and zerofill flag

Submitted: 14 May 2009 11:44 Modified: 8 Jun 2009 14:29
Reporter: Susanne Ebrecht Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1 OS:Windows
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: CHECKED

[14 May 2009 11:44] Susanne Ebrecht 
Description:
Place a table in diagramm.

Edit table.

Add column.

Type integer into data type field. The flags unsigned and zerofill won't show up.

Type just int into data type field and the flags show up.

How to repeat:
see above

Suggested fix:
add flags to the long form integer as well
[14 May 2009 15:34] Johannes Taxacher 
its about the "Flags" box to the right of the columns - it doesn't list the same flags for INT / INTEGER
also checking/uncheckung AI checkbox doesn't work for columns defined as "INTEGER"
[3 Jun 2009 22:14] Johannes Taxacher 
fix confirmed. will be included in 5.1.13
[8 Jun 2009 14:29] Tony Bedford 
An entry was added to the 5.1.13 changelog:

In the Flags box, which is located in the Column Details panel in the Table Editor, the same flags were not listed as available for both the INT and INTEGER data types. INT has both UNSIGNED and ZEROFILL listed, but these were not listed for the column if it was of type INTEGER. Also, the AI checkbox was not selectable for columns defined as INTEGER.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.