Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1.201205
-
Fix Version/s: CMT8.4.1.201209
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT8.4.1.0028
Description
1There are some tables
CREATE TABLE "part_hash"(
"id" integer,
"fname" character varying(90),
"lname" character varying(90),
"signed" date
);
ALTER TABLE "part_hash" PARTITION BY HASH (month([signed])) PARTITIONS 12;
2 After offline or online migration, it become:
CREATE TABLE "part_hash"(
"id" integer,
"fname" character varying(90),
"lname" character varying(90),
"signed" date
);
ALTER TABLE "part_hash" PARTITION BY HASH (month([signed])) PARTITIONS 11;
Q2: There is table
CREATE TABLE "part_list_int"(
"id" integer,
"data" integer
);
ALTER TABLE "part_list_int" PARTITION BY LIST ([data]) (PARTITION p0 VALUES IN (5,10,15), PARTITION p1 VALUES IN (6,12,18));
After do offline or online migration, it become:
CREATE TABLE "part_list_int"(
"id" integer,
"data" integer
);
ALTER TABLE "part_list_int" PARTITION BY LIST ([data]) (PARTITION p0 VALUES IN (5,10,15));