[sqlite] Obtaining rowid of an updated row in UPSERT

Dear SQLiters, If an INSERT ... ON CONFLICT DO UPDATE statement detects that a row already exists and needs to be updated, it doesn't seem to set lastRowid to the rowid of that row. Observe (sqlite 3.30.1): > create table users (id integer primary key, firstname text, lastname text,

Re: [sqlite] Obtaining rowid of an updated row in UPSERT

On 16.01.2020 14:02, Daniel Janus wrote: Dear SQLiters, If an INSERT ... ON CONFLICT DO UPDATE statement detects that a row already exists and needs to be updated, it doesn't seem to set lastRowid to the rowid of that row. Observe (sqlite 3.30.1):   > create table users (id integer prim