Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
101 check-ins going from release to trunk
|
2025-06-24
| ||
| 18:27 | Similar fix to the previous check-in, but this time for sqlite3_preupdate_new(). (Leaf check-in: 9aaff764d5 user: drh tags: trunk) | |
| 15:58 | Range check the column index on the sqlite3_preupdate_old() interface and return SQLITE_MISUSE if too large. Forum post b617e49728. (check-in: 6a5701e6c7 user: drh tags: trunk) | |
| 07:38 | API doc typo fixes and one rephrasing improvement from brickviking. (check-in: 85e8060c47 user: stephan tags: trunk) | |
|
2025-06-23
| ||
| 19:38 | Improve some of the error messages emitted by fts5 when it encounters corruption. (check-in: 48044a6b57 user: dan tags: trunk) | |
| 19:00 | Fix an SQL typo introduced by the previous check-in. (check-in: 72a81d247b user: drh tags: trunk) | |
| 16:51 | Escape the "_" character in LIKE patterns in the CLI. Forum post 6a89702f5d. (check-in: cf61cd359e user: drh tags: trunk) | |
| 13:42 | Fix a harmless compiler warning injected by [c978aed3b6f82b3d]. (check-in: f46500247b user: drh tags: trunk) | |
| 13:28 | Improved "statement aborts at ..." log-file messages that identify the trigger that caused the abort. (check-in: 7691264fe3 user: drh tags: trunk) | |
|
2025-06-22
| ||
| 22:48 | Add the --disable-rpath configure script flag to address forum post 13cac3b56516f849. (check-in: a59d9bb25e user: stephan tags: trunk) | |
| 12:04 | API doc typo fixes from brickviking. (check-in: 18e07f8f53 user: stephan tags: trunk) | |
|
2025-06-21
| ||
| 16:33 | Minor JS test cleanups prompted by a linter. (check-in: 764235a3d1 user: stephan tags: trunk) | |
| 16:18 | Remove some duplicated JS tests. (check-in: d1cb9ed79d user: stephan tags: trunk) | |
| 16:02 | Reduce the maximum --size flag for JS kvvfs speedtest1 from 4 to 2, as --size 3 and 4 are overflowing the kvvfs storage limits. (check-in: b77b3adc82 user: stephan tags: trunk) | |
| 15:58 | Give oo1.Stmt.get() similar treatment to [8c187140a60b]. This is an internal change only - the API is unaffected. (check-in: f5a7abc0a4 user: stephan tags: trunk) | |
| 15:38 | Extend the SEE-via-kvvfs tests to include all three key types. (check-in: fc001aa5ee user: stephan tags: trunk) | |
| 14:38 | Rework how JS's oo1.DB.exec() flags its Stmt objects to make certain Stmt APIs illegal (i.e. throwing) if called while that Stmt is being step()ped by DB.exec() (which can happen via client-provided per-result-row callbacks). This is an internal change only - the API is unaffected. Remove some unrelated dead code. (check-in: 8c187140a6 user: stephan tags: trunk) | |
| 06:07 | Numerous small doc typo from BrickViking. (check-in: 3aab4415de user: stephan tags: trunk) | |
|
2025-06-20
| ||
| 13:12 | Enhance sqlite3BtreeSetPageSize() so that it detects early if no changes are needed and exists with SQLITE_OK. (check-in: c978aed3b6 user: drh tags: trunk) | |
|
2025-06-19
| ||
| 20:19 | Fix an out-of-order local variable declaration in ext/misc/fileio.c. (check-in: a88bb75288 user: drh tags: trunk) | |
| 20:00 | Improve the accuracy of sqlite3BtreeRowCountEst(). (check-in: e553fb538e user: drh tags: trunk) | |
| 19:33 | Generalize the indexCellCompare() so that works on any index page, not just the current page that a cursor is pointing to. (check-in: b305a7f5db user: drh tags: trunk) | |
| 12:35 | A slight doc rephrasing for clarity, suggested in the forum. (check-in: 0d6084a398 user: stephan tags: trunk) | |
| 10:46 | Doc typo fixes from forum post 0bce273669. (check-in: 8f97e3f00d user: stephan tags: trunk) | |
| 10:25 | Expose the column metadata APIs to WASM (which does not require a non-default sqlite3.c build, contrary to my prior mistaken claims). This adds only 424 bytes to sqlite3.wasm and 660 bytes to sqlite3.js. (check-in: 3cf983816c user: stephan tags: trunk) | |
|
2025-06-18
| ||
| 19:04 | Extend the pedantic enforcement of type in STRICT tables to cover VIRTUAL columns. (check-in: b734c74e55 user: drh tags: trunk) | |
| 16:17 | Enforce judgmental typing on STORED generated columns for STRICT tables. Forum post 6caf195248. (check-in: 5e9279bff0 user: drh tags: trunk) | |
| 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 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 post fde857fb8101a4be (check-in: 7331e32a76 user: stephan tags: trunk) | |
| 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) | |
| 17:15 | Extend [b5c6cb13cff5] to use a wildcard on darwin* because some OSes report a version number in the suffix. Forum post 0c4bbc2962dfb06e. (check-in: d960bd6f92 user: stephan tags: trunk) | |
| 14:56 | Minor proj.tcl portability fixes and cleanups suggested in forum post 7b218c3c9f. Tested on Linux, Msys, Cygwin, and Haiku. (check-in: b5c6cb13cf user: stephan tags: trunk) | |
|
2025-06-16
| ||
| 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 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-12
| ||
| 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
| ||
| 15:03 | Fix a problem with UPDATEs on fts5 tables that contain blob values. (check-in: badf3014bd user: dan tags: trunk) | |
| 00:01 | Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. Forum post 52503ac21d. (check-in: 80a78987da user: drh tags: trunk) | |
|
2025-06-10
| ||
| 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: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) | |
|
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 post 63750d717c but was independently developed, then tested by temporarily setting LISTSIZE to 2. (check-in: aba5c3135e user: drh tags: trunk) | |
| 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 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) | |
| 18:34 | 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 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: 4f21874d5d user: stephan tags: trunk) | |
|
2025-06-03
| ||
| 18:11 | Apply the duplicate 'export default' workaround to the (untested and unsupported) node-specific build rules in mkwasmbuilds.c to resolve a problem reported off-list by Thomas Steiner. (check-in: c8523d9e14 user: stephan tags: branch-3.50) | |
| 18:10 | Apply the duplicate 'export default' workaround to the (untested and unsupported) node-specific build rules in mkwasmbuilds.c to resolve a problem reported off-list by Thomas Steiner. (check-in: 2f8a1b7953 user: stephan tags: trunk) | |
| 17:46 | Relax query flattener constraint (3b) and thereby allow flattening the RHS of a LEFT JOIN even if the RHS contains a virtual table. This is a performance optimization that would not normally be found on a patch branch, but downstream needs it and does not want to wait on the next full release. (check-in: 916dde1f40 user: drh tags: branch-3.50) | |
| 10:49 | Enhance sqlite3_rsync so that it works even if the replica database is initially malformed. (check-in: ea1754f7d8 user: drh tags: trunk) | |
| 10:30 | Fix an off-by-one error in sqlite3_rsync. (check-in: e13a9492c1 user: drh tags: branch-3.50) | |
| 10:28 | Fix an off-by-one error in sqlite3_rsync, reported in forum post b6d78f60fc. (check-in: 27d9e8e79b user: drh tags: trunk) | |
| 10:18 | Fix harmless compiler warning introduced by the setlk-snapshot-fix merge. (check-in: c1f20f89d9 user: drh tags: trunk) | |
|
2025-06-02
| ||
| 23:41 | Fix JSONB edit so that when it is trying to reduce the size of an element it understands 0xf0 (8-byte) sizes. (check-in: cee2711227 user: drh tags: branch-3.50) | |
| 23:34 | Fix JSONB edit so that when it is trying to reduce the size of an element it understands 0xf0 (8-byte) sizes. (check-in: 5b3de6e8ab user: drh tags: trunk) | |
| 18:58 | Increase the version number to 3.51.0 (check-in: ed69d44327 user: drh tags: trunk) | |
| 18:48 | 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: 7f9c0cdd06 user: dan tags: trunk) | |
| 18:42 | Improve the accuracy of affinity and collating sequence analysis for NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. (check-in: d6a8b1ea5c user: drh tags: branch-3.50) | |
| 18:34 | Improve the accuracy of affinity and collating sequence analysis for NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. Initial problem report in forum post 829306db47. (check-in: f184d1d236 user: drh tags: trunk) | |
| 15:17 | Slight modernization of the TEA README.txt. (check-in: bf7be67e3f user: stephan tags: trunk) | |
| 15:10 | TEA: remove the stale man page and references to the MSC makefiles from the README.txt. Based on discussion at forum post 87e6660191a472c5. A couple of weeks ago we internally discussed pulling in the MSC makefiles from the 3.49 tree but they are stale and possibly unused, so opted against it for the time being. (check-in: c9888a4095 user: stephan tags: trunk) | |
| 13:54 | Remove an unnecessary parameter from sqlite3VdbeRecordUnpack(). Improved comments and assert()s on KeyInfo. (check-in: 387f4c4d98 user: drh tags: trunk) | |
| 09:49 | Fix stale comments related to KeyInfo. Add new assert()s associated with memory management of KeyInfo. (check-in: abd805bc76 user: drh tags: trunk) | |
|
2025-06-01
| ||
| 21:55 | Update the version number to 3.50.1 (check-in: 86f0e4eabe user: drh tags: branch-3.50) | |
| 21:49 | Fix an off-by-one error in the size computation of a vdbe-sorter. (check-in: d5ab065727 user: drh tags: branch-3.50) | |
| 21:38 | Fix an off-by-one error in the size computation of a vdbe-sorter. Forum post c1cc8b057a. Problem introduced by checkin [d4307a0d43f42e96]. (check-in: 8b7a7fcf62 user: drh tags: trunk) | |
| 16:10 | Fix VACUUM so that it works even when ATTACH_WRITE is disabled. (check-in: 42494f85ac user: drh tags: trunk) | |
|
2025-05-31
| ||
| 20:51 | Enhance "box" and "column" mode formatting in the CLI to better deal with double-wide characters. (check-in: b0de22ed0a user: drh tags: trunk) | |
| 18:46 | Cherrypick obscure (fuzzer-generated) RIGHT JOIN bug fixes from trunk. (check-in: a61da8169b user: drh tags: branch-3.50) | |
| 18:26 | New makefile target "xdevtest" works like "releasetest" except that it omits the "verify-source" dependency so that it can be run with uncommitted changes in the source tree. (check-in: 1afb1ac3e9 user: drh tags: trunk) | |
| 18:16 | Fix an affinity problem caused by a USING or NATURAL JOIN on the LHS of a FULL JOIN. Forum post 5028c785b6. (check-in: 8d393ca07f user: dan tags: trunk) | |
| 16:17 | Relax query flattener constraint (3b) and thereby allow flattening the RHS of a LEFT JOIN even if the RHS contains a virtual table. This was previously disallowed by [9dbae1df75219e2a] as a performance optimization. It turns out that the constraint causes performance issues, and we do not have a record of any performance issue that it solves. (check-in: 1ddaa92057 user: drh tags: trunk) | |
| 11:08 | Move a mis-located makefile comment block. (check-in: 7d884386be user: stephan tags: trunk) | |
| 11:02 | tcl extension: UDFs may now 'break' to return an SQL NULL. Add the (eval -asdict) flag to use a dict, instead of an array, for the eval row data. (check-in: 413a626b5c user: stephan tags: trunk) | |
| 09:44 | Add some missing UNUSED_PARAMETER() annotations to squelch downstream build warnings when using -Wextra -pedantic. (check-in: a98a2f4935 user: stephan tags: trunk) | |
|
2025-05-30
| ||
| 22:58 | Follow-up to the previous: The same optimization suppression needs to happen if the left-hand side is coming from a LEFT JOIN. (check-in: cf5b37b3a3 user: drh tags: trunk) | |
| 19:55 | When synthesizing an ON constraint from a USING or NATURAL, if the left-hand side is coming from a RIGHT JOIN, be sure to set the EP_CanBeNull flag so that the optimizer knows to check for NULL even if the column has a NOT NULL constraint. Fix for the problem reported by forum post 4fc70203b61 (check-in: 60adc78a22 user: drh tags: trunk) | |
| 16:08 | Configure-related fixes and additions, most notably integration of self-tests for proj.tcl's APIs. Teaish make-install fixes based on the discussion in forum thread 87e6660191a472c5. (check-in: 2e486f8fd0 user: stephan tags: trunk) | |
| 15:46 | Random typo fixes in JNI docs. (check-in: f63608a384 user: stephan tags: trunk) | |
| 15:43 | Use a more robust backup definition for offsetof(). (check-in: 22441955e0 user: drh tags: trunk) | |
| 11:55 | Add "include <stddef.h>" to fts5 and rtree to ensure that they use the system version of the offsetof() macro when it is available, as the built-in version triggers ubsan errors with clang. (check-in: 6ceb1322ef user: drh tags: branch-3.50) | |
| 11:14 | Add "include <stddef.h>" to fts5 and rtree to ensure that they use the system version of the offsetof() macro when it is available, as the built-in version triggers ubsan errors with clang. (check-in: 838deb7f34 user: dan tags: trunk) | |
| 11:00 | Extend the fix for ticket 623eff57e76d45f6]so that it covers RIGHT JOIN in addition to LEFT JOIN. (check-in: cbd9aabaa5 user: drh tags: branch-3.50) | |
| 10:18 | Squelch an interesting but harmless struct initialization warning emitted after an emsdk update. Fix JS breakage introduced by changes in Emscripten 4.0.7: manually export the HEAPxyz symbols which used to be exposed by default. (check-in: 042c6c6e95 user: stephan tags: branch-3.50) | |
| 10:18 | Squelch an interesting but harmless struct initialization warning emitted after an emsdk update. Fix JS breakage introduced by changes in Emscripten 4.0.7: manually export the HEAPxyz symbols which used to be exposed by default. (check-in: 10d0897cc9 user: stephan tags: trunk) | |
|
2025-05-29
| ||
| 20:33 | Fix the missing -lm link flag for the sqlite3 shell when building the autoconf bundle with --disable-static-shell, as reported in forum post 5adf1c932a. (check-in: 80d5a9daa6 user: stephan tags: branch-3.50) | |
| 20:29 | Fix the missing -lm link flag for the sqlite3 shell when building the autoconf bundle with --disable-static-shell, as reported in forum post 5adf1c932a. (check-in: f6318c4a6b user: stephan tags: trunk) | |
| 18:44 | Extend the fix for ticket [623eff57e76d45f6] so that it covers RIGHT JOIN in addition to LEFT JOIN. Problem reported by forum post 2025-05-29T15:10:14Z. (check-in: 29b1e1b976 user: drh tags: trunk) | |
| 17:46 | Fix a goofy hash function in Lemon. No changes to SQLite itself. (check-in: d6cbabe23d user: drh tags: trunk) | |
| 14:26 | Version 3.50.0 (check-in: dfc790f998 user: drh tags: trunk, release, major-release, version-3.50.0) | |