SQLite
Timeline
Not logged in

88 check-ins going from [release] to [trunk]

2017-04-29
19:29
[4e1df76e] Leaf: 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: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)
2017-04-26
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
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
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-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
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)
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)
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
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
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)
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)
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)
2017-04-13
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)
09:45
[6f54ffd1] Allow a user column name to be used on the LHS of a MATCH operator in FTS5. (user: dan, tags: trunk)
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)
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:06
[76cd611d] Smaller and faster implementation of exprMightBeIndexed(). (user: drh, tags: trunk)
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)
2017-04-10
20:51
[e052436d] Smaller and faster vdbeFreeOpArray() (user: drh, tags: trunk)
20:27
[efd1702a] Slightly smaller and faster sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
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)
2017-04-08
18:18
[204e72f0] Disallow leading zeros on numeric constants in JSON. Fix for ticket [b93be8729a895a528e2] (user: drh, tags: trunk)
14:11
[b9a8c2b9] Expand on the comment above OP_Destroy to explain why it throws an error if there are any active reader VMs. (user: dan, tags: trunk)
13:52
[fa4416ad] Have the rtree module close any open blob-handle within the xSavepoint method. This prevents such an open blob handle from interfering with DROP TABLE operations. (user: dan, tags: trunk)
13:42
[78c1e903] Fix the quoting mechanism for ".dump" so that it is not applied for the ".mode quote" output. (user: drh, tags: trunk)
09:12
[a921ada8] Have fts5 close any open blob-handle when a new savepoint is opened. This ensures that fts5 does not prevent DROP TABLE statements (which always open a savepoint) from succeeding. (user: dan, tags: trunk)
01:09
[1cdae2db] Make sure the RTree sqlite3_blob handle is reset prior to renaming the table. (user: drh, tags: trunk)
00:55
[a6ce57ee] Fix the ".dump" command so that it works with ".headers on". Also fix the display of ".mode insert" with ".headers on". (user: drh, tags: trunk)
2017-04-07
20:20
[73073529] Use replace() instead of char() to quote newline and return characters in strings in the output of .dump, to avoid excess expression complexity. (user: drh, tags: trunk)
2017-04-06
14:56
[48826b22] Fix the ".lint fkey" shell command for cases where the child key is also an INTEGER PRIMARY KEY. (user: dan, tags: trunk)
12:06
[327eff25] Fix the ".lint fkey" shell tool command so that it works for foreign keys that refer implicitly to primary key columns with non-BINARY default collation sequences. (user: dan, tags: trunk)
2017-04-05
13:44
[c5f1a2b6] Remove a confusing and pointless sentence from the documentation for the sqlite3_interrupt() interface. (user: drh, tags: trunk)
12:39
[ad90e8bb] Split off sqlite3DbFreeNN() from sqlite3DbFree() and use it in cases where we know that the argument to be freed is never NULL. (user: drh, tags: trunk)
11:57
[9e6c9391] Save a few bytes and a few CPU cycles in sqlite3ExprListDelete() routine. (user: drh, tags: trunk)
11:49
[a1cf4476] Remove a conditional made unreachable by the previous ExprList enhancement. (user: drh, tags: trunk)
11:32
[2b6560ad] Combine the ExprList_item objects and the ExprList wrapper into a single memory allocation, for improved performance and reduced footprint. (user: drh, tags: trunk)
10:54
[71ed35cc] Attempt to remove bash-isms from configure.ac. Use -O0 with --enable-debug. (user: drh, tags: trunk)
2017-04-04
19:58
[e5bb7db5] Fix a problem causing "PRAGMA integrity_check" to disable the xfer optimization for subsequent VACUUM operations on tables with one or more CHECK constraints. This could result in VACUUM producing slightly larger database files. (user: dan, tags: trunk)
2017-04-03
14:07
[5c11f430] Avoid an unnecessary call to sqlite3WhereGetMask() inside of whereShortCut(). (user: drh, tags: trunk)
13:59
[658f08ce] Do not attempt to run sync2.test with SQLITE_DISABLE_DIRSYNC builds. (user: dan, tags: trunk)
13:33
[86897c24] Force a schema load prior to "PRAGMA optimize". (user: drh, tags: trunk)
13:17
[777b43e6] Fix typos in the documentation for OP_Column. (user: drh, tags: trunk)
12:04
[84fa069c] Slightly smaller and faster implementation for vdbeSorterCompareInt(). (user: drh, tags: trunk)
2017-04-01
20:44
[e6e36b28] Remove an unnecessary setting of the Mem.enc field for the output of the OP_Record opcode, for a performance improvement and size reduction. (user: drh, tags: trunk)
20:14
[c45cd3b9] Minor performance enhancements to the OP_Affinity opcode. (user: drh, tags: trunk)
19:45
[fcd2acdd] Remove an unnecessary clearing of the Vdbe.iCurrentTime value. (user: drh, tags: trunk)
11:59
[8698df60] Faster implementation for sqlite3VdbeIntValue() and sqlite3VdbeRealValue(). (user: drh, tags: trunk)
11:40
[1c0d82e0] Remove unused fields from the BtCursor object. (user: drh, tags: trunk)
00:20
[2452f061] Save a 78 bytes of code space and a million CPU cycles in speedtest1 by storing the cell index for the leaf page in the BtCursor object in its own field (BtCursor.ix), rather than as an entry in the BtCursor.aiIdx array. (user: drh, tags: trunk)
2017-03-30
17:13
[c8000e94] Declare the Lemon-generated parser object as itself. (Duh) (user: drh, tags: trunk)
16:51
[9e550ccc] Increase the version number for the next development cycle. (user: drh, tags: trunk)
16:37
[1279de0b] Ensure that the stack space used to hold the Lemon-generated parser object is always 8-byte aligned. (user: drh, tags: trunk)
2017-03-29
23:22
[a6891942] When compiling with MSVC, disable extra SELECT/WHERE tracing for dynamically built shells. (user: mistachkin, tags: trunk)
18:03
[4a01880b] Avoid unnecessary blob handle invalidation when changes are made to an unrelated table. (user: drh, tags: trunk)
17:06
[06c2b685] Slightly smaller and faster implementation of pcache1InitBulk(). (user: drh, tags: trunk)
16:55
[d336858d] Fix some tests in malloc5.test to account for the sqlite3_release_memory() change in the previous commit. (user: dan, tags: trunk)
15:18
[5d902b7f] Fix the sqlite3_release_memory() interface so that it works even if SQLITE_DEFAULT_PCACHE_INITSZ is non-zero. (user: drh, tags: trunk)
2017-03-28
18:48
[424a0d38] Leaf: Version 3.18.0 (user: drh, tags: release, branch-3.18, version-3.18.0)
2017-03-25
19:16
[8469fc0d] Add the new sqlite3_set_last_insert_rowid() interface to the extension loader thunk. (user: drh, tags: trunk)