SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2016-12-09
00:15
[1f16c9a7] Leaf: Fix an obscure problem in range estimation with STAT4. (user: drh, tags: trunk)
2016-12-08
23:52
[92998e4a] Fix the showstat4 utility program so that is displays strings using standard SQL notation (single quotes) rather than C-style notation. (user: drh, tags: trunk)
19:04
[b26df26e] Fix a minor error in the cg_anno.tcl script causing the cycles-per-file counts to be miscomputed. (user: drh, tags: trunk)
18:36
[254a83bf] Update the tool/cg_anno.tcl script to give a summary of cycle counts by canonical source file name. (user: drh, tags: trunk)
01:38
[83bc5e40] More changes to take advantage of the sqlite3VdbeAppendP4() method. (user: drh, tags: trunk)
2016-12-07
21:35
[28883e8f] Add the sqlite3VdbeAppendP4() method for adding P4 content to the most recently coded instruction. (user: drh, tags: trunk)
20:22
[3954f837] The use P4_DYNAMIC in place of the P4_MPRINTF operand type. (user: drh, tags: trunk)
20:09
[04716c90] Performance optimization for sqlite3VdbeAddOp4(). (user: drh, tags: trunk)
17:06
[24574a15] Put the SQLITE_UNTESTABLE compile-time option in the correct order for PRAGMA compile_options. (user: drh, tags: trunk)
15:49
[f3608187] Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. (user: drh, tags: trunk)
15:38
[433d16ff] Prevent the flattening or where-term push-down optimizations from obscuring misuses of SQL row values that can lead to crashes or assert() failures. (user: dan, tags: trunk)
13:49
[afab1663] Always honor the sqlite3.dbOptFlags bitmask, regardless of compile-time options. Continuing fix for ticket [da78413751863]. (user: drh, tags: trunk)
07:46
[391344d8] Leaf: Merge latest trunk changes into this branch. (user: dan, tags: changebatch)
2016-12-06
22:47
[2a81763e] Performance improvement and size reduction in the Expr node allocator function sqlite3PExpr(). (user: drh, tags: trunk)
19:33
[0820f8b3] Add missing nul-terminator to a Tcl_AppendResult() call in tclsqlite.c. (user: dan, tags: trunk)
17:59
[e8247065] In the LEMON parser-generator, fix the stack overflow processing so that it correct invokes the destructor on the top-level of the parse stack. (user: drh, tags: trunk)
2016-12-05
20:16
[b4bc40d1] Fix a harmless redundant local variable declaration in the date/time function logic. (user: drh, tags: trunk)
20:06
[8df492c1] Work around a bug in the definition of "ino_t" on some versions of Android. (user: drh, tags: trunk)
2016-12-02
19:07
[6e144735] Simplify the date/time function logic for improved rebustness and also to decrease the size of the binary. (user: drh, tags: trunk)
17:08
[768c9859] Extend the valid range of 'unixepoch' dates from JulianDay 0 through 9999-12-31. (user: drh, tags: trunk)
14:15
[3c58b173] Closed-Leaf: Fix a potential integer overflow during out-of-bound date computations. (user: drh, tags: date-overflow-fix)
02:19
[0bdb7ae1] Test cases for the improved LIKE/GLOB matcher. (user: drh, tags: trunk)
2016-12-01
19:58
[a427c405] Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening sub-selects. Possible fix for [2df0107b]. (user: dan, tags: trunk)
19:38
[8bed4cd5] Closed-Leaf: Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening sub-selects. Possible fix for [2df0107b]. (user: dan, tags: left-join-fix)
18:57
[2df0ebf9] Performance improvement for GLOB and LIKE matching for patterns with two or more multi-character wildcards ("*" or "%"). (user: drh, tags: trunk)
18:49
[a1e2b6ce] Closed-Leaf: Faster version of patternCompare() that uses new return values rather than an extra parameter to communicate wildcard information back up to parent searches. (user: drh, tags: pattern-compare-optimization)
17:34
[c5e5614d] Modify the patternCompare() function (used for GLOB, LIKE) to better handle patterns containing multiple wildcard characters ("*", "%"). (user: dan, tags: pattern-compare-optimization)
2016-11-30
16:54
[d2d30914] Add the remember(V,PTR) extension function which copies an SQL value into an application variable. (user: drh, tags: trunk)
16:39
[7ca58a07] Leaf: Merge all the latest changes from trunk. (user: drh, tags: est_count_pragma)
14:47
[3816bb41] Fix then handling of the (oversized) integer literal -0x8000000000000000. (user: drh, tags: trunk)
05:08
[9d0d8c2e] Change the OP_DecrJumpZero opcode back to its old behavior of always decrementing, except top the decrementing when it reaches the largest negative number. (user: drh, tags: trunk)
04:07
[1218005a] More improvements to boundary cases in the date/time functions, flowing out of branch coverage testing. (user: drh, tags: trunk)
01:05
[96106d56] Prevent a warning about integer overflow when using a very large negative LIMIT. (user: drh, tags: trunk)
00:48
[dc453b34] Further changes to the date/time functions to suppress harmless signed integer overflow warnings that could have occurred when doing out-of-range date calculations which, according to the docs, give undefined results. (user: drh, tags: trunk)
2016-11-29
20:39
[d410a839] The documentation says that the built-in date-time functions give undefined results for dates before 0000-01-01 and after 9999-12-31. Change the actually implementation so that the answer given is really NULL. This also avoids unnecessary hand-wringing over an signed integer overflow that might otherwise occur when processing out-of-bound dates. (user: drh, tags: trunk)
2016-11-28
21:22
[9021f687] Fix broken hyperlinks to the sqlite3_snapshot objection definition in the documentation. No changes to code. (user: drh, tags: trunk)
14:52
[7cc2d60d] Simplify some code in fts5_expr.c. Add some extra test cases for the same. (user: dan, tags: trunk)
2016-11-26
20:44
[41a3af54] Leaf: Merge all recent trunk changes, and especially the new sqlite3_snapshot_recover() interface. (user: drh, tags: apple-osx)
19:44
[b70c85ce] Add the sqlite3_snapshot_recover() interface and related functionality. (user: drh, tags: trunk)
2016-11-25
20:20
[a4205a83] Clarification of the behavior of sqlite3_stmt_readonly() on BEGIN IMMEDIATE statements. The is comment changes only - no changes to code. (user: drh, tags: trunk)
19:32
[6ac7b07a] Remove the OP_RowKey opcode. Use OP_RowData in its place. (user: drh, tags: trunk)
19:18
[49ebc219] Refactor the sqlite3BtreeKey() and sqlite3BtreeData() internal interfaces into sqlite3BtreePayload() and sqlite3BtreePayloadChecked(), respectively. This is a continuation of the optimization started by check-in [2d831074cf]. The result is a slightly smaller and faster binary. (user: drh, tags: trunk)
17:03
[a9498407] Small performance increase and size reduction in the OP_Column opcode. (user: drh, tags: trunk)
15:47
[c53dca7f] Performance enhancement to sqlite3_snprintf(). (user: drh, tags: trunk)
15:11
[b6acf5d4] Performance improvement in sqlite3StrAccumFinish() for the common case where no memory allocation is required. (user: drh, tags: trunk)
14:30
[6df7c574] Add a comment to help clarify the EP_FromJoin hack in exprCodeBetween(). (user: drh, tags: trunk)
2016-11-23
23:18
[9a603a18] Fix the error message for invalid ".mode" arguments in the command-line shell, so that it mentions the new "quote" mode. (user: drh, tags: trunk)
19:31
[c08aff13] Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (user: dan, tags: trunk)
14:19
[161192f1] Correctly display the names of SQL functions in the VDBE_PROFILE output. (user: drh, tags: trunk)
2016-11-22
22:23
[e2c4bdf5] Closed-Leaf: Merge bug fixes and enhancements from trunk. (user: drh, tags: serializable-snapshot)
20:29
[bee2859b] Add a new requirement mark for CAST expressions. (user: drh, tags: trunk)
19:15
[f5ac98ef] Update requirement marks to reflect changes in wording in the documentation. No changes to code. (user: drh, tags: trunk)
01:26
[32be7aae] Remove unnecessary OP_Close opcodes for a size reduction and performance increase. (user: drh, tags: trunk)
2016-11-21
21:33
[abeddb6d] Remove unnecessary OP_Close opcodes at the end of INSERT operations, resulting in smaller and faster code. (user: drh, tags: trunk)
18:15
[9979ba80] Enhance speedtest1.c so that is works on older versions of SQLite, before the introduction of the group_concat() aggregate function. (user: drh, tags: trunk)
2016-11-20
17:59
[b3b7b42d] Fix harmless compiler warnings. (user: drh, tags: trunk)
12:00
[0a98c8d7] Prevent a possible use-after-free bug in the query optimizer. (user: drh, tags: trunk)
2016-11-17
21:52
[4fe94b0f] Leaf: Experimental changes for faster in-memory DB operation for large databases. (user: drh, tags: memdb-opt)
20:05
[d6b3779e] Fix a problem in rtreeD.test causing it to fail in OMIT_BUILTIN_TEST builds. (user: dan, tags: trunk)
13:54
[2331192b] Change the --enable-debug option on configure so that it enables the ".selecttrace" and ".wheretrace" commands in the command-line shell. (user: drh, tags: trunk)
13:13
[005d5b87] Disable the query flattener optimization for SELECT statements that are on the RHS of vector IN operators. This is a hack that fixes the bug described in ticket [da7841375186386c]. A better solution that does not disable the query flattener is needed, but this will server for the time being. (user: drh, tags: trunk)
2016-11-15
21:17
[77aeb705] Add a needed #include to speedtest1.c. (user: drh, tags: trunk)
17:37
[b6a81fa1] Experimental changes toward making snapshots serializable. (user: drh, tags: serializable-snapshot)
04:00
[66347385] Change the OP_Last opcode so that it is a no-op if the cursor is already pointing at the end of the b-tree. (user: drh, tags: trunk)
02:46
[5ed0bd38] Make the VACUUM command about 9% faster by avoiding unnecessary calls to sqlite3BtreeMovetoUnpacked() while copying rowid tables. (user: drh, tags: trunk)
2016-11-14
20:47
[03f75a67] Add 8794 new test cases received from the OSS-FUZZ project. (user: drh, tags: trunk)
20:08
[c5dbc599] Fix a potential use-after-free error during parsing of malformed CREATE TABLE statement. (user: drh, tags: trunk)
18:27
[a71fad45] Enhance fuzzcheck.c to accept database-specific configuration parameters in the option CONFIG table. Add the fuzzdata5.db fuzz database containing test cases from OSS-FUZZ. (user: drh, tags: trunk)
17:25
[6f2d43ec] Fix the ossfuzz.c test module so that it does not segfault after a "PRAGMA empty_result_callbacks=1;". Add the ossshell.c program for simple command-line testing of ossfuzz.c. (user: drh, tags: trunk)
15:28
[e211c579] Avoid unnecessary calls to sqlite3ExprCacheAffinityChange() when generating OP_MakeRecord opcodes that do not change any register affinities. (user: drh, tags: trunk)
08:19
[e78f6f3b] Fix an fts5 problem causing a crash in phrase queries where the first token of the phrase matches one or more rows but some other token within the phrase matches zero. (user: dan, tags: trunk)
2016-11-11
20:37
[7b76be41] Fix harmless compiler warnings in test code for MSVC. (user: drh, tags: trunk)
19:08
[b835cf3e] Avoid storing redundant fields in sorter records when the sort-key and data have fields in common. (user: drh, tags: trunk)
19:01
[925840cf] Enhance the OP_IdxInsert opcode so that it can used unpacked key values if they are available. Update the code generator to take advantage of this new capability. The speedtest1.c test is about 2.6% faster as a result. (user: drh, tags: trunk)
18:45
[dd62d2de] Closed-Leaf: Merge trunk with this branch. (user: dan, tags: sorter-opt)
18:19
[1a587d72] Closed-Leaf: Remove obselete and unused logic in the update code generator. Fix the sqlite3BtreeMovetoUnpacked() routine so that it remembers the rowid of the row that it landed on. (user: drh, tags: unpacked-IdxInsert)
17:52
[5515b827] Merge enhancements and bug-fixes from trunk. (user: drh, tags: unpacked-IdxInsert)
17:08
[46e00162] Fix a problem with switching from wal to rollback mode when SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE is configured. (user: dan, tags: trunk)
16:33
[119d6ef8] Add the test/ossfuzz.c interface adaptor for OSS-FUZZ. Make previsions for testing the adaptor using fuzzcheck.c. (user: drh, tags: trunk)
15:49
[fba5fddb] Handle some obscure "row value misused" cases that could cause segfaults or assertion failures. (user: dan, tags: trunk)
14:54
[f98c8ac8] Back out the "--raw" option on ".read" in the command-line shell. Instead, fix the command-line shell so that if EOF is reached without seeing a final semicolon, it goes ahead and passes the accumulated SQL text to SQLite. (user: drh, tags: trunk)
09:51
[642a8fba] Add extra tests for the xBestIndex() virtual table method. (user: dan, tags: trunk)
05:19
[6311a8bd] In the command line shell, avoid using utf8_printf() in a couple places where it is superfluous. (user: mistachkin, tags: trunk)
04:37
[09233770] Add the --raw option to the ".read" dot-command of the command-line shell, to cause the named file to be read and sent directly into sqlite3_exec() without any interpretation. (user: drh, tags: trunk)
03:37
[b0ff183b] Take care not to try to generate code for the ATTACH and DETACH commands if there were syntax errors during parsing. Fix for ticket [2f1b168ab4d4844] (user: drh, tags: trunk)
2016-11-10
20:14
[0af62fdb] Avoid storing redundant fields in sorter records when the sort-key and data have fields in common (as in "SELECT a FROM t1 ORDER BY 1"). (user: dan, tags: sorter-opt)
2016-11-09
01:46
[b4889588] Fix typo in the CSV extension. (user: mistachkin, tags: trunk)
01:07
[754ee844] Add a DISTINCT query to speedtest1.c. Also change INSERT OR REPLACE into just REPLACE. (user: drh, tags: trunk)
00:57
[d6dd2ad3] Remove the "experimental" marking from the sqlite3_preupdate interfaces. But be sure all the interface definitions are within documentation. (user: drh, tags: trunk)
00:10
[89d958ab] Enhance the OP_IdxInsert opcode to optionally accept unpacked key material. (user: drh, tags: unpacked-IdxInsert)
2016-11-08
19:22
[bec5b6d4] Avoid superfluous cursor seeks in "INSERT OR REPLACE" statements. (user: dan, tags: trunk)
17:19
[8cb8516d] Avoid generating OP_TableLock unnecessary instructions on btrees that are not sharable. (user: drh, tags: trunk)
16:27
[c2f84f63] Fix the speedtest1.c test program so that it gives closing "%" wildcards on LIKE searches. (user: drh, tags: trunk)
00:30
[b5733cae] Tweaks to speedtest1.c to better reflect mobile usage based on findings in the "Pocket Data" paper by Kennedy, Ajay, Challen, and Ziarek. (user: drh, tags: trunk)
2016-11-07
18:18
[b5409849] Fix OOM error reporting in the json1_group_object() SQL function. Remove an unreachable branch from the JSON1 logic. (user: drh, tags: trunk)
15:15
[145cd13e] Replace some unreachable branches from the JSON1 extension with assert(). (user: drh, tags: trunk)
13:37
[7a635391] Fix the JSON1 extension so that the JSON validator correctly rejects malformed backslash escapes within string literals. (user: drh, tags: trunk)
2016-11-04
19:09
[0e5ffd91] Merge recent trunk changes, including all the fixes that appeared in version 3.15.1. (user: drh, tags: apple-osx)
12:05
[b86b79c4] Avoid a crash that can occur after an obscure OOM in the built-in INSTR() function. (user: dan, tags: trunk)
12:03
[afbbb6c6] Mark the ICU extension functions as deterministic. (user: drh, tags: trunk)
11:23
[97354093] Add an assert() to silence a coverity false-positive. (user: drh, tags: trunk)
07:25
[81c86401] Fix a test case in vacuum5.test so that it works with the in-memory journal permutation. (user: dan, tags: trunk)
2016-11-03
21:35
[1d0e43c5] Replace a couple more references to Tcl 8.5 in the Windows build tools. (user: mistachkin, tags: trunk)
19:24
[3ca80010] Fix a test case in vacuum5.test sot aht it works with -DSQLITE_ENABLE_ATOMIC_WRITE. (user: dan, tags: trunk)
19:01
[f5dd95e2] Fix a test case in vacuum5.test so that it works with -DSQLITE_TEMP_STORE=2. (user: dan, tags: trunk)
18:30
[63cfe197] Avoid using the "direct overflow read" optimization to read large blobs if the pager layer has a wal file open - even if the database header indicates that the db is not a wal database. (user: drh, tags: branch-3.15)
13:12
[ba9873da] In the command-line shell, fix the .imposter command so that it works with indexes on expressions. Fix the ".mode quote" mode so that it works with ".headers ON". (user: drh, tags: trunk)
13:01
[be3ec8fd] Add the ".imposter" command to the command-line shell. (user: drh, tags: trunk)
02:25
[ad08753a] Fix an possible NULL pointer deference in the command-line shell that can occur when using imposter mode. (user: drh, tags: trunk)
2016-11-02
19:49
[def8f598] Adjust the MSVC makefile to use Tcl8.6 by default. (user: drh, tags: trunk)
14:50
[30288453] Fix an issue that was causing the new database image to be assembled entirely in heap memory when VACUUMing a database, even if it should use a temp file. This could cause SQLITE_NOMEM errors when vacuuming very large databases on 32-bit systems. (user: dan, tags: trunk)
13:18
[d18f61b7] Fix a requirement mark. No changes to code. (user: drh, tags: trunk)
02:17
[9b3a3b41] Use NOT NULL partial indexes when the query is constrained by a single LIKE or GLOB. (user: drh, tags: trunk)
2016-10-31
16:49
[6d142025] Add the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE sqlite3_dbconfig() option - for disabling SQLite's default checkpoint-on-close behaviour. (user: dan, tags: trunk)
16:16
[093d2fc2] Closed-Leaf: Add the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE sqlite3_dbconfig() option - for disabling SQLite's default checkpoint-on-close behaviour. (user: dan, tags: no-ckpt-on-close)
2016-10-27
14:51
[6374978e] Remove the mutex from test_multiplex.c. (user: dan, tags: trunk)
01:02
[619f5cc7] Make sure left-join markings are transferred to the virtual scalar subexpressions when decomposing a vector comparison in the ON clause of a LEFT JOIN. Fix for ticket [fef4bb4bd9185ec8f]. (user: drh, tags: trunk)
2016-10-26
18:41
[c23f5ef3] Small size reduction and performance enhancement in whereScanInit(). (user: drh, tags: trunk)
17:57
[d861ee17] Small size reduction and performance improvement in whereScanNext(). (user: drh, tags: trunk)
16:05
[ec9dab80] If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the same index, set the index cursor to return NULL values if there are no matches for a row on the lhs. Fix for ticket [34a579141b2c5ac] (user: dan, tags: trunk)
15:46
[e7b9bc67] Closed-Leaf: If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the same index, set the index cursor to return NULL values if there are no matches for a row on the lhs. (user: dan, tags: leftjoin-or-fix)
13:58
[86675ae0] Merge the SQLITE_ENABLE_URI_00_ERROR compile-time option. (user: drh, tags: trunk)
13:44
[1aaa06e3] Closed-Leaf: Add extra tests to check the result of including a %00 escape in a URI when ENABLE_URI_00_ERROR is defined. (user: dan, tags: uri-00-error)
12:15
[e8a9bfec] Add compile time option SQLITE_ENABLE_URI_00_ERROR. If defined, any "%00" escape found in a URI is treated as an error. (user: dan, tags: uri-00-error)
2016-10-25
15:39
[fe49fb03] Leaf: Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. (user: drh, tags: index-info-on-table)
15:06
[b1158564] Add test case to demonstrate a "BEGIN EXCLUSIVE" command returning SQLITE_BUSY_SNAPSHOT. (user: dan, tags: trunk)
2016-10-24
01:01
[98795c2d] Performance optimization in moveToRoot(). Avoid repeated validity checking of the root page on each call. Once is enough. (user: drh, tags: trunk)
2016-10-22
01:22
[5f3e6028] In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. (user: drh, tags: trunk)
2016-10-21
21:21
[b861328a] Closed-Leaf: In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. (user: dan, tags: sessions-fix)
17:45
[0c8a5b88] Merge updates from trunk, and especially the ".mode quote" enhancement to the shell. (user: drh, tags: est_count_pragma)
17:39
[c4f5fa78] Add ".mode quote" to the command-line shell. (user: drh, tags: trunk)
10:49
[b54c15f1] Avoid using the "direct overflow read" optimization to read large blobs if the pager layer has a wal file open - even if the database header indicates that the db is not a wal database. (user: dan, tags: trunk)
10:09
[b7d9727b] If SQLITE_DIRECT_OVERFLOW_READ is defined at compile time, add "DIRECT_OVERFLOW_READ" to the list of symbols returned by "PRAGMA compile_options". (user: dan, tags: trunk)
2016-10-20
18:20
[fd81d8a4] Leaf: Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. (user: drh, tags: multi-arg-pragma)
11:48
[fd9c6ff0] Add test case to incrblob4.test. No changes to code. (user: dan, tags: trunk)
2016-10-18
16:36
[56474ebc] Minor simplification of the comparison opcodes. (user: drh, tags: trunk)
15:29
[2aa7a03b] Fix harmless uninitialized variable warnings in speedtest1.c. (user: drh, tags: trunk)
14:35
[6ca0e06b] Add the --repeat option to speedtest1.c and speed-check.sh. (user: drh, tags: trunk)
2016-10-17
18:44
[5ec02ecf] Escape non-ASCII character from an ICU extension comment. (user: mistachkin, tags: trunk)
18:33
[3d89dc45] Corrections to a couple recently added 'filectrl.test' results. (user: mistachkin, tags: trunk)
15:28
[c88d36e2] Changes to support interrupting a checkpoint using sqlite3_interrupt(). (user: dan, tags: trunk)
00:48
[cda998f0] Small size reduction and performance increase in the string duplicator. (user: drh, tags: trunk)
2016-10-15
18:37
[16d88a90] Add documentation for the OP_SorterInsert opcode, formerly omitted by mistake. No changes to code. (user: drh, tags: trunk)
08:56
[2674d779] Add test case to hook.test. No changes to non-test code. (user: dan, tags: trunk)
2016-10-14
21:27
[16039be3] Add the SQLITE_FCNTL_WIN32_GET_HANDLE file control. (user: mistachkin, tags: trunk)
21:16
[aa6de9c4] Bump the version number in anticipation of the next development cycle. (user: drh, tags: trunk)
10:20
[70787558] Version 3.15.0 (user: drh, tags: trunk, release, version-3.15.0)
2016-10-13
12:56
[4d66ac98] Take care to avoid integer overflow when doing the initial page cache allocation with an excessively large cache_size setting. (user: drh, tags: trunk)
2016-10-12
18:55
[443913d5] 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. (user: drh, tags: trunk)
18:26
[e87d02d2] Add to sqlite3_analyzer command-line options --version and --tclsh, and also the undocumented --debug option. (user: drh, tags: trunk)
15:15
[61f05269] New testcase() macros to ensure coverage of the ORDER BY LIMIT optimization code in where.c. (user: drh, tags: trunk)
14:48
[8e2b25f9] Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. (user: dan, tags: trunk)
2016-10-10
14:48
[6624c496] Remove a stray line from session4.test causing a memory leak. No changes to SQLite code. (user: dan, tags: trunk)
14:34
[aebe429e] When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444]. (user: dan, tags: trunk)
13:29
[71797ba4] Make sure indexes on expressions skip over initial NULL values in the index. Fix for ticket [4baa464912129477f3c9] (user: drh, tags: trunk)
10:06
[788f86be] Fix a case in which the rtree module was ignoring an OOM while generating an error message. (user: dan, tags: trunk)
2016-10-08
16:10
[010ec225] Update test/trace3.test to account for the fact that casting a pointer to a 64-bit signed integer might produce a negative value. (user: dan, tags: trunk)
13:34
[c568ae3e] Corrections to Lemon documentation. No SQLite changes. (user: drh, tags: trunk)
11:55
[cbed3d75] Add missing "static" to internal function whereRangeVectorLen(). (user: dan, tags: trunk)
09:21
[dbe2997f] Updates to the tool/warnings.sh script to make it easier to use on OpenBSD. (user: dan, tags: trunk)
2016-10-05
20:14
[b066637b] Fix some compiler warnings in fts5. (user: dan, tags: trunk)
20:10
[2dde3375] Fix harmless compiler warnings. (user: drh, tags: trunk)
15:04
[b2ef39b1] Add a test case for the fix in [a596b7c6cc]. (user: dan, tags: trunk)
15:02
[a596b7c6] Do not set MEM_Blob unless the appropriate fields of the Mem object have been correctly initialized. (user: drh, tags: trunk)
01:33
[d080012d] Fix the backup_malloc.test script so that it works on Windows. (user: drh, tags: trunk)
2016-10-04
12:20
[3a9d802f] Fix a problem with the lempar.c parser template. (user: drh, tags: trunk)
00:47
[b10d0f93] Do not bother to initialize unused fields in the BtreePayload object. (user: drh, tags: trunk)
2016-10-03
18:13
[c6e9b942] Allow deterministic functions in the WHERE clause of a partial index. (user: drh, tags: trunk)
16:33
[109852e5] Size and performance optimizations on the sqlite3ExprAssignVarNumber() routine. (user: drh, tags: trunk)
15:28
[d15ae2e5] Avoid unnecessary strlen() calls in sqlite3ExprAssignVarNumber() by passing in the token length from the parser. (user: drh, tags: trunk)
14:44
[5bb7cde0] Avoid unnecessary memset() calls in the query optimizer. (user: drh, tags: trunk)
12:56
[012ff6dd] Fix an obsolete comment on a variable definition in expr.c. No code changes. (user: drh, tags: trunk)
02:59
[81e4d4f8] Make sure the sqlite_sequence table is updated when an optional xfer optimization is used. Fix for ticket [7b3328086a5c1]. (user: drh, tags: trunk)
01:21
[ea8affa9] Allocate Parse objects off of the stack where appropriate for a substantial performance increase and a size reduction. (user: drh, tags: trunk)
2016-10-01
23:55
[fe07609e] Add SQLITE_USE_ALLOCA to the --lean configuration in speed-check.sh. (user: drh, tags: trunk)
21:43
[361940b4] Rearrange fields in the Parse object to reduce the amount of initialization required. (user: drh, tags: trunk)
20:43
[34edbfd1] Reduce the width of a memset() to avoid double-initializing some variables. (user: drh, tags: trunk)
19:32
[a76bff74] Remove an unnecessary memset() call. (user: drh, tags: trunk)
19:21
[54a449a4] Use sqlite3DbMallocRawNN() where appropriate, instead of sqlite3DbMallocRaw(). (user: drh, tags: trunk)
16:53
[7983eef0] Make sure deleting an unused prepared statement does not reference uninitialized fields in the structure. (user: drh, tags: trunk)
11:39
[6ac6e446] Avoid accessing Vdbe.pc if it is uninitialized. Check Vdbe.magic first. (user: drh, tags: trunk)
00:37
[1e21bbe8] Avoid unnecessary zeroing of fields in the Vdbe object when it is allocated. (user: drh, tags: trunk)
2016-09-30
22:24
[63cf7eaf] 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. (user: drh, tags: trunk)
21:20
[ab12fce3] Fix an always-true conditional left over from the previous commit. (user: drh, tags: trunk)
20:22
[60285020] Fix the Parse.aColCache column cache so that all of the valid entries are in the first Parse.nColCache slots. (user: drh, tags: trunk)
19:14
[c1419727] Another simplification to the Parse object. (user: drh, tags: trunk)
18:35
[814e41da] Remove unnecessary fields from the Parse object. (user: drh, tags: trunk)
17:46
[47ae1cda] Avoid unnecessary Mem initializations when generating a new sqlite3_stmt object. (user: drh, tags: trunk)
2016-09-29
20:28
[3c93c8f5] Small size and performance optimization to sqlite3VdbeChangeP5(). (user: drh, tags: trunk)
19:50
[984a96d7] 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. (user: drh, tags: trunk)
19:27
[945f82bc] Size and performance optimization to sqlite3ValueFromExpr() (user: drh, tags: trunk)
15:53
[e2cd79aa] Clarification and typo-fixes in comments. No changes to code. (user: drh, tags: trunk)
2016-09-28
20:42
[cc29ddd6] Use Knuth multiplicative hashing for the symbol table. (user: drh, tags: trunk)
16:15
[06014163] Merge recent enhancements from trunk. (user: drh, tags: apple-osx)
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)