database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-01 06:27:03 +03:00
Code Activity

Commit Graph

  • 0d3e5ca28e 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. drh 2025-05-31 18:26:37 +00:00
  • 51e3f855b8 Fix an affinity problem caused by a USING or NATURAL JOIN on the LHS of a FULL JOIN. [forum:/forumpost/5028c785b6|Forum post 5028c785b6]. dan 2025-05-31 18:16:21 +00:00
  • 5248693924 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. drh 2025-05-31 16:17:14 +00:00
  • 420233e375 Fix assert() statements in os_unix.c and os_win.c. Allow walsetlk_recover.test to run in non-SQLITE_ENABLE_SNAPSHOT builds. dan 2025-05-31 15:10:41 +00:00
  • 1ff4233f90 Move a mis-located makefile comment block. stephan 2025-05-31 11:08:06 +00:00
  • 10206572b6 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. stephan 2025-05-31 11:02:06 +00:00
  • b504aab848 Add some missing UNUSED_PARAMETER() annotations to squelch downstream build warnings when using -Wextra -pedantic. stephan 2025-05-31 09:44:00 +00:00
  • d930d7ef14 Follow-up to the previous: The same optimization suppression needs to happen if the left-hand side is coming from a LEFT JOIN. drh 2025-05-30 22:58:09 +00:00
  • ded1959120 If blocking locks are enabled, avoid using the busy handler when blocked by another process running recovery. dan 2025-05-30 20:52:18 +00:00
  • dd16539e71 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:/forumpost/4fc70203b61c7e12|forum post 4fc70203b61] drh 2025-05-30 19:55:46 +00:00
  • 88ed38ca6d Avoid invoking the busy-handler if a blocking lock times out while attempting to open a snapshot transaction. dan 2025-05-30 18:23:03 +00:00
  • 76473827ed Merge trunk into tcl-cw branch. tcl-cw stephan 2025-05-30 16:22:39 +00:00
  • f42ceb9075 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:87e6660191a472c5 | forum thread 87e6660191a472c5]. stephan 2025-05-30 16:08:31 +00:00
  • 7ac10ec8b5 Random typo fixes in JNI docs. stephan 2025-05-30 15:46:52 +00:00
  • 8ae57fab64 Use a more robust backup definition for offsetof(). drh 2025-05-30 15:43:04 +00:00
  • 175c3582f0 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. drh 2025-05-30 11:55:07 +00:00
  • b65326f51a 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. dan 2025-05-30 11:14:11 +00:00
  • 4cb03d18a4 Extend the fix for ticket 623eff57e76d45f6]so that it covers RIGHT JOIN in addition to LEFT JOIN. drh 2025-05-30 11:00:57 +00:00
  • 8dcef6c925 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. stephan 2025-05-30 10:18:47 +00:00
  • 0148820fd7 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. stephan 2025-05-30 10:18:09 +00:00
  • 726b2db511 Fix the missing -lm link flag for the sqlite3 shell when building the autoconf bundle with --disable-static-shell, as reported in [forum:5adf1c932a | forum post 5adf1c932a]. stephan 2025-05-29 20:33:39 +00:00
  • d14446730c Fix the missing -lm link flag for the sqlite3 shell when building the autoconf bundle with --disable-static-shell, as reported in [forum:5adf1c932a | forum post 5adf1c932a]. branch-3.49 stephan 2025-05-29 20:30:01 +00:00
  • d2b230a488 Fix the missing -lm link flag for the sqlite3 shell when building the autoconf bundle with --disable-static-shell, as reported in [forum:5adf1c932a | forum post 5adf1c932a]. stephan 2025-05-29 20:29:13 +00:00
  • f429845a60 Extend the fix for ticket [623eff57e76d45f6] so that it covers RIGHT JOIN in addition to LEFT JOIN. Problem reported by [forum:/forumpost/7dee41d32506c4ae|forum post 2025-05-29T15:10:14Z]. drh 2025-05-29 18:44:41 +00:00
  • b163f66de0 Fix a goofy hash function in Lemon. No changes to SQLite itself. drh 2025-05-29 17:46:34 +00:00
  • f766ca9ae3 Update the reuse-schema branch to version 3.50.0 drh 2025-05-29 14:59:57 +00:00
  • de6eeaaa0e Update the bedrock branch to version 3.50.0 drh 2025-05-29 14:59:34 +00:00
  • 3419721072 Bring the wal2 branch to to version 3.50.0. drh 2025-05-29 14:47:35 +00:00
  • e9057eb841 Bring the begin-concurrent branch up to version 3.50.0. drh 2025-05-29 14:40:50 +00:00
  • 3f52361352 Version 3.50.0 version-3.50.0 major-release drh 2025-05-29 14:26:00 +00:00
  • b3c1884b65 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:/forumpost/a8704b30f3|forum post 2025-05-28T13:03:40Z]. Test cases are in TH3. drh 2025-05-28 16:56:23 +00:00
  • b3bcf489a4 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. silly-partial-indexes drh 2025-05-28 14:59:42 +00:00
  • f08f71a21d Slight change to tool/split-sqlite3c.tcl to make it compatible with jimsh drh 2025-05-26 23:20:23 +00:00
  • f96d44e5de Fix a bug in the speedtest.tcl testing script that was introduced by [7e9845433ff26bdc] drh 2025-05-26 17:29:13 +00:00
  • 209894c2f5 In the TEA build, enable USE_TCL_STUBS on Mac platforms. stephan 2025-05-26 16:59:49 +00:00
  • 6e35b42abc 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). tea-breakage-experimentation stephan 2025-05-26 16:39:13 +00:00
  • 93394ebc27 On OpenBSD, do not test fuzzcheck with ubsan as part of "make devtest". dan 2025-05-26 16:17:06 +00:00
  • 8f06aed1df Avoid calls to sprintf() in Lemon, since OpenBSD hates sprintf(). drh 2025-05-26 15:36:43 +00:00
  • 3f01048954 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. stephan 2025-05-26 15:20:57 +00:00
  • 45fa2347fe tclsqlite.c doc typo fix. stephan 2025-05-26 07:15:20 +00:00
  • a01b7adb13 Change json_group_object() so that it ignores entries where the label is NULL. [forum:/forumpost/e5bd251fb5|Forum post e5bd251fb5]. drh 2025-05-24 20:20:20 +00:00
  • c5031b578b vtablog.c doc fixes reported in [forum:416d1e37b2|forum post 416d1e37b2]. stephan 2025-05-24 16:01:50 +00:00
  • 81a2f7ba8f Amend the previous: Set SQLITE_JSON_MAX_DEPTH to 500 on *all* builds of fuzzcheck. drh 2025-05-24 01:34:41 +00:00
  • 85f37eba16 Limit JSON recursion depth to 500 when running ASAN in fuzzcheck, to prevent stack overflow on ARM64. drh 2025-05-23 20:50:49 +00:00
  • c1ea1a6d4d Add the --osmalloc option to the test/speedtest.tcl testing script. Adjust ./configure so that it does not check for malloc_usable_size(). drh 2025-05-23 14:52:23 +00:00
  • 96e16194b8 Fix a problem with using streaming iterators with sqlite3changegroup_add_change(). dan 2025-05-22 18:04:48 +00:00
  • b43090b981 Merge the latest trunk changes into the reuse-schema branch. drh 2025-05-19 17:06:55 +00:00
  • dce57658bf Merge the latest trunk enhancements into the bedrock branch through the wal2 intermediary. drh 2025-05-19 16:58:50 +00:00
  • 497d44ec5e Merge recent trunk changes into the wal2 branch. drh 2025-05-19 16:52:04 +00:00
  • 7978de38e5 Merge the latest trunk changes into the begin-concurrent branch. drh 2025-05-19 16:45:11 +00:00
  • 4a0b7a332f Clarify some malloc size computations to simplify the proof that they are safe. Remove some code associated with cygwin that is marked "#if 0". drh 2025-05-19 14:50:36 +00:00
  • 79c792d5d9 Make the new sqlite3_setlk_timeout() interface accessible to loadable extensions. drh 2025-05-19 14:04:48 +00:00
  • 890de76cf5 Remove stray tab characters from source files. drh 2025-05-19 12:46:08 +00:00
  • a58208a214 Fix a harmless comment typo drh 2025-05-19 12:34:11 +00:00
  • acf95a3217 Adjust the tool/warnings.sh script so that it works on the latest versions of clang on Mac. drh 2025-05-19 11:08:30 +00:00
  • f62ae820a6 Merge trunk into this branch. stephan 2025-05-17 17:15:49 +00:00
  • 953e450e8e 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. stephan 2025-05-17 11:06:02 +00:00
  • c953cb6b3b Minor tcl doc update. tea-cleanups stephan 2025-05-17 10:35:11 +00:00
  • 9bb2548e3e Rename feature-tests.tcl to feature.tcl. Haiku tcl portability fixes. stephan 2025-05-17 10:32:48 +00:00
  • 1e24694b59 Latest upstream teaish pieces for minor fixes. Restructure this copy of teaish to simplify maintenance and the autoconf bundle build. stephan 2025-05-17 07:02:06 +00:00
  • 972a0f5e8d Improved version of the previous check-in. drh 2025-05-16 18:19:11 +00:00
  • cd64392301 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. drh 2025-05-16 17:30:20 +00:00
  • cecf833325 Add the --enablefk option to the "changeset apply" command of the changeset program. drh 2025-05-15 18:50:19 +00:00
  • c638017280 Enhance the "changeset" utility program with new command-line options for the "changeset apply" command. drh 2025-05-15 17:33:32 +00:00
  • 4165fd8a86 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. drh 2025-05-15 11:20:54 +00:00
  • 691b44a1b3 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. drh 2025-05-14 16:40:05 +00:00
  • c02ac7b9d7 Fix trunk fork. drh 2025-05-13 19:06:11 +00:00
  • 186fd30436 Adjust the strftime() test in test/date4.test to remove flags not supported in musl libc if that environment is detected. stephan 2025-05-13 18:58:56 +00:00
  • 494830ca8e First cut at enhancing the fsdir virtual table so that it works with unicode characters on Windows. drh 2025-05-13 16:58:36 +00:00
  • 0df6c5b9a7 Omit the unused readdir_r() routine from test_windirent.c drh 2025-05-13 15:09:13 +00:00
  • 0a0777d845 Session extension doc typo fix reported in [forum:75e9408acb|forum post 75e9408acb]. stephan 2025-05-12 19:12:50 +00:00
  • a0b34dcfc0 Fix a coding mistake in vfstrace. drh 2025-05-12 11:48:39 +00:00
  • eb55814c62 Remove a redundant typedef from the sqlite3_rsync.c source file. drh 2025-05-11 10:48:10 +00:00
  • 94e22bc077 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. drh 2025-05-10 17:09:53 +00:00
  • 844b457950 Add enforcement of the obscure JSON5 syntax rule that the &#92;0 escape sequence must not be followed by a digit. [forum:/forumpost/c061e87faf7d1c55|Forum post c061e87faf]. drh 2025-05-10 15:53:17 +00:00
  • 733aff3be8 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:/forumpost/3fa9d44c0b381342|forum thread 2025-05-08T08:50Z]. Additional test cases will be added separately. drh 2025-05-08 16:18:18 +00:00
  • cc28137e08 Internal doc typo fix. No code changes. stephan 2025-05-08 13:51:55 +00:00
  • f087b6ace3 Fix a harmless warning about and oversize shift operation on malformed JSONB inputs. [https://issues.oss-fuzz.com/issues/415850463|OSSFuzz 415850463]. drh 2025-05-07 17:13:30 +00:00
  • 1b571af11a Version 3.49.2 version-3.49.2 drh 2025-05-07 10:39:52 +00:00
  • 75e4cbebb3 Merge the latest trunk enhancements into the reuse-schema branch. drh 2025-05-06 23:01:40 +00:00
  • acd36d842a Merge the latest trunk enhancements into the bedrock branch. drh 2025-05-06 21:45:41 +00:00
  • bd18310b5f Merge the latest trunk changes into the wal2 branch. drh 2025-05-06 21:38:45 +00:00
  • 4b3e9a4903 Merge all the latest trunk enhancements into the begin-concurrent branch. drh 2025-05-06 21:26:10 +00:00
  • 999fef466a 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. drh 2025-05-06 18:04:04 +00:00
  • f67058367b Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix. dan 2025-05-06 17:56:32 +00:00
  • 288f356854 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 [https://issues.chromium.org/issues/415397143|Chromium fuzzer]. Never seen in the wild, as far as anybody knows. drh 2025-05-06 17:53:27 +00:00
  • ad39fa81af Fix the sqlite3VdbeTypeofColumn() function so that it works correctly even when SQLITE_DEBUG is defined. drh 2025-05-06 16:28:44 +00:00
  • 3b51a1ac01 Fix console-I/O on Windows for DEBUG=3 builds. Broken by [925e97e6f4238f02]. drh 2025-05-06 15:39:39 +00:00
  • fc3e726389 Account for Tcl 8.x's lack of Tcl_BounceRefCount(). stephan 2025-05-05 23:44:41 +00:00
  • b64b143b61 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). stephan 2025-05-05 22:56:07 +00:00
  • f44bf6c482 Part 1 of 2(3?) of adding the -asdict flag to the db eval command of the Tcl interface, as proposed in [forum:dce85c5ab9f0bc10|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. stephan 2025-05-05 20:44:58 +00:00
  • d50c4a4b33 Flesh out the break-as-null test cases to better demonstrate how it compares to the default of returning an empty string. stephan 2025-05-05 17:13:15 +00:00
  • 66937b8fbd Allow Tcl-defined UDFs to 'break' to result in an SQL NULL, as per suggestion in [forum:585ebac2c48f1411|forum post 585ebac2c48f1411]. stephan 2025-05-05 16:49:16 +00:00
  • ba6a769e12 Merge trunk into cygwin-fixes branch. 'make test' failure count = 1 (delete_db-1.3.0) both before and after the merge, cygwin-fixes stephan 2025-05-05 15:12:23 +00:00
  • d7324103b1 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. drh 2025-05-03 15:17:21 +00:00
  • 37b76bac18 Fix a harmless redundant variable declaration in sqlite3_rsync. drh 2025-05-03 10:55:47 +00:00
  • e618674714 Addition summary results output when using -vvv on sqlite3_rsync. drh 2025-05-03 10:49:39 +00:00
  • d7b83224bb 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. drh 2025-05-03 10:35:32 +00:00
  • f4d435dc0d 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. drh 2025-05-03 08:17:46 +00:00
  • e2826db73a Improvements to protocol negotiation. faster-rsync drh 2025-05-03 07:00:51 +00:00