Skip to content

I deleted records should get a new added_ms #24

@simonw

Description

@simonw

Spotted this when I had Showboat run a demo of the latest uvx sqlite-chronicle: https://gist.github.com/simonw/aa0f65ed10b1419181e5f78cc815f30e

Also https://claude.ai/code/session_0162NBkTdHMpUNxkBF1W6Pkb

Currently if you delete a record and then insert a record with the same primary key the chronicle table preserves the original added_ms timestamp. I think undeleting (aka reusing a previously-used primary key) should reset that to the time of the undelete operation.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions