Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins that include changes to files matching 'ext/*'
|
2024-05-18
| ||
| 15:21 | JS error message and doc typos reported in the forum. No code changes. (Leaf check-in: 1a073f9a user: stephan tags: trunk) | |
|
2024-05-17
| ||
| 14:26 | Merge branches "fix-onerow-opt", "faster-openread", "fts5-delay-tokenizer" and "enhanced-raise", each containing minor enhancements prepared for 3.46, into this branch. (Leaf check-in: 6dc64721 user: dan tags: pending-3.46) | |
|
2024-05-15
| ||
| 15:11 | If there is no data available for a field in a corrupted record, but the type is available, have the recovery extension substitute 0, 0.0, '' or X'' instead of a NULL value. (Leaf check-in: 78051359 user: dan tags: branch-3.45) | |
| 15:06 | If there is no data available for a field in a corrupted record, but the type is available, have the recovery extension substitute 0, 0.0, '' or X'' instead of a NULL value. (check-in: 8eb326c2 user: dan tags: trunk) | |
|
2024-05-14
| ||
| 19:41 | Optimize queries against fts5vocab(row) tables that do use the "cnt" column. (Closed-Leaf check-in: 96a591c2 user: dan tags: fts5-delay-tokenizer) | |
| 19:09 | Avoid calculating the value of the "cnt" column for fts5vocab(row) queries that do not use it. (check-in: c0c91e30 user: dan tags: fts5-delay-tokenizer) | |
| 17:16 | Have fts5 tables delay initializing the tokenizer until it is first used in all cases where the tokenizer is not "trigram". (check-in: ca4fdcb8 user: dan tags: fts5-delay-tokenizer) | |
|
2024-05-13
| ||
| 20:06 | Allow existing fts5 tables to be dropped even if the associated tokenizer is not available. (check-in: 69ef47ee user: dan tags: fts5-delay-tokenizer) | |
|
2024-05-09
| ||
| 18:54 | Reformulate a for-in loop to a for loop in wasm.xWrap() to work around downstream frameworks modifying the JS Array prototype, as reported in forum post b549992634b55104. (check-in: ce2eb6d8 user: stephan tags: branch-3.45) | |
| 18:39 | Add a maintenance-reminder comment explaining [dc58ed65492857]. (check-in: 857f5d7f user: stephan tags: trunk) | |
| 18:00 | Reformulate a for-in loop to a for loop in wasm.xWrap() to work around downstream frameworks modifying the JS Array prototype, as reported in forum post b549992634b55104. (check-in: dc58ed65 user: stephan tags: trunk) | |
| 17:45 | Fix a problem causing the recovery extension to use excessive memory and CPU time in some cases. (check-in: bc394acb user: dan tags: branch-3.45) | |
|
2024-05-08
| ||
| 11:51 | Fix a hyperlink typo in session documentation. (check-in: 42d67c6f user: drh tags: trunk) | |
|
2024-05-07
| ||
| 19:45 | Fix bug in test script sessionconflict.test. (check-in: e29decb8 user: dan tags: trunk) | |
|
2024-05-06
| ||
| 20:21 | When extracting links from sqlar archives, clobber any existing file or link, and do not call utimes() to set the timestamp - it looks through the link and operates on the target. (check-in: 2bf8c3f9 user: dan tags: trunk) | |
| 17:55 | Add new sessions API sqlite3changegroup_add_change(). (check-in: 5eaab43c user: dan tags: trunk) | |
| 17:32 | Edit comments in sqlite3session.h. (Closed-Leaf check-in: 49f84878 user: dan tags: changegroup-add-change) | |
| 17:21 | Add tests for sqlite3changegroup_add_change(). (check-in: 9d67bedc user: dan tags: changegroup-add-change) | |
| 11:27 | Fix problem in sqlar_uncompress() when being used to extract symbolic links. (check-in: 4d90c3f1 user: dan tags: trunk) | |
|
2024-05-04
| ||
| 21:10 | Add new sessions API sqlite3changegroup_add_change(). (check-in: 73647db1 user: dan tags: changegroup-add-change) | |
|
2024-05-02
| ||
| 17:46 | Fix a case where the recovery extension might write uninitialized data to the recovered database. (check-in: 8519b4d0 user: dan tags: trunk) | |
|
2024-05-01
| ||
| 16:25 | Fix another problem in the recovery extension where a corrupt sqlite_schema table could lead to excessive memory consumption. (check-in: 1c7e33a8 user: dan tags: trunk) | |
| 14:42 | Fix a problem causing the recovery extension to use excessive memory and CPU time in some cases. (check-in: 8de85170 user: dan tags: trunk) | |
|
2024-04-26
| ||
| 19:10 | Fix issues in LIMIT/OFFSET support for virtual tables. The first problem was reported by forum post c243b8f856. That report prompted an enhancement to the generate_series() (also included in this merge) which in turn identified other similar issues. (check-in: 5f6c079d user: drh tags: trunk) | |
| 18:42 | Internal JS doc touchups. No functional changes. (check-in: 626b997b user: stephan tags: trunk) | |
| 18:24 | Additional internal docs in the wasm utilities. (check-in: 5a2245a9 user: stephan tags: trunk) | |
| 17:09 | Further fixes and improvements to the generate_series() enhancements on this branch. (check-in: b7d9bd7e user: drh tags: vtab-limit-fix) | |
| 14:36 | Use hex flag masks rather than decimals in ext/misc/series.c. (check-in: a94e2cd0 user: drh tags: vtab-limit-fix) | |
| 13:30 | Enhance the generated_series() table-valued-function to respond to LIMIT and OFFSET. Use this to add new test cases for LIMIT and OFFSET on virtual tables in a compound SELECT. (check-in: 408d47ec user: drh tags: vtab-limit-fix) | |
|
2024-04-25
| ||
| 06:52 | wasm: add a makefile comment about the static sqlite3.h/c version info injected into the JS files possibly differing from the runtime-emited version info when a user provides their own sqlite3.c. (check-in: d99a01a0 user: stephan tags: trunk) | |
|
2024-04-24
| ||
| 06:43 | Remove an undocumented feature from the JS Worker1.open API because it relies on broken behavior which has no VFS-agnostic workaround. (check-in: 3a640038 user: stephan tags: trunk) | |
|
2024-04-23
| ||
| 06:49 | Remove some dead WASM-side code. (check-in: 0a07ee27 user: stephan tags: trunk) | |
| 06:36 | Minor touchups in JS docs and exception messages. (check-in: 9e7fc937 user: stephan tags: trunk) | |
| 05:38 | When running the 'dist' target in ext/wasm for an SEE-capable build, ensure that the resulting zip file and directory name include '-see'. (check-in: 04c552b1 user: stephan tags: trunk) | |
|
2024-04-22
| ||
| 20:09 | Add extra tests for aborting conflicts in the sessions module. (check-in: b4a6d326 user: dan tags: trunk) | |
| 17:03 | Minor cleanups to [8fbda563d2f5]. (check-in: 5ee2594b user: stephan tags: trunk) | |
| 16:46 | Extend the JS/WASM SEE build support by (A) filtering SEE-related bits out of the JS when not building with SEE and (B) accepting an optional key/textkey/hexkey option to the sqlite3.oo1.DB and subclass constructors to create/open SEE-encrypted databases with. Demonstrate SEE in the test app using the kvvfs. This obviates the changes made in [5c505ee8a7]. (check-in: 8fbda563 user: stephan tags: trunk) | |
| 11:48 | For sqlite3.oo1.DB JavaScript classes, bypass execution of any on-open() SQL in SEE-capable builds because it would necessarily run before the client has an opportunity to provide their decryption key, which would leave the db handle in an unusable state and cause the ctor to throw. This currently affects only the OPFS VFSes. We may want to consider extending the ctor options object to optionally accept an SEE key and apply it when opening the db. (check-in: 5c505ee8 user: stephan tags: trunk) | |
|
2024-04-17
| ||
| 19:48 | Prevent tokenize-blobs from being used with non-contentless tables. Fix some other issues with the new code on this branch. (Leaf check-in: 6a640ea4 user: dan tags: fts5-tokenize-blob) | |
|
2024-04-16
| ||
| 14:23 | Add some tests for the fts5 tokenize-blob functionality on this branch. (check-in: c2f9d125 user: dan tags: fts5-tokenize-blob) | |
|
2024-04-15
| ||
| 20:24 | Add experimental way to specify an alternative tokenizer when writing to or querying an fts5 table. (check-in: 6c51c9c6 user: dan tags: fts5-tokenize-blob) | |
| 14:59 | Merge version 3.45.3 patches into the reuse-schema-3.45 sub-branch. (Leaf check-in: a1ff4153 user: drh tags: reuse-schema-3.45) | |
| 14:45 | Merge all of the latest trunk enhancements into the bedrock branch. (Leaf check-in: 16dac180 user: drh tags: bedrock) | |
| 14:39 | Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: 4a72acbc user: drh tags: wal2) | |
| 14:36 | Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: eedf6bed user: drh tags: begin-concurrent) | |
| 14:29 | Merge from wrong branch. Bedrock should be updated from wal2, not from trunk. (Closed-Leaf check-in: 4c23cad9 user: drh tags: mistake) | |
| 14:21 | Merge all 3.45.3 changes into the wal2-3.45 branch. (Leaf check-in: 2ccc0185 user: drh tags: wal2-3.45) | |
| 14:18 | Merge all 3.45.3 changes into the begin-concurrent-3.45 subbranch. (Leaf check-in: 3dda82e0 user: drh tags: begin-concurrent-3.45) | |
|
2024-04-09
| ||
| 19:23 | Fix a "shift exponent is too large" usan error that could occur in the fts3 snippet() function when a query phrase contains more than 64 tokens. (check-in: 6d2c7ac4 user: dan tags: trunk) | |
| 15:18 | Avoid some performance problems in the recover extension when recovering strategically corrupted databases. (check-in: d83b0ffe user: dan tags: branch-3.45) | |
| 15:09 | Avoid some performance problems in the recover extension when recovering strategically corrupted databases. (check-in: e66a834b user: dan tags: trunk) | |
|
2024-04-08
| ||
| 12:02 | Merge the latest trunk enhancements, and especially the enhancement to the WHERE-clause push-down optimization, into the bedrock branch. (check-in: 0f93b52c user: drh tags: bedrock) | |
| 11:57 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 59ccea7d user: drh tags: wal2) | |
| 11:45 | Fix a harmless compiler warning in the ICU extension due to [acddbc489d5231da]. (check-in: 3d8750e8 user: drh tags: trunk) | |
|
2024-04-05
| ||
| 15:04 | Merge all recent trunk enhancements into the reuse-schema branch. (Leaf check-in: e556f3d3 user: drh tags: reuse-schema) | |
| 14:54 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 7a2a64b6 user: drh tags: bedrock) | |
| 14:50 | Merge the latest trunk enhancements into the wal2 branch. (check-in: a8a8a2db user: drh tags: wal2) | |
| 14:46 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 4ff83342 user: drh tags: begin-concurrent) | |
|
2024-04-04
| ||
| 22:53 | Optimize sqlite3.oo1.DB.exec() for the rowMode='object' case to avoid converting the object property keys (column names) from native code to JS for each row. This speeds up large data sets considerably and addresses the report in forum post 3632183d2470617d. (check-in: 8b41ef86 user: stephan tags: trunk) | |
| 12:37 | Fix exception propagation when the opfs-sahpool VFS fails to initialize to address report in forum post be0141c639. (check-in: db31d178 user: stephan tags: branch-3.45) | |
| 12:36 | Fix exception propagation when the opfs-sahpool VFS fails to initialize to address report in forum post be0141c639. (check-in: cdb3a900 user: stephan tags: trunk) | |
|
2024-04-02
| ||
| 21:55 | Add an optional 3rd argument to the icu_load_collation() function that specifies the "strength" of the comparison. (check-in: acddbc48 user: drh tags: trunk) | |
|
2024-03-27
| ||
| 20:34 | Update comments in fts5.h. (check-in: 862945d5 user: dan tags: trunk) | |
|
2024-03-26
| ||
| 10:48 | Merge all recent trunk enhancements into the reuse-schema branch. (check-in: e469b022 user: drh tags: reuse-schema) | |
| 10:45 | Merge all recent trunk enhancements into the bedrock branch. (check-in: 33d3453f user: drh tags: bedrock) | |
| 10:42 | Merge all recent trunk enhancements into the wal2 branch. (check-in: c2139d82 user: drh tags: wal2) | |
| 10:42 | Merge all recent trunk enhancements into the begin-concurrent branch. (check-in: 9b854e54 user: drh tags: begin-concurrent) | |
|
2024-03-25
| ||
| 10:55 | Improvements to the vtablog.c extension: Eliminate memory leaks. More diagnostic output for xBestIndex. (check-in: 92e9a71b user: drh tags: trunk) | |
| 00:38 | Improvements to the vtablog.c extension, for better logging of virtual table interactions. (check-in: e253bb36 user: drh tags: trunk) | |
|
2024-03-21
| ||
| 15:52 | Add comments (only, no code) to the JS sqlite3_config() bindings reminding us why SQLITE_CONFIG_ROWID_IN_VIEW is specifically not included. JNI does not need this treatment because it explicitly supports only a very small subset of config options. (check-in: 4fea3962 user: stephan tags: trunk) | |
|
2024-03-20
| ||
| 16:29 | Fix test cases for rtree and fts5. No changes to code. (check-in: 633dca90 user: drh tags: branch-3.44) | |
| 16:04 | Have rtree avoid keeping a blob handle open following an error. (check-in: 1303716a user: drh tags: branch-3.44) | |
| 15:26 | Following a ROLLBACK that reverts changes to an RTREE, any pending queries against that same RTREE abort with code SQLITE_ABORT_ROLLBACK. dbsqlfuzz de7d17b72d0e842352c998dd86a47b7d0f707be9. (check-in: b26e5a50 user: drh tags: branch-3.44) | |
| 12:19 | Back port various minor patches (check-in: a1a5c427 user: drh tags: branch-3.44) | |
| 11:25 | Fix a harmless compiler warning in the randomjson.c extension. (check-in: a4c93512 user: drh tags: branch-3.44) | |
|
2024-03-18
| ||
| 21:08 | Fix asan problems in sqlite3rbu.c. Enable RBU for sanitizer release tests. (check-in: ad2ae771 user: dan tags: trunk) | |
| 20:52 | Avoid spurious SQLITE_IOERR_DATA errors when reading partial pages from a cksumvfs database using a SQLITE_DIRECT_OVERFLOW_READ build. (check-in: 0f485dbe user: dan tags: trunk) | |
| 18:56 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: c2d4adab user: drh tags: reuse-schema) | |
| 18:55 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 10ab5e85 user: drh tags: bedrock) | |
| 18:51 | Merge the latest trunk enhancements into the wal2 branch. (check-in: c0af1242 user: drh tags: wal2) | |
| 18:47 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 50b43b02 user: drh tags: begin-concurrent) | |
|
2024-03-15
| ||
| 12:59 | Attempt to use the Dekker high-precision floating point algorithm in the ext/misc/totype.c extension. This check-in should have been derived from trunk, not the exp-values-clause2 branch. But that's ok, because both trunk and the branch are the same in all aspects that relate to this check-in and this check-in is just parking the proposed enhancement for future consideration - it is not a serious proposal at this point. (Leaf check-in: dd41db3b user: drh tags: totype-dekker) | |
|
2024-03-14
| ||
| 13:18 | JS: remove an unused function argument and some debug-related comments. No functional changes. (check-in: f1570943 user: stephan tags: trunk) | |
|
2024-03-13
| ||
| 18:00 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 5c8e80f4 user: drh tags: bedrock) | |
| 17:55 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 2b12da72 user: drh tags: wal2) | |
| 17:51 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 238fa84a user: drh tags: begin-concurrent) | |
| 15:59 | Merge the latest trunk enhancements into the reuse-schema branch. Fix the reuse-schema build of the CLI so that it works again. (check-in: 70ef3784 user: drh tags: reuse-schema) | |
| 15:47 | Merge trunk into this branch. (check-in: 38635651 user: dan tags: exp-values-clause2) | |
|
2024-03-11
| ||
| 23:28 | Merge the latest branch-3.45 patches into the reuse-schema-3.45 subbranch. (check-in: e22e0e1e user: drh tags: reuse-schema-3.45) | |
| 23:26 | Merge the latest branch-3.45 changes into the bedrock-3.45 subbranch. (check-in: 516b7e13 user: drh tags: bedrock-3.45) | |
| 23:23 | Merge the branch-3.45 patches into the wal2 branch. (check-in: f8cee91f user: drh tags: wal2-3.45) | |
| 23:18 | Merge the latest branch-3.45 changes into the begin-concurrent branch. (check-in: 98ea2ca2 user: drh tags: begin-concurrent-3.45) | |
| 19:33 | Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it. (check-in: 6eae4547 user: dan tags: trunk) | |
| 09:39 | Add more docs for the OPFS delete-before-open feature. (check-in: cb8d9c26 user: stephan tags: trunk) | |
| 09:34 | Add delete-before-open=1 URI flag to the 'opfs' VFS to tell it to xDelete the db file before opening it, primarily to enable users to work around a corrupt db without having to reach into OPFS-specific APIs to remove the db file. (check-in: e87cf0d7 user: stephan tags: trunk) | |
| 09:32 | Add delete-before-open=1 URI flag to the 'opfs' VFS to tell it to xDelete the db file before opening it, primarily to enable users to work around a corrupt db without having to reach into OPFS-specific APIs to remove the db file. (Closed-Leaf check-in: e83f9788 user: stephan tags: opfs-delete-before-open) | |
|
2024-03-09
| ||
| 18:41 | Fix the .expert command in the shell so that it does not leak memory if not followed by SQL and so that it works with reverse_unordered_selects. (check-in: 7ead022e user: drh tags: trunk) | |
| 13:10 | Fix the rtreeJ.test module to align it with [cd017c28d516399e]. (check-in: 111b3d82 user: drh tags: branch-3.45) | |
| 12:30 | Handle an OOM case in fts5 code to query tokendata=1 tables. (check-in: ebf59fa3 user: drh tags: branch-3.45) | |
|
2024-03-08
| ||
| 13:49 | Omit some extra tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. (check-in: 29d9eb7d user: dan tags: trunk) | |
| 11:08 | Do not run tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. (check-in: de8130c0 user: dan tags: trunk) | |
| 03:24 | Must use sqlite3IntFloatCompare() for accurate comparisons between very large integer and floating point values in RTREE. Otherwise the comparison does not work on all platforms. Further fix to [027e5336acc26f57]. (check-in: 820f106a user: drh tags: trunk) | |
|
2024-03-07
| ||
| 19:29 | Introducing JS worker1 promiser v2, which initializes via Promise (instead of a callback function) and can be loaded as an ESM module. (check-in: 2fbaf2f5 user: stephan tags: trunk) | |
| 18:53 | Resolve duplicate loading of promiser v2 demo code (a side effect of having done precisely what it was told to do). Consolidate demo-worker1-promiser(-esm).html/(m)js variants into central copies processed with c-pp. (Closed-Leaf check-in: 9347d9b9 user: stephan tags: wasm-promiser1-v2) | |
| 17:56 | wasm promiser.v2 is essentially working but the demo code is double-loading the module for as-yet-undetermined reasons. (check-in: aa877ce0 user: stephan tags: wasm-promiser1-v2) | |
| 16:25 | Merge all the latest trunk enhancements into the exp-values-clause branch. (check-in: c4923f26 user: drh tags: exp-values-clause) | |
| 16:04 | Initial work at getting sqlite3Worker1Promiser.v2() to return a Promise instead of using an onready() callback, and also creating an ESM build for promiser1 per user request. It seems to work but requires more testing. (check-in: 0e272123 user: stephan tags: wasm-promiser1-v2) | |
| 15:58 | Fix harmless compiler warnings in test code for the intck extension. (check-in: 7fbdc1a8 user: drh tags: trunk) | |
|
2024-03-06
| ||
| 21:08 | Fix harmless compiler warnings seen with MSVC. (check-in: c0f61524 user: mistachkin tags: branch-3.45) | |
| 20:54 | When doing a text-affinity comparison between two values where one or both have both a text and a numeric type, make sure the numeric type does not confuse the answer. This is a deeper fix to the problem observed by forum post 3776b48e71. The problem bisects to [25f2246be404f38b] on 2014-08-24, prior to version 3.8.7. (check-in: 6d385ccd user: mistachkin tags: branch-3.45) | |
| 20:49 | Add the json_pretty() SQL function. (check-in: ceb51c1c user: drh tags: trunk) | |
| 14:42 | Add a couple of json_pretty() examples to /fiddle. (check-in: d5e1687b user: stephan tags: json-pretty) | |
| 12:28 | Correction to the previous check-in. (check-in: 483fa296 user: drh tags: trunk) | |
| 11:35 | Fix handling of "id=?" corner cases in rtree when the value on the RHS is a real value. Problem reported by forum post 1bb055be17. (check-in: 027e5336 user: dan tags: trunk) | |
| 08:45 | Wasm build tweaks to attempt to get the node.js-for-node.js build to use Emscripten's nodefs filesystem driver for persistent storage. This is completely untested - validating it requires a nodeist. (Leaf check-in: 0bcbde7c user: stephan tags: wasm-nodefs) | |
|
2024-03-05
| ||
| 18:03 | Merge trunk changes into this branch. (check-in: a003fffa user: dan tags: exp-values-clause) | |
| 12:48 | /fiddle: reorder/replace example entries to make them more coherent when tried in order and clear the example selection list when the input area is cleared, both based on forum feedback. (check-in: b4ce270b user: stephan tags: trunk) | |
| 08:48 | /fiddle 'Mandlebrot' typo fix reported in the forum. (check-in: ceefe6ba user: stephan tags: trunk) | |
| 07:55 | Update fiddle.make to account for Makefile changes in [178b7d46f9]. (check-in: 7a5d8105 user: stephan tags: trunk) | |
| 06:31 | /fiddle: before resetting a db, roll back any transactions (resolves problem reported in forum post 0b41a25d65) and remove an obsolete/broken reference to a long-gone API which could cause initialization to fail prematurely. (check-in: ee164ca7 user: stephan tags: trunk) | |
|
2024-03-04
| ||
| 16:18 | Fix harmless compiler warnings in the increment integrity_check extension. (check-in: 596668e6 user: drh tags: trunk) | |
| 09:56 | Document why the wasm build does not use Emscripten's -sSTRICT=1 flag and account for a behaviour change in emsdk 3.1.55 regarding the HEAPxyz symbols. (check-in: f6e88720 user: stephan tags: trunk) | |
| 09:23 | When warning about multiple invocations of JS's sqlite3ApiBootstrap(), use the warning logger installed by the first invocation, rather than console.warn. (check-in: d162af2d user: stephan tags: trunk) | |
| 06:54 | After wasm bootstrapping has read the optional global-scope config objects, delete those objects because any further changes would not have any useful effect. Expand the docs regarding the sqlite3ApiBootstrap() config object and explain the necessary evil of a separate global-scope object for that configuration. (check-in: e6b14f73 user: stephan tags: trunk) | |
|
2024-03-01
| ||
| 19:08 | RTREE uses multi-DROP to erase shadow tables. (check-in: cf8a58d6 user: drh tags: multi-drop) | |
|
2024-02-27
| ||
| 00:58 | Bring the extra-src branch up to date with the trunk. (Closed-Leaf check-in: 12ff5c5c user: stephan tags: extra-src) | |
|
2024-02-26
| ||
| 12:16 | Add the intck extension. For performing incremental integrity-check on a database. (check-in: 141d8bb0 user: dan tags: trunk) | |
| 11:51 | Fix header comments on test scripts. (Closed-Leaf check-in: 9fe9670c user: drh tags: incr-integrity-check) | |
|
2024-02-24
| ||
| 16:26 | Add further tests for the intck module. (check-in: c253e276 user: dan tags: incr-integrity-check) | |
|
2024-02-23
| ||
| 20:51 | Add tests for the new code on this branch. (check-in: 351d46b2 user: dan tags: incr-integrity-check) | |
| 18:21 | Add the ".intck ?STEPS_PER_UNLOCK?" command to the shell tool. (check-in: cfd05183 user: dan tags: incr-integrity-check) | |
| 17:10 | Fix detection of surplus index entries when all indexed fields are NULL. (check-in: 5f310fb7 user: dan tags: incr-integrity-check) | |
| 15:13 | Fix problems with resuming integrity-check operations on indexes with mixed ASC and DESC columns, and on indexes that contain NULL values. (check-in: 0f68b35a user: dan tags: incr-integrity-check) | |
|
2024-02-21
| ||
| 20:58 | Fix various issues in sqlite3intck.c. (check-in: 8a7bfa74 user: dan tags: incr-integrity-check) | |
| 19:31 | Simplify the way the restart key is saved internally by the intck extension. (check-in: 0e39962b user: dan tags: incr-integrity-check) | |
| 19:17 | Add documentation to ext/intck/sqlite3intck.h. (check-in: 4cc19bd7 user: dan tags: incr-integrity-check) | |
| 16:12 | Merge trunk changes into this branch. (check-in: 63e8846a user: dan tags: incr-integrity-check) | |
|
2024-02-20
| ||
| 20:18 | Have the intck extension better handle corruption at the b-tree layer. (check-in: ecd775d1 user: dan tags: incr-integrity-check) | |
| 18:17 | Use fewer cycles to generate the "next key" value used by sqlite3_intck_suspend() function in the intck extension. (check-in: 95f01426 user: dan tags: incr-integrity-check) | |
| 16:04 | Consider using "=" and IS operators with even low-quality indexes in cases where they are selected explicitly using an INDEXED BY clause. (check-in: 43cbbea8 user: dan tags: incr-integrity-check) | |
| 12:48 | Enhancements to PRAGMA optimize and ANALYZE. Add the 0x10000 flag to PRAGMA optimize. ANALYZE now records zero-size partial indexes in the sqlite_stat1 table. PRAGMA optimize looks for both growth and shrinkage in table sizes, and uses tighter bounds (10x rather than 25x) to trigger a re-analyze. PRAGMA optimize automatically uses are reasonable analysis_limit to prevent excessive runtimes. (check-in: 63ef234e user: drh tags: trunk) | |
|
2024-02-19
| ||
| 20:15 | Use more efficient SQL to verify that indexes contain entries that match their tables. (check-in: c01e008c user: dan tags: incr-integrity-check) | |
| 18:03 | Add implementation of sqlite3_intck_suspend(). (check-in: c36ada86 user: dan tags: incr-integrity-check) | |
| 16:22 | If a table has one or more rows and it has a partial index has zero rows, still make an entry in the sqlite_stat1 table for the partial index, so that we know that "PRAGMA optimize" does not need to redo the whole table. (check-in: e147b189 user: drh tags: better-pragma-optimize) | |
|
2024-02-17
| ||
| 20:55 | Add start of extension for incremental integrity-checks to ext/intck/. (check-in: 444e3c92 user: dan tags: incr-integrity-check) | |
|
2024-02-16
| ||
| 11:41 | Handle an OOM case in fts5 code to query tokendata=1 tables. (check-in: 01222d96 user: dan tags: trunk) | |
|
2024-02-12
| ||
| 19:12 | Replace the assert() that was removed by [f023cb541b5dd72c] because [1cd5d4623f44af25] made it true again. (check-in: 189a49f1 user: drh tags: trunk) | |
| 17:01 | Have rtree avoid keeping a blob handle open following an error. (check-in: 26978f34 user: drh tags: branch-3.45) | |
| 16:12 | Have rtree avoid keeping a blob handle open following an error. (check-in: 1cd5d462 user: dan tags: trunk) | |
|
2024-02-11
| ||
| 23:25 | Cherrypick multiple fixes for trifling faults from trunk, so that all 834 dbsqlfuzz run clean with ASAN on branch-3.45. dbsqlfuzz. (check-in: c080560c user: drh tags: branch-3.45) | |
| 22:56 | In the RTREE extension, allow the xBeginTransaction() entry point to be invoked multiple times without intervening calls to xEndTransaction(). (check-in: f023cb54 user: drh tags: trunk) | |
|
2024-02-07
| ||
| 19:52 | Bring test cases into alignment with the latest enhancements. (check-in: cd017c28 user: drh tags: trunk) | |
| 19:09 | Checked into the wrong branch. (Closed-Leaf check-in: 81bd7aee user: drh tags: mistake) | |
|
2024-02-06
| ||
| 13:36 | Return SQLITE_ABORT if the underlying shadow tables change in the middle of an rtree query in such a way as to invalidate an rtree internal priority queue entry. This replaces the SQLITE_ABORT_ROLLBACK mechanism added in [97cffff331b]. (check-in: 061af0d7 user: drh tags: branch-3.45) | |
| 08:59 | Correct docs about the first OFPS VFS's importDb() method being synchronous (it's not, whereas the second VFS's importDb() is). (check-in: ae7505fa user: stephan tags: trunk) | |
| 08:25 | Make explicit that using the importDb() methods of the OPFS VFSes has undefined results if the being-imported db is currently open. Doc changes only. (check-in: f28b9924 user: stephan tags: trunk) | |
|
2024-02-05
| ||
| 17:54 | Return SQLITE_ABORT if the underlying shadow tables change in the middle of an rtree query in such a way as to invalidate an rtree internal priority queue entry. This replaces the SQLITE_ABORT_ROLLBACK mechanism added in [af5c4251]. (check-in: 32f85a5c user: dan tags: trunk) | |
| 17:35 | Return SQLITE_ABORT if the underlying shadow tables change in the middle of an rtree query in such a way as to invalidate an rtree internal priority queue entry. (Closed-Leaf check-in: 478280ef user: dan tags: rtree-fix) | |
| 03:56 | Extend [d294a23ed6d] to apply to all wasm speedtest1 builds. (check-in: 26f848e5 user: stephan tags: trunk) | |
| 03:37 | wasm: pass the promiser function to the promiser onready() callback to simplify access to it in certain usage patterns. (check-in: f8a8b9ee user: stephan tags: trunk) | |
| 02:36 | wasm: squelch a new (and, in our case, invalid) warning from emcc 3.1.52. (check-in: d294a23e user: stephan tags: trunk) | |
|
2024-02-04
| ||
| 04:01 | Fix harmless compiler warnings seen with MSVC. (check-in: e52c8742 user: mistachkin tags: trunk) | |
|
2024-02-03
| ||
| 19:41 | Following a ROLLBACK that reverts changes to an RTREE, any pending queries against that same RTREE abort with code SQLITE_ABORT_ROLLBACK. (check-in: 97cffff3 user: drh tags: branch-3.45) | |
| 19:19 | Following a ROLLBACK that reverts changes to an RTREE, any pending queries against that same RTREE abort with code SQLITE_ABORT_ROLLBACK. dbsqlfuzz de7d17b72d0e842352c998dd86a47b7d0f707be9. (check-in: af5c4251 user: drh tags: trunk) | |
|
2024-02-01
| ||
| 15:42 | Ensure the fts5 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: d18d9a05 user: dan tags: trunk) | |
| 15:21 | Ensure the fts3 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: 1bdb8cba user: dan tags: trunk) | |
|
2024-01-30
| ||
| 17:02 | Merge the 3.45.1 patches into the reuse-schema branch. (check-in: f98a99fc user: drh tags: reuse-schema-3.45) | |
| 16:56 | Merge the 3.45.1 patch release changes into the bedrock branch. (check-in: 5955853a user: drh tags: bedrock-3.45) | |
| 16:53 | Merge the changes from the 3.45.1 patch release into the wal2 branch. (check-in: 5e980265 user: drh tags: wal2-3.45) | |
| 16:50 | Merge the 3.45.1 patch release into the begin-concurrent branch. (check-in: d1f20a47 user: drh tags: begin-concurrent-3.45) | |
|
2024-01-24
| ||
| 19:54 | Update ext/wasm/SQLTester for recent internal-API reorgs. (check-in: 996cfdf9 user: stephan tags: trunk) | |
|
2024-01-23
| ||
| 15:04 | Fix harmless "unused parameter" compiler warning in the new fts3IntegrityMethod implementation. (check-in: 9d459f6b user: drh tags: branch-3.45) | |
| 10:47 | Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. (check-in: e79b9736 user: dan tags: branch-3.45) | |
|
2024-01-22
| ||
| 12:56 | Fix userauth so that it works together with SQLITE_OMIT_SHARED_CACHE. (Forum post 0bfc5888a384d430). However, also change to code to issue a deprecation warning whenever SQLITE_USER_AUTHENTICATION is used. (check-in: 249048b0 user: drh tags: trunk) | |
| 12:30 | Add a notice to the user-authentication documentation to say that the extension is deprecated and may disappear in the future. (check-in: fe6fc7b9 user: drh tags: trunk) | |
|
2024-01-20
| ||
| 15:13 | When doing a text-affinity comparison between two values where one or both have both a text and a numeric type, make sure the numeric type does not confuse the answer. This is a deeper fix to the problem observed by forum pose 3776b48e71. The problem bisects to [25f2246be404f38b] on 2014-08-24, prior to version 3.8.7. (check-in: 709841f8 user: drh tags: trunk) | |
|
2024-01-16
| ||
| 16:14 | Fix harmless "unused parameter" compiler warning in the new fts3IntegrityMethod implementation. (check-in: bb1fe53a user: drh tags: trunk) | |
| 16:05 | Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. (check-in: b855886c user: dan tags: trunk) | |
| 14:54 | Remove the LLONG_MAX preprocessor macro from the series.c extension as it is apparently only C99 and later. Forum post 4af649419b. (check-in: f106bc0d user: drh tags: trunk) | |
| 14:28 | wasm build: reformulate an awk invocation to account for awks which do not support the -e flag. Problem reported on the forum via a docker-hosted build. (check-in: 90dd5115 user: stephan tags: branch-3.45) | |
| 14:24 | Various build- and code-reorg cleanups for ext/wasm. No functional changes. (check-in: 835bd4a1 user: stephan tags: trunk) | |
|
2024-01-13
| ||
| 20:38 | Merge latest trunk changes into this branch. (check-in: bb9a7157 user: dan tags: reuse-schema) | |
| 20:36 | Merge latest wal2 changes into this branch. (check-in: c39f6585 user: dan tags: bedrock) | |
| 20:21 | Merge latest trunk changes into this branch. (check-in: 68c2b8d0 user: dan tags: wal2) | |
| 19:57 | Merge latest trunk changes into this branch. (check-in: 95bf4bc2 user: dan tags: begin-concurrent) | |
|
2024-01-12
| ||
| 16:33 | Fix a usan complaint about signed integer overflow. (Leaf check-in: 16aa7297 user: drh tags: branch-3.43) | |
| 15:38 | Fix a signed integer overflow usan complaint in fts5. This is fixed on trunk by [a76a636b23], but that is a large commit that adds new features. (check-in: 4b2d02f2 user: dan tags: branch-3.43) | |
|
2024-01-11
| ||
| 16:10 | wasm build: reformulate an awk invocation to account for awks which do not support the -e flag. Problem reported on the forum via a docker-hosted build. (Closed-Leaf check-in: 58366579 user: stephan tags: wasm-post-3.45) | |
| 14:21 | Internal JS doc cleanups. (check-in: c8284170 user: stephan tags: wasm-post-3.45) | |
| 14:13 | Fix a comment in sessions. No functional changes. Forum post 8c20dc935b. (check-in: b0eb6d36 user: drh tags: trunk) | |
| 14:03 | In fts5, flush the contents of the in-memory hash table whenever the secure-delete option is toggled. This prevents spurious corruption reports under some circumstances. (check-in: ccf55231 user: dan tags: trunk) | |
| 12:56 | Remove some dead JS code. Minor doc cleanups. (check-in: bf23cf20 user: stephan tags: wasm-post-3.45) | |
| 12:31 | Split the JS vfs/vtab helper code into discreet units as a step towards a build which optionally elides those pieces. This is an internal restructuring change and does not affect the API. (check-in: ede945fd user: stephan tags: wasm-post-3.45) | |
|
2024-01-10
| ||
| 20:13 | Fix a few compiler gripes. Update 2024-04-16: Closed, since the solution to Windows console I/O already on trunk is better. (Closed-Leaf check-in: 2e74a938 user: larrybr tags: win-dupe-crt-fio) | |
| 05:52 | For CLI shell and other utilities, optionally avoid C runtime file I/O on Windows in favor of WIN32 calls, while nominally preserving FILE* API interfaces. (a WIP, awaiting build and testing) (check-in: 6be68be1 user: larrybr tags: win-dupe-crt-fio) | |
|
2024-01-08
| ||
| 07:52 | Make explicit which JS APIs are for internal use only by moving the JS-bound internal-use-only functions out of client-visible reach and renaming the WASM-exported ones from sqlite3_wasm... to sqlite3__wasm... (with two underscores). These have always been documented as internal-use-only, so this is not a breaking change except for clients which have ignored the docs. (check-in: 0eddc20f user: stephan tags: wasm-post-3.45) | |
|
2024-01-07
| ||
| 20:27 | Remove an ALWAYS() from RTREE. Dbsqlfuzz found a way to make it false. (check-in: 40f0a29e user: drh tags: trunk) | |
| 00:45 | Updates to RTREE to facility testing. (check-in: 7a5b42ff user: drh tags: trunk) | |
|
2024-01-06
| ||
| 13:58 | Update extension ext/misc/totext.c to avoid both ubsan warnings and dubious real->integer conversions. (check-in: 54143600 user: dan tags: trunk) | |
|
2024-01-05
| ||
| 15:53 | Update extension ext/misc/totext.c to avoid both ubsan warnings and dubious real->integer conversions. (Closed-Leaf check-in: c626aa10 user: dan tags: totype-fix) | |