# 96 Secondary Indexes are Not Getting Updated Properly When Adding or Updating Data

---

Secondary index does not seem to be maintained. After entering a new field value in an existing record, with a secondary index selected, the index order is lost. Subsequent searches on that indexed field fail when searching for valid values. The table has to be repaired before secondary index is usable again.
The secondary index was single integer field in sscending order. Nothing very special, except, there were a large number of nulls in this particular field.