This Day In History For 2020-07-27
2 Years Ago (more context)
|
2018-07-27
| ||
| 23:33 | Improvements to the parser to increase coverage. Fix the parser so that at least one expresssion is required after PARTITION BY and within the list of expressions on VALUES(). (check-in: 02204f8b user: drh tags: trunk) | |
| 22:55 | When doing a DROP VIEW do not try to delete entries from the sqlite_stat1 table as there are none. (check-in: 7efdba2b user: drh tags: trunk) | |
| 22:14 | Minor grammar changes that help the parser run faster by reducing the number of NUL rule reductions. (check-in: cfd1b005 user: drh tags: trunk) | |
| 20:45 | Enhance Makefile for MSVC to support building the shell tool without using the amalgamation. (check-in: 3d815d83 user: mistachkin tags: trunk) | |
| 20:37 | The WHERE-clause constant propagation optimization attempts to use transitive laws to replace column values with constants in the WHERE clause in order to help to query planner make more aggressive optimizations. (check-in: f4229707 user: drh tags: trunk) | |
| 20:01 | Reduce the performance cost of the constant propagation optimization to less than 200,000 cycles. (Closed-Leaf check-in: 865249de user: drh tags: propagate-const-opt) | |
| 18:19 | Performance improvement to sqlite3ExprCollSeq(). With this change, the performance of speed-check.sh is within 400,000 cycles of trunk. (check-in: a5f86f49 user: drh tags: propagate-const-opt) | |
| 18:12 | Faster implementation of sqlite3IsBinary(). (check-in: be05d0db user: drh tags: propagate-const-opt) | |
| 17:51 | Only run the constant propagation optimization on joins since that is the only scenario where it is useful. This saves prepare time for the common case of a simple query. (check-in: 598d6083 user: drh tags: propagate-const-opt) | |
| 16:57 | Constant propagation is now restricted to just the WHERE clause. The mechanism is changed to take affinity and collation into account. This seems to give correct answers. But the search for constant propagation costs 4 million cycles in the speed test. (check-in: 82c67efb user: drh tags: propagate-const-opt) | |
3 Years Ago (more context)
|
2017-07-27
| ||
| 22:16 | Enhance the like optimization so that it works with an ESCAPE clause. (check-in: 2495acf7 user: drh tags: branch-3.8.9) | |
| 20:24 | Enhance the like optimization so that it works with an ESCAPE clause. (check-in: f5d330f4 user: drh tags: trunk) | |
| 19:59 | Increase the version number to 3.21.0 in anticipation for changes to go into the next release. (check-in: 0645f25c user: drh tags: trunk) | |
| 18:49 | Merge the pointer-passing interface changes from the 3.20 branch. (check-in: c63903a4 user: drh tags: trunk) | |
| 18:43 | Simplified documentation for the pointer passing interface. (check-in: 2dfcd9a8 user: drh tags: branch-3.20) | |
| 18:34 | Do not set device-capabilities flags SEQUENTIAL or SAFE_APPEND for f2fs file-systems. (check-in: 4477e60c user: dan tags: batch-atomic-write) | |
| 17:45 | • Edit [49cf31da82275dd3|49cf31da]: Mark "Closed". (artifact: f5bb63d4 user: drh) | |
| 17:45 | Add destructor functions for the pointer argument (NB: not the type string) to the sqlite3_bind_pointer() and sqlite3_result_pointer() interfaces. Use this new capability to resolve a pointer leak in the custom geometry function mechanism of the RTREE extension. (check-in: 5a2340b8 user: drh tags: branch-3.20) | |
| 16:42 | In sqlite3_bind_pointer(), invoke the destructor if the bind index is out of range, like sqlite3_bind_blob() does. (Closed-Leaf check-in: d6684d2a user: drh tags: pointer-with-destructor) | |
| 15:53 | Improved implementation of the destructor on pointer-passing interfaces. (check-in: 601ad679 user: drh tags: pointer-with-destructor) | |
| 14:04 | A demonstration of how FTS3 cursor pointers can be passed from the MATCH operator to the snippet() function securely and opaquely without having to use the sqlite3_result_pointer() and sqlite3_value_pointer() interfaces. (Closed-Leaf check-in: 49cf31da user: drh tags: pass-pointer-as-blob) | |
| 03:48 | Add a destructor argument to sqlite3_bind_pointer() and sqlite3_result_pointer(). (check-in: 3d9e841f user: drh tags: pointer-with-destructor) | |
| 00:27 | Do now allow the geometry object in the right operand of a MATCH operator in the RTREE extension to be inpersonated by a BLOB literal. (check-in: 24c9cd46 user: drh tags: branch-3.19) | |
4 Years Ago (more context)
|
2016-07-27
| ||
| 19:39 | • Edit [bf46179d44843769|bf46179d]: Edit check-in comment. (artifact: 517b1d33 user: drh) | |
| 19:33 | Fix some problems with multi-column IN(SELECT...) processing. (check-in: 719a3b20 user: dan tags: rowvalue) | |
| 19:30 | Enhance the query planner cost estimation for index scans to take into account WHERE clause terms that can be computed using only the index and that do not require looking up rows in the original table. This fixes an obscure performance regression that arose when the ORDER BY LIMIT optimization was added by check-in [bf46179d44843]. (check-in: 9e2b2681 user: drh tags: trunk) | |
| 19:20 | Add test cases and fix a comment. (Closed-Leaf check-in: 50f8ea37 user: drh tags: improved-index-scan) | |
| 18:27 | When estimating the cost of an index scan, factor in the cost savings of being able to use the index to evaluate some WHERE clause terms without having to do a table lookup. (check-in: a59b5622 user: drh tags: improved-index-scan) | |
| 16:03 | Initialize a variable in where.c to avoid a valgrind warning. (check-in: 4d59df02 user: dan tags: trunk) | |
5 Years Ago (more context)
|
2015-07-27
| ||
| 19:57 | Clarification to the documentation for sqlite3_result_zeroblob64(). No changes to code. (check-in: c98175e9 user: drh tags: trunk) | |
| 19:31 | Add an experimental "BEGIN UNLOCKED" command. (check-in: 80794216 user: dan tags: begin-concurrent) | |
| 13:49 | Version 3.8.11 (check-in: b8e92227 user: drh tags: trunk, release, version-3.8.11) | |
| 12:19 | Merge the fts5-btree-index branch with this one. FTS5 changes only. (check-in: 9f1dcdc3 user: dan tags: trunk) | |
| 11:49 | Bump the "version" field in the fts5 config table. (Closed-Leaf check-in: 92c91789 user: dan tags: fts5-btree-index) | |
| 11:43 | Minor tweak to the SQL schema used by fts5. (check-in: 427bf09b user: dan tags: fts5-btree-index) | |
| 11:01 | Remove a potentially undefined behaviour involving signed integers and bitshift operations from fts5_hash.c. (check-in: ad6286ab user: dan tags: fts5-btree-index) | |
| 10:46 | Merge latest trunk changes with this branch. (check-in: 5ec933c2 user: dan tags: fts5-btree-index) | |
10 Years Ago (more context)
|
2010-07-27
| ||
| 18:37 | • Edit [621824092d443425|62182409]: Change branch background color to "#c0ffc0". Timestamp 2010-07-27 18:36:38. (artifact: 479f2044 user: dan) | |
| 18:37 | • Edit [7cf0e851d4c5e826|7cf0e851]: Change background color to "#c0ffc0". Timestamp 2010-07-27 18:34:16. (artifact: d94e1320 user: dan) | |
| 18:36 | Merge trunk changes into experimental branch. (check-in: 62182409 user: dan tags: experimental) | |
| 18:34 | Add experimental unix-only file-control to grow and truncate the database file by a configurable chunk size. (check-in: 7cf0e851 user: dan tags: experimental) | |
| 16:42 | Update the makefiles to prefer TCL version 8.5 instead of 8.4. (check-in: 8118de2a user: drh tags: trunk) | |
15 Years Ago (more context)
|
2005-07-27
| ||
| 20:41 | More work on the new optimizer. Fewer tests fail now. (CVS 2565) (check-in: ee3a08e3 user: drh tags: trunk) | |