This Day In History For 2025-05-24
1 Year Ago (more context)
|
2024-05-24
| ||
| 23:44 | Ensure that queries like "SELECT func(a) FROM tab GROUP BY 1" only call the func() function once per row. Fix for the issue described in forum thread bf8f43aa522c2299. (check-in: 663f5dd32d user: drh tags: trunk) | |
| 21:38 | Fix another fts5 problem related to unknown tokenizer modules. (check-in: e78b778304 user: dan tags: trunk) | |
| 21:23 | Fix a crash in fts5 that could occur within "PRAGMA integrity_check" if the specified tokenizer was unknown. (check-in: 061d7b69e6 user: dan tags: trunk) | |
| 20:18 | When omitting result columns for the vector-IN optimization, make sure that any result-set column references in both the ORDER BY clause and the GROUP BY clause are updated appropriately. (Closed-Leaf check-in: f890812df0 user: drh tags: group-by-consistency) | |
| 18:31 | Ensure that queries like "SELECT indeterministic(a) FROM tbl GROUP BY 1" invoke the indeterministic function only once for each row of tbl. (check-in: 4555d66547 user: dan tags: group-by-consistency) | |
| 14:16 | Add the stmtrand() extension function for use in testing. (check-in: 5c97a5b9d1 user: drh tags: trunk) | |
| 13:33 | Fix an "ifcapable" expression in values.test. (check-in: b8442d2a60 user: dan tags: trunk) | |
3 Years Ago (more context)
|
2022-05-24
| ||
| 22:16 | fiddle: added support for exporting (downloading) the current db file. To do this we had to fall back to named dbs, instead of defaulting to an in-memory one, but the virtual filesystem is an in-memory FS, so the end effect is the same. (check-in: 7c7fd34c8a user: stephan tags: fiddle-local-db) | |
| 19:01 | fiddle: initial work on loading a client-side db file. Works but requires some cleanup. Export is not yet implemented. (check-in: 0fa8378c00 user: stephan tags: fiddle-local-db) | |
| 16:05 | When an ON clause on an INNER JOIN references a table to the right of of the join, just convert the ON clause to an ordinary WHERE clause term, in order to be compatible with older versions of SQLite. See forum thread 687b0bf563a1d4f1 for details. (check-in: 2b6ebba26d user: drh tags: trunk) | |
| 14:46 | • Edit [2f9a42fb141d386f|2f9a42fb14]: Edit check-in comment. (artifact: 0d0c7dc7c0 user: stephan) | |
| 14:45 | Use more descriptive var names in ext/fiddle/Makefile. (check-in: 2f9a42fb14 user: stephan tags: trunk) | |
| 14:36 | fiddle: lots of generic refactoring, restructuring, and cleanup in the higher-level code. Added push-fiddle ext/fiddle/Makefile target to push the fiddle app to a remote server via rsync. (check-in: ed19fef345 user: stephan tags: trunk) | |
| 01:15 | wasm/JS: minor doc updates, corrected bind()ing of the undefined value to behave as documented, removed some superfluous code. (check-in: 526c8c7280 user: stephan tags: trunk) | |
| 00:35 | wasm/JS: documented DB.selectValue() and corrected the fetching of NULL columns via Stmt.get(). (check-in: 70f91fab82 user: stephan tags: trunk) | |
| 00:22 | wasm/JS: added support for scalar UDFs. Fixed a deallocation problem with bind()ed strings/blobs. (check-in: 325a9ee31a user: stephan tags: trunk) | |
4 Years Ago (more context)
|
2021-05-24
| ||
| 14:35 | Fix a problem in the in-memory journal code that could occasionally lead to a segfault when a sub-transaction that modified zero pages was committed. (check-in: 17960165f5 user: dan tags: trunk) | |
| 12:28 | Minor comment improvements in fuzzcheck.c. (check-in: 7aca8d52c1 user: drh tags: trunk) | |
| 12:13 | New dbsqlfuzz cases added to test/fuzzdata8.db. (check-in: 5bb5c9ec04 user: drh tags: trunk) | |
| 11:35 | Fix the TreeView module so that it works with the TK_ERROR exprssion. Also fix an assert() that was failing due to the recent TK_ERROR addition. (check-in: dd56fbe0cf user: drh tags: trunk) | |
| 00:17 | Additional defenses (above and beyond [b986600520696b0c]) to prevent an invalid subquery from causing problems downstream. If an error is found while analyzing a subquery expression, change the expression to TK_ERROR so inhibit further processing on that expression. dbsqlfuzz cf624b8c0484c66e0f552bf6475e3e3f2c22b24e. (check-in: 0be6b6c9f7 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2020-05-24
| ||
| 12:36 | Version number to 3.32.1. (check-in: 56e5063c32 user: drh tags: trunk) | |
| 03:39 | • Fixed ticket [7a5279a25c]: Segfault in sqlite3ExprCodeTarget plus 5 other changes (artifact: b803c5fed4 user: drh) | |
| 03:38 | When rewriting a query for window functions, if the rewrite changes the depth of TK_AGG_FUNCTION nodes, be sure to adjust the Expr.op2 field appropriately. Fix for ticket [7a5279a25c57adf1] (check-in: ad7bb70af9 user: drh tags: trunk) | |
| 03:01 | Move some utility Walker callbacks into the walker.c source file, as they seem to belong there better. (check-in: dac438236f user: drh tags: trunk) | |
| 02:05 | Improvements to parse-tree tracing logic. No changes in deliverable code. (check-in: f7e5a68a7e user: drh tags: trunk) | |
| 00:30 | Minor fix to a comment. No code changes. (check-in: efdbb2b499 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2015-05-24
| ||
| 21:46 | The assert() changes removed in the previous check-in are needed after all. (check-in: 336fccc84c user: drh tags: trunk) | |
| 21:09 | Better detection of corruption in allocateSpace() in btree.c. (check-in: bf7bb53ee2 user: drh tags: trunk) | |
| 10:18 | Detect database corruption in the modifyPagePointer() routine and abort. (check-in: 4f0bba42f9 user: drh tags: trunk) | |
15 Years Ago (more context)
|
2010-05-24
| ||
| 20:27 | OOM errors during an auto-checkpoint are benign. (check-in: 3d252ce5d0 user: drh tags: trunk) | |
| 20:24 | Remove the walmode.test case from the inmemory_journal test of permutations.test. (check-in: 27ba9c21fb user: drh tags: trunk) | |
| 17:00 | Fix the wal2.test script so that it works in auto_vacuum mode. (check-in: 6a818afb93 user: drh tags: trunk) | |
| 13:57 | Change the checksum used in WAL files so that each frames checksum depends on the content of the WAL header and all frame headers and content up to and including the frame to which the checksum is attached. (check-in: 8a53f12c83 user: dan tags: trunk) | |
| 13:28 | Make sure a WAL frame of all zeros is detected as an invalid frame. (check-in: 02d99ad4b5 user: drh tags: trunk) | |
| 12:34 | Fix up test_osinst.c to work with SQLITE_OMIT_VIRTUALTABLE. (check-in: 51fd38152b user: drh tags: trunk) | |
| 10:39 | Change the WAL file format to support two kinds of checksums - one that is fast to calculate on little-endian architectures and another that is fast on big-endian architectures. A flag in the wal-header indicates which the file uses. (check-in: 65ba804dd1 user: dan tags: trunk) | |
20 Years Ago (more context)
|
2005-05-24
| ||
| 20:19 | Remove the config.h file from the build. Ticket #1224. (CVS 2480) (check-in: 3e64f1ab41 user: drh tags: trunk) | |
| 12:01 | Move a few things around to make building without the parser easier. (CVS 2479) (check-in: 5fadb464eb user: danielk1977 tags: trunk) | |