SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2017-02-25
20:57
[ffd61fb4] Leaf: Add an 'extern "C"' block to header file sqlite3userauth.h. (user: dan, tags: trunk)
17:47
[4cd2a967] Optimize defragmentPage() in the case where the page contains either one or two free-blocks and a small number of fragmented bytes. (user: dan, tags: trunk)
16:24
[f9863b39] Closed-Leaf: Tweak the code on this branch to detect b-tree page corruption in the same cases as the trunk. (user: dan, tags: defragmentpage-opt)
2017-02-24
19:58
[202b1c02] Optimize defragmentPage() in the case where the page contains either one or two free-blocks and a small number of fragmented bytes. (user: dan, tags: defragmentpage-opt)
2017-02-23
16:30
[a8fd7052] Save a few bytes and a few cycles by setting Vdbe.expmask to zero for statements prepared using legacy interface sqlite3_prepare(). (user: dan, tags: trunk)
2017-02-22
19:49
[fe073905] Merge integrity_check and other improvements from trunk. (user: drh, tags: auto-analyze)
19:41
[d6afd98d] Move a branch condition in analyze.c inside an #ifdef SQLITE_ENABLE_STAT4 block. (user: dan, tags: trunk)
19:27
[737a8244] Improve the performance of ANALYZE when SQLITE_ENABLE_STAT4 is defined. (user: dan, tags: trunk)
18:53
[aa02bd3c] Improvements to PRAGMA integrity_check. Verify CHECK constraints. Verify NOT NULL constraints even on table that lack indexes. Verify CHECK and NOT NULL constraints with PRAGMA quick_check. (user: drh, tags: trunk)
18:04
[5af7d72e] Closed-Leaf: Cleanup and simplification of the output row count limit control of PRAGMA integrity_check. (user: drh, tags: integrity-check-improvements)
14:15
[549bae08] Enhance "PRAGMA integrity_check" so that it verifies CHECK constraints. (user: drh, tags: integrity-check-improvements)
2017-02-21
21:24
[80adc0cb] In sqlite3VdbeHalt(), return as soon as possible if Vdbe.magic!=VDBE_MAGIC_RUN. This makes sqlite3_reset() slightly faster in some cases. (user: dan, tags: trunk)
17:52
[e400909f] Fix an FTS5 problem that could cause a crash when certain queries were interrupted using sqlite3_interrupt(). (user: dan, tags: trunk)
15:27
[3c3228ed] Very small enhancement to dispatch speed for SQL functions. (user: drh, tags: trunk)
14:04
[7a62fc6a] Leaf: The VDBE cycle counts for the sqlite3_progress_handler() callback are now cumulative. Leftovers from the previous statement are applied to the next statement. (user: drh, tags: cumulative-progress-count)
13:29
[9626b41e] Leaf: Proof of concept for a "PRAGMA vdbe_cycle_limit=N" command. When N>0, invoke sqlite3_interrupt() whenever any byte code program uses more than N virtual machine cycles. (user: drh, tags: vdbe_cycle_limit)
2017-02-20
23:32
[1589db01] Correct a harmless typo in the previous check-in. (user: mistachkin, tags: trunk)
19:13
[96b6a98e] Avoid unsigned integer overflows for SQLITE_WIN32_HEAP_INIT_SIZE when the Win32 heap subsystem is used with very large values of SQLITE_DEFAULT_CACHE_SIZE and/or SQLITE_DEFAULT_PAGE_SIZE. (user: mistachkin, tags: trunk)
14:30
[0d8a868a] Small grammar simplification. (user: drh, tags: trunk)
13:11
[ff213f2e] Merge fixes from trunk. (user: drh, tags: auto-analyze)
2017-02-18
20:05
[c1adf959] Leaf: Add an optimization to OP_Column to speed up sequential OP_Column instructions that read earlier fields from the same cursor. Attempt to reorder OP_Column opcodes so as to take advantage of this. (user: dan, tags: sort-column-opcodes)
13:47
[49181427] Add the SQLITE_BUG_COMPATIBLE_20160819 compile-time option to omit the error message when an unrecognized argument is provided to the VACUUM command. (user: drh, tags: trunk)
2017-02-17
23:52
[8cc9d74c] Fix the #endif location for an #ifndef SQLITE_UNTESTABLE macro in the command-line shell. (user: drh, tags: trunk)
13:38
[85026c8e] Enhance the Index and Table objects so that they remember if their stats come from the sqlite_stat1 table. Make the "PRAGMA stats" an SQLITE_DEBUG only pragma. Add the flags column to "PRAGMA stats". These are all preliminary steps toward a "PRAGMA analyze_ifneeded;" feature. (user: drh, tags: auto-analyze)
02:07
[662e8ccf] Leaf: Merge fixes from trunk. (user: drh, tags: increased-sorting-cost)
02:04
[218b2bbb] Fix a test case that was made to fail by the LIKE optimization enhancement in check-in [158290c0ab] but which went unnoticed because test builds were running with ICU enabled and ICU disables the LIKE optimization. (user: drh, tags: trunk)
01:43
[8a03be1d] Enable the ".wheretrace" and ".selecttrace" extensions in the command-line shell when compiled on Windows using DEBUG=3 or higher. Fix a harmless warning in the shell that comes up when compiled this way. (user: drh, tags: trunk)
2017-02-16
21:29
[aa0703e5] Increase the estimated cost of sorting when sorting wide results sets, to account for the extra storage space and I/O required for the external sort. (user: drh, tags: increased-sorting-cost)
20:52
[9fc5cd50] Change the name of WhereInfo.pDistinctSet to pResultSet, since it is now used for more than just DISTINCT processing. (user: drh, tags: trunk)
17:18
[ff5e733c] Change two MallocZero() calls into MallocRaw() to avoid unnecessary memset(). (user: drh, tags: trunk)
16:26
[bb8e2642] Fix a comment on a field of the ExprList object. No changes to code. (user: drh, tags: trunk)
15:57
[7e14044c] Increase Table.tabFlags from 8 to 32 bits. (user: drh, tags: trunk)
15:06
[6bd82b95] Remove two redundant initializations from the virtual table logic. (user: drh, tags: trunk)
14:48
[6affb1c8] Always use the IsVirtual() macro to determine if a Table object is a virtual table. Slightly smaller and faster code. (user: drh, tags: trunk)
14:02
[325ccfa9] Leaf: Merge recent enhancements from trunk. (user: drh, tags: est_count_pragma)
2017-02-15
22:36
[58797e9b] Query planner optimization to detect empty tables in a join early and bail out without doing excess work. (user: drh, tags: trunk)
18:30
[830b9235] Minor enhancement to mutex tracing on Win32. (user: mistachkin, tags: trunk)
16:11
[a2b4f60b] Add the companion "carray_asc" table-valued function to the carray extension. (user: drh, tags: carray_asc)
15:09
[810d2932] Remove the CLANG_VERSION macro, since we have learned that version numbers in clang are "marketing" and are inconsistent and unreliable. Builds using clang will still use the GCC_VERSION macro since clang works hard to be gcc compatible. (user: drh, tags: trunk)
04:16
[ee1e6896] Further reforms to Tcl_*Alloc() usage. (user: mistachkin, tags: trunk)
01:39
[1d267757] In the blob test code, avoid crashing on low-memory systems by using Tcl_AttemptAlloc(). (user: mistachkin, tags: trunk)
2017-02-14
23:58
[80481754] Experimental enhancements to mutex debugging. (user: mistachkin, tags: mutexDbg2)
21:47
[ca4f1e49] Clarification of the help text for the command-line shell. (user: drh, tags: trunk)
20:00
[54836270] Enable the SQLITE_ENABLE_NULL_TRIM option for WITHOUT ROWID tables. (user: drh, tags: trunk)
16:30
[e4731fd6] More realistic lengths of string values in speedtest1 with --testset orm. (user: drh, tags: trunk)
15:58
[58b2f911] Fix a testcase number on the ORM testset of speedtest1. (user: drh, tags: trunk)
15:57
[1836adc1] Add the new "--testset orm" to the speedtest1 utility. (user: drh, tags: trunk)
2017-02-13
13:35
[670f10b2] Change all legacy instances of "#if SQLITE_DEBUG" to "#ifdef SQLITE_DEBUG" for consistency. (user: drh, tags: trunk)
13:26
[f3b65926] Fix typos in using the MSVC_VERSION macro. (user: drh, tags: trunk)
13:20
[c447441c] Avoid a duplication #define in FTS5 (user: drh, tags: trunk)
2017-02-11
14:59
[e464b919] Fix indexes on expressions so that they can be actually used with a COLLATE clause. (user: drh, tags: trunk)
13:51
[9689d04b] Ensure that indexed expressions with collating sequences are handled correctly. Proposed fix for ticket [eb703ba7b50c1a5]. (user: drh, tags: trunk)
2017-02-10
21:40
[7520c238] Bump the version number up to 3.18.0. (user: drh, tags: trunk)
21:37
[158290c0] Enhance the LIKE optimization so that it works for arbitrary expressions on the LHS as long as the pattern on the RHS does not begin with a digit or a minus sign. (user: drh, tags: trunk)
19:38
[064445b1] Add the "," flag to printf(). (user: drh, tags: trunk)
17:38
[ad867e87] Version 3.17.0 release candidate (user: drh, tags: branch-3.17)
2017-02-09
17:12
[798fb9d7] Cleanup the usage of the SQLITE_DISABLE_INTRINSIC compile-time option. Remove the SQLITE_RUNTIME_BYTEORDER compile-time option. Use -DSQLITE_BYTEORDER=0 instead. Fix a bug in R-Tree that occurs when compiling on a known little-endian machine without the use of intrinsic byteswapping functions. (user: drh, tags: trunk)
2017-02-08
19:12
[1afec575] Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is executed against an fts3 table. (user: dan, tags: trunk)
19:10
[9962c10a] Leaf: Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is executed against an fts3 table. (user: dan, tags: fts3-seekstmt-cache)
18:13
[c09dd5c0] Typo fixes in comment. No changes to code. (user: mistachkin, tags: trunk)
16:55
[92dbd875] Merge the 3.17.0beta changes from trunk. (user: drh, tags: apple-osx)
16:01
[77b470b0] Always invoke the xRoundup() method of the memory allocator before calling xMalloc(). (user: drh, tags: trunk)
12:18
[c46e06fa] Round up the size of all memory allocations to a multiple of 8 bytes when using the system memory allocator. (user: drh, tags: trunk)
2017-02-07
21:44
[c8bfd99b] When generating the hash on the sqlite_master table in dbselftest, use an ORDER BY clause, since the sqlite_master table is reordered by VACUUM. (user: drh, tags: trunk)
21:09
[fc1dfe87] MSVC makefile enhancments for several command line tools and the session extensions. (user: mistachkin, tags: trunk)
21:00
[61242267] Fix harmless compiler warnings in dbfuzz. (user: drh, tags: trunk)
20:57
[db6b3993] Fix harmless compiler warnings in kvtest.c (user: drh, tags: trunk)
20:51
[e68829c9] The dbselftest utility now generates hashes in the selftest table with --init. It also accepts multiple database files on the command-line. (user: drh, tags: trunk)
19:36
[cb1e83f9] Omit fts5fault1.test from the inmemory_journal permutation. (user: dan, tags: trunk)
19:23
[be82d5ae] Update a test parameter in malloc5.test to account for the increase in default lookaside buffer size. (user: dan, tags: trunk)
17:36
[1fcac836] Add the initial version of the "dbselftest" utility program. (user: drh, tags: trunk)
16:15
[722e57fe] Update an error message in corruptC.test. (user: dan, tags: trunk)
14:45
[bb7f445b] Fix a build problem affecting non-amalgamation rtree builds. (user: dan, tags: trunk)
14:22
[e11cc523] Fix a test case to account for the fact that sqlite3_blob_reopen() now returns SQLITE_IOERR_NOMEM instead of SQLITE_NOMEM if an OOM occurs in the VFS layer. (user: dan, tags: trunk)
13:51
[a136609c] Fix SQLITE_BYTEORDER #defines in R-Tree when compiled separately from the amalgamation. (user: drh, tags: trunk)
12:58
[07fe6228] Make the cellMargin() routine of R-Tree slightly smaller and faster while also fixing a harmless compiler warning. (user: drh, tags: trunk)
03:44
[0611770d] Back out [ec8ff892ac] which is causing missed OOM errors on some tests. (user: drh, tags: trunk)
00:55
[f77ee9e9] Fix a minor typo in a comment in R-Tree. No changes to code. (user: drh, tags: trunk)
2017-02-06
16:52
[e5aea894] Remove a small amount of unnecessary code from R-Tree. (user: drh, tags: trunk)
15:27
[c54173b6] Add the "max-limits" utility program to the tools/ subdirectory. (user: drh, tags: trunk)
07:37
[6b0276f9] Fix a bug in kvtest causing "init --variance 0" runs to generate single byte blob values only. (user: dan, tags: trunk)
01:19
[853a58a7] Remove incorrect testcase() macros from R-Tree. (user: drh, tags: trunk)
2017-02-04
20:15
[ec8ff892] Simplification to the error handling to extension loading in sqlite3_open(). (user: drh, tags: trunk)
17:33
[b20ff81f] Allow sqlite3session_apply() to apply changesets to tables that have been extended using ALTER TABLE ADD COLUMN. (user: dan, tags: trunk)
15:29
[6c3f0902] Merge recent trunk enhancements. (user: drh, tags: apple-osx)
14:30
[61bd2a88] Leaf: Merge the latest trunk changes, especially the RTREE enhancement to use sqlite3_blob objects. (user: drh, tags: sqlite3_blob_reset)
14:24
[97ccf3e4] In RTREE, use an sqlite3_blob object rather than an sqlite3_stmt object for reading content out of the %_node shadow table. (user: drh, tags: trunk)
13:12
[95ee745f] Closed-Leaf: Close sqlite3_blob objects on xSync rather than waiting until xCommit. (user: drh, tags: rtree-blob-agressive-release)
2017-02-03
20:54
[5706d470] Improved performance and stack usage when processing VALUES clauses with a very large number of rows. (user: drh, tags: trunk)
19:16
[f5306ad6] Closed-Leaf: Avoid a performance problem when very large "VALUES(..), (..), (..)" terms are used in queries. (user: dan, tags: recursive-selectdup)
15:16
[83a099f1] Improved tests for the carray() table-valued function. (user: drh, tags: trunk)
14:44
[a7674ead] Modify the sqlite3SelectDup() routine to avoid recursing on Select.pPrior. (user: dan, tags: recursive-selectdup)
2017-02-02
23:57
[53b77838] Add the sqlite3_blob_reset() interface. Enhance the behavior of sqlite3_blob objects so that they can go active again after encountering an error by rerunning sqlite3_blob_reopen(). More work needed on the documentation. (user: drh, tags: sqlite3_blob_reset)
20:32
[8e03a8e9] Ensure that all cursors have their positions saved prior to rolling back a savepoint. (user: drh, tags: trunk)
19:24
[5a0da77c] Fix issues in the sha1 extension seen with MSVC. (user: mistachkin, tags: trunk)
00:46
[01d97e5b] Closed-Leaf: This is an experimental patch that ensures that all cursors have their position saved prior to starting a ROLLBACK TO. (user: drh, tags: savepoint-rollback)
2017-02-01
23:06
[0c66cf0f] Fix harmless compiler warnings seen with MSVC. (user: mistachkin, tags: trunk)
23:03
[aaae74d0] Backout the change in [02f6293f27] as it causes MSVC to complain. (user: mistachkin, tags: trunk)
22:59
[54d28546] Fix C99-style variable declaration issue seen with older versions of MSVC. (user: mistachkin, tags: trunk)
22:43
[997f765b] Closed-Leaf: Fix harmless compiler warnings seen with MSVC. (user: mistachkin, tags: msvcWarn)
22:32
[6a378c29] Add an option to the MSVC makefile to enable treating warnings as errors. (user: mistachkin, tags: trunk)
17:08
[4854ea9c] Unwind the RTREE dimension loop inside of rtreeCallbackConstraint(). (user: drh, tags: trunk)
16:41
[3c4c0126] Completely unroll the dimension loop inside of cellArea() in RTREE. (user: drh, tags: trunk)
15:49
[f1f3c8cc] Precompute the nDim2 value in the Rtree object and use that to make loops over coordinates faster. (user: drh, tags: trunk)
15:24
[82fcd54a] Use compiler intrinsic functions (when available) for byteswapping in RTREE. (user: drh, tags: trunk)
15:19
[510933cb] Fix the build by making the OPFLAG_ISNOOP macro available unconditionally. (user: drh, tags: trunk)
14:19
[7f857020] Update the documentation comment in sqlite.h.in for sqlite3_preupdate_hook(). (user: dan, tags: trunk)
14:10
[964bdc27] Changes so that the pre-update hook and the sessions module work with WITHOUT ROWID tables. (user: dan, tags: trunk)
02:25
[c5395e74] More RTREE performance optimizations related to decoding values. (user: drh, tags: trunk)
01:34
[9663eea2] Improved comments on the statGet() implementation in ANALYZE. No changes to code. (user: drh, tags: trunk)
2017-01-31
21:22
[0bf7b518] R-TREE optimization: unwrap the coordinate decode loop in rtreeCallbackConstraint(). (user: drh, tags: trunk)
19:10
[85dddf2b] Very small performance improvements and size reductions in sqlite3VdbeExec() and blobSeekToRow(). (user: drh, tags: trunk)
19:02
[495ea824] Closed-Leaf: Simplifications to blobSeekToRow(). (user: drh, tags: micro-optimizations)
17:31
[25f1275f] Leaf: Add a speed-test program for the sessions module. (user: dan, tags: preupdate-without-rowid)
16:34
[02f6293f] Remove an unnecessary initialization of the pOp variable in sqlite3VdbeExec(). (user: drh, tags: micro-optimizations)
15:29
[b63deed6] Add the "stat" command to kvtest.c. Also add the --variance option to the "init" command. Add the tool/kvtest-speed.sh script used for doing performance testing on key/value access patterns. (user: drh, tags: trunk)
15:27
[bd22bf9c] Fix a typo in a comment. (user: drh, tags: trunk)
14:08
[4a592abb] Merge latest trunk with this branch. (user: dan, tags: preupdate-without-rowid)
12:41
[eacfdcf2] Further minor enhancement and size reduction in sqlite3ExprAssignVarNumber(). (user: drh, tags: trunk)
03:52
[5987ca1f] Performance optimization in sqlite3ExprAssignVarNumber(). (user: drh, tags: trunk)
2017-01-30
19:44
[856f8604] Experimental change to invoke the preupdate hook when WITHOUT ROWID tables are written. (user: dan, tags: preupdate-without-rowid)
11:38
[e93d2c49] Fix building with SQLITE_OMIT_FOREIGN_KEY defined. (user: dan, tags: trunk)
2017-01-28
20:46
[4fe879d4] In the amalgamation, allocate the parser engine object from stack rather than from heap, for improved performance. This only happens in the amalgamation, since otherwise the sqlite3RunParser() routine does not know the object size. (user: drh, tags: trunk)
19:53
[2a2e7d86] Fix a couple comment typos. No changes to code. (user: mistachkin, tags: trunk)
19:45
[dc555b10] Avoid redundant table b-tree cursor seeks in UPDATE statements that use the two-pass strategy. (user: dan, tags: trunk)
15:26
[426b440a] Updates to the sqlite3_blob documentation. No changes to code. (user: drh, tags: trunk)
13:40
[aa1ab371] In the speed-check.sh script, automatically invoke "fossil test-diff --tk" on the cachegrind output against trunk, if not generating a trunk run. (user: drh, tags: trunk)
06:50
[7c029655] Fix a typo in the docs for sqlite3_update_hook(). (user: dan, tags: trunk)
2017-01-27
19:27
[24e77c1c] Add the sha1.c loadable extension that implements the sha1() and sha1_query() SQL functions. (user: drh, tags: trunk)
17:02
[fbb6bf1b] Fix a problem causing the pre-update hook to be invoked by DROP TABLE statements. (user: dan, tags: trunk)
16:39
[0e14fe1b] Merge all recent trunk enhancements into the apple-osx branch. (user: drh, tags: apple-osx)
16:24
[fe86ff54] Merge all recent enhancements from trunk. (user: drh, tags: est_count_pragma)
13:14
[d9752c8f] Alternative ICU fix (compare to check-in [50e60cb4]) that avoids casting integers to pointers. (user: drh, tags: trunk)
01:52
[58f02e6e] In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl". (user: drh, tags: trunk)
01:25
[c012619b] Another micro-optimization in accessPayload(). Slightly smaller and faster. (user: drh, tags: trunk)
01:13
[ebb1fd98] Performance optimization in accessPayload(). (user: drh, tags: trunk)
00:31
[68e7a8c6] Simplify the accessPayload() routine so that it always populates the overflow page cache. In the one case where populating the page cache can lead to problems, simply invalidate the cache as soon as accessPayload() returns. This simplification reduces code size and helps accessPayload() to run a little faster. This backs out the eOp==2 mode of accessPayload() added by check-in [da59198505]. (user: drh, tags: trunk)
2017-01-26
21:30
[293bf3ed] Remove an unreachable branch in the error handling logic for sqlite3BtreePayloadChecked(). (user: drh, tags: trunk)
18:00
[b4a98f65] Improvement to the OP_Permutation opcode to prevent it from using CPU cycles for initialization in prepared statements that do not use that opcode. (user: drh, tags: trunk)
17:26
[b4803184] Remove the obsolete lastRowid cache from the sqlite3VdbeExec() for a size reduction and performance improvement. (user: drh, tags: trunk)
17:11
[1e96e5ec] Performance optimization in sqlite3VdbeCloseStatement(). (user: drh, tags: trunk)
16:54
[7459f4b7] Performance optimization to sqlite3_blob_read(). (user: drh, tags: trunk)
16:27
[3e96d6ef] Minor simplification and performance optimization for Direct Overflow Read. (user: drh, tags: trunk)
02:26
[9879be18] Make SQLITE_DIRECT_OVERFLOW_READ work for in WAL mode as long as the page being read is not in the the -wal file. (user: drh, tags: trunk)
01:54
[62a4851c] Enhancements to the kvtest utility program. Add the --jmode option. Improved output formatting. (user: drh, tags: trunk)
00:58
[50e60cb4] Modify the ICU extension to use a static initializer, as VC++ complains about a dynamic initialization. Maybe the dynamic structure initialization is a GCC extension. This fixes a problem identified on the SQLite mailing list by Ziemowit Laski. (user: drh, tags: trunk)
2017-01-25
20:55
[4801bd59] Trim NULL values off the end of records when the SQLITE_ENABLE_NULL_TRIM compile-time option is used. Increase the size of the P5 operand to 16 bits. Fix a problem with short records in the sessions extension. (user: drh, tags: trunk)
18:53
[c7651d21] Closed-Leaf: Fix another pre-update hook issue, this time in sqlite3preupdate_old(). (user: dan, tags: trim-nulls)
14:58
[118ded40] Experimental enhancement to automatically trim NULL values from the end of records, for a reduced disk footprint. This change also involves increasing the P5 operand from 8 to 16 bits. (user: drh, tags: trim-nulls)
14:38
[8cd1a445] Ensure that sqlite3_blob_reopen() correctly handles short rows. Fix for ticket [e6e962d6b0f06f46e]. (user: drh, tags: trunk)
13:54
[0803390c] Fix SQLITEINT_H macro usage in two extensions. (user: drh, tags: trunk)
04:41
[57d8dad3] Closed-Leaf: Ensure that sqlite3_blob_reopen() correctly handles short rows. Proposed fix for ticket [e6e962d6b0f06f46e]. Further testing needed. (user: drh, tags: blob_reopen-fix)
2017-01-23
21:12
[64131724] Leaf: Experimental changes to permit a VFS to directly override the initial page size. (user: mistachkin, tags: pagePerSector)
19:11
[175bda87] Document the --mmap option in the --help screen for kvtest. Enhance kvtest so that numeric arguments can have suffixes like "K" or "M". Add kvtest to the unix makefiles. (user: drh, tags: trunk)
18:40
[4948f7e6] Add the --mmap option to the kvtest utility program. (user: drh, tags: trunk)
16:56
[ee793d30] Optimization: Try to avoid unnecessary btree searching when repositioning a cursor to the next row. (user: drh, tags: trunk)
15:58
[7a4f512d] Add the missing SQLITE_API symbol to test_delete.c (it is not added automatically as this file is not part of the amalgamation). (user: dan, tags: trunk)
07:06
[03c60134] Fix a problem preventing FTS5 from correctly passing the FTS5_TOKENIZE_PREFIX flag to custom tokenizer implementations. (user: dan, tags: trunk)
2017-01-22
16:34
[06b8001a] Fix an uninitialized variable in the command-line shell. (user: drh, tags: trunk)
02:04
[772dcb08] Fixes to documentation comments in the public header file. (user: mistachkin, tags: trunk)
00:11
[ed62c5a6] Fix an initialized variable in kvtest. (user: drh, tags: trunk)
2017-01-21
21:47
[2c4ecb85] Closed-Leaf: A better implementation of the moveto-neighbor optimization that checks for nearby rows on adjacent pages. (user: drh, tags: btree-moveto-neighbor)
16:54
[8e5cfb20] B-tree optimization: When seeking on a rowid table that has already been positioned, check to see if the new row happens to be the next row on the same leaf page. That is a reasonably common case, and if it is true it avoids a full binary search. (user: drh, tags: btree-moveto-neighbor)
16:27
[347df3c1] Change sqlite3_blob_reopen() to call sqlite3VdbeExec() directly rather than going through sqlite3_step(). Performance enhancement. (user: drh, tags: trunk)
15:58
[ffda1d1e] Add extra (somewhat inefficient) trace callbacks for triggers if SQLITE_TRACE_TRIGGER is defined. (user: dan, tags: trigger-trace)
15:55
[0d1ad13a] 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. (user: drh, tags: trunk)
15:30
[4cda3b30] Leaf: A proof-of-concept for running sqlite3_blob_open() without using OP_Column when operating on a pure key/value table. This demo does not include any corrupt database checking. Uses about 3% fewer CPU cycles on a key/value performance test. (user: drh, tags: kv-access-opt-demo)
14:11
[9d197a53] Remove an unnecessary sqlite3_bind_int64() call from sqlite3_blob_open(). Also other minor refactoring of the sqlite3_blob implementation. (user: drh, tags: trunk)
2017-01-20
20:43
[264e5c10] Minor performance optimization and size reduction to the accessPayload() routine in btree.c. (user: drh, tags: trunk)
16:47
[8971d98f] Fix a typo in the help message for kvtest. (user: dan, tags: trunk)
16:46
[90291327] Add option "--stats" to test program kvtest. Specifying --stats causes kvtest to output information similar to the shell tool option of the same name. (user: dan, tags: trunk)
16:09
[87b640c8] Get the "--testset rtree" option working on speedtest1. Add the --rtree, --lookaside, and --clang options to the speed-check.sh script. (user: drh, tags: trunk)
00:40
[52a61967] Minor performance optimizations to sqlite3_blob_open() and sqlite3_blob_reopen(). (user: drh, tags: trunk)
2017-01-19
21:20
[9ed38521] 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. (user: drh, tags: trunk)
18:20
[ffd559af] In the 'vtshim' extension, avoid accessing freed memory when handling errors from xCreate/xConnect. (user: mistachkin, tags: trunk)
2017-01-18
22:47
[a84a08d0] In the 'windirent' test module, use a macro for the hidden/system attribute checking. (user: mistachkin, tags: trunk)
22:19
[b92cc6e5] Remove superfluous option to Tcl 'lsort' in the vtabH test file. (user: mistachkin, tags: trunk)
22:16
[d3c91c1f] Make the vtabH-3.1 test more portable and robust. (user: mistachkin, tags: trunk)
22:16
[26dd42b4] Fix handling of initial hidden and/or system files in the opendir() implementation for Windows. No changes to non-test code. (user: mistachkin, tags: trunk)
20:14
[2a8f6c89] Add temporary code to record and report on the set of b-tree pages read and written by the current transaction. This is likely still buggy. (user: dan, tags: transaction-pages)
17:20
[a435841e] Baseline interface definition for the experimental sqlite3_kv accessor object. (user: drh, tags: sqlite3_kv)
2017-01-17
10:41
[681d96eb] 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] 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
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)
16:52
[381fd34b] Attempt to detect physical sector sizes on Windows 8 and higher. (user: mistachkin, tags: winSectorSize)