/ File History
Login

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

History of src/upsert.c

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