Bug #16391 cannot set default values to null
Submitted: 11 Jan 2006 23:08 Modified: 29 Apr 2006 1:42
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.2 OS:MacOS (mac)
Assigned to: Alfredo Kojima CPU Architecture:Any

[11 Jan 2006 23:08] [ name withheld ] 
Description:
unable to set default value of a column to null in table editor -> columns / indices window.

How to repeat:
- select a column
- click null button in default value field
- click apply

raises an alert panel "no modifications to be applied".

Suggested fix:

suggested workaround: 

do it manually in command line ...

ALTER TABLE `<db>`.`<table>` MODIFY COLUMN `<column>` FLOAT DEFAULT null;
[12 Jan 2006 0:21] Lachlan Mulcahy 
Verified on 1.1.2 Mac OSX 10.4.4.

A field without a NULL default value, given a NULL default will cause the client to not recognise any changes to be applied to the table.
[29 Apr 2006 1:42] 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