Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1.201211
-
Fix Version/s: CMT8.4.1.201211
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT8.4.1.3082
From CUBRID8.4.1.7007 to CUBRID9.0.0.0478
Description
1 There is table in CUBRID8.4.1.7007
CREATE TABLE "autoincrem"(
"i" integer AUTO_INCREMENT(4,1) NOT NULL,
"b" integer DEFAULT 33,
"c" integer NOT NULL,
CONSTRAINT pk_autoincrem_i PRIMARY KEY("i")
);
2 Do migration to CUBRID9.0.00478 via offline
Actual result:
After migration, it become to:
CREATE TABLE "autoincrem"(
"i" integer(10) AUTO_INCREMENT NOT NULL,
"b" integer(10) DEFAULT 33,
"c" integer(10) NOT NULL,
CONSTRAINT pk_autoincrem_i PRIMARY KEY("i")
);
It has lost current values for auto_increment.
The current_value will be used in CUBRID 8.4.1 when inserting new record
and The current_value+1 will be used in CUBRID 9.0.x when inserting new record, there are different.