Indeed it is a bad idea to update the fields of a record that determine it's location in the index used for the scan. AFAIK SQLite will continue with the "next record" based on the updated record's position in the index being scanned. Depending on what you did to the fields used in the index, you may skip forwards or backwards, thereby processing some records multiple (up to infinity) times and/or not processing some records.