Details
-
Type:
Task
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1.201203
-
Fix Version/s: CMT8.4.1.201203
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
CMT2.0.0.4999
Description
1 Create one table in mysql
SET FOREIGN_KEY_CHECKS=0;
– ----------------------------
– Table structure for pgao1
– ----------------------------
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 Do migration
3 After migration, the partition will be lost
The partition feature will be supported int the next version 2.0.1