Index behavior and keys with system delimiters (Functions/Subroutines/Programs,General)
Created at 20 AUG 2009 01:58PM
If an OpenInsight/Advanced Revelation data table contains data records with keys that contain system delimiters (@TM→@RM) in them and indexing is applied to this table the indexes can be corrupt and return incorrect results. This longstanding issue can be resovled by applying the attached RDK. This RDK updates F.INDEXER and BUILD.INDEX procedures to strip out any keys that have system delimiters. If any keys with these delimiters are encountered, they are written into the SYSLISTS item RTI_INDEX_ERRORS. These data records will remain in the table and are not deleted. They are only excluded from the indexes. This RDK may be applied to OpenInsight 8.0.x and above.