I've got a Ultralite BUG during a database schema upgrade using the ALTER DATABASE SCHEMA FROM FILE command.
If I try to add an index to a column of a existent table that already has an indexed column (by schema migration), the Ultralite database becomes invalid and the following error is shown during the database validation:
Validation failed: Index validation failed for table Test, index Test with code: 120
Following, I put the steps to reproduce this problem (All steps were done using the SybaseCentral):
The following output is shown:
Checking page (1) Validating table Test Validating index primary on table Test Validating index Test on table Test Incorrect row count for index Test on table Test Validating index IX_test on table Test Validating table sysuldata Validating index primary on table sysuldata Validation failed: Index validation failed for table Test, index Test with code: 120
Thank you for posting this, and for the repro. We will look into it.
At this point I can't think of a workaround other than the obvious :)
answered 20 Jan '12, 10:35