Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1.201211
-
Fix Version/s: CMT8.4.1.201211
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT8.4.1.3088
From mysql to cubrid8.4.1.7007 via offline
Description
1 There is one table which has two fk
CREATE TABLE `participant` (
`host_year` int(11) NOT NULL,
`nation_code` char(3) NOT NULL,
`gold` int(11) DEFAULT '0',
`silver` int(11) DEFAULT '0',
`bronze` int(11) DEFAULT '0',
PRIMARY KEY (`host_year`,`nation_code`),
KEY `nation_code` (`nation_code`),
CONSTRAINT `participant_ibfk_3` FOREIGN KEY (`host_year`) REFERENCES `olympic` (`host_year`) ON DELETE CASCADE,
CONSTRAINT `participant_ibfk_4` FOREIGN KEY (`nation_code`) REFERENCES `nation` (`code`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1
2 Do migration to new database.
3 Goto progress UI.
Actual result:
"participant_ibfk_4" will be lost.
Additional:
When run the three sql in csql ,it is ok.
I really don't know why. The error was thrown by CUBRID database.
But when i changed the order of creating FKs and indexes(creating index before creating FK), It was fixed.....