SQLite
Timeline
Not logged in

200 most recent check-ins using file tool/lempar.c version 10579a61

2017-09-30
11:47
[92848623] Closed-Leaf: More details in the header comment of pushDownWhereTerms(). No changes to code. (user: drh, tags: prefer-coroutine-sort-subquery)
10:50
[6aed4ea3] Make sure the SQLITE_Stat34 optimization switch is always 0x800, a value which is hard-coded in the TH3 test suite. (user: drh, tags: prefer-coroutine-sort-subquery)
01:25
[71f0adf7] Fix unreachable conditionals and revise a testcase that was made obsolete by the changes on this branch. (user: drh, tags: prefer-coroutine-sort-subquery)
2017-09-29
22:13
[6b1651d7] Always render a subquery that is not part of a join as a co-routine. (user: drh, tags: prefer-coroutine-sort-subquery)
16:08
[f62cd4d9] Merge the query flattener comment improvements from trunk. (user: drh, tags: prefer-coroutine-sort-subquery)
16:07
[0840f9f8] Clean up the comments on the query flattener to more clearly and accurately express the conditions under which the flattener is able to run. (user: drh, tags: trunk)
14:31
[06f432fb] Merge changes from trunk. (user: drh, tags: prefer-coroutine-sort-subquery)
12:44
[2a45bbc9] Make sure the 6th parameter to the authorizer callback for view subqueries has the correct view name. (user: drh, tags: trunk)
12:12
[04ef40a8] Better names for subqueries in EXPLAIN comments. (user: drh, tags: trunk)
2017-09-28
20:06
[042d655d] Do not flatten subqueries that contain an ORDER BY or GROUP BY clause and can be implemented using a co-routine. (user: drh, tags: prefer-coroutine-sort-subquery)
17:29
[ff2f5a31] Remove the (undocumented) query-planner control that prevents a "SELECT ALL" subquery in FROM clause from being implemented as a co-routine. This control was added by [a29e117d7ec], where it was called a "stop-gap". (user: drh, tags: trunk)
16:56
[fd3267ef] Fix over-length source code lines in select.c. No logic changes. (user: drh, tags: trunk)
13:47
[5b9ae693] Fix an issue introduced by check-in [4cd2a9672c59] (2017-03-03) that could allow a negative value in the 3rd parameter to memmove() when defragmentPage() is called on a btree page with a corrupted freeblock list. The corruption is now detected early and results in an SQLITE_CORRUPT return before the memmove() is reached. (user: drh, tags: trunk)
01:58
[490e488e] Add new routines to simplify dealing with collating sequences in expressions: sqlite3ExprNNCollSeq() and sqlite3ExprCollSeqMatch(). (user: drh, tags: trunk)
01:09
[04130018] Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. (user: drh, tags: trunk)
00:01
[80277d2f] In two places, change the magic number -1 to its proper symbol XN_ROWID. (user: drh, tags: trunk)
2017-09-27
16:51
[f5ef2e1b] Disable tests for the LIKE optimization when ICU is enabled, since the LIKE optimization only works for the built-in LIKE operator and ICU overrides the built-in. (user: drh, tags: trunk)
2017-09-25
09:37
[24a95e14] Add an extra snapshot related test case. (user: dan, tags: trunk)
2017-09-23
07:46
[d71eeaab] Leaf: Experimental change so that snapshot transactions always lock the wal file - preventing writers or truncate-checkpointers from wrapping it. (user: dan, tags: snapshots-lock-wal)
2017-09-22
20:18
[8d2a1cca] Leaf: Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. (user: drh, tags: est_count_pragma)
16:23
[2c03d8b8] Use the updated Win32 VFS semantics for winOpen from check-in [5d03c738e9] for WinRT, et al, as well. (user: mistachkin, tags: trunk)
12:52
[403b88a8] Partial backout of check-in [e0af9a904076]. It turns out we do need some extra space at the end of the record blob as an overrun area to use when decoding a maliciously malformed record. (user: drh, tags: trunk)
11:09
[c7a5880d] Leaf: Cherrypick [ec37ad6d08] into this branch. With this patch, if SQLITE_SHARED_MAPPING is defined at build-time SQLite will use a single memory mapping for multiple connections to the same database file within a single process. (user: dan, tags: begin-concurrent)
10:49
[307b802e] Merge latest trunk changes into this branch. (user: dan, tags: begin-concurrent)
00:24
[0a12915b] Update the configure script so that it looks for tclsh8.7 ahead of tclsh8.6. (user: drh, tags: trunk)
2017-09-21
20:43
[5d03c738] In the Windows VFS, when trying to open a database file read/write, if it fails check to see if the file exists and is read-only and immediately fall back to a read-only open attempt, rather than running the AV retry loop. (user: drh, tags: trunk)
20:03
[fa3f5bcc] In the Windows VFS, do not emit an SQLITE_CANTOPEN error log message when falling back from SQLITE_OPEN_READWRITE to SQLITE_OPEN_READONLY. Wait until the open fails completely. (user: drh, tags: trunk)
19:08
[68e9a840] Fix harmless UB in the ICU extension. (user: drh, tags: trunk)
14:03
[3fbfa9a8] Leaf: The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. (user: drh, tags: sqlite3_snapshot_describe)
13:11
[fd4ec0cd] Fix a potential use of an uninitialized pointer in RTree following an OOM error. (user: drh, tags: trunk)
10:24
[65765222] Fix a bug in tool/mksourceid.c: The mksourceid.c program was incorrectly including the "# Remove this line" line of the Fossil-generated "manifest" file in the SHA3 hash. That means that all SQLITE_SOURCE_IDs for trunk versions going back to check-in [30966d56] (2017-08-22) are incorrect. (user: drh, tags: trunk)
01:04
[f8b1c64d] Revert one performance improvement changes from check-in [3b3e32d4cd07] as it was causing a reference to an uninitialized value. (user: drh, tags: trunk)
00:49
[adc12c83] Fix the rendering of the P4_INTARRAY argument to the OP_IntegrityCk opcode in the output of EXPLAIN. (user: drh, tags: trunk)
2017-09-20
18:47
[4b3f7eac] Size and performance optimization on sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
18:07
[e0af9a90] The BLOB returned by sqlite3VdbeMemFromBtree() does not need to be zero-terminated. (user: drh, tags: trunk)
17:49
[3b3e32d4] Small size and performance optimization in the bytecode engine. (user: drh, tags: trunk)
10:47
[7f2bd4ff] Improved resolution of large integer values in "CAST(x AS NUMERIC)". (user: drh, tags: trunk)
09:09
[5b2002f3] Updates to the "lemon.html" document received from Andy Goth. (user: drh, tags: trunk)
2017-09-18
18:17
[1b2de414] Add the sqlite3_mmap_warm() function as an extension in the ext/misc/mmapwarm.c source file. (user: drh, tags: trunk)
18:08
[3235835b] Closed-Leaf: Fix a typo in the MSVC makefile. (user: drh, tags: mmap-warm)
16:28
[d4a30b91] Add extension "mmapwarm.c". Provides function sqlite3_mmap_warm(), used to "warm up" the memory mapping used by SQLite in mmap mode to access db file content. (user: dan, tags: mmap-warm)
13:16
[a9447193] Minor simplification of error message generation during compound query code generation. (user: drh, tags: trunk)
09:40
[74f399d8] The out-of-bounds read on recovery fix of check-in [378afa16381a222a] caused problems for some corner-case error conditions. This alternative fix appears to work better. (user: drh, tags: trunk)
08:51
[2e573350] Leaf: Merge latest trunk changes with this branch. (user: dan, tags: shared-mapping-hack)
00:18
[42f07775] Fix the CSV virtual table extension so that it works when the default character is unsigned. (user: drh, tags: trunk)
2017-09-17
19:45
[29227d00] Do not make the assumption (as check-in [4da49a95c0f07] incorrectly did) that the ExprList returned by sqlite3ExprListDup() would never be passed into sqlite3ExprListAppend(). Include a new test case that shows this sometimes does happen. (user: drh, tags: trunk)
2017-09-16
20:58
[5dbb255a] Simplify the sqlite3VdbeGet() routine. Smaller, faster, and easier to maintain. (user: drh, tags: trunk)
2017-09-15
17:40
[dd95887f] Remove an unnecessary parameter from selectInnerLoop(). (user: drh, tags: trunk)
15:38
[5dc3ecb5] Improved the header-comment documentation on sqlite3ExprCodeExprList(). No changes to code. (user: drh, tags: trunk)
15:17
[4da49a95] Optimization to the ExprList object to make it slightly smaller and faster. (user: drh, tags: trunk)
14:36
[f7f0bf1d] Fix a harmless comment typo. No changes to code. (user: drh, tags: trunk)
2017-09-14
21:12
[1a7e0b61] Add another test case for the problem fixed by the previous commit. (user: dan, tags: trunk)
20:41
[cf5bf42c] Avoid an out-of-bounds read that can be caused by a specially constructed journal file. (user: dan, tags: trunk)
02:36
[378afa16] Avoid an out-of-bounds read on a recovery attempt using a carefully crafted database and rollback journal with mismatched page sizes. The test case for this is in TH3. (user: drh, tags: trunk)
2017-09-13
20:20
[43c6023b] Test case update due to PRAGMA integrity_check enhancements in [8525c30c]. No changes to code. (user: drh, tags: trunk)
18:38
[ebada072] Leaf: Experimental sqlite3_stmt_retryable() interface. (user: drh, tags: sqlite3_stmt_retryable)
12:55
[87ccdf9c] Disable FTS3 matchinfo() tests that assume a littleEndian platform when running on bigEndian. (user: drh, tags: trunk)
00:33
[8525c30c] Improvements to PRAGMA integrity_check for better detection of malformed records. Integrity_check now avoids returning SQLITE_CORRUPT on a corrupt record. Also includes microoptimizations that I stumbled over while working on integrity_check. (user: drh, tags: trunk)
00:13
[81f62e99] Closed-Leaf: PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption while scanning indexes. (user: drh, tags: improved-integrity-check)
00:01
[a5a19492] Fix test script comment. No changes to code. (user: mistachkin, tags: trunk)
2017-09-12
23:58
[3a2793aa] Remove use of the rand_s() function (added by [139081bef9f63c3e]) as it appears to cause issues with some third-party DLLs. (user: mistachkin, tags: trunk)
20:09
[afe45271] Leaf: Add the highly-experimental "PRAGMA noop_update=TRUE" command. (user: drh, tags: begin-concurrent-pnu)
18:49
[de2e3717] Leaf: Add the highly-experimental "PRAGMA noop_update=TRUE" command. (user: drh, tags: pragma-noop-update)
18:11
[8b1fc4b9] Merge the mutex-free PRNG change into this branch. (user: dan, tags: shared-mapping-hack)
18:03
[ec37ad6d] Hack to have multiple connections to a single file share a single memory mapping of the databse file. (user: dan, tags: shared-mapping-hack)
15:05
[9780b23c] Fix an error in [b22cdd67] that can cause a negative infinity to be (rarely) reported as a positive infinity. (user: drh, tags: trunk)
13:27
[b22cdd67] Changes to (hopefully) get the build working with recent Intel compilers. (user: drh, tags: trunk)
00:24
[d7b7f038] Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. (user: drh, tags: trunk)
2017-09-11
23:46
[9d91ee5e] New test case for ticket [b899b6042f97f52d]. (user: drh, tags: trunk)
20:54
[3b7dbe9d] Add support for new operators in virtual tables: !=, IS, IS NOT, IS NULL, and NOTNULL. (user: drh, tags: trunk)
19:47
[0fb992af] Closed-Leaf: Refactor names of constants and functions associated with the auxiliary operators for xBestIndex. (user: drh, tags: vtab-extra-ops)
18:37
[d3153abd] Minor adjustments to indentation and spacing for clarity. No changes to code. (user: drh, tags: vtab-extra-ops)
08:53
[8d24e080] Add tests to check that affinities work with != operators on virtual table column values. No changes to code. (user: dan, tags: vtab-extra-ops)
2017-09-10
01:06
[99b9140c] Simplifications to the PRAGMA integrity_check code generator. (user: drh, tags: improved-integrity-check)
2017-09-09
22:46
[b6425d01] Simplification and performance improvement to sqlite3_reset(). (user: drh, tags: improved-integrity-check)
20:38
[8fa923ca] Improved detection of malformed records by PRAGMA integrity_check. (user: drh, tags: improved-integrity-check)
19:41
[34c8e952] Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL constraints. (user: dan, tags: vtab-extra-ops)
08:03
[e63d1a7c] Leaf: Use a mutex-free PRNG for the random() and randomblob() SQL functions and for the randomness used during checkpoint operations. (user: drh, tags: mutex-free-randomness)
06:10
[6a0b9d9d] Leaf: Merge trunk enhancements (user: drh, tags: apple-osx)
00:51
[faa22e29] Fix harmless compiler warnings seen with MSVC. (user: mistachkin, tags: trunk)
2017-09-08
17:48
[e1e3ca7e] Have the header comment for sqlite3Checkpoint() mention TRUNCATE along with the other three checkpoint types. No changes to code. (user: dan, tags: trunk)
2017-09-07
09:56
[02828d71] Prevent a possible crash when trying to recover using a carefully corrupted \ and truncated rollback journal. (Test case in TH3) (user: drh, tags: trunk)
2017-09-05
20:16
[9e393a0e] Update "PRAGMA integrity_check" to detect inconsistencies between a single record's header and body. (user: dan, tags: trunk)
17:23
[868cd196] Fix a comment describing the xRowid method of the "series" virtual table. No code changes. (user: dan, tags: trunk)
16:24
[7fdd6298] Add experimental API sqlite3rbu_temp_size_limit(). For limiting the amount of temporary disk space RBU uses. (user: dan, tags: trunk)
2017-09-04
19:31
[72d22c22] Use the SQLITE_CORRUPT_BKPT return code in a couple more places. (user: mistachkin, tags: trunk)
18:44
[77854694] Add the 'mksourceid' executable to the clean target for MSVC. (user: mistachkin, tags: trunk)
00:33
[c7f9f47b] Proposed fix for ticket [b899b6042f97f5] (user: drh, tags: trunk)
00:19
[03f3cc03] Fix recent test cases in test/indexepxr2.test so that they work even without SQLITE_ENABLE_STAT4 and SQLITE_ENABLE_JSON1. (user: drh, tags: trunk)
2017-09-01
14:50
[b2e2100c] Add the new sqlite3PagerUnrefPageOne() pager method to deal with the special case of unreferencing page1. (user: drh, tags: trunk)
12:57
[c4e7e175] Remove an obsolete optimization in pcache that due to more recent changes was recently making the code a little slower. (user: drh, tags: trunk)
12:18
[919863b1] Small size and performance improvement in pcacheManageDirtyList() by not zeroing the PgHdr.pDirtyNext and PgHdr.pDirtyPrev pointers for PgHdr objects that are not on the dirty list. (user: drh, tags: trunk)
2017-08-31
21:11
[4094a341] Clarify the documentation about "protected" versus "unprotected" sqlite3_value objects. No changes to code. (user: drh, tags: trunk)
2017-08-30
13:21
[bcc20be5] Remove unnecessary "__declspec(dllexport)" qualifiers from generated file shell.c. (user: dan, tags: trunk)
04:44
[ffd437da] Small performance optimization in pcache1. (user: drh, tags: trunk)
2017-08-29
20:21
[a06263f1] Faster memory allocation from lookaside by not trying to keep track of the number of outstanding allocations, and rather computing that value only when requested. (user: drh, tags: trunk)
17:52
[1b3df8ff] Leaf: Add a Tcl script to run the performance tests described in README-server-edition.html. (user: dan, tags: server-process-edition)
2017-08-28
17:32
[f545db6c] Leaf: Add the --enable-update-limit option to the ./configure script. (user: drh, tags: begin-concurrent-branch-3.19)
17:30
[5cd9ff87] Avoid unnecessary mutexes in the pcache1 implementation in the common case where no auxiliary page cache memory is configured. (user: drh, tags: begin-concurrent-branch-3.19)
17:26
[cc440400] Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. (user: drh, tags: begin-concurrent-branch-3.19)
17:19
[d53108e7] Merge recent enhancements from trunk. (user: drh, tags: begin-concurrent)
17:00
[64a8ae68] Add the --enable-update-limit option to the ./configure script. (user: drh, tags: trunk)
16:11
[1ba051e3] Avoid unnecessary mutexes in the pcache1 implementation in the common case where no auxiliary page cache memory is configured. (user: drh, tags: trunk)
15:51
[54b00024] Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. (user: drh, tags: trunk)
14:33
[2348045f] Backport changes to shell.c into shell.c.in. (user: drh, tags: trunk)
11:12
[cf0d3715] Fix the ".dump", ".schema", and ".fullschema" commands of the command-line shell so that they work even if PRAGMA empty_result_callbacks is enabled. Fix for ticket [02f0f4c54f281]. (user: drh, tags: trunk)
2017-08-27
10:55
[c93298d5] Leaf: Instrumentation and changes in an effort to reduce thread contention. (user: drh, tags: reduced-thread-contention)
2017-08-25
19:51
[1783c54c] Fix a few over-length source code lines. No functional changes. (user: drh, tags: trunk)
15:43
[776d9128] Size and performance optimization for sqlite3Init(). (user: drh, tags: trunk)
13:34
[39f708d1] Small performance optimization in sqlite3WhereBegin(). (user: drh, tags: trunk)
13:02
[2738b8db] Convert a branch made unreachable by [59560d07] into an assert(). (user: drh, tags: trunk)
11:44
[e8d23afe] Improve the internal mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. (user: drh, tags: trunk)
09:17
[b79cc8dc] Avoid returning duplicate rows in experimental pragmas "pragma_list", "module_list" and "function_list". (user: dan, tags: trunk)
01:14
[bf65dae8] Closed-Leaf: Update the mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. (user: drh, tags: wal-sync-refactor)
2017-08-24
20:54
[25292b9a] Fix an incorrect hyperlink in a comment. (user: drh, tags: trunk)
16:21
[8d3a7ea6] Leaf: Version 3.20.1 (user: drh, tags: release, branch-3.20, version-3.20.1)
15:43
[7ec72314] Fixes to documentation about SQLITE_OPEN_URI. (user: drh, tags: trunk)
14:08
[70338c7c] Increase the version number to 3.20.1. (user: drh, tags: branch-3.20)
14:04
[abc7adfd] Make sure the sqlite3_result_pointer() interface does not leave a VM register in an inconsistent state. Fix for ticket [7486aa54b968e9b5]. Test cases are in TH3. (user: drh, tags: branch-3.20)
13:55
[d2f9230c] Make sure the sqlite3_result_pointer() interface does not leave a VM register in an inconsistent state. Fix for ticket [7486aa54b968e9b5]. Test cases are in TH3. (user: drh, tags: trunk)
10:10
[c3fe1f4b] Test BEGIN CONCURRENT transactions that consist entirely of read-only statements. (user: dan, tags: begin-concurrent)
2017-08-23
23:09
[59560d07] Performance optimization to pageFindSlot() in the b-tree layer. (user: drh, tags: trunk)
20:36
[bc1ec123] Size and performance optimization to dropCell() and freeSpace(). (user: drh, tags: trunk)
14:45
[77074990] Smaller and faster implementation of the fillInCell() routine. (user: drh, tags: trunk)
2017-08-22
21:23
[e69c0c87] Update documentation to make it clear that SQLITE_SOURCE_ID and sqlite3_sourceid() might changes if the source code is edited. (user: drh, tags: trunk)
21:07
[564c7340] Less dramatic changes to the source-id following an edit. Modify the way that the amalgamation is constructed to give it the opportunity to detect changes and modify the source-id. (user: drh, tags: trunk)
19:54
[515d6a83] Modify the SQLITE_SOURCE_ID if the source code has changed in any way since the previous check-in. (user: drh, tags: trunk)
19:49
[a1b3337e] Closed-Leaf: Trying again to get out-of-tree builds to work correctly. (user: drh, tags: mksourceid)
19:44
[ca5dcb4a] Leaf: mksourceid still does not work right. (user: drh, tags: mistake)
19:43
[5a037ac2] Attempting to fix the source-id generator so that it works for out-of-tree builds. (user: drh, tags: mksourceid)
19:19
[d4c05e04] Add the "mksourceid" program to the build process. That program changes the SQLITE_SOURCE_ID if the source tree has been modified in any way. (user: drh, tags: mksourceid)
15:21
[885c2b44] Fix error tests in seldom-used compile-time branches of the unix backend. (user: drh, tags: trunk)
2017-08-21
02:20
[56d19f9f] Remove an unnecessary conditional. (user: drh, tags: trunk)
02:05
[6538ef7b] Minor optimization to sqlite3VdbeMemSetStr(). (user: drh, tags: trunk)
2017-08-19
20:38
[d01d2cff] Space and size optimization to the printf implementation. (user: drh, tags: trunk)
15:50
[2dd36ade] Ensure that write-locks on pages are dropped at the end of each write transaction, even if there is still a read transaction open. (user: dan, tags: server-process-edition)
2017-08-18
22:30
[745bc8de] Another size and performance optimization to readDbPage(). This time we eliminate some unnecessary local variables. (user: drh, tags: trunk)
21:14
[ca9e1875] Size and performance optimization the readDbPage() routine in the pager. (user: drh, tags: trunk)
18:55
[abb6e076] Add tests to this branch. (user: dan, tags: server-process-edition)
16:09
[3075cfa0] For the unix VFS, avoid an unnecessary stat() system call prior to opening any file in the common case where there are no unused file descriptors. (user: drh, tags: trunk)
16:04
[66fb9e1c] Do not search for locks to clear when connecting to a db in multi-process mode unless it looks like the previous user of the client-id crashed. (user: dan, tags: server-process-edition)
14:34
[eb1202b5] Combine the OP_CreateTable and OP_CreateIndex opcodes of the bytecode engine into a single OP_CreateBtree opcode. This simplifies the implementation and makes the bytecode programs clearer. (user: drh, tags: trunk)
08:29
[37e19008] Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. (user: dan, tags: trunk)
2017-08-17
20:53
[a42a438c] Use the __builtin_clzll() function of gcc to improve the performance and reduce the size of the sqlite3LogEst() routine. (user: drh, tags: trunk)
19:32
[a8115f95] Add support for crash recovery in multi-process mode. And add test cases for the same. (user: dan, tags: server-process-edition)
19:23
[264a5e1b] Small optimization in the Expr tree walker. (user: drh, tags: trunk)
18:54
[0367a4d5] Size optimization in the authorizer error message generation logic. (user: drh, tags: trunk)
18:23
[f13682ea] In sqlite3ViewGetColumnNames(), return the number of errors, not an error code. (user: drh, tags: trunk)
18:17
[0712f057] The RTREE extension should return SQLITE_CORRUPT_VTAB, not just SQLITE_CORRUPT when it encounters incorrectly formatted shadow tables. (user: drh, tags: trunk)
14:47
[fb6ca99b] Remove an unnecessary branch from the [be436a7f4587ce517ddc] fix. (user: drh, tags: trunk)
14:12
[2101b420] Add test cases for ticket [be436a7f4587ce517] using virtual table modules fts5 and rtree. (user: dan, tags: trunk)
02:26
[a7bc7752] Defer schema resets when the query planner is running. Proposed fix for ticket [be436a7f4587ce517]. (user: drh, tags: trunk)
2017-08-16
19:20
[f078deb2] Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. (user: drh, tags: trunk)
17:06
[380a7b7a] Update this branch with the latest changes from trunk. (user: dan, tags: server-process-edition)
16:52
[04e0cb57] Enhance this branch to support page-level-locking (without MVCC) for multi-process deployments. (user: dan, tags: server-process-edition)
14:16
[39543903] Remove an unnecessary local variable from OP_Column, for a small size reduction and performance increase. (user: drh, tags: trunk)
11:04
[dc98a92f] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
2017-08-15
14:14
[2cf3f3de] Small size and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
03:46
[373b71d1] Btree optimization: New field BtCursor.pPage that points to the current page, saving a single pointer dereference on each access. (user: drh, tags: trunk)
01:07
[346a710d] Fix a problem allowing a conflicting transaction to be committed in the case where more than one 32KB shared-memory page has been written to since the transaction was started. (user: drh, tags: begin-concurrent-branch-3.19)
2017-08-14
23:53
[16969338] Minor size and performance optimization to sqlite3BtreeCloseCursor(). (user: drh, tags: trunk)
18:13
[240d5714] Change the internal btree routine moveToRoot() to return SQLITE_EMPTY if the table is empty or if it has pgnoRoot==0. This simplifies the callers, making them smaller and faster. The SQLITE_EMPTY result code is intercepted and changed into SQLITE_OK before surfacing in an API. (user: drh, tags: trunk)
17:03
[25e92baa] Fix harmless indentation error. (user: drh, tags: trunk)
14:53
[d0da791b] Sometimes a TK_COLUMN Expr node can have Expr.pTab==0 if it is a reference to an expression column in an index on an expression. Fix for ticket [aa98619ad08ddcab]. (user: drh, tags: trunk)
07:16
[8e1b28ed] Remove code for PLL support in wal mode from this branch. (user: dan, tags: server-process-edition)
06:55
[bc2498d6] Update this branch with latest trunk changes. (user: dan, tags: server-process-edition)
01:33
[7e0d3e9c] Properly dequote column names in tables constructed by an aggregate SELECT. (user: drh, tags: trunk)
2017-08-12
18:31
[02174842] Add new test file fts5vocab2.test. (user: dan, tags: trunk)
14:06
[42560723] Add a more rigorous test case for the bug fixed by the previous commit on this branch. (user: dan, tags: begin-concurrent)
02:16
[14d262d6] Update the speed-check.sh test script to append log output to the end of the cout-NAME.txt file. (user: drh, tags: trunk)
02:01
[6e52fa5f] Remove the zBase field from the StrAccum object. Resulting code is slightly smaller and faster. (user: drh, tags: trunk)
01:09
[28a5aec1] Size and performance micro-optimization on sqlite3SrcListIndexedBy(). (user: drh, tags: trunk)
2017-08-11
21:16
[38dd9b50] Fix a problem allowing a conflicting transaction to be committed in the case where more than one 32KB shared-memory page has been written to since the transaction was started. (user: dan, tags: begin-concurrent)
20:22
[11054cf5] Add another PAGERTRACE() macro to show when pages are added to Pager.pAllRead. No impact on production builds. (user: drh, tags: begin-concurrent)
19:31
[39f39e3d] Add a PAGERTRACE() macro to log when frames are written into the WAL file. This is for analysis only and is a no-op for production builds. (user: drh, tags: begin-concurrent)
19:16
[47e71695] Merge the latest enhancements from trunk. (user: drh, tags: begin-concurrent)
18:59
[831156a4] Fix compiler warnings that arise if the PAGERTRACE macro is turned on. This changes does not affect production builds. (user: drh, tags: trunk)
18:55
[aa49926d] Improved comments in the header of the LSM1 vtab module. No code changes. (user: drh, tags: trunk)
13:51
[cb0c49cb] New test cases for LSM1. (user: drh, tags: trunk)
12:49
[2164031b] Convert the LSM1 virtual table to be WITHOUT ROWID and get UPDATE and DELETE operations working on it. (user: drh, tags: trunk)
03:47
[9466d952] Simplification to the like optimization logic. Remove unnecessary branches. (user: drh, tags: trunk)
2017-08-10
20:43
[c601d128] Allow WITHOUT ROWID virtual tables to be writable as long as they have exactly one column as their PRIMARY KEY. (user: drh, tags: trunk)
20:36
[34a7bd71] Add the "instance" type to the fts5vocab virtual table module. For direct access to the contents of the fts5 term index. (user: dan, tags: trunk)
19:12
[f38ff718] Closed-Leaf: Fix a typo in csv01.test introduced by the previous commit. (user: dan, tags: writable-vtab-without-rowid)
19:10
[b0e3b88a] Add extra tests to this branch. (user: dan, tags: writable-vtab-without-rowid)
17:53
[6997e00c] Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual table is modified to add a "fullname" column which is the primary key, and to accept update operations against the primary key. (user: drh, tags: writable-vtab-without-rowid)
15:19
[ab9ee4c1] Experimental changes that allow a WITHOUT ROWID virtual table to be writable as long as it has only a single-column PRIMARY KEY. (user: drh, tags: writable-vtab-without-rowid)
03:27
[e49279e6] Add a first draft of the "vtablog" extensions that implements a generic virtual table useful for experimentation using the command-line shell. (user: drh, tags: trunk)
2017-08-09
22:55
[dcdf0913] Preserve the error code from xConnect or xCreate methods in virtual table implementations when they are encountered during parsing. (user: drh, tags: trunk)
20:35
[a6256980] Leaf: Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. (user: dan, tags: reuse-schema)
19:27
[94434a25] Various bug fixes for the new LSM1 virtual table design. (user: drh, tags: trunk)
18:40
[313df946] Work toward redesigning the interface to the LSM1 virtual table. (user: drh, tags: trunk)
2017-08-08
21:40
[795eede3] The identifier "vsnprintf" appears to be a reserved word in recent versions of XCode, so avoid using it as a structure field. (user: drh, tags: trunk)
21:30
[f4a4b149] Fix a faulty signed/unsigned character comparison in the LIKE optimization logic. (user: drh, tags: trunk)
20:03
[537e3be2] Enhance the CSV virtual table extension so that it accepts the last row of the CSV file even if the last row omits the closing \n, as long as the last row has a full set of columns. (user: drh, tags: trunk)
2017-08-07
19:12
[b26d7a1c] Avoid casting a value larger than 2^31 to a (size_t) or (SIZE_T) on systems where it is a 32-bit type. (user: dan, tags: trunk)
19:06
[f08d63b4] Leaf: On Windows, avoid casting a value larger than 2^31 to a (SIZE_T) on systems where it is a 32-bit type. (user: mistachkin, tags: mmap-size-limit)
18:54
[4249fcf7] Fix a problem with handling SQLITE_FCNTL_MMAP_SIZE requests with a negative parameter in os_unix.c. (user: dan, tags: mmap-size-limit)
18:27
[7c8b6f1c] Update bigmmap.test to account for builds that use "-DSQLITE_MAX_MMAP_SIZE=<integer-constant>LL". (user: dan, tags: mmap-size-limit)
18:13
[46c3085d] Avoid casting a value larger than 2^31 to a (size_t) on systems where it is a 32-bit type. (user: dan, tags: mmap-size-limit)