SQLite
Timeline
Not logged in

47 timeline items tagged with "trunk" occurring on or after release.

2016-09-26
14:39
[cf7f9e6d] Leaf: 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)