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.5217
Description
1 Create one table use the sql
CREATE TABLE "TEST"."BMS_DCT_FAXSND_HIS3"
( "DOCID" VARCHAR2(35) NOT NULL ENABLE,
"RECEIVERID" VARCHAR2(35) NOT NULL ENABLE,
"SNDORDER" NUMBER(3,0) NOT NULL ENABLE,
"RECEIVERNM" VARCHAR2(256),
"RECEIVERSEQ" NUMBER(4,0),
"FAXNUM" VARCHAR2(20) DEFAULT 23,
"SNDREQDT" VARCHAR2(14),
"ATTFILEFLAG" VARCHAR2(1) DEFAULT NULL,
"SNDREQID" VARCHAR2(35),
CONSTRAINT "PK_BMS_DCT_FAXSND_HIS3" PRIMARY KEY ("DOCID", "SNDORDER", "RECEIVERID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 6291456 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" 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" ;
2 Do migration from oracle to cubrid
Actual result:
It will pop "ERROR: Data overflow coercing 'NULL' to type varchar"
fixed