Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around 40fa792d35.
|
2022-03-02
| ||
| 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) | |
| 18:58 | Version 3.38.0 (check-in: 40fa792d35 user: drh tags: trunk, release, major-release, version-3.38.0) | |
| 15:47 | Fix an undersized memory allocation in the test harness for RTREE. This error was in test logic only, not in the SQLite library itself. forum post 35470a0a72a005e1 (check-in: 7e3c959439 user: drh tags: trunk) | |
|
2022-02-21
| ||
| 16:49 | Merge the latest trunk changes into the reuse-schema branch. (check-in: b3c26f4a34 user: drh tags: reuse-schema) | |
| 14:30 | Fix compiler warnings for older compilers (ex: gcc 4.0.1 powerpc-apple-darwin). (check-in: 5c188243d7 user: drh tags: trunk) | |
| 13:44 | Remove stray tab characters from auxiliary source code files. (check-in: e25e33582b user: drh tags: trunk) | |
| 13:02 | Add SQLITE_OMIT_JSON to the compile-time option test sequence. (check-in: f36325a6e2 user: drh tags: trunk) | |
| 00:23 | Do not allow error messages from sqlite3NestedParse() to leak up into the main parse. (check-in: 9c4e21abdc user: drh tags: trunk) | |
|
2022-02-19
| ||
| 21:25 | Improve .backup and .save help text (check-in: 741651fd4b user: larrybr tags: trunk) | |
| 15:57 | Add a NEVER() to a branch that is unreachable for STAT4. (check-in: e4e97505af user: drh tags: trunk) | |
|
2022-02-17
| ||
| 17:24 | Enhance the documentation on sqlite3_stmt_readonly() to explain that EXPLAIN and EXPLAIN QUERY PLAN do not affect the return value. Add test cases to verify this. Add new test cases and requirements marks for complete requirements test coverage on this interface. (check-in: a6fbb7ba05 user: drh tags: trunk) | |
| 14:33 | Remove references to the now-defunct SQLITE_ENABLE_JSON1 compile-time option. (check-in: db950192c9 user: drh tags: trunk) | |
| 14:29 | Fix a testing error on Windows that was recently added to shell5.test. (check-in: 6cace54320 user: drh tags: trunk) | |
|
2022-02-16
| ||
| 15:11 | Make the sqlite3_error_offset() interface accessible from TCL using the new "erroroffset" method on the sqlite3 object. (check-in: 3454a1222b user: drh tags: trunk) | |
|
2022-02-15
| ||
| 20:56 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: b9ba43fcb3 user: drh tags: reuse-schema) | |
| 20:47 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 1336d2f23f user: drh tags: begin-concurrent-pnu-wal2) | |
| 20:37 | Merge recent trunk enhancements into the wal2 branch. (check-in: 7dba818893 user: drh tags: wal2) | |
| 20:24 | Merge recent trunk enhancements into the begin-concurrent-report branch. (check-in: 213df7a063 user: drh tags: begin-concurrent-report) | |
| 20:18 | Merge the latest trunk changes into the begin-concurrent branch. (check-in: 94838f16ba user: drh tags: begin-concurrent) | |
| 17:04 | Sync with trunk (check-in: 2b4a295c58 user: larrybr tags: shell-tweaks) | |
| 13:23 | Improved rendering of floating point numbers without a fractional part in ".dump" output from the CLI. Forum post 550d877659f37cb2. (check-in: 9edaeed56f user: drh tags: trunk) | |
| 11:46 | New assert() statements to help prove correctness of memjournal.c. (check-in: d74ec88c2f user: drh tags: trunk) | |
|
2022-02-14
| ||
| 21:11 | Generalize the in-memory journal so that it is able to accept writes that begin at any offset less than or equal to the current file size. (check-in: c039d5476e user: drh tags: trunk) | |
| 18:55 | CLI .import can auto-rename non-unique column names when it creates a new table (check-in: 4b5d07ea7e user: larrybr tags: trunk) | |
| 18:18 | Minor correction to the early corruption detection added by [a6fda39e81d0da98|check-in a6fda39e81d0da98] so that it works even if the page being cleared in page 1 of the database. (check-in: a5ec16907e user: drh tags: trunk) | |
| 13:53 | Fix a bad assert() (it needs an "||CORRUPT_DB" term) in b-tree, discovered by dbsqlfuzz. (check-in: f5f263cc62 user: drh tags: trunk) | |
| 01:12 | CLI's .import column rename made more minimal, and reports renames. (Leaf check-in: c626cff7f9 user: larrybr tags: auto-column) | |
|
2022-02-13
| ||
| 22:18 | Sync w/trunk, fix zAutoColumns placement blunder, all to pass all TCL tests (check-in: 67dc59f46d user: larrybr tags: auto-column) | |
|
2022-02-12
| ||
| 18:56 | Do not run merge1.test with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: bf8dbfd499 user: dan tags: trunk) | |
| 16:02 | Fix a possible user-after-free in ALTER TABLE found by asan. (check-in: 9252619d41 user: dan tags: trunk) | |
| 13:45 | Update fuzz.test to account for a change in error message made in the core. (check-in: c57601b51f user: dan tags: trunk) | |
| 13:37 | Avoid dropping SQLITE_TOOBIG errors in the quote() function. (check-in: 115c3051a1 user: dan tags: trunk) | |
| 13:12 | For .import auto-column, aid build-time override of rename decoration. (check-in: 433e5ead2b user: larrybr tags: auto-column) | |
| 10:48 | Fix auto-column bug noted by post https://sqlite.org/forum/forumpost/d102c15d63 (check-in: 689137e1b5 user: larrybr tags: auto-column) | |
| 02:15 | Sync w/trunk, allow build-time override of auto-column decorating character (check-in: caaef4c592 user: larrybr tags: auto-column) | |
|
2022-02-11
| ||
| 21:20 | Fix a test in without_rowid1.test so that it is disabled without ALTER TABLE support, as it uses ALTER TABLE. (check-in: ca22a64e6f user: drh tags: trunk) | |
| 19:41 | Update some OOM tests of the ALTER TABLE command to account for an error message which may be returned if opening the temp db fails. (check-in: 3409fd4150 user: dan tags: trunk) | |
| 17:47 | Load recent dbsqlfuzz finds into test/fuzzdata8.db. (check-in: b275ad250d user: drh tags: trunk) | |
| 17:47 | Reference the wayback machine for the dead hyperlink to the MS support page in the comments about why the extra typedef for va_arg(). No code changes. (check-in: ab1a9b5b78 user: drh tags: trunk) | |
| 17:33 | Fix an assert() in the pager by adding "|| CORRUPT_DB", in as much as the assert() is not necessarily true if the database size in the header is wrong. dbsqlfuzz f2f996065b90988aa9b0ae425b66dbb296546a08. (check-in: a51402e8c2 user: drh tags: trunk) | |
| 16:10 | Fix a problem in [c006515ae6faff65] causing an assert() to fail with some build configurations. (check-in: d7ff262d6d user: dan tags: trunk) | |
| 14:08 | Use the enhanced SQLITE_TESTCTRL_LOCALTIME_FAULT (2) capability to do better testing of the 'localtime' and 'utc' modifiers to date/time functions. (check-in: f38071946a user: drh tags: trunk) | |
| 13:40 | Upon .import column renaming, issue message saying so. Test this. (check-in: 8b6ca9304b user: larrybr tags: auto-column) | |
| 12:06 | Fix the bind2.test test script so that it works even if SQLITE_ENABLE_PREUPDATE_HOOK is not defined. Fix for test-case breakage from check-in [c006515ae6faff65]. (check-in: 937d3a45b3 user: drh tags: trunk) | |
| 11:37 | Work around the MSVC bug that prevents the use of function pointer types in the second argument of va_arg() by adding a typedef. (check-in: eae3ab0a05 user: drh tags: trunk) | |
| 01:21 | CLI auto-column rename revamped after forum discussion. (check-in: 2da1f8e45e user: larrybr tags: auto-column) | |
|
2022-02-10
| ||
| 23:12 | Fix SQLITE_TESTCTRL_LOCALTIME_FAULT so that it works even if mutexes are enabled. (check-in: 64537a0669 user: drh tags: trunk) | |
| 21:26 | Enhance SQLITE_TESTCTRL_LOCALTIME_FAULT so that is able to install an alternative localtime() interface so that the localtime logic an be better tested. (check-in: 6e25cb0890 user: drh tags: trunk) | |
| 15:40 | Performance improve to the 'localtime' and 'utc' modifiers for date/time functions. (check-in: 85cb601475 user: drh tags: trunk) | |
| 12:57 | Faster implementation of the date(), time(), and datetime() functions. (check-in: fa1b393bdb user: drh tags: trunk) | |
| 12:31 | Fix the test harness so that it builds without SQLITE_ENABLE_PREUPDATE_HOOK. Has been broken since [c006515ae6faff65]. (check-in: 4565f71129 user: drh tags: trunk) | |
| 03:21 | A CLI feature. auto .import (new table) columns. WIP (check-in: 7e3be36dfc user: larrybr tags: auto-column) | |