SQLite
Timeline
Not logged in

50 most recent check-ins

2017-01-17
10:41
[681d96eb] Leaf: Fix a problem that could cause a spurious SQLITE_NOMEM error when attempting to resume an RBU operation if the previous client failed right after completing the incremental checkpoint. Also a "cannot vacuum wal db" error that could occur when resuming an RBU vacuum if an error (OOM or IO error) occurs during the incremental checkpoint. (user: dan, tags: trunk)
00:10
[7fd560c6] Disable intrinsic functions for Windows using Clang, due to reports of linkage errors. This causes a 0.6% performance reduction. We will want to revisit this change in the future. (user: drh, tags: trunk)
2017-01-16
18:10
[9b64af7b] Back out check-in [0b3174e0b1364c] and replace it with a better fix for \ticket [91e2e8ba6ff2e2] - a fix that does not cause the problem identified by ticket [7ffd1ca1d2ad4ec]. Add new test cases for both tickets. (user: drh, tags: trunk)
16:43
[06136652] Closed-Leaf: Back out check-in [0b3174e0b1364c] and replace it with a better fix for ticket [91e2e8ba6ff2e2] - a fix that does not cause the problem identified by ticket [7ffd1ca1d2ad4ec]. (user: drh, tags: automatic-index-affinity)
16:01
[9d0dfe0b] Add test cases for tickets [91e2e8ba6ff2e2] and [7ffd1ca1d2ad4ec]. (user: drh, tags: automatic-index-affinity)
11:54
[e42ed9b4] Leaf: An example showing how to improve performance of sqlite3VdbeSerialPut() using the GCC intrinsic function __builtin_bswap64(). (user: drh, tags: builtin-bswap64)
2017-01-13
22:21
[8b42b8e3] Leaf: Merge updates from trunk. (user: mistachkin, tags: winSectorSize)
18:24
[97914266] Fix a problem preventing resumption of RBU operations after recovering from a process or system failure that occurs during the incremental-checkpoint phase. (user: dan, tags: trunk)
12:53
[8c85b8fd] Fix the build for SQLITE_ENABLE_MEMORY_MANAGEMENT. (user: drh, tags: trunk)
2017-01-12
23:37
[6e388423] Attempt to detect physical sector sizes on Windows Vista and higher. (user: mistachkin, tags: winSectorSize)
19:10
[9acc7238] Remove a branch that is probably unreachable, and which adds no value. (user: drh, tags: trunk)
16:21
[385db266] Fix harmless compiler warnings in the UPDATE code generator. (user: drh, tags: trunk)
16:14
[bddf3956] Remove an unnecessary corruption test from the btree balancer. If corruption is present, it will be found harmlessly by later tests. (user: drh, tags: trunk)
15:19
[bd8b977a] Leaf: Test case macros to show that the previous check-in is well tested. (user: drh, tags: extra-testcase-macros)
15:11
[8097712c] Improved detection of cells that extend into the reserved space at the end of the page while adjusting overflow page pointers during autovacuum. (user: drh, tags: trunk)
11:52
[163cc1b2] Remove invalid test case from cursorhints2.test (user: drh, tags: trunk)
11:50
[c07aef6f] Make sure Tcl_AppendResult() always has a NULL-pointer argument at the end. (user: drh, tags: trunk)
2017-01-11
21:03
[7ae6104a] Changes to allow some multi-row UPDATE statements to avoid the two-pass approach. (user: dan, tags: trunk)
20:10
[62257eb5] Closed-Leaf: Fix a problem causing the pre-update hook to be passed an incorrect rowid value in some single-pass multi-row updates. (user: dan, tags: onepass-update)
19:03
[0a2b8e1b] Fix a problem with single-pass multi-row UPDATE statements that invoke REPLACE conflict handling. (user: dan, tags: onepass-update)
16:52
[381fd34b] Attempt to detect physical sector sizes on Windows 8 and higher. (user: mistachkin, tags: winSectorSize)
15:42
[cab86c90] Fix a problem preventing UPDATE statements that use a range-scan on the PK index of a WITHOUT ROWID table from using a one-pass strategy. (user: dan, tags: onepass-update)
14:21
[4f83f680] Leaf: In the STAT4 computations, ensure that the aAvgEq values do not go negative. (user: drh, tags: branch-3.8.9)
14:15
[f58f75b5] In the STAT4 computations, ensure that the aAvgEq values do not go negative. (user: drh, tags: trunk)
2017-01-10
20:04
[46db23cc] Changes to allow some multi-row UPDATE statements to avoid the two-pass approach. (user: dan, tags: onepass-update)
17:37
[e500c15a] Add a test case for ticket [25e335f802dd]. (user: dan, tags: trunk)
17:33
[c92ecff2] Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. Fix for ticket [25e335f802dd]. (user: drh, tags: trunk)
16:09
[4209b89e] Avoid unnecessary calls to the xRoundup() method of the memory allocator when the soft heap limit is not set. (user: drh, tags: trunk)
15:08
[71c03b59] Fix a potential assertion fault discovered by OSS-Fuzz. (user: drh, tags: trunk)
2017-01-09
20:57
[ff9eab95] Leaf: Merge latest changes from trunk, and also move the perf-counter into the inner loop of sqlite3BtreeMovetoUnpacked(). (user: drh, tags: vdbe-aux-perf)
19:55
[a5fa0965] Remove a redundant assignment statement. (user: drh, tags: trunk)
19:27
[237aa974] Performance optimization and size reduction in the OP_Variable opcode. (user: drh, tags: trunk)
18:22
[d38fd229] Fix typo in a comment. No changes to code. (user: mistachkin, tags: trunk)
18:20
[8a90f691] Closed-Leaf: Try to move OP_Concat operations outside the inner loop. This turns out to make things very slightly slower, at least in speedtest1.c. (user: drh, tags: failed-optimization)
15:44
[6e106acd] Modify the OP_RowData opcode so that when P3!=0 it is allowed to hold an ephemeral copy of the content. This avoids unnecessary memcpy() operations in the xfer-optimization and VACUUM. (user: drh, tags: trunk)
13:43
[a5fe03bc] Add the SQLITE_UINT64_TYPE compile-time option. (user: drh, tags: trunk)
07:00
[50fb1eb3] Leaf: Merge the "changebatch" functionality into this branch. (user: dan, tags: begin-concurrent)
06:53
[c8ca3e0a] Disable the optimization from [8cb8516d] (omit TableLock instructions for non-sharable databases) on this branch. This branch uses the TableLock instructions to ensure that the db schema is not written from within a BEGIN CONCURRENT transaction. (user: dan, tags: begin-concurrent)
06:33
[d0e212d0] Upgrade this branch to 3.16 plus the various fixes that appeared after its release. (user: dan, tags: begin-concurrent)
2017-01-07
14:47
[3178ec4c] Improvements to the iIdxNoSeek optimization of sqlite3GenerateRowDelete() so that it is automatically disabled for BEFORE triggers but works in all other cases. (user: drh, tags: trunk)
14:26
[db2c0960] Critical fix to the previous check-in so that it works when there are BEFORE triggers that move the cursor before the OP_Delete has a chance to be applied. (user: drh, tags: trunk)
03:26
[f0495c51] Avoid an unnecessary btree seek while deleting an index entry due to a conflict on a REPLACE operation. (user: drh, tags: trunk)
00:56
[d577dda0] Avoid duplicate b-tree searches in the duplicate row detector used to implement DISTINCT. (user: drh, tags: trunk)
00:42
[746b1836] This hack illustrates how to use the VDBE_PROFILE mechanism to show which bytecode operators are using resources other than time. In this case, the number of loops through the binary search code in sqlite3BtreeMovetoUnpacked() is measured, for the purpose of helping to identify unnecessary btree searches. (user: drh, tags: vdbe-aux-perf)
2017-01-06
16:32
[a65a6289] Leaf: Version 3.16.2 (user: drh, tags: release, branch-3.16, version-3.16.2)
13:53
[01b4cb26] Clarify the documentation on sqlite3_column_count(). (user: dan, tags: branch-3.16)
13:52
[4a97ba4e] Ensure that "PRAGMA case_sensitive_like" and "PRAGMA shrink_memory" set the number of output columns to 0 (as they are statements that return no data). (user: dan, tags: branch-3.16)
13:49
[6696cd18] Ensure that "PRAGMA case_sensitive_like" and "PRAGMA shrink_memory" set the number of output columns to 0 (as they are statements that return no data). (user: dan, tags: trunk)
11:56
[b0726941] Improve handling of corrupt databases in fts5. (user: dan, tags: branch-3.16)
11:55
[609ac1c7] Improve handling of corrupt data in fts5. (user: dan, tags: trunk)