/ All files named "src/upsert.c"
Login

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

History for src/upsert.c

2019-12-26
23:40
[2920de71] 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: 9047)
2019-10-19
13:29
[b445315c] part of check-in [27ab41c9] Refactor names of column index transformation functions, for clarity. Get generated columns working with ALTER TABLE RENAME COLUMN. (check-in: [27ab41c9] user: drh branch: generated-columns, size: 9016)
2019-08-30
23:15
[710c91bb] 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: 9011)
2018-08-21
12:16
[0dd81b40] part of check-in [a04a0ea9] Fix various harmless warnings generated by static analysis tools. (check-in: [a04a0ea9] user: drh branch: trunk, size: 8782)
2018-05-28
17:31
[47edd408] part of check-in [5a4542db] When compiling with SQLITE_DEBUG, add run-time checks to ensure that no statement aborts unless either there have been no writes or else there is a statement journal. (check-in: [5a4542db] user: drh branch: stmt-journal-testing, size: 8746)
2018-04-20
18:01
[ae4a4823] part of check-in [279c48f6] Fix a VDBE comment on upsert. Provide an error message when upsert detects index corruption. (check-in: [279c48f6] user: drh branch: trunk, size: 8699)
16:49
[23b386d7] part of check-in [131ed95e] Improved VDBE comment on UPSERT code. (check-in: [131ed95e] user: drh branch: upsert-opt2, size: 8617)
15:56
[4f1d04b8] part of check-in [7c4b6d54] Avoid unnecessary cursor seeks during upsert processing. (check-in: [7c4b6d54] user: drh branch: upsert-opt2, size: 8548)
13:18
[71ebb84f] part of check-in [c37f39d1] Enhance UPSERT so that the UPDATE uses the same set of cursors as the INSERT. (check-in: [c37f39d1] user: drh branch: trunk, size: 9044)
2018-04-19
21:29
[ee5c9e44] part of check-in [e657c1d6] Minor simplification to the upsert logic. (check-in: [e657c1d6] user: drh branch: trunk, size: 9170)
2018-04-18
18:18
[ed50cfcf] part of check-in [8f4376e5] Improved matching of COLLATE clauses within the ON CONFLICT conflict-target. (check-in: [8f4376e5] user: drh branch: trunk, size: 8977)
2018-04-17
21:59
[3e152ac4] part of check-in [558865d5] Remove unreachable branches. 100% MC/DC in TH3 now. (check-in: [558865d5] user: drh branch: upsert, size: 8837)
18:16
[e83fd8c0] part of check-in [27cd3b2f] Add some more simple test cases for UPSERT. And a minor fix. (check-in: [27cd3b2f] user: dan branch: upsert, size: 8870)
2018-04-16
13:00
[5d949141] part of check-in [0203f34f] Add support for the "excluded.*" names in the UPDATE clause of an upsert. (check-in: [0203f34f] user: drh branch: upsert, size: 8600)
2018-04-14
22:35
[3baeab51] part of check-in [d3c53fd3] Get upsert working on WITHOUT ROWID tables. (check-in: [d3c53fd3] user: drh branch: upsert, size: 8591)
2018-04-13
21:55
[a82eacec] part of check-in [a9080bc8] First cut at logic to perform DO UPDATE for rowid tables. (check-in: [a9080bc8] user: drh branch: upsert, size: 7877)
18:59
[bd9b5b48] part of check-in [6d3017f9] Add infrastructure for doing an UPDATE as part of an UPSERT. Still no actual UPDATE code, however. (check-in: [6d3017f9] user: drh branch: upsert, size: 6707)
14:27
[1535f427] 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: 6078)
13:44
[5012bea9] part of check-in [98d32ba6] Improved conflict-target matching logic. (check-in: [98d32ba6] user: drh branch: upsert, size: 5730)
13:06
[ae29d025] 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: 4950)
01:15
[c48c365e] part of check-in [80969643] Begin adding upsert logic. This is an incremental check-in. (check-in: [80969643] user: drh branch: upsert, size: 3836)
2018-04-12
21:42
Added: [8b1a4fc6] part of check-in [389806b0] Break out the upsert code into a separate source file. (check-in: [389806b0] user: drh branch: upsert, size: 2091)