Bug #32761 Forward Engineer out of sync with SHOW WARNINGS
Submitted: 27 Nov 2007 10:51 Modified: 4 Dec 2007 16:48
Reporter: Daniel Haas Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.9 OS:Windows (Vista)
Assigned to: Johannes Taxacher CPU Architecture:Any

[27 Nov 2007 10:51] Daniel Haas
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.
[29 Nov 2007 16:57] Vladimir Kolesnikov
fixed (not vista-specific)
[4 Dec 2007 16:48] Johannes Taxacher
works in 5.0.10 SVN rev 2290