Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: CMT8.4.1.201209
-
Fix Version/s: CMT8.4.1.201209
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT8.4.1.3020
From mysql to CUBRID8.4.1.6004
Description
1There are two partition tables.
1 CREATE TABLE `part_range_int` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`,`created`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (id)
(PARTITION pgao1_1 VALUES LESS THAN (10) ENGINE = InnoDB,
PARTITION pgao1_2 VALUES LESS THAN (100) ENGINE = InnoDB) */;
INSERT INTO `part_range_int` VALUES ('1', '2008-02-02 00:00:00');
INSERT INTO `part_range_int` VALUES ('60', '2009-02-02 00:00:00');
2 CREATE TABLE `part_range_int1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`,`created`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (id)
(PARTITION pgao1_1 VALUES LESS THAN (20) ENGINE = InnoDB,
PARTITION pgao1_2 VALUES LESS THAN (100) ENGINE = InnoDB) */;
INSERT INTO `part_range_int1` VALUES ('19', '2008-02-02 00:00:00');
INSERT INTO `part_range_int1` VALUES ('30', '2009-02-02 00:00:00');
3 Do migration from online to online, targe table name set to part_range_int3
Except result:
It can merge the partitions of the two tables.
Actual result:
It only use the schema of part_range_int1.
Partition defination need to be changed by user, CMT can't merge them automaticely