Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
15 check-ins related to "generalized-upsert"
|
2020-12-14
| ||
| 15:39 | Enhance UPSERT so that it allows multiple ON CONFLICT clauses and does not require a conflict target for DO UPDATE. (check-in: 6b01a24d user: drh tags: trunk) | |
| 13:52 | Minor changes for test coverage. (Closed-Leaf check-in: e5a8fa50 user: drh tags: generalized-upsert) | |
|
2020-12-12
| ||
| 00:43 | More test cases. No new problems discovered. (check-in: f34dd67e user: drh tags: generalized-upsert) | |
| 00:28 | New test cases with corresponding bug fixes. (check-in: f22c21a9 user: drh tags: generalized-upsert) | |
|
2020-12-11
| ||
| 19:36 | Begin adding test cases. Fix one bug found so far. More are pending. (check-in: aadd67dd user: drh tags: generalized-upsert) | |
| 17:11 | Small performance tweaks. (check-in: 5321d60c user: drh tags: generalized-upsert) | |
| 16:49 | Bug fixes so that legacy tests pass. New tests for new functionality have not yet been added. (check-in: aa76790e user: drh tags: generalized-upsert) | |
| 01:17 | Logic is in place to handle multiple ON CONFLICT clauses, but it does not work. Any use of ON CONFLICT will likely lead to memory faults. This is an incremental check-in to save my place. (check-in: 15514231 user: drh tags: generalized-upsert) | |
|
2020-12-10
| ||
| 20:31 | Use an iterator for the index loop in sqlite3GenerateConstraintChecks(). The idea is that this iterator can be enhanced to traverse the indexes in any order, as required by multi-index UPSERT. (check-in: 64a4a91e user: drh tags: generalized-upsert) | |
| 12:49 | The DO UPDATE code generator searches for the correct ON CONFLICT clause to use. (check-in: a47e35ee user: drh tags: generalized-upsert) | |
|
2020-12-09
| ||
| 20:30 | For upsert, the constraint check code generator uses a copy of the index list for the target table, which can potentially be reordered. (check-in: 3194c00c user: drh tags: generalized-upsert) | |
| 13:11 | Improved comments in sqliteInt.h. No changes to code. (check-in: 8ccb8d1d user: drh tags: generalized-upsert) | |
| 01:34 | Initialize all terms in the ON CONFLICT clause stack. (check-in: 5e683fd1 user: drh tags: generalized-upsert) | |
|
2020-12-08
| ||
| 14:29 | Enhance UPSERT parsing to allow multiple ON CONFLICT clauses. Only the very last clause may omit the conflict target, but the conflict target may now be omitted for the DO UPDATE resolution. (check-in: 2ca62f4c user: drh tags: generalized-upsert) | |
|
2020-12-07
| ||
| 23:14 | Fix a bad assert() in math1Func(). (check-in: 4b286129 user: drh tags: trunk) | |