W
M
N
insert into user_agent (value) values ('test2') on conflict(value) do nothing returning id the first time i get the id and then for every new request the last row id is bumped and not returned, is this a d1 or sqlite thing?NNtest returns 1test returns nothing (insertion doesn't happen)test1 returns 3Ninsert into user_agent (value) values ('test2') on conflict(value) do update set value = excluded.value returning id works, but it feels wrong...
M
E
H
MM
--persist
JJJ
JJ — it has to be a lot moreJJJJJJJJJJ
EIf the first statement after BEGIN DEFERRED is a write statement, then a write transaction is started.BEGIN...Our implementation guarantees that each statement in the list will execute and commit, sequentially, non-concurrently. Batched statements are SQL transactions. If a statement in the sequence fails, then an error is returned for that specific statement, and it aborts or rolls back the entire sequence.E
implementationbatches
S
E
S
I
M
I
II
Our implementation guarantees that each statement in the list will execute and commit, sequentially, non-concurrently. Batched statements are SQL transactions. If a statement in the sequence fails, then an error is returned for that specific statement, and it aborts or rolls back the entire sequence.insert into user_agent (value) values ('test2') on conflict(value) do nothing returning idtesttest1test13insert into user_agent (value) values ('test2') on conflict(value) do update set value = excluded.value returning id