This Day In History For 2025-06-02
1 Year Ago (more context)
|
2024-06-02
| ||
| 10:52 | Be more aggressive about freeing memory associated with the sqlite3_index_info.idxStr field. (Closed-Leaf check-in: 85dcd0a847 user: drh tags: xbestindex-or-terms) | |
2 Years Ago (more context)
|
2023-06-02
| ||
| 21:31 | Clarify sqlite3_is_interrupted() return. No code change. (check-in: b6c2d3d203 user: larrybr tags: trunk) | |
| 20:27 | Get built-in ExportHandler instances to do more of .mode work. Replace atexit() with something that works for (not quite) "main" returns. Sync w/trunk. (check-in: a588dd9fc6 user: larrybr tags: cli_extension) | |
| 18:05 | Restore the LEFT JOIN strength reduction that was partially lost in [d747afda5683ca5f] when strength reduction was generalized to all OUTER JOINs. (check-in: 2d962b84dd user: drh tags: trunk) | |
| 13:31 | Do that last CLI fix more simply, using established means. (check-in: a1823b2976 user: larrybr tags: trunk) | |
| 12:56 | Fix CLI fault on missing -nonce reported by forum post f8c14a1134. (check-in: cd24178bba user: larrybr tags: trunk) | |
| 00:03 | Fix the OUTER JOIN strength reduction theorem prover's handling of the CASE operator. (check-in: 73d7b14b17 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2022-06-02
| ||
| 16:26 | Fix a problem with flattening and window functions causing an "IS <column>" to be transformed to "IS TRUE" or "IS FALSE" when <column> is a view or sub-select expression that is the literal value "TRUE" or "FALSE". (check-in: 2a952c7738 user: dan tags: trunk) | |
| 02:45 | Avoid a direct use of abort() in debug builds to prevent a compilation issue for Windows CE. (check-in: 8eb9a7dd07 user: mistachkin tags: trunk) | |
4 Years Ago (more context)
|
2021-06-02
| ||
| 19:28 | Add an optimization control bit to disable the OP_SeekScan optimization. (check-in: f674c41e5c user: drh tags: seekscan-improvements) | |
| 18:50 | Fix an ALWAYS which can be false. (check-in: a87f8ecd6d user: drh tags: seekscan-improvements) | |
| 17:32 | Tighten assert() restrictions on the OP_SeekScan opcode. (check-in: dbc33d3ae3 user: drh tags: seekscan-improvements) | |
| 17:14 | Never use WHERE_IN_SEEKSCAN for the 2nd or subsequent IN operator. (check-in: d0b9861908 user: drh tags: seekscan-improvements) | |
| 12:44 | This is an attempt to address the OP_SeekScan performance issue identified by forum post b4fcb8a598. (check-in: d58efb3f21 user: drh tags: seekscan-improvements) | |
10 Years Ago (more context)
|
2015-06-02
| ||
| 19:38 | Change the fts5 multi-column syntax to use parenthesis instead of square brackets. (check-in: ab85a6fc4f user: dan tags: fts5) | |
| 19:36 | Always check for cell overflow before returning a slot from the pageFindSlot routine in btree.c. (check-in: 9f035c45a4 user: drh tags: trunk) | |
| 18:09 | For FROM-clause subqueries that cannot be flattened, try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. Call this the "WHERE-clause push-down optimization". Do not confuse this with the completely different MySQL push-down optimization. (check-in: 6df18e949d user: drh tags: trunk) | |
| 18:07 | Merge latest trunk changes with this branch. (check-in: c9ffda4abb user: dan tags: fts5) | |
| 17:57 | Reimplement [ec69e09a] so that each call to the xNext() method does not involve two iterations of the match expression tree (only one). (check-in: 80fe305b3e user: dan tags: fts5) | |
| 17:25 | Add test cases for type affinity rules. (check-in: 9678646d9a user: drh tags: trunk) | |
| 16:50 | • Edit [bce3f04186cd2d69|bce3f04186]: Mark "Closed". (artifact: 0ff1100a27 user: drh) | |
| 16:19 | Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB to avoid confusion with "no affinity". (check-in: 29ad9e9173 user: drh tags: trunk) | |
| 16:09 | Add the built-in affinity() SQL function. This turns out to be not as useful as originally envisioned, so abandon it on a branch. (Leaf check-in: 80889306bf user: drh tags: affinity-func) | |
| 15:32 | Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB. (Closed-Leaf check-in: bce3f04186 user: drh tags: blob-affinity-rename) | |
| 14:02 | Fix a faulty assert() in btree.c. Update the database fuzz test file with new test cases. (check-in: 4e621af134 user: drh tags: trunk) | |
| 09:20 | Add the "finish_test" command to the end of new test script sessionE.test. (check-in: fb39140707 user: dan tags: sessions) | |
| 09:19 | Modify the sessions module to ignore all operations on tables with no primary keys as documented. (check-in: bdaf9575cd user: dan tags: sessions) | |
15 Years Ago (more context)
|
2010-06-02
| ||
| 20:38 | When a lock fails due to an I/O error (not an SQLITE_BUSY) then the checkpoint should fail. (check-in: c6eb0a2727 user: drh tags: trunk) | |
| 18:59 | Fix a problem with rolling back to a savepoint opened before the writer decided to wrap the log file. (check-in: 6b4aed6aae user: dan tags: trunk) | |
| 17:15 | If an error occurs while writing frames to the log to commit a transaction, do not mark the pages as clean in the cache. Otherwise, the subsequent rollback does not roll them back (leaving the client to continue with a cache that makes it appear that the transaction was committed - inconsistent with the database on disk). (check-in: cb571c1b71 user: dan tags: trunk) | |
| 16:40 | Added implementation of vfslog_time() for Windows testing. (check-in: b3109f85bd user: shaneh tags: trunk) | |
| 16:39 | Updated wal2.test for windows testing. (check-in: c3606f3985 user: shaneh tags: trunk) | |
| 15:59 | Make sure the directory used by os_unix.c for shared-memory files is always the same, regardless of individual client permissions and environment variable settings. (check-in: f97bd520f0 user: drh tags: trunk) | |
| 15:43 | When walTryBeginRead() encounters an I/O error trying to set a lock (as opposed to SQLITE_BUSY) be sure to propagate that error back up the call stack. (check-in: aa2c2b67a7 user: drh tags: trunk) | |
| 14:45 | Changes to make WAL more robust against SHM locking failures and OOM errors. (check-in: ebf4041383 user: drh tags: trunk) | |
| 14:43 | In the rowhash.test, make sure global variables are cleared prior to use. (check-in: 28efe0a404 user: drh tags: trunk) | |
| 12:58 | Undo one of the "const" markers from the previous check-in because the value needs to be changable, even if it is not actually ever changed in the current implementation. (check-in: c24ac3563f user: drh tags: trunk) | |
| 05:53 | Add some 'const' markers to static data that is really constant. (check-in: e7073e23b8 user: dan tags: trunk) | |
25 Years Ago (more context)
|
2000-06-02
| ||
| 23:22 | :-) (CVS 45) (check-in: 3e88142e90 user: drh tags: trunk) | |
| 23:21 | :-) (CVS 44) (check-in: cd83d3cfeb user: drh tags: trunk) | |
| 23:04 | :-) (CVS 43) (check-in: 60f45a3ba5 user: drh tags: trunk) | |
| 18:52 | :-) (CVS 42) (check-in: 11e3296319 user: drh tags: trunk) | |
| 15:51 | :-) (CVS 41) (check-in: 90cfd6174b user: drh tags: trunk) | |
| 15:05 | :-) (CVS 40) (check-in: 939adb4d37 user: drh tags: trunk) | |
| 14:38 | :-) (CVS 39) (check-in: 721d58f4e1 user: drh tags: trunk) | |
| 14:27 | :-) (CVS 38) (check-in: 46c4b792e0 user: drh tags: trunk) | |
| 13:27 | :-) (CVS 37) (check-in: 2b55f9b790 user: drh tags: trunk) | |
| 02:09 | :-) (CVS 1696) (check-in: 80d925b82b user: drh tags: trunk) | |
| 01:51 | :-) (CVS 36) (check-in: d3c31defba user: drh tags: trunk) | |
| 01:36 | :-) (CVS 35) (check-in: a57ecd606c user: drh tags: trunk) | |
| 01:17 | :-) (CVS 34) (check-in: 52338f4ab5 user: drh tags: trunk) | |