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 | |