Icon View Incident Report

Serious Serious
Reported By: Pedro Silva
Reported On: 1/11/2005
For: Version 4.16 Build 1
# 1943 TDBISAMTable OptimizeTable, CopyTable, and AlterTable Populating NULL Fields with Default Values

I've recently updated from version 4.05 to 4.16 in Delphi 7. I noticed that if you do an index optimization of a table (with dbsys, etc...) the null values that exist in a Time field are changed to 0.

Comments Comments
This also includes the SQL equivalents - OPTIMIZE TABLE, COPY TABLE, and ALTER TABLE. Of special note is that previously the AlterTable method would fill any NULL columns with the default value for the column if one was present in the table. This was an incorrect behavior, and it was presumptious of DBISAM to assume that the any NULL columns should be replaced with the default value for the column.

Resolution Resolution
Fixed Problem on 1/12/2005 in version 4.17 build 1