This Day In History For 2025-12-06
1 Year Ago (more context)
|
2024-12-06
| ||
| 18:35 | Add the SQLITE_PREPARE_DONT_LOG option for sqlite3_prepare_v3(), that prevents errors in the compilation of the SQL from being sent to sqlite3_log(). (check-in: 8704034254 user: drh tags: trunk) | |
| 17:52 | Update logging (now v=16) to more closely analyze all attempts to load the main db schema. (check-in: 65b753735b user: dan tags: cf8f1552-commit-instr) | |
| 17:04 | • Post: Anomalous error messages from "PRAGMA table_list". (artifact: 00ee467ece user: drh) | |
| 09:36 | Guard the x64 assembler in wal.c with "ifdef __x86_64__". (check-in: 5fa1699e31 user: dan tags: cf8f1552-commit-instr) | |
| 00:12 | Minor doc update in auto.def. No functional changes. (check-in: d324be296d user: stephan tags: trunk) | |
| 00:09 | Ensure that the post-config checks for @UNEXPANDED_VARS@ pass even if --disable-tcl is used, as reported in forum post 74ef8059fc. (check-in: a38606bf44 user: stephan tags: trunk) | |
2 Years Ago (more context)
|
2023-12-06
| ||
| 22:22 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 5c36819c42 user: drh tags: reuse-schema) | |
| 21:18 | Merge the latest trunk changes into the bedrock branch. (check-in: c2e53000f4 user: drh tags: bedrock) | |
| 21:11 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 457724e738 user: drh tags: wal2) | |
| 21:05 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: b1c58f485f user: drh tags: begin-concurrent) | |
| 18:34 | Fix compiler warning about shadowed variable in fts5_index.c. (check-in: ee70e4c1c9 user: dan tags: trunk) | |
| 18:25 | Work around LLVM's newfound hatred of function pointer casts. Forum post 1a7d257346636292. (check-in: ec0ae40309 user: drh tags: trunk) | |
| 18:10 | Update documentation comments in fts5.h. (check-in: 38c50e22c9 user: dan tags: trunk) | |
| 17:50 | Do correct comparisons between object labels in JSON even when the two labels contain different JSON escapes. (check-in: bda2e30cc2 user: drh tags: trunk) | |
| 17:39 | Correctly handle 8-byte sizes in the JSONB format. Forum post 283daf08e91183fc. (check-in: 73d390f39c user: drh tags: trunk) | |
| 16:57 | Fix the routine that determines the json_tree.path value for the first row so that it correctly takes into account escape sequences in the path argument. (Closed-Leaf check-in: b9243ee8a3 user: drh tags: json-label-compare) | |
| 16:27 | In CLI, move -interactive flag handling back to arg-loop pass 2. (check-in: 63cb05a862 user: larrybr tags: trunk) | |
| 15:50 | Test cases for object label matching with escape sequences. (check-in: c6f2aa38e9 user: drh tags: json-label-compare) | |
| 15:35 | The rule for the RHS of the ->> and -> operators when the RHS does not begin with $ is that it must be (1) all digits, or (2) all alphanumerics, or (3) contained within [..] or else it will become a quoted label. (check-in: 0e059a546e user: drh tags: json-label-compare) | |
| 14:50 | Increased rigor in comparisons between object labels in JSON. (check-in: 2bc86d145f user: drh tags: json-label-compare) | |
| 14:36 | Add the tokendata=1 option and related APIs to fts5. (check-in: a76a636b23 user: dan tags: trunk) | |
| 14:30 | Merge trunk changes into this branch. (Closed-Leaf check-in: 8f46eace86 user: dan tags: fts5-token-data) | |
| 12:30 | README.md typo fix reported in the forum and update all links from http: to https:. (check-in: 5c48acdbb4 user: stephan tags: trunk) | |
3 Years Ago (more context)
|
2022-12-06
| ||
| 19:58 | • New ticket [679ed6a282] Different affinities in CREATE VIEW depending if column names declared. (artifact: 7a0f43e8cd user: drh) | |
| 19:32 | Enhance CLI .sha3sum to warn of text fields that are not to-blob-to-text reversible. (check-in: bbde0f36d0 user: larrybr tags: trunk) | |
| 19:25 | Merge from trunk prepratory to branch end. (Closed-Leaf check-in: 1d01f8483a user: larrybr tags: sha3sum_text_validation) | |
| 19:20 | Avoid several -Wall warnings in textfixture build. (check-in: 03ae8680e4 user: larrybr tags: trunk) | |
| 18:48 | For CLI .sha3sum, emit warning to stderr for any invalidly encoded text fields. (check-in: 8e833ecc81 user: larrybr tags: sha3sum_text_validation) | |
| 18:48 | Have sqlite3_stmt_scanstatus_v2() return an NCYCLE value for all loops, not just virtual tables ones. The value returned is the sum of the NCYCLE counts for the various opcodes that move or read data from the table or index cursor associated with the loop. (check-in: 9499b2f51e user: dan tags: trunk) | |
| 17:59 | Clear a few more -Wall warnings and simplify dynaprompt feature keep/omit macros. (check-in: 540e895d87 user: larrybr tags: trunk) | |
| 15:24 | Simplified experimental changes to promote the use of co-routines. Less cruft than the coroutines-exp1 branch, but still does not work. Checked in as a work-in-progress. (check-in: e2318a30bf user: drh tags: coroutines-exp2) | |
| 15:22 | • Edit [e7d323c16ee77481|e7d323c16e]: Mark "Closed". (artifact: c198e561ab user: drh) | |
| 15:11 | Fix compiler warnings in the new dynamic continuation prompt logic of the CLI. (check-in: 0d80500d35 user: drh tags: trunk) | |
| 13:12 | In the unix backend, when implementing the defenses against small file descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so that it can be created again the next time through the loop. Fix for the problem described by forum post 699af709ab3a8ccf. (check-in: c0cfe0582a user: drh tags: trunk) | |
| 11:41 | Support an SQLITE_SCANSTAT_NCYCLE statistic for "CO-ROUTINE" elements. (check-in: d3f6a207fd user: dan tags: trunk) | |
| 11:21 | JS vtables: add infrastructure related to accessing and modifying sqlite3_index_info. (check-in: 0d77c34803 user: stephan tags: wasm-vtab) | |
| 09:49 | Remove deprecated symbol sqlite3.opfs.OpfsDb, which was renamed to sqlite3.oo1.OpfsDb on 2022-11-29. (check-in: 0ce51bed65 user: stephan tags: wasm-vtab) | |
| 08:46 | Rename wasm.cstringToJs() to wasm.cstrToJs() for consistency with other wasm.cstr... APIs. (check-in: cbf483ea0b user: stephan tags: wasm-vtab) | |
| 08:39 | Add wasm.cArgvToJs() to support sqlite3_module::xConnect(). (check-in: c3ebdccf94 user: stephan tags: wasm-vtab) | |
| 08:21 | Minor internal JS code/docs cleanups. (check-in: 21331bdd36 user: stephan tags: wasm-vtab) | |
| 06:21 | Merge trunk into wasm-vtab branch. (check-in: d106edb956 user: stephan tags: wasm-vtab) | |
| 06:16 | Minor test tweaks. (check-in: f902f3b2c7 user: stephan tags: wasm-vtab) | |
| 06:09 | Add a demonstration sqlite3_vtab/module implemented in JS, based on ext/misc/templatevtab.c. Add oo1.selectArrays() and selectObjects(). (check-in: 60482c97e0 user: stephan tags: wasm-vtab) | |
| 05:31 | Add optional feature: A CLI continuation prompt which reflects open lexemes and parens, similarly to PG shell. (check-in: f41f18b1c3 user: larrybr tags: trunk) | |
| 05:09 | Add optional feature: A CLI continuation prompt which reflects open lexemes and parens, similarly to PG shell. (Leaf check-in: dac2ddc287 user: larrybr tags: dynamic_prompt) | |
| 00:54 | Highly experimental (and non-working) changes aimed at increasing the number of occasions where a subquery can be implemented using a co-routine rather than being materialized. This is just saving work in progress. (Closed-Leaf check-in: e7d323c16e user: drh tags: coroutines-exp1) | |
4 Years Ago (more context)
|
2021-12-06
| ||
| 23:07 | Improved EXPLAIN QUERY PLAN output for Bloom filters. (check-in: 00070e1fff user: drh tags: bloom-filter) | |
| 21:45 | Add SQLITE_STMTSTATUS_FILTER_HIT and _MISS for tracking the effectiveness of Bloom filters. (check-in: 24ba535d20 user: drh tags: bloom-filter) | |
| 20:16 | Omit the OP_FilterInit opcode. Use OP_Blob to initialize each Bloom filter instead. Size the Bloom filter based on sqlite_stat1 size estimates rather than a run-time measurement for improved testability. (check-in: 8a9036ee61 user: drh tags: bloom-filter) | |
| 19:11 | Merge trunk fixes into the bloom-filter branch. (check-in: edacf8034d user: drh tags: bloom-filter) | |
| 19:03 | Fix an OOB read that could occur in fts5 when processing corrupt records. (check-in: 734606ea1a user: drh tags: branch-3.37) | |
| 18:57 | Fix an OOB read that could occur in fts5 when processing corrupt records. (check-in: bb9b1a15f7 user: dan tags: trunk) | |
| 17:23 | Create new branch named "ppvar_manage" (Leaf check-in: 74ee8d2bda user: larrybr tags: ppvar_manage) | |
| 16:56 | Do not allow SQLITE_LIMIT_LENGTH to be set lower than 1 as an SQLITE_LIMIT_LENGTH of 0 causes lots of unnecessary problems for users of the sqlite3_str object. (check-in: 286243f3a4 user: drh tags: branch-3.37) | |
| 16:51 | Do not allow certain dangerous ".testctrl" commands in safe mode. (check-in: 4602644f85 user: drh tags: branch-3.37) | |
| 16:42 | Fix SQLITE_TESTCTRL_IMPOSTER so that it is a harmless no-op if the schema parameter is invalid. (check-in: b15c553c2c user: drh tags: branch-3.37) | |
| 16:36 | In the shell tool, avoid modifying internal data structures until after the arguments to ".open" have been parsed. (check-in: cbd69ed8af user: drh tags: branch-3.37) | |
| 16:29 | Start a new branch on which to cherrypick fixes against 3.37.0. (check-in: cea9e41aae user: drh tags: branch-3.37) | |
| 16:22 | Merge .testctrl safe mode blocks (check-in: a42fc4ac08 user: larrybr tags: cli_extension) | |
| 15:40 | Do not allow SQLITE_LIMIT_LENGTH to be set lower than 1 as an SQLITE_LIMIT_LENGTH of 0 causes lots of unnecessary problems for users of the sqlite3_str object. (check-in: 8fd5b8ec4a user: drh tags: trunk) | |
| 15:24 | Do not allow certain dangerous ".testctrl" commands in safe mode. (check-in: 080e72d119 user: drh tags: trunk) | |
| 15:08 | Fix SQLITE_TESTCTRL_IMPOSTER so that it is a harmless no-op if the schema parameter is invalid. (check-in: 2d9a45ab10 user: drh tags: trunk) | |
| 13:07 | Attempt to vary the size of Bloom filters based on an estimate of how many keys the filter will hold. (check-in: a7adcf6908 user: drh tags: bloom-filter) | |
15 Years Ago (more context)
|
2010-12-06
| ||
| 21:09 | Fix the build so that it once again works with SQLITE_OMIT_SHARED_CACHE and SQLITE_OMIT_AUTOVACUUM. (check-in: fabcb6b95e user: drh tags: trunk) | |
| 21:06 | Add the ability to disable constant factoring using sqlite3_test_control(). Add a TCL interface to this new capability and add tests cases to the TCL test scripts to actually use the new capability. (check-in: ad8bc68197 user: drh tags: trunk) | |
| 18:59 | Back out part of the previous change that was not really necessary in order to fix [80ba201079ea60], and which in fact serves no useful purpose. (check-in: fa9eef865f user: drh tags: trunk) | |
| 18:50 | Initialize all constants at the very beginning of a prepared statement. Do not allow constant initialization to occur once control flow has a chance to diverge, to avoid the possibility of having uninitialized registers. Ticket [80ba201079ea60807]. (check-in: c5c53152d6 user: drh tags: trunk) | |
| 17:11 | Have sqlite3_blob_bytes() return 0 following a failed call to sqlite3_reopen_blob(). (check-in: 476a8b4921 user: dan tags: trunk) | |
| 16:01 | • New ticket [80ba201079] Bug involving subqueries and the OR optimization. (artifact: 4cebcddb11 user: dan) | |
20 Years Ago (more context)
|
2005-12-06
| ||
| 17:48 | Allow VACUUM to detach the auxillary database after malloc() fails. (CVS 2804) (check-in: 6824a78bc7 user: danielk1977 tags: trunk) | |
| 17:19 | Modify ATTACH and DETACH to execute at runtime instead of compile time. (CVS 2803) (check-in: 5e04ec694a user: danielk1977 tags: trunk) | |
| 13:19 | Report errors out of sqlite3_open16(). (CVS 2802) (check-in: f5b58163d4 user: drh tags: trunk) | |
| 12:57 | Add test file for new malloc() failure handling. (CVS 2801) (check-in: 0b82f9623c user: danielk1977 tags: trunk) | |
| 12:52 | Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800) (check-in: e1606658f1 user: danielk1977 tags: trunk) | |