/ History for test/upsert1.test
Login

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

History for test/upsert1.test

2019-12-26
23:40
[88f9e258] part of check-in [f14ce948] If an UPSERT can cause an Abort due to a constraint failure, make sure the query planner knows this. Ticket [7c13db5c3bf74001]. (check-in: [f14ce948] user: drh branch: trunk, size: 8289)
2019-12-06
01:23
[0b740c84] part of check-in [ebf897e8] Do not allow UPSERT of a view. (check-in: [ebf897e8] user: drh branch: trunk, size: 8013)
2019-08-30
23:15
[9b115320] part of check-in [67381dad] Make sure OP_RealAffinity has been applied to all columns of type REAL in the excluded.* pseudo-table of an UPSERT. Ticket [5a3dba8104421320] (check-in: [67381dad] user: drh branch: trunk, size: 7712)
2018-08-14
15:12
[994bde41] part of check-in [529fb55e] 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]. (check-in: [529fb55e] user: drh branch: trunk, size: 7332)
2018-07-11
13:34
[ecd8f69e] part of check-in [d120c45f] 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]. (check-in: [d120c45f] user: drh branch: trunk, size: 4499)
2018-04-23
20:38
[d587db59] part of check-in [67d0b2c1] Fix a problem in sqlite3ExprCompare() associated with UPSERT. (check-in: [67d0b2c1] user: drh branch: trunk, size: 4014)
2018-04-19
23:52
[93431588] part of check-in [c6f71115] Fix the handling of "PRAGMA count_changes=ON" with UPSERT. Also improved the implementation of count_changes in other places, without changing the behavior. (check-in: [c6f71115] user: drh branch: trunk, size: 3729)
2018-04-13
15:14
[3b4e8e59] part of check-in [d07f05e9] Get the ON CONFLICT DO NOTHING form of upsert working by mapping it into INSERT OR IGNORE. (check-in: [d07f05e9] user: drh branch: upsert, size: 3269)
14:27
[81966c8e] part of check-in [5bf70425] 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. (check-in: [5bf70425] user: drh branch: upsert, size: 2744)
13:44
[6eb6c5bb] part of check-in [98d32ba6] Improved conflict-target matching logic. (check-in: [98d32ba6] user: drh branch: upsert, size: 1943)
13:06
[4812fa1f] part of check-in [2c1b1987] 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. (check-in: [2c1b1987] user: drh branch: upsert, size: 1725)
01:15
[6ebecb01] part of check-in [80969643] Begin adding upsert logic. This is an incremental check-in. (check-in: [80969643] user: drh branch: upsert, size: 1352) Added