/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent check-ins

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. Leaf check-in: 3a640038c7 user: stephan tags: trunk
2024-04-23
12:02
Fix a problem with vector IN operators used with an index where the affinities and collations for the various vector terms are different. check-in: 86e8c782e7 user: drh tags: trunk
11:56
Fix an uninitialized variable problem in the new code on this branch. Closed-Leaf check-in: 85625b3871 user: dan tags: vector-in-fix
06:49
Remove some dead WASM-side code. check-in: 0a07ee27bd user: stephan tags: trunk
06:36
Minor touchups in JS docs and exception messages. check-in: 9e7fc9370d 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: 04c552b12e user: stephan tags: trunk
2024-04-22
20:09
Add extra tests for aborting conflicts in the sessions module. check-in: b4a6d32662 user: dan tags: trunk
17:03
Minor cleanups to [8fbda563d2f5]. check-in: 5ee2594b65 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: 8fbda563d2 user: stephan tags: trunk
13:31
Extra robustness in the code that causes cursors to return NULL when they are participating in an OUTER JOIN. check-in: 672c2869ef user: drh 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: 5c505ee8a7 user: stephan tags: trunk
00:42
Continuation of the fix at [8c0f69e0e4ae0a44]: If a viaCoroutine FROM clause term is participating in a RIGHT or FULL JOIN, we have to create an always-NULL pseudo-cursor for that term when processing the RIGHT join. dbsqlfuzz 6fd1ff3a64bef4a6c092e8d757548e95698b0df5. check-in: e1040e51eb user: drh tags: trunk
2024-04-21
23:35
Fix an indentation problem in debugging routine sqlite3ShowSrcList(). No changes to production code. check-in: 5560df2726 user: drh tags: trunk
2024-04-20
19:19
Slight performance improvement for the new code on this branch. check-in: 500c67f134 user: dan tags: vector-in-fix
15:14
Fix a problem where an expression like (a, b) IN (SELECT ...) might not use an index on (a, b) if the affinities and collation sequences of "a" and "b" are not identical. check-in: 4d870fd8b5 user: dan tags: vector-in-fix
2024-04-18
16:11
Correct handling of OUTER JOIN when on or the other operand is a subquery implemented using the VALUES-as-coroutine optimization. dbsqlfuzz bde3bf80aedf25afa56e2997a0545a314765d3f8. check-in: 8c0f69e0e4 user: drh 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: 6a640ea4d8 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: c2f9d1259c user: dan tags: fts5-tokenize-blob
2024-04-15
20:43
The first assert() added in [0ebc65481f4a3e79] is not necessarily true in a corrupt database file. So add a term to make it true. check-in: 6b21cccdee user: drh tags: trunk
20:24
Add experimental way to specify an alternative tokenizer when writing to or querying an fts5 table. check-in: 6c51c9c6a8 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: a1ff415341 user: drh tags: reuse-schema-3.45
14:45
Merge all of the latest trunk enhancements into the bedrock branch. Leaf check-in: 16dac180b5 user: drh tags: bedrock
14:39
Merge the latest trunk enhancements into the wal2 branch. Leaf check-in: 4a72acbc4b user: drh tags: wal2
14:36
Merge the latest trunk enhancements into the begin-concurrent branch. Leaf check-in: eedf6bed2a user: drh tags: begin-concurrent
14:29
Merge from wrong branch. Bedrock should be updated from wal2, not from trunk. Closed-Leaf check-in: 4c23cad98d user: drh tags: mistake
14:21
Merge all 3.45.3 changes into the wal2-3.45 branch. Leaf check-in: 2ccc018546 user: drh tags: wal2-3.45
14:18
Merge all 3.45.3 changes into the begin-concurrent-3.45 subbranch. Leaf check-in: 3dda82e001 user: drh tags: begin-concurrent-3.45
13:34
Version 3.45.3 Leaf check-in: 8653b75887 user: drh tags: release, branch-3.45, version-3.45.3
2024-04-12
18:46
If a build fails in testrunner.tcl, do not attempt to run the jobs that depend on that build. Instead, report those jobs as having been skipped. check-in: b40580be71 user: drh tags: trunk
16:52
Adjustment to EQP output in one test case. check-in: 08dd2b927b user: drh tags: branch-3.45
15:15
Mark the BTree cell overflow cache as invalid whenever the rowid goes invalid. Leaf check-in: 0ec6669c84 user: drh tags: branch-3.44
15:10
Increase the version number to 3.45.3. check-in: 119b3b3c9c user: drh tags: branch-3.45
15:06
Mark the BTree cell overflow cache as invalid whenever the rowid goes invalid. check-in: 5266bb6dc9 user: drh tags: branch-3.45
15:02
Fixes and new tests logic to ensure that the btree overflow page cache is only used when it is consistent. This resolves the malfunction observed in [forum:/forumpost/284955a3cd454a15|forum post 284955a3cd454a15]. check-in: 5dede50d9e user: drh tags: trunk
13:05
Add assert() statements to help verify the overflow page cache. Closed-Leaf check-in: 0ebc65481f user: drh tags: btree-ovfl-cache
12:32
New assert() statements to verify the correctness of the BTCF_AtLast flag on btree cursors. check-in: 4efecd6167 user: drh tags: btree-ovfl-cache
11:28
Test case for the fix in the previous check-in. check-in: 0cf4d835da user: drh tags: btree-ovfl-cache
02:57
Mark the BTree cell overflow cache as invalid whenever the rowid goes invalid. check-in: 74c9e19c92 user: drh tags: btree-ovfl-cache
2024-04-11
19:09
Fix handling of the SQLITE_OMIT_WAL check in one place. Resolves [forum:87cc13302de160eb|forum post 87cc13302de160eb]. check-in: ce86d30d91 user: stephan tags: branch-3.45
19:08
Fix handling of the SQLITE_OMIT_WAL check in one place. Resolves [forum:87cc13302de160eb|forum post 87cc13302de160eb]. check-in: 5dae6e6df4 user: stephan tags: trunk
2024-04-10
16:36
Fix the pragma4.test script so that it works with SQLITE_OMIT_VIRTUALTABLE. check-in: 61060c7d0d user: dan tags: branch-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: 6d2c7ac4ec user: dan tags: trunk
15:18
Avoid some performance problems in the recover extension when recovering strategically corrupted databases. check-in: d83b0ffe8b user: dan tags: branch-3.45
15:09
Avoid some performance problems in the recover extension when recovering strategically corrupted databases. check-in: e66a834bba user: dan tags: trunk
14:08
Ignore CHECK constraints when qualifying the xfer optimization while running VACUUM. check-in: 944d1b6eb3 user: drh tags: branch-3.44
14:07
Ignore CHECK constraints when qualifying the xfer optimization while running VACUUM. check-in: bb6f990809 user: drh tags: branch-3.45
13:57
The read-only CHECK-constraint optimization of [34ddf02d3d21151b] inhibits the xfer optimization for tables with CHECK constraints. However, the xfer optimization is required for correct operation of VACUUM INTO on tables that contain generated columns. Fix this by ignoring CHECK constraints when qualifying the xfer optimization while running VACUUM. Problem reported by [forum:/forumpost/3ec177d68fe7fa2c|forum post 3ec177d68fe7fa2c]. check-in: a6e26e7788 user: drh tags: trunk
2024-04-08
17:55
Update tests in returning1.test to account for [c7896e88]. check-in: c02956cd5c user: dan tags: trunk
12:02
Merge the latest trunk enhancements, and especially the enhancement to the WHERE-clause push-down optimization, into the bedrock branch. check-in: 0f93b52c77 user: drh tags: bedrock
11:57
Merge the latest trunk enhancements into the wal2 branch. check-in: 59ccea7db7 user: drh tags: wal2