Bug #31092 sychronisation error in workbench
Submitted: 19 Sep 2007 9:24 Modified: 19 Sep 2007 11:52
Reporter: samuel zhu Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL GUI Common Severity:S1 (Critical)
Version: OS:Microsoft Windows (2000)
Assigned to: CPU Architecture:Any

[19 Sep 2007 9:24] samuel zhu
Description:
ALTER TABLE `school`.`sc`,
	CHANGE COLUMN `sno`   `sno` CHAR(10) NULL DEFAULT '',
	CHANGE COLUMN `cno`   `cno` CHAR(6) NULL DEFAULT '',
	CHANGE COLUMN `grade`   `grade` TINYINT(3) unsigned NULL,
	ADD COLUMN   `FKstudentsno`  NULL AFTER `grade`,
	ADD CONSTRAINT `FKstudent` FOREIGN KEY (`FKstudentsno`)
	REFERENCES `school`.`student` (`sno`)
	ON DELETE NO ACTION 
	ON UPDATE NO ACTION;
ALTER TABLE `school`.`student`,
	CHANGE COLUMN `sno`   `sno` CHAR(10) NULL DEFAULT '',
	CHANGE COLUMN `sname`   `sname` VARCHAR(45) NULL DEFAULT '',
	CHANGE COLUMN `sex`   `sex` TINYINT(1) NULL,
	CHANGE COLUMN `sage`   `sage` TINYINT(3) unsigned NULL,
	ADD COLUMN   `FKcoursecno`  NULL AFTER `sage`,
	ADD CONSTRAINT `FKcourse` FOREIGN KEY (`FKcoursecno`) 
	REFERENCES `school`.`course` (`cno`)
	ON DELETE NO ACTION 
	ON UPDATE NO ACTION;
CREATE TABLE `school`.`course` (
  `cno` CHAR(6) CHARACTER SET  COLLATE  UNSIGNED UNSIGNED NULL,
  PRIMARY KEY (`cno`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;

errors in Finalize reverse engineering:

file source\myx_grt_value.c: line 3307: assertion `dict != NULL' failed
file source\myx_grt_value.c: line 3307: assertion `dict != NULL' failed
file source\myx_grt_value.c: line 3307: assertion `dict != NULL' failed
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 '
	CHANGE COLUMN `sno`   `sno` CHAR(10) NULL DEFAULT '',
	CHANGE COLUMN `cno`   `' at line 1
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 '
	CHANGE COLUMN `sno`   `sno` CHAR(10) NULL DEFAULT '',
	CHANGE COLUMN `sname`  ' at line 1
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 'COLLATE  UNSIGNED UNSIGNED NULL,
  PRIMARY KEY (`cno`)
)
ENGINE = InnoDB
CHA' at line 2

How to repeat:
create tables in workbench, when do database synchronisation, above error occurs.
[19 Sep 2007 11:52] Miguel Solorzano
Thank you for the bug report.
[13 Mar 2014 13:36] Omer Barnir
This bug is not scheduled to be fixed at this time.