SQLite
Timeline
Not logged in

50 most recent timeline items

2017-09-23
07:46
[d71eeaab9e] 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
[8d2a1cca61] 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
[2c03d8b8f0] Leaf: Use the updated Win32 VFS semantics for winOpen from check-in [5d03c738e9] for WinRT, et al, as well. (user: mistachkin, tags: trunk)
12:52
[403b88a894] 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
[c7a5880d6d] 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
[307b802e86] Merge latest trunk changes into this branch. (user: dan, tags: begin-concurrent)
00:24
[0a12915b37] Update the configure script so that it looks for tclsh8.7 ahead of tclsh8.6. (user: drh, tags: trunk)
2017-09-21
20:43
[5d03c738e9] 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
[fa3f5bcc23] 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
[68e9a840d9] Fix harmless UB in the ICU extension. (user: drh, tags: trunk)
14:03
[3fbfa9a8e8] Leaf: The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. (user: drh, tags: sqlite3_snapshot_describe)
13:11
[fd4ec0cdbd] Fix a potential use of an uninitialized pointer in RTree following an OOM error. (user: drh, tags: trunk)
10:24
[65765222ef] 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
[f8b1c64d3e] 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
[adc12c83dd] 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
[4b3f7eacb8] Size and performance optimization on sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
18:07
[e0af9a9040] The BLOB returned by sqlite3VdbeMemFromBtree() does not need to be zero-terminated. (user: drh, tags: trunk)
17:49
[3b3e32d4cd] Small size and performance optimization in the bytecode engine. (user: drh, tags: trunk)
10:47
[7f2bd4ff45] Improved resolution of large integer values in "CAST(x AS NUMERIC)". (user: drh, tags: trunk)
09:09
[5b2002f3df] Updates to the "lemon.html" document received from Andy Goth. (user: drh, tags: trunk)
2017-09-18
18:17
[1b2de41453] Add the sqlite3_mmap_warm() function as an extension in the ext/misc/mmapwarm.c source file. (user: drh, tags: trunk)
18:08
[3235835bab] Closed-Leaf: Fix a typo in the MSVC makefile. (user: drh, tags: mmap-warm)
16:28
[d4a30b91f9] 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
[a944719314] Minor simplification of error message generation during compound query code generation. (user: drh, tags: trunk)
09:40
[74f399d81f] 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
[2e57335081] Leaf: Merge latest trunk changes with this branch. (user: dan, tags: shared-mapping-hack)
00:18
[42f0777555] 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
[29227d00a9] 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
[5dbb255a93] Simplify the sqlite3VdbeGet() routine. Smaller, faster, and easier to maintain. (user: drh, tags: trunk)
2017-09-15
17:40
[dd95887f82] Remove an unnecessary parameter from selectInnerLoop(). (user: drh, tags: trunk)
15:38
[5dc3ecb5f6] Improved the header-comment documentation on sqlite3ExprCodeExprList(). No changes to code. (user: drh, tags: trunk)
15:17
[4da49a95c0] Optimization to the ExprList object to make it slightly smaller and faster. (user: drh, tags: trunk)
14:36
[f7f0bf1da0] Fix a harmless comment typo. No changes to code. (user: drh, tags: trunk)
2017-09-14
21:12
[1a7e0b61c8] Add another test case for the problem fixed by the previous commit. (user: dan, tags: trunk)
20:41
[cf5bf42cad] Avoid an out-of-bounds read that can be caused by a specially constructed journal file. (user: dan, tags: trunk)
02:36
[378afa1638] 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
[43c6023bbf] Test case update due to PRAGMA integrity_check enhancements in [8525c30c]. No changes to code. (user: drh, tags: trunk)
18:38
[ebada0723a] Leaf: Experimental sqlite3_stmt_retryable() interface. (user: drh, tags: sqlite3_stmt_retryable)
12:55
[87ccdf9cbb] Disable FTS3 matchinfo() tests that assume a littleEndian platform when running on bigEndian. (user: drh, tags: trunk)
00:33
[8525c30c1d] 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
[81f62e99f2] Closed-Leaf: PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption while scanning indexes. (user: drh, tags: improved-integrity-check)
00:01
[a5a1949259] Fix test script comment. No changes to code. (user: mistachkin, tags: trunk)
2017-09-12
23:58
[3a2793aa65] 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
[afe45271b9] Leaf: Add the highly-experimental "PRAGMA noop_update=TRUE" command. (user: drh, tags: begin-concurrent-pnu)
18:49
[de2e371757] Leaf: Add the highly-experimental "PRAGMA noop_update=TRUE" command. (user: drh, tags: pragma-noop-update)
18:11
[8b1fc4b9f3] Merge the mutex-free PRNG change into this branch. (user: dan, tags: shared-mapping-hack)
18:03
[ec37ad6d08] 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
[9780b23ca3] 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
[b22cdd6734] Changes to (hopefully) get the build working with recent Intel compilers. (user: drh, tags: trunk)
00:24
[d7b7f038a2] Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. (user: drh, tags: trunk)