sqldelight icon indicating copy to clipboard operation
sqldelight copied to clipboard

Support ON CONFLICT in SQLite

Open swankjesse opened this issue 1 year ago • 3 comments
trafficstars

SQLDelight Version

2.0.1

SQLDelight Dialect

Android SDK 33

Describe the Bug

Fro the upsert docs, this syntax is valid:

CREATE TABLE vocabulary(word TEXT PRIMARY KEY, count INT DEFAULT 1);
INSERT INTO vocabulary(word) VALUES('jovial')
  ON CONFLICT(word) DO UPDATE SET count=count+1;

Stacktrace

No response

swankjesse avatar Apr 10 '24 18:04 swankjesse

Any updates on this one ?

mahmed1987 avatar Jun 20 '24 09:06 mahmed1987