Currently, the SqLite is using the INSERT OR REPLACE method/operation for MERGE operation. This does not do the expected operation. The purpose of MERGE is to update the existing row if present, otherwise insert a new one. The operation will be based on the passed qualifier fields. In the case of INSERT OR REPLACE, it is setting the other fields to NULL if that is not a part of the query expressions.
An issue has been replicated and proven on this small project.
Currently, the SqLite is using the
INSERT OR REPLACEmethod/operation forMERGEoperation. This does not do the expected operation. The purpose ofMERGEis to update the existing row if present, otherwise insert a new one. The operation will be based on the passed qualifier fields. In the case ofINSERT OR REPLACE, it is setting the other fields toNULLif that is not a part of the query expressions.An issue has been replicated and proven on this small project.