Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: CMT8.4.1
-
Fix Version/s: CMT8.4.1.201203
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
Source DB mysql
CMT:8.4.1.0012
Description
1 Create three tables:
CREATE TABLE `A` (
`i` int(11) DEFAULT NULL,
KEY `A_ab` (`i`),
CONSTRAINT `A_ab` FOREIGN KEY (`i`) REFERENCES `ab` (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
CREATE TABLE `a` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `ab` (
`b` decimal(63,0) DEFAULT NULL,
`a` int(11) DEFAULT NULL,
KEY `id_a` (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='aaaass'
2 choose the three table, do offline migration to online db.
3 goto step3,change A to A1, goto step4,it will display "hasn't reference table". Pls see the attachment.
In CUBRID the foreign key must refer to a primary key or a unique index which is defined in the referred table.