Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1.201209
-
Fix Version/s: CMT8.4.1.201209
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT8.4.1.3018
From mysql to CUBRID8.4.1.6004
Description
1There are two tables in mysql
Create table cmt(a int, b int);
insert into cmt values(1,1),(2,2),(3,3)
Create table cmt1(a int, b int);
insert into cmt1 values(1,1),(2,2),(3,3)
2 Do migration from online to online.
Change cmt to cmt1, input target column of b column.
3 Do migration.
Actual result:
The data cannot be migrated
Additional:
Q1 From online to offline, the data cannot be migrated too.
Q2 From online to file, the data and schema cannoe be migrated too.
1) loadd schema and data
cm841@NC-VM-PL-QA-31:~$ cubrid loaddb -i schema.txt -d data.txt -udba target Password: Start object loading. Line 2:No class named cmt1, ignoring tuples Line 6:No class named cmt1, ignoring tuples Line 8:Unknown class "cmt1". Line 10:No class named cmt1, ignoring tuples
2) Only loadd data after create table in csql
cm841@NC-VM-PL-QA-31:~$ cubrid loaddb -d data.txt -udba target Password: Start object loading. Line 3:Missing attribute values. Expected 3, found 2. Line 4:Missing attribute values. Expected 3, found 2. Line 5:Missing attribute values. Expected 3, found 2. Line 7:Missing attribute values. Expected 3, found 2. Line 8:Missing attribute values. Expected 3, found 2. Line 9:Missing attribute values. Expected 3, found 2. Line 8:Missing attribute values. Expected 3, found 2. Line 11:Missing attribute values. Expected 3, found 2.
The files is migrated from online to file.