SQLite
Timeline
Not logged in

All nodes on the path from [release] to [trunk]

2016-05-02
19:05
[5830cf72] Leaf: Remove some randomness from test script temptable2.test. (user: dan, tags: trunk)
16:59
[088cf838] Fix a test case in temptable2.test so that it works on systems that lack a coherient cache (ex: OpenBSD) and thus do not support the "PRAGMA mmap_size" command. (user: drh, tags: trunk)
13:57
[e4af9675] Fix harmless LLVM compiler warnings in the srcck1.c utility program used during the build process. (user: drh, tags: trunk)
12:18
[3f221f59] Disable the multi-row one-pass DELETE optimization when the WHERE clause contains a subquery. Fix for ticket [dc6ebeda9396087]. (user: drh, tags: trunk)
10:25
[54c63b32] Improvements to the way the LIKE optimization is implemented, resulting in slightly smaller and faster code that is easier to test. (user: drh, tags: trunk)
2016-04-30
19:23
[820c57bb] Change the way tester.tcl handes $argv so that in "permutations.test <permutation> <filename>" <filename> may be the name of any file in the test/ directory. (user: dan, tags: trunk)
18:10
[459a0b45] Remove an unnecessary branch from the OP_String8 opcode. (user: drh, tags: trunk)
17:19
[762bdc55] More bug fixes to Lemon identified by Kelvin Sherlock. None of these have any impact on SQLite. (user: drh, tags: trunk)
02:59
[daf4630f] Simplifications to the OP_Halt opcode implementation. (user: drh, tags: trunk)
2016-04-29
20:30
[614bb709] Fix the temporary directory search algorithm for unix so that it fails gracefully even if all candidate directories are inaccessible. This fixes a bug that was introduced by check-in [9b8fec60d8e]. (user: drh, tags: trunk)
15:39
[9d0a5ae0] Postpone I/O associated with TEMP files for as long as possible, with the hope that the I/O can ultimately be avoided completely. (user: drh, tags: trunk)
11:33
[4cbd5024] Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. Fix a mostly harmless buffer overread in the sessions module. (user: dan, tags: trunk)
11:28
[4792d6db] Lemon bug fix: Do not merge action routines unless their destructors are also identical. Problem and suggested fix reported on the mailing list by Kelvin Sherlock. (user: drh, tags: trunk)
02:55
[e7c22e3b] Some optimization comments added to vdbe.c. No functional changes to code. (user: drh, tags: trunk)
2016-04-28
22:29
[9f15a520] Further simplifications and improved commentting on the rowset.c module, including several optimization comments. (user: drh, tags: trunk)
20:11
[8cdbe89a] Comment changes only: Add several optimization marks in rowset.c. Add a header comment that explains what the various special comments mean. (user: drh, tags: trunk)
19:23
[9f6f17b5] Fix typo in comment. No changes to code. (user: mistachkin, tags: trunk)
18:53
[5748e643] Rearrange some code in the RowSet logic for clarity of presentation, while adding an /*OPTIMIZATION-IF-TRUE*/ comment. It should operate identically. (user: drh, tags: trunk)
14:15
[33e62747] Use comments to mark several branches as optimizations. No changes to code. (user: drh, tags: trunk)
03:52
[fcf85bfe] Remove an unnecessary conditional from the sqlite3DecOrHexToI64() routine. (user: drh, tags: trunk)
00:32
[46d4ffff] Change the sqlite3Atoi64() routine so that it returns failure if not all of the input characters are consumed, even if it consumed all characters up to the first 0x00. This has no impact on external APIs as far as I can tell. (user: drh, tags: trunk)
2016-04-27
15:24
[0065fe97] More simplification of the sqlite3AtoF() routine. Add special comments to indicate branches that are for optimization purposes only and that give the correct answer even if always or never taken. (user: drh, tags: trunk)
02:35
[3adfe9f3] Remove still more unnecessary branches from sqlite3AtoF(). (user: drh, tags: trunk)
2016-04-26
23:14
[dd69e53c] Further simplifications to sqlite3AtoF() to remove unneeded branches. (user: drh, tags: trunk)
21:02
[a9d00749] Remove an unnecessary line from the sqlite3AtoF() routine. (user: drh, tags: trunk)
18:58
[12418b10] The pcache and the built-in VFSes should not use mutexes when SQLITE_CONFIG_SINGLETHREAD is set. (user: drh, tags: trunk)
13:13
[d819bfbd] Fix the "checksymbols" target in Makefile.in to be able to deal with the sqlite3changegroup family of interfaces. (user: drh, tags: trunk)
2016-04-25
19:25
[7dd48c10] Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. (user: dan, tags: trunk)
02:20
[ec215f94] When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. (user: drh, tags: trunk)
01:43
[d0a579b3] Fix a typo in the Makefile. (user: mistachkin, tags: trunk)
2016-04-23
20:59
[b38fe522] Fix the fix to the temporary directory search algorithm so that it continues to return "." as a fallback if that directory has the correct permissions. (user: drh, tags: trunk)
2016-04-21
23:37
[67985761] Change the temporary directory search algorithm on unix so that directories with only -wx permission are allowed. And do not allow "." to be returned if it lacks -wx permission. (user: drh, tags: trunk)
18:13
[bd4a6f83] Add the sqlite3rbu_vacuum() API, to create an RBU handle that can be used to rebuild a database in the same way as the VACUUM command. (user: dan, tags: trunk)
02:27
[c4f165c4] Add the SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION method for enabling sqlite3_load_extension() while leaving the load_extension() SQL function disabled. (user: drh, tags: trunk)
2016-04-20
19:30
[3340f086] When an error occurs while transitioning out of WAL mode, make sure the locking state is not left at EXCLUSIVE. (user: drh, tags: trunk)
18:31
[38a4e9d9] Fix a locking race condition in Windows 10 that can occur when two or more processes attempt to recover the same hot journal at the same time. (user: drh, tags: trunk)
2016-04-18
17:30
[92dc59fd] Leaf: Version 3.12.2 (user: drh, tags: release, branch-3.12.0, version-3.12.2)
16:18
[39dd67af] Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (user: drh, tags: branch-3.12.0)
16:12
[a2cf4968] Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (user: drh, tags: branch-3.12.0)
16:06
[368e86c7] Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (user: drh, tags: branch-3.12.0)
15:59
[9c37e9ce] Increase the version number to 3.12.2. (user: drh, tags: branch-3.12.0)
15:54
[ab9d279f] Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (user: drh, tags: branch-3.12.0)
15:46
[eba27d4d] Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (user: drh, tags: trunk)
13:09
[3a7d7298] The last parameter to pread64() and pwrite64() should be off64_t, not off_t. (user: drh, tags: trunk)
2016-04-15
15:03
[3e217d62] CLI enhancement: Add the ".eqp full" option, that shows both the EXPLAIN QUERY PLAN and the EXPLAIN output for each command run. Also disable any ".wheretrace" and ".selecttrace" when showing EQP output. (user: drh, tags: trunk)
2016-04-14
17:29
[d23e5813] In the ICU extension toupper() and tolower() SQL functions, avoid calling u_strToUpper() or u_strToLower() a second time if the buffer passed to the first invocation turns out to be large enough. (user: dan, tags: trunk)
16:40
[7b7a69d0] Add the SF_HasAgg constant (currently unused). Also enhance the comments on many other constant definitions to detail constraints on their values. (user: drh, tags: trunk)
15:44
[79147dca] Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (user: dan, tags: trunk)
15:38
[67d7f79c] Add some missing testcase() macros to the pushDownWhereTerms() routine. (user: drh, tags: trunk)
13:35
[53179614] Rename WhereInfo.pResultSet to pDistinctSet to more accurately reflect what it represents. (user: drh, tags: trunk)
13:16
[7ee570e7] Since the return value of sqlite3OsClose() is always ignored, we might as well make it "void" instead of "int", and thereby save 50 bytes in the compiled binary. (user: drh, tags: trunk)
13:06
[5a469145] Additional ".selecttrace" debugging output when the query is transformed from a DISTINCT into a GROUP BY. (user: drh, tags: trunk)
2016-04-13
21:00
[55a62483] Fix compiler warnings by removing surplus local variables in the schema pretty-printer logic of the command-line shell. (user: drh, tags: trunk)
15:52
[68142dc5] Fixes for harmless compiler warnings. (user: drh, tags: trunk)
15:33
[83cfe82c] Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (user: drh, tags: trunk)
2016-04-12
19:30
[bedb88a4] Compilation fix for a C99-ism in the 'fts3view' tool. (user: mistachkin, tags: trunk)
19:20
[a18a6ce2] Fix harmless compiler warnings in the 'session' module. (user: mistachkin, tags: trunk)
17:13
[b65b69f6] Fix speedtest1 so that it automatically unlinks its test database prior to startup. (user: drh, tags: trunk)
16:59
[8053a6e2] Add the --temp option to the speedtest1.c performance test program. (user: drh, tags: trunk)
16:23
[662c32af] Improved localtime() support for WindowsCE (user: drh, tags: trunk)
16:04
[7e728965] Add the sqlite3_snapshot_cmp() interface (available only with SQLITE_ENABLE_SNAPSHOT). (user: drh, tags: trunk)
11:58
[07f10dea] Update the header comment on the memjournal.c file. No code changes. (user: drh, tags: trunk)
00:26
[e2c4995b] Performance optimization the Vdbe allocator. (user: drh, tags: trunk)
00:16
[aec94b6e] Avoid unnecessary calls to object destructors for a small performance gain. (user: drh, tags: trunk)
00:00
[fdf75239] Performance improvements in sqlite3WhereExprUsage(). (user: drh, tags: trunk)
2016-04-11
22:23
[3189a7f1] Fix typo in the MSVC makefile. (user: mistachkin, tags: trunk)
19:01
[9efe2265] Performance optimization to sqlite3Dequote() and its callers. (user: drh, tags: trunk)
18:25
[2764aeaa] Performance optimization for the sqlite3ExprListDelete() routine. (user: drh, tags: trunk)
18:15
[e35b345c] Performance optimizations in the column cache of the code generator, and especially the sqlite3ExprCacheRemove() routine. (user: drh, tags: trunk)
16:43
[476cc283] Simplification and performance improvements in sqlite3ExprDup() and its subroutines. More work is possible in this area. (user: drh, tags: trunk)
16:35
[e554a4c3] Rename the OP_MX_JUMP macro to SQLITE_MX_JUMP_OPCODE to avoid confusing the opcode name generator. (user: drh, tags: trunk)
14:49
[60ad80e3] Performance improvement in sqlite3ExprDelete(). (user: drh, tags: trunk)
13:36
[099478fa] Remove the VdbeOp.opflags field and its associated initialization overhead. Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values() routine run faster. (user: drh, tags: trunk)
01:43
[ef1966c2] Back off of the parser optimization in the previous check-in, slightly, to preserve some backwards compatibility regarding some undocumented behavior in the '#AAA' style query parameter. (user: drh, tags: trunk)
01:26
[16df7128] Small size reduction and performance improvement in the parser. (user: drh, tags: trunk)
01:06
[6a5cceee] Factor out the common operation of setting the Expr.x.pSelect field of an Expr object into a subroutine. (user: drh, tags: trunk)
2016-04-09
18:04
[6c56b3a0] Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (user: drh, tags: trunk)
17:04
[ca2ef8a8] Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (user: drh, tags: trunk)
14:36
[3686ed74] Limit the number of digits shown in the "prereq" mask for ".wheretrace" debugging output. (user: drh, tags: trunk)
2016-04-08
19:44
[1dfa5234] Update documentation for sqlite3_snapshot_open(). No code changes. (user: drh, tags: trunk)
15:09
[fe7d3b75] Version 3.12.1 (user: drh, tags: release, branch-3.12.0, version-3.12.1)
2016-04-07
23:18
[84d2a09e] Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (user: drh, tags: branch-3.12.0)
21:29
[300f1b61] Update the version number to 3.12.1. This is the first release candidate. (user: drh, tags: branch-3.12.0)
21:29
[3360ab09] Carry table column types through into VIEW definitions, where possible. (user: drh, tags: branch-3.12.0)
21:22
[c232b99e] Prevent the in-memory journal read cursor from entering an inconsistent state when it reads the last few bytes out of the journal file. Fix for ticket [7f7f8026eda38]. (user: drh, tags: branch-3.12.0)
21:14
[87aa9357] Add test cases for ticket [7f7f8026eda387d544]. (user: drh, tags: trunk)
18:42
[c4b9c611] Prevent the in-memory journal read cursor from entering an inconsistent state when it reads the last few bytes out of the journal file. Fix for ticket [7f7f8026eda38]. (user: drh, tags: trunk)
14:16
[153135bf] Avoid decrementing a pointer off the front end of the buffer in OP_MakeRecord. (user: drh, tags: trunk)
14:05
[8415d484] Instead of just commenting out the unneeded code in the previous check-in, remove it completely. (user: drh, tags: trunk)
14:01
[e84e88e3] Remove an unnecessary test for a NULL pointer in freeP4(). (user: drh, tags: trunk)
13:45
[716b20de] Update comments on the unix file locking protocol. No changes to code. (user: drh, tags: trunk)
2016-04-06
17:32
[ea4de04d] Add a couple options to the MSVC makefile. (user: mistachkin, tags: branch-3.12.0)
2016-04-05
23:39
[da81d7af] Remove an unnecessary branch in the sqlite3LogEstToInt() routine. (user: drh, tags: trunk)
20:59
[fb555c3c] Carry table column types through into VIEW definitions, where possible. (user: drh, tags: trunk)
19:46
[0bf9926c] Remove superfluous directories from the Makefile clean targets. (user: mistachkin, tags: trunk)
15:59
[cf569f9f] Incorrect version of build.c checked in at [87e5f5a6c60e3] (because I neglected to press the "Save" button on the text editor). There is no change to the logic, just improved presentation. (user: drh, tags: trunk)
14:02
[ed128e8b] Make sure "0" intended as a NULL pointer is cast to a pointer when used in a varargs functions parameter. (user: drh, tags: trunk)
14:01
[87e5f5a6] Remove an unnecessary conditional from the index builder. (user: drh, tags: trunk)
13:35
[7cacf4e9] Use SQLITE_WITHIN() for pointer range comparisons in some testing code. (user: drh, tags: trunk)
13:19
[85b97931] Do not allow pointer arithmetic to move a pointer across a memory allocation boundary. (user: drh, tags: trunk)
2016-04-04
18:04
[d5fc2f7f] Fix documentation typos. Comment changes only. No changes to code. (user: drh, tags: trunk)
17:59
[cefd36ff] Improve error messages from the 'shell1-5.0' test. (user: mistachkin, tags: trunk)
17:34
[4534ebf1] Improved handling of UTF8 by the command-line shell. (user: drh, tags: trunk)
17:23
[65c7bcc4] Add the ".auth ON|OFF" command to the command-line shell. (user: drh, tags: trunk)
16:40
[8627a4cd] Test that the view name is passed to the authorization callback when a SELECT statement is run on a view. (user: dan, tags: trunk)
14:57
[42a21966] Enhance sqlite3session_apply() and sqlite3session_apply_strm() so that conflicts are retried before the xConflict() callback is invoked, as long as the "apply" operation is making forward progress. (user: drh, tags: trunk)
13:46
[e375fe52] Minor performance optimization in the comparison opcodes of the VDBE. (user: drh, tags: trunk)
12:38
[0213d6af] Fix harmless compiler warnings. (user: drh, tags: trunk)
2016-04-01
17:54
[59814f35] Preupdate hook documentation fixes. No changes to code. (user: drh, tags: trunk)
12:35
[a62340dc] When reading an sqlite_stat1 table with missing entries for some indexes, set the default for the missing indexes after all other indexes are set so that the default values are more in line with indexes that are actually in the stat1 table. (user: drh, tags: trunk)
2016-03-31
22:53
[69f4d832] Update the clean target in the MSVC makefile. (user: mistachkin, tags: trunk)
20:40
[c648539b] Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (user: drh, tags: trunk)
2016-03-30
16:23
[7cf0cab7] Updates for the MSVC makefiles. (user: mistachkin, tags: trunk)
16:22
[64d75cbe] Fix typo in comment. No changes to code. (user: mistachkin, tags: trunk)
15:30
[47887ef8] Simplifications and clarification to update callback handling in the OP_Delete and OP_Insert opcodes. (user: drh, tags: trunk)
14:26
[e9bcd5ac] Increase the version number to 3.13.0 on account of the new session extension. (user: drh, tags: trunk)
14:17
[9cdf813c] Remove a redundant test for disabling RESTRICT with defer_foreign_keys=ON. (user: drh, tags: trunk)
13:43
[4af7a90f] Incorporate the sessions extension and the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. (user: drh, tags: trunk)
12:20
[e4bee561] Improvements to the performance testing program "speedtest1.c" and the shell script that invokes it. (user: drh, tags: trunk)
2016-03-29
10:14
[e9bb4cf4] Version 3.12.0 (user: drh, tags: trunk, release, version-3.12.0)