/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

200 most recent check-ins using file test/vtabF.test version fd5ad376

2019-09-03
19:29
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: b584fd36 user: dan tags: branch-3.9
17:39
Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. check-in: 7b4583f9 user: drh tags: branch-3.9
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. 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
03:09
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 inspired by check-in [72de49f2] but is new implementation, not a cherry-pick. Leaf check-in: f0f49224 user: drh tags: branch-3.7.11
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-06-01
16:13
Add test code for LSM to the ext/lsm1/lsm-test directory. check-in: bb7436e8 user: dan tags: lsm-vtab
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-03-31
08:00
Update shell6.test to account for the fact that tests are now run in a separate directory. check-in: 1e3622de user: dan tags: schemalint
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-10-17
23:44
Fix SQLITE_DBCONFIG_REQUIRE_TXN so that it allows BEGIN IMMEDAITE and BEGIN EXCLUSIVE to run outside of a transaction. Leaf check-in: 29997f79 user: drh tags: require-write-txn
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-09-07
19:23
Sync up the MSVC makefiles. check-in: b3777e1f user: mistachkin tags: branch-3.14
13:20
Fix the ".read" command in the command-line shell so that it understands that the input is not interactive. check-in: 7c2c0d1d user: drh tags: branch-3.14
12:47
Version number to 3.14.2. check-in: 925ef2f9 user: drh tags: branch-3.14
12:41
Makefile changes to support building winsqlite3.dll using STDCALL rather than CDECL. check-in: af951e03 user: drh tags: branch-3.14
12:20
Correct affinity computations for a SELECT on the RHS of an IN operator. Fix for ticket [199df4168c]. check-in: 2d1983ff user: drh tags: branch-3.14
12:08
The ORDER BY LIMIT optimization is not valid unless the inner-most IN operator loop is actually used by the query plan. Fix for ticket [0c4df46116e90f92]. check-in: b4f8be1f user: drh tags: branch-3.14
11:27
Fix a problem in internal function sqlite3OpenTableAndIndices causing an operand of an unrelated VM instruction to be overwritten. Fix for [ef360601]. check-in: e5c30f22 user: drh tags: branch-3.14
2016-08-27
01:41
Fix the "Synopsis" on the OP_Lt, OP_Le, OP_Gt, and OP_Ge opcodes, which has been backwards for time out of mind. check-in: f51248dc user: drh tags: rowvalue
2016-08-26
22:09
Fix a minor problem in sqlite3FindInIndex() related to rowids being used as part of the index. check-in: 829f802b user: drh tags: rowvalue
21:15
Fix the sqlite3FindInIndex() to ensure that it always uses a prefix of the index and uses no repeated columns. Enhanced comments. check-in: b9fc89e4 user: drh tags: rowvalue
19:54
Add an EXPLAIN QUERY PLAN line for when a index is used to implement an IN operator. check-in: 171aa833 user: drh tags: rowvalue
19:47
Add test cases to rowvalue2.test. check-in: 078bb69e user: dan tags: rowvalue
19:31
Enhance sqlite3FindInIndex() so that it is able to make use of the primary keys at the end of an index. check-in: 4b589fbf user: drh tags: rowvalue
18:17
Fix a post-OOM crash in updateRangeAffinityStr(). Add several ALWAYS() macros on unreachable branches. check-in: 87d40195 user: drh tags: rowvalue
17:54
Fix a problem with affinity changes and vector range comparisons. check-in: b34413ac user: dan tags: rowvalue
13:19
Allow ROWID values in indexed vector comparisons. check-in: b0cc6be4 user: drh tags: rowvalue
03:42
Comment improvements. Put ALWAYS and NEVER macros on three unreachable branches. check-in: 39761700 user: drh tags: rowvalue
01:02
Remove an unreachable branch from sqlite3ExprAffinity() check-in: 9d96f614 user: drh tags: rowvalue
2016-08-25
22:31
Merge recent changes from trunk. check-in: 5789aab8 user: drh tags: rowvalue
22:06
Fix the sqlite3_trace_v2() interface so that it goes disabled if either the callback or mask arguments are zero, in accordance with the documentation. check-in: 37e6c54b user: drh tags: trunk
21:14
Refactor the sqlite3ExprCodeIN() routine for improved maintainability. check-in: b56705ae user: drh tags: rowvalue
17:47
Another fix in the IN-operator algorithm description. check-in: f474aeac user: drh tags: rowvalue
17:40
Further refinement of the in-operator.md documentation. check-in: df064837 user: drh tags: rowvalue
15:46
Improvements to IN operator code generator comments. Avoid unnecessary Copy operations on the LHS of the IN operator. check-in: b6344298 user: drh tags: rowvalue
14:23
Corrections to the IN-operator notes. check-in: 25033ee9 user: drh tags: rowvalue
14:00
Add notes on the implementation of the IN operator. check-in: d256b2ca user: drh tags: rowvalue
2016-08-24
21:54
Simplified VDBE code for the vector NOT IN null-scanning loop. check-in: 7ae504e6 user: drh tags: rowvalue
21:24
Improved extended comments of comparison operators when the SQLITE_STOREP2 flags is set on P5. No changes to non-debug code. check-in: bbc1b016 user: drh tags: rowvalue
19:58
Modularize all use of the calling convention macros based on the USE_STDCALL nmake macro. check-in: e4a56197 user: mistachkin tags: callbackConv
19:14
Add the sqlite3changebatch_db() API. check-in: bee44ebc user: dan tags: changebatch
18:51
In sqlite3FindInIndex(), improve internal comments and avoid an unreachable branch. check-in: 55945fc1 user: drh tags: rowvalue
18:50
Fix a bug in the fts5 snippet function causing it to return text containing zero phrase instances. Closed-Leaf check-in: b174ed2b user: dan tags: fts5-snippet-bias
18:49
Merge updates from trunk. check-in: 428fc38d user: mistachkin tags: callbackConv
18:21
Sync up the MSVC autoconf makefile. check-in: 77f7c31a user: mistachkin tags: trunk
17:49
Fix more unreachable branches. check-in: 6099c180 user: drh tags: rowvalue
15:37
Add a NEVER() on an unreachable branch in comparisonAffinity(). check-in: 505a2f20 user: drh tags: rowvalue
12:22
Fix a buffer overrun in the code for handling IN(...) operators when the LHS of the operator contains indexed columns or expressions. check-in: f41a0391 user: dan tags: rowvalue
00:51
The previous OOM fix was bad. Back it out and replace it with a better one. check-in: 1e3bc369 user: drh tags: rowvalue
00:25
Avoid a potential null-pointer dereference following an OOM. check-in: 25f6ed8d user: drh tags: rowvalue
2016-08-23
19:02
Simplify the row value misuse error message. check-in: 838c50a5 user: drh tags: rowvalue
19:02
Add further tests for changebatch. And a fix to prevent a changeset from conflicting with itself. check-in: 506d6ff4 user: dan tags: changebatch
18:30
Fix a problem with rowvalue UPDATE when the rowvalue is not the left-most and the RHS is a multi-column subquery. check-in: e149e6b9 user: drh tags: rowvalue
18:09
Fix harmless compiler warnings in changebatch. check-in: a721a738 user: drh tags: changebatch
17:30
Fix an uninitialized variable in CASE expression code generation. check-in: c8ffae05 user: drh tags: rowvalue
17:02
Add a new method to sessions - sqlite3sessions_fullchangeset() - to return a changeset that always contains values for all old.* fields. Update changebatch to use these values to more reliably detect multi-column UNIQUE constraint violations. check-in: efa761b2 user: dan tags: changebatch
14:42
Fix the SQLITE_USER_AUTHENTICATION login check so that the SQLITE_AUTH_USER error code correctly propagates and is not overwritten by SQLITE_ERROR. check-in: c640489d user: drh tags: trunk
2016-08-22
21:01
Add a couple of extra tests to changebatch1.test. check-in: 207d970b user: dan tags: changebatch
20:49
Add an experimental module to detect conflicts between sessions changesets. check-in: 0c9fd6b7 user: dan tags: changebatch
20:10
Add support for the SQLITE_DBCONFIG_MAINDBNAME configuration option. check-in: 78395193 user: drh tags: trunk
14:30
Fix the vector BETWEEN operator so that it only evaluates the left-most vector expression once. Add support for vector comparisons in the CASE operator. check-in: 07e69f43 user: drh tags: rowvalue
00:48
Reinstate the mechanism in BETWEEN that avoids evaluating the first expression more than once, but fix the affinity extractor so that it works with this mechanism. The de-duplication of the first expression still does not work for vector expressions, though. check-in: 2f39987f user: drh tags: rowvalue
2016-08-20
22:49
The docs promise the in "x BETWEEN y AND z" the x expression is only evaluated once. That is no longer true, and so some tests are failing. This needs to be fixed before merging to trunk. check-in: e50d264f user: drh tags: rowvalue
21:11
Further comment enhancements. No changes to code. check-in: d4562a9e user: drh tags: rowvalue
21:02
Clarification of code comments in expr.c. Clean up the implementations of sqlite3ExprIsVector() and sqlite3ExprVectorSize() slightly. check-in: 4fb66d65 user: drh tags: rowvalue
18:06
Fixes for problems following OOM errors. check-in: 9041ee4a user: drh tags: rowvalue
17:23
Fix other minor problems with the fts5 snippet() function. check-in: b56b2a85 user: dan tags: fts5-snippet-bias
17:00
Do not duplicate the Expr.pLeft subtree of a TK_SELECT_COLUMN node. check-in: 8384c77e user: drh tags: rowvalue
15:01
Fix a segfault that could occur if a query that used a vector comparison contained certain types of syntax errors. check-in: 203f07c5 user: dan tags: rowvalue
12:00
Improvements to the vector comparison splitter in exprAnalyze(). check-in: a3ffd283 user: drh tags: rowvalue
01:06
Improvements to comments. No code changes. check-in: 4165d20f user: drh tags: rowvalue
00:51
Add support for vector assignments in the SET clause of an UPDATE statement. check-in: f320d47d user: drh tags: rowvalue
00:07
Change the way TK_SELECT_COLUMN is handled so that the subquery is only generated once even if part of the vector comparison is used for indexing and the other part is now. This change also is a pathway to vector assignment in UPDATE statements. check-in: d8feea7d user: drh tags: rowvalue
2016-08-19
19:58
Replace the magic number (-2) with its symbol XN_EXPR in the exprMightBeIndexed() routine. No logic changes. check-in: d4a5af69 user: drh tags: rowvalue
19:12
Improved comments on sqlite3CodeSubquery(). No changes to code. check-in: acea4ee1 user: drh tags: rowvalue
18:40
Show the WhereTerm.iField value on debugging output, when it is non-zero. check-in: 931c9535 user: drh tags: rowvalue
18:37
Register any built-in fts5 module before loading automatic extensions. This allows automatic extensions to register fts5 tokenizers and auxiliary functions. check-in: b10e31dc user: dan tags: fts5-snippet-bias
18:28
Fix an obsolete comment on codeEqualityTerm(). No changes to code. check-in: d07be5af user: drh tags: rowvalue
15:41
Merge recent enhancements from trunk. check-in: b1787236 user: drh tags: rowvalue
15:17
Merge the VACUUM attached database enhancement from trunk. Closed-Leaf check-in: 12d5e38d user: drh tags: dbconfig_maindbname
15:15
Enhance the VACUUM command so that it can operate on an attached database. check-in: 083f9e62 user: drh tags: trunk
15:12
Disable row counting on queries run while doing a VACUUM. Closed-Leaf check-in: ad35ef11 user: drh tags: vacuum-attached-db
14:25
Have the fts5 snippet() function avoid favouring snippets that begin with sentences that do not contain search terms. Add an extra bias in favour of the first sentence in the document. check-in: d8180af2 user: dan tags: fts5-snippet-bias
14:20
Add the capability to VACUUM an attached database by specifying the schema name as an argument to the VACUUM command. Since version 2.0, VACUUM has accepted an argument which was silently ignored. Now it has meaning. check-in: 29d63059 user: drh tags: vacuum-attached-db
2016-08-18
22:44
Add the SQLITE_DBCONFIG_MAINDBNAME interface. check-in: d6e3d579 user: drh tags: dbconfig_maindbname
22:19
Change the name of Db.zName to Db.zDbSName for improved long-term code maintainability. check-in: cb9865e1 user: drh tags: trunk
20:56
Fix a zName to zDbSName conversion missed in the previous check-in. Closed-Leaf check-in: d7cf423c user: drh tags: zDbSName
19:04
Fix a SQL NULL handling bug in the vector IN operator code generation. check-in: 936146b1 user: drh tags: rowvalue
18:09
Display SELECT_COLUMN expressions in the .wheretrace debugging output. check-in: 3b27a5da user: drh tags: rowvalue
17:55
Display VECTOR expressions in .wheretrace and .selecttrace debugging output. check-in: 157347e2 user: drh tags: rowvalue
15:36
Since the TK_VECTOR token is not actually used by the parser, make it an extra token code added by the tool/addopcodes.tcl script during parser build. check-in: b40b202c user: drh tags: rowvalue
15:21
Merge recent enhancements from trunk. check-in: 4768a106 user: drh tags: rowvalue
15:15
Simplify the vector comparison code generator logic, and the resulting VDBE code. check-in: e2ad0b5d user: drh tags: rowvalue
14:47
Adjust some tests to account for recent changes to the fts5 snippet function. check-in: 184ecbe9 user: dan tags: fts5-snippet-bias
14:33
Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. check-in: 92a22f01 user: drh tags: zDbSName
2016-08-17
19:05
Bias the fts5 snippet() function to return snippets that look like they start at the start of sentences. check-in: 60de1594 user: dan tags: fts5-snippet-bias
11:14
Fix a problem in the fts5 snippet() auxiliary function. check-in: a861713c user: dan tags: trunk
2016-08-16
16:46
Fix a bug in destructor processing of Lemon. That has no impact on the SQLite grammar. The bug was introduced by prior work to optimize the Lemon-generated parser used by SQLite. check-in: f9035b8e user: drh tags: trunk
2016-08-13
14:30
Questionable changes to support interruptible checkpoint in ZipVFS. Leaf check-in: c7a9f26d user: dan tags: interruptible-checkpoint
14:17
Remove an unnecessary stack variable from sqlite3VdbeExec(). Closed-Leaf check-in: c54bd9c8 user: drh tags: vector-compare
13:03
Improvements to commits. No code changes. check-in: 18f5a3be user: drh tags: vector-compare
12:37
Fix to the vector less-than operator. All legacy tests passing now. check-in: ec70a67e user: drh tags: vector-compare
10:34
Fix an fts5 problem with corrupt database handling found by address-sanitizer. check-in: e22252e1 user: dan tags: trunk
10:02
Attempt to simplify the logic and generated code for vector comparisons. Basic comparison operators are working, but there are many indexing test failures still to be worked through. check-in: dfc028cf user: drh tags: vector-compare
06:38
Fix a buffer overread in fts5. check-in: fcfbee6c user: dan tags: trunk
2016-08-12
16:21
Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. check-in: 8a5f41c7 user: dan tags: interruptible-checkpoint
11:25
Add VdbeCoverage() macros on newly added VDBE branch operations. check-in: 381aa731 user: drh tags: rowvalue
11:01
Fix a post-OOM memory leak. check-in: 14009b32 user: drh tags: rowvalue
2016-08-11
19:12
Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. check-in: d9f8918c user: drh tags: begin-concurrent
18:53
Version 3.14.1 check-in: a12d8059 user: drh tags: release, branch-3.14, version-3.14.1
18:05
Add the "modeof=<filename>" URI parameter to os_unix.c - used to specify a file to copy permissions from when a new database is created. Also allow passing NULL as the second parameter to sqlite3rbu_vacuum(). check-in: ed406d31 user: dan tags: trunk
13:51
Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. check-in: 1adb22f5 user: drh tags: branch-3.14
13:08
Increase the version number to 3.14.1. check-in: 34aed3a3 user: drh tags: branch-3.14
13:03
Enhance sqlite3PcacheTruncate() to run faster in the common case where the cutoff is just a few pages less than the page number highwater mark. check-in: 03dceaea user: drh tags: branch-3.14
12:31
Merge recent changes from trunk. check-in: 959677b9 user: drh tags: rowvalue
12:01
Fix some problems with handling "no such collation sequence" errors. check-in: 8278be06 user: dan tags: rowvalue
09:55
Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. check-in: ab83d707 user: dan tags: trunk
01:24
Fix a harmless compiler warning in FTS5. check-in: 2ea0c8b4 user: drh tags: trunk
2016-08-10
20:02
Optimization to sqlite3WhereExprUsage(). check-in: 95493058 user: drh tags: trunk
19:43
List of MATCH operator names in isMatchOfColumn() should be constant. check-in: 7319d676 user: drh tags: trunk
18:56
Performance enhancement in the expression walker. check-in: ebccbd96 user: drh tags: trunk
15:02
Tweaks to pcache1TruncateUnsafe() to make it slightly smaller and faster and easier to test. check-in: 059f4e2e user: drh tags: trunk
14:40
Rearrange the code inside sqlite3RunParser() routine so that sqlite3Parser() is only called from a single place. This allows sqlite3Parser() to be in-lined, which results in a 0.25% overall performance gain. check-in: 25d1d02b user: drh tags: trunk
13:34
Increment the version number to 3.15. check-in: 8c2701e7 user: drh tags: trunk
13:30
Improved comments on the lempar.c parser template. Adjust the YY_SHIFT_USE_DFLT constant in the Lemon-generated parser tables so as to guarantee that it is always out of range of the yy_lookahead[] table. check-in: 83622f3f user: drh tags: trunk
11:50
Fix pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. check-in: b07a26df user: drh tags: trunk
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
01:43
Performance optimization in the yy_find_shift_action() routine of the Lemon-generated parser. check-in: ba6663be user: drh tags: trunk
2016-08-09
21:08
Prototype for the remember(V,PTR) extension function. Closed-Leaf check-in: f0942c36 user: drh tags: rememberFunc
21:01
Fix harmless compiler warning. check-in: 9a5a4f6e user: drh tags: trunk
19:48
Minor update to the way fts5 column filters are parsed. check-in: 14864f2b user: dan tags: trunk
19:26
Have fts5 interpret column lists that begin with a "-" character as "match any column except" lists. check-in: e5175456 user: dan tags: trunk
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
05:48
Add rowvalue5.test, which should have been part of the previous commit on this branch. check-in: ea03e219 user: dan tags: rowvalue
01:21
Refocus the timer on the pager_end_transaction() routine. check-in: 9d4eb6e4 user: drh tags: debug
2016-08-08
20:15
Fix some cases involving row values and virtual tables. check-in: 156a41f3 user: dan tags: rowvalue
18:42
Fix the EXPLAIN QUERY PLAN output for row value range constaints that use an index. check-in: bb606511 user: dan tags: rowvalue
16:52
Merge trunk changes with this branch. check-in: 0e927a7e user: dan tags: rowvalue
14:21
Merge all changes from the 3.14 release. check-in: c3cd543f user: drh tags: apple-osx
13:40
Version 3.14 check-in: d5e98057 user: drh tags: trunk, release, version-3.14.0
2016-08-07
18:52
Fix documentation typos. No changes to code. check-in: ebc396a1 user: drh tags: trunk
2016-08-05
20:54
Have the TEA package build without SQLITE_OMIT_DEPRECATED. As it uses recently deprecated interfaces sqlite3_profile() and sqlite3_trace(). check-in: 95578898 user: dan tags: trunk
16:16
Undo commit [f250166bb]. It is required to handle IO and other errors that occur within a VACUUM of a Zipvfs database. check-in: ae72513a user: dan tags: trunk
15:34
Remove an incorrect ALWAYS() statement and add a test case to show when the condition is sometimes false. check-in: 0f57effa user: drh tags: trunk
14:35
Fix a very obscure problem following OOM in sqlite3_declare_vtab(). check-in: 68eac748 user: drh tags: trunk
2016-08-04
14:08
Add extra logging calls to this branch. check-in: 491f1ef3 user: dan tags: debug
13:39
Merge all recent enhancements from trunk. check-in: dacfff51 user: drh tags: apple-osx
13:23
Revert the SQLITE_APICALL changes for now. That changes needs further research before it is released. Deferred until 3.15. check-in: 9adda385 user: drh tags: trunk
12:35
Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. check-in: b7f30a9f user: drh tags: trunk
12:33
Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. check-in: e22ca3cd user: drh tags: apple-osx
09:13
Merge the ORDER BY LIMIT fix, and other enhancements, from trunk. check-in: bf5a9542 user: drh tags: apple-osx
09:09
Make sure the ORDER BY LIMIT optimization is not applied if the inner-most loop can only have a single iteration and is hence not really a loop. check-in: 13e3bd3d user: drh tags: trunk
01:47
Add an experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. This changes has been merged into main branches via cherry-pick. Closed-Leaf check-in: 4ada023c user: drh tags: unknown-function
2016-08-03
18:00
Fix a problem with estimating the number of rows visited by a query that uses a multi-column IN(SELECT...) constraint. check-in: 3c2f908f user: dan tags: rowvalue
16:39
Fix another problem involving vector range constraints and mixed ASC/DESC indexes. check-in: 1559f4c4 user: dan tags: rowvalue
16:14
Fix stat4-based cost estimates for vector range constraints. check-in: 18af74ab user: dan tags: rowvalue
14:51
Fix a typo in a comment in btree.c. No changes to code. check-in: 722c1281 user: drh tags: trunk
13:40
Fix the --help output on fuzzcheck so that it fix in an 80-character window. check-in: b91444b5 user: drh tags: trunk
2016-08-02
20:45
Add new test file rowvaluefault.test. check-in: e496b2d6 user: dan tags: rowvalue
20:42
Fix a unused variable that comes up with -DSQLITE_OMIT_DATETIME_FUNCS. check-in: e2f9919e user: drh tags: trunk
19:29
The 'replace.tcl' tool should use Unix line-endings. check-in: 50de9631 user: mistachkin tags: trunk
18:50
Add tests and fixes for vector operations that use sub-queries with different combinations of LIMIT, OFFSET and ORDER BY clauses. check-in: 092b1c5f user: dan tags: rowvalue
17:45
Fix SQLITE_OMIT_SUBQUERY builds. check-in: 339f85f4 user: dan tags: rowvalue
17:07
Fix a problem with vector range constraints and mixed ASC/DESC indexes. check-in: e2ad30c8 user: dan tags: rowvalue
16:24
Merge latest trunk changes into this branch. check-in: d468101b user: dan tags: rowvalue
16:18
Add missing comments and make some code on this branch clearer. check-in: 6937677c user: dan tags: rowvalue
13:26
Updates to requirements marks. No changes to code. check-in: b23c10ac user: drh tags: trunk
11:29
Fix a problem introduced by [77948b5eceab92a7] causing duplicate calls to be made to the xSavepoint() method of virtual tables under some circumstances. check-in: e64a4173 user: dan tags: trunk
08:45
Fix harmless compiler warnings in sqlite3_status(). check-in: 7c38a79c user: drh tags: trunk
2016-08-01
21:17
Update the wordcount.c test program and add a new script "time-wordcount.sh" for additional performance testing. check-in: d8ef9f58 user: drh tags: trunk
20:14
Fix a problem with vector range constraints involving the rowid column. And other issues. check-in: 3ef75d45 user: dan tags: rowvalue
17:06
Fix other harmless compiler warnings. check-in: 90d2c490 user: drh tags: trunk
16:57
Remove a duplicate typedef from loadext.c (remaining copy is in sqlite3ext.h). check-in: fd184e5a user: dan tags: trunk
16:50
Add an extra compiler switch to loadext.test to ensure that it picks up the correct version of sqlite3.h when building a test extension. check-in: e57fa6af user: dan tags: trunk
16:37
Fix a problem with IN(...) constraints where the LHS is a sub-select that is an aggregate query. check-in: 1f4dba87 user: dan tags: rowvalue
15:00
Update releasetest.tcl to automatically do one round of tests with USE_STDCALL=1 when running on Windows with MSVC. check-in: a6a112de user: drh tags: trunk
14:35
Avoid making unnecessary changes to the signatures of the sqlite3_auto_extension() and sqlite3_cancel_auto_extension() interfaces. check-in: b6ea2f21 user: drh tags: trunk
2016-07-30
21:02
Fix problems with vector == comparisons and NULL values. check-in: 059d0d05 user: dan tags: rowvalue