/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/upsert1.test

2019-08-30
23:15
Make sure OP_RealAffinity has been applied to all columns of type REAL in the excluded.* pseudo-table of an UPSERT. Ticket [5a3dba8104421320] file: [9b115320] check-in: [67381dad] user: drh branch: trunk, size: 7712
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