Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of [06b8001a]
|
2017-01-22
| ||
| 16:34 | Fix an uninitialized variable in the command-line shell. check-in: 06b8001a user: drh tags: trunk | |
| 02:04 | Fixes to documentation comments in the public header file. check-in: 772dcb08 user: mistachkin tags: trunk | |
| 00:11 | Fix an initialized variable in kvtest. check-in: ed62c5a6 user: drh tags: trunk | |
|
2017-01-21
| ||
| 16:27 | Change sqlite3_blob_reopen() to call sqlite3VdbeExec() directly rather than going through sqlite3_step(). Performance enhancement. check-in: 347df3c1 user: drh tags: trunk | |
| 15:55 | In the kvtest.c test utility, reuse the buffer into which blobs are read, rather than reallocating it for each row. This is a closer match to how other test programs work, and thus provides a better comparison. check-in: 0d1ad13a user: drh tags: trunk | |
| 14:11 | Remove an unnecessary sqlite3_bind_int64() call from sqlite3_blob_open(). Also other minor refactoring of the sqlite3_blob implementation. check-in: 9d197a53 user: drh tags: trunk | |
|
2017-01-20
| ||
| 20:43 | Minor performance optimization and size reduction to the accessPayload() routine in btree.c. check-in: 264e5c10 user: drh tags: trunk | |
| 16:47 | Fix a typo in the help message for kvtest. check-in: 8971d98f user: dan tags: trunk | |
| 16:46 | Add option "--stats" to test program kvtest. Specifying --stats causes kvtest to output information similar to the shell tool option of the same name. check-in: 90291327 user: dan tags: trunk | |
| 16:09 | Get the "--testset rtree" option working on speedtest1. Add the --rtree, --lookaside, and --clang options to the speed-check.sh script. check-in: 87b640c8 user: drh tags: trunk | |
| 00:40 | Minor performance optimizations to sqlite3_blob_open() and sqlite3_blob_reopen(). check-in: 52a61967 user: drh tags: trunk | |
|
2017-01-19
| ||
| 21:20 | If compiled with SQLITE_INLINE_MEMCPY, all memcpy() calls are replaced with in-line code. With that change, cachegrind shows which memcpy() calls are taking the most time. This is a performance-measurement hack only and is not for production use. check-in: 9ed38521 user: drh tags: trunk | |
| 18:20 | In the 'vtshim' extension, avoid accessing freed memory when handling errors from xCreate/xConnect. check-in: ffd559af user: mistachkin tags: trunk | |
|
2017-01-18
| ||
| 22:47 | In the 'windirent' test module, use a macro for the hidden/system attribute checking. check-in: a84a08d0 user: mistachkin tags: trunk | |
| 22:19 | Remove superfluous option to Tcl 'lsort' in the vtabH test file. check-in: b92cc6e5 user: mistachkin tags: trunk | |
| 22:16 | Make the vtabH-3.1 test more portable and robust. check-in: d3c91c1f user: mistachkin tags: trunk | |
| 22:16 | Fix handling of initial hidden and/or system files in the opendir() implementation for Windows. No changes to non-test code. check-in: 26dd42b4 user: mistachkin tags: trunk | |
|
2017-01-17
| ||
| 10:41 | 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. check-in: 681d96eb user: dan tags: trunk | |
| 00:10 | 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. check-in: 7fd560c6 user: drh tags: trunk | |
|
2017-01-16
| ||
| 18:10 | 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. check-in: 9b64af7b user: drh tags: trunk | |
| 16:43 | 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]. Closed-Leaf check-in: 06136652 user: drh tags: automatic-index-affinity | |
| 16:01 | Add test cases for tickets [91e2e8ba6ff2e2] and [7ffd1ca1d2ad4ec]. check-in: 9d0dfe0b user: drh tags: automatic-index-affinity | |
|
2017-01-13
| ||
| 18:24 | Fix a problem preventing resumption of RBU operations after recovering from a process or system failure that occurs during the incremental-checkpoint phase. check-in: 97914266 user: dan tags: trunk | |
| 12:53 | Fix the build for SQLITE_ENABLE_MEMORY_MANAGEMENT. check-in: 8c85b8fd user: drh tags: trunk | |
|
2017-01-12
| ||
| 19:10 | Remove a branch that is probably unreachable, and which adds no value. check-in: 9acc7238 user: drh tags: trunk | |
| 16:21 | Fix harmless compiler warnings in the UPDATE code generator. check-in: 385db266 user: drh tags: trunk | |
| 16:14 | Remove an unnecessary corruption test from the btree balancer. If corruption is present, it will be found harmlessly by later tests. check-in: bddf3956 user: drh tags: trunk | |
| 15:11 | Improved detection of cells that extend into the reserved space at the end of the page while adjusting overflow page pointers during autovacuum. check-in: 8097712c user: drh tags: trunk | |
| 11:52 | Remove invalid test case from cursorhints2.test check-in: 163cc1b2 user: drh tags: trunk | |
| 11:50 | Make sure Tcl_AppendResult() always has a NULL-pointer argument at the end. check-in: c07aef6f user: drh tags: trunk | |
|
2017-01-11
| ||
| 21:03 | Changes to allow some multi-row UPDATE statements to avoid the two-pass approach. check-in: 7ae6104a user: dan tags: trunk | |
| 20:10 | Fix a problem causing the pre-update hook to be passed an incorrect rowid value in some single-pass multi-row updates. Closed-Leaf check-in: 62257eb5 user: dan tags: onepass-update | |
| 19:03 | Fix a problem with single-pass multi-row UPDATE statements that invoke REPLACE conflict handling. check-in: 0a2b8e1b user: dan tags: onepass-update | |
| 15:42 | 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. check-in: cab86c90 user: dan tags: onepass-update | |
| 14:15 | In the STAT4 computations, ensure that the aAvgEq values do not go negative. check-in: f58f75b5 user: drh tags: trunk | |
|
2017-01-10
| ||
| 20:04 | Changes to allow some multi-row UPDATE statements to avoid the two-pass approach. check-in: 46db23cc user: dan tags: onepass-update | |
| 17:37 | Add a test case for ticket [25e335f802dd]. check-in: e500c15a user: dan tags: trunk | |
| 17:33 | Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. Fix for ticket [25e335f802dd]. check-in: c92ecff2 user: drh tags: trunk | |
| 16:09 | Avoid unnecessary calls to the xRoundup() method of the memory allocator when the soft heap limit is not set. check-in: 4209b89e user: drh tags: trunk | |
| 15:08 | Fix a potential assertion fault discovered by OSS-Fuzz. check-in: 71c03b59 user: drh tags: trunk | |
|
2017-01-09
| ||
| 19:55 | Remove a redundant assignment statement. check-in: a5fa0965 user: drh tags: trunk | |
| 19:27 | Performance optimization and size reduction in the OP_Variable opcode. check-in: 237aa974 user: drh tags: trunk | |
| 18:22 | Fix typo in a comment. No changes to code. check-in: d38fd229 user: mistachkin tags: trunk | |
| 15:44 | 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. check-in: 6e106acd user: drh tags: trunk | |
| 13:43 | Add the SQLITE_UINT64_TYPE compile-time option. check-in: a5fe03bc user: drh tags: trunk | |
|
2017-01-07
| ||
| 14:47 | Improvements to the iIdxNoSeek optimization of sqlite3GenerateRowDelete() so that it is automatically disabled for BEFORE triggers but works in all other cases. check-in: 3178ec4c user: drh tags: trunk | |
| 14:26 | 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. check-in: db2c0960 user: drh tags: trunk | |
| 03:26 | Avoid an unnecessary btree seek while deleting an index entry due to a conflict on a REPLACE operation. check-in: f0495c51 user: drh tags: trunk | |
| 00:56 | Avoid duplicate b-tree searches in the duplicate row detector used to implement DISTINCT. check-in: d577dda0 user: drh tags: trunk | |
|
2017-01-06
| ||
| 13:49 | 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). check-in: 6696cd18 user: dan tags: trunk | |
| 11:55 | Improve handling of corrupt data in fts5. check-in: 609ac1c7 user: dan tags: trunk | |
| 01:09 | Clarify the documentation on sqlite3_column_count(). check-in: 9ea0badd user: drh tags: trunk | |
| 00:02 | Remove several non-portable tests for the deprecated temp_store_directory PRAGMA. check-in: 28d87789 user: mistachkin tags: trunk | |
|
2017-01-05
| ||
| 20:00 | Ensure that sqlite3_column_count() returns 0 for the "set" mode of "get/set" PRAGMA statements that do not return a value in that case (e.g. page_size, cache_size, auto_vacuum). check-in: 2f57939a user: dan tags: trunk | |
| 19:32 | Ensure that sqlite3_column_count() returns 0 for the "set" mode of "get/set" PRAGMA statements that do not return a value in that case (e.g. page_size, cache_size, auto_vacuum). Closed-Leaf check-in: 5c05d8ec user: dan tags: pragma-columncount-fix | |
| 17:23 | Fix handling the case where a sub-query in a FROM clause is itself a UNION ALL, and one side of that UNION ALL is a query on a view that includes an ORDER BY. Fix for ticket [190c2507]. check-in: 590ca83b user: dan tags: trunk | |
| 13:50 | Fix problems in trigger and foreign key handling when doing REPLACE on a WITHOUT ROWID table that has no secondary indexes. Fix for ticket [30027b613b4]. check-in: 571f166e user: drh tags: trunk | |
| 07:58 | Ensure that the sqlite3_value_text() interface returns a buffer that is long enough to hold the complete string plus the zero terminator even when the input is a zeroblob. Fix for a problem detected by OSS-Fuzz. check-in: 2dc7eeb5 user: drh tags: trunk | |
| 06:57 | Fix some problems with foreign key processing within REPLACE ops on WITHOUT ROWID tables with no triggers or auxiliary indexes. Closed-Leaf check-in: c1220b1a user: dan tags: replace-fix | |
|
2017-01-04
| ||
| 22:02 | Improved the comment on the block of code the provides the performance optimization originally added by check-in [925840cfdb]. The original check-in omitted condition 4, which was the cause of bug [30027b613b]. check-in: c6506b82 user: drh tags: replace-fix | |
| 20:13 | Possible fix for [30027b61]. There may still be problems surrounding foreign key processing. check-in: 71ccb1f4 user: dan tags: replace-fix | |
| 14:53 | Adjust filename creation in test_sqllog.c so that it uses leading zeros on counters, so that files appear in order when sorted lexicographically. check-in: 8d670973 user: drh tags: trunk | |
| 13:09 | Performance enhancements in the printf implementation. check-in: 82e4001b user: drh tags: trunk | |
| 04:18 | Factor constant functions out of the inner loop since they are more expensive than the extra OP_Copy needed to move the result into place. check-in: 80ad317f user: drh tags: trunk | |
| 04:10 | Clean up the implementation of constant function factorization. Closed-Leaf check-in: 2ab997e4 user: drh tags: factor-constant-funcs | |
| 01:07 | Attempt to factor out constant functions from the interior of table scans, since functions can often be expensive to compute. check-in: 62e9270a user: drh tags: factor-constant-funcs | |
| 00:26 | Changes to the printf implementation for better performance. Closed-Leaf check-in: acdb8f6f user: drh tags: printf-optimization | |
|
2017-01-03
| ||
| 21:57 | Use compiler intrinsic functions for signed integer math when overflow detection is needed. check-in: d3ac32a6 user: drh tags: trunk | |
| 21:50 | Back out the use of __sync_fetch_and_sub() as it does not appear to work. Closed-Leaf check-in: 4c2efd42 user: drh tags: gnu-safe-math | |
| 21:03 | Fix a typo in a comment. check-in: ae087123 user: drh tags: gnu-safe-math | |
| 20:01 | Use the CLANG_VERSION macro to control clang-specific features. check-in: f8ebeec2 user: drh tags: gnu-safe-math | |
| 18:05 | Use the GCC built-in __sync_fetch_and_sub() to make the sqlite3StatusDown() routine atomic, and thereby avoid some mutexing. check-in: f69ce75b user: drh tags: gnu-safe-math | |
| 17:33 | Make use of the __buildin_OP_overflow() functions from GCC when doing 64-bit signed integer arithmetic. check-in: 82cbebb8 user: drh tags: gnu-safe-math | |
| 14:45 | Add the experimental affinity() SQL function when SQLITE_DEBUG is defined. check-in: bed0eaa5 user: drh tags: trunk | |
| 14:39 | Put the affinity() function implementation inside of #ifdef SQLITE_DEBUG. Closed-Leaf check-in: f778f58a user: drh tags: affinity-sql-func | |
| 14:30 | Merge all the latest changes from trunk. check-in: c27cd8a8 user: drh tags: affinity-sql-func | |
| 13:45 | Defer size checking on row-value assignments for when the RHS is a SELECT until after the "*" wildcards have been expanded. check-in: 36944be6 user: drh tags: trunk | |
| 11:59 | Fix a typo on a comment. No code changes. check-in: abc27b60 user: drh tags: trunk | |
| 08:11 | Add test cases for the fix in [f12ed3ce]. No problems discovered. check-in: 548532fd user: dan tags: trunk | |
| 02:58 | Improvements to the way vector assignment size checking is done. Size checks when the RHS is a SELECT are deferred until after "*" wildcards are expanded. Closed-Leaf check-in: 696219b1 user: drh tags: vector-size-check | |
| 01:24 | Fix the row-values in UPDATE statements within TRIGGER problem identified by ticket [8c9458e7]. check-in: f12ed3ce user: drh tags: trunk | |
| 00:27 | Improved assert()s on the sqlite3ExprListDup() logic for TK_SELECT_COLUMN. Closed-Leaf check-in: 14da99d4 user: drh tags: rowvalue-update-trigger | |
|
2017-01-02
| ||
| 23:43 | Test cases for the row-value UPDATE TRIGGER fix. check-in: b9b96437 user: drh tags: rowvalue-update-trigger | |
| 23:18 | Put an ALWAYS() on an unreachable branch in the sqlite3ExprListDup() routine. check-in: 2caaaab5 user: drh tags: rowvalue-update-trigger | |
| 22:36 | Proposed fix for the row-value TRIGGER UPDATE problem described in ticket [8c9458e7]. check-in: 61a442ea user: drh tags: rowvalue-update-trigger | |
| 19:10 | Increase the version number to 3.17.0 for the next release cycle. check-in: 16415b5a user: drh tags: trunk | |
| 19:02 | Provide the SQLITE_DEFAULT_LOOKASIDE compile-time option and make it's default value be 1200,100 (raised from 512,125 in the latest release). check-in: 584da48f user: drh tags: trunk | |
| 18:40 | Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, which is experimentally determined to be slightly faster. check-in: 12d9493c user: drh tags: trunk | |
| 18:19 | Avoid unnecessary calls to sqlite3BtreeEnterAll() and sqlite3BtreeLeaveAll() when no btree is using shared-cache. check-in: cfb31582 user: drh tags: trunk | |
| 12:20 | Add the --all option to the wordcount test program. Fix the speedtest1 test program so that it builds on MSVC and so that the --lookaside 0 0 option works. check-in: cb338f36 user: drh tags: trunk | |
| 11:57 | Version 3.16.0 check-in: 04ac0b75 user: drh tags: trunk, release, version-3.16.0 | |
|
2017-01-01
| ||
| 12:44 | Detect row-value comparison size mismatches even when the size of one operand is obscured by an unexpanded subquery. check-in: 2c4d167c user: drh tags: trunk | |
|
2016-12-31
| ||
| 21:55 | Add the --help and --all options to the wordcount test utility. Closed-Leaf check-in: 18baeadf user: drh tags: wordcount-enhancement | |
| 18:37 | In speedtest1.c, make the "--lookaside 0 0" option completely disable lookaside. Closed-Leaf check-in: 52b99bcb user: drh tags: speedtest1 | |
| 14:33 | Minor #include change to speedtest1.c so that it will compile under MSVC. check-in: 8c28fde0 user: drh tags: speedtest1 | |
|
2016-12-30
| ||
| 17:40 | Fix a crash that could occur following an OOM in the group_concat() function if the second argument is an SQLITE_BLOB value. check-in: 14d855d2 user: dan tags: trunk | |
| 15:16 | Strengthen the defense against OOM in the instr() SQL function. check-in: a0971e71 user: drh tags: trunk | |
| 14:25 | Add a test to ensure that the app-defined pcache xFetch() method is never passed a key of zero. check-in: 0bdbe49c user: drh tags: trunk | |
| 14:15 | Avoid passing NULL pointers to memcmp() or memcpy(), even when the "number-of-bytes" argument is passed 0. check-in: 56ff72ab user: dan tags: trunk | |
| 12:10 | Fix a harmless compiler warning in fuzzcheck.c check-in: 2842bc60 user: drh tags: trunk | |
| 12:06 | Disable the pagerAcquireMapPage() routine if memory-mapped I/O is disabled. This fixes a harmless compiler warning on OpenBSD. check-in: 3e25ba6e user: drh tags: trunk | |