Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around fc98218cf69e63bdb9e5.
|
2021-01-30
| ||
| 21:55 | Improved comments on the new code. (check-in: a38f0c1d7c user: drh tags: returning) | |
| 16:16 | Add an ALWAYS() to an unreachable branch. (check-in: 6bb6de42b6 user: drh tags: returning) | |
| 14:17 | Change the OP_ResultRow opcode so that it does not cancel pending statement transactions. (check-in: fea91e3a51 user: drh tags: returning) | |
| 12:07 | Fix a obsolete assert() in the bytecode engine. Improved OOM detection in sqlite3AddReturning(). (check-in: 138b10d54a user: drh tags: returning) | |
| 03:06 | Fix handling of an OOM condition in sqlite3AddReturning(). (check-in: 52204cd768 user: drh tags: returning) | |
| 02:43 | Fix a memory deallocation problem that comes up when doing a RETURNING query on a corrupt database. I think I fixed this before, but it got unfixed with stale editor content. (check-in: 02b1415efb user: drh tags: returning) | |
| 02:34 | Another attempt to get trigger selection correct for RETURNING triggers. (check-in: 1b8ed52275 user: drh tags: returning) | |
| 02:22 | When running the RETURNING trigger, if it is tagged as a DELETE trigger, do not use it as INSERT or UPDATE. (check-in: 3c7a6e04dd user: drh tags: returning) | |
| 01:30 | Test cases added. RETURNING works with UPSERT as does PG. (check-in: f5698f96e2 user: drh tags: returning) | |
|
2021-01-29
| ||
| 22:33 | Better handling of errors in RETURNING due to corrupt database files. (check-in: 6aa2a058d1 user: drh tags: returning) | |
| 21:31 | RETURNING works even if "PRAGMA count_changes=ON" is set. (check-in: a9122d9757 user: drh tags: returning) | |
| 21:18 | Allow "*" wildcards in the RETURNING clause. (check-in: b0e3ae303d user: drh tags: returning) | |
| 19:32 | Working prototype. (check-in: b7ef4dc21f user: drh tags: returning) | |
| 16:20 | Fix possible division-by-zero in the new log() SQL functions. Problemm discovered by OSSFuzz. (check-in: 1ffd321a33 user: drh tags: trunk) | |
| 14:22 | Incorporate the sqlite3TriggerList() optimization from trunk. And move the pReturning field to the uninitialized area in the Parse object, to save memset() time. (check-in: 29fbaf0e3e user: drh tags: returning) | |
| 13:47 | Performance optimization (and size reduction) in sqlite3TriggerList() for the common case where there are no TEMP triggers. (check-in: 0defaf730b user: drh tags: trunk) | |
|
2021-01-27
| ||
| 20:35 | Merge recent enhancements from trunk. (check-in: 5fbcb208d2 user: drh tags: returning) | |
| 19:15 | Fix an issue with IN operator optimization introduced by check-in [4a43430fd23f8835] and described by ticket [ee51301f316c09e9]. (check-in: 9dc7fc9f04 user: drh tags: trunk) | |
| 17:15 | Ensure a cursor used by the SeekScan operator does not point to a valid row on the first iteration of the loop. Possible fix for [ee51301f316c09e]. (Closed-Leaf check-in: 390cf60a28 user: dan tags: fix-2d6e8400) | |
|
2021-01-25
| ||
| 21:24 | Add an extra log message in the case of an SQLITE_CORRUPT_INDEX error. (check-in: 0571c24177 user: drh tags: trunk) | |
|
2021-01-22
| ||
| 21:23 | Enhance the query planner to enable it to use an index for IS NOT NULL constraints, even if STAT4 is not enabled. (check-in: 7b2a7c7314 user: drh tags: trunk) | |
| 20:28 | Merge fixes from trunk. Omit a conditional in sqlite3IsLikeFunction() that was made unreachable by this enhancement. (Closed-Leaf check-in: 0b42f9eb5d user: drh tags: isnotnull-opt) | |
|
2021-01-21
| ||
| 21:36 | Do not allow VACUUM to resize the page_size to 512 if the reserve_byte value is 31 or greater. forum post e807885dc5. (check-in: d5ea75a09d user: drh tags: trunk) | |
| 20:42 | Performance optimizations in exprAnalyze() (check-in: 6d60cf540b user: drh tags: isnotnull-opt) | |
| 17:54 | Always enable the IS NOT NULL optimization, even if STAT4 is not enabled. (check-in: fc98218cf6 user: drh tags: isnotnull-opt) | |
| 16:02 | Fix a problem caused by using an SQL variable in an OVER clause within a trigger program. Edit: The problem appears to have existed ever since window functions landed on trunk (check-in [17198a1206e2fbc9]) on 2018-06-30, version 3.25.0. (check-in: 02264ab6a0 user: dan tags: trunk) | |
| 15:40 | Fix a problem caused by using an SQL variable in an OVER clause within a trigger program. (Closed-Leaf check-in: 4f676466e6 user: dan tags: fix-over-trigger) | |
|
2021-01-20
| ||
| 23:01 | Improvements to the auxiliary "main.mk" makefile so that it works better with multi-threaded builds. (check-in: d1873054d8 user: drh tags: trunk) | |
| 15:10 | Incorporate the 3.34.1 patches into the reuse-schema branch. (Leaf check-in: cc0e582854 user: drh tags: reuse-schema-3.34) | |
| 14:10 | Version 3.34.1 (Leaf check-in: 10e20c0b43 user: drh tags: release, patch, version-3.34.1, branch-3.34) | |
| 10:59 | Add tests for sqlite3session_memory_used() interface. (check-in: 5596611f96 user: dan tags: trunk) | |
|
2021-01-19
| ||
| 20:38 | Fix an issue with sha3_query() when the first argument contains blank SQL statements. (check-in: a1a7a5f238 user: drh tags: branch-3.34) | |
| 20:17 | Bump the version number to 3.34.1. (check-in: cea7d0f8a3 user: drh tags: branch-3.34) | |
| 20:09 | Fix a problem handling sub-queries with both a correlated WHERE clause and a "HAVING 0" clause where the parent query is itself an aggregate. The problem was apparently introduced by check-in [6e6b3729e0549de0] (check-in: 30a4c32365 user: drh tags: branch-3.34) | |
| 20:04 | Prevent potential segfault in the sqlite-expert idxPopulateStat1 context cleanup code. (check-in: 69e31d52b2 user: drh tags: branch-3.34) | |
|
2021-01-18
| ||
| 19:28 | Fix harmless compiler warnings seen with MSVC. (check-in: dc7938d2d7 user: mistachkin tags: trunk) | |
| 19:27 | Update test helper procedure 'get_pwd' to handle the ComSpec environment variable being absent. (check-in: fe1979552f user: mistachkin tags: trunk) | |
| 12:35 | Enhance the query planner so that it is able to code EXISTS operators in the WHERE clause as if they were IN operators, when appropriate. (check-in: c1862abb44 user: drh tags: trunk) | |
| 00:11 | More comments on the EXISTS-to-IN optimization logic. (Closed-Leaf check-in: 92cc29099f user: drh tags: exists-to-in) | |
|
2021-01-17
| ||
| 00:13 | Minor simplification of the EXISTS-to-IN logic. (check-in: cac90a9f4a user: drh tags: exists-to-in) | |
|
2021-01-16
| ||
| 20:22 | Improved handling of vector equalities in the EXISTS-to-IN translator. (check-in: ef49ee4a37 user: drh tags: exists-to-in) | |
| 18:55 | Give the EXISTS-to-IN optimization the ability to handle some cases that involve vector comparisons, instead of throwing a mysterious error in those cases. (check-in: 87e78a19bb user: drh tags: exists-to-in) | |
| 18:22 | Add debugging output about the EXISTS-to-IN optimization when the ".wheretrace" flag has the 0x20 bit set. (check-in: 0dad5ce34a user: drh tags: exists-to-in) | |
| 12:15 | Fix a hyperlink in the Lemon documentation. (check-in: 2ffb2ffa0e user: drh tags: trunk) | |
|
2021-01-15
| ||
| 17:51 | Add OOM injection tests for new code on this branch. (check-in: 9a181dbaed user: dan tags: exists-to-in) | |
| 16:37 | Update header comments for routines added by this branch. (check-in: 950030d679 user: dan tags: exists-to-in) | |
| 15:32 | Ensure the EXISTS->IN transformation preserves the collation sequence of the comparison operation. (check-in: a373baae12 user: dan tags: exists-to-in) | |
| 15:21 | Fix a potential NULL pointer dereference following OOM. (check-in: 8ce3cb9096 user: drh tags: exists-to-in) | |
| 15:17 | Add a new optimizer disabling bit to close off the exists-to-in optimization, for testing purposes. (check-in: a80c9a076d user: drh tags: exists-to-in) | |
| 14:25 | Small performance improvement in the EXISTS-to-IN translator for the common case where the EXISTS operator is not found in the WHERE clause. (check-in: dcb7772d76 user: drh tags: exists-to-in) | |