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

[29 Aug 2008 18:50] Federico Razzoli
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
[29 Aug 2008 19:10] Valeriy Kravchuk
Not repeatable on Windows.
[3 Sep 2008 17:17] MySQL Verification Team
I could not repeat on FC6. Could you please provide the create table statement which presents this behavior?. Thanks in advance.
[3 Oct 2008 23:00] Bugs System
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".
[27 Oct 2008 4:16] Jared S
Bug should be marked duplicate of http://bugs.mysql.com/bug.php?id=36076