Bug #38775 DEFAULT NULL not permitted for INT fields
Submitted: 13 Aug 2008 16:43 Modified: 14 Oct 2008 13:52
Reporter: Alex Saavedra Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.25 OS:Windows
Assigned to: CPU Architecture:Any

[13 Aug 2008 16:43] Alex Saavedra
Description:
When you create a column of type INT and you define DEFAULT NULL, the MySQL validation tool (Model >> Validation (MySQL) >> Validate All) reports 'Invalid default value NULL'

How to repeat:
1. design table t1 as:
    CREATE  TABLE IF NOT EXISTS `mydb`.`t1` (
      `id` INT NOT NULL AUTO_INCREMENT ,
      `x1` INT NULL DEFAULT NULL ,
      PRIMARY KEY (`id`) )
    ENGINE = InnoDB
2. select Model >> Validation (MySQL) >> Validate All

The log reports:
  Invalid default value 'NULL' for column `t1`.`x1`: .
[13 Aug 2008 16:57] Valeriy Kravchuk
Thank you for a problem report. Verified just as described.
[14 Oct 2008 13:52] Alex Saavedra
Working fine in v 5.0.25
[13 Apr 2009 21:11] MySQL Verification Team
See bug: http://bugs.mysql.com/bug.php?id=44243.