Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around ad3ffa1a75a5a032.
|
2022-03-10
| ||
| 11:10 | Improve formatting of changes doc for this branch (Leaf check-in: 2129cfb8c5 user: larrybr tags: shell-tweaks) | |
| 02:23 | Mention that sqlite3_column_text16() returns have native endianness (check-in: 25b7f88fcb user: larrybr tags: trunk) | |
| 01:15 | Check-in [642a0b4752743216] fixing sqlite_dbpage is not exactly correct. This patch should fix it. (check-in: b6c4c8a09a user: drh tags: branch-3.38) | |
| 01:10 | Check-in [642a0b4752743216] fixing sqlite_dbpage is not exactly correct. This patch should fix it. (check-in: 6ba36714ca user: drh tags: trunk) | |
|
2022-03-09
| ||
| 22:16 | Sync w/Trunk, finish doc/sh_tweak_changes.md (check-in: 5a1797c225 user: larrybr tags: shell-tweaks) | |
| 18:30 | Further refinements to the sqlite_offset() fix from [6029514b08b88e3f]. (check-in: 98799d7bbb user: drh tags: branch-3.38) | |
| 18:29 | Further refinements to the sqlite_offset() fix from [6029514b08b88e3f]. (check-in: 6f838305e2 user: drh tags: trunk) | |
| 14:29 | Fix the sqlite_dbpage virtual table so that it starts a write transaction on all attached schemas. (check-in: e92c4fdb99 user: drh tags: branch-3.38) | |
| 14:22 | Fix the sqlite_dbpage virtual table so that it starts a write transaction on all attached schemas. (check-in: 642a0b4752 user: drh tags: trunk) | |
| 13:22 | Do not use va_arg() as an l-value, because AIX does not allow that, from what we are told. (check-in: 46d1a6de62 user: drh tags: trunk) | |
| 12:20 | Improve the defenses against bad pathnames input into the findCreateFileMode() function of os_unix.c in order to quiet static-analyzer warnings. There are no demonstrated problems in the prior code, but this change makes the code easier to prove correct and more robust against future changes. (check-in: a9cda38997 user: drh tags: trunk) | |
|
2022-03-08
| ||
| 16:44 | (WIP) Add DB-dispatch for dot commands upon shell extension load. (check-in: 19f2a747b8 user: larrybr tags: cli_extension) | |
| 16:12 | Fix a potentially uninitialized local variable in the ".import" command of the CLI - introduced by [741651fd4b1b776b]. This same change is part of the nearby "Fix compiler warnings" check-in. (check-in: ce9e3d903c user: drh tags: branch-3.38) | |
| 15:49 | Fix a minor typo in a comment. (check-in: cf61419f88 user: drh tags: trunk) | |
| 13:59 | Fix compiler warnings. (check-in: 5e30c6ea70 user: drh tags: trunk) | |
| 03:10 | Add a .md summarizing CLI changes on this branch and their motivation or purpose. (check-in: 5ddccc2f28 user: larrybr tags: shell-tweaks) | |
| 01:02 | CLI regularization and code cleanup (check-in: 16af0e4560 user: larrybr tags: cli_extension) | |
|
2022-03-07
| ||
| 19:00 | Sync with trunk (check-in: 1194093a58 user: larrybr tags: cli_extension) | |
| 18:42 | Add multi-threaded test for the features on this branch. Fix a misuse of xShmLock(). (check-in: 1ec05168c9 user: dan tags: begin-concurrent-pnu-wal2) | |
| 18:38 | Disable an assert in moveToRoot() when the database is corrupt. Forum post e9a176b7bd. (check-in: ab744a5da8 user: drh tags: branch-3.38) | |
| 18:32 | Disable an assert in moveToRoot() when the database is corrupt. Forum post e9a176b7bd. (check-in: ae464a18d7 user: drh tags: trunk) | |
| 17:19 | In the stay-on-last-page optimization for sqlite3BtreeIndexMoveto() (check-in [0057bbb508e7662b] about 16 hours ago), be sure to clear the BTCF_ValidOvfl flag, since the overflow cache is invalidated by the search on the last page. OSSFuzz issue 45329. (check-in: 0021bebc16 user: drh tags: trunk) | |
| 16:40 | Do not allocate new Trigger objects in the parser following a syntax error, to avoid violating invariants associated with Expr nodes. See forum thread 2024e94071ef1531 for more information. (check-in: 369d240455 user: drh tags: branch-3.38) | |
| 16:22 | Do not allocate new Trigger objects in the parser following a syntax error, to avoid violating invariants associated with Expr nodes. See forum thread 2024e94071ef1531 for more information. (check-in: 5e0ed49b3d user: drh tags: trunk) | |
| 14:59 | Fix the code generated for vector IN operator constraints on virtual tables so that they work even if the "omit" field in the sqlite3_index_info object is off. This has apparently never worked correctly before. Presumably, nobody has ever before written a virtual table that can use vector IN operator constraints and that relies on bytecode to double-check the constraints. Test cases in TH3. Problem discovered by dbsqlfuzz cab8e26194a40147627094f3c6849c0a7b1e0310. (check-in: 4a2040d5c7 user: drh tags: branch-3.38) | |
| 14:51 | Fix the code generated for vector IN operator constraints on virtual tables so that they work even if the "omit" field in the sqlite3_index_info object is off. This has apparently never worked correctly before. Presumably, nobody has ever before written a virtual table that can use vector IN operator constraints and that relies on bytecode to double-check the constraints. Test cases in TH3. Problem discovered by dbsqlfuzz cab8e26194a40147627094f3c6849c0a7b1e0310. (check-in: 21b656572d user: drh tags: trunk) | |
| 01:29 | Optimizations to sqlite3BtreeIndexMoveto() avoid unnecessary comparisons if the cursor is already near the end of the table and is not moving far. This case is more common that you would expect. The optimization saves almost 4 million CPU cycles. (check-in: 0057bbb508 user: drh tags: trunk) | |
| 01:28 | Fix the .import problem in the CLI reported by forum post 72a024c957. (check-in: d753285bcb user: drh tags: branch-3.38) | |
| 00:14 | Disentangle variable use in last checkin (check-in: 4c3a02600f user: larrybr tags: trunk) | |
|
2022-03-06
| ||
| 23:41 | For CLI .import, revert to importing into temp or main when given table is found there and no -schema option used. And plug an obscure leak. (check-in: bf9d127884 user: larrybr tags: trunk) | |
| 20:22 | Fix obsolete but harmless comments in btree. No changes to code. (check-in: 4838b888e4 user: drh tags: trunk) | |
| 17:53 | (WIP) Shell meta-command objectification done, ready for dbShell to be loaded and used for extension meta-commands (check-in: a88983ecb7 user: larrybr tags: cli_extension) | |
| 11:44 | The sqlite_offset() function should be non-deterministic. dbsqlfuzz 3df8230bb940870db87ffca2c0fc759c1e7fa356. (check-in: 8083757606 user: drh tags: branch-3.38) | |
| 11:43 | The sqlite_offset() function should be non-deterministic. dbsqlfuzz 3df8230bb940870db87ffca2c0fc759c1e7fa356. (check-in: e1a185e60a user: drh tags: trunk) | |
| 03:22 | (WIP) shell extension load and ShellState internal/external partitioning in place, passing shell tests with trivial exceptions (check-in: a85679d3e9 user: larrybr tags: cli_extension) | |
| 00:01 | Remove a NEVER() associated with sqlite_offset()> (check-in: bf2501e26c user: drh tags: branch-3.38) | |
|
2022-03-05
| ||
| 23:52 | Remove a NEVER() associated with sqlite_offset()> (check-in: e29dffcdba user: drh tags: trunk) | |
| 20:20 | Fix the 'localtime' modifier in date/time functions so that it preserves fractional seconds. Forum post 2ffbaa2c3fd7fb82. (check-in: 6833f4aeef user: drh tags: branch-3.38) | |
| 20:12 | Fix the 'localtime' modifier in date/time functions so that it preserves fractional seconds. Forum post 2ffbaa2c3fd7fb82. (check-in: 1c875b0764 user: drh tags: trunk) | |
| 19:46 | Increase the version number to 3.38.1. (check-in: cd87e77dd0 user: drh tags: branch-3.38) | |
| 19:39 | Cherry-pick all bug fix changes since the 3.38.0 release. (check-in: 45a5d5acf7 user: drh tags: branch-3.38) | |
| 19:36 | Further improvements to the sqlite_offset() function. (check-in: 4230e2f5e0 user: drh tags: trunk) | |
| 14:44 | Fix the sqlite_offset() function so that it gives the correct answer even if the argument is a virtual column in an index-only query. Test cases in TH3. (check-in: 6029514b08 user: drh tags: trunk) | |
| 11:57 | Update obsolete text in the ICU README.txt file talking about SQLite's robustness (or lack thereof) in the face of corrupt database files. (check-in: dc88fc62f0 user: drh tags: trunk) | |
|
2022-03-04
| ||
| 20:54 | Do try to evaluate the Bloom filter on a LEFT JOIN early, as doing so essentially converts it into an INNER JOIN. See forum thread 544af7eee2. (check-in: d46d0e67c9 user: drh tags: trunk) | |
| 16:28 | When setting an sqlite3_value object to a pointer value, make sure any prior memory allocations associated with that object have been cleared first. dbsqlfuzz 33f842d1a09afaad5f078c3e1162a54b78e5f2ab. (check-in: 31e1bde4b2 user: drh tags: trunk) | |
|
2022-03-03
| ||
| 19:40 | Restore the ability to push-down OR subterms of the WHERE clause when processing a multi-index OR. (check-in: d71fb6fdc3 user: drh tags: trunk) | |
| 16:48 | Make sure the xParseCell and xCellSize methods of the MemPage object are initialized consistently even if the page is detected as being corrupt. dbsqlfuzz fd21f341f3b4f582401d2feb2a1c0c4cc2c26caa. (check-in: 725a06434b user: drh tags: trunk) | |
| 15:59 | Fix for the problem identified in forum post 0cd8e058bf: When evaluating an multi-index OR, do not push down auxiliary WHERE clause terms that involve subqueries into the OR-subqueries. Otherwise, the covering-index optimizer might convert table-references into index-references for the particular OR index that is active for the branch in which the subquery subroutine is coded, and those index-references will not work if the subquery subroutine is invoked from a different OR branch that uses a different index. (check-in: 61a1c6dbd0 user: drh tags: trunk) | |
| 15:00 | Add the new OP_BeginSubrtn opcode (which is really an alias for OP_Integer) and make other changes so that the span of a subroutine that implements a subquery is more readily apparent in bytecode listings. (check-in: b822674870 user: drh tags: trunk) | |
|
2022-03-02
| ||
| 21:04 | Bloom filter pull-down optimization is incompatible with Skip-Scan. Make sure the query planner does not try to to both. Forum post 50a1bbe08ce4c29c. (check-in: ad3ffa1a75 user: drh tags: trunk) | |
| 17:50 | Faster version of sqlite3VdbeMemRelease(). (check-in: 86c5fa2f30 user: drh tags: trunk) | |
| 13:45 | Reinstate the releaseMemArray() performance optimization of [bb520293d8c11518] with corrections. (check-in: 1291080d11 user: drh tags: trunk) | |
| 11:39 | The optimization at [ece326db50201937] is not quite right, so back it out for now. (check-in: b218a4b9fe user: drh tags: trunk) | |
| 01:02 | Fix a harmless compiler warning. (check-in: 6497997aa8 user: drh tags: trunk) | |
| 00:50 | The performance optimizations at [bb520293d8c11518] is not quite right, so it has to be backed out. (check-in: 15f73b121c user: drh tags: trunk) | |
|
2022-03-01
| ||
| 20:15 | The MemPage.aDataEnd field should point to the end of the data buffer for the page, not just the end of the usable portion of that buffer. The purpose aDataEnd is to detect cells that overflow the page, and that won't work on a page with reserved bytes and a cell that starts in the reserved region, unless the boundary is at the very end of the page. Chromium issue 1276294. (check-in: f839c0bc83 user: drh tags: trunk) | |
| 19:19 | Fix a minor typo in a comment. (check-in: 86ba06aa4c user: drh tags: trunk) | |
| 16:22 | Fix two assert() statements in btree.c which were not true in the case of a corrupt database file. Forum post 14819f2063. (check-in: 3b36ed79d8 user: drh tags: trunk) | |
| 15:48 | Fix slightly-incorrect assert() statements. Forum post f1e83b77b5ff37db (check-in: 3c9f5c9def user: drh tags: trunk) | |
| 14:13 | Increase the max_page_count on ROLLBACK, if necessary, so that it is sufficient to cover the entire database. Fix for the problem identified by forum post 3b9e894312. (check-in: 12c012162c user: drh tags: trunk) | |
|
2022-02-28
| ||
| 16:44 | Fix the Xfer-optimization on the INSERT statement so that it is omitted if there is a RETURNING clause, since that optimization is not able to deal with RETURNING. See forum thread 595e132f71 for details. (check-in: 1d3760a517 user: drh tags: trunk) | |
| 14:26 | Reorganize the bits in Mem.flags. Free up one bit for reuse. (check-in: fe454291d9 user: drh tags: trunk) | |
| 13:38 | Expand the comment on the definition of the Mem object to better explain the meanings of the various flag bits. (check-in: f2f0426035 user: drh tags: trunk) | |
| 12:16 | Performance optimization in initMemArray() saves about 750K cycles with only a 4-byte increase in code size. (check-in: c3e9cd5e74 user: drh tags: trunk) | |
| 12:08 | The performance increase in the previous check-in of this branch was due to the revised loop in initMemArray() and reordering fields of Mem - not the call the memcpy(). Changing the code to avoid memcpy() results in an even better gain, and code that is far less dodgy. (Closed-Leaf check-in: d74aa97953 user: drh tags: optimize-init-mem) | |
| 03:25 | An optimization to initMemArray() saves almost 500K cycles. But it seems a little dodgy. I want to think about this more before merging to trunk. Perhaps there is a cleaner way to accomplish the same. (check-in: 7fefd86761 user: drh tags: optimize-init-mem) | |
| 02:35 | Avoid unnecessary deinitialization of the Mem.flags field. (check-in: bb520293d8 user: drh tags: trunk) | |
|
2022-02-27
| ||
| 21:10 | Cache values of UnpackedRecord.aMem[0] into new fields of UnpackedRecord. This avoids extra indirections and saves about 750K cycles. (check-in: 7cf2d1f039 user: drh tags: trunk) | |
| 18:54 | Bypass a single branch in vdbeRecordCompareString() in the common case, for a performance increase of over 600K CPU cycles. (check-in: 36f0f07e50 user: drh tags: trunk) | |
|
2022-02-26
| ||
| 23:01 | Remove an unnecessary local variable for a small performance increase and size reduction. (check-in: 9bda611f0d user: drh tags: trunk) | |
| 14:39 | Allow the OP_Column opcode to read rows that are larger than SQLITE_LIMIT_LENGTH as long as the specific field being read out is less than or equal to SQLITE_LIMIT_LENGTH. (check-in: 1bf4848995 user: drh tags: trunk) | |
|
2022-02-25
| ||
| 20:11 | Revise the initialization processing for OP_Column to make it about 1.8 million cycles faster. (check-in: 3b7259ebd5 user: drh tags: trunk) | |
| 18:51 | Fix the OP_NullRow documentation so that it accurately describes what it actually does for a pseudo-cursor. (check-in: 4e26990209 user: drh tags: trunk) | |
| 18:15 | Dead branch: Superseded by [3b7259ebd5b9b1f7] (Closed-Leaf check-in: 09a47f32a4 user: drh tags: simplify-cursor-state) | |
| 16:21 | Do not do a deferred seek on a cursor that is marked nullRow. (check-in: 1c026bcb3c user: drh tags: simplify-cursor-state) | |
| 15:44 | This branch proposes to consolidate various state fields of VdbeCursor (specifically, nullRow, deferredMoveto, and cacheStatus) into a single eCurState field. This first check-in adds the new eCurState field while retaining and continuing to use the legacy state fields. (check-in: 7953716c12 user: drh tags: simplify-cursor-state) | |
| 13:29 | Improved comment on the codeDeferredSeek() routine. No code changes. (check-in: 54f49f65ac user: drh tags: trunk) | |
| 11:30 | Fix unimportant typos in comment text. (check-in: 3934601329 user: drh tags: trunk) | |
| 01:23 | Invoking SQLITE_TESTCTRL_INTERNAL_FUNCTIONS causes the flags field of the PRAGMA function_list to show all bits, including internal-use-only bits, rather than just the bits that are part of the API. (check-in: ad1be34828 user: drh tags: trunk) | |
| 01:10 | Remove unused P4 types on the Opcode object. Saves a few bytes of code space and simplifies the code. (check-in: aca5384359 user: drh tags: trunk) | |
| 00:09 | Merge shell-tweaks enhancements (with 3.38) (check-in: 4c7d94d3f3 user: larrybr tags: cli_extension) | |
|
2022-02-24
| ||
| 14:44 | Change the OP_Next and OP_Prev opcodes so that they invoke sqlite3BtreeNext() and sqlite3BtreePrevious() directly rather than through a function pointer, for improved performance and a decrease in code size. (check-in: 9d13cbbef3 user: drh tags: trunk) | |
| 11:09 | Spell fix, no code change (check-in: f2597fae3c user: larrybr tags: trunk) | |
| 04:29 | Regularize CLI .mode processing (check-in: 6d0557244f user: larrybr tags: cli_extension) | |
| 01:41 | Fix an assert() so that it is still valid following OOM with the latest enhancements. (check-in: ecf832f71f user: drh tags: trunk) | |
| 01:08 | Update the version number of version 3.39.0 for the next development cycle. (check-in: 9542e9bebb user: drh tags: trunk) | |
|
2022-02-23
| ||
| 22:56 | Add a new subclass for MemPage.xCellSize specifically for the case of a leaf page in a B+Tree, that is optimized for that cases. This gains a half million cycles or more at the cost of less than 200 bytes of code space. (check-in: 7ad829224a user: drh tags: trunk) | |
| 18:23 | Optimize calls to get2byte() in btree.c for almost a one-million cycle performance gain and a few bytes less code. (check-in: 41061f2996 user: drh tags: trunk) | |
| 17:16 | Defer the check for error check Pgno zero until after the page fetch misses, to gain a few CPU cycles and a small size reduction. (check-in: ece326db50 user: drh tags: trunk) | |
| 17:00 | Store the page number for the PENDING_BYTE page in the Pager object, rather than computing the page number every time it is needed, because it turns out that number is needed quite frequently. This saves a few hundred thousand CPU cycles and a few bytes of code space. (check-in: 5aa9c3eb45 user: drh tags: trunk) | |
| 10:10 | Sync with 3.38 (check-in: b9b27d74b9 user: larrybr tags: cli_extension) | |
|
2022-02-22
| ||
| 22:28 | Sync w/3.38, add .parameter ls to CLI (check-in: 8c9a5fb26b user: larrybr tags: shell-tweaks) | |
| 20:38 | Don't reload the schema on PRAGMA database_list. (check-in: 630fe446da user: drh tags: reuse-schema) | |
| 20:29 | For the "PRAGMA database_list" statement, do not check to see if the schema is up-to-date and do not try to reload the schema. (check-in: 710de6a213 user: drh tags: trunk) | |
| 20:04 | Merge version 3.38.0 into the reuse-schema branch. (check-in: 8fe85dcdb1 user: drh tags: reuse-schema) | |
| 19:56 | Merge version 3.38.0 into the begin-concurrent-pnu-wal2 branch. (check-in: 8387e4f3af user: drh tags: begin-concurrent-pnu-wal2) | |
| 19:46 | Merge version 3.38.0 into the wal2 branch. (check-in: de24c8ee41 user: drh tags: wal2) | |
| 19:37 | Merge version 3.38.0 into the begin-concurrent-report branch. (check-in: 0bbf7be25d user: drh tags: begin-concurrent-report) | |
| 19:30 | Merge version 3.38.0 into the begin-concurrent branch. (check-in: c5998c43c1 user: drh tags: begin-concurrent) | |