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
-
sync-en
Difficulty 1/5 Under an hour Newbie friendliness 92/100
Maintainers usually reply within 1 day
-
sync-en
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
Maintainers usually reply within 3 days
-
Form
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
symfony/symfony-docs#23159 ·
Maintainers usually reply within 3 days
-
bug component: bulk editor support
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Yoast/wordpress-seo#23669 ·
Maintainers usually reply within 3 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
php/frankenphp#2688 ·
Maintainers usually reply within 1 day