/ Timeline
Login

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

100 check-ins occurring around 0c8b9b211f4285e2.

2016-10-12
18:55
Avoid reading the -1-th element of an array in the query planner. Fix to a bug introduced by check-in [8e2b25f9b8a7] from earlier today. Curiously, the problem only appeared on 32-bit systems. check-in: 443913d5 user: drh tags: trunk
18:26
Add to sqlite3_analyzer command-line options --version and --tclsh, and also the undocumented --debug option. check-in: e87d02d2 user: drh tags: trunk
15:15
New testcase() macros to ensure coverage of the ORDER BY LIMIT optimization code in where.c. check-in: 61f05269 user: drh tags: trunk
14:48
Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. check-in: 8e2b25f9 user: dan tags: trunk
2016-10-10
14:48
Remove a stray line from session4.test causing a memory leak. No changes to SQLite code. check-in: 6624c496 user: dan tags: trunk
14:34
When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444]. check-in: aebe429e user: dan tags: trunk
13:29
Make sure indexes on expressions skip over initial NULL values in the index. Fix for ticket [4baa464912129477f3c9] check-in: 71797ba4 user: drh tags: trunk
10:06
Fix a case in which the rtree module was ignoring an OOM while generating an error message. check-in: 788f86be user: dan tags: trunk
2016-10-08
16:10
Update test/trace3.test to account for the fact that casting a pointer to a 64-bit signed integer might produce a negative value. check-in: 010ec225 user: dan tags: trunk
13:34
Corrections to Lemon documentation. No SQLite changes. check-in: c568ae3e user: drh tags: trunk
11:55
Add missing "static" to internal function whereRangeVectorLen(). check-in: cbed3d75 user: dan tags: trunk
09:21
Updates to the tool/warnings.sh script to make it easier to use on OpenBSD. check-in: dbe2997f user: dan tags: trunk
2016-10-05
20:14
Fix some compiler warnings in fts5. check-in: b066637b user: dan tags: trunk
20:10
Fix harmless compiler warnings. check-in: 2dde3375 user: drh tags: trunk
15:04
Add a test case for the fix in [a596b7c6cc]. check-in: b2ef39b1 user: dan tags: trunk
15:02
Do not set MEM_Blob unless the appropriate fields of the Mem object have been correctly initialized. check-in: a596b7c6 user: drh tags: trunk
01:33
Fix the backup_malloc.test script so that it works on Windows. check-in: d080012d user: drh tags: trunk
2016-10-04
12:20
Fix a problem with the lempar.c parser template. check-in: 3a9d802f user: drh tags: trunk
00:47
Do not bother to initialize unused fields in the BtreePayload object. check-in: b10d0f93 user: drh tags: trunk
2016-10-03
18:13
Allow deterministic functions in the WHERE clause of a partial index. check-in: c6e9b942 user: drh tags: trunk
16:33
Size and performance optimizations on the sqlite3ExprAssignVarNumber() routine. check-in: 109852e5 user: drh tags: trunk
15:28
Avoid unnecessary strlen() calls in sqlite3ExprAssignVarNumber() by passing in the token length from the parser. check-in: d15ae2e5 user: drh tags: trunk
14:44
Avoid unnecessary memset() calls in the query optimizer. check-in: 5bb7cde0 user: drh tags: trunk
12:56
Fix an obsolete comment on a variable definition in expr.c. No code changes. check-in: 012ff6dd user: drh tags: trunk
02:59
Make sure the sqlite_sequence table is updated when an optional xfer optimization is used. Fix for ticket [7b3328086a5c1]. check-in: 81e4d4f8 user: drh tags: trunk
01:21
Allocate Parse objects off of the stack where appropriate for a substantial performance increase and a size reduction. check-in: ea8affa9 user: drh tags: trunk
2016-10-01
23:55
Add SQLITE_USE_ALLOCA to the --lean configuration in speed-check.sh. check-in: fe07609e user: drh tags: trunk
21:43
Rearrange fields in the Parse object to reduce the amount of initialization required. check-in: 361940b4 user: drh tags: trunk
20:43
Reduce the width of a memset() to avoid double-initializing some variables. check-in: 34edbfd1 user: drh tags: trunk
19:32
Remove an unnecessary memset() call. check-in: a76bff74 user: drh tags: trunk
19:21
Use sqlite3DbMallocRawNN() where appropriate, instead of sqlite3DbMallocRaw(). check-in: 54a449a4 user: drh tags: trunk
16:53
Make sure deleting an unused prepared statement does not reference uninitialized fields in the structure. check-in: 7983eef0 user: drh tags: trunk
11:39
Avoid accessing Vdbe.pc if it is uninitialized. Check Vdbe.magic first. check-in: 6ac6e446 user: drh tags: trunk
00:37
Avoid unnecessary zeroing of fields in the Vdbe object when it is allocated. check-in: 1e21bbe8 user: drh tags: trunk
2016-09-30
22:24
Avoid initializing the column-cache section of the Parse object, since entries in the cache will be initialized as they are used, and avoiding the initial memset() saves many CPU cycles. check-in: 63cf7eaf user: drh tags: trunk
21:20
Fix an always-true conditional left over from the previous commit. check-in: ab12fce3 user: drh tags: trunk
20:22
Fix the Parse.aColCache column cache so that all of the valid entries are in the first Parse.nColCache slots. check-in: 60285020 user: drh tags: trunk
19:14
Another simplification to the Parse object. check-in: c1419727 user: drh tags: trunk
18:35
Remove unnecessary fields from the Parse object. check-in: 814e41da user: drh tags: trunk
17:46
Avoid unnecessary Mem initializations when generating a new sqlite3_stmt object. check-in: 47ae1cda user: drh tags: trunk
2016-09-29
20:28
Small size and performance optimization to sqlite3VdbeChangeP5(). check-in: 3c93c8f5 user: drh tags: trunk
19:50
Remove the peep-hole optimization of removing OP_Close opcodes that come before OP_Halt, as the extra work of removing those opcodes uses more cycles than just running them. check-in: 984a96d7 user: drh tags: trunk
19:27
Size and performance optimization to sqlite3ValueFromExpr() check-in: 945f82bc user: drh tags: trunk
15:53
Clarification and typo-fixes in comments. No changes to code. check-in: e2cd79aa user: drh tags: trunk
2016-09-28
20:42
Use Knuth multiplicative hashing for the symbol table. check-in: cc29ddd6 user: drh tags: trunk
16:15
Merge recent enhancements from trunk. check-in: 06014163 user: drh tags: apple-osx
16:05
Two more typo fixes in comments. check-in: 40c0fb0a user: drh tags: trunk
16:04
Fix typos in comments. No code changes. check-in: 5bbd071d user: drh tags: trunk
2016-09-27
00:09
Update requirements marks due to improvements in the wording of documentation. No changes to code. check-in: bf903b2e user: drh tags: trunk
00:03
Fix FTS3 test cases due to the flattener change of the previous check-in. check-in: 0c8b9b21 user: drh tags: trunk
2016-09-26
14:39
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. check-in: cf7f9e6d user: dan tags: trunk
12:38
Inline the relevent parts of sqlite3ExprAlloc() into spanExpr(), for a performance improvement. check-in: fe89225e user: drh tags: trunk
2016-09-24
17:42
Omit the LikeOp object from the parser. Change more sqlite3PExpr() calls into sqlite3ExprAlloc() calls. check-in: 795454a3 user: drh tags: trunk
01:41
Add -DSQLITE_MAX_EXPR_DEPTH=0 to the --lean option on speed-check.sh. check-in: a8cb1390 user: drh tags: trunk
2016-09-23
21:36
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. check-in: 8a6ea455 user: drh tags: trunk
20:59
Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the expression tree, where appropriate. This is both smaller and faster. check-in: afac0709 user: drh tags: trunk
18:13
New test case for the ORDER BY LIMIT optimization. check-in: 9a5a489d user: drh tags: trunk
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-22
21:37
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. check-in: ee1382a3 user: drh tags: trunk
18:53
Remove the internal sqlite3CodeOnce() interface, replacing it with a direct call to sqlite3VdbeAddOp0(v,OP_Once). Slightly smaller and faster. check-in: c3774c6a user: drh tags: trunk
18:46
Makefile changes to support building winsqlite3.dll using STDCALL rather than CDECL. check-in: 5e892d60 user: mistachkin tags: trunk
2016-09-21
23:58
Fix speedtest1.c so that it works with SQLITE_OMIT_DEPRECATED. Add the --lean and --cachesize options to speed-check.sh. check-in: 7785b3a2 user: drh tags: trunk
19:43
Fix a problem with the fts5 auxiliary function API causing a crash when a query contained a phrase of zero terms. check-in: 0741812d user: dan tags: trunk
19:00
Do not run vacuummem.test if ENABLE_MEMORY_MANAGEMENT is defined. check-in: 4a613d85 user: dan tags: trunk
18:18
Fix obsolete requirements marks. Add new tests for VACUUM of attached databases. check-in: 2b44f9aa user: drh tags: trunk
17:53
Avoid running vacuum5.test in auto-vacuum mode. check-in: be184bef user: dan tags: trunk
17:47
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. check-in: 46b7d19e user: dan tags: trunk
14:41
Update the fts5vocab table to handle "ORDER BY term" efficiently. check-in: d4928fb5 user: dan tags: trunk
2016-09-20
22:04
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] check-in: db3ebd7c user: drh tags: trunk
17:49
Fix harmless compiler warning. check-in: 72429063 user: mistachkin tags: trunk
17:38
Fix typo in comment. check-in: bd3ecbb5 user: mistachkin tags: trunk
01:46
Further performance enhancements in zeroblob() handling. check-in: 21b0e3b7 user: drh tags: trunk
01:19
Avoid unnecessary calls to ExpandBlob() for smaller and faster code. check-in: 5e196fd1 user: drh tags: trunk
2016-09-19
23:39
Very small optimization in the bytecode engine. check-in: 46002511 user: drh tags: trunk
11:00
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...)". check-in: 2401ea5a user: drh tags: trunk
10:24
Improved performance in sqlite3ExprCodeTarget(). check-in: 75146165 user: drh tags: trunk
02:19
Small performance optimization in the expression walker. check-in: c6e6afb9 user: drh tags: trunk
2016-09-18
16:08
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]. check-in: 6bf5ba10 user: drh tags: trunk
2016-09-17
22:46
Minor enhancement to the TclKit batch tool: it should download the TclKit EXE alone when the TCLKIT_NOENV environment variable is set. check-in: baceb988 user: mistachkin tags: trunk
19:34
Small performance optimization in the freeSpace() routine of btree.c. check-in: 63962e2a user: drh tags: trunk
17:39
Improved description of the ElseNotEq opcode in comments. No changes to code. check-in: e011435e user: drh tags: trunk
2016-09-16
20:39
Fix typo in the name of a Win32 string conversion routine. Replace several uses of raw_printf() with utf8_printf() in the shell. check-in: 6fc95dd7 user: mistachkin tags: trunk
19:42
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. check-in: 03573887 user: drh tags: trunk
19:11
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. check-in: e660402e user: drh tags: trunk
18:53
Remove the #ifdef SQLITE_DEBUG from around the testcase_glob() routine in the command-line shell. check-in: 9885dac4 user: drh tags: trunk
17:50
Merge recent changes from trunk. check-in: e3d9efa2 user: drh tags: apple-osx
16:30
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]. check-in: a92aee55 user: dan tags: trunk
15:42
Replace a faulty assert() with a testcase() to assure the condition is tested. Ticket [0eab1ac7591f]. check-in: a49bc0a8 user: drh tags: trunk
14:50
Add WHERETRACE macros showing every entry and exit from whereLoopAddBtreeIndex(). check-in: e7653dec user: drh tags: trunk
11:53
Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly. check-in: a3e3b3e1 user: drh tags: trunk
02:52
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. check-in: 792afefa user: drh tags: trunk
00:26
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. check-in: 8e5c9203 user: drh tags: trunk
2016-09-15
21:35
Add the ".testcase" and ".check" dot-commands in the shell, when compiled using SQLITE_DEBUG. check-in: 62289f27 user: drh tags: trunk
19:15
Omit the sqlite3Apis constant object when compiling with SQLITE_OMIT_LOAD_EXTENSION, since it is not used. check-in: 7b104613 user: drh tags: trunk
14:54
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. check-in: b9f5bdbf user: drh tags: trunk
05:47
Fix a typo in a comment in sqlite.h.in. No changes to code. check-in: 12df7152 user: dan tags: trunk
00:32
Slight size reduction and performance increase in sqlite3VdbeHalt(). check-in: 5990a1bd user: drh tags: trunk
00:04
Optimization to vdbeRecordCompareInt() makes it slightly smaller and faster. check-in: 5a2a7712 user: drh tags: trunk
2016-09-14
18:56
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. check-in: 55f7f8ee user: drh tags: trunk
01:43
Backport the ORDER BY LIMIT optimization to version 3.8.9. check-in: db361482 user: drh tags: branch-3.8.9