Error on `upsert()` to table with several unique/primary keys
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 45/100
Research direction
Start by reproducing the reported upsert() failure against a SQLite table with one primary key and another unique key. Inspect the SQLite driver's upsert path and add or update coverage for this schema; done means the upsert succeeds without the ON CONFLICT constraint error.
Written by the indexing model from the issue text.
Description
There is table with one primary key and yet another unique key. On upsert() usage throws error:
SQLSTATE[HY000]: General error: 1 ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint
Seems for SQLite requires created separate ON CONFLICT clause for each of keys.
- Dominant language
- PHP
- Stars
- 30
- Forks
- 13
- Avg merge
- 1d 11h
- Merged PRs (30d)
- 4
Getting set up
- No Dockerfile or Docker Compose file
- Has a pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from yiisoft/db-sqlite
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Support schema namesOpen
Difficulty 4/5 3-5 days Newbie friendliness 25/100
-
status:ready for adoption type:enhancement
Difficulty 4/5 3-5 days Newbie friendliness 42/100
All issues in yiisoft/db-sqlite
Similar issues
-
Bug
Difficulty 1/5 Under an hour Newbie friendliness 90/100
Maintainers usually reply within 1 day
-
0. Needs triage 35-feedback bug
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Maintainers usually reply within 1 day
-
Notification e-mails are sent without Date and Message-ID headersPossibly taken @nofuturekid claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
unraid/webgui#2781 · 1 comment ·
Maintainers usually reply within 6 days
-
1.severity: security
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
NixOS/nixpkgs#569828 · 1 reaction ·
Maintainers usually reply within 1 day
-
Use FormEvents constants when generating subscriberPossibly taken @GromNaN claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
symfony/maker-bundle#1841 ·
Maintainers usually reply within 1 day