Icon View Incident Report

Minor Minor
Reported By: Dave M
Reported On: 5/17/2006
For: Version 4.24 Build 1
# 2200 Using ALTER TABLE Inside of a Transaction Causes Access Violation

I made the mistake of doing the following. This causes a 11279 access violation in a query c/s 4.23b and in dbsys (both c/s and local). This error shows up in the server log.

START TRANSACTION WITH sometable;
ALTER sometable 
ADD COLUMN if not exists "somecolumn" date;
COMMIT FLUSH



Resolution Resolution
Fixed Problem on 5/18/2006 in version 4.25 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