Hi @larry,
Thanks for your response to my query.
We are doing below checks during application initialisation if we have db which was created before:
PRAGMA integrity_check
SELECT name FROM sqlite_master WHERE type = 'table'
pragma table_info('<tableName>')
pragma index_list('<tableName>')'
pragma index_info('<indexName>')
and later if we get above mentioned error codes and other error codes like SQLITE_CORRUPT/SQLITE_NOTADB/SQLITE_READONLY/SQLITE_ERROR, we recreate the database where we end up losing data.
I guess we are not over reporting the case of database corruption by considering these cases for database corruption.
Thanks.