MySQL Bugs: #16040: the field's default value maybe vanished in some circumstance

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:	None
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

Description:
The field's default value maybe vanished in some circumstance.

creat a new table 
CREATE TABLE `db1`.`test` (
  `id` INTEGER ,
  `number` INTEGER ,
)
ENGINE = InnoDB;

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.

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.

Fixed in Linux, updated OS field.

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

    http://dev.mysql.com/doc/en/installing-source.html