Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: CMT1.5.4
-
Fix Version/s: CMT1.5.5
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
CMT1.5.4.4026
Description
1 Create table in mysql
CREATE TABLE `pgao1` (
`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) */;
– ----------------------------
– Records
– ----------------------------
INSERT INTO `pgao1` VALUES ('1', '2008-02-02 00:00:00');
INSERT INTO `pgao1` VALUES ('60', '2009-02-02 00:00:00');
2 Migrated the table to 8.4.0.1008. It's ok. But migrated to 8.4.1.0001, it's error.
Addtional:
If we migrate the table, it's ok in two version.
CREATE TABLE `pgao` (
`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 (TO_DAYS(created))
(PARTITION pgao_1 VALUES LESS THAN (733773) ENGINE = InnoDB,
PARTITION pgao_2 VALUES LESS THAN (734138) ENGINE = InnoDB) */;
– ----------------------------
– Records
– ----------------------------
INSERT INTO `pgao` VALUES ('1', '2008-02-02 00:00:00');
INSERT INTO `pgao` VALUES ('60', '2009-02-02 00:00:00');
CUBRID 8.4.1 will be supported at next version