SQLite

All files named ”test/upsert1.test”
Login

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

History for test/upsert1.test

2025-04-10
10:18
[77e3cbabd6] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 10109)
2024-04-12
11:28
[beba4316fb] part of check-in [0cf4d835da] Test case for the fix in the previous check-in. (check-in: [0cf4d835da] user: drh branch: btree-ovfl-cache, size: 10113)
2023-08-17
17:48
[a512e2f884] part of check-in [3c06709335] Do not allow bound parameters in the ON CONFLICT clause of an UPSERT. dbsqlfuzz 9983e2c77634a8ccf33b5c91fa9982599de5f9e9 (check-in: [3c06709335] user: drh branch: trunk, size: 9307)
2021-12-30
02:38
[b0ae2f5868] part of check-in [2f09b51b1f] When a table has an INTEGER PRIMARY KEY ON CONFLICT REPLACE and some other uniqueness constraint, and it participates in an upsert on that other constraint, ensure that code that checks for conflicts on the INTEGER PRIMARY KEY is well-formed. Fix for the problem reported by forum post 06b16b8b29f8c8c3. (check-in: [2f09b51b1f] user: drh branch: trunk, size: 8858)
2020-07-29
16:18
[eb32e56adf] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 8290)
2019-12-26
23:40
[88f9e258c6] part of check-in [f14ce94866] If an UPSERT can cause an Abort due to a constraint failure, make sure the query planner knows this. Ticket [7c13db5c3bf74001]. (check-in: [f14ce94866] user: drh branch: trunk, size: 8289)
2019-12-06
01:23
[0b740c8488] part of check-in [ebf897e861] Do not allow UPSERT of a view. (check-in: [ebf897e861] user: drh branch: trunk, size: 8013)
2019-08-30
23:15
[9b11532014] part of check-in [67381daded] 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: [67381daded] user: drh branch: trunk, size: 7712)
2018-08-14
15:12
[994bde4180] part of check-in [529fb55e3d] 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: [529fb55e3d] user: drh branch: trunk, size: 7332)
2018-07-11
13:34
[ecd8f69e20] part of check-in [d120c45f3d] 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: [d120c45f3d] user: drh branch: trunk, size: 4499)
2018-04-23
20:38
[d587db593f] part of check-in [67d0b2c152] Fix a problem in sqlite3ExprCompare() associated with UPSERT. (check-in: [67d0b2c152] user: drh branch: trunk, size: 4014)
2018-04-19
23:52
[934315888a] part of check-in [c6f71115eb] 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: [c6f71115eb] user: drh branch: trunk, size: 3729)
2018-04-13
15:14
[3b4e8e5932] part of check-in [d07f05e98b] Get the ON CONFLICT DO NOTHING form of upsert working by mapping it into INSERT OR IGNORE. (check-in: [d07f05e98b] user: drh branch: upsert, size: 3269)
14:27
[81966c8ef8] part of check-in [5bf7042562] 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: [5bf7042562] user: drh branch: upsert, size: 2744)
13:44
[6eb6c5bb63] part of check-in [98d32ba661] Improved conflict-target matching logic. (check-in: [98d32ba661] user: drh branch: upsert, size: 1943)
13:06
[4812fa1f1f] part of check-in [2c1b1987d8] 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: [2c1b1987d8] user: drh branch: upsert, size: 1725)
01:15
Added: [6ebecb01d1] part of check-in [8096964340] Begin adding upsert logic. This is an incremental check-in. (check-in: [8096964340] user: drh branch: upsert, size: 1352)