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.5236
Description
1 create one table
CREATE TABLE "TEST"."DATETEST"
( "DATETYPE" DATE,
"TIMESTAMPTYPE" TIMESTAMP (6),
"TIMESTAMPWLTZ" TIMESTAMP (6) WITH LOCAL TIME ZONE,
"TIMESTAMPWTZ" TIMESTAMP (6) WITH TIME ZONE,
"TIMESTAMPTYPE0" TIMESTAMP (0)
) 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 Import the sql in attachment
3 Do migration
Actual result:
Cannot be migrated
Timestamp with time zone is not right.Please see the attachment.