Bug #16040 the field's default value maybe vanished in some circumstance
Submitted: 28 Dec 2005 11:25 Modified: 11 Aug 2006 16:28
Reporter: ming lu Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.1.6, 1.1.2 OS:Microsoft Windows (Windows)
Assigned to: Michael G. Zinner CPU Architecture:Any
Tags: Object Editors

[28 Dec 2005 11:25] ming lu
The field's default value maybe vanished in some circumstance.

creat a new table 
CREATE TABLE `db1`.`test` (
  `id` INTEGER ,
  `number` INTEGER ,

Edit the table, set id's default value with 10 and number's default value with 'NULL'. Then change the mouse's focus between the line of 'id'  and the line of 'number' in the listbox several times. You will find the id's default value vanished. 

How to repeat:
Do a test follow my steps above, you could repeat the problem.
[28 Dec 2005 11:42] Valeriy Kravchuk
Thank you for a bug report. It is not only "vanished", but, in case of 1.1.6 on Windows, if you change default value for column using the "Colum Details" tab, the appropriate part of ALTER TABLE statement (ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}) is not generated. So, it is a bug.
[6 Jan 2006 22:23] Alfredo Kojima
Fixed in Linux, updated OS field.
[11 Aug 2006 16:28] Michael G. Zinner
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