Icon View Incident Report

Serious Serious
Reported By: Jason Wilson [GlobeStar Systems]
Reported On: 4/11/2013
For: Version 4.35 Build 2
# 3755 Autoinc Field Rollover Not Working Properly

Looks like the AutoInc rollover does not work properly.

Use the following SQL to create a table in dbsys and then open it in dbsys and start adding rows by updating the MyText column - autoinc field is correctly filled in using 2147483641 until 2147483647 and then it rolls over to 1 and then all future inserts result in one.

CREATE TABLE IF NOT EXISTS "autoinctest"
(
   "MyID" AUTOINC,
   "MyText" VARCHAR(10),
PRIMARY KEY ("RecordID") COMPRESS NONE
LAST AUTOINC 2147483640
);



Resolution Resolution
Fixed Problem on 4/12/2013 in version 4.36 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image