This Day In History For 2025-09-30
1 Year Ago (more context)
|
2024-09-30
| ||
| 19:01 | Add static library build. Get build working (for a given value of working) with the --disable-amalgamation flag. (check-in: ddfda58004 user: stephan tags: autosetup) | |
| 18:19 | Fix the character width tables for the CLI such that all unicode code-points less than 0x300 have a width of 1. This is in fact the case for Mac, Ubuntu, and Windows. (check-in: f0c5a86fef user: drh tags: trunk) | |
| 17:57 | Merge the latest trunk enhancements, via the wal2 branch, into the bedrock branch. (check-in: fd6ff55141 user: dan tags: bedrock) | |
| 17:53 | Fix a usan warning in test_hexio.c on this branch. (check-in: 59fba0288d user: dan tags: wal2) | |
| 17:44 | More generic build tinkering. (check-in: 433bfc7902 user: stephan tags: autosetup) | |
| 17:32 | Merge the latest trunk enhancements, including fix for assert() failure in fts5, into the wal2 branch. (check-in: ab63561812 user: dan tags: wal2) | |
| 17:28 | In fts5, avoid starting a new merge of level L if there exists already an ongoing merge of a level less than L. (check-in: 350c6e75ce user: dan tags: trunk) | |
| 15:17 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 1ba833743d user: drh tags: reuse-schema) | |
| 14:41 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 0f9e2fceec user: drh tags: wal2) | |
| 14:33 | Generic build tinkering. (check-in: b6c1772ce0 user: stephan tags: autosetup) | |
| 12:39 | Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 1bf073d7c0 user: drh tags: begin-concurrent) | |
2 Years Ago (more context)
|
2023-09-30
| ||
| 18:13 | Changes so that fts5 can handle tokens with embedded '\0' bytes. (check-in: c027c092c4 user: dan tags: fts5-token-data) | |
| 17:08 | Fix JNI binding to compile without SQLITE_ENABLE_PREUPDATE_HOOK. Add build option to disable all optional ENABLE flags. (check-in: c04022b740 user: stephan tags: trunk) | |
| 16:50 | Restore the trunk version of sqlite3_user_data(). Fix the xColumn for virtual tables so that the sqlite3_context contains a valid but NULL user data pointer. (check-in: 15ffd932fe user: drh tags: jsonb) | |
| 16:19 | Make all SQLite3Jni methods which take a void-pointer-as-long-int argument explicitly package-private, as they're always for internal use only even if SQLite3Jni is eventually made public. (check-in: 5e387275f6 user: stephan tags: trunk) | |
| 14:48 | JNI: rename sqlite3_errmsg16() to sqlite3_errmsg(), as the 16 suffix is superfluous there. (check-in: df25b21689 user: stephan tags: trunk) | |
| 14:34 | Expose sqlite3_stmt_busy() to JNI. (check-in: 5733aa5fe3 user: stephan tags: trunk) | |
| 14:34 | Finish adding jsonb_ versions for all JSON routines that return JSON text. (check-in: 6daa7b6969 user: drh tags: jsonb) | |
| 13:16 | Correct an undefined-value deref in the JS bindings, triggered by passing invalid args and then tripping over an undefined value while trying to report that. Reported in forum post dd42df144651d779. (check-in: 1545f0f735 user: stephan tags: branch-3.43) | |
| 13:13 | Correct an undefined-value deref in the JS bindings, triggered by passing invalid args and then tripping over an undefined value while trying to report that. Reported in forum post dd42df144651d779. (check-in: fd46325407 user: stephan tags: trunk) | |
| 10:59 | Make (almost) all SQLite3Jni.sqlite3_... members public but make the SQLite3Jni class package-private, which has the same foot-protection effect but makes it much simpler to patch SQLite3Jni to publicize the interface later. Remove some of the extraneous foot-shooting protection from indidivual functions, in lieu moving it to the still-pending higher-level interfaces. (check-in: 082b86683e user: stephan tags: trunk) | |
| 10:37 | Merge in and close jni-ptr-passing branch. The remaining pointer-passing adaptation can be done incrementally without affecting the interface. (check-in: 7927c42410 user: stephan tags: trunk) | |
| 10:31 | Make all native JNI sqlite3_...() bindings package-private as a foot-shooting protective measure (higher-level pre-native-call argument validation is largely pending). Move SQLTester.java and TesterFts5.java into the org.sqlite.jni package so that they can access the being-tested methods. (Leaf check-in: ec82f7251a user: stephan tags: jni-ptr-passing) | |
| 09:41 | More work towards the new pointer-passing mechanism in JNI, and code-adjacent cleanups. (check-in: 6c63987e89 user: stephan tags: jni-ptr-passing) | |
3 Years Ago (more context)
|
2022-09-30
| ||
| 23:49 | Remove a couple of weird quirks of the Worker1 and Promiser APIs. The Worker1 (now undocumented) unlink capability needs to be reevaluated to work equivalently for all storage backends. (check-in: 9f2b331a32 user: stephan tags: fiddle-opfs) | |
| 23:02 | Tweaks to the Worker1 and Promiser APIs prompted by documenting them. (check-in: c68b9aa160 user: stephan tags: fiddle-opfs) | |
| 22:40 | Remove one of the NEVER() macros added by [5166acf3f0040459] because it is reachable after all. (check-in: bd8ae5febb user: drh tags: trunk) | |
| 20:59 | New test cases in fuzzdata8.db (check-in: aa367a3c97 user: drh tags: trunk) | |
| 20:53 | Fix a bug in the demoDelete fix from [d76a301e22e05722]. (check-in: 7e761a0253 user: drh tags: trunk) | |
| 20:48 | Add NEVER() to two error-detection tests that were made unreachable by the previous check-in. (check-in: 5166acf3f0 user: drh tags: trunk) | |
| 20:35 | Add JS wrapper for sqlite3_exec() which knows how to handle a JS callback. Add some console.error() reporting of module-load failures, as they otherwise often get silently swallowed up by the loader's mechanisms. Add 'flexible-string' JS-to-WASM argument converter which performs more X-to-string conversions than the 'string' arg converter does. (check-in: 96818aa83f user: stephan tags: fiddle-opfs) | |
| 20:15 | Better handle a case of database corruption where a b-tree page is one of its own ancestor pages. (check-in: a24e468048 user: dan tags: trunk) | |
| 16:49 | Add sqlite3.version object. Add more state to the Worker #1 config-get response, including sqlite3.version. (check-in: 711f458d18 user: stephan tags: fiddle-opfs) | |
| 15:46 | Add oo1.JsStorageDb.clearStorage/storageSize() methods, copies of capi.sqlite3_web_kvvfs_clear/size(). (check-in: 1e09efe7fa user: stephan tags: fiddle-opfs) | |
| 15:24 | batch-runner.js: force WebSQL batches to not abort for a failed statement (necessary for apples-to-apples-ish benchmark comparisons). (check-in: 60f0c5cb04 user: stephan tags: fiddle-opfs) | |
| 14:35 | Improvements to the "demoDelete" method in the demovfs, suggested by forum post cad18961c2. (check-in: d76a301e22 user: drh tags: trunk) | |
| 14:14 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: b119a5e896 user: drh tags: reuse-schema) | |
| 14:04 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 68a61513f9 user: drh tags: begin-concurrent-pnu-wal2) | |
| 13:54 | Merge recent trunk enhancements into the wal2 branch. (check-in: c22c7c8798 user: drh tags: wal2) | |
| 13:42 | Merge the latest trunk changes into the begin-concurrent-report branch (check-in: 4d6141f32d user: drh tags: begin-concurrent-report) | |
| 13:29 | Merge all recent trunk enhancements into the begin-concurrent branch. (check-in: ba2539f6de user: drh tags: begin-concurrent) | |
| 12:27 | Merge version 3.39.4 changes into the reuse-schema-3.39 branch. (Leaf check-in: 8102592836 user: drh tags: reuse-schema-3.39) | |
| 12:10 | Expose sqlite3_msize() to wasm. (check-in: aa6ad34f3b user: stephan tags: fiddle-opfs) | |
| 11:01 | Add oo1.JsStorageDb() as a convenience wrapper for oo1.DB(...,'kvvfs'). Minor doc cleanups. (check-in: 8a7998709f user: stephan tags: fiddle-opfs) | |
| 10:55 | wasm: expose sqlite3_de/serialize(), sqlite3_malloc/free() and friends, noting that the former explicitly lies on use of the latter for memory management so is not generically safe for use in wasm. (check-in: fbc0edb5d3 user: stephan tags: fiddle-opfs) | |
4 Years Ago (more context)
|
2021-09-30
| ||
| 21:42 | Adjust 3 query result expectations to reflect changed group_concat() behavior with varying separator. (Closed-Leaf check-in: 86f9c07a4f user: larrybr tags: group_concat_varsep) | |
| 18:42 | Fix a problem with view handling in SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 6e791a24ce user: dan tags: trunk) | |
| 17:39 | Fix rtreedoc.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: a300adc211 user: dan tags: trunk) | |
| 17:20 | Simplify windowed group_concat() by allowing a change in undocumented behavior (fails some new tests) (check-in: 9d8e616738 user: larrybr tags: group_concat_varsep) | |
| 10:47 | Update a test case in rtreedoc.test to account for the fact that release builds generate fewer VM instructions than debug builds. (check-in: 7d16b30282 user: dan tags: trunk) | |
5 Years Ago (more context)
|
2020-09-30
| ||
| 20:35 | Add experimental unicode-aware trigram tokenizer to fts5. And support for LIKE and GLOB optimizations for fts5 tables that use said tokenizer. (check-in: 0d7810c1ae user: dan tags: fts5-trigram) | |
| 18:22 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: f07ac3fb38 user: drh tags: branch-3.28) | |
| 18:06 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: 4a43430fd2 user: drh tags: trunk) | |
| 18:03 | For the OP_SeekScan opcode, adjust the number of steps run before giving up based on the estimated number of comparisons needed to perform a seek. (Closed-Leaf check-in: dc4172e6b8 user: drh tags: in-scan-vs-index) | |
| 17:33 | • Fixed ticket [5c4e7aa793]: Incorrect result for comparison with NULL plus 6 other changes (artifact: 1091db2ab8 user: drh) | |
| 17:32 | Back out the incorrect optimization of check-in [e51ecadcbdef5ce6] as ticket [5c4e7aa793943803] reports a case where the optimization does not work. (check-in: 7395e96b8c user: drh tags: trunk) | |
| 17:18 | • New ticket [5c4e7aa793] Incorrect result for comparison with NULL. (artifact: c71d1ae4f7 user: mrigger) | |
| 15:46 | • Fixed ticket [66e4b0e271]: Incorrect result for LEFT JOIN plus 7 other changes (artifact: 000faea09a user: drh) | |
| 15:36 | In the query flattener when substituting expression Y in place of expression X, if X is marked has having come from an ON or USING clause of a LEFT JOIN, then be sure that all subexpressions of Y, not just the root node of Y, are similarly marked. Otherwise, if Y is an AND operator, it will be split up during WHERE clause analysis and the subexpressions will not get the special treatment needed by LEFT JOIN ON/USING clauses. Fix for ticket [66e4b0e271c47145]. (check-in: 69f9eb7343 user: drh tags: trunk) | |
| 12:47 | • New ticket [66e4b0e271] Incorrect result for LEFT JOIN. (artifact: 2d62d6474e user: mrigger) | |
| 09:17 | Better understanding of savepoint code (check-in: ce6d8d6215 user: shearer tags: trunk) | |
| 00:48 | Add an sqlite3FaultSim() call to btreeNext() to make it easier to simulate I/O errors in calls to sqlite3BtreeNext(), and in OP_SeekScan. (check-in: 29cca775d3 user: drh tags: in-scan-vs-index) | |
| 00:10 | In the OP_SeekScan opcode, changes to pOp must occur after the call to VdbeBranchTaken() so that the VdbeBranchTaken() attributes the branch to the correct opcode. (check-in: 61fbe7aa7c user: drh tags: in-scan-vs-index) | |
10 Years Ago (more context)
|
2015-09-30
| ||
| 14:50 | Merge recent enhancements from trunk, and especially the fix for ticket [1b266395d6bc10]. (check-in: b2face9aa9 user: drh tags: sessions) | |
| 14:30 | Add a corrupt database to test/fuzzdata3.db to validate the previous check-in. (check-in: e796c0efb6 user: drh tags: trunk) | |
| 14:19 | Fix an assert() in btree.c that is only true for non-corrupt databases. (check-in: 29f7227ff1 user: drh tags: trunk) | |
| 14:06 | • Fixed ticket [1b266395d6]: INSERT OR REPLACE with a foreign key constraint leads to assertion fault plus 3 other changes (artifact: b42dc3716f user: drh) | |
| 12:59 | Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395]. (check-in: a6d5e4e869 user: dan tags: trunk) | |
| 12:36 | • Ticket [1b266395d6] INSERT OR REPLACE with a foreign key constraint leads to assertion fault status still Open with 6 other changes (artifact: f0a3eedde7 user: drh) | |
| 12:10 | • New ticket [1b266395d6]. (artifact: 7f88fd969c user: drh) | |
| 11:19 | Improve error handling in shell command ".tables". (check-in: 31a91ee7d3 user: dan tags: trunk) | |
15 Years Ago (more context)
|
2010-09-30
| ||
| 20:33 | Merge experimental into trunk: Refactor the text-to-numeric conversion routines to work without zero-terminators and in UTF16 as well as UTF8. Avoid invalidating strings with doing affinity conversions. (check-in: 07ee080ec4 user: drh tags: trunk) | |
| 20:11 | Fix some matching issues in enc4.test affected by TCL versions. (Closed-Leaf check-in: dd6d61a967 user: shaneh tags: experimental) | |
| 18:43 | Add further tests to e_createtable.test. (check-in: 0a4528d629 user: dan tags: trunk) | |
| 18:30 | Fix memory leak in enc4.test script. (check-in: bfc294ae43 user: shaneh tags: experimental) | |
| 18:19 | Additional encoding tests. (check-in: c7f9363617 user: shaneh tags: experimental) | |
| 18:12 | Remove unnecessary calls to memAboutToChange() in vdbe.c. An affinity change no longer invalidates shallow copies. (check-in: afb0fd0b04 user: drh tags: experimental) | |
| 17:34 | • Fixed ticket [3998683a16]: Some valid floating-point literals are not recognized. plus 2 other changes (artifact: b314a82831 user: drh) | |
| 17:33 | Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. (check-in: ca154f97a5 user: drh tags: experimental) | |
| 16:51 | Changes to remove sqlite3FitsIn64Bits(). (check-in: 43fef1cab6 user: shaneh tags: experimental) | |
| 16:26 | • New ticket [3998683a16] Some valid floating-point literals are not recognized.. (artifact: 7d4b5cce32 user: drh) | |
| 14:48 | • Fixed ticket [8454a207b9]: ALTER TABLE ADD COLUMN with negative DEFAULT value plus 2 other changes (artifact: 788cfd73d9 user: drh) | |
| 14:48 | Fix the handling of default values for ALTER TABLE ADD COLUMN columns so that is able to deal with negative numbers, including large negative numbers. Ticket [8454a207b9fd2243c4] (check-in: ce6cc16e3a user: drh tags: experimental) | |
| 12:56 | • New ticket [8454a207b9] ALTER TABLE ADD COLUMN with negative DEFAULT value. (artifact: 90b2b3d0d1 user: drh) | |
| 00:50 | Rework the text to numeric conversion routines so that they work with either UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. (check-in: 14eed3a0e0 user: drh tags: experimental) | |
25 Years Ago (more context)
|
2000-09-30
| ||
| 23:00 | Version 1.0.8 (CVS 494) (check-in: 384909e50f user: drh tags: trunk) | |
| 22:46 | Documenting the TCL interface (CVS 149) (check-in: 7e0bacedf9 user: drh tags: trunk) | |