Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1
-
Fix Version/s: CMT8.4.1
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
CMT2.0.0.5279
From oracle to cubrid
Description
1 Create one table in oracle
CREATE TABLE "TEST"."AGENT"
( "AGENT_ID" NUMBER(*,0) NOT NULL ENABLE,
"AGENT_GRP_ID" NUMBER(*,0) DEFAULT NULL,
"STATUS" NUMBER(*,0) NOT NULL ENABLE,
"HOST_NAME" VARCHAR2(20) DEFAULT NULL,
"LAST_ACCESS" TIMESTAMP (6) DEFAULT NULL,
"IP" VARCHAR2(40) DEFAULT NULL,
"CPU1" VARCHAR2(20) DEFAULT 'a',
"MAC" VARCHAR2(20) DEFAULT 'b',
"MEM" VARCHAR2(10) DEFAULT 'c',
"BANDWIDTH" VARCHAR2(10) DEFAULT 'd'
)
CREATE INDEX "TEST"."IDX_AGENT_ID" ON "TEST"."AGENT" ("AGENT_ID")
2 Do migration
Actual result
Cannot find the index in CMT.
To tester: In regression, please check the cases:
There are two index in one table.
There is one composite index in one table.