Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1.201209
-
Fix Version/s: CMT8.4.1.201209
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT8.4.1.3018
Description
1 There are two tables in mysql which name is A, a
CREATE TABLE `a` (
`a` int(11) NOT NULL DEFAULT '0',
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
`d` int(11) DEFAULT '0',
PRIMARY KEY (`a`),
KEY `a_b_id` (`b`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– ----------------------------
– Records
– ----------------------------
INSERT INTO `a` VALUES ('0', '1', null, '0');
INSERT INTO `a` VALUES ('1', '1', null, '0');
INSERT INTO `a` VALUES ('2', '2', null, '0');
INSERT INTO `a` VALUES ('3', '3', null, '0');
– ----------------------------
CREATE TABLE `A` (
`i` int(11) DEFAULT NULL,
`d` int(11) DEFAULT NULL,
`a` int(11) DEFAULT '0',
KEY `A_ab` (`i`),
CONSTRAINT `A_ab` FOREIGN KEY (`i`) REFERENCES `ab` (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
– ----------------------------
– Records
– ----------------------------
INSERT INTO `A` VALUES ('3', null, '0');
INSERT INTO `A` VALUES ('6', null, '0');
CREATE TABLE `ab` (
`b` decimal(63,0) DEFAULT NULL,
`a` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`a`),
KEY `b_idx` (`b`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='aaaass';
– ----------------------------
– Records
– ----------------------------
INSERT INTO `ab` VALUES ('2', '6');
INSERT INTO `ab` VALUES ('3', '3');
2 Do migration from db to file.
Actual result:
The logs will double.
fixed