Reported By: Pedro Silva Reported On: 1/11/2005 For: Version 4.16 Build 1
# 1943TDBISAMTable 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.
CommentsThis 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.
ResolutionFixed Problem on 1/12/2005 in version 4.17 build 1