database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-06-04 20:42:35 +03:00
Code

Commit Graph

  • d282fbc59c 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. branch-3.50 stephan 2025-06-03 18:11:27 +00:00
  • a29b138692 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. master stephan 2025-06-03 18:10:59 +00:00
  • d95ba2fb03 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. drh 2025-06-03 17:46:24 +00:00
  • 464a15a92c Merge latest changes from the wal2 branch into this branch. bedrock dan 2025-06-03 14:19:49 +00:00
  • efa511f1a8 Merge latest trunk changes into this branch. wal2 dan 2025-06-03 14:15:20 +00:00
  • 1b49d3de46 Merge latest trunk changes into this branch. mistake dan 2025-06-03 14:08:40 +00:00
  • 1d151e6d25 Enhance sqlite3_rsync so that it works even if the replica database is initially malformed. drh 2025-06-03 10:49:51 +00:00
  • 9412d98419 Fix an off-by-one error in sqlite3_rsync. drh 2025-06-03 10:30:31 +00:00
  • df724c893a Fix an off-by-one error in sqlite3_rsync, reported in [forum:/forumpost/b6d78f60fc|forum post b6d78f60fc]. drh 2025-06-03 10:28:47 +00:00
  • 140748f949 Fix harmless compiler warning introduced by the setlk-snapshot-fix merge. drh 2025-06-03 10:18:54 +00:00
  • 1daead7a11 Fix JSONB edit so that when it is trying to reduce the size of an element it understands 0xf0 (8-byte) sizes. drh 2025-06-02 23:41:56 +00:00
  • 2bd9f69d40 Fix JSONB edit so that when it is trying to reduce the size of an element it understands 0xf0 (8-byte) sizes. drh 2025-06-02 23:34:42 +00:00
  • 333b07b18d Increase the version number to 3.51.0 drh 2025-06-02 18:58:42 +00:00
  • 9269b212bf 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. dan 2025-06-02 18:48:36 +00:00
  • 13efb2f676 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. drh 2025-06-02 18:42:49 +00:00
  • 69ce758efa Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows. setlk-snapshot-fix dan 2025-06-02 18:37:32 +00:00
  • 342ef63e63 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:/forumpost/829306db47|forum post 829306db47]. drh 2025-06-02 18:34:17 +00:00
  • cfee69fbe4 Updates to new test cases to run with SQLITE_ENABLE_SETLK_TIMEOUT=2 builds. dan 2025-06-02 18:09:46 +00:00
  • eb9a145711 Merge trunk changes into this branch. dan 2025-06-02 17:44:10 +00:00
  • d84bbac8be Slight modernization of the TEA README.txt. stephan 2025-06-02 15:17:59 +00:00
  • a3fcd7c79e TEA: remove the stale man page and references to the MSC makefiles from the README.txt. Based on discussion at [forum:87e6660191a472c5 | 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. stephan 2025-06-02 15:10:41 +00:00
  • 8658a8df59 Remove an unnecessary parameter from sqlite3VdbeRecordUnpack(). Improved comments and assert()s on KeyInfo. drh 2025-06-02 13:54:33 +00:00
  • 7590bfd7fc Fix stale comments related to KeyInfo. Add new assert()s associated with memory management of KeyInfo. drh 2025-06-02 09:49:07 +00:00
  • 6510bebf48 Update the version number to 3.50.1 drh 2025-06-01 21:55:17 +00:00
  • 7c1d13bcd8 Fix an off-by-one error in the size computation of a vdbe-sorter. drh 2025-06-01 21:49:45 +00:00
  • d4c224b833 Fix an off-by-one error in the size computation of a vdbe-sorter. [forum:/forumpost/c1cc8b057a|Forum post c1cc8b057a]. Problem introduced by checkin [d4307a0d43f42e96]. drh 2025-06-01 21:38:35 +00:00
  • f18bf8997b Fix VACUUM so that it works even when ATTACH_WRITE is disabled. drh 2025-06-01 16:10:25 +00:00
  • c0190101d1 Enhance "box" and "column" mode formatting in the CLI to better deal with double-wide characters. drh 2025-05-31 20:51:42 +00:00
  • 977b0f8813 Update a few test scripts so that they run on windows. dan 2025-05-31 19:55:07 +00:00
  • ce3887bde4 Cherrypick obscure (fuzzer-generated) RIGHT JOIN bug fixes from trunk. drh 2025-05-31 18:46:44 +00:00
  • 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 reuse-schema 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. begin-concurrent drh 2025-05-29 14:40:50 +00:00
  • 3f52361352 Version 3.50.0 version-3.50.0 release 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