database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-09-03 23:22:10 +03:00
Code Activity

Commit Graph

  • 8fb8782e2a Random wasm internal doc cleanups. No code changes. master stephan 2025-09-03 13:39:15 +00:00
  • 7fa9e45746 Add test case for pushing WHERE constraints into a UNION sub-query that uses virtual tables. dan 2025-09-02 14:59:16 +00:00
  • 91f5303c1c Experimentally add the --compile-commands configure flag to generate compile_commands.json for compilers which support it (clang), to enable Language Server Protocol (LSP) inspection of the sources. This is probably not terribly useful without the --disable-amalgamation flag, as the amalgamation is so large as to make IDE/LSP processing very slow. compile-commands stephan 2025-09-02 13:14:40 +00:00
  • 6f341f499a Latest side-stream autosetup/proj.tcl for improved compile-commands feature detection. stephan 2025-09-01 13:01:20 +00:00
  • f91151bfa1 Fix a line-wrap change made in [50234bc9e9fe58da] which broke the docsrc build by splitting a link reference across two lines, which the doc processor does not like. Problem reported in [forum:ea1fe5f421549899 | forum post ea1fe5f4215]. stephan 2025-09-01 00:32:43 +00:00
  • 20bfeccb65 Update test script reservebytes.test so that it works with the "prepare" permutation. dan 2025-08-29 16:51:16 +00:00
  • f942995fd2 Ensure POSIX builds work as expected (no extra usleep() calls) if SQLITE_ENABLE_SETLK_TIMEOUT is defined. dan 2025-08-29 15:56:38 +00:00
  • 62ed0b79da Add 'from a check-out' to the mksqlite3h.tcl manifest instructions. stephan 2025-08-29 11:21:08 +00:00
  • a00b9b99ba Fix the mksqlite3h.tcl SQLITE_SCM_... changes to work from out-of-tree builds. Problem reported in [forum:812f8d6ff4|forum post 812f8d6ff4]. stephan 2025-08-29 11:09:20 +00:00
  • 9976684d26 Remove some commented-out debugging lines and fix a doc typo. No code changes. stephan 2025-08-28 17:10:44 +00:00
  • 8200750eb1 Add macros SQLITE_SCM_BRANCH/TAGS/DATETIME to sqlite3.h, pulled from the fossil-generated manifest.tags. stephan 2025-08-28 17:05:37 +00:00
  • dca1f04f07 Remove sqlite3expert.h from the compiler invocation for that tool, as it (A) doesn't need to be there and (B) it causes some compilers problems (as reported in [forum:a1085109e7db4cf3 | forum post a1085109e7]). This bug was faithfully carried over from the legacy build. stephan 2025-08-28 15:04:52 +00:00
  • 7cfbb21451 Get Tcl_Init() working for Tcl9, the major caveat being that for statically-linked builds this only works if the Tcl9 main lib ZIP file (part of its source build but not installed) gets concatenated to the resulting custom shell's binary. Thanks to Jan Nijtmans for his help with this. tcl-init stephan 2025-08-28 14:21:18 +00:00
  • 64bc5263e1 Merge trunk into tcl-init branch. stephan 2025-08-28 12:04:24 +00:00
  • 702e88747b Add the SQLITE_JSON_MAX_DEPTH compile-time option. Copied from [59446dc0bd009157]. branch-3.42.0 drh 2025-08-27 17:37:13 +00:00
  • 1df00568b3 Add test to ensure that changing the number of reserved bytes in a database using VACUUM does not confuse other connections in stock SQLite. dan 2025-08-27 11:21:44 +00:00
  • f8b5cc695c Fix a typo in a comment. dan 2025-08-25 16:41:04 +00:00
  • 3c2b02d919 Check that certain ON clauses do not refer to tables to their right as a separate step after parsing a SELECT statement, instead of as part of the planner stage. For for [forum:ccfb3b5052 | forum post ccfb3b5052]. dan 2025-08-25 14:27:31 +00:00
  • 08a256958f For the --pagecache option of the CLI, if the SIZE parameter is a power-of-two, automatically round it up to using the PCACHE_HDRSZ. drh 2025-08-25 13:04:26 +00:00
  • 7af1d61886 Add test case to this branch to show that it handles cases where ON clauses use select-list aliases to refer to columns to their right. on-clause-fix-3rd-try dan 2025-08-25 11:47:15 +00:00
  • c6925d5922 Small simplification to the query flattener logic. drh 2025-08-23 18:18:03 +00:00
  • 4bace197e1 Fix the cases in joinI.test on this branch. dan 2025-08-23 16:26:36 +00:00
  • 81b8ad0830 Fix cksumvfs test case added by [e3bd1feccaee8ff2] so that it works with varying page sizes. Test case change only - no changes to code. drh 2025-08-23 11:09:53 +00:00
  • 49ccbc49e6 Minor tweaks to this option, to make it ready to land on trunk, if we decide to do so. on-clause-option-4 drh 2025-08-22 23:06:00 +00:00
  • d9b8237b74 Disable the query flattener if the subquery is a join and the subquery is anywhere to the right of a RIGHT JOIN and if there is an ON clause on the subquery. drh 2025-08-22 22:02:11 +00:00
  • b33477c5b4 Fix the sqlite3SetJoinExpr() routine so that it correctly sets the join flags on CASE expressions. drh 2025-08-22 21:46:22 +00:00
  • d271627f96 Steal the test/joinI.test from the on-clause-error-fix branch that demonstrates that this branch does not work. drh 2025-08-22 19:30:26 +00:00
  • fbb07ff67f Remember if a SELECT statement contains an ON clause. If it does, then after name resolution, scan the WHERE clause to verify that the ON clause does not reference tables to its right. drh 2025-08-22 19:17:44 +00:00
  • f7b1b5af96 Improve performance of this patch. on-clause-error-fix dan 2025-08-22 19:14:35 +00:00
  • db97d2ef81 Enhance treeview so that it shows the contents of ON clauses while they are still attached to the SrcItem object and before they are moved into the WHERE clause. drh 2025-08-22 18:19:26 +00:00
  • 6f15549f91 Experimental minor simplification of the query flattener. simplify-flattener drh 2025-08-22 16:34:55 +00:00
  • 54c96b2152 Attempt to detect errors cause by ON clauses that refer to tables to the right of themselves while resolving names, instead of later on after query-flattening and other operations have complicated things. dan 2025-08-22 16:25:34 +00:00
  • 90916e5ba0 Fix a minor typo in a comment. drh 2025-08-21 18:47:01 +00:00
  • 8376b87ae3 Add config as an alias for the reconfigure makefile target. Minor makefile doc tweaks. Random typo fixes in shell.c.in and tclsqlite.h pointed out by the misspell makefile target. No code changes. stephan 2025-08-21 17:59:28 +00:00
  • 1702244d2e Remove some resolved TODOs from the makefile. Ensure that testfixture links against TCL_LIBS. stephan 2025-08-21 17:39:44 +00:00
  • bb4743c278 The sqlite3_prepare() and similar interfaces should not return SQLITE_ERROR_RETRY. [forum:/forumpost/aa61ab56adb56159|Forum post aa61ab56]. drh 2025-08-20 23:29:59 +00:00
  • 5e972ddd9f Add an assert() to prove that sqlite3_prepare() does not return SQLITE_ERROR_RETRY. create-index-error-retry-fix drh 2025-08-20 23:13:49 +00:00
  • 51d3e6d51c Change a newly unreachable branch into an ALWAYS(). drh 2025-08-20 21:12:40 +00:00
  • 1be5689087 Avoid returning SQLITE_ERROR_RETRY if collation sequences associated with the table's PK cannot be found when creating an index. Possible fix for [forum:aa61ab56ad | forum post aa61ab56ad]. dan 2025-08-20 15:42:23 +00:00
  • c30e1a10ef Fix a problem with SQLITE_CHANGESET_CONFLICT conflicts caused by DELETE triggers within a call to sqlite3changset_apply_v2() with SQLITE_CHANGESETAPPLY_IGNORENOOP specified. dan 2025-08-20 11:21:35 +00:00
  • 4a27581f14 In builds without HAVE_FCHMOD (e.g. WASI), make the chmod() of temp files a no-op, analog to how lack of HAVE_FCHOWN is handled, as discussed in [forum:98d5158d3fdd7a41 | forum post 98d5158d3f]. stephan 2025-08-20 09:43:15 +00:00
  • 697d29ea49 Fix a problem causing an SQLITE_CHANGESET_DATA conflict of a DELETE operation to be incorrectly ignored if the SQLITE_CHANGESETAPPLY_IGNORENOOP is specified. dan 2025-08-19 21:35:23 +00:00
  • 7f84ce0ea9 Add a doc sentence about sqlite3_set_clientdata()'s result value, per request in [forum:bda6c22b6a | forum post bda6c22b6a]. No code changes. stephan 2025-08-16 10:17:04 +00:00
  • a6c95406c1 Avoid depending on HAVE_STDINT_H and SQLITE_PTRSIZE and other things in non-amalgamation builds of fts5. dan 2025-08-14 19:36:59 +00:00
  • e3fc1fc8dd Minor internal cleanups in the configure script. No behavioral changes. stephan 2025-08-13 19:59:37 +00:00
  • 6f097125cd Have cksumvfs write checksums to the database file only, not the wal file. Writing them to the wal file breaks wal file recovery. dan 2025-08-13 19:13:16 +00:00
  • 0e77c3fa4d In cksumvfs, do not write checksums to the wal file, as this prevents recovery from working. cksumvfs-wal-fix dan 2025-08-13 18:37:41 +00:00
  • 527062ac5e Minor autosetup/README.md tweaks. stephan 2025-08-13 18:30:42 +00:00
  • 656563cce9 Move the forced NDEBUG in fts3Int.h up above the #include of assert.h, as reported in [forum:8f16dd9480aad85f | forum post 8f16dd9480aad85f]. stephan 2025-08-13 17:58:47 +00:00
  • 6cebfa56cc Doc updates in the configure script. No functional changes. stephan 2025-08-13 16:49:55 +00:00
  • 8e875fa3bd Fix a problem with the checksum-vfs and direct-overflow-reads. Forum post [forum:350e147cd1 | 350e147cd1]. dan 2025-08-13 14:40:24 +00:00
  • c5c9c6093b Fix a problem with the checksum-vfs and direct-overflow-reads. cksum-direct-ovfl-fix dan 2025-08-13 14:35:14 +00:00
  • 16478dbfdd Doc cleanups in main.mk. No functional changes. stephan 2025-08-13 11:46:05 +00:00
  • a939a635a2 Fix a problem with reading wal mode databases from UNC shares on windows introduced by [e88212b10a7829ff]. dan 2025-08-12 19:02:48 +00:00
  • 3f85939bf0 Fix a problem building testfixture on non SQLITE_OS_WIN platforms. win-unc-fix dan 2025-08-12 18:57:02 +00:00
  • b1406a6550 On windows, when opening a UNC path, fall back to using a single file handle shared between all connections for locking. dan 2025-08-12 17:55:34 +00:00
  • 1ecc135cc5 The off-by-one fix at [3e627d66ebdef8df] is insufficient. An index can hold twice as many columns as a table, if the table is a WITHOUT ROWID table. The limit should be twice the maximum, not just one more than the maximum. Problem discovered by OSSFuzz. drh 2025-08-11 13:17:10 +00:00
  • 9081b89720 Replace some 32-bit arithmetic in fts3_write.c with 64-bit to avoid the possibility of integer overflow. dan 2025-08-11 10:54:39 +00:00
  • 88f7807fa6 Add an explicit call to sqlite3_initialize() to sqlite3_rsync so that it works when built with SQLITE_OMIT_AUTOINIT, as suggested in [forum:c4ec6b33097b8536 | forum post c4ec6b33097b8536]. stephan 2025-08-07 20:20:22 +00:00
  • 2e3f9aff4a Increase the patch level from 4 to 5. branch-3.50 drh 2025-08-06 19:20:36 +00:00
  • c580b148b0 Do not allow the number of terms in an ORDER BY or GROUP BY clause to exceed the maximum number of columns in a table. drh 2025-08-06 19:19:52 +00:00
  • 11ba513fe5 Skip checking for dlopen() on mingw builds and those which include "windows" in their host tuple, as suggested in [forum:2436c8ffed | forum post 2436c8ffed]. Those environments identify as Windows for SQLite's purposes so use LoadLibrary(). stephan 2025-08-06 19:16:16 +00:00
  • e7440380c2 Do not allow the number of terms in an ORDER BY or GROUP BY clause to exceed the maximum number of columns in a table. drh 2025-08-06 19:12:10 +00:00
  • e6061cba7f Fix Windows makefile breakage caused by [ae9d7c9c922bb241]. drh 2025-08-06 19:05:39 +00:00
  • 5d06c6b3f1 Add *.obj to the make clean target for the sake of the Unix-on-Windows environments. stephan 2025-08-06 16:51:12 +00:00
  • de048aeda9 Extend the sqlite3_rsync PATH to include /opt/local/bin, per request in [forum:ca3c1bb7ca8e03 | forum post ca3c1bb7ca8e03]. stephan 2025-08-06 15:57:44 +00:00
  • 7270a56fdf Minor bug fixes in the script added by the previous check-in drh 2025-08-06 12:47:58 +00:00
  • aa86b2a373 Add a script to build ARM64EC binaries on Windows11 for ARM64. drh 2025-08-06 12:43:06 +00:00
  • bfe2964c5d Version 3.42.1 version-3.42.1 branch-3.42 drh 2025-08-06 11:05:53 +00:00
  • ff1d5e5bb8 Fix a possible printf() of a NULL string in fuzzcheck. (Passing a NULL to "%s" in SQLite's internal printf() prints the text "NULL", but it apparently segfaults glibc. Whatever.) [forum:/forumpost/e07d56579b|Forum post e07d56579b]. drh 2025-08-05 23:01:31 +00:00
  • bb0afc2818 Fix the same potential integer overflow problem of [5508b56fd24016c1] in a different and much simpler way. No error is raised but memory errors are avoided. drh 2025-08-05 21:04:04 +00:00
  • 48b12598cb Fix a couple of potential integer overflow problems in FTS5. drh 2025-08-05 20:33:14 +00:00
  • e25813cd12 Fix a buffer overread in the sessions extension that could occur when processing a corrupt changeset. drh 2025-08-05 19:36:05 +00:00
  • 5f022e71c8 Minor patch to LSM1 in an attempt to get it to build on Mac. lsm1-experimental drh 2025-08-05 12:04:22 +00:00
  • cd70a44d45 Remove the <i>experimental</i> lsm1 extension from trunk, in as much as readers were thinking that this was a supported extension and were reporting bugs against it. drh 2025-08-05 12:01:43 +00:00
  • 332eb8e63c Add bounds checking and error messages and improved comments to the (unused) zorder extension function. [forum:/forumpost/e3f1ede174|Forum post e3f1ede174] drh 2025-08-05 10:54:56 +00:00
  • 3155997184 Improved defenses against corrupt ZIP archives in the zipfile extension. drh 2025-08-05 01:58:20 +00:00
  • f9c2cff2fe Improved defenses against corrupt ZIP archives in the zipfile extension. drh 2025-08-05 01:53:03 +00:00
  • eff534e1a5 Back out a recently added NEVER(). drh 2025-08-05 00:16:40 +00:00
  • 7d436c1acf When doing an indexed row-value comparison using an IN operator where the order of the columns in the row-value need to be rearranged in order to match the index, be sure to make affinity conversions before the rearranging of the row-value columns. drh 2025-08-05 00:13:48 +00:00
  • a37bf61539 Fix a bug in the fuzzcheck.c test program introduced by [1cccea0508f5c8b8]. drh 2025-08-04 23:37:48 +00:00
  • d7d77eb56d When doing an indexed row-value comparison using an IN operator where the order of the columns in the row-value need to be rearranged in order to match the index, be sure to make affinity conversions before the rearranging of columns so that the correct affinity is applied. Fix for the bug reported by [forum:/forumpost/eab63506cf|forum post eab63506cf]. This problem goes back almost nine years to [ddb5f0558c445699]. drh 2025-08-04 23:05:35 +00:00
  • 82b08cc8ef Add an assert() to verify that IN_INDEX_NOOP is not used for vector operations. dan 2025-08-04 20:48:37 +00:00
  • e318c4573b Remove the "experimental" mark the snapshot interfaces. drh 2025-08-04 19:35:20 +00:00
  • dbfdbcdeb7 Fixes to sqlite3_error_schema(). error-schema drh 2025-08-04 17:45:42 +00:00
  • 96be4a368b The sqlite3_error_schema() interface now works for errors discovered during OP_Transaction. drh 2025-08-04 13:55:58 +00:00
  • 8725bf916d Fix harmless compiler warnings arising from [1cccea0508f5c8b8]. drh 2025-08-04 11:50:41 +00:00
  • fe263ce3a6 Prototype of the sqlite3_error_schema() interface. Non-functional. drh 2025-08-04 11:40:31 +00:00
  • 1f4c281b0b Minor doc typo fix in sqliteLimit.h. stephan 2025-08-04 11:20:31 +00:00
  • 1cf61ce636 Add a note to sqlite3_deserialize() that a schema name of NULL implies the main db, a former shortcoming pointed out in [forum:0543d8aa8e|forum post 0543d8aa8e]. stephan 2025-08-03 08:56:16 +00:00
  • cd552cf99f Tag a condition in os_unix.c as unreachable. drh 2025-08-02 17:37:59 +00:00
  • 8c30f16a2e Fiddle: move the About button into the main toolbar. Extend the About text with some info which only shows up (or is only hidden) when terminal mode is available. stephan 2025-08-02 15:04:50 +00:00
  • f681a9a7d8 Fiddle: make the toolbar visible in terminal mode and hide non-terminal-mode options when in terminal mode. Move the terminal/split-view toggle button into the toolbar. Improve the view-switching handling. stephan 2025-08-02 14:50:01 +00:00
  • 380ef6006b Fiddle: move the About button into the header bar and get it working together with the optional jquery.terminal console mode. stephan 2025-08-02 13:21:07 +00:00
  • a0e569d5ba Fiddle: add an about/info/help view and a button to toggle it. Change the color schema to a more conventional black/white. Force imported databases out of WAL mode, which doesn't work in fiddle. stephan 2025-08-02 12:06:37 +00:00
  • 7516e513b4 Fix the same potential integer overflow problem that was just fixed in the 3.32 branch, but in the 3.39 branch this time. Also increase the patch level here in the 3.39 branch. branch-3.39 drh 2025-08-01 13:22:00 +00:00
  • 24664c3785 Fix the same potential integer overflow problem of [5508b56fd24016c1] in a different and much simpler way. No error is raised but memory errors are avoided. branch-3.32 drh 2025-08-01 13:01:33 +00:00
  • 8b1157d9b5 Increase the patch level to 4. drh 2025-08-01 11:25:39 +00:00
  • 3ecedf6a0a Cast a string size variable to 64-bit to avoid any possibility of integer overflow. drh 2025-08-01 10:58:37 +00:00
  • b0cc58b981 Version 3.50.4 for the reuse-schema-3.50 branch. reuse-schema-3.50 drh 2025-08-01 09:47:33 +00:00