Hello,
I would like to test the consistency check function but I have
difficulties inserting certain inconsistencies into the database for
proper testing.
I found a Testscript which uses T_ConsistencyChecker.class and managed
to run it but so far it only tests the following cases:
- Base tables and all associated indexes contain the same number of rows.
- The values and row locations in each index match those of the base table.
According to the documentation, there are two other cases:
- Base tables are internally consistent.
- All BTREE indexes are internally consistent.
Is it possible to manipulate the base tables and/or the btree indexes
in a way to cause inconsistencies, so I can run this function to find
them?
What would be the error messages of these cases?
Thank you,
Tu
