Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1.201208
-
Fix Version/s: CMT8.4.1.201209
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT8.4.1.3022
From oracle to mysql
Description
1 There are three tables
create table A001 ( ID INTEGER not null, NAME VARCHAR2(20) ); alter table A001 add primary key (ID); alter table A001 add constraint FK_11 foreign key (ID) references A001 (ID) on delete cascade; create table A002 ( ID INTEGER, AGE INTEGER ); alter table A002 add foreign key (ID) references A001 (ID) on delete cascade; create unique index SYS_COO5669 on A002 (ID); create table FKNO ( ID NCHAR(10) ); alter table FKNO add constraint FK_FKNO_FKNOMAIN foreign key (ID) references FKNOMAIN (ID); create table FKNOMAIN ( ID NCHAR(10) not null ); alter table FKNOMAIN add constraint PK_FKNOMAIN primary key (ID);
2 Do migration from online to online
choose A001 include fk, A002 include fk fkno.
3 Goto progress, the DB records are error. Please see the attachment.
When migrate sql statement, the db record is error too.
Migrate the sql as follows:
select s_name, f_name, concat(s_name, f_name) as concat from code;
The progress and db records aren't right. please see the attachment. errorprogress.png