SQLite
Timeline
Not logged in

50 most recent timeline items

2017-01-18
01:11
[cb9d1ab3] Leaf: Add runtime version checking for winSectorSize. (user: mistachkin, tags: winSectorSize)
00:27
[de699ead] When determining sector sizes on Windows 7 and Vista, make sure the target file is on the same volume as corresponding root directory. (user: mistachkin, tags: winSectorSize)
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 • Fixed ticket [7ffd1ca1]: Incorrect affinity when using automatic indexes plus 5 other changes (user: drh)
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)
15:10 • New ticket [7ffd1ca1] Incorrect affinity when using automatic indexes. (user: drh)
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] 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:46 • Fixed ticket [25e335f8]: Incorrect result when ON clause refers to table to the right plus 4 other changes (user: drh)
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)
17:19 • Ticket [25e335f8] Incorrect result when ON clause refers to table to the right status still Open with 6 other changes (user: drh) ... 1 similar event omitted.
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:21 • Edit [8a90f69139f7014e|8a90f691]: Mark "Closed". (user: drh)
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)