Marv
10/14/2025, 4:00 PMON CONFLICT statement in room?
INSERT INTO X (a,b,c) VALUES (:x, :y, :z)
ON CONFLICT(X) DO UPDATE SET
a=excluded.a
WHERE excluded.b > X.b
works, but using multiple ON CONFLICT results in error.
The "spec" suggests you can have multiple ON CONFLICT in the statement and it works in sqlite3 command line