Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
140 events for the month beginning 2016-04-01 by user drh
Following month ↑|
2016-04-30
| ||
| 18:10 | Remove an unnecessary branch from the OP_String8 opcode. (check-in: 459a0b45 user: drh tags: trunk) | |
| 17:19 | More bug fixes to Lemon identified by Kelvin Sherlock. None of these have any impact on SQLite. (check-in: 762bdc55 user: drh tags: trunk) | |
| 02:59 | Simplifications to the OP_Halt opcode implementation. (check-in: daf4630f user: drh tags: trunk) | |
|
2016-04-29
| ||
| 20:30 | 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]. (check-in: 614bb709 user: drh tags: trunk) | |
| 17:07 | Fix the nolock VFS so that it supports shared memory. (check-in: ce11f8e8 user: drh tags: apple-osx) | |
| 16:01 | Merge the latest enhancements from trunk. (check-in: 91e5c07e user: drh tags: begin-concurrent) | |
| 15:52 | Merge enhancements from trunk, and in particular the TEMP file deferred I/O enhancements. (check-in: 81b76901 user: drh tags: apple-osx) | |
| 15:39 | Postpone I/O associated with TEMP files for as long as possible, with the hope that the I/O can ultimately be avoided completely. (check-in: 9d0a5ae0 user: drh tags: trunk) | |
| 11:28 | 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. (check-in: 4792d6db user: drh tags: trunk) | |
| 02:55 | Some optimization comments added to vdbe.c. No functional changes to code. (check-in: e7c22e3b user: drh tags: trunk) | |
|
2016-04-28
| ||
| 22:29 | Further simplifications and improved commentting on the rowset.c module, including several optimization comments. (check-in: 9f15a520 user: drh tags: trunk) | |
| 20:11 | Comment changes only: Add several optimization marks in rowset.c. Add a header comment that explains what the various special comments mean. (check-in: 8cdbe89a user: drh tags: trunk) | |
| 18:53 | Rearrange some code in the RowSet logic for clarity of presentation, while adding an /*OPTIMIZATION-IF-TRUE*/ comment. It should operate identically. (check-in: 5748e643 user: drh tags: trunk) | |
| 14:15 | Use comments to mark several branches as optimizations. No changes to code. (check-in: 33e62747 user: drh tags: trunk) | |
| 03:52 | Remove an unnecessary conditional from the sqlite3DecOrHexToI64() routine. (check-in: fcf85bfe user: drh tags: trunk) | |
| 00:32 | 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. (check-in: 46d4ffff user: drh tags: trunk) | |
|
2016-04-27
| ||
| 15:24 | 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. (check-in: 0065fe97 user: drh tags: trunk) | |
| 02:35 | Remove still more unnecessary branches from sqlite3AtoF(). (check-in: 3adfe9f3 user: drh tags: trunk) | |
|
2016-04-26
| ||
| 23:14 | Further simplifications to sqlite3AtoF() to remove unneeded branches. (check-in: dd69e53c user: drh tags: trunk) | |
| 21:02 | Remove an unnecessary line from the sqlite3AtoF() routine. (check-in: a9d00749 user: drh tags: trunk) | |
| 18:58 | The pcache and the built-in VFSes should not use mutexes when SQLITE_CONFIG_SINGLETHREAD is set. (check-in: 12418b10 user: drh tags: trunk) | |
| 13:13 | Fix the "checksymbols" target in Makefile.in to be able to deal with the sqlite3changegroup family of interfaces. (check-in: d819bfbd user: drh tags: trunk) | |
|
2016-04-25
| ||
| 22:39 | Add an sqlite3FaultSim() all to make it easier to simulate IO errors in a VACUUM commit. (check-in: 8bfde416 user: drh tags: tempfiles-25) | |
| 19:28 | Remove an obsolete comment from the pager. No code changes. (check-in: 36f97ca8 user: drh tags: tempfiles-25) | |
| 19:20 | Fix some unreachable branches in the pager. (check-in: 3ae44770 user: drh tags: tempfiles-25) | |
| 15:03 | Merge bug fix from trunk. (check-in: a905d5e0 user: drh tags: tempfiles-25) | |
| 02:20 | 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]. (check-in: ec215f94 user: drh tags: trunk) | |
| 02:20 | • Fixed ticket [f7f8c97e]: Valid query fails to compile due to WHERE clause optimization plus 5 other changes (artifact: c320a9dd user: drh) ... 1 similar event omitted. | |
|
2016-04-23
| ||
| 21:16 | Merge the temporary directory search algorithm fix from trunk. (check-in: 9b8fec60 user: drh tags: tempfiles-25) | |
| 20:59 | 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. (check-in: b38fe522 user: drh tags: trunk) | |
| 19:55 | Merge the latest trunk changes. (check-in: 84da122d user: drh tags: tempfiles-25) | |
|
2016-04-21
| ||
| 23:37 | 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. (check-in: 67985761 user: drh tags: trunk) | |
| 15:44 | Merge the latest changes from trunk. (Closed-Leaf check-in: 8183fa68 user: drh tags: skip-ahead-distinct) | |
| 15:35 | Merge all recent enhancements from trunk. (check-in: a15c49ae user: drh tags: apple-osx) | |
| 15:24 | Add a function prototype in order to fix a compiler warning. (check-in: 49aec971 user: drh tags: tempfiles-25) | |
| 15:03 | Merge updates from trunk. (check-in: cc28106e user: drh tags: tempfiles-25) | |
| 02:27 | Add the SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION method for enabling sqlite3_load_extension() while leaving the load_extension() SQL function disabled. (check-in: c4f165c4 user: drh tags: trunk) | |
| 01:58 | Test cases for SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION. (Closed-Leaf check-in: debafa5e user: drh tags: load-ext-security) | |
| 01:30 | Revert sqlite3_enable_load_extension() to its original long-standing behavior. Add SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION which will enable only the C-API and leave the SQL function disabled. (check-in: b2ae5bfa user: drh tags: load-ext-security) | |
|
2016-04-20
| ||
| 19:30 | When an error occurs while transitioning out of WAL mode, make sure the locking state is not left at EXCLUSIVE. (check-in: 3340f086 user: drh tags: trunk) | |
| 18:31 | 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. (check-in: 38a4e9d9 user: drh tags: trunk) | |
| 12:16 | Merge all recent enhancements from trunk. (check-in: 1f709fbf user: drh tags: begin-concurrent) | |
| 00:30 | API Change: Modify sqlite3_enable_load_extension() so that it only enables/disables the load_extension() SQL function, and leaves the C-APIs enabled at all times. In this way, applications can enable extension loading for the C interface without having to expose that capability to the SQL. (check-in: edb454e4 user: drh tags: load-ext-security) | |
|
2016-04-18
| ||
| 18:40 | • Edit [92dc59fd5ad66f64|92dc59fd]: Add tag "release". (artifact: c00916fd user: drh) | |
| 18:40 | • Edit [92dc59fd5ad66f64|92dc59fd]: Change background color to "#d0c0ff". Edit check-in comment. Add tag "version-3.12.2". (artifact: f9f38516 user: drh) | |
| 17:30 | Version 3.12.2 (Leaf check-in: 92dc59fd user: drh tags: release, branch-3.12.0, version-3.12.2) | |
| 16:18 | 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). (check-in: 39dd67af user: drh tags: branch-3.12.0) | |
| 16:12 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: a2cf4968 user: drh tags: branch-3.12.0) | |
| 16:06 | 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] (check-in: 368e86c7 user: drh tags: branch-3.12.0) | |
| 15:59 | Increase the version number to 3.12.2. (check-in: 9c37e9ce user: drh tags: branch-3.12.0) | |
| 15:58 | • Fixed ticket [7d7525cb]: Compatibility break on INTEGER PRIMARY KEY columns. plus 5 other changes (artifact: 7d322fdd user: drh) | |
| 15:54 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: ab9d279f user: drh tags: branch-3.12.0) | |
| 15:53 | • Edit [abf9d602eefd9de6|abf9d602]: Move to branch mistake. Add propagating "hidden". Mark "Closed". Edit check-in comment. (artifact: 58464421 user: drh) | |
| 15:46 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: eba27d4d user: drh tags: trunk) | |
| 15:24 | • New ticket [7d7525cb] Compatibility break on INTEGER PRIMARY KEY columns.. (artifact: b61cd89a user: drh) | |
| 13:36 | Merge recent trunk changes. (check-in: d9768de5 user: drh tags: tempfiles-25) | |
| 13:30 | sqlite3PCachePerecentDirty() should return 0 if the pcache is empty. (check-in: 85f3d80e user: drh tags: tempfiles-25) | |
| 13:09 | The last parameter to pread64() and pwrite64() should be off64_t, not off_t. (check-in: 3a7d7298 user: drh tags: trunk) | |
|
2016-04-15
| ||
| 22:03 | Add the SQLITE_SkipAhead optimization setting (check-in: 87703b76 user: drh tags: skip-ahead-distinct) | |
| 16:27 | Skip-ahead is now just an optimization. If it gets confused, it falls back to an incremental scan with redundancy elimination. (check-in: 6fac0b92 user: drh tags: skip-ahead-distinct) | |
| 16:17 | Skip-ahead does not always work. So we still have to check for redundancy. (check-in: db5a2364 user: drh tags: skip-ahead-distinct) | |
| 15:54 | Fixes to the skip-ahead distinct logic. More issues remain. (check-in: 45a70b2b user: drh tags: skip-ahead-distinct) | |
| 15:06 | Merge enhancements from trunk, especially the ".eqp full" enhancement to the command-line shell. (check-in: 491f0dbd user: drh tags: skip-ahead-distinct) | |
| 15:03 | 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. (check-in: 3e217d62 user: drh tags: trunk) | |
| 14:13 | Several new test cases that cause failures. (check-in: 0379f2cf user: drh tags: skip-ahead-distinct) | |
| 13:24 | Fixed crash bugs. Still sometimes gets the wrong answers. (check-in: 2afcb2c7 user: drh tags: skip-ahead-distinct) | |
| 01:55 | Progress toward getting DISTINCT to use a seek to advance to the next distinct row, when driven by an appropriate index. (check-in: 9e14aa14 user: drh tags: skip-ahead-distinct) | |
|
2016-04-14
| ||
| 19:29 | Work toward improving analysis and code generation for DISTINCT and aggregate queries. (Leaf check-in: 129083bd user: drh tags: better-distinct-agg) | |
| 16:40 | Add the SF_HasAgg constant (currently unused). Also enhance the comments on many other constant definitions to detail constraints on their values. (check-in: 7b7a69d0 user: drh tags: trunk) | |
| 15:38 | Add some missing testcase() macros to the pushDownWhereTerms() routine. (check-in: 67d7f79c user: drh tags: trunk) | |
| 13:35 | Rename WhereInfo.pResultSet to pDistinctSet to more accurately reflect what it represents. (check-in: 53179614 user: drh tags: trunk) | |
| 13:16 | 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. (check-in: 7ee570e7 user: drh tags: trunk) | |
| 13:06 | Additional ".selecttrace" debugging output when the query is transformed from a DISTINCT into a GROUP BY. (check-in: 5a469145 user: drh tags: trunk) | |
|
2016-04-13
| ||
| 21:00 | Fix compiler warnings by removing surplus local variables in the schema pretty-printer logic of the command-line shell. (check-in: 55a62483 user: drh tags: trunk) | |
| 19:20 | Merge enhancements from trunk via tempfiles-lazy-open. (check-in: ae16310c user: drh tags: tempfiles-25) | |
| 16:02 | Merge enhancements from trunk. (Closed-Leaf check-in: e2edd34e user: drh tags: tempfiles-lazy-open) | |
| 15:52 | Fixes for harmless compiler warnings. (check-in: 68142dc5 user: drh tags: trunk) | |
| 15:33 | Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (check-in: 83cfe82c user: drh tags: trunk) | |
|
2016-04-12
| ||
| 17:13 | Fix speedtest1 so that it automatically unlinks its test database prior to startup. (check-in: b65b69f6 user: drh tags: trunk) | |
| 16:59 | Add the --temp option to the speedtest1.c performance test program. (check-in: 8053a6e2 user: drh tags: trunk) | |
| 16:23 | Improved localtime() support for WindowsCE (check-in: 662c32af user: drh tags: trunk) | |
| 16:10 | Merge enhancements from trunk. (check-in: 9682c043 user: drh tags: tempfiles-lazy-open) | |
| 16:04 | Add the sqlite3_snapshot_cmp() interface (available only with SQLITE_ENABLE_SNAPSHOT). (check-in: 7e728965 user: drh tags: trunk) | |
| 11:58 | Update the header comment on the memjournal.c file. No code changes. (check-in: 07f10dea user: drh tags: trunk) | |
| 00:26 | Performance optimization the Vdbe allocator. (check-in: e2c4995b user: drh tags: trunk) | |
| 00:16 | Avoid unnecessary calls to object destructors for a small performance gain. (check-in: aec94b6e user: drh tags: trunk) | |
| 00:00 | Performance improvements in sqlite3WhereExprUsage(). (check-in: fdf75239 user: drh tags: trunk) | |
|
2016-04-11
| ||
| 19:01 | Performance optimization to sqlite3Dequote() and its callers. (check-in: 9efe2265 user: drh tags: trunk) | |
| 18:25 | Performance optimization for the sqlite3ExprListDelete() routine. (check-in: 2764aeaa user: drh tags: trunk) | |
| 18:15 | Performance optimizations in the column cache of the code generator, and especially the sqlite3ExprCacheRemove() routine. (check-in: e35b345c user: drh tags: trunk) | |
| 16:43 | Simplification and performance improvements in sqlite3ExprDup() and its subroutines. More work is possible in this area. (check-in: 476cc283 user: drh tags: trunk) | |
| 16:35 | Rename the OP_MX_JUMP macro to SQLITE_MX_JUMP_OPCODE to avoid confusing the opcode name generator. (check-in: e554a4c3 user: drh tags: trunk) | |
| 14:49 | Performance improvement in sqlite3ExprDelete(). (check-in: 60ad80e3 user: drh tags: trunk) | |
| 13:36 | Remove the VdbeOp.opflags field and its associated initialization overhead. Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values() routine run faster. (check-in: 099478fa user: drh tags: trunk) | |
| 01:43 | 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. (check-in: ef1966c2 user: drh tags: trunk) | |
| 01:26 | Small size reduction and performance improvement in the parser. (check-in: 16df7128 user: drh tags: trunk) | |
| 01:06 | Factor out the common operation of setting the Expr.x.pSelect field of an Expr object into a subroutine. (check-in: 6a5cceee user: drh tags: trunk) | |
|
2016-04-09
| ||
| 18:04 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: 6c56b3a0 user: drh tags: trunk) | |
| 17:20 | • Fixed ticket [a306e56f]: Failed DELETE with PRAGMA reverse_unordered_selects plus 5 other changes (artifact: dd06e22d user: drh) | |
| 17:04 | 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] (check-in: ca2ef8a8 user: drh tags: trunk) | |
| 16:31 | • New ticket [a306e56f] Failed DELETE with PRAGMA reverse_unordered_selects. (artifact: 66083a64 user: drh) | |
| 14:36 | Limit the number of digits shown in the "prereq" mask for ".wheretrace" debugging output. (check-in: 3686ed74 user: drh tags: trunk) | |
|
2016-04-08
| ||
| 21:35 | Attempt to treat the arguments to a table-valued function as if they occur in the ON clause of a LEFT JOIN rather than in the WHERE clause. But this causes undesirable behavior with generate_series, as demonstrated by test cases. This is an incremental check-in pending further work. (Leaf check-in: 00ac73a0 user: drh tags: tabfunc-in-left-join) | |
| 19:44 | Update documentation for sqlite3_snapshot_open(). No code changes. (check-in: 1dfa5234 user: drh tags: trunk) | |
| 15:09 | Version 3.12.1 (check-in: fe7d3b75 user: drh tags: release, branch-3.12.0, version-3.12.1) | |
|
2016-04-07
| ||
| 23:18 | Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (check-in: 84d2a09e user: drh tags: branch-3.12.0) | |
| 21:29 | Update the version number to 3.12.1. This is the first release candidate. (check-in: 300f1b61 user: drh tags: branch-3.12.0) | |
| 21:29 | Carry table column types through into VIEW definitions, where possible. (check-in: 3360ab09 user: drh tags: branch-3.12.0) | |
| 21:25 | • Edit [ea4de04d67aea510|ea4de04d]: Change branch background color to "#80bbd6". (artifact: ec292813 user: drh) | |
| 21:22 | 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]. (check-in: c232b99e user: drh tags: branch-3.12.0) | |
| 21:14 | • Fixed ticket [7f7f8026]: Segfault following heavy SAVEPOINT usage plus 3 other changes (artifact: c9b6953f user: drh) | |
| 21:14 | Add test cases for ticket [7f7f8026eda387d544]. (check-in: 87aa9357 user: drh tags: trunk) | |
| 21:07 | • Ticket [7f7f8026] Segfault following heavy SAVEPOINT usage status still Open with 3 other changes (artifact: 26ac4c61 user: drh) ... 1 similar event omitted. | |
| 18:42 | 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]. (check-in: c4b9c611 user: drh tags: trunk) | |
| 18:31 | • New ticket [7f7f8026] Segfault following heavy SAVEPOINT usage. (artifact: af77e034 user: drh) | |
| 14:16 | Avoid decrementing a pointer off the front end of the buffer in OP_MakeRecord. (check-in: 153135bf user: drh tags: trunk) | |
| 14:05 | Instead of just commenting out the unneeded code in the previous check-in, remove it completely. (check-in: 8415d484 user: drh tags: trunk) | |
| 14:01 | Remove an unnecessary test for a NULL pointer in freeP4(). (check-in: e84e88e3 user: drh tags: trunk) | |
| 13:45 | Update comments on the unix file locking protocol. No changes to code. (check-in: 716b20de user: drh tags: trunk) | |
|
2016-04-05
| ||
| 23:39 | Remove an unnecessary branch in the sqlite3LogEstToInt() routine. (check-in: da81d7af user: drh tags: trunk) | |
| 20:59 | Carry table column types through into VIEW definitions, where possible. (check-in: fb555c3c user: drh tags: trunk) | |
| 18:29 | • Edit [8f1f300c284ea1e4|8f1f300c]: Move to branch mistake. Mark "Closed". Edit check-in comment. Change user to "drh". (artifact: d1841848 user: drh) | |
| 18:24 | Oops. Branched from the wrong baseline. Ignore this one. (Closed-Leaf check-in: 8f1f300c user: drh tags: mistake) | |
| 17:50 | Add the SQLITE_DBCONFIG_REQUIRE_TXN argument for sqlite3_dbconfig() which when set requires an explicit transaction before updating the database. (check-in: b7570ac1 user: drh tags: require-write-txn) | |
| 15:59 | 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. (check-in: cf569f9f user: drh tags: trunk) | |
| 14:02 | Make sure "0" intended as a NULL pointer is cast to a pointer when used in a varargs functions parameter. (check-in: ed128e8b user: drh tags: trunk) | |
| 14:01 | Remove an unnecessary conditional from the index builder. (check-in: 87e5f5a6 user: drh tags: trunk) | |
| 13:35 | Use SQLITE_WITHIN() for pointer range comparisons in some testing code. (check-in: 7cacf4e9 user: drh tags: trunk) | |
| 13:19 | Do not allow pointer arithmetic to move a pointer across a memory allocation boundary. (check-in: 85b97931 user: drh tags: trunk) | |
| 00:44 | Avoid unnecessary memset() operations in sqlite3PagerGet(). (Leaf check-in: 0c97b802 user: drh tags: pager-get-noinit) | |
|
2016-04-04
| ||
| 18:04 | Fix documentation typos. Comment changes only. No changes to code. (check-in: d5fc2f7f user: drh tags: trunk) | |
| 17:34 | Improved handling of UTF8 by the command-line shell. (check-in: 4534ebf1 user: drh tags: trunk) | |
| 17:23 | Add the ".auth ON|OFF" command to the command-line shell. (check-in: 65c7bcc4 user: drh tags: trunk) | |
| 14:57 | 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. (check-in: 42a21966 user: drh tags: trunk) | |
| 13:46 | Minor performance optimization in the comparison opcodes of the VDBE. (check-in: e375fe52 user: drh tags: trunk) | |
| 12:38 | Fix harmless compiler warnings. (check-in: 0213d6af user: drh tags: trunk) | |
|
2016-04-01
| ||
| 17:54 | Preupdate hook documentation fixes. No changes to code. (check-in: 59814f35 user: drh tags: trunk) | |
| 12:35 | 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. (check-in: a62340dc user: drh tags: trunk) | |