SQLite
Timeline
Not logged in

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

2016-12-02
19:07
[6e144735] Leaf: 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)
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)
18:57
[2df0ebf9] Performance improvement for GLOB and LIKE matching for patterns with two or more multi-character wildcards ("*" or "%"). (user: drh, tags: trunk)
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)
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)
19:13
[bbd85d23] Leaf: Version 3.15.2 (user: drh, tags: release, branch-3.15, version-3.15.2)
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
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-24
13:42
[e31d646a] Fix a test case in vacuum5.test so that it works with the in-memory journal permutation. Cherrypick of [81c86401]. (user: dan, tags: branch-3.15)
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)
21:33
[f693850a] Updates makefiles and build scripts on windows to used Tcl 8.6. (user: drh, tags: branch-3.15)
21:14
[86dc74cb] Update the version number to 3.15.2. (user: drh, tags: branch-3.15)
21:13
[4c6efe60] Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (user: drh, tags: branch-3.15)
21:08
[661b4506] Prevent a possible use-after-free bug in the query optimizer. (user: drh, tags: branch-3.15)
21:01
[27438fb4] 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: branch-3.15)
20:44
[0f956597] Fix a potential use-after-free error during parsing of malformed CREATE TABLE statement. (user: drh, tags: branch-3.15)
20:37
[4efd331e] 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: drh, tags: branch-3.15)
20:31
[6492e57e] Fix OOM error reporting in the json1_group_object() SQL function. Remove an unreachable branch from the JSON1 logic. (user: drh, tags: branch-3.15)
20:24
[7c466283] Fix the JSON1 extension so that the JSON validator correctly rejects malformed backslash escapes within string literals. (user: drh, tags: branch-3.15)
20:19
[8a55b8e1] Avoid a crash that can occur after an obscure OOM in the built-in INSTR() function. (user: drh, tags: branch-3.15)
20:12
[8fd2fcce] Mark the ICU extension functions as deterministic. (user: drh, tags: branch-3.15)
19:43
[794763fd] Handle some obscure "row value misused" cases that could cause segfaults or assertion failures. (user: drh, tags: branch-3.15)
19:40
[f8cf7ff1] 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: branch-3.15)
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
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
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)
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)
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-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)
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
12:08
[1136863c] Version 3.15.1 (user: drh, tags: release, branch-3.15, version-3.15.1)
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:27
[752e14d9] Fix a test case in vacuum5.test so that it works with -DSQLITE_TEMP_STORE=2 and -DSQLITE_ENABLE_ATOMIC_WRITE.. (user: dan, tags: branch-3.15)
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:49
[5221e3cc] Add the SQLITE_FCNTL_WIN32_GET_HANDLE file control. (user: drh, tags: branch-3.15)
18:44
[ccdcce46] Increase the version number to 3.15.1. (user: drh, tags: branch-3.15)
18:38
[ee16fedd] Escape non-ASCII character from an ICU extension comment. (user: drh, tags: branch-3.15)
18:36
[3fae483f] 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: drh, tags: branch-3.15)
18:35
[aba1e22b] 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: branch-3.15)
18:33
[54eeddec] 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: drh, tags: branch-3.15)
18:31
[0fc4f0f4] 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: branch-3.15)
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)
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)
13:58
[86675ae0] Merge the SQLITE_ENABLE_URI_00_ERROR compile-time option. (user: drh, tags: trunk)
2016-10-25
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
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
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)