MySQL Bugs: #39139: Default value in column with not null flag is lost

Bug #39139	Default value in column with not null flag is lost
Submitted:	30 Aug 2008 22:40	Modified:	1 Sep 2008 21:14
Reporter:	Lorenzo Luconi Trombacchi	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.24	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
if you add a default value to a column with not null flag on, the value disappears after you close and reopen your project. If you make a "forward engineering create script sql" exportation, before closing the project, the default value is present, but if you save, close and reopen the project, the default value is lost.

How to repeat:
Create a table, define a column without the not null flag and add a default value (for example a value of 1 for a int column). Then save and close your project and reopen it (or close workbench). Your default value is still present, but if you set de not null flag to on and you close/open project, the default value is not more present.

Thank you for a bug report. Verified just as described.

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=38825