Bug #30403 Query Browser makes a hash of create table
Submitted: 14 Aug 2007 8:39 Modified: 4 Jun 2009 12:28
Reporter: John Woodhouse Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.12 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[14 Aug 2007 8:39] John Woodhouse 
Description:
If I edit a column to make it auto increment and apply the changes, query browser creates a command

ALTER TABLE `test`.`employees` MODIFY COLUMN `Employee_ID` DECIMAL(10,0) UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT;

obviously you can't have a field that is NOT NULL with a DEFAULT NULL.. however the field wasn't created with DEFAULT NULL so it would appear this is added erroneously, and it seems to not be possible to remove the NULL default value

this also occurred when trying to create the table with AUTO_INCREMENT ticked

How to repeat:
create a table using the query browser to generate the command
[14 Aug 2007 11:18] MySQL Verification Team 
Thank you for the bug report.
[27 Oct 2008 4:14] Jared S 
Bug should be marked duplicate of http://bugs.mysql.com/bug.php?id=36076
[4 Jun 2009 12:28] Axel Schwenke 
duplicate of bug #36076