This Day In History For 2020-08-27
1 Year Ago (more context)
|
2019-08-27
| ||
| 20:00 | • Closed ticket [f8a7060e]: Incorrect result for query that uses MIN() and a CAST on rowid plus 4 other changes (artifact: 400f3bdf user: dan) | |
| 19:59 | Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. (check-in: 94085fb3 user: dan tags: trunk) | |
| 17:59 | The ALWAYS() added by the previous check-in was incorrect. Take it back out. (check-in: 336235db user: drh tags: trunk) | |
| 17:28 | Add ALWAYS() to an always true conditional that results from the previous check-in. Add a test case for ticket [dbaf8a6820be1ece] to supplement those already checked into TH3. (check-in: aff20980 user: drh tags: trunk) | |
| 17:01 | • Fixed ticket [dbaf8a68]: Unexpected affinity conversion is performed for the IN operator plus 6 other changes (artifact: afafc304 user: drh) | |
| 17:01 | Omit the "x IN (y)" to "x==y" optimization of check-in [e68b427afbc82e20] (and ticket [e39d032577df6942]) as it causes difficult affinity problems as demonstrated by ticket [dbaf8a6820be1ece] and the original assertion fault is no longer a factor due to countless other changes of the previous 5 years. (check-in: 7f5168a7 user: drh tags: trunk) | |
| 15:14 | • New ticket [dbaf8a68] Unexpected affinity conversion is performed for the IN operator. (artifact: 8542c61f user: mrigger) | |
| 10:09 | • Fixed ticket [ac8dd4a3]: Segfault when dropping a temp trigger on a database that has already been detached plus 5 other changes (artifact: 8eb244c9 user: drh) | |
| 10:08 | • Edit [069c2f4c61f06211|069c2f4c]: Edit check-in comment. (artifact: 6718e124 user: drh) | |
| 10:05 | If a TEMP TRIGGER references an auxiliary schema, and that auxiliary schema is detached, move the trigger to reference the TEMP schema before completing the detach, so that the trigger does not hold a dangling schema pointer. Ticket [ac8dd4a32ba4322f] (check-in: 069c2f4c user: drh tags: trunk) | |
| 09:42 | • New ticket [ac8dd4a3] Segfault when dropping a temp trigger on a database that has already been detached. (artifact: 719304a8 user: dan) | |
2 Years Ago (more context)
|
2018-08-27
| ||
| 17:13 | Add support for the Geopoly extension to the R-Tree extension. This also involves adding the SQLITE_INDEX_CONSTRAINT_FUNCTION capability to the xFindFunction method of the sqlite3_module object, and to the sqlite3_index_info.aConstraint.op field in the xBestIndex implementation of virtual tables. (check-in: 666133e3 user: drh tags: trunk) | |
| 17:05 | Minor changes to the visual01.txt test script. (Closed-Leaf check-in: 4bc28eed user: drh tags: rtree-geopoly) | |
| 15:55 | Split the three-argument version of geopoly_within() off into a separate function named geopoly_contains_point(). (check-in: 5a0e1541 user: drh tags: rtree-geopoly) | |
3 Years Ago (more context)
|
2017-08-27
| ||
| 10:55 | Instrumentation and changes in an effort to reduce thread contention. (Leaf check-in: c93298d5 user: drh tags: reduced-thread-contention) | |
4 Years Ago (more context)
|
2016-08-27
| ||
| 20:21 | Fix typos in comments. No changes to running code. (check-in: a07269f2 user: drh tags: trunk) | |
| 18:35 | Fix some comments in sqlite3session.h. No changes to code. (check-in: 78cd64e2 user: dan tags: trunk) | |
| 18:34 | Fixes to fts5 snippet() function. (check-in: d464a7b1 user: dan tags: trunk) | |
| 18:33 | • Edit [b174ed2bde43a187|b174ed2b]: Mark "Closed". (artifact: 4be647e9 user: dan) | |
| 14:13 | Merge updates from trunk. (check-in: 082fd5f8 user: drh tags: rowvalue) | |
| 14:05 | Fix the extra comments (added with -DSQLITE_ENABLE_EXPLAIN_COMMENTS) so that the sense of <, <=, >, and >= tests is correct and so that the SQLITE_STOREP2 version is shown correctly. These changes are already in the rowvalue branch but are added here since they are technically unrelated to rowvalue. (check-in: 4d43c469 user: drh tags: trunk) | |
| 01:41 | Fix the "Synopsis" on the OP_Lt, OP_Le, OP_Gt, and OP_Ge opcodes, which has been backwards for time out of mind. (check-in: f51248dc user: drh tags: rowvalue) | |
5 Years Ago (more context)
|
2015-08-27
| ||
| 23:42 | Fix the OR-optimization so that it always ignores subplans that do not use an index. (check-in: cf452028 user: drh tags: index-expr) | |
| 23:18 | Fix the OR-optimization so that it always ignores subplans that do not use an index. (check-in: 66f92a16 user: drh tags: trunk) | |
| 20:33 | Fix EXPLAIN QUERY PLAN output for indexed-expressions. Fix another obscure fault in the WHERE term scanner. (check-in: 73d361ce user: drh tags: index-expr) | |
| 19:57 | Add header comments for new methods in pager.c. (check-in: 437c7e21 user: dan tags: begin-concurrent) | |
| 19:56 | Fix problems in the indexed-expression handling in the optimizer. (check-in: 03375017 user: drh tags: index-expr) | |
| 19:22 | Add test cases for concurrent transactions and long-lived SELECT statements. (check-in: fd4798cb user: dan tags: begin-concurrent) | |
| 18:24 | Activate the ability to use expressions in indexes in a query. There are some test failures, but mostly this seems to work. (check-in: 42f93f58 user: drh tags: index-expr) | |
| 17:42 | Fix a problem whereby concurrent transactions would not consider pages read by the transaction before the first write statement. (check-in: fc17f731 user: dan tags: begin-concurrent) | |
| 16:07 | Merge changes from trunk. (check-in: c80e9e8e user: drh tags: index-expr) | |
| 15:58 | Adjustments to the WHERE term scanning, to better handle scanning terms of an index. (check-in: 5611130a user: drh tags: index-expr) | |
10 Years Ago (more context)
|
2010-08-27
| ||
| 18:44 | Make sqlite3_create_function() a special case of sqlite3_create_function_v2() in order reduce the number of code paths and simplify testing. (check-in: 4758d86d user: drh tags: trunk) | |
| 17:48 | Add the sqlite3_create_function_v2() API, a version of create_function that allows a destructor to be specified. (check-in: 9a724dfb user: dan tags: trunk) | |
| 17:16 | Refactor the implementation of the scratch memory allocator. Add the SQLITE_TESTCTRL_SCRATCHMALLOC interface to facilitate testing. (check-in: a3475ddf user: drh tags: trunk) | |
| 12:21 | Remove unnecessary code from malloc.c. Enhance pcache1.c so that is tries to reuse existing pages, rather than create new pages, when SQLite is under memory pressure. "Memory pressure" means that SQLITE_CONFIG_PAGECACHE memory is nearly exhausted or sqlite3_soft_heap_limit() has been reached. (check-in: 51049479 user: drh tags: trunk) | |
| 11:19 | Further tests for CAST in e_expr.test. (check-in: 9616df8c user: dan tags: trunk) | |
15 Years Ago (more context)
|
2005-08-27
| ||
| 17:23 | Version 3.2.5 (CVS 2634) (check-in: b2415a74 user: drh tags: trunk) | |
| 17:22 | Change the wording of the news line for release 3.2.5. (CVS 2633) (check-in: 70db46d3 user: drh tags: trunk) | |
| 17:19 | Get the date right. Today is the 27th, not the 25th or the 28th. (CVS 2632) (check-in: 905b9d6c user: drh tags: trunk) | |
| 17:06 | Increase the version number and update web pages for the next release. (CVS 2631) (check-in: e6039e90 user: drh tags: trunk) | |
| 16:36 | Disable synchronous writes to the master journal when PRAGMA synchronous=OFF for all database files. Ticket #1375. (CVS 2630) (check-in: 644b96aa user: drh tags: trunk) | |
| 13:16 | Fix comment in vdbeapi.c. Remove unused structure definition from func.c. (CVS 2629) (check-in: 51a38134 user: drh tags: trunk) | |
| 13:11 | Remove the words "statically linked" from the description of the shell on the download page. Ticket #1391. (CVS 2628) (check-in: ecb96044 user: drh tags: trunk) | |
| 09:07 | Remove GNUmake extensions from the makefile. Ticket #1390. (CVS 2627) (check-in: d0691fed user: drh tags: trunk) | |
| 01:51 | Do not change fields of stale sqlite3 handles. Ticket #1384. (CVS 2626) (check-in: 7e05b7ca user: drh tags: trunk) | |
| 01:50 | Widen the opcode column of explain output in the shell. (CVS 2625) (check-in: dd3b00aa user: drh tags: trunk) | |