Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around fe1979552f43e052.
2021-01-29
| ||
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) | |
14:15 | Merge the latest trunk enhancements into the exists-to-in branch. (check-in: 13c4c9088c user: drh tags: exists-to-in) | |
11:39 | Add simple tests (and a fix) for the change on this branch. (check-in: 897f3f4026 user: dan tags: exists-to-in) | |
2021-01-14
| ||
20:57 | Improvements to the min/max optimization. Fix for a performance regression introduced at [b8ba2f17f938c035] reported by forum post 4050026ab8 (check-in: 249a71cc68 user: drh tags: trunk) | |
20:50 | Allow the planner to convert an EXISTS(SELECT...) expression in a WHERE clause to the equivalent IN(...) expression in situations where this is possible and advantageous. (check-in: 9f90a88221 user: dan tags: exists-to-in) | |
00:53 | The early-out of the inner loop on the min/max optimization was overly aggressive for the cases where there is a join and outer loops contain IN operators. Fix this. Test case in TH3. (Closed-Leaf check-in: ccd3bae14b user: drh tags: minmax-opt-exp) | |
2021-01-13
| ||
21:05 | Fix a harmless compiler warning. (check-in: 83ec01e38c user: drh tags: minmax-opt-exp) | |
19:28 | Expand the number of optimization-disable bits from 16 to 32. Use one of the new bits to disable the min/max optimization, so that we can more easily verify that we get the same answer both with and within that optimization. (check-in: fd0c9a123b user: drh tags: minmax-opt-exp) | |
15:23 | Further enhancements to the min/max optimization of check-in b8ba2f17f938c035 to fix the performance regression identified by forum post 4050026ab8. (check-in: 188772a1db user: drh tags: minmax-opt-exp) | |
12:59 | cli: Omit surplus whitespace at the end of lines in .explain output. (check-in: 11e4eb0957 user: drh tags: trunk) | |
11:44 | In the .selecttrace output, show the ORDER BY clause added by the Min/Max optimization. (check-in: db0ecfe664 user: drh tags: trunk) | |
2021-01-12
| ||
20:16 | Lexer and grammar rules for a RETURNING clause on DELETE/INSERT/UPDATE. Actually making this work, though, will involve a lot more code which will likely slow down processing for the common case where there is no RETURNING clause. Furthermore, RETURNING seems to be of limited usefulness and it is not standard SQL. So we abandon it here. These experimental changes are parked in a branch as an historical reference. If circumstances changes, we might take up the cause again some day. (check-in: abf8da8156 user: drh tags: returning) | |