This Day In History For 2025-05-21
1 Year Ago (more context)
|
2024-05-21
| ||
| 17:37 | Ensure an sqlite_dbdata cursor is properly reset before being used again, even if it has already encountered database corruption. (check-in: 3210e1ca4d user: dan tags: trunk) | |
| 15:24 | Merge the latest trunk enhancements into the bedrock branch. (check-in: c65a82f1fa user: drh tags: bedrock) | |
| 15:20 | Merge the lates trunk enhancements into the reuse-schema branch. (check-in: 97e0af8882 user: drh tags: reuse-schema) | |
| 15:20 | Merge the latest trunk enhancements into the wal2 branch. (check-in: d4217d9f70 user: drh tags: wal2) | |
| 15:17 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 5c1c8651d1 user: drh tags: begin-concurrent) | |
| 14:54 | Do not attempt to run mmapcorrupt.test with builds that do not support mmap(). (check-in: 54a49f1847 user: dan tags: trunk) | |
| 13:34 | Fix harmless compiler warnings. (check-in: aab59f9f7c user: drh tags: trunk) | |
| 11:11 | Fix the -> and ->> operators so that when the RHS is a string that looks like a number, it is still treated as a string, because that is what PG does. Forum post 9e52cdfe15c3926e. (check-in: de8182cf17 user: drh tags: trunk) | |
2 Years Ago (more context)
|
2023-05-21
| ||
| 05:06 | First serious stab at FIDDLE-build-ready. Fix a flub with absent -A option for some builds. (check-in: bfc36f0f10 user: larrybr tags: cli_extension) | |
| 02:48 | CLI code cleanup and shuffle for clarity. Moderate refactoring to exploit commmon patterns. Extend OOM simulation for debug builds. Plug one leak. Fix trivial nit copied from trunk. (check-in: b64ef7f92e user: larrybr tags: cli_extension) | |
3 Years Ago (more context)
|
2022-05-21
| ||
| 21:13 | Minor fiddle-related build restructuring to support upcoming development of the C-style wasm sqlite3 interface, plus some commentary about the plans and goals for that. (check-in: c7cfdd4c36 user: stephan tags: trunk) | |
| 18:03 | Defer materializing a view or subquery until the materialization is actually needed, so that if it is not needed, not useless work is performed. (Closed-Leaf check-in: 16bf350683 user: drh tags: deferred-materialize) | |
| 15:54 | Fix a typo in a comment. (check-in: 34d7045b2c user: drh tags: deferred-materialize) | |
| 15:12 | Use the newer OP_BeginSubrtn opcode instead of OP_Integer to start the subroutine used to matrialize a view. This does not change execution but does make the byte code a little easier to read. (check-in: cebd4fd606 user: drh tags: deferred-materialize) | |
| 14:19 | fiddle: refactor into main thread (UI) and worker thread (wasm module). Added bits needed to support triggering sqlite3_interrupt() but do not yet have a second SharedWorker to test it with. (check-in: 5ff3326856 user: stephan tags: trunk) | |
| 00:45 | fiddle: add a selection list of example queries. (check-in: 74abf03977 user: stephan tags: trunk) | |
| 00:01 | In the shell WASM build, call open_db() early so that we can get access to the global db handle from certain experimentation-only function without having to first run some SQL code. (check-in: 31706ef851 user: stephan tags: trunk) | |
4 Years Ago (more context)
|
2021-05-21
| ||
| 21:49 | If there are errors in a nested CTE, be sure to abandon processing. Do not continue since the parse tree may have been left in a goofy state which could cause use-after-free and segfaults. See forum post aa4a7a3980 for an example. (check-in: 94225d6939 user: drh tags: trunk) | |
| 18:27 | • Edit [c5e2de1d24d34589|c5e2de1d24]: Move to branch bad-merge. Mark "Closed". Edit check-in comment. (artifact: 0becfa9ff4 user: drh) | |
| 17:45 | • Edit [41e742bd0f94894b|41e742bd0f]: Mark "Closed". (artifact: 82ecd504b2 user: drh) | |
| 17:31 | Merge latest changes from wal2 into this branch. (check-in: 4efefb5938 user: dan tags: begin-concurrent-pnu-wal2) | |
| 16:42 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 95cc778345 user: drh tags: wal2) | |
| 16:41 | Fix a problem with SQLITE_MAX_MEMORY in malloc.c. (check-in: c18dbe2f38 user: dan tags: trunk) | |
| 16:32 | Merge the latest trunk changes into begin-concurrent-report branch via the begin-concurrent-pnu branch. (check-in: 1dc6cf5113 user: drh tags: begin-concurrent-report) | |
| 16:17 | Merge recent trunk changes into the begin-concurrent-pnu branch. (check-in: a8d05f8e92 user: drh tags: begin-concurrent-pnu) | |
| 15:33 | Merge all recent trunk changes into the begin-concurrent branch. (check-in: 0dba9010ad user: drh tags: begin-concurrent) | |
| 13:32 | Add a new sqlite3_config() option for setting the maximum precision of a printf() substitition. The default value is 100,000. It was formerly more than 2 billion. The default can be changed using the SQLITE_PRINTF_PRECISION_LIMIT compile-time option. (Leaf check-in: fd8b68a474 user: drh tags: compile-time-precision-limit) | |
5 Years Ago (more context)
|
2020-05-21
| ||
| 20:38 | Change a NEVER macro into a NO_TEST comment, as the conditional is reachable, but only when compiling for Windows 32-bit. (check-in: ce36b6d133 user: drh tags: trunk) | |
| 19:13 | Avoid another potential OOB read in sqlite3expert.c. (check-in: 0ccea80092 user: dan tags: trunk) | |
10 Years Ago (more context)
|
2015-05-21
| ||
| 20:26 | Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". drh added later: All changes on this branch have been cherrypicked to trunk and will be merged into sessions from trunk. So this branch can close. (Closed-Leaf check-in: b9e45596d8 user: dan tags: sessions-value-dup) | |
| 17:24 | Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. Cherrypick of [cbeb9a1aed8c]. (check-in: b3bb660af9 user: dan tags: branch-3.8.6) | |
| 17:21 | Avoid ever writing before the start of an allocated buffer in the DIRECT_OVERFLOW_READ code. Fix for [e3a290961a6]. Cherrypick of [c3c15d20c691]. (check-in: 31b13eb528 user: dan tags: branch-3.8.6) | |
| 02:24 | Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. Cherrypick [ad4b19d2ac0889a] (check-in: 000197cc4e user: drh tags: branch-3.7.11) | |
| 02:20 | Ensure that tables names are dequoted exactly once by the trigger logic. Cherrypick [59e92bd9521f1e8] and [9d887b92f8086961e]. (check-in: 9e3f64a4f4 user: drh tags: branch-3.7.11) | |
| 02:07 | When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c] with additional changes. (check-in: 09784f376b user: drh tags: branch-3.7.11) | |
| 01:04 | Do not allow virtual table constructors to be called recursively. Cherrypick [0a72726da21581ab] (check-in: 0f0694e424 user: drh tags: branch-3.7.11) | |
| 00:50 | Add the ".open" command to the command-line shell. Cherrypick from [21eccb919441]. (check-in: a71e2a72c5 user: drh tags: branch-3.7.11) | |
15 Years Ago (more context)
|
2010-05-21
| ||
| 19:15 | Fix another bug in walClearHash(). (check-in: 40f80ffe70 user: dan tags: trunk) | |
| 18:24 | Comment out the SQLITE_FCNTL_SIZE_HINT from os_unix.c since it does not seem to provide any performance gain there. (check-in: 7d01309da6 user: drh tags: trunk) | |
| 16:23 | Correct an off-by-one bug in the previous commit. (check-in: 75a1130d86 user: dan tags: trunk) | |
| 15:31 | Remove entries from wal-index hash tables when a rollback or savepoint rollback occurs. (check-in: 36795c2b23 user: dan tags: trunk) | |
| 13:16 | Fix the wal-index header read routine so that it correctly detects a zero header as being malformed and in need of a wal-index rebuild. (check-in: 1a4eb3a3ef user: drh tags: trunk) | |
20 Years Ago (more context)
|
2005-05-21
| ||
| 18:32 | Speed improvements as described by tickets #1257 and #1258. These changes help some but are nowhere near the 23% claimed in the tickets. (CVS 2469) (check-in: 3fa177c54a user: drh tags: trunk) | |
| 02:48 | More structure rearrangements for additional size reductions. Ticket #1253. (CVS 2468) (check-in: 6b6e525b29 user: drh tags: trunk) | |