This Day In History For 2025-10-02
1 Year Ago (more context)
|
2024-10-02
| ||
| 18:54 | Modify the behavior of sqlite_dbpage so that the null-INSERT that truncates a database must be the very last INSERT operation within a transaction in order to be effective. This simplifies the code and also makes the behavior easier to document and understand. (check-in: b869a7d9ce user: drh tags: trunk) | |
| 17:43 | Fix a typo in fts5delete.test. (check-in: b1f001435e user: dan tags: trunk) | |
| 17:04 | Add the contentless_unindexed=1 option to fts5. This causes the values of any UNINDEXED columns of a contentless fts5 table to be stored persistently in the database. (check-in: 58313ac59e user: dan tags: trunk) | |
| 16:55 | Adjust the new truncation behavior of sqlite_dbpage(N,null) such that it causes the database to be truncated to N-1 pages. This makes more since. An error is raised if N is less than 2. (check-in: 7d5ff86ef7 user: drh tags: trunk) | |
| 13:26 | Remove all use of the "long double" data type from SQLite, as hardware support for long double is increasingly rare and the use of long double creates challenges for some compilers. (check-in: 761d8fd18b user: drh tags: trunk) | |
| 11:34 | Remove a few more traces of long double from the code. (Closed-Leaf check-in: 11d6a89e4a user: drh tags: omit-long-double) | |
| 11:15 | Ensure that if sqlite3_snapshot_get() is called immediately after a "BEGIN", then it locks the database such that the returned snapshot object may not be invalidated by a writer or checkpointer until after the sqlite3_snapshot_get() caller has closed its transaction. (check-in: eb5277e490 user: dan tags: trunk) | |
| 11:11 | Merge latest trunk changes into this branch. (Closed-Leaf check-in: 2b3945e6a5 user: dan tags: snapshot_get-locking) | |
| 11:11 | Update docs for sqlite3_snapshot_get(). (check-in: 78c3892ab7 user: dan tags: snapshot_get-locking) | |
2 Years Ago (more context)
|
2023-10-02
| ||
| 23:56 | New test cases for JSONB. (check-in: 6d4aeff575 user: drh tags: jsonb) | |
| 20:16 | Fix jsonb_insert() so that it does not behave like jsonb_set(). New test cases added. (check-in: 54197149b8 user: drh tags: jsonb) | |
| 17:12 | JNI: when fetching text-or-blob/length pairs, fetch the text-or-blob first, then the length, as the API docs suggest. (check-in: e4f9d3946f user: stephan tags: trunk) | |
| 17:06 | Fix the length of the string in the new concat() and concat_ws() functions. (check-in: 3252432265 user: drh tags: trunk) | |
| 15:56 | Remove an ALWAYS() from a branch that can in fact be false following an OOM fault. (check-in: 3a1feb1c46 user: drh tags: trunk) | |
| 15:37 | Revisit the opfs-sahpool's handling of sqlite3_vfs::xGetLastError(). This impl seems to be in line with what the library internal expects but it requires more testing (via purposely-induced I/O errors) before merging. (check-in: c53fd21f68 user: stephan tags: wasm-xGetLastError) | |
| 14:51 | New test cases for JSONB. (check-in: d624c31e5c user: drh tags: jsonb) | |
| 14:44 | Pointer-casting-related fixes for JNI on 32-bit ARM (pi4 armv7l). (check-in: 54441039ae user: stephan tags: trunk) | |
| 13:35 | Allow json_replace() to accept JSONB arguments as the new value. (check-in: 95eb7b37fa user: drh tags: jsonb) | |
| 13:20 | Improvements to error handling for BLOB inputs on JSON. (check-in: 14f20ecbfa user: drh tags: jsonb) | |
| 12:40 | Gather forward references into a single place for the JSON code. Allow JSONB arguments to json_array() and json_object() and similar. (check-in: c352201b8c user: drh tags: jsonb) | |
3 Years Ago (more context)
|
2022-10-02
| ||
| 22:50 | More cleanups in the UDF argument and result handling, in particular int64. Consolidate some duplicate int64/bigint range checking code. Expose the UDF low-level utilities (arg/result conversion) to client code. Add the sqlite3_context pointer to the JS-side UDF wrappers for API consistency. (check-in: 10ab77af95 user: stephan tags: fiddle-opfs) | |
| 20:13 | Minor doc typo fix in sqlite.h.in. (check-in: 372802aaa2 user: stephan tags: trunk) | |
| 20:08 | JS: clean up create_function() wrapper and add support for create_window_function(). Eliminate an extraneous blob copy when a UDF returns a blob. Make use of newfound JS-fu to clean up how sqlite3ApiBootstrap() config is initialized. (check-in: d3bad9347c user: stephan tags: fiddle-opfs) | |
| 18:47 | js: implement a hand-written wrapper for sqlite3_create_function_v2() which converts, if necessary, JS-function-type args to WASM function wrappers. Replace DB.createFunction() impl with the new one. (check-in: 435ab33384 user: stephan tags: fiddle-opfs) | |
| 03:14 | Doc typo fixes. (check-in: e528675da3 user: stephan tags: fiddle-opfs) | |
| 03:11 | More fleshing out of sqlite3.capi.wasm.pstack. (check-in: eb5726677a user: stephan tags: fiddle-opfs) | |
| 01:48 | Document the roles of the new (this past week) JS files added to the build process. (check-in: 8b3bc7313a user: stephan tags: fiddle-opfs) | |
| 00:09 | General internal cleanups in the oo1 API. (check-in: f9db664f75 user: stephan tags: fiddle-opfs) | |
4 Years Ago (more context)
|
2021-10-02
| ||
| 18:22 | Try to fix a harmless static-analyzer warning in sqlite3BtreeTransferRow(). (check-in: 5906a0152d user: drh tags: trunk) | |
| 17:46 | Fix a harmless static-analyzer warning in sqlite3ExprCode(). (check-in: 918c22e82a user: drh tags: trunk) | |
| 17:34 | Remove an unnecessary static buffer from sqlite3VdbeExpandSql(). (check-in: 953a33b7f7 user: drh tags: trunk) | |
| 17:12 | Make the sqlite3_filename_xxxx() interfaces robust against NULL pointer arguments, even though the documentation says the behavior is undefined in that case. (check-in: dd64c60bab user: drh tags: trunk) | |
| 16:39 | Fix harmless compiler warnings (check-in: bdb9dc8a02 user: drh tags: trunk) | |
| 15:34 | Fix CLI line processing. (back to start state after meta-command executes) (check-in: 928c2a3498 user: larrybr tags: trunk) | |
5 Years Ago (more context)
|
2020-10-02
| ||
| 21:16 | • New ticket [95302bdb08] WHERE clause that uses a NUMERIC cast influences the result type. (artifact: bd7d181bc4 user: mrigger) | |
| 20:44 | • New ticket [2ba5930b27] Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer. (artifact: 851e0fc355 user: mrigger) | |
| 20:19 | • Closed ticket [0f586dbeb3]: FTS4 integrity-check fails for UTF16 encoding plus 4 other changes (artifact: 845723a5e7 user: dan) | |
| 20:17 | • Ticket [0f586dbeb3]: 6 changes (artifact: 6c7bdf81d4 user: dan) | |
| 20:04 | • New ticket [0f586dbeb3]. (artifact: 7cccafc763 user: mrigger) | |
| 15:15 | Fix some test code so that testfixture can build with SQLITE_OMIT_WAL defined. (check-in: dd009cd7ae user: dan tags: trunk) | |
| 13:57 | Import further corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization from trunk. (check-in: c144d6404f user: drh tags: branch-3.28) | |
| 13:48 | Additional corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization. (check-in: ad5ab24ebd user: drh tags: trunk) | |
| 12:49 | Remove an incorrect assert() from the OP_SeekScan opcode. (check-in: c0400f8c0b user: drh tags: trunk) | |
| 12:42 | Fix a faulty assert() statement. Add new test cases. (check-in: 80ecdb3da4 user: drh tags: trunk) | |
| 12:11 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: ec37744c6e user: drh tags: branch-3.28) | |
| 11:55 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: 091d719394 user: drh tags: trunk) | |
| 02:07 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: 9a1cdf7e9c user: drh tags: branch-3.28) | |
| 02:02 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: c75c3a3b75 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2015-10-02
| ||
| 20:04 | Update fts5 to avoid using a statement journal for UPDATE and DELETE operations that affect at most a single row. (check-in: 5c83b9db46 user: dan tags: trunk) | |
15 Years Ago (more context)
|
2010-10-02
| ||
| 01:03 | • Edit [220cca50da08c516|220cca50da]: Move to branch apple-osx-3623. Edit check-in comment. Timestamp 2010-08-17 23:13:42. (artifact: f6bb96ec6a user: drh) | |
| 01:01 | Backport the very lastest R-Tree in order to take advantage of its enhanced robustness to corrupt databases. (Leaf check-in: 29a681dd7b user: drh tags: apple-osx-3623) | |
| 01:00 | Fix the amalgamation builder so that it works with the rtree updates of the prior check-in. (Leaf check-in: 265b0b29b8 user: drh tags: branch-3.6.23) | |