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

2020-01-19 Thread Kees Nuyt
On Sun, 19 Jan 2020 17:07:38 +0100, you wrote: >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

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

2020-01-19 Thread Daniel Janus
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 primary

[sqlite] Obtaining rowid of an updated row in UPSERT

2020-01-16 Thread Daniel Janus
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,