/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

200 most recent check-ins using file test/shared3.test version fcd65cb1

2018-12-19
16:03
Add interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. Cherrypick from commit [8201f4e1] on branch-3.18. Leaf check-in: 4cb67252 user: dan tags: branch-3.9
01:57
Add extra defenses against strategically corrupt databases to fts3/4. check-in: 882ef4e3 user: drh tags: branch-3.9
2018-12-14
20:28
Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. (Backported fix from version 3.14.0). Leaf check-in: 11368e67 user: drh tags: branch-3.8.9
20:20
Add the OP_ColumnsUsed opcode (when compiled with SQLITE_ENABLE_COLUMN_USED_MASK) as a hint to the b-tree layer as to which columns of a btree cursor will be used. (Backport from 3.8.11) check-in: b29e02f8 user: drh tags: branch-3.8.9
2018-02-02
16:46
Enable the ".wheretrace" and ".selecttrace" options in the shell when configure is run using --enable-debug. This mirrors a similar change that has already occurred on trunk. Leaf check-in: c4f798b2 user: drh tags: branch-3.9.2
2017-11-14
18:26
Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. This is a modified cherrypick of [dae4a97a]. check-in: b2679d3b user: dan tags: branch-3.8.9
2017-11-09
04:13
Disallow ORDER BY and LIMIT on UPDATE and DELETE of views and WITHOUT ROWID tables. This is a temporary fix for ticket [d4beea1633f1b88f] until a better solution can be found. check-in: 30aa941f user: drh tags: branch-3.8.9
2017-07-27
22:16
Enhance the like optimization so that it works with an ESCAPE clause. check-in: 2495acf7 user: drh tags: branch-3.8.9
2017-07-21
07:45
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is a cherry-pick of [f0f49224] with version-specific edits. That check-in was inspired by check-in [72de49f2]. check-in: 69906880 user: drh tags: branch-3.9.2
04:08
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f49224] which was in turn inspired by [72de49f2]. Leaf check-in: 5a3022e0 user: drh tags: branch-3.8.10
03:23
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f492245e95], which is in turn inspired by check-in [72de49f2]. Leaf check-in: a66a5b39 user: drh tags: branch-3.8.6
2017-07-17
19:37
Try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. This is a cherry-pick of [6df18e949d36] with bug fixes. check-in: cd6ac078 user: drh tags: branch-3.8.9
19:25
When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. Closed-Leaf check-in: adc082c1 user: drh tags: push-down-backport
19:14
Do not apply the WHERE-clause pushdown optimization to terms that originate in the ON or USING clause of a LEFT JOIN. Fix for ticket [c2a19d81652f40568c]. check-in: 52674f94 user: drh tags: push-down-backport
19:07
For FROM-clause subqueries that cannot be flattened, try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. Cherry-pick from [6df18e949d36]. Still need to backport bug fixes associated with that check-in. check-in: 043d6ce8 user: drh tags: push-down-backport
2017-07-08
01:01
Fix the covering index OR optimization (check-in [fcbd6abd]) so that it works with SQLITE_MAX_ATTACHED>30. Broken by a bad cherry-pick merge. check-in: d227de8a user: drh tags: branch-3.8.9
2017-07-05
16:20
Make use of covering indexes in the OR optimization. check-in: fcbd6abd user: drh tags: branch-3.8.9
14:54
Add the count-of-view optimization when compiled using SQLITE_COUNTOFVIEW_OPTIMIZATION. check-in: b7ae4b87 user: drh tags: branch-3.8.9
2017-06-06
18:22
Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. check-in: 802b82f3 user: drh tags: branch-3.8.9
2017-05-24
04:32
Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. check-in: 19dad0a7 user: drh tags: branch-3.8.9
2017-05-22
00:27
When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. check-in: 962531e7 user: drh tags: branch-3.8.9
2017-01-11
14:21
In the STAT4 computations, ensure that the aAvgEq values do not go negative. check-in: 4f83f680 user: drh tags: branch-3.8.9
2016-11-02
16:29
When the block sorting optimization is used in a scalar subquery, be sure to exit the loop as soon as the first valid output row is received. Fix for ticket [cb3aa0641d9a4] backported to the 3.8.9 branch. check-in: 8e4ba115 user: drh tags: branch-3.8.9
2016-09-23
18:06
Fix the ORDER BY LIMIT optimization backport so that it works when the ORDER BY uses the DESC direction. check-in: 0c3cafb7 user: drh tags: branch-3.8.9
2016-09-14
01:43
Backport the ORDER BY LIMIT optimization to version 3.8.9. check-in: db361482 user: drh tags: branch-3.8.9
2016-08-10
03:35
Try to make pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. Leaf check-in: 9ab53605 user: drh tags: debug
02:54
Remove all timers and other debugging logs except for the one timer on pcache1TruncateUnsafe(). check-in: 5980e625 user: drh tags: debug
2016-08-09
11:44
Add another timer on pcache1TruncateUnsafe(). check-in: 42ce53f6 user: drh tags: debug
11:23
Add a debug timer to pcache1Truncate(). Change the formatting of some other messages to make them easier to read. check-in: 7d0af4b5 user: dan tags: debug
01:21
Refocus the timer on the pager_end_transaction() routine. check-in: 9d4eb6e4 user: drh tags: debug
2016-08-04
14:08
Add extra logging calls to this branch. check-in: 491f1ef3 user: dan tags: debug
2016-07-30
03:33
A new version of the slow mutex log that uses gettimeofday() instead of trying to access the hardware timer. check-in: 92b9fead user: drh tags: debug
2016-07-29
16:32
Turn memory status off by default. check-in: ea3c7162 user: drh tags: debug
14:31
Enhance a debugging log message to better identify a mutex. check-in: e60cb6d8 user: dan tags: debug
14:23
Use __sync_synchronous(), when available, instead of a mutex when a memory barrier is needed. check-in: 7d4562e9 user: drh tags: debug
14:10
Add calls to sqlite3_log() when sqlite3_mutex_enter() takes more than 100,000 CPU cycles. check-in: 33c7ef7a user: drh tags: debug
2016-07-16
11:47
Temporarily add extra sqlite3_log() calls to this version to help with debugging a performance problem. check-in: 613c1cea user: dan tags: debug
2016-07-14
20:19
Experimental patch restore the slight bias in btree-balancing immediately after the change to reduces the amount of memcpy() work done by balancing. Leaf check-in: 46bd9533 user: drh tags: btree-balance-bias
2016-03-31
21:36
Version 3.9.3 check-in: dfbfd34b user: drh tags: release, branch-3.9, version-3.9.3
21:16
Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. check-in: f1e6bb95 user: drh tags: branch-3.9
2016-02-05
14:34
Merge PRAGMA synchronous=EXTRA and OOM performance enhancements from trunk. check-in: 332c8036 user: drh tags: begin-concurrent
14:29
Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as other enhancements from trunk. check-in: 201fcbee user: drh tags: apple-osx
14:15
Merge enhancements from trunk. check-in: a533608c user: drh tags: sessions
14:11
Improvements to the way out-of-memory conditions are handled, resulting in an almost 1% performance gain in the commmon case where OOM errors do not occur. check-in: b082538d user: drh tags: trunk
13:38
Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority cases where db is guaranteed to be not NULL. Closed-Leaf check-in: 0a802e96 user: drh tags: oom-handling
04:55
Improve ERRORLEVEL handling in the MSVC batch build tool sub-routine 'fn_UnsetVariable'. check-in: fe123ab4 user: mistachkin tags: trunk
04:50
OOM failures on sqlite3_errmsg16() in an app-defined function are no longer benign. check-in: 9efb223f user: drh tags: oom-handling
04:39
Another small tweak to the MSVC batch build tool. check-in: 76718bbc user: mistachkin tags: trunk
02:50
Minor simplification of schema error reporting. check-in: a8846aee user: drh tags: oom-handling
02:42
Further performance improvements that fall out of the mallocFailed changes. check-in: d94416dd user: drh tags: oom-handling
01:55
Improvements to the way that OOM errors are processed. check-in: c3ef0347 user: drh tags: oom-handling
2016-02-04
19:50
Temporarily back out the 0.5% performance improvement from check-in [632071bac5ff32]. Need a more elaborate solution that works with reentrant virtual tables and SQL functions. check-in: 42736fb0 user: drh tags: trunk
19:45
Further improve performance of unindexed fts5 prefix queries. check-in: c9c6457d user: dan tags: trunk
17:31
Avoid running some particularly time-consuming tests as part of veryquick.test. check-in: f465944b user: dan tags: trunk
11:48
Remove unnecessary sets of db->mallocFailed. check-in: b787165b user: drh tags: trunk
11:15
Use sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension. check-in: 634d008c user: drh tags: trunk
10:28
Escape control characters in JSON. Fix for ticket [ad2559db380abf8]. check-in: 4f1b5229 user: drh tags: trunk
09:48
Refinements to synchronous logic: (1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number. (2) Honor SQLITE_NO_SYNC on xDelete calls with sync (3) Count xDelete syncs during testing (4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal unlink are off by default. check-in: e3157cb5 user: drh tags: trunk
02:34
Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. Leaf check-in: 1c8d3001 user: drh tags: zero-register
2016-02-03
22:14
In the VDBE loop, only check for OOM errors at jumps rather than after every opcode, for about a 0.5% performance increase. check-in: 632071ba user: drh tags: trunk
20:04
Improve performance of fts5 prefix queries on detail=col tables. check-in: ca11f46d user: dan tags: trunk
19:52
Fix markup errors in comments used to generate the documentation - specifically in the documentation on the OP_Seek opcode. check-in: ef252bc4 user: drh tags: trunk
19:20
Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. check-in: af924018 user: drh tags: trunk
01:55
Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. check-in: ae8b9d2e user: drh tags: trunk
2016-02-02
21:19
Add tests to restore full coverage of fts5 code. check-in: 063755c8 user: dan tags: trunk
17:40
Enhance the performance of fts5 AND and OR queries. check-in: 62ea9e5a user: dan tags: trunk
02:53
Merge recent enhancements from trunk. check-in: 347f6a80 user: drh tags: begin-concurrent
02:30
Merge recent enhancements from trunk. check-in: e6a4a163 user: drh tags: apple-osx
02:22
Merge all recent enhancements from trunk. check-in: f3f92001 user: drh tags: sessions
02:04
Enhance the comment on the sqlite3_index_constraint object to bring attention to the fact than iColumn field can be negative for a rowid. check-in: d8b7b199 user: drh tags: trunk
00:59
Add the SQLITE_DBCONFIG_REQUIRE_WRITE_TXN connection setting, which if enabled requires all write operations to be enclosed within BEGIN ... COMMIT. Leaf check-in: 7453790c user: drh tags: require-write-txn
2016-02-01
21:48
Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. check-in: 6d7d4703 user: drh tags: trunk
20:12
Improve performance of fts5 queries. check-in: 2334e882 user: dan tags: trunk
17:20
Number VDBE opcodes starting with 0 instead of 1, as this obviates the lower-bound test on "switch(opcode){...}", making the code smaller and faster. check-in: 4c9222f7 user: drh tags: trunk
16:36
Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. check-in: 5d7c0928 user: dan tags: trunk
13:58
Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. check-in: a17712bf user: dan tags: trunk
13:21
Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. check-in: a9b6a067 user: drh tags: trunk
00:21
Fix an assert() that might fail on a corrupt database. check-in: 22eaced7 user: drh tags: trunk
2016-01-30
21:09
Fix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds. check-in: a2810cf6 user: dan tags: trunk
19:16
Performance enhancement for fts5 column filter queries on detail=full tables. check-in: 13fb4aa6 user: dan tags: trunk
16:59
Merge the implementation of OP_IdxRowid and OP_Seek so that OP_Seek no longer requires the rowid register and a separate OP_IdxRowid call. Shorter and faster prepared statements result. check-in: 9bec50a1 user: drh tags: trunk
15:52
Only honor the register subtype value if the MEM_Subtype flag is set. Revised and improved fix for ticket [f45ac567eaa9f9]. check-in: 1f4c667f user: drh tags: trunk
15:46
A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93]. Closed-Leaf check-in: 2e9fb129 user: dan tags: clear-subtype-flag
14:53
Take care to clear the subtype on VDBE registers when the value of the register is overwritten with new content. Closed-Leaf check-in: ec653cbc user: drh tags: clear-subtype-fail
14:17
Output subtype information on register traces for PRAGMA vdbe_trace. check-in: 96b78020 user: drh tags: trunk
13:32
Add the BTREE_FORDELETE and BTREE_AUXDELETE flags to the b-tree layer interface and use them. Add assert() statement to verify that they are correct. check-in: 85c46704 user: drh tags: trunk
12:50
Simplification and size reduction to the printf logic. Remove the bFlags parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. check-in: 0bdb41c4 user: drh tags: trunk
02:10
Make use of covering indexes in the OR optimization. check-in: 9de3d712 user: drh tags: trunk
00:45
Change the P4_INTARRAY so that always begins with a length integer. Print the content of the INTARRAY on EXPLAIN output. Closed-Leaf check-in: 6c520d57 user: drh tags: covering-or
2016-01-29
21:16
Add tests for the change on this branch. check-in: 7cb697f8 user: dan tags: covering-or
20:58
Different comment on the alternative cursor fields of VdbeCursor. check-in: 6e3dcb6d user: drh tags: covering-or
19:29
Experimental attempt to make better use of covering indexes within OR queries. check-in: a323ac3a user: dan tags: covering-or
19:04
Improvements to FORDELETE processing, including bug fixes and adding assert() statements to help verify correct operation. Closed-Leaf check-in: 46080b04 user: drh tags: btree-fordelete-flag
18:48
Remove a stray "exit" in a test script. Closed-Leaf check-in: 10c88bf9 user: drh tags: fordelete-assert
18:11
Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint. check-in: 512caa1a user: drh tags: trunk
18:04
Prepend "rc!=SQLITE_OK || " to the nExtraDelete assert() condition. check-in: 2a055ed0 user: dan tags: fordelete-assert
16:57
Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint. Closed-Leaf check-in: ab946039 user: drh tags: OR-clause-improvement
08:38
Avoid two more instances of pointer arithmetic on freed pointers. check-in: 2910ef64 user: dan tags: trunk
2016-01-28
18:22
Modify the order of terms in an "if" condition to avoid implicitly comparing a dangling pointer to NULL following an OOM error. check-in: 5372f800 user: dan tags: trunk
17:06
Modifications to ensure the nExtraDelete-related assert() statement does not fail. check-in: f43ff8f8 user: dan tags: fordelete-assert
08:58
Remove a duplicate "p->magic = VDBE_MAGIC_RUN;" line from vdbeaux.c. check-in: 688eb3b4 user: dan tags: trunk
02:47
Fix for pthread detection in the configure scripts. check-in: 47633ffd user: drh tags: trunk
00:04
Minor correction to the batch tool changes in the previous check-in. check-in: 7c89d75d user: mistachkin tags: trunk
2016-01-27
23:50
Make the MSVC batch build tool sub-routine 'fn_UnsetVariable' a bit more robust. check-in: 1edd5f31 user: mistachkin tags: trunk
16:26
Change the name of the BTREE_IDXDELETE flag to BTREE_AUXDELETE, to better reflect its purpose. check-in: 1d3bf6be user: drh tags: fordelete-assert
16:17
Fix tests in fordelete.test to test for the BTREE_AUXDELETE flag. check-in: bbd25cf1 user: dan tags: fordelete-assert
15:49
Add assert() statements on the nExtraDelete variable in vdbe.c to try to verify that the FORDELETE and IDXDELETE flags are being generated correctly. Those flags are not currently generated correctly, and so the assert()s trip on this check-in. check-in: dde1db0d user: drh tags: fordelete-assert
07:28
Support building for Windows 10 desktop using 'MinCore.lib'. check-in: 4bf89891 user: mistachkin tags: trunk
2016-01-26
23:32
Merge all recent trunk enhancements. check-in: 9a71d56d user: drh tags: btree-fordelete-flag
20:19
Performance improvements for fts5, particularly detail=col mode. check-in: a3d7b8ac user: dan tags: trunk
20:08
Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. Leaf check-in: b4ac61ae user: dan tags: fts5-perf
19:30
Improve the performance of fts5 column filters on detail=col tables. check-in: 249a2d07 user: dan tags: fts5-perf
17:08
Enhance fts5txt2db.tcl, a script used to generate fts5/fts4 databases for performance testing. check-in: c646e403 user: dan tags: fts5-perf
15:23
Change the automatic index mechanism so that it avoids creating transient indexes on columns that are known to have low cardinality. Leaf check-in: 12ef3a8f user: drh tags: autoindex-planning
14:48
Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. check-in: 4003db4a user: dan tags: trunk
13:56
Ensure that unixFullpathname() always nul-terminates its output buffer, even when returning an error. Closed-Leaf check-in: 4a438556 user: dan tags: follow-symlinks
00:12
Remove an unused variable. check-in: 1c2656c1 user: drh tags: follow-symlinks
2016-01-25
23:24
Add the ability to do Windows builds to the amalgamation tarball. check-in: abd2b357 user: drh tags: trunk
23:19
Minor changes to the autoconf/README.txt file. Closed-Leaf check-in: 6df8a9c0 user: drh tags: msvcMakeMin
22:08
Fix a compiler warning about doing pointer arithmetic involving a NULL pointer even though the result of computation is never used. check-in: 7c49a947 user: drh tags: trunk
18:43
Only use lstat() if the HAVE_LSTAT macro is defined. Fix some test file issues. check-in: 8a6e4147 user: dan tags: follow-symlinks
18:05
Simplify the unixFullpathname() function. This adds a dependency on lstat(). check-in: f71249d3 user: dan tags: follow-symlinks
17:04
Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. check-in: 80398fd4 user: dan tags: follow-symlinks
15:57
Replace the OP_SetIfNotPos operator with OP_OffsetLimit in the VDBE, for simpler and smaller code. check-in: 7ac017a4 user: drh tags: trunk
13:55
Add the SQLITE_EXTRA_DURABLE compile-time option. check-in: 30671345 user: drh tags: trunk
02:15
Small simplification to the prepare statement opcode memory reuse logic. Easier to read, and slightly smaller and faster. check-in: 8a1deae4 user: drh tags: trunk
01:07
Small simplification and performance improvement in memsys5Free(). check-in: 0a9cff5c user: drh tags: trunk
2016-01-23
22:55
Add the SQLITE_SPELLFIX_STACKALLOC_SZ compile-time option to control how much stack space is available for use as the Wagner matrix in editDest3 of the spellfix extension. check-in: dd0100dd user: drh tags: trunk
21:57
More updates to the README. check-in: 9f02868d user: mistachkin tags: msvcMakeMin
20:43
Updates to the autoconf README file. check-in: 4ce60fa4 user: drh tags: msvcMakeMin
20:34
Move Makefile.min.msc into the autoconf subdir where it belongs and change its name to Makefile.msc. Adjust build scripts accordingly. check-in: 12eb8db7 user: drh tags: msvcMakeMin
20:16
Minor coding style tweaks for the mkmsvcmin tool. check-in: c15e0fc4 user: mistachkin tags: msvcMakeMin
20:09
Adjust the amalgamation-tarball build process so that it includes the MSVC makefile and the sqlite3.rc resource file. check-in: e420f3dc user: drh tags: msvcMakeMin
19:47
Improved comments on the transformation script and on the generated Makefile. check-in: c6e633ab user: drh tags: msvcMakeMin
19:24
Use the -integer option when sorting list elements. check-in: 949aa614 user: mistachkin tags: msvcMakeMin
18:51
Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. check-in: 72d53699 user: dan tags: fts5-perf
18:24
Changes to spellfix to try to get it to use stack space instead of heap space in cases where that makes sense. check-in: dfcebc73 user: drh tags: trunk
16:20
Merge trunk changes (including fixes for warnings in fts5) with this branch. check-in: ceccc9ad user: dan tags: fts5-perf
15:57
Fix some signed/unsigned comparison compiler warnings in fts5. check-in: 3be336aa user: dan tags: trunk
14:45
Fix a problem involving detail=col and column filters. check-in: 7558a0ad user: dan tags: fts5-perf
14:05
Remove an assert() that can be false if compiled with SQLITE_USE_ALLOCA. check-in: f0a551ed user: drh tags: trunk
07:53
Add tooling to create an MSVC Makefile capable of building the core library and shell only, using a pre-built amalgamation. check-in: c46f1a13 user: mistachkin tags: msvcMakeMin
01:54
Cleanup localtime() support for Windows CE. check-in: 39759a55 user: mistachkin tags: winCeLocalTime
00:07
More work on the MSVC build. check-in: a79c46bc user: mistachkin tags: trunk
2016-01-22
23:17
In the TCL interface, if a database connection object was opened with the -uri 1 option, then also honor URI filenames for the "backup" and "restore" commands. check-in: a1c8116c user: drh tags: trunk
22:16
More MSVC makefile cleanup. check-in: df22556f user: mistachkin tags: trunk
19:48
Experimental performance enhancements for fts5. check-in: b5a57b81 user: dan tags: fts5-perf
19:44
Reenable the xCurrentTime and xGetLastError methods on the unix VFSes as long as SQLITE_OMIT_DEPRECATED is not defined. check-in: c11c85fd user: drh tags: trunk
17:48
Add the sqlite3TokenInit() utility function. check-in: 73231753 user: drh tags: trunk
15:44
Have the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statement before attempting to match it against the names of attached databases. check-in: e60461e9 user: dan tags: trunk
14:46
Merge latest trunk changes into this branch. check-in: 9341491c user: dan tags: schemalint
14:44
Fix handling of transitive constraints in schemalint.tcl. check-in: 44edc1aa user: dan tags: schemalint
14:32
Update the schemalint.tcl script so that the argument to a -select option may be either an SQL statement or the name of a file containing an SQL statement check-in: d4e37767 user: dan tags: schemalint
04:22
Enable FTS4 when building the shell with the MSVC makefile. check-in: e4c07df5 user: mistachkin tags: trunk
03:54
Further refinements to the MSVC makefile. check-in: 67625b96 user: mistachkin tags: trunk
01:25
MSVC makefile enhancements for use with the Windows 10 SDK. check-in: ac2e9d3d user: mistachkin tags: trunk
2016-01-21
18:56
Fix typo in 'Makefile.in'. check-in: 29a51c6d user: mistachkin tags: trunk
17:25
Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. Closed-Leaf check-in: 82470d1c user: dan tags: disable-restrict
17:06
Add a new hint bit on the flags parameter of sqlite3BtreeDelete(). The new BTREE_IDXDELETE bit indicates that the call is to delete an index entry corresponding to a table row that has already been deleted. check-in: ac2cbadd user: drh tags: btree-fordelete-flag
15:55
Improved comments on the FORDELETE hint. No logic changes. check-in: a3cec529 user: drh tags: trunk
2016-01-20
18:47
Add 'rbu' to the clean targets. check-in: f60f0250 user: mistachkin tags: trunk
16:36
Add a -detail option to the loadfts5.tcl script. For creating tables with the detail= option set. check-in: 81e830e2 user: dan tags: trunk
16:02
Merge the LIKE-operator bug fix from trunk. check-in: 36cb3d6e user: drh tags: sessions
15:27
Version 3.10.2 Leaf check-in: 17efb420 user: drh tags: release, version-3.10.2, branch-3.10
15:20
Fix a problem in autoconf/configure.ac causing --enable-readline to fail if libedit was not present. check-in: d4a6425f user: dan tags: branch-3.10
15:19
Fix a problem in autoconf/configure.ac causing --enable-readline to fail if libedit was not present. check-in: e8adeb64 user: dan tags: trunk
15:08
Fix the build so that it works for SQLITE_OMIT_WAL again. check-in: d1c15de5 user: drh tags: branch-3.10
15:05
Fix a potential use-after-free problem when compiling with SQLITE_HAS_CODEC. check-in: b94a3a37 user: drh tags: branch-3.10
14:32
Increase version number to 3.10.2. check-in: c1f918dc user: drh tags: branch-3.10
14:30
Case folding in the LIKE operator should look at all bits of the character, not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a back-out of check-in [0a99a8c4facf] with a testcase added. check-in: 29dc4a3e user: drh tags: branch-3.10
14:22
Case folding in the LIKE operator should look at all bits of the character, not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a back-out of check-in [0a99a8c4facf] with a testcase added. check-in: 204432ee user: drh tags: trunk
12:18
Merge recent enhancements from trunk. check-in: 5520f600 user: drh tags: begin-concurrent
11:40
Merge all recent enhancements from trunk. check-in: 3ed49691 user: drh tags: apple-osx
11:33
Merge recent enhancements from trunk. check-in: 327af5f6 user: drh tags: sessions
08:47
Improve performance of sqlite3VtabImportErrmsg(). check-in: 18d61c8e user: dan tags: trunk
03:36
Performance improvement in sqlite3DbMallocRaw(). check-in: ff8eadbe user: drh tags: trunk
02:36
Suppress the display of the P4 operand in EXPLAIN output when an opcode has been converted into a No-op. check-in: 9f8297f8 user: drh tags: trunk
02:21
Remove an unnecessary memset() from the symbol name resolver. check-in: da527dda user: drh tags: trunk
02:01
Remove an unnecessary memset() for a small size reduction and speed improvement. check-in: 730d7efb user: drh tags: trunk
01:48
During compilation, transfer the azVar[0..nzVar-1] array from Parse to Vdbe rather than copying it. Smaller and faster code. check-in: 80dd495f user: drh tags: trunk
01:32
Very small simplification to the btree balancer. check-in: f421adf5 user: drh tags: trunk
2016-01-19
21:36
Fix an incorrect VFS version number check in the threadtest3.c test program. check-in: 5bf6442b user: drh tags: trunk
17:54
Fix two harmless compiler warnings about comparisons of dangling pointers. check-in: 86944f19 user: drh tags: trunk
16:06
Add further fts5 tests. 100% code coverage is finally restored. check-in: b914ece0 user: dan tags: trunk
2016-01-18
17:48
Add tests for fts5. Fix a crash that can occur in fts5 if the database content is corrupted. check-in: acaf4264 user: dan tags: trunk
13:18
Avoid unnecessary calls to memset() for a small performance improvement. check-in: 9e8c23ac user: drh tags: trunk
09:08
Add a debugging function to print human-readable versions of fts5 detail=none leaf pages. check-in: 8358af36 user: dan tags: trunk
00:46
Simplification of the VDBE bytecode for incremental blob I/O. check-in: d23849f6 user: drh tags: trunk
00:20
Fix a problem with SQLITE_TEST_REALLOC_STRESS. check-in: 0aaf3feb user: drh tags: trunk
2016-01-16
21:06
Add extra tests to cover untested branches in fts5. check-in: 61deab04 user: dan tags: trunk
20:50
Improvements to the way sqlite3VdbeAddOpList() works, resulting in a slightly smaller and faster binary. check-in: 88ceb588 user: drh tags: trunk
18:58
Add further tests for fts5. Fix some problems with detail=col mode and auxiliary functions. check-in: de77d602 user: dan tags: trunk
15:12
Use sqlite3VdbeAddOp4() rather than a separate sqlite3VdbeChangeP4() call, for a slightly smaller and faster binary. check-in: a4258cd4 user: drh tags: trunk
03:16
Fix a potential use-after-free problem when compiling with SQLITE_HAS_CODEC. check-in: 653ea15a user: drh tags: trunk
2016-01-15
21:55
Remove an unnecessary memset(). check-in: 689421a9 user: drh tags: trunk
19:54
Rationalize some code in fts5_storage.c. Add tests to cover recently added branches in fts5. check-in: 3b72df40 user: dan tags: trunk
16:11
Remove unnecessary de-initialization of the Parse object. check-in: 75ab30c5 user: drh tags: trunk
15:06
Work toward making the schema parsing logic simplier and more compact. check-in: c52ca2c0 user: drh tags: trunk
05:39
Fix a couple C99-isms in FTS5 that cause compile errors on MSVC. check-in: 584848d4 user: mistachkin tags: trunk
2016-01-14
22:19
Combine the xFunc and xStep pointers of the FuncDef object into a single pointer xSFunc. check-in: 0d1b3d7d user: drh tags: trunk