Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
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
Description
1 create one table
CREATE TABLE "TEST"."GAME"
( "HOST_YEAR" NUMBER(*,0) NOT NULL ENABLE,
"EVENT_CODE" NUMBER(*,0) NOT NULL ENABLE,
"ATHLETE_CODE" NUMBER(*,0) NOT NULL ENABLE,
"STADIUM_CODE" NUMBER(*,0) NOT NULL ENABLE,
"NATION_CODE" CHAR(3) DEFAULT NULL,
"MEDAL" CHAR(1) DEFAULT NULL,
"GAME_DATE" DATE DEFAULT NULL,
CONSTRAINT "GAME_PK" PRIMARY KEY ("EVENT_CODE", "ATHLETE_CODE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE,
CONSTRAINT "GAME_IBFK_3" FOREIGN KEY ("EVENT_CODE")
REFERENCES "TEST"."EVENT" ("CODE") ON DELETE CASCADE ENABLE,
CONSTRAINT "GAME_IBFK_5" FOREIGN KEY ("ATHLETE_CODE")
REFERENCES "TEST"."ATHLETE" ("CODE1") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "TEST"."GAME_PK" ON "TEST"."GAME" ("EVENT_CODE", "ATHLETE_CODE")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
ALTER TABLE "TEST"."GAME" ADD CONSTRAINT "GAME_PK" PRIMARY KEY ("EVENT_CODE", "ATHLETE_CODE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE
2 Do migration,goto step4
Actual result
The fk of on delete no action became on delete restrict
Fixed in CMT8.4.1.0001