Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: CMT8.4.3.201301
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
Win2003 x64 Enterprise SP2,java 1.6.0_21 and jdk 1.7.0_09
Description
1.I did the online migration use CMT8.4.13079 from CUBRID 8.4.1.7007 to CUBRID 9.0.0.0478.
2.log:
2012-10-30 18:43:56.406 Import 14 records from [bigintandint] to table [bigintandint] unsuccessfully. Error:jdbc:cubrid:10.34.64.107:38000:dzltest:dba:********:?charset=UTF-8
Too few input host variables provided.
3.If you want to reproduce the issue, please use the create and input sql to
get a table in CUBRID 8.4.1.3079 ,then,do online migration to CUBRID 9.0.0.0478.
CREATE TABLE "bigintandint"(
"bigint1" bigint,
"bigintu" numeric(20,0)
);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(1,NULL);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(NULL,2.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(9223372036854775806,18446744073709551615.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(-9223372036854775808,0.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(2000,3333.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(-9223372036854775808,0.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(9223372036854775806,18446744073709551615.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(1,NULL);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(NULL,2.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(9223372036854775806,18446744073709551615.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(-9223372036854775808,0.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(2000,3333.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(-9223372036854775808,0.);
INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(9223372036854775806,18446744073709551615.);
It is CUBRID(9.0) JDBC driver's bug.
Create CUBRIDPreparedStatement with "INSERT INTO "bigintandint"("bigint1","bigintu")VALUES(?,?);" can't work well.