.ADI index gets corrupted when deleting large amounts of records
We have a rather large table (93 fields, 25 indexes), which I can consistently corrupt an index on by deleting a large amount of records.
I currently have a table of 459938 records.
If I attempt to delete 426744 of these using SQL (delete from TABLE1 where FIELD1>='8'), I get the message "poQuery: Error 7200: AQE Error: State = HY000; NativeError = 7017; [iAnywhere Solutions][Advantage SQL][ASA] Error 7017: Corrupt .ADI, .CDX or .IDX index."
Running a further select statement I can see only 2825 records were removed before the error occurred. Retrying the delete query results in one further record being deleted every time the query is run before getting the error again.
Deleting and recreating the indexes will fix the problem until the delete query is run again.
The problem can be reproduced on various servers using ADS 126.96.36.199 but I am currently using WindowsServer2008R2.
I can also reproduce a very similar problem by simply highlighting all the records in Arc32 and pressing the "Delete current or selected records" button.