Description:
When the option "Generate SHOW WARNINGS after every DDL statement" is enabled on the first page of the wizard, the creation process goes out of sync:
Error 2014: Commands out of sync; you can't run this command now
USE `mydb`
Error 2014: Commands out of sync; you can't run this command now
-- -----------------------------------------------------
-- Table `mydb`.`users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`users` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `first_name` VARCHAR(45) NOT NULL , `last_name` VARCHAR(45) BINARY NOT NULL , `registered` TIMESTAMP NOT NULL , `customer_id` INT UNSIGNED NULL DEFAULT 1 , PRIMARY KEY (`id`) , CONSTRAINT `customer` FOREIGN KEY (`customer_id` ) REFERENCES `mydb`.`customers` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION )
Error 2014: Commands out of sync; you can't run this command now
This happened with MySQL Server 5.0.45 and MySQL Workbench 5.0.9 SE under Windows Vista.
How to repeat:
1. Create a model with at least one table.
2. Run Database -> Forward Engineer...
3. Select option "Generate SHOW WARNINGS after every DDL statement"
4. Complete the wizard and try to create the tables.