Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
35 events for the month beginning 2020-12-01 by user dan
Following month ↑|
2020-12-23
| ||
| 16:46 | Add the sqlite3session_memory_used() API to the sessions module. For querying the amount of heap memory currently being used by a session object. (check-in: 823f75c2 user: dan tags: trunk) | |
|
2020-12-22
| ||
| 20:35 | Fix SQLITE_OMIT_WINDOWFUNC builds by moving declaration of sqlite3ExpandSubquery out of "ifndef SQLITE_OMIT_WINDOWFUNC" block. (check-in: 9587fa8b user: dan tags: trunk) | |
| 16:23 | 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: f62f983b user: dan tags: trunk) | |
|
2020-12-21
| ||
| 19:50 | Fix problems with joining UNION ALL sub-queries against other sub-queries that contain LEFT JOIN. (check-in: d554f710 user: dan tags: trunk) | |
| 18:39 | Fix a problem when flattening joins between a UNION ALL sub-query and another sub-query that uses more than one window function. (check-in: ef9733fe user: dan tags: trunk) | |
|
2020-12-19
| ||
| 15:39 | Fix a broken assert() in fts5 that could be triggered by corrupt database records. (check-in: b79f59f9 user: dan tags: trunk) | |
|
2020-12-18
| ||
| 18:04 | Fix for the previous fix in the case where a UNION ALL sub-query is joined against some other compound query. (Closed-Leaf check-in: 63c5cfb9 user: dan tags: union-all-flattener) | |
| 16:13 | When flattening UNION ALL subqueries into a join query, ensure that separate cursor numbers are used for each segment of the newly flattened query. (check-in: c510377b user: dan tags: union-all-flattener) | |
|
2020-12-17
| ||
| 17:17 | Fix a part of the header comment for flattenSubquery(). (check-in: dc0937ce user: dan tags: union-all-flattener) | |
| 16:48 | Add test cases and minor fixes to this branch. (check-in: 5d6dc29d user: dan tags: union-all-flattener) | |
| 11:30 | Merge latest trunk changes into this branch. (check-in: 9f41f604 user: dan tags: reuse-schema) | |
| 11:24 | Fix a problem with sqlite3_expanded_sql() that could occur with statements that use both numbered (e.g. "?1") and unnumbered (i.e. "?") parameters. (check-in: 2a6cd683 user: dan tags: trunk) | |
|
2020-12-16
| ||
| 20:00 | Allow sub-queries that use UNION ALL to be flattened, even if the parent query is a join. Still some problems on this branch. (check-in: 00e4bf74 user: dan tags: union-all-flattener) | |
|
2020-12-15
| ||
| 19:27 | Fix another integer overflow triggered by a corrupt database in recently modified vacuum code. (check-in: 4e2dd2a5 user: dan tags: trunk) | |
| 16:28 | When the -statstep option is passed to the "rbu" executable, print out memory stats right before exiting, as well as every -statstep steps. (check-in: 94f81b51 user: dan tags: trunk) | |
| 13:55 | Change an fts5 assert() that can be triggered by a corrupt database to an if() condition. (check-in: ea0a7f10 user: dan tags: trunk) | |
|
2020-12-14
| ||
| 15:25 | Fix an integer overflow problem in new VACUUM code. (check-in: 59b4367f user: dan tags: trunk) | |
|
2020-12-11
| ||
| 19:01 | Fix an assert() broken by recent changes to vacuum. (check-in: dd058da8 user: dan tags: trunk) | |
| 16:03 | Add an "#ifndef SQLITE_AMALGAMATION" block around the typedef for u64 in shathree.c. (check-in: b411f29e user: dan tags: trunk) | |
| 14:22 | Fix the expert extension so that it handles generated columns correctly. (check-in: c2ae7ba6 user: dan tags: trunk) | |
|
2020-12-10
| ||
| 19:54 | Remove a redundant branch added by [56a54258560]. (check-in: b4d6f6d7 user: dan tags: trunk) | |
| 19:51 | Changes to avoid loading large records into memory within VACUUM. (check-in: 56a54258 user: dan tags: trunk) | |
| 19:20 | Fix minor issues with new code on this branch. (Closed-Leaf check-in: f7fa76d0 user: dan tags: vacuum-lomem) | |
| 18:07 | Merge trunk changes into this branch. (check-in: 7337eed6 user: dan tags: vacuum-lomem) | |
| 18:06 | Better integrate the changes on this branch with OP_Insert and OP_IdxInsert. (check-in: 101cef14 user: dan tags: vacuum-lomem) | |
|
2020-12-09
| ||
| 20:33 | Transfer large index or WITHOUT ROWID records between b-trees when vacuuming without loading them into memory. (check-in: dfd4ca68 user: dan tags: vacuum-lomem) | |
| 16:49 | Add tests for a 'delete' command on a contentless table where values that weren't actually inserted are NULL. (check-in: 818c647c user: dan tags: trunk) | |
| 16:32 | Avoid loading large intkey rows when VACUUMing, even if the page-size is changing. (check-in: 0d2c3776 user: dan tags: vacuum-lomem) | |
|
2020-12-08
| ||
| 20:19 | Experimental changes to vacuum to avoid loading large records entirely into memory. Currently only works in limited cases only - for rowid tables when the page-size does not change. (check-in: c90e063c user: dan tags: vacuum-lomem) | |
|
2020-12-04
| ||
| 18:47 | Update this branch with latest trunk changes. (check-in: 846e8444 user: dan tags: reuse-schema) | |
| 16:49 | Ensure that fts5 function matchinfo() is registered before running tests that use it in fts5corrupt3.test. (check-in: 932e05e0 user: dan tags: trunk) | |
| 16:26 | Fix a test script problem in walvfs.test. (check-in: 4c5076fb user: dan tags: trunk) | |
|
2020-12-03
| ||
| 21:22 | When merging prefix lists in fts5, use 16-way merges instead of 2-way merges. This faster. (check-in: 026a9350 user: dan tags: trunk) | |
|
2020-12-02
| ||
| 19:08 | Allow a search for an N character prefix in fts5 to use a prefix index of size N+1, if no prefix index of size N exists. (check-in: 78a7801d user: dan tags: trunk) | |
| 16:23 | Improve performance for fts5 column filters that filter for more than one column. e.g. "{col1 col2 col3}:phrase". (check-in: d8de2f23 user: dan tags: trunk) | |