Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
111 check-ins for the month beginning 2025-05-01
Following month ↑|
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) | |
| 19:55 | Update a few test scripts so that they run on windows. (check-in: 14a18f4e3a user: dan tags: setlk-snapshot-fix) | |
| 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) | |
| 15:10 | Fix assert() statements in os_unix.c and os_win.c. Allow walsetlk_recover.test to run in non-SQLITE_ENABLE_SNAPSHOT builds. (check-in: 9f521ecda2 user: dan tags: setlk-snapshot-fix) | |
| 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) | |
| 20:52 | If blocking locks are enabled, avoid using the busy handler when blocked by another process running recovery. (check-in: a35236757a user: dan tags: setlk-snapshot-fix) | |
| 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) | |
| 18:23 | Avoid invoking the busy-handler if a blocking lock times out while attempting to open a snapshot transaction. (check-in: fe11f85fd3 user: dan tags: setlk-snapshot-fix) | |
| 16:22 | Merge trunk into tcl-cw branch. (Leaf check-in: 6747183c90 user: stephan tags: tcl-cw) | |
| 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:30 | 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. (Leaf check-in: e6bf6b1b31 user: stephan tags: branch-3.49) | |
| 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:59 | Update the reuse-schema branch to version 3.50.0 (Leaf check-in: 4b1a38ff6b user: drh tags: reuse-schema) | |
| 14:59 | Update the bedrock branch to version 3.50.0 (check-in: 54b8888080 user: drh tags: bedrock) | |
| 14:47 | Bring the wal2 branch to to version 3.50.0. (check-in: 9f9f81ca9c user: drh tags: wal2) | |
| 14:40 | Bring the begin-concurrent branch up to version 3.50.0. (Leaf check-in: 436609fdb1 user: drh tags: begin-concurrent) | |
| 14:26 | Version 3.50.0 (check-in: dfc790f998 user: drh tags: trunk, release, major-release, version-3.50.0) | |
|
2025-05-28
| ||
| 16:56 | Do not use a partial index unless the WHERE clause uses one or more columns from the table being indexed. This resolves the issue reported by forum post 2025-05-28T13:03:40Z. Test cases are in TH3. (check-in: f037ca064d user: drh tags: trunk) | |
| 14:59 | Do not use a partial index if the truth of the WHERE clause does not depend on at least one column from the table being indexed. (Closed-Leaf check-in: cbe2a392e4 user: drh tags: silly-partial-indexes) | |
|
2025-05-26
| ||
| 23:20 | Slight change to tool/split-sqlite3c.tcl to make it compatible with jimsh (check-in: fe670ddda9 user: drh tags: trunk) | |
| 17:29 | Fix a bug in the speedtest.tcl testing script that was introduced by [7e9845433ff26bdc] (check-in: e4ffa86aa6 user: drh tags: trunk) | |
| 16:59 | In the TEA build, enable USE_TCL_STUBS on Mac platforms. (check-in: 0b5415151c user: stephan tags: trunk) | |
| 16:39 | Slight tweaks to the tea build to have to create a .o file instead of building directly from sources. This is step 1 of N of narrowing down platform-specific breakage between 3.49 (autotools) and 3.50 (autosetup). (Leaf check-in: 14c8247f7e user: stephan tags: tea-breakage-experimentation) | |
| 16:17 | On OpenBSD, do not test fuzzcheck with ubsan as part of "make devtest". (check-in: a3dabd599c user: dan tags: trunk) | |
| 15:36 | Avoid calls to sprintf() in Lemon, since OpenBSD hates sprintf(). (check-in: ed17858ddf user: drh tags: trunk) | |
| 15:20 | When detecting TCLLIBDIR, skip over //zipfs paths, as the (file isdirectory) command will actually return true for those, but they're useless for installation purposes. This resolves the tea build's inability to install on stock openbsd. (check-in: 5b29724a32 user: stephan tags: trunk) | |
| 07:15 | tclsqlite.c doc typo fix. (check-in: de0dfac1e5 user: stephan tags: trunk) | |
|
2025-05-24
| ||
| 20:20 | Change json_group_object() so that it ignores entries where the label is NULL. Forum post e5bd251fb5. (check-in: 28215d131c user: drh tags: trunk) | |
| 16:01 | vtablog.c doc fixes reported in forum post 416d1e37b2. (check-in: 5d25f62bcd user: stephan tags: trunk) | |
| 01:34 | Amend the previous: Set SQLITE_JSON_MAX_DEPTH to 500 on *all* builds of fuzzcheck. (check-in: c266e38c5b user: drh tags: trunk) | |
|
2025-05-23
| ||
| 20:50 | Limit JSON recursion depth to 500 when running ASAN in fuzzcheck, to prevent stack overflow on ARM64. (check-in: 5e96e177a0 user: drh tags: trunk) | |
| 14:52 | Add the --osmalloc option to the test/speedtest.tcl testing script. Adjust ./configure so that it does not check for malloc_usable_size(). (check-in: 7e9845433f user: drh tags: trunk) | |
|
2025-05-22
| ||
| 18:04 | Fix a problem with using streaming iterators with sqlite3changegroup_add_change(). (check-in: 3dbde72714 user: dan tags: trunk) | |
|
2025-05-19
| ||
| 17:06 | Merge the latest trunk changes into the reuse-schema branch. (check-in: fc5edd557e user: drh tags: reuse-schema) | |
| 16:58 | Merge the latest trunk enhancements into the bedrock branch through the wal2 intermediary. (check-in: e7d6e993df user: drh tags: bedrock) | |
| 16:52 | Merge recent trunk changes into the wal2 branch. (check-in: 720d175478 user: drh tags: wal2) | |
| 16:45 | Merge the latest trunk changes into the begin-concurrent branch. (check-in: 9fec43d927 user: drh tags: begin-concurrent) | |
| 14:50 | Clarify some malloc size computations to simplify the proof that they are safe. Remove some code associated with cygwin that is marked "#if 0". (check-in: ba8184d132 user: drh tags: trunk) | |
| 14:04 | Make the new sqlite3_setlk_timeout() interface accessible to loadable extensions. (check-in: 8819b7285b user: drh tags: trunk) | |
| 12:46 | Remove stray tab characters from source files. (check-in: 298ff5a1dc user: drh tags: trunk) | |
| 12:34 | Fix a harmless comment typo (check-in: c4d25acec3 user: drh tags: trunk) | |
| 11:08 | Adjust the tool/warnings.sh script so that it works on the latest versions of clang on Mac. (check-in: 05a3dd9a17 user: drh tags: trunk) | |
|
2025-05-17
| ||
| 17:15 | Merge trunk into this branch. (check-in: 58dd6d94e5 user: stephan tags: tcl-cw) | |
| 11:06 | Latest teaish pieces, most significantly for tcl portability fixes. Move autoconf/teaish/autosetup/... to autosetup/teaish/. to simplify maintenance and deployment via the autoconf bundle. (check-in: 381d3e82e8 user: stephan tags: trunk) | |
| 10:35 | Minor tcl doc update. (Closed-Leaf check-in: 43259e8c3f user: stephan tags: tea-cleanups) | |
| 10:32 | Rename feature-tests.tcl to feature.tcl. Haiku tcl portability fixes. (check-in: 15bd9e581a user: stephan tags: tea-cleanups) | |
| 07:02 | Latest upstream teaish pieces for minor fixes. Restructure this copy of teaish to simplify maintenance and the autoconf bundle build. (check-in: 2b8d9b75ec user: stephan tags: tea-cleanups) | |
|
2025-05-16
| ||
| 18:19 | Improved version of the previous check-in. (check-in: 036c97e36c user: drh tags: trunk) | |
| 17:30 | Fix the optimization of check-in [663f5dd32d9db832] that strives to avoid duplicate compuations in the GROUP BY clause so that it works even if the GROUP BY term is a subquery on the RHS of a LEFT JOIN. Problem found by dbsqlfuzz. Test cases in TH3. (check-in: 955a026996 user: drh tags: trunk) | |
|
2025-05-15
| ||
| 18:50 | Add the --enablefk option to the "changeset apply" command of the changeset program. (check-in: e98d46d436 user: drh tags: trunk) | |
| 17:33 | Enhance the "changeset" utility program with new command-line options for the "changeset apply" command. (check-in: 428daca4f1 user: drh tags: trunk) | |
| 11:20 | Rework the showHelp() function in the CLI implementation so that its purpose and operation are well described by the header commit. Omit the use of enums that cause issues for MSVC 2025. (check-in: 336ceeccc6 user: drh tags: trunk) | |
|
2025-05-14
| ||
| 16:40 | Back out the "low-quality index" query planner hack of check-in [bcac937526d9a6ef]. Subsequent query planner enhancements for dealing with star-queries make that change unnecessary and the change was recently found to cause a performance regression in an unrelated query. Also fix a typo in a debugging message. (check-in: e7dcf25efa user: drh tags: trunk) | |
|
2025-05-13
| ||
| 19:06 | Fix trunk fork. (check-in: 53644c42c5 user: drh tags: trunk) | |
| 18:58 | Adjust the strftime() test in test/date4.test to remove flags not supported in musl libc if that environment is detected. (check-in: fc254c1eb7 user: stephan tags: trunk) | |
| 16:58 | First cut at enhancing the fsdir virtual table so that it works with unicode characters on Windows. (check-in: c9e04dadfd user: drh tags: trunk) | |
| 15:09 | Omit the unused readdir_r() routine from test_windirent.c (check-in: f9a216e3ad user: drh tags: trunk) | |
|
2025-05-12
| ||
| 19:12 | Session extension doc typo fix reported in forum post 75e9408acb. (check-in: b96cfff52b user: stephan tags: trunk) | |
| 11:48 | Fix a coding mistake in vfstrace. (check-in: f0054cc0bc user: drh tags: trunk) | |
|
2025-05-11
| ||
| 10:48 | Remove a redundant typedef from the sqlite3_rsync.c source file. (check-in: b4c37c6bcc user: drh tags: trunk) | |
|
2025-05-10
| ||
| 17:09 | Provide the SQLITE_BUG_COMPATIBLE_20250510 compile-time option that restores the JSON5 bug fixed in the previous check-in, in case some applications need it for legacy compatibility. (check-in: 491cf31904 user: drh tags: trunk) | |
| 15:53 | Add enforcement of the obscure JSON5 syntax rule that the \0 escape sequence must not be followed by a digit. Forum post c061e87faf. (check-in: 83c7477f2b user: drh tags: trunk) | |
|
2025-05-08
| ||
| 16:18 | Fix PRAGMA trusted_schema=OFF and similar so that it restricts the kinds of functions in CHECK constraints that the documentation says it does. It was letting through some function that it ought not have. This is a defect in [5720924cb07766cd]. See forum thread 2025-05-08T08:50Z. Additional test cases will be added separately. (check-in: 25920beebf user: drh tags: trunk) | |
| 13:51 | Internal doc typo fix. No code changes. (check-in: ac2aa39f7e user: stephan tags: trunk) | |
|
2025-05-07
| ||
| 17:13 | Fix a harmless warning about and oversize shift operation on malformed JSONB inputs. OSSFuzz 415850463. (check-in: cf8b55b3b6 user: drh tags: trunk) | |
| 10:39 | Version 3.49.2 (check-in: 17144570b0 user: drh tags: release, branch-3.49, version-3.49.2) | |
|
2025-05-06
| ||
| 23:01 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: f98aa940b4 user: drh tags: reuse-schema) | |
| 21:45 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 9d6517e7cc user: drh tags: bedrock) | |
| 21:38 | Merge the latest trunk changes into the wal2 branch. (check-in: b17f5beab8 user: drh tags: wal2) | |
| 21:26 | Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 55a51ba58f user: drh tags: begin-concurrent) | |
| 18:04 | Fix a bug in the NOT NULL/IS NULL optimization that can cause invalid data to be used for a column if that column has a CHECK constraint that includes the NOT NULL or IS NULL operator. (check-in: 9d1f01aac9 user: drh tags: branch-3.49) | |
| 17:56 | Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix. (check-in: 6eb2939a60 user: dan tags: trunk) | |
| 17:53 | Fix a bug in the NOT NULL/IS NULL optimization of check-in [cb94350185f555c3] that can cause invalid data to be used for a column if that column has a CHECK constraint that includes the NOT NULL or IS NULL operator. Problem discovered by the Chromium fuzzer. Never seen in the wild, as far as anybody knows. (check-in: 2adaee9aa9 user: drh tags: trunk) | |
| 16:28 | Fix the sqlite3VdbeTypeofColumn() function so that it works correctly even when SQLITE_DEBUG is defined. (check-in: 1d5021533e user: drh tags: trunk) | |
| 15:39 | Fix console-I/O on Windows for DEBUG=3 builds. Broken by [925e97e6f4238f02]. (check-in: ccef4f7058 user: drh tags: trunk) | |
|
2025-05-05
| ||
| 23:44 | Account for Tcl 8.x's lack of Tcl_BounceRefCount(). (check-in: 46b0bf5603 user: stephan tags: tcl-cw) | |
| 22:56 | Part 2 of 2(?) of adding the -asdict flag to the db eval command of the Tcl interface. This needs a critical review from seasoned Tcl C API users before merging can be considered (noting that it's not planned for inclusion until 3.51). (check-in: 5368647a1f user: stephan tags: tcl-cw) | |
| 20:44 | Part 1 of 2(3?) of adding the -asdict flag to the db eval command of the Tcl interface, as proposed in forum post dce85c5ab9f0bc10. This is the lowest-level part but it does nothing because the higher-level part does not yet exist to activate it, a notable consequence of which is that it's untested. Rename pArray to pTgtName because the former name is now confusingly incorrect. (check-in: 003e2c9bca user: stephan tags: tcl-cw) | |
| 17:13 | Flesh out the break-as-null test cases to better demonstrate how it compares to the default of returning an empty string. (check-in: ad1ae76ad1 user: stephan tags: tcl-cw) | |
| 16:49 | Allow Tcl-defined UDFs to 'break' to result in an SQL NULL, as per suggestion in forum post 585ebac2c48f1411. (check-in: 034211985d user: stephan tags: tcl-cw) | |
| 15:12 | Merge trunk into cygwin-fixes branch. 'make test' failure count = 1 (delete_db-1.3.0) both before and after the merge, (Leaf check-in: 7471088197 user: stephan tags: cygwin-fixes) | |
|
2025-05-03
| ||
| 15:17 | Enhance sqlite3_rsync so that if the first attempt to invoke a copy of itself on the remote system using ssh fails, try again after augmenting the PATH. This enables sqlite3_rsync to work without the --exe option when the remote system is a Mac. (check-in: 38d4c94d8c user: drh tags: trunk) | |
| 10:55 | Fix a harmless redundant variable declaration in sqlite3_rsync. (check-in: f8f15eff6a user: drh tags: trunk) | |
| 10:49 | Addition summary results output when using -vvv on sqlite3_rsync. (check-in: c702999cfa user: drh tags: trunk) | |
| 10:35 | Promote the --protocol option to sqlite3_rsync from being an undocumented debug option to being a supported and user-visible option. This is sometimes needed to work around bugs in prior versions running on the remote. (check-in: 4855e04e44 user: drh tags: trunk) | |
| 08:17 | Enhance sqlite3_rsync (in a backwards-compatible way) so that it has the ability to send hashes for blocks of pages in addition to individual pages. By judicious use of this capability, network bandwidth requirement to sync two similar databases is reduced. (check-in: e5d87aaa8f user: drh tags: trunk) | |
| 07:00 | Improvements to protocol negotiation. (Closed-Leaf check-in: 4f5a06e420 user: drh tags: faster-rsync) | |
|
2025-05-02
| ||
| 23:50 | Clean up command-line parsing. Add the undocumented -protocol option for debugging. (check-in: 2a52b174e6 user: drh tags: faster-rsync) | |
| 22:25 | Now appears to be working. More testing needed. Refinement of the version-2 algorithm needed. (check-in: cb035181d9 user: drh tags: faster-rsync) | |
| 18:32 | Bug fixes. Added new debugging features to better visualize the protocol. (check-in: c703306686 user: drh tags: faster-rsync) | |
| 17:39 | This is the start of an experiment in getting sqlite3_rsync to use less bandwidth when the two databases are very similar, by sending hashes over blocks of pages initially, rather than over individual pages, then requesting more detail when hashes do not match. (check-in: 266b4b8f01 user: drh tags: faster-rsync) | |
| 11:18 | Do not allow sqlite3_rsync to convert the replica from WAL-mode into DELETE-mode, as that can disrupt existing clients on the replica side. DELETE-mode to WAL-mode conversions are allowed, however. See forum thread 6b575b66156. (check-in: 660a035b6c user: drh tags: trunk) | |
|
2025-05-01
| ||
| 18:07 | Enhance sqlite3_rsync so that, by default, it will sync non-WAL-mode database files. Add a new command-line option --wal-only that restricts the sync to WAL-mode databases only (the former default). Improve command-line option parsing so that only a single "-" is required before each option. (check-in: 4b53603fe4 user: drh tags: trunk) | |
| 16:07 | Allow sqlite3_rsync to work on non-WAL-mode databases, as long as the --wal-only flag is not used. (Closed-Leaf check-in: e4126dcd1e user: drh tags: rsync-non-wal-mode) | |
| 16:02 | Mistake: Started from the wrong check-out. (Leaf check-in: 9f88f73ce3 user: drh tags: mistake) | |