SQLite
Timeline
Not logged in

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

2016-09-28
20:42
[cc29ddd6] Leaf: Use Knuth multiplicative hashing for the symbol table. (user: drh, tags: trunk)
16:05
[40c0fb0a] Two more typo fixes in comments. (user: drh, tags: trunk)
16:04
[5bbd071d] Fix typos in comments. No code changes. (user: drh, tags: trunk)
2016-09-27
00:09
[bf903b2e] Update requirements marks due to improvements in the wording of documentation. No changes to code. (user: drh, tags: trunk)
00:03
[0c8b9b21] Fix FTS3 test cases due to the flattener change of the previous check-in. (user: drh, tags: trunk)
2016-09-26
14:39
[cf7f9e6d] When flattening a query of the form "SELECT * FROM (SELECT * FROM tbl WHERE x=?) WHERE y=?", ensure that the final WHERE clause is "x=? AND y=?" instead of "y=? AND x=?". Although it is still not guaranteed, this makes the order in which WHERE clause terms are processed comport more closely to users expectations. (user: dan, tags: trunk)
12:38
[fe89225e] Inline the relevent parts of sqlite3ExprAlloc() into spanExpr(), for a performance improvement. (user: drh, tags: trunk)
2016-09-24
17:42
[795454a3] Omit the LikeOp object from the parser. Change more sqlite3PExpr() calls into sqlite3ExprAlloc() calls. (user: drh, tags: trunk)
01:41
[a8cb1390] Add -DSQLITE_MAX_EXPR_DEPTH=0 to the --lean option on speed-check.sh. (user: drh, tags: trunk)
2016-09-23
21:36
[8a6ea455] Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr nodes that do not have substructure. Use that bit to avoid unnecessary recursion. (user: drh, tags: trunk)
20:59
[afac0709] Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the expression tree, where appropriate. This is both smaller and faster. (user: drh, tags: trunk)
18:13
[9a5a489d] New test case for the ORDER BY LIMIT optimization. (user: drh, tags: trunk)
2016-09-22
21:37
[ee1382a3] Fix a potential null-pointer dereference and crash in the case where one thread is calling sqlite3_column_text() and another thread is calling sqlite3_step() on the same prepared statement at the same instant. (user: drh, tags: trunk)
18:53
[c3774c6a] Remove the internal sqlite3CodeOnce() interface, replacing it with a direct call to sqlite3VdbeAddOp0(v,OP_Once). Slightly smaller and faster. (user: drh, tags: trunk)
18:46
[5e892d60] Makefile changes to support building winsqlite3.dll using STDCALL rather than CDECL. (user: mistachkin, tags: trunk)
2016-09-21
23:58
[7785b3a2] Fix speedtest1.c so that it works with SQLITE_OMIT_DEPRECATED. Add the --lean and --cachesize options to speed-check.sh. (user: drh, tags: trunk)
19:43
[0741812d] Fix a problem with the fts5 auxiliary function API causing a crash when a query contained a phrase of zero terms. (user: dan, tags: trunk)
19:00
[4a613d85] Do not run vacuummem.test if ENABLE_MEMORY_MANAGEMENT is defined. (user: dan, tags: trunk)
18:18
[2b44f9aa] Fix obsolete requirements marks. Add new tests for VACUUM of attached databases. (user: drh, tags: trunk)
17:53
[be184bef] Avoid running vacuum5.test in auto-vacuum mode. (user: dan, tags: trunk)
17:47
[46b7d19e] Do not run test "delete_db.test" with either the journaltest or inmemoryjournal permutations. Ensure that the multiplexor tests in delete_db.test are performed in non-autovacuum mode. (user: dan, tags: trunk)
14:41
[d4928fb5] Update the fts5vocab table to handle "ORDER BY term" efficiently. (user: dan, tags: trunk)
2016-09-20
22:04
[db3ebd7c] Improved implementation of 64-bit signed integer multiply that correctly detects overflow (and promotes to floating-point) in some corner cases. Fix for ticket [1ec41379c9c1e400] (user: drh, tags: trunk)
17:49
[72429063] Fix harmless compiler warning. (user: mistachkin, tags: trunk)
17:38
[bd3ecbb5] Fix typo in comment. (user: mistachkin, tags: trunk)
01:46
[21b0e3b7] Further performance enhancements in zeroblob() handling. (user: drh, tags: trunk)
01:19
[5e196fd1] Avoid unnecessary calls to ExpandBlob() for smaller and faster code. (user: drh, tags: trunk)
2016-09-19
23:39
[46002511] Very small optimization in the bytecode engine. (user: drh, tags: trunk)
11:00
[2401ea5a] Fix a segfault introduced by the row-value enhancement that comes up on a skip-scan where the first term of the index is unconstrained and the second term is of the form "columm IN (SELECT...)". (user: drh, tags: trunk)
10:24
[75146165] Improved performance in sqlite3ExprCodeTarget(). (user: drh, tags: trunk)
02:19
[c6e6afb9] Small performance optimization in the expression walker. (user: drh, tags: trunk)
2016-09-18
16:08
[6bf5ba10] Revise the implementation of OP_Once so that it is smaller, faster, and uses less memory. This also fixes an obscure bug introduced 3 days ago by check-in [5990a1bdb4a073]. (user: drh, tags: trunk)
2016-09-17
22:46
[baceb988] Minor enhancement to the TclKit batch tool: it should download the TclKit EXE alone when the TCLKIT_NOENV environment variable is set. (user: mistachkin, tags: trunk)
19:34
[63962e2a] Small performance optimization in the freeSpace() routine of btree.c. (user: drh, tags: trunk)
17:39
[e011435e] Improved description of the ElseNotEq opcode in comments. No changes to code. (user: drh, tags: trunk)
2016-09-16
20:39
[6fc95dd7] Fix typo in the name of a Win32 string conversion routine. Replace several uses of raw_printf() with utf8_printf() in the shell. (user: mistachkin, tags: trunk)
19:42
[03573887] If no KEY is specified on ATTACH, copy the main schema key if the key size is non-zero. In other words, allow for -1 as a valid key size in support of the --textkey to SEE. (user: drh, tags: trunk)
19:11
[e660402e] Fix problems with the fileRead() function in the command-line shell. Fix a harmless memory leak in the command-line shell, to make validation testing easier. (user: drh, tags: trunk)
18:53
[9885dac4] Remove the #ifdef SQLITE_DEBUG from around the testcase_glob() routine in the command-line shell. (user: drh, tags: trunk)
16:30
[a92aee55] Fix a problem causing incorrect code to be generated for IN constraints like "a IN (1, 2, 3)" where column "a" is a rowid column with an extra UNIQUE index created on it. Ticket [0eab1ac759]. (user: dan, tags: trunk)
15:42
[a49bc0a8] Replace a faulty assert() with a testcase() to assure the condition is tested. Ticket [0eab1ac7591f]. (user: drh, tags: trunk)
14:50
[e7653dec] Add WHERETRACE macros showing every entry and exit from whereLoopAddBtreeIndex(). (user: drh, tags: trunk)
11:53
[a3e3b3e1] Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly. (user: drh, tags: trunk)
02:52
[792afefa] In the shell, make ".testcase" and ".check" available in all configurations, not just SQLITE_DEBUG. All testcases to be named. Show the result of each testcase on stdout. (user: drh, tags: trunk)
00:26
[8e5c9203] In the command-line shell, add the --new option to the ".open" command. Also, report the current database filename as part of the ".show" command. (user: drh, tags: trunk)
2016-09-15
21:35
[62289f27] Add the ".testcase" and ".check" dot-commands in the shell, when compiled using SQLITE_DEBUG. (user: drh, tags: trunk)
19:15
[7b104613] Omit the sqlite3Apis constant object when compiling with SQLITE_OMIT_LOAD_EXTENSION, since it is not used. (user: drh, tags: trunk)
14:54
[b9f5bdbf] Remove no-op code (adding an assert() to prove that the code was no-op) in the text affinity logic of the bytecode engine comparison operators. (user: drh, tags: trunk)
05:47
[12df7152] Fix a typo in a comment in sqlite.h.in. No changes to code. (user: dan, tags: trunk)
00:32
[5990a1bd] Slight size reduction and performance increase in sqlite3VdbeHalt(). (user: drh, tags: trunk)
00:04
[5a2a7712] Optimization to vdbeRecordCompareInt() makes it slightly smaller and faster. (user: drh, tags: trunk)
2016-09-14
18:56
[55f7f8ee] Update comments used to generate API documentation to include the new "[dateof:3.X.Y]" notation for dates of release where appropriate. No changes to code. (user: drh, tags: trunk)
2016-09-12
18:50
[29dbef4b] Leaf: Version 3.14.2 (user: drh, tags: release, branch-3.14, version-3.14.2)
14:23
[264e9c75] Fix a bug in sqldiff causing it to confuse blobs zero bytes in size with NULL values. (user: dan, tags: trunk)
13:32
[02f40c3b] Add missing "finish_test" command to vacuum5.test. (user: dan, tags: trunk)
09:28
[e0e042dc] Have releasetest.tcl delete all test files except for "testfixture", "testfixture.exe", "sqlite3", "sqlite3.exe", "test.log" and "test-out.txt" after each test run is finished. Passing the "--keep" option restores the old behaviour. (user: dan, tags: trunk)
2016-09-10
19:51
[711c5917] Changes to give a warning-free build with SQLITE_OMIT_INCRBLOB and SQLITE_OMIT_SHARED_CACHE. (user: drh, tags: trunk)
14:43
[8a9d1281] Add test code to delete an SQLite database and its auxiliary files. (user: dan, tags: trunk)
2016-09-09
20:23
[19e2e595] Remove an unnecessary call to sqlite3VdbeMemExpandBlob() when casting to text. (user: drh, tags: trunk)
19:33
[37803b19] Performance improvements to the comparison operators in the bytecode engine. (user: drh, tags: trunk)
15:12
[6ac932c9] Fix a out-of-order variable declaration for some compile-time configurations. (user: drh, tags: trunk)
13:23
[2bdd838e] In releasetest.tcl, the --srcdir option is automatic, so no need to mention it in the --help output. (user: drh, tags: trunk)
13:17
[afaaa276] Fix an obsolete comment in the releasetest.tcl source code. (user: drh, tags: trunk)
12:29
[9a14e6c4] In releasetest.tcl: Improved testing for uncommitted changes. If uncommitted changes are seen, exit immediately unless the --force option is used. (user: drh, tags: trunk)
2016-09-08
23:18
[a04a21ad] Remove an extra space before function names in the amalgamation. Cherrypick of [20f3c7436f6a8a7bab39]. (user: mistachkin, tags: branch-3.14)
23:12
[30e917ff] Issue a warning and prompt the user to continue if the releasetest.tcl script is run in a checkout with uncommitted changes. (user: drh, tags: trunk)
2016-09-07
20:12
[e9acf616] 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. Cherrypick of [37e6c54b1afc6348]. (user: mistachkin, tags: branch-3.14)
19:54
[ddb5f055] Add support for row-value comparisons, including IN operators, and row-value updates in the UPDATE statement. (user: drh, tags: trunk)
19:47
[c844f3da] Fix the extra comments (added with -DSQLITE_ENABLE_EXPLAIN_COMMENTS) so that the sense of <, <=, >, and >= tests is correct and so that the SQLITE_STOREP2 version is shown correctly. Cherrypick of [4d43c4698eef4e3d]. (user: mistachkin, tags: branch-3.14)
19:31
[71866b36] Merge selected test fixes from trunk. (user: mistachkin, tags: branch-3.14)
19:23
[b3777e1f] Sync up the MSVC makefiles. (user: mistachkin, tags: branch-3.14)
18:11
[12b7782a] Add the ext/misc/memvfs.c extension that implements a VFS for read-only database files contained in memory. (user: drh, tags: trunk)
13:20
[7c2c0d1d] Fix the ".read" command in the command-line shell so that it understands that the input is not interactive. (user: drh, tags: branch-3.14)
12:47
[925ef2f9] Version number to 3.14.2. (user: drh, tags: branch-3.14)
12:41
[af951e03] Makefile changes to support building winsqlite3.dll using STDCALL rather than CDECL. (user: drh, tags: branch-3.14)
12:20
[2d1983ff] Correct affinity computations for a SELECT on the RHS of an IN operator. Fix for ticket [199df4168c]. (user: drh, tags: branch-3.14)
12:08
[b4f8be1f] 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]. (user: drh, tags: branch-3.14)
11:27
[e5c30f22] Fix a problem in internal function sqlite3OpenTableAndIndices causing an operand of an unrelated VM instruction to be overwritten. Fix for [ef360601]. (user: drh, tags: branch-3.14)
10:10
[d8451fe8] Fix the ".read" command in the command-line shell so that it understands that the input is not interactive. (user: drh, tags: trunk)
01:51
[820644b8] 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]. (user: drh, tags: trunk)
2016-09-03
16:23
[672c21bc] Build the generate_series(START,END,STEP) table-valued function into fuzzershell, to make it easier to construct compact test cases that contain actual data. (user: drh, tags: trunk)
2016-09-02
21:34
[9bdf7ca1] Add a test case for the OOM handled by the previous commit. (user: dan, tags: trunk)
21:17
[d9d8a048] Correctly detect an OOM occurring in the setDestPgsz() subroutine of backup. (user: drh, tags: trunk)
17:18
[7908fc60] Within a backup operation, ensure that a read-transaction is opened on the source database before its page size is read. This ensures the page-size used to write to the backup database is the same as its actual page-size, which is important for ZipVFS databases. (user: dan, tags: trunk)
2016-09-01
14:03
[f4ba894a] Have "sqldiff --rbu" ignore rows with NULL values in primary key fields. RBU can't handle such rows and the documentation already says sqldiff ignores them. Because the code now uses "=" instead of "IS" to filter on primary key columns, diffs on virtual tables are faster now too. (user: dan, tags: trunk)
09:35
[38d31e18] If SQLITE_ENABLE_ZIPVFS is defined, journal_mode=off is configured and a savepoint or statement rollback is attempted, move the pager into the error state to prevent the transaction from being committed. This makes it safe to use journal_mode=off with zipvfs under some conditions. (user: dan, tags: trunk)
2016-08-29
14:18
[6602974d] Use some of the example code from the sessions documenatation in the sessions test cases. (user: dan, tags: trunk)
2016-08-27
20:21
[a07269f2] Fix typos in comments. No changes to running code. (user: drh, tags: trunk)
18:35
[78cd64e2] Fix some comments in sqlite3session.h. No changes to code. (user: dan, tags: trunk)
18:34
[d464a7b1] Fixes to fts5 snippet() function. (user: dan, tags: trunk)
14:05
[4d43c469] Fix the extra comments (added with -DSQLITE_ENABLE_EXPLAIN_COMMENTS) so that the sense of <, <=, >, and >= tests is correct and so that the SQLITE_STOREP2 version is shown correctly. These changes are already in the rowvalue branch but are added here since they are technically unrelated to rowvalue. (user: drh, tags: trunk)
2016-08-26
12:00
[70901479] Fix a problem in internal function sqlite3OpenTableAndIndices causing an operand of an unrelated VM instruction to be overwritten. Fix for [ef360601]. (user: dan, tags: trunk)
04:32
[84de17bc] Rename a test procedure in 'speed3.test' to avoid a name collision. (user: mistachkin, tags: trunk)
02:10
[e4aeaa2b] Adapt the special case of '$' in item names for test 'vtabH-3.1' as well. (user: mistachkin, tags: trunk)
01:47
[328f79bb] Make the test 'vtabH-3.1' work when there are less than 5 top-level items. (user: mistachkin, tags: trunk)
01:17
[3680f95f] Support running the fstree tests in 'vtabH.test' on Windows when not using the system drive. (user: mistachkin, tags: trunk)
2016-08-25
23:24
[a8546fee] Fix typos in 'vtabF.test' file. No changes to code. (user: mistachkin, tags: trunk)
22:06
[37e6c54b] 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. (user: drh, tags: trunk)
2016-08-24
18:21
[77f7c31a] Sync up the MSVC autoconf makefile. (user: mistachkin, tags: trunk)
2016-08-23
14:42
[c640489d] Fix the SQLITE_USER_AUTHENTICATION login check so that the SQLITE_AUTH_USER error code correctly propagates and is not overwritten by SQLITE_ERROR. (user: drh, tags: trunk)
2016-08-22
20:10
[78395193] Add support for the SQLITE_DBCONFIG_MAINDBNAME configuration option. (user: drh, tags: trunk)
2016-08-19
15:15
[083f9e62] Enhance the VACUUM command so that it can operate on an attached database. (user: drh, tags: trunk)
2016-08-18
22:19
[cb9865e1] Change the name of Db.zName to Db.zDbSName for improved long-term code maintainability. (user: drh, tags: trunk)
2016-08-17
11:14
[a861713c] Fix a problem in the fts5 snippet() auxiliary function. (user: dan, tags: trunk)
2016-08-16
16:46
[f9035b8e] 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. (user: drh, tags: trunk)
2016-08-13
10:34
[e22252e1] Fix an fts5 problem with corrupt database handling found by address-sanitizer. (user: dan, tags: trunk)
06:38
[fcfbee6c] Fix a buffer overread in fts5. (user: dan, tags: trunk)
2016-08-11
18:53
[a12d8059] Version 3.14.1 (user: drh, tags: release, branch-3.14, version-3.14.1)
18:05
[ed406d31] 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(). (user: dan, tags: trunk)
13:51
[1adb22f5] Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (user: drh, tags: branch-3.14)
13:08
[34aed3a3] Increase the version number to 3.14.1. (user: drh, tags: branch-3.14)
13:03
[03dceaea] Enhance sqlite3PcacheTruncate() to run faster in the common case where the cutoff is just a few pages less than the page number highwater mark. (user: drh, tags: branch-3.14)
09:55
[ab83d707] Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (user: dan, tags: trunk)
01:24
[2ea0c8b4] Fix a harmless compiler warning in FTS5. (user: drh, tags: trunk)
2016-08-10
20:02
[95493058] Optimization to sqlite3WhereExprUsage(). (user: drh, tags: trunk)
19:43
[7319d676] List of MATCH operator names in isMatchOfColumn() should be constant. (user: drh, tags: trunk)
18:56
[ebccbd96] Performance enhancement in the expression walker. (user: drh, tags: trunk)
15:02
[059f4e2e] Tweaks to pcache1TruncateUnsafe() to make it slightly smaller and faster and easier to test. (user: drh, tags: trunk)
14:40
[25d1d02b] 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. (user: drh, tags: trunk)
13:34
[8c2701e7] Increment the version number to 3.15. (user: drh, tags: trunk)
13:30
[83622f3f] 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. (user: drh, tags: trunk)
11:50
[b07a26df] Fix pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. (user: drh, tags: trunk)
01:43
[ba6663be] Performance optimization in the yy_find_shift_action() routine of the Lemon-generated parser. (user: drh, tags: trunk)
2016-08-09
21:01
[9a5a4f6e] Fix harmless compiler warning. (user: drh, tags: trunk)
19:48
[14864f2b] Minor update to the way fts5 column filters are parsed. (user: dan, tags: trunk)
19:26
[e5175456] Have fts5 interpret column lists that begin with a "-" character as "match any column except" lists. (user: dan, tags: trunk)
2016-08-08
13:40
[d5e98057] Version 3.14 (user: drh, tags: trunk, release, version-3.14.0)