db-sqlite
db-sqlite copied to clipboard
SQLite driver for Yii Database
### Related PR - https://github.com/yiisoft/db/pull/945 | Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? | ✔️ | Breaks BC? | ✔️/❌ | Fixed...
SQLite don't support `CASCADE`, but we can make it manually.
From the [documentation](https://www.sqlite.org/lang_createtable.html) > If a schema-name is specified, it must be either "main", "temp", or the name of an [attached database](https://www.sqlite.org/lang_attach.html). [PRAGMA database_list;](https://sqlite.org/pragma.html#pragma_database_list) https://github.com/yiisoft/yii2/issues/20262
| Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? | ❌ | Breaks BC? | ✔️ Related to https://github.com/yiisoft/db/pull/1108
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...