Bug #38390 usability issue
Submitted: 26 Jul 2008 13:40 Modified: 26 Jul 2008 14:09
Reporter: Martin Bachmann Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0.23 SE OS:Windows
Assigned to: CPU Architecture:Any

[26 Jul 2008 13:40] Martin Bachmann 
Description:
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM' at line 28

-- -----------------------------------------------------
-- Table `simulatron`.`sim_shipTypes`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `simulatron`.`sim_shipTypes` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `created` DATETIME NULL ,
  `modified` DATETIME NULL ,
  `name` VARCHAR(250) NULL ,
  `description` TEXT NULL ,
  `icon` VARCHAR(200) NULL ,
  `image` VARCHAR(200) NULL ,
  `armor` INT UNSIGNED NULL ,
  `attack` INT UNSIGNED NULL ,
  `defense` INT UNSIGNED NULL ,
  `speed` INT UNSIGNED NULL ,
  `stealth` INT UNSIGNED NULL ,
  `radar` INT UNSIGNED NULL ,
  `maneuverability` INT UNSIGNED NULL ,
  `weight` INT UNSIGNED NULL ,
  `fuelMax` INT UNSIGNED NULL ,
  `cargoTroops` INT UNSIGNED NULL ,
  `cargoRessources` INT UNSIGNED NULL ,
  `colonyBase` TINYINT NOT NULL ,
  `cost` INT UNSIGNED NULL ,
  `scrapeValue` INT UNSIGNED NULL ,
  `buildtime` INT UNSIGNED NULL ,
  `techlevel` INT UNSIGNED NULL ,
  `updatePeriod`  NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`id`) )
ENGINE = MyISAM
SQL script execution finished: statements: 19 succeeded, 1 failed

How to repeat:
it just happens with my model when I try to create the database.
[26 Jul 2008 14:09] Martin Bachmann 
One column in the model had no type defined. I assumed workbench would catch such issues and not let one sync any sql scripts that won't execute.

(Ok, there's a validate function, but its result is overloaded with stuff already)

Btw: It takes 14(!) clicks to synchronize. How about just 1-3? It's a pain like this if I want to use this function frequently.