View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap