-
-
Notifications
You must be signed in to change notification settings - Fork 692
[Regression][SQLite] Insert + On Conflict Do Nothing = error #1549
Copy link
Copy link
Closed
Description
Description
In SeaORM prior 0.11, running the following query twice works fine:
INSERT INTO \"group_user_membership\" (\"user_id\", \"group_id\") VALUES ('01GVEMDSKK33QX8ET4601B4HG7', '00000000000000000000000000') ON CONFLICT (\"group_id\", \"user_id\") DO NOTHING"Running it on 0.11.x results in DbErr::RecordNotInserted
Steps to Reproduce
- Insert a record
- Insert a conflicting record instructing to do nothing on conflict
Expected Behavior
No error, not records inserted.
Actual Behavior
Get an error: DbErr::RecordNotInserted
Reproduces How Often
Every single time.
Workarounds
Check for DbErr::RecordNotInserted prior bubbling error up the stack.
Reproducible Example
Versions
0.11.0 and 0.11.1
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels