MySQL Bugs: #16562: Default column value will not update from NULL

Bug #16562	Default column value will not update from NULL
Submitted:	17 Jan 2006 14:27	Modified:	29 Apr 2006 2:28
Reporter:	Charlie Farrow	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.6	OS:
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
When using the above version on mysql administrator, you are not able to change the default column value from NULL to an integer.

Changes from an integer to another work correctly.

In this instance, hitting 'Close' results in the message 'Are you sure you want to quit the table editor without applying the changes', however if you try and apply the changes the message 'The changes you made did not result in the need to alter the table.

If you make other changes to the table and apply the changes, the query does not include the required information to change the NULL columns, but it does change everything else.

How to repeat:
Try in in mysql administrator 1.1.6 and edit a table.

I do not think you will need any more than this, if you do please let me know and will be happy to assist.

Missed this:

OS is WIN XP SP2

screenshoot

Attachment: bug16562.PNG (image/png, text), 64.94 KiB.

Still happens in 1.1.9

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html