Description:
First BUG :
++++++++++++
design 2 tables 'A' and 'B'
and make a relation as : 'A has many B'and 'B has many A'
the generated script is this one :
======================================================
CREATE TABLE `test`.`A` (
`primaryID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`primaryID`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE `test`.`B` (
`primaryID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`primaryID`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE `test`.`A_has_B` (
`FKAprimaryID` NOT NULL,
`FKBprimaryID` NOT NULL,
CONSTRAINT `FKA` FOREIGN KEY `FKA` (`FKAprimaryID`)
REFERENCES `test`.`A` (`primaryID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `FKB` FOREIGN KEY `FKB` (`FKBprimaryID`)
REFERENCES `test`.`B` (`primaryID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
ENGINE = InnoDB;
======================================================
I ) As you can see the table which is created 'A_has_B' has two keys, ok, but the datatype is messing ! so this script cannot work and generates an error.
II ) the keys are not marked as primary key in 'A_has_B'
Second bug (linked whith the first one).
++++++++++++++++++++++++++++++++++++++++++
I try to modify the middle table 'A_has_B' in order to put the missing data type:
1) the data type are not listed when tab in the column
2) if i cut/past the datatype of another key INT(11) the application crashed
How to repeat:
First BUG :
++++++++++++
1) design 2 tables 'A' and 'B'
2) make a relation as : 'A has many B'and 'B has many A'
3) menu-->Synchronise
==> generated script is a bad script
Second bug (linked whith the first one).
++++++++++++++++++++++++++++++++++++++++++
I try to modify the table 'A_has_B' in order to put the missing data types :
1) when typing int the table editor the data type are not listed
2) if i put by "cutting and pasting" the datatype of another key INT(11)
=====> the application is crashing.
Description: First BUG : ++++++++++++ design 2 tables 'A' and 'B' and make a relation as : 'A has many B'and 'B has many A' the generated script is this one : ====================================================== CREATE TABLE `test`.`A` ( `primaryID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`primaryID`) ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test`.`B` ( `primaryID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`primaryID`) ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test`.`A_has_B` ( `FKAprimaryID` NOT NULL, `FKBprimaryID` NOT NULL, CONSTRAINT `FKA` FOREIGN KEY `FKA` (`FKAprimaryID`) REFERENCES `test`.`A` (`primaryID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FKB` FOREIGN KEY `FKB` (`FKBprimaryID`) REFERENCES `test`.`B` (`primaryID`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB; ====================================================== I ) As you can see the table which is created 'A_has_B' has two keys, ok, but the datatype is messing ! so this script cannot work and generates an error. II ) the keys are not marked as primary key in 'A_has_B' Second bug (linked whith the first one). ++++++++++++++++++++++++++++++++++++++++++ I try to modify the middle table 'A_has_B' in order to put the missing data type: 1) the data type are not listed when tab in the column 2) if i cut/past the datatype of another key INT(11) the application crashed How to repeat: First BUG : ++++++++++++ 1) design 2 tables 'A' and 'B' 2) make a relation as : 'A has many B'and 'B has many A' 3) menu-->Synchronise ==> generated script is a bad script Second bug (linked whith the first one). ++++++++++++++++++++++++++++++++++++++++++ I try to modify the table 'A_has_B' in order to put the missing data types : 1) when typing int the table editor the data type are not listed 2) if i put by "cutting and pasting" the datatype of another key INT(11) =====> the application is crashing.