SQLite

Timeline
Login

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

50 most recent check-ins

2025-06-17
20:50
tea: remove the vsatisfies 8.6- enforcement from the extension because at least one platform with tcl 8.6 is inexplicably failing it. [forum:fde857fb8101a4be | Forum post fde857fb8101a4be] (Leaf check-in: 7331e32a76 user: stephan tags: trunk)
19:32
Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Also fix a corner case in the previous check-in on this branch. (Leaf check-in: c232fa2bfc user: drh tags: branch-3.50)
19:10
Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. (check-in: 5973f9b9aa user: drh tags: trunk)
18:57
Fix a corner-case for [9441fff52cc4e19c]. (check-in: 336a59eb3a user: drh tags: trunk)
18:17
Update walcksum.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (Closed-Leaf check-in: 0da16f6c62 user: dan tags: forum-b490f726db-fix)
17:15
Extend [b5c6cb13cff5] to use a wildcard on darwin* because some OSes report a version number in the suffix. [forum:0c4bbc2962dfb06e | Forum post 0c4bbc2962dfb06e]. (check-in: d960bd6f92 user: stephan tags: trunk)
14:56
Minor proj.tcl portability fixes and cleanups suggested in [forum:7b218c3c9f|forum post 7b218c3c9f]. Tested on Linux, Msys, Cygwin, and Haiku. (check-in: b5c6cb13cf user: stephan tags: trunk)
14:37
proj.tcl portability fixes and cleanups suggested in [forum:7b218c3c9f|forum post 7b218c3c9f]. Branching so that it can be tested on msys/cygwin/haiku before committing to it. (Closed-Leaf check-in: 89552e9137 user: stephan tags: linux-named-apple)
11:36
Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Possible fix for [forum:/forumpost/b490f726db | forum post b490f726db]. (check-in: 3a3269fe8e user: dan tags: forum-b490f726db-fix)
2025-06-16
18:04
Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. (check-in: 6c5f4c8af9 user: drh tags: branch-3.50)
17:36
Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. Problem reported by [forum:/forumpost/68f29a2005|forum post 68f29a2005]. (check-in: 9441fff52c user: drh tags: trunk)
16:07
Improved debugging output for the transitive constraint optimization. (check-in: 94b53c20e9 user: drh tags: trunk)
15:34
Make the show-%p-az-zero hack of the previous check-in configurable at run-time using the 0x100000 bit of either .treetrace or .wheretrace. As before, this is all a no-op except for debugging builds. (check-in: a29627d7e7 user: drh tags: trunk)
13:51
Add an "#if 0" that can be changed to "1" to cause all %p output to render as 0, thus making comparisons of .treetrace and .wheretrace output easier. (check-in: 65e2704c0b user: drh tags: trunk)
2025-06-14
18:02
Generalize the indexCellCompare() so that works on any index page, not just the current page that a cursor is pointing to. (Leaf check-in: eda518028f user: drh tags: flex-search)
14:46
Fix issues with expression indexes for flex-search queries. (check-in: 711608e49b user: drh tags: flex-search)
13:18
Add the ability to disable the Flex-Search optimization using SQLITE_TESTCTRL_OPTIMIZATION. (check-in: 5319a55ab2 user: drh tags: flex-search)
09:54
Generates code to implement either an index search or a table scan, according to the results of the OP_IfUseIndex opcode. But does not always work. And the OP_IfUseIndex opcode is currently an unconditional "yes". (check-in: 9872df2b85 user: drh tags: flex-search)
2025-06-13
11:08
Further improvements to the EQP text for flex-search. (check-in: 40a83da503 user: drh tags: flex-search)
00:50
Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: 680e278c3e user: drh tags: flex-search)
00:25
Fix test cases on the expert extension. (check-in: c46feb36b5 user: drh tags: flex-search)
2025-06-12
19:02
Preliminary code generation for flex-search. Add a no-op IfUseIndex opcode as a placeholder. (check-in: 521948c64f user: drh tags: flex-search)
13:40
Merge latest trunk enhancements and fixes into the experimental flex-search branch. (check-in: 51c89c886f user: drh tags: flex-search)
13:27
Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (check-in: 954efdd30d user: drh tags: branch-3.50)
10:56
Help ext/wasm 'make snapshot' find the wasm docs dir when it's run from outside of my usual checkout structure. (check-in: 0e04136bc5 user: stephan tags: branch-3.50)
07:35
Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (check-in: a95d126e13 user: dan tags: trunk)
2025-06-11
17:24
Fix a problem with UPDATEs on fts5 tables that contain blob values. (check-in: 2b4577d83c user: drh tags: branch-3.50)
15:03
Fix a problem with UPDATEs on fts5 tables that contain blob values. (check-in: badf3014bd user: dan tags: trunk)
00:06
Increase the version number for this branch to 3.50.2. (check-in: e9652e398e user: drh tags: branch-3.50)
00:05
Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. (check-in: e0ce6dab46 user: drh tags: branch-3.50)
00:01
Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. [forum:/forumpost/52503ac21d|Forum post 52503ac21d]. (check-in: 80a78987da user: drh tags: trunk)
2025-06-10
20:06
Improved selection of the divisor when subdividing nested Bitvec objects. This fixes a potential stack overflow that can occur when the database size is within 60 pages of the maximum allowed by the file format. (check-in: 5d40152bfe user: drh tags: branch-3.50)
19:52
Improved selection of the divisor when subdividing nested Bitvec objects. This fixes a potential stack overflow that can occur when the database size is within 60 pages of the maximum allowed by the file format. (check-in: f7ab764ed9 user: drh tags: trunk)
18:26
Minor corrections to the new Bitvec testing logic. (check-in: 77b79ca127 user: drh tags: trunk)
17:22
Enhancements to sqlite3BitvecBuiltinTest() that allow testing code to create very large Bitvec objects that do not use the linear array cross-check. (check-in: c5680672ca user: drh tags: trunk)
16:56
Adjustments to ext/misc/fileio.c in an attempt to get it to build using mingw. (check-in: ac786b92e3 user: drh tags: branch-3.50)
16:02
Improved diagnostics for Bitvec: Add the sqlite3ShowBitvec() routine that can be called from a debugger (only available with SQLITE_DEBUG). Add new output opcodes for sqlite3BitvecBuiltinTest(). (check-in: dea1e37fa6 user: drh tags: trunk)
2025-06-09
22:38
Adjustments to ext/misc/fileio.c in an attempt to get it to build using mingw. (check-in: 96b14a3f11 user: drh tags: trunk)
16:32
Initial implementation of sqlite3BtreeEstimatedPosition() with the est_rank() SQL function used for testing. (check-in: e93048425b user: drh tags: flex-search)
2025-06-07
16:45
Query planner identifies loops where it might be advantageous to check the number of matching rows and fall back to a full table scan if the number of matching rows is large. (check-in: 87fd199257 user: drh tags: flex-search)
2025-06-06
23:10
Remove unnecessary whitespace and otherwise improve comments in the wherecode.c module. No coding changes. (check-in: 2eb4e9bf0f user: drh tags: trunk)
23:02
Update the "msort" function in Lemon so that it works with lists of any length, and also so that the sort is stable. This patch was motivated by [forum:/forumpost/63750d717c9ed961|forum post 63750d717c] but was independently developed, then tested by temporarily setting LISTSIZE to 2. (check-in: aba5c3135e user: drh tags: trunk)
15:43
Update the reuse-schema branch to the 3.50.1 patch release. (Leaf check-in: b5463d7560 user: drh tags: reuse-schema-3.50)
14:52
Version 3.50.1 (check-in: b77dc5e0f5 user: drh tags: release, branch-3.50, version-3.50.1)
2025-06-05
20:12
Remove the clunky test_windirent.h and test_windirent.c files from src/ and replace them with a much cleaner and more compact ext/misc/windirent.h. (check-in: acc978df52 user: drh tags: trunk)
18:28
Enhance the FSDIR virtual table with a new "level" column. The query planner knows how to optimize to avoid search deeper than the maximum requested level. (check-in: 1ddc0f9e79 user: drh tags: trunk)
13:14
Fix harmless compiler warning introduced by the setlk-snapshot-fix merge. (check-in: cbab5d8651 user: drh tags: branch-3.50)
11:57
Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. (check-in: 8ac4525a2e user: drh tags: branch-3.50)
08:33
Merge TEA README updates from [bf7be67e3f]. No code changes. (check-in: 65c5e66af7 user: stephan tags: branch-3.50)
2025-06-04
18:40
tea build: add an info-exists check after a 'scan' call, as scan does not create its target vars on error. Problem reported at [forum:fde857fb8101a4be | forum post fde857fb8101a4be] and triggers when the 'vsatisfies' test for the host's Tcl version fails (so the build would fail anyway, but will fail more informatively with this fix). (check-in: a7eb03e263 user: stephan tags: branch-3.50)