View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap