Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/upsert1.test
|
2018-08-14
| ||
| 15:12 | Fix UPSERT so that it checks the target-constraint first and fires the DO UPDATE if that constraint is violated regardless of whether or not other constraints are in violation. This aligns SQLite behavior with what PostgreSQL does. Fix for ticket [908f001483982c43cdb476dfb590a1a]. file: [994bde41] check-in: [529fb55e] user: drh branch: trunk, size: 7332 | |
|
2018-07-11
| ||
| 13:34 | On an UPSERT when the order of constraint checks is rearranged, make sure that the affinity transformations on the inserted content occur before any of the constraint checks. Fix for ticket [79cad5e4b2e219dd197242e9e5f4e]. file: [ecd8f69e] check-in: [d120c45f] user: drh branch: trunk, size: 4499 | |
|
2018-04-23
| ||
| 20:38 | Fix a problem in sqlite3ExprCompare() associated with UPSERT. file: [d587db59] check-in: [67d0b2c1] user: drh branch: trunk, size: 4014 | |
|
2018-04-19
| ||
| 23:52 | Fix the handling of "PRAGMA count_changes=ON" with UPSERT. Also improved the implementation of count_changes in other places, without changing the behavior. file: [93431588] check-in: [c6f71115] user: drh branch: trunk, size: 3729 | |
|
2018-04-13
| ||
| 15:14 | Get the ON CONFLICT DO NOTHING form of upsert working by mapping it into INSERT OR IGNORE. file: [3b4e8e59] check-in: [d07f05e9] user: drh branch: upsert, size: 3269 | |
| 14:27 | Get the conflict-target clause parsing working correctly, with test cases. This change involves an enhancement to sqlite3ExprCompare() which needs to be reviewed on trunk prior to merging. file: [81966c8e] check-in: [5bf70425] user: drh branch: upsert, size: 2744 | |
| 13:44 | Improved conflict-target matching logic. file: [6eb6c5bb] check-in: [98d32ba6] user: drh branch: upsert, size: 1943 | |
| 13:06 | Back off of the extended upsert syntax that allows multiple ON CONFLICT clauses. The syntax now is exactly as in PostgreSQL and MySQL. Add support for WHERE clauses on the conflict-target phrase, for partial indexes. file: [4812fa1f] check-in: [2c1b1987] user: drh branch: upsert, size: 1725 | |
| 01:15 | Begin adding upsert logic. This is an incremental check-in. file: [6ebecb01] check-in: [80969643] user: drh branch: upsert, size: 1352 Added | |