Repository navigation
last_insert_rowid() in auto-commit reads a fresh Hrana session #83
Description
Found while landing #39. In auto-commit mode, a direct SELECT last_insert_rowid() runs on a fresh one-shot Hrana stream and returns 0, while xerial 3.53.4.0 returns the connection's last insert rowid.
#39 avoids depending on that query by reading last_insert_rowid from the Hrana insert result, but the direct-query behavior still differs. A fix needs connection-scoped execution for session-state functions in auto-commit, verified against live sqld.
Activity
docs(jdbc): document last_insert_rowid under the remote model (#83) (#…
docs: rewrite the transaction contract for lazy begin and mapped erro…
magnusp commentedon Oct 30, 2026
Hibernate's SQLite
GenerationType.IDENTITYalso reads the identity with a separateselect last_insert_rowid(), so it depends on the same session-state behavior. The new Hibernate integration suite (#264) keeps auto-commit disabled and documents this dependency rather than duplicating the issue.test(jdbc): add Hibernate integration smoke tests (#264)