SQLite

Timeline
Login

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

50 most recent check-ins

2025-06-18
19:04
Extend the pedantic enforcement of type in STRICT tables to cover VIRTUAL columns. (Leaf check-in: b734c74e55 user: drh tags: trunk)
16:17
Enforce judgmental typing on STORED generated columns for STRICT tables. [forum:/forumpost/6caf195248a849e4|Forum post 6caf195248]. (check-in: 5e9279bff0 user: drh tags: trunk)
15:37
Export the column-metadata APIs to WASM. Doing so requires a non-default build of sqlite3.c, so this is a proof-of-concept branch saved just in case SQLITE_ENABLE_COLUMN_METADATA ever becomes the default for sqlite3.c. (Closed-Leaf check-in: 59db3f639d user: stephan tags: wasm-column-metadata)
15:22
Add the --enable-column-metadata flag to the configure script (off by default). It's only available in the canonical build, not the autoconf build, because it changes how sqlite3.c gets generated. (check-in: 986b601db1 user: stephan tags: trunk)
14:17
Eliminate configure/build discrepancies in how 'make tclextension-...' works vs other makefile-side handling of the extension, conforming to the former. (check-in: 7ca545fd3b user: stephan tags: trunk)
14:14
Change the definition of SQLITE_DYNAMIC to a function that has exactly the same type as sqlite3_destructor_type, in an effort to work around possible legacy compiler bugs. (check-in: 83553edf78 user: drh tags: trunk)
11:11
Add the --tclConfig.sh FILE flag to buildtclext.tcl to eliminate the discrepancy between the configure-time-detected tclConfig.sh and the one auto-detected by the tclextension family of makefile targets. Add the tclextension-all target to run all of the various tclextension-... targets in their natural order to facilitate testing changes like this one. Update the --help text to note that --with-tclsh should only be used if there's a specific need, and that --with-tcl is generall preferred. This is in response to [https://github.com/termux/termux-packages/issues/23268 | Termux ticket 23268]. (check-in: 928976abcb user: stephan tags: trunk)
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] (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)