Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: CMT8.4.1.201211
-
Fix Version/s: CMT8.4.1.201211
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
jdk1.7.0_09
Online migration from mysql5.5(LINUX64) to Online CUBRID8.4.1.7007(Windows 32)
Description
1.The log is:
2012-11-01 17:53:47.640 Import 10 records from [decimaltest] to table [decimaltest] unsuccessfully. Error:Semantic: Cannot coerce host var to type numeric. ds from [datetimetest] to table [datetimetest] successfully.
2.You can get the source table,by the sqls below:
CREATE TABLE "decimaltest"(
"decimal65" numeric(38,0),
"udecimal65" numeric(38,0),
"decimal654" numeric(38,4),
"decimal132" numeric(13,2),
"decimal33" numeric(3,3),
"udecimal20" numeric(4,2)
)
;
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(10000000000000000000000000000000000000000000000000000000000000000.,10000000000000000000000000000000000000000000000000000000000000000.,1000000000000000000000000000000000000000000000000000000000000.,9.99,0.999,99.99);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(4564586897986550.,4253453454.,425345345345.,542352534.,0.,11.);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(99999999999999999999999999999999999999999999999999999999999999999.,99999999999999999999999999999999999999999999999999999999999999999.,9999999999999999999999999999999999999999999999999999999999999.9999,99999999999.99,0.999,99.99);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(9999999999999999999999999999999999999999999999999999999999999999.,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(99999999999999999999999999999999999999999999999999999999999999999.,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(99999999999999999999999999999999999999999999999999999999999999999.,99999999999999999999999999999999999999999999999999999999999999999.,9999999999999999999999999999999999999999999999999999999999999.9999,99999999999.99,0.999,99.99);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(NULL,NULL,NULL,NULL,-0.999,NULL);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(123456789123457000.,12345678912345700000000000000000000.,1234567890123460000000000000000000.,12345678912.34,0.999,99.99);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(4564586897986550.,4253453454.,425345345345.,542352534.,0.,11.);
INSERT INTO "decimaltest"("decimal65","udecimal65","decimal654","decimal132","decimal33","udecimal20")VALUES(4564586897986550.,4253453454.,425345345345.,542352534.,0.,11.);
I just know it has been reported in jira.
But I think the description of Error in the log file can be optimized, So Please optimize the word in log file this time, then it can be easily understood.(There both have successfully and unsuccessfully)