SQLite
Timeline
Not logged in

200 most recent check-ins using file tool/lempar.c version db1bdb48

2017-05-26
18:18
[a7e0e7a4] Leaf: Adjust the bitvec related sqlite3_log messages added by [9527089b]. (user: dan, tags: begin-concurrent)
16:51
[9df01957] Add extra test cases for deferred page allocation. (user: dan, tags: begin-concurrent)
16:15
[a4a3bbe6] Fix a problem with deferred page allocation in transactions that revert page allocations by savepoint rollbacks. (user: dan, tags: begin-concurrent)
2017-05-25
21:35
[6f415833] Leaf: Small performance increase and size decrease in the btreeInitPage() routine. (user: drh, tags: trunk)
21:02
[47a7dd92] Fix a problem with the deferred page allocation on this branch that could occur when the database file is just slightly smaller than the PENDING_BYTE page offset. (user: dan, tags: begin-concurrent)
17:36
[12964240] Leaf: Merge all fixes from the 3.19.2 release. (user: drh, tags: apple-osx)
17:27
[6513e4a1] Merge the LEFT JOIN query flattener fixes from 3.19.2. (user: drh, tags: trunk)
16:50
[edb4e819] Leaf: Version 3.19.2 (user: drh, tags: release, branch-3.19, version-3.19.2)
11:39
[1a074c8a] The SQLITE_EXTRA_IFNULLROW compile-time option causes OP_IfNullRow opcodes to be issued for references to the right-hand side table of *any* flattened join, not just LEFT JOINs. This puts extra stress on the OP_IfNUllRow opcodes for testing purposes. (user: drh, tags: branch-3.19)
00:28
[b30a364a] The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. (user: drh, tags: branch-3.19)
00:12
[c315727a] Increase the version number to 3.19.2 since ticket [7fde638e94287d2] is going to necessitate another patch release. (user: drh, tags: branch-3.19)
00:08
[77fc2301] The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. (user: drh, tags: trunk)
2017-05-24
15:32
[57a60e95] Fix harmless compiler warnings in FTS5. (user: mistachkin, tags: trunk)
13:08
[f6d7b988] Version 3.19.1 (user: drh, tags: release, branch-3.19, version-3.19.1)
04:18
[cfb0d9e0] Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. (user: drh, tags: trunk)
2017-05-23
20:00
[84996aef] Remove the msvc.h header file from the autoconf tarball. (user: drh, tags: trunk)
19:35
[4440e420] Do not use strcpy() in the (obsolete) amatch extension. In releasetest.tcl, run Apple tests using -Os instead of -O1 (user: drh, tags: trunk)
19:23
[5b9d498f] Add experimental new API sqlite3_wal_info(). (user: dan, tags: begin-concurrent)
15:33
[05ada741] Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. (user: drh, tags: branch-3.19)
15:21
[44b21e35] Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. (user: drh, tags: trunk)
12:44
[28d2902d] Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. (user: drh, tags: branch-3.19)
12:36
[941d8142] Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. (user: drh, tags: trunk)
01:35
[16656b8f] Change the version number to 3.19.1. (user: drh, tags: branch-3.19)
01:30
[4510d55d] Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. (user: drh, tags: branch-3.19)
01:29
[919d36e6] When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. (user: drh, tags: branch-3.19)
01:21
[92c17850] When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. (user: drh, tags: trunk)
00:32
[987a2b55] Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. (user: drh, tags: trunk)
2017-05-22
19:24
[bbd2d0e1] Pull in all changes from the 3.19.0 release. (user: drh, tags: apple-osx)
18:09
[0bb23c48] Fix incompatibilities between the "sqldiff --changeset" command and the sessions module. Specifically, allow sessions to process changesets containing tables with zero operations on them and have sqldiff output the expected output for tables with multi-column primary keys. (user: dan, tags: trunk)
18:00
[5fe28e15] Add the ".cd" command to the command-line shell. (user: drh, tags: trunk)
17:39
[ab471f61] Increase the version number to 3.20 for the next release cycle. (user: drh, tags: trunk)
14:04
[e6ba2a93] Merge the last-minute 3.19.0 changes into trunk. (user: drh, tags: trunk)
13:58
[28a94eb2] Version 3.19.0 (user: drh, tags: release, branch-3.19, version-3.19.0)
13:06
[3dd6fe53] Include the "msvc.h" header file in the amalgamation tarball. (user: drh, tags: branch-3.19)
08:04
[3ea2bad2] Fix a case where NULL was being passed to memcmp() following an OOM. This is probably not a real problem, as the number-of-bytes parameter was passed 0 in this case, but it was causing a santizer complaint. (user: dan, tags: trunk)
08:01
[a726d981] Leaf: Add code to this branch to emit a log message after each cumulative second that the WRITER lock has been held. (user: dan, tags: server-edition)
00:45
[f261678c] When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. (user: drh, tags: trunk)
2017-05-19
23:04
[50ad60de] Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. (user: drh, tags: branch-3.19)
22:51
[c2de178f] Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. (user: drh, tags: trunk)
20:55
[946b87a5] Improved comments on one routine in the query planner. Improved diagnostic output for ".wheretrace". No production code changes. (user: drh, tags: trunk)
20:47
[68942a4f] Fix a documentation typo. No changes to code. (user: drh, tags: trunk)
20:46
[f2b829ec] Branch for the 3.19 release. (user: drh, tags: branch-3.19)
19:57
[9527089b] Invoke sqlite3_log() in response to irregularities surrounding the Pager.pAllRead bit-vector. (user: dan, tags: begin-concurrent)
12:32
[35f72104] Fix some problems in fts5 code detected by -fsanitize=undefined. (user: dan, tags: trunk)
2017-05-18
20:47
[0eed1521] Fix a problem on this branch causing some page-level read-locks to be omitted. (user: dan, tags: begin-concurrent)
18:17
[cfa4aa20] Closed-Leaf: Fix a documentation typo. No changes to code. (user: drh, tags: doc-type)
2017-05-16
09:49
[7940bff3] Update the tool/warnings.sh script to automatically use the right options on OpenBSD. (user: dan, tags: trunk)
2017-05-15
19:32
[9b7f8024] Avoid writer starvation by adding a RESERVED state to page locks. (user: dan, tags: server-edition)
17:56
[6e0f64ab] Leaf: Merge changes from trunk. (user: drh, tags: schemalint)
17:34
[14ea8400] Merge the latest changes from trunk. (user: drh, tags: begin-concurrent)
15:12
[bb0d9281] Fix the build so that it works again with SQLITE_OMIT_SUBQUERY. (user: drh, tags: trunk)
15:05
[0f05d7e9] Improvements to the omittest.tcl script. (user: drh, tags: trunk)
2017-05-13
19:07
[a38858a2] Avoid running recovery while there is another read/write client. (user: dan, tags: server-edition)
2017-05-12
18:52
[cbf44ed9] Require exclusive access to the db to wrap the wal file. Have "PRAGMA wal_checkpoint = restart" block for this. (user: dan, tags: server-edition)
14:05
[a123cb93] Make sure the 'sqlite3changegroup_*' functions are included in the SQLITE_APICALL handling. (user: mistachkin, tags: trunk)
2017-05-11
19:09
[339df63f] Add another test case for the new authorizer functionality. (user: dan, tags: trunk)
18:49
[b55c0f14] Merge recent enhancements from trunk. (user: drh, tags: apple-osx)
18:42
[3ba9e7ab] Enhance the json_extract() function to reuse parses of the same JSON when the function appears multiple times in the same query. (user: drh, tags: trunk)
18:14
[9a2de4f0] Do not save the state of an fts5 merge operation mid-way through an input term, even if no previous entry for that term has caused any output. Doing so may corrupt the FTS index. (user: dan, tags: trunk)
16:49
[44ca6c2c] Closed-Leaf: Cache the JSON parse used by json_extract(). (user: drh, tags: auxdata-cache)
15:20
[ff530675] Negative N values in sqlite3_get_auxdata() and sqlite3_set_auxdata() can be used to access an auxiliary data cache over all functions in a single prepared statement. (user: drh, tags: auxdata-cache)
13:43
[3980ea09] New requirements marks and documentation for the authorizer. (user: drh, tags: trunk)
12:27
[47629b19] Improvements to the sqlite3_set_authorizer() documentation. (user: drh, tags: trunk)
12:05
[4139953a] Change the SQLITE_READ authorization call for unreferenced tables to use an empty string for the column name, as this is less likely to impact legacy authorization callbacks that assume column names are always non-NULL. (user: drh, tags: trunk)
2017-05-10
19:42
[2be9850c] Rename fields of the internal AuxData object to make them unique and easier to search for. (user: drh, tags: trunk)
16:33
[92c5ea70] Improved documentation for the SQLITE_READ authorizer callback. No code changes. (user: drh, tags: trunk)
16:18
[2584df3d] Fix a problem causing a lock to be held past the end of a transaction. Use a blocking lock to take the read-lock on page 1 taken by all transactions. (user: dan, tags: server-edition)
16:12
[92ab1f72] Invoke the SQLITE_READ authorizer callback with a NULL column name for any table referenced by a query but from when no columns are extracted. (user: drh, tags: trunk)
13:46
[4464ca1d] Use a blocking call to obtain the wal-mode WRITER lock in some cases. (user: dan, tags: server-edition)
13:36
[30018d31] Fix a couple of test scripts so that they work with -DSQLITE_DISABLE_FTS4_DEFERRED builds. (user: dan, tags: trunk)
12:58
[199b2a84] Avoid unnecessary codec operations on in-memory subjournals. (user: drh, tags: trunk)
12:49
[d2bb0066] Closed-Leaf: Do not invoke codec macros for in-memory subjournals. (user: drh, tags: codecless-inmemory-subjournal)
2017-05-09
16:32
[270b7d1e] Fix a problem with wrapping the log file in server mode. (user: dan, tags: server-edition)
2017-05-08
20:15
[b733afc1] Add some support for wal mode to the hack on this branch. (user: dan, tags: server-edition)
18:29
[2c145ee6] Do not invoke codec macros when reading or writing an in-memory sub-journal. (user: dan, tags: codecless-inmemory-subjournal)
2017-05-06
18:09
[04e7e565] Fix an obscure assertion fault that can follow an OOM. The problem was introduced by check-in [a1cf44763277b6c7]. (user: drh, tags: trunk)
17:12
[198ff4c0] Fix requirements marks and harmless compiler warnings. (user: drh, tags: trunk)
16:04
[ed6bad67] Update this branch with latest trunk changes. (user: dan, tags: server-edition)
2017-05-04
14:02
[269bf52e] Remove the tool/schemalint.tcl script. And related Makefile entries. It is superseded by sqlite3_expert. (user: dan, tags: schemalint)
11:13
[b9a58dac] Fix a collision of the "B0" identifier name between the termios.h header file and the SHA3 implementation in the shell. (user: drh, tags: trunk)
2017-05-03
19:36
[e24b7382] Remove the unused "sqlite3_stack_used" TCL command from the test harness. (user: drh, tags: trunk)
17:44
[05eba9e3] Fix the sqlite3GetInt32() function so that it correctly returns 0 on a zero-length input string. (user: drh, tags: trunk)
15:54
[31a51b4d] Always enable URI filenames when compiling with SQLITE_HAS_CODEC. Also allow plaintext keys using the key= query parameter. (user: drh, tags: trunk)
13:05
[593e5dd0] Fix a harmless compiler warning on Windows. (user: drh, tags: schemalint)
12:50
[d8254047] Get sqlite3_expert building on Windows. (user: drh, tags: schemalint)
12:15
[da15752d] In sqlite3expert.c, do not copy the schema for virtual tables. Updates to makefiles to make building easier. (user: drh, tags: schemalint)
2017-05-02
20:42
[af7d1596] In the sqlite3_expert command-line tool, allow two-dash options. Do not accept the database name if it begins with "-". (user: drh, tags: schemalint)
19:45
[a7dcf6a7] Merge the latest enhancements from trunk. (user: drh, tags: schemalint)
18:00
[430f539c] Fix the fts3EvalAverageDocsize() routine so that it returns errors from sqlite3_reset() rather than always returning SQLITE_OK. (user: drh, tags: trunk)
17:54
[9e35c89d] Reuse the same materialization of a view when that view appears in a query more than once, such as in a self-join. (user: drh, tags: trunk)
16:55
[47cbb471] Move terms of the HAVING clause that reference only columns in the GROUP BY clause over to the WHERE clause, resulting in a faster query plan. (user: drh, tags: trunk)
16:46
[8424492e] Closed-Leaf: Additional comments on the sqlite3ExprIsConstantOrGroupBy() routine. No code changes. (user: drh, tags: having-where-optimization)
01:30
[6674814a] Fix typo in comment. No changes to code. (user: mistachkin, tags: trunk)
2017-05-01
20:07
[83b1e163] Update this branch with latest trunk changes. (user: dan, tags: server-edition)
19:53
[a3317959] Remove an unnecessary branch. (user: drh, tags: having-where-optimization)
18:24
[adcad37b] Enhance "PRAGMA integrity_check" to detect duplicate rowids within a leaf page. (user: dan, tags: trunk)
18:12
[a6727eef] Clear the BTCF_ValidNKey flag set if a cursor is moved by sqlite3BtreeInsert(). Fix for [f68dc596c4]. (user: dan, tags: trunk)
17:04
[c64fe3a1] Closed-Leaf: Futher bug fixes to the function that determines when a materialized view can be reused. (user: drh, tags: materialized-view-reuse)
16:37
[b2aae559] Minor bug fixes and performance enhancement. (user: drh, tags: materialized-view-reuse)
15:15
[478c34b9] Initial implementation of an optimization that attempts to reuse the same materialization of a view on a self-join of the view. (user: drh, tags: materialized-view-reuse)
14:25
[11f4761c] Update this branch with latest trunk changes. (user: dan, tags: schemalint)
14:09
[4921cd95] Add extra tests for the optimization on this branch. (user: dan, tags: having-where-optimization)
2017-04-29
20:53
[5375a3ce] Automatically transfer terms from the HAVING clause to the WHERE clause of an aggregate query in cases where the result of evaluating the term depends only one one or more of the GROUP BY expressions (and on no other inputs). (user: dan, tags: having-where-optimization)
19:29
[4e1df76e] Add a single testcase() macro to the subquery processing logic. (user: drh, tags: trunk)
18:02
[e54c9f8d] Improvements to opcode documentation in the bytecode engine. No changes to code. (user: drh, tags: trunk)
15:48
[f6b025bf] Avoid reading the file-size before page 1 is read-locked. (user: dan, tags: server-edition)
15:27
[d7bb79ed] Evaluate WHERE clause terms that reference only the index before evaluating terms that require the table, and thereby avoid seeking the table row if index terms are false. This is called the "push-down" optimization in the MySQL world, we are told. (user: drh, tags: trunk)
14:56
[91dfb61a] Closed-Leaf: Minor size and performance improvements to the push-down optimization. (user: drh, tags: pushdown-optimization)
2017-04-28
19:59
[afe68f0a] Within a loop that uses a non-covering index test, test non-indexed terms that can be tested without seeking the main table cursor before those that cannot. (user: dan, tags: pushdown-optimization)
17:32
[a40b42c4] Fix various bugs revealed by running performance tests. (user: dan, tags: server-edition)
14:09
[a5a08548] Add a missing releasePage() call to the server-mode free-list management code. (user: dan, tags: server-edition)
10:20
[778e8a10] Use a different free-list format for server-mode databases in order to reduce contention. (user: dan, tags: server-edition)
2017-04-27
14:12
[3144ae40] Do not write master journal filenames into server-mode journal files. Use SQLITE_MUTEX_STATIC_APP1 to protect critical sections in server.c. (user: dan, tags: server-edition)
13:05
[d5b5326d] If possible, delete the journal file when a database connection is closed. (user: dan, tags: server-edition)
2017-04-26
20:45
[64ecf7c7] Experimental implementation of pessimistic page-level locking based on rollback mode. (user: dan, tags: server-edition)
17:21
[2d0b6431] Add new test file cachespill.test. (user: dan, tags: trunk)
14:34
[63d9ca5c] Replace <fts5.h> with "fts5.h" in test file fts5_test_tok.c. (user: dan, tags: trunk)
04:32
[304689f8] Fix a subtle bug in Lemon discovered and reported on the mailing list by Kelvin Sherlock, who also suggested the correct fix. (user: drh, tags: trunk)
2017-04-24
16:14
[031feebc] Bring in all the latest enhancements from trunk. (user: drh, tags: apple-osx)
14:16
[1c1b0862] When building an ephemeral table of integers, do not assume that the table does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. (user: dan, tags: trunk)
2017-04-22
00:20
[e39769f4] Fix an assertion fault found by OSSFuzz. (user: drh, tags: trunk)
2017-04-21
19:58
[9fa2ce3c] Another minor formatting fix. (user: dan, tags: schemalint)
19:56
[da9a2e5a] Fix formatting errors in the previous commit. (user: dan, tags: schemalint)
19:53
[3b2ff4e0] Update the README.md file in the ext/expert/ directory. (user: dan, tags: schemalint)
17:03
[bdc50d8d] Remove a NEVER macro for a condition that may be true as of [a47efb7c]. Problem reported by OSSFuzz. (user: dan, tags: trunk)
16:04
[840042cb] Fix an FTS5 bug that could cause a prefix-query without a prefix-index on a database that contains delete-markers to return extra, non-matching, rows. (user: dan, tags: trunk)
2017-04-20
17:35
[b1533bc4] Merge latest trunk changes into this branch. (user: dan, tags: schemalint)
17:03
[4e366996] Avoid creating a temp table in the user database in the sqlite3_expert code. (user: dan, tags: schemalint)
16:43
[8e57c313] Closed-Leaf: Speed this branch up a bit by filtering before the virtual table layer when sampling user data. (user: dan, tags: schemalint-failure)
16:18
[4577fea5] Avoid adding INTEGER PRIMARY KEY columns to candidate indexes. (user: dan, tags: schemalint)
16:08
[c62e3582] Avoid creating a temp table in the user database in the sqlite3_expert code. Trouble is, this makes sampling for stat1 data much slower. (user: dan, tags: schemalint-failure)
09:54
[c69c3e21] Add an option to generate stat1 data based on a subset of the user database table contents to sqlite3_expert. (user: dan, tags: schemalint)
2017-04-19
13:25
[6b21d0fd] Further improvements to coverage of fts3 module. (user: dan, tags: trunk)
07:33
[ea8a0d2c] Further modifications and test cases to improve test coverage of fts3. (user: dan, tags: trunk)
2017-04-18
20:10
[a157fcfd] Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. (user: dan, tags: schemalint)
13:50
[dc2a4802] Use sqlite3_table_column_metadata() instead of a SELECT statement to check for the existence of a %_stat table in fts3. This leads to smaller and easier to test code. (user: dan, tags: trunk)
11:20
[41c27bc0] Improved optimizations of views as the right operand of a LEFT JOIN. (user: drh, tags: trunk)
09:04
[ff4976da] Fix sqlite3_expert handling of triggers on views. (user: dan, tags: schemalint)
05:49
[e47fdb49] Refactor the fts3ColumnMethod() function so that all branches can be covered. (user: dan, tags: trunk)
2017-04-17
23:23
[56845256] Defer checking for null in the comparison operators, since that is an uncommon case. (user: drh, tags: trunk)
20:50
[e698db19] Do not allow a Mem object to be both NULL and some other type at the same time. (user: drh, tags: trunk)
18:42
[69f51f83] Consolidate two branches of code in the "PRAGMA foreign_key_check" implementation. (user: dan, tags: trunk)
18:02
[690870bd] Fix a problem in "PRAGMA foreign_key_check" in handling a WITHOUT ROWID child table with an INTEGER PRIMARY KEY parent key. Also, if an FK violation is detected in a WITHOUT ROWID child table, do not try to read and return the rowid. The second column returned by "PRAGMA foreign_key_check" in this case (WITHOUT ROWID child table) is now always set to NULL. (user: dan, tags: trunk)
17:03
[159e8022] Add support for analyzing trigger programs to the sqlite3_expert code. (user: dan, tags: schemalint)
16:07
[352413ee] Further improvements to test coverage in fts3. (user: dan, tags: trunk)
13:38
[1a08a836] Improve coverage of code in fts3. (user: dan, tags: trunk)
13:18
[f508aff8] Fix the ".column" output mode in the command-line shell so that it correctly counts and formats multi-byte UTF characters. (user: drh, tags: trunk)
2017-04-16
22:41
[90015df3] In the showwal command-line tool, for unix builds, if the auxiliary argument is of the form "Ntruncate" where "N" is a frame number, then truncate the WAL file after the N-th frame. (user: drh, tags: trunk)
22:08
[d7b9813c] Add the anycollseq.c loadable extension in etc/misc (user: drh, tags: trunk)
2017-04-15
16:52
[2e630879] Fix problems with handling constraints on the rowid column in sqlite3expert.c. (user: dan, tags: schemalint)
15:47
[2d0c458e] Merge latest trunk changes into this branch. (user: dan, tags: schemalint)
14:30
[d238694c] Add header comment for sqlite3_vtab_collation(). (user: dan, tags: schemalint)
14:16
[0cd75a87] Fix memory leaks in the code on this branch. Make use of the sqlite3_index_constraint.usage field. Do not try to handle ORDER BY terms with explicit COLLATE clauses - they don't get passed to the vtab layer anyway. (user: dan, tags: schemalint)
11:53
[89f9e436] In the skip-ahead-distinct optimization, fix a bug in the logic that determines when to invoke the optimization based on sqlite_stat1 statistics. (user: drh, tags: trunk)
2017-04-14
22:41
[e50fd489] Closed-Leaf: Fix to the decision logic for when to use the skip-ahead-distinct optimization. (user: drh, tags: skip-ahead-distinct)
19:46
[d78355c8] Remove end-of-line whitespace from lemon.c. (user: drh, tags: trunk)
19:44
[a5379905] Fix some left-over K&R-C constructs in lemon.c. No changes to the core. (user: drh, tags: trunk)
19:41
[3bb65850] Modify the code in ext/expert/ to use the vtab interface instead of sqlite3_whereinfo_hook(). Remove sqlite3_whereinfo_hook(). (user: dan, tags: schemalint)
19:03
[3a5860d8] Closed-Leaf: Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in the result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. (user: drh, tags: left-join-view)
17:30
[f489b5bb] When doing a DISTINCT query using an index, try to use the index to skip ahead to the next distinct element, rather than doing a full scan of the index. (This is the "skip-ahead-distinct" optimization.) (user: drh, tags: trunk)
17:18
[1838a59c] An initial attempt to optimize VIEWs that occur as the right operand of a LEFT JOIN. This particular check-in does not work correctly because it does not deal with the case of columns in the VIEW that return non-NULL even when all columns in the table of the VIEW are NULL because of the LEFT JOIN. (user: drh, tags: left-join-view)
14:50
[6bf67376] Make USE_FULLWARN=1 the default for MSVC and fix harmless compiler warnings. (user: mistachkin, tags: trunk)
14:02
[5159cb8f] Enhance the sqlite3TreeView() display for Expr objects so that it shows the iRightJoinTable value for Expr nodes that have the EP_FromJoin property. (user: drh, tags: trunk)
12:39
[e651074b] Simplify the interface to the subst() routines that are part of the query flattener by collecting common parameters into the SubstContext object and passing around a pointer to that object. (user: drh, tags: trunk)
12:27
[f956f6ae] Remove an incorrect ALWAYS(). (user: drh, tags: trunk)
00:45
[1aa0ea8d] Fix a couple of unreachable branches. (user: drh, tags: skip-ahead-distinct)
2017-04-13
21:29
[ce1e2b88] Fix the skip-ahead-distinct optimization so that it works with indexes that have repeated columns with different collating sequences. (user: drh, tags: skip-ahead-distinct)
19:48
[57c5173b] Simplification of the skip-ahead-distinct logic. There is still an issue with handling COLLATE. (user: drh, tags: skip-ahead-distinct)
18:33
[70ac9ea1] New test cases and minor fixes for the optimization on this branch. (user: dan, tags: skip-ahead-distinct)
16:19
[5fcd840c] Update this branch with latest changes from trunk. (user: dan, tags: schemalint)
15:51
[59c70108] Reinstate the SQLITE_API qualifier on the sqlite3_delete_database() method in test_delete.c. Accidentally removed by the previous commit. (user: dan, tags: trunk)
15:36
[fa9bb7b7] Update the code in test_delete.c to use the "win32" VFS if SQLITE_OS_WIN is defined. (user: dan, tags: trunk)
13:01
[0cf16dec] Only use the skip-ahead-distinct optimization if the index has been analyzed and we know that a skip-head is likely to skip over at least 11 rows. The magic number 11 was determined by experimentation. (user: drh, tags: skip-ahead-distinct)
09:45
[6f54ffd1] Allow a user column name to be used on the LHS of a MATCH operator in FTS5. (user: dan, tags: trunk)
01:19
[132339a1] Forward port the skip-ahead-distinct branch which was abandoned for some reason that I do not recall. This port should have been achived by a merge of trunk into the previous head of skip-ahead-distinct, but that did not work. So I had to manually "rebase" the changes. (user: drh, tags: skip-ahead-distinct)
00:12
[8e7b6118] Fix a regression caused by the fix for ticket [6c9b5514077fed34551f98e64c09a1] - control characters allowed in JSON. (user: drh, tags: trunk)
2017-04-12
17:50
[c847543f] Update fts5 to support "<colset> : ( <expr> )" for column filtering, as well as "<colset> : NEAR(...)" and "<colset> : <phrase>". (user: dan, tags: trunk)
17:38
[f2643315] Improved \n and \r escapes in the ext/misc/dbdump.c utility function. The implementation of dbdump.c now matches the implementation in the CLI. (user: drh, tags: trunk)
2017-04-11
20:48
[7aae5c0f] Avoid updating unaffected indexes on a table as part of an UPDATE that requires foreign key processing in some cases. (user: dan, tags: trunk)
19:58
[477bea9e] Closed-Leaf: Avoid updating unaffected indexes on a table as part of an UPDATE that requires foreign key processing in some cases. (user: dan, tags: fkey-optimization)
19:00
[0f66a093] Update this branch with latest trunk changes. (user: dan, tags: schemalint)
18:55
[1f68c184] Limit the depth of recursion for valid JSON in the JSON1 extension in order to avoid using excess stack space in the recursive descent parser. Fix for ticket [981329adeef51011052667a9]. (user: drh, tags: trunk)
18:29
[cc8c3581] Fix a formatting issue in the output of the sqlite3_expert program. (user: dan, tags: schemalint)
18:06
[76cd611d] Smaller and faster implementation of exprMightBeIndexed(). (user: drh, tags: trunk)
17:43
[0c45c5eb] Add header comments to the API functions in sqlite3expert.h. Include a list of all candidate indexes in the report output by the sqlite3_expert program. (user: dan, tags: schemalint)
16:44
[4143650c] Very slight smaller and faster sqlite3SelectNew() (user: drh, tags: trunk)
12:20
[0f3eb61f] Add an ALWAYS() around an unreachable condition in sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
11:52
[d6bb7c42] Fix a segfault that could occur if an indexed expression was used in a comparison operation within the result-set of a SELECT statement. (user: dan, tags: trunk)
01:30
[a47efb7c] When using an index on an expression, try to use the columns of the index rather than pulling columns from the table and reevaluating the expression. (user: drh, tags: trunk)
01:01
[c59eaf2b] Closed-Leaf: Improved comments. Fix a problem when an indexed expression is used in an ORDER BY clause. (user: drh, tags: covering-index-on-expr)
2017-04-10
23:42
[8978465f] Merge changes from trunk. (user: drh, tags: covering-index-on-expr)
20:51
[e052436d] Smaller and faster vdbeFreeOpArray() (user: drh, tags: trunk)
20:27
[efd1702a] Slightly smaller and faster sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
20:00
[9318f1b9] Add ext/expert/README.md. (user: dan, tags: schemalint)
16:13
[5dd98317] Changes to allow the code in sqlite3expert.c to be tested directly (via the API in sqlite3expert.h) instead of by invoking the sqlite3_expert application. Fix memory leaks and other problems. (user: dan, tags: schemalint)
12:31
[6ee12221] Add a new JSON test case to verify that all control characters are escaped in the json_quote() function. (user: drh, tags: trunk)
12:25
[475d8f82] Change the JSON extension so that it disallows control characters inside of strings. Fix for ticket [6c9b5514077fed34551f98e64c09a10dc2fc8e16]. (user: drh, tags: trunk)
2017-04-09
19:23
[19dd753f] Do not expose the name of the internal Mem object in the public interface defined by sqlite3.h. (user: drh, tags: trunk)
08:38
[0857c48e] Fix the -file option on the sqlite3_expert program. (user: dan, tags: schemalint)
2017-04-08
19:00
[e051e8f2] Merge latest trunk with this branch. (user: dan, tags: schemalint)