Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CM8.4.3.201211
-
Fix Version/s: CM8.4.3.201211, CQB8.4.3.201211
-
Component/s: CUBRID Manager, CUBRID Query Browser
-
Environment:
CM8.4.3.3013
Description
1 Create one table :
CREATE TABLE "pd"(
"i" integer NOT NULL,
"d" date,
CONSTRAINT pk_pd_i PRIMARY KEY("i")
);
ALTER TABLE "pd" PARTITION BY RANGE ([d]) (PARTITION p0 VALUES LESS THAN ('2012-01-01'), PARTITION p1 VALUES LESS THAN ('2013-01-01'));
2 When compare schema for database.
The table ddl will become three tables.
CREATE TABLE "pd"(
"i" integer NOT NULL,
"d" date,
CONSTRAINT pk_pd_i PRIMARY KEY("i")
);
ALTER TABLE "pd" PARTITION BY RANGE ([d]) (PARTITION p0 VALUES LESS THAN ('2012-01-01'), PARTITION p1 VALUES LESS THAN ('2013-01-01'));
CREATE TABLE "pd_p_p0"
UNDER "pd";
CREATE TABLE "pd_p_p1"
UNDER "pd";
Suggest delete the sub table of partition table.
Fixed on trunk, delete partitioned tables from the schema compare list