SQLite
Timeline
Not logged in

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

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