Bug #46509 Workbench column defaults cannot be removed

• Submitted: 2 Aug 2009 15:02
• Modified: 28 Aug 2009 10:17
• Reporter: Ken Brown
• Status: Closed
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 5.1.16, 5.2.2
• OS: Any (Ubuntu 9.04, XP)
• Assigned to: Alfredo Kojima
• CPU Architecture: Any
• Tags: column, DEFAULT, delete, fail, workbench

[2 Aug 2009 15:02] Ken Brown

Description:
cannot delete column defaults once set

How to repeat:
create table
create column
add default
try and remove default

[2 Aug 2009 15:39] Valeriy Kravchuk

Thank you for the problem report. Verified just as described on Windows XP. There is no way to remove DEFAULT setting for a CHAR(N) or VARCHAR(N) column as soon as it was set once. You get DEFAULT '' at least.

[2 Aug 2009 16:52] Ken Brown

char and  can live with - char & varchar setting to a empty string the problem I have is with numbers - you cannot get rid, and zero is a number.

[12 Aug 2009 13:57] Alfredo Kojima

Problem with in 5.1 and 5.2
However I can not repeat the problem for number fields. Setting an empty default value for an INT field will leave it empty.

[13 Aug 2009 12:34] Johannes Taxacher

this has been fixed. 
will be included in 5.1.17

[28 Aug 2009 10:17] Tony Bedford

An entry was added to the 5.1.17 changelog:

In the Columns tab of the Table Editor, if a default value was added for a column, it could not then be removed.