MySQL Bugs: #39131: If you have a DEFAULT NULL field, you can't change the DEFAULT with table editor

Bug #39131	If you have a DEFAULT NULL field, you can't change the DEFAULT with table editor
Submitted:	29 Aug 2008 18:50	Modified:	3 Oct 2008 17:17
Reporter:	Federico Razzoli (OCA)	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Linux (Ubuntu 8.04)
Assigned to:		CPU Architecture:	Any

Description:
If you edit an existing table with DEFAULT NULL fields, you won't be albe to change that fields' DEFAULT value.
If try to change it and you won't change anything else, and then click on Apply Changes, a message appear: No modifications to be applied.
If you change something else, for example you check USIGNED, the query to be executed appears... and it says explicitly: DEFAULT NULL.

This is true even if you have columns *without* a DEFAULT value, because the editor show NULL as default.

How to repeat:
see above

Not repeatable on Windows.

I could not repeat on FC6. Could you please provide the create table statement which presents this behavior?. Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Bug should be marked duplicate of http://bugs.mysql.com/bug.php?id=36076