This Day In History For 2022-01-27
1 Year Ago (more context)
|
2021-01-27
| ||
| 20:35 | Merge recent enhancements from trunk. (check-in: 5fbcb208d2 user: drh tags: returning) | |
| 19:15 | • Fixed ticket [ee51301f31]: Incorrect optimization of IN operator. plus 5 other changes (artifact: 8a0867c579 user: drh) | |
| 19:15 | Fix an issue with IN operator optimization introduced by check-in [4a43430fd23f8835] and described by ticket [ee51301f316c09e9]. (check-in: 9dc7fc9f04 user: drh tags: trunk) | |
| 17:27 | • Edit [390cf60a286b13f4|390cf60a28]: Edit check-in comment. (artifact: dd13f75f7d user: drh) | |
| 17:15 | Ensure a cursor used by the SeekScan operator does not point to a valid row on the first iteration of the loop. Possible fix for [ee51301f316c09e]. (Closed-Leaf check-in: 390cf60a28 user: dan tags: fix-2d6e8400) | |
| 16:06 | • New ticket [ee51301f31] Incorrect optimization of IN operator.. (artifact: 2d6e840056 user: drh) | |
2 Years Ago (more context)
|
2020-01-27
| ||
| 19:55 | Version 3.31.1 (check-in: 3bfa9cc97d user: drh tags: trunk, release, version-3.31.1) | |
| 17:09 | Update the version number to 3.31.1. (check-in: 6fb9a8fb85 user: drh tags: trunk) | |
| 14:53 | • Edit [34ab760689fd493e|34ab760689]: Edit check-in comment. (artifact: 6f0275e33f user: drh) | |
| 14:40 | Revise the layout of filenames in the Pager object so that it is unchanged from prior versions. It turns out that some important 3rd-party software does questionable pointer manipulations on those filenames that depend on that legacy layout. Technically, this is a misuse of SQLite by the 3rd-party software, but we want to avoid unnecessary breakage. (check-in: 34ab760689 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2019-01-27
| ||
| 19:50 | Improvements to the ".eqp trace" command in the CLI so that it ensures that the schema has been read prior to activing the tracing feature, to avoid cluttering the output with a trace of the schema parse. (check-in: 42687d45aa user: drh tags: trunk) | |
| 02:45 | New test cases form dbsqlfuzz (check-in: 9cf8ebd141 user: drh tags: trunk) | |
| 02:41 | Window functions that can abort should indicate this, so that if they are used in DML statement, a statement journal will be used. (check-in: 0ea05a0eb9 user: drh tags: trunk) | |
| 01:11 | Update fuzzcheck so that with the --load-dbsql options it screens its inputs to ensure that they are valid dbsqlfuzz cases. Add new dbsqlfuzz finds to the test/fuzzdata8.db database. (check-in: 004f7d9bbe user: drh tags: trunk) | |
4 Years Ago (more context)
|
2018-01-27
| ||
| 18:55 | Fix missing header comments and other code issues in zipfile.c. (check-in: 6ea8ba312c user: dan tags: trunk) | |
| 16:29 | If a zipfile virtual table is created with no argument - "CREATE VIRTUAL TABLE zzz USING zipfile()" - accumulate data in memory. Support "SELECT zipfile_blob(z) FROM zzz LIMIT 1" to retrieve a zip archive image. (check-in: e63185edfe user: dan tags: trunk) | |
| 14:25 | Changes to avoid a harmless UB warning from clang. (check-in: 19f5c14000 user: drh tags: trunk) | |
| 13:56 | • Fixed ticket [ec32177c99]: Incorrect result with complex OR-connected WHERE and STAT4 plus 3 other changes (artifact: 83c4e1e229 user: drh) | |
| 13:55 | New test case for ticket [ec32177c99ccac2b1] that works without the STAT4. (check-in: 5259d4847f user: drh tags: trunk) | |
| 05:40 | Proposed fix for the query planner problem of ticket [ec32177c99ccac2b1]. (check-in: eef8cbef3c user: drh tags: trunk) | |
| 04:43 | • Ticket [ec32177c99] Incorrect result with complex OR-connected WHERE and STAT4 status still Open with 6 other changes (artifact: f5d59ef08d user: drh) | |
| 04:10 | • New ticket [ec32177c99]. (artifact: 014b03109f user: drh) | |
| 03:26 | Fix compiler warnings in zipfile.c. (check-in: bed610d99b user: drh tags: trunk) | |
5 Years Ago (more context)
|
2017-01-27
| ||
| 19:27 | Add the sha1.c loadable extension that implements the sha1() and sha1_query() SQL functions. (check-in: 24e77c1cef user: drh tags: trunk) | |
| 17:02 | Fix a problem causing the pre-update hook to be invoked by DROP TABLE statements. (check-in: fbb6bf1b69 user: dan tags: trunk) | |
| 16:39 | Merge all recent trunk enhancements into the apple-osx branch. (check-in: 0e14fe1b98 user: drh tags: apple-osx) | |
| 16:24 | Merge all recent enhancements from trunk. (check-in: fe86ff5429 user: drh tags: est_count_pragma) | |
| 13:14 | Alternative ICU fix (compare to check-in [50e60cb4]) that avoids casting integers to pointers. (check-in: d9752c8f7c user: drh tags: trunk) | |
| 01:52 | In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl". (check-in: 58f02e6eae user: drh tags: trunk) | |
| 01:25 | Another micro-optimization in accessPayload(). Slightly smaller and faster. (check-in: c012619b65 user: drh tags: trunk) | |
| 01:13 | Performance optimization in accessPayload(). (check-in: ebb1fd98d4 user: drh tags: trunk) | |
| 00:31 | Simplify the accessPayload() routine so that it always populates the overflow page cache. In the one case where populating the page cache can lead to problems, simply invalidate the cache as soon as accessPayload() returns. This simplification reduces code size and helps accessPayload() to run a little faster. This backs out the eOp==2 mode of accessPayload() added by check-in [da59198505]. (check-in: 68e7a8c676 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2012-01-27
| ||
| 18:15 | • New ticket [c04a8b8a4f] Trailing comments not stripped from views, invalid dumps. (artifact: a35724eba5 user: rogerb) | |
15 Years Ago (more context)
|
2007-01-27
| ||
| 14:30 | Version 3.3.12 (CVS 3616) (check-in: fc66070393 user: drh tags: trunk) | |
| 14:26 | Adjustments to the pragma test for OS-X. (CVS 3615) (check-in: 4d0d2063df user: drh tags: trunk) | |
| 14:11 | More adjustments to the pragma test for windows. (CVS 3614) (check-in: 79a65436d1 user: drh tags: trunk) | |
| 14:04 | Adjustment to tests for PRAGMA integrity_check so that they run under windows. (CVS 3613) (check-in: a79914ccbc user: drh tags: trunk) | |
| 13:38 | Increment the version number in preparation for the 3.3.12 release. (CVS 3612) (check-in: 24e465af92 user: drh tags: trunk) | |
| 13:37 | Fix a documentation comment in vdbe.c. Ticket #2188. (CVS 3611) (check-in: 3eec703beb user: drh tags: trunk) | |
| 02:38 | Parser changes to allow parenthesized numerical arguments to pragmas, in support of the integrity_check enhancement of check-in (3609) and ticket #2176. (CVS 3610) (check-in: ab6322bf93 user: drh tags: trunk) | |
| 02:24 | Limit the number of errors returned by PRAGMA integrity_check to 100 by default. Specify an alternative limit using an argument to the pragma. Ticket #2176. (CVS 3609) (check-in: d564a039f2 user: drh tags: trunk) | |