Re: [sqlite] insert or replace - bug or intended behaviour?

> there might be a bug in the replace-conflict handler of sqlite-2.8.15... What you are seeing is the correct behavior; the entire row is replaced. Perhaps you are confusing insert with update. Regards

[sqlite] insert or replace - bug or intended behaviour?

Dear all, there might be a bug in the replace-conflict handler of sqlite-2.8.15, but I'm not sure about it. Here is what I do: -- > CREATE TABLE tbl(key integer primary key, value integer, other integer); > INSERT INTO tbl VALUES(1, 1, 3); > INSERT OR REPLACE INTO tbl (key, value) values(1,