This Day In History For 2025-06-07
1 Year Ago (more context)
|
2024-06-07
| ||
| 21:00 | Experimental optimization to rewrite a SELECT with an EXISTS(...) expression in the WHERE clause as a join. (check-in: 972a33db0b user: dan tags: exists-to-join) | |
| 19:48 | At attempt at improving the performance of unixRead(). Partly successfuly, but the improvement is not that much and there is question whether or not the improvement is worth the extra complication and code space. (Leaf check-in: aebc790a16 user: drh tags: fast-read) | |
| 00:20 | Allow the query planner access to the argument of LIMIT even if that argument is a bound parameter. (check-in: 148d505ca0 user: drh tags: branch-3.28) | |
2 Years Ago (more context)
|
2023-06-07
| ||
| 23:11 | • Edit [8c291d99946eb32b|8c291d9994]: Mark "Closed". (artifact: 9b20cf2e92 user: larrybr) | |
| 23:10 | Add spell-checking for all comments in main sources. (./src/ .c .h .in) make target "misspell" tells of misspelled words for which no exceptions have been put into tool/custom.txt . (check-in: 5332abf0ad user: larrybr tags: trunk) | |
| 17:03 | Fix straggler misspellings and tidy the custom dictionary. Also include pickups from forum post c61fb09afd. (Closed-Leaf check-in: 8c291d9994 user: larrybr tags: spell-check) | |
| 15:00 | Remove additional traces of FTS1 and FTS2 that were missed by [2bb50d5aedef0fd2] (check-in: 9a12bac5d2 user: drh tags: trunk) | |
| 14:47 | Remove unused, legacy shell script "mkso.sh" from the root of the repo. (check-in: 57f75e4869 user: drh tags: trunk) | |
| 08:40 | Add a C-source spell-checking facility. make misspell (on Nix) (check-in: 26c1bb4bd9 user: larrybr tags: spell-check) | |
3 Years Ago (more context)
|
2022-06-07
| ||
| 13:09 | Fix the query flattener to deal with a RIGHT JOIN corner case described by forum post 323f86cc30. (check-in: 3f45007d54 user: drh tags: trunk) | |
| 11:02 | Test cases for forum post 323f86cc30 added to join8.test, though commented out so that they do not (yet) run. (check-in: 7f97cb67d0 user: drh tags: trunk) | |
| 10:14 | Preserve the database encoding on the CAST operator in the sqlite3ValueFromExpr() routine. Forum thread 800eecf5e6cdc3f4. Test case in TH3. (check-in: 3f6a442099 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2021-06-07
| ||
| 17:36 | Fix a buffer overread that could occur in fts5 when handling corrupt records. (check-in: 078962a216 user: dan tags: trunk) | |
| 15:28 | Fix a buffer overrun in fts3 that could occur when handling corrupt records and '^' queries. (check-in: 9d0b6b0f42 user: dan tags: trunk) | |
| 14:21 | Add recent dbsqlfuzz test cases to test/fuzzdata8.db. (check-in: 162022003c user: drh tags: trunk) | |
| 13:50 | Avoid use of uninitialized memory while running defragmentPage() on a corrupt database file. dbsqlfuzz 4c45cecc0b255aaf2ea85453ccd17e814fd0b6b2 (check-in: 35e40d7575 user: drh tags: trunk) | |
| 11:50 | Fix an assert() in the OP_ParseSchema opcode that might fail on a corrupt database file when running with PRAGMA writable_schema=ON. dbsqlfuzz e7d743ca65f2767e415095f0c5a49166a0f55eea. (check-in: 10801f65af user: drh tags: trunk) | |
| 00:54 | Remove unnecessary end-of-line whitespace from the regexp.c extension. (check-in: 17e26a1f5e user: drh tags: trunk) | |
| 00:41 | Omit the unnecessary highlighting of the security implications of SQLTIE_DIRECTONLY in the sqlite3_create_function() documentation. No changes to code. (check-in: 2aa9368b63 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2020-06-07
| ||
| 22:44 | Fix minor OOM problems. (Closed-Leaf check-in: 8b23d80271 user: drh tags: persist-agginfo) | |
| 20:18 | AggInfo objects might be referenced even after the sqlite3Select() function that created them has exited. So AggInfo cannot be a stack variable. And it must not be freed until the Parse object is destroyed. (check-in: 3c840b4df3 user: drh tags: persist-agginfo) | |
| 17:33 | Alternative fix to ticket [c8d3b9f0a750a529]: Prior to deleting or modifying an Expr not that is referenced by an AggInfo, modify the AggInfo to get its own copy of the original Expr. (check-in: 7682d8a768 user: drh tags: persist-agginfo) | |
| 14:42 | New debugging output. (Leaf check-in: c0d9dfe507 user: drh tags: early-winfunc-rewrite-dev) | |
| 12:26 | Improvements to the treeview debugging display. (check-in: a7c5c73992 user: drh tags: early-winfunc-rewrite-dev) | |
| 03:01 | • New ticket [f7d890858f] Segfault in moveToRoot. (artifact: 88abc01a39 user: yongheng) | |
| 00:51 | Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (Leaf check-in: 765bbcce1d user: drh tags: branch-3.32-early-winfunc-rewrite) | |
| 00:43 | • Fixed ticket [e5504e987e]: Segfault in sqlite3VdbeCursorMoveto plus 5 other changes (artifact: 42cf529a17 user: drh) | |
| 00:43 | Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (check-in: a6c2147cc6 user: drh tags: early-winfunc-rewrite-dev) | |
15 Years Ago (more context)
|
2010-06-07
| ||
| 19:26 | In os_unix.c, call munmap() to unmap a shared-memory region prior to closing the associated file descriptor. (check-in: 95cc976f15 user: dan tags: trunk) | |
| 17:47 | Change all.test, quick.test and permutations.test so that they use a separate interpreter for each test file. (check-in: 7c33eb5a5a user: dan tags: trunk) | |
| 14:28 | Refactor some of the global variables and commands used by tester.tcl. (check-in: c2edf8e17f user: dan tags: trunk) | |
| 06:11 | Add a couple of extra coverage tests for wal.c. (check-in: cfe60254df user: dan tags: trunk) | |
20 Years Ago (more context)
|
2005-06-07
| ||
| 22:22 | Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) (check-in: 62a7353d4a user: drh tags: trunk) | |
| 20:07 | In the documentation, amplify the fact that encodings cannot be changed on a database that already exists. Ticket #1277. (CVS 2503) (check-in: 4704f3a19a user: drh tags: trunk) | |
| 09:21 | Remove SSE vacuum hook. (CVS 2502) (check-in: 59960a5915 user: danielk1977 tags: trunk) | |
| 07:58 | Add "#ifndef OMIT_DISKIO" condition around sqlite3_opentemp_count variable in test interface code. (CVS 2501) (check-in: f2ce662e81 user: danielk1977 tags: trunk) | |
| 02:12 | Add tests to make sure statement journals are only opened when necessary. (CVS 2500) (check-in: 914d6e6549 user: drh tags: trunk) | |
| 01:43 | Do not open a statement journal unless absolutely necessary. (CVS 2499) (check-in: 989573a53b user: drh tags: trunk) | |
25 Years Ago (more context)
|
2000-06-07
| ||
| 23:51 | :-) (CVS 74) (check-in: 2ffeb8509c user: drh tags: trunk) | |
| 15:39 | :-) (CVS 73) (check-in: a00b81b0e1 user: drh tags: trunk) | |
| 15:24 | :-) (CVS 72) (check-in: 6f8de336d0 user: drh tags: trunk) | |
| 15:23 | :-) (CVS 71) (check-in: a92eb77170 user: drh tags: trunk) | |
| 15:11 | :-) (CVS 70) (check-in: d3baa046c9 user: drh tags: trunk) | |
| 14:42 | :-) (CVS 69) (check-in: e4f6b17f66 user: drh tags: trunk) | |
| 14:42 | :-) (CVS 1697) (check-in: 5d773b5d4e user: drh tags: trunk) | |
| 02:04 | :-) (CVS 68) (check-in: fc8d25ea1f user: drh tags: trunk) | |
| 01:33 | :-) (CVS 67) (check-in: 8bff1bee63 user: drh tags: trunk) | |
| 01:27 | :-) (CVS 66) (check-in: 5d2e72e4bd user: drh tags: trunk) | |
| 00:12 | :-) (CVS 65) (check-in: 80ee166ed1 user: drh tags: trunk) | |