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

[17 Jan 2006 14:27] Charlie Farrow
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.
[17 Jan 2006 14:53] Charlie Farrow
Missed this:

OS is WIN XP SP2
[17 Jan 2006 14:56] Aleksey Kishkin
screenshoot

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

[27 Feb 2006 14:36] Charlie Farrow
Still happens in 1.1.9
[29 Apr 2006 2:28] Alfredo Kojima
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