This Day In History For 2018-04-14
1 Year Ago (more context)
|
2017-04-14
| ||
| 22:41 | Fix to the decision logic for when to use the skip-ahead-distinct optimization. (Closed-Leaf check-in: e50fd48969 user: drh tags: skip-ahead-distinct) | |
| 22:40 | • Edit [1aa0ea8db7580aff|1aa0ea8db7]: Remove the "Closed" mark. (artifact: 98140a550d user: drh) | |
| 21:44 | • Edit [a53799059d4ece24|a53799059d]: Edit check-in comment. (artifact: 169fa8ed33 user: drh) | |
| 19:46 | Remove end-of-line whitespace from lemon.c. (check-in: d78355c85f user: drh tags: trunk) | |
| 19:44 | Fix some left-over K&R-C constructs in lemon.c. No changes to the core. (check-in: a53799059d user: drh tags: trunk) | |
| 19:41 | Modify the code in ext/expert/ to use the vtab interface instead of sqlite3_whereinfo_hook(). Remove sqlite3_whereinfo_hook(). (check-in: 3bb6585004 user: dan tags: schemalint) | |
| 19:03 | Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in the result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. (Closed-Leaf check-in: 3a5860d86f user: drh tags: left-join-view) | |
| 17:30 | When doing a DISTINCT query using an index, try to use the index to skip ahead to the next distinct element, rather than doing a full scan of the index. (This is the "skip-ahead-distinct" optimization.) (check-in: f489b5bb6b user: drh tags: trunk) | |
| 17:20 | • Edit [8183fa6829e8688d|8183fa6829]: Mark "Closed". (artifact: 05af424bac user: drh) | |
| 17:18 | An initial attempt to optimize VIEWs that occur as the right operand of a LEFT JOIN. This particular check-in does not work correctly because it does not deal with the case of columns in the VIEW that return non-NULL even when all columns in the table of the VIEW are NULL because of the LEFT JOIN. (check-in: 1838a59c8a user: drh tags: left-join-view) | |
| 14:50 | Make USE_FULLWARN=1 the default for MSVC and fix harmless compiler warnings. (check-in: 6bf673767b user: mistachkin tags: trunk) | |
| 14:02 | Enhance the sqlite3TreeView() display for Expr objects so that it shows the iRightJoinTable value for Expr nodes that have the EP_FromJoin property. (check-in: 5159cb8f2b user: drh tags: trunk) | |
| 12:39 | Simplify the interface to the subst() routines that are part of the query flattener by collecting common parameters into the SubstContext object and passing around a pointer to that object. (check-in: e651074be2 user: drh tags: trunk) | |
| 12:27 | Remove an incorrect ALWAYS(). (check-in: f956f6ae6b user: drh tags: trunk) | |
| 00:45 | Fix a couple of unreachable branches. (check-in: 1aa0ea8db7 user: drh tags: skip-ahead-distinct) | |
2 Years Ago (more context)
|
2016-04-14
| ||
| 19:29 | Work toward improving analysis and code generation for DISTINCT and aggregate queries. (Leaf check-in: 129083bd5e user: drh tags: better-distinct-agg) | |
| 17:29 | 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. (check-in: d23e581351 user: dan tags: trunk) | |
| 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: 7b7a69d098 user: drh tags: trunk) | |
| 15:44 | 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: 79147dca87 user: dan tags: trunk) | |
| 15:38 | Add some missing testcase() macros to the pushDownWhereTerms() routine. (check-in: 67d7f79c5e user: drh tags: trunk) | |
| 13:35 | Rename WhereInfo.pResultSet to pDistinctSet to more accurately reflect what it represents. (check-in: 5317961411 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: 7ee570e7a9 user: drh tags: trunk) | |
| 13:06 | Additional ".selecttrace" debugging output when the query is transformed from a DISTINCT into a GROUP BY. (check-in: 5a46914510 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2015-04-14
| ||
| 20:15 | Begin changing fts5 to use a delete flag so that delete markers may be annihilated more quickly. (check-in: 9341c070bb user: dan tags: fts5) | |
| 19:01 | Add the --summary option to the sqldiff command-line tool. (check-in: 88b22761c5 user: drh tags: trunk) | |
| 15:14 | Update API documentation to identify many functions as methods on objects. No changes to code. (check-in: b549cbcee1 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2014-04-14
| ||
| 19:48 | Make sure the undocumented sqlite_rename_parent() function does not crash even if it is invoked with NULL arguments. Ticket [264b970c4379fd4b94] (check-in: c6fa8d0d82 user: drh tags: trunk) | |
| 19:48 | • Fixed ticket [264b970c43]: Crash when calling sqlite_rename_parent() with NULL parameters. plus 5 other changes (artifact: b9804f7e44 user: drh) | |
| 19:46 | • New ticket [264b970c43]. (artifact: 9c40070dd4 user: drh) | |
| 19:23 | Allow the sorter to begin returning data to the VDBE as soon as it is available, instead of waiting until all keys have been sorted. (check-in: cb0ab20c48 user: dan tags: threads) | |
| 18:41 | Improve performance in single-threaded mode by having the final merge pass keys directly to the VDBE, instead of going via a final PMA. (Closed-Leaf check-in: 02610cd9b7 user: dan tags: threads-experimental) | |
| 14:43 | Fix comments on the rtreenode() and rtreedepth() test function in the R-Tree module. (check-in: ade5b986e8 user: drh tags: rtree-enhancements) | |
| 12:18 | Remove over 300 lines of unused code, code that implemented the older Guttman insertion algorithms that are no longer used. (check-in: 3ba5f295c7 user: drh tags: rtree-enhancements) | |
| 08:45 | Minor fixes so that builds with SQLITE_MAX_WORKER_THREADS=0 work. (check-in: e400bbbf26 user: dan tags: threads-experimental) | |
| 07:30 | Improve use of multiple threads in sqlite3VdbeSorterRewind(). (check-in: e1bdc4b810 user: dan tags: threads-experimental) | |
5 Years Ago (more context)
|
2013-04-14
| ||
| 23:51 | • Fixed ticket [2500cdb9be]: COLLATE in ORDER BY clause breaks name resolution plus 4 other changes (artifact: 14e81f52fe user: drh) | |
| 23:51 | Only consider AS names from the result set as candidates for resolving identifiers in the WHERE clause if there are no other matches. In the ORDER BY clause, AS names take priority over any column names. Fix for ticket [2500cdb9be]. (check-in: d0d5af79a0 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2008-04-14
| ||
| 23:13 | Do not attempt to write to temporary database files that have never been opened. (CVS 5007) (check-in: 7bb9a4165a user: drh tags: trunk) | |
| 22:57 | Fix #3053: bashism (CVS 5006) (check-in: 7217cecee7 user: mlcreech tags: trunk) | |
| 17:42 | Fix alignment issue in instrumentation code. (CVS 5005) (check-in: c9e0d625bc user: danielk1977 tags: trunk) | |
| 16:37 | Do not set the pager to persistent error state if a call to OsAccess() fails. (CVS 5004) (check-in: aa16eb5729 user: danielk1977 tags: trunk) | |
| 15:27 | Make sure the page size in crash6.test does not exceed the maximum configured page size. (CVS 5003) (check-in: 36b6610b25 user: drh tags: trunk) | |
| 15:15 | Free Mem.z buffers when a vdbe statement is reset. (CVS 5002) (check-in: 0bedbe092a user: danielk1977 tags: trunk) | |
| 14:34 | Cleanup some #ifdefs to make their meaning clearly. No logical changes. (CVS 5001) (check-in: b8bc5f3a83 user: drh tags: trunk) | |
| 13:42 | Disable auto_vacuum during the vacuum3 test. (CVS 5000) (check-in: e2e1ca818c user: drh tags: trunk) | |
| 01:00 | Get the SQLITE_SECURE_DELETE compile-time option working again. Ticket #3050. (CVS 4999) (check-in: 40ba51fd4c user: drh tags: trunk) | |