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

Commit Graph

  • d41f5ef7e6 Reduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test module to avoid false-positive infinite loop reports from OSS-Fuzz based on long and complex fuzzer-generated LIKE/GLOB patterns that are not actually infinite loops, but which do take a long time to resolve. master drh 2025-10-19 17:30:07 +00:00
  • efe8ae567c Use 64-bit memory allocations everywhere in the expert extension. drh 2025-10-18 11:19:02 +00:00
  • 21c57abc53 Increase the range of integer indexes in the the merge() family of SQL functions. drh 2025-10-18 11:04:03 +00:00
  • 31c86ca0a8 Fix a minor memory leak in the CLI that can occur following an error in the ".output" dot-command. drh 2025-10-17 10:06:44 +00:00
  • 9f36870a77 Resolve the MacOS-specific build issue reported in [forum:95edc7a8d7d1de59|forum post 95edc7a8d7d1de59], with help from Bo Lindbergh. stephan 2025-10-16 23:42:39 +00:00
  • 2cf93f054d An attempted workaround for a MacOS-ism which causes the strchrnul() feature test to incorrectly pass though strchrnul() is not available. This new check works on Linux but is as-yet untested on the affected systems. See [forum:95edc7a8d7d1de59|forum post 95edc7a8d7d1de59]. strchrnul-feature-test stephan 2025-10-16 17:17:13 +00:00
  • 9c3fcd932d Improve performance of the shell tool ".ar" command when it is given a large number of arguments. dan 2025-10-16 14:17:30 +00:00
  • 0a585a64d2 In dbpage.c, disable truncation on any update error, including errors in sqlite3PagerWrite(). drh 2025-10-16 12:43:36 +00:00
  • 6eaeea0a3b Fix an off-by-one in c-pp-lite.c which could cause @token@-processed output to get one duplicated byte. stephan 2025-10-16 01:44:03 +00:00
  • e826aa8e00 Minor JS doc updates. No code changes. stephan 2025-10-15 23:28:31 +00:00
  • ff5d4c348c Resolve a valgrind-reported error in ext/wasm/c-pp-lite.c caused by successful exit colliding with the atexit() handler. Add -e SCRIPT support to c-pp-lite to facilitate testing. stephan 2025-10-15 23:13:50 +00:00
  • f66a0600d8 Improve performance of the shell tool ".ar" command when it is given a large number of arguments. ar-performance-improvement dan 2025-10-15 15:54:38 +00:00
  • 34c1e04cbf Fix memory allocation in the ".table" command of the .cli when the number of tables in the database file approaches 2 billion. drh 2025-10-15 10:52:45 +00:00
  • f83df5b150 Reestablish APIARMOR for the sqlite3_db_status() interface. drh 2025-10-14 19:21:46 +00:00
  • d6cb2ccee6 JS/WASM: Expose sqlite3_db_status64(), sqlite3changeset_apply_v3(), sqlite3changeset_apply_v3_strm(), and SQLITE_DBSTATUS_TEMPBUF_SPILL. stephan 2025-10-14 18:23:32 +00:00
  • e7cf3fe4c8 Add the test/testloadext.c loadable extension to test the ability to use the latest APIs using the loadable extension mechanism. drh 2025-10-14 17:50:55 +00:00
  • efde2f6059 Add the sqlite3_db_status64() interface and the SQLITE_DBSTATUS_TEMPSTORE_SPILL option for use in that interface. drh 2025-10-14 17:09:06 +00:00
  • 53a6b7d138 Make the new sqlite3_db_status64() API accessible to extensions. dbstatus-spill drh 2025-10-14 16:57:50 +00:00
  • 4472c967a6 Fix two links in ext/wasm/README.md. stephan 2025-10-14 14:07:58 +00:00
  • abe709be8d Extra defenses against integer overflow in the decimal extension. drh 2025-10-14 14:03:09 +00:00
  • 5dbbe50758 Add a section to ext/wasm/README.md about the dependency on wabt/wasm-strip for release builds. stephan 2025-10-14 13:47:40 +00:00
  • 9f136fc5ed Fix a makefile typo which caused a build directory to not get mkdir'd for the fiddle build. stephan 2025-10-14 13:25:02 +00:00
  • 898ac77f55 Merge all the latest trunk enhancements into the dbstatus-spill branch. drh 2025-10-14 11:18:45 +00:00
  • 264bcad69a Avoid integer overflows (a) when dealing with zeroblob(N) calls when 2*N is larger than 2^31, and (b) in fts5 when a corrupt record is close to 2^31 bytes in size. Both of these require special builds with SQLITE_MAX_LENGTH set to a non-default value. dan 2025-10-13 16:07:28 +00:00
  • a8bb50ce95 Fix a bug in concat_ws() in which an initial empty string was treated as if it was a NULL value. drh 2025-10-13 12:36:54 +00:00
  • c93270ebc7 Enable CLI documentation for .imposter drh 2025-10-13 10:35:59 +00:00
  • 94356039d0 Fix broken hyperlinks in the documentation. drh 2025-10-12 19:17:31 +00:00
  • ee4676b3f7 Fix order of operations in the OP_Concat operator of the byte-code engine to avoid any possibility of an integer overflow. drh 2025-10-12 10:31:34 +00:00
  • 637e1c7cc8 Merge trunk into the cygwin-fixes branch. With tcl9 this passes all but one test, which fails with: error copying ...: No error cygwin-fixes stephan 2025-10-11 20:06:54 +00:00
  • e4eaf174a5 Remove an unused variable from the generate_series implementation. drh 2025-10-11 18:44:54 +00:00
  • 59e1ab5576 Fix an assert() that could fail when reading a blob or text value larger than 1GiB from the database (requires a non-default build configuration). This is an assert() fix only, production builds were functioning correctly. dan 2025-10-11 16:23:22 +00:00
  • 11878165f6 Improvements to the (rarely used) home-grown varients of seriesCeil() and seriesFloor() based on ideas from [forum:/forumpost/2025-10-11T12:36:56z|forum post 2025-10-11T12:36:56z]. drh 2025-10-11 15:45:47 +00:00
  • 5013fd1f81 Provide alternative implementations of ceil() and floor() to the generate_series() function so that it will build even when SQLite is compiled using --disable-math. [forum:/forumpost/91690fa646|Forum post 91690fa646]. drh 2025-10-10 19:43:03 +00:00
  • fdddb454e5 Merge trunk and an off-list patch from Jan N. into the cygwin-fixes branch. stephan 2025-10-10 16:59:25 +00:00
  • eeb2e03b7b Back out [8bf26c956e]. It is not required following [8e7da8cf50]. dan 2025-10-10 16:04:19 +00:00
  • 80f0fcd31d Fix harmless compiler warnings. drh 2025-10-10 14:31:46 +00:00
  • 8c1670642d Makefile updates to suppose carray() and percentile(). Add Carray to the CLI and fuzzcheck to support debugging. drh 2025-10-10 14:22:05 +00:00
  • e33786f09a Regenerate autoconf/Makefile.msc to squelch a 'make test' warning. stephan 2025-10-10 14:00:27 +00:00
  • f9d511319b Fix the carrayfault.test script so that it works in configurations that do not support virtual tables. drh 2025-10-10 13:43:53 +00:00
  • ea0d2cebd9 Avoid (apparently harmless) undefined behavior in CARRAY if the rowid is used as a constraint in the WHERE clause. drh 2025-10-10 10:40:37 +00:00
  • 7b34ca9cc1 Fix the sqlite3_bind_blob() interface so that it sets the encoding of the underlying sqlite3_value object to the database encoding. Fix for the problem reported by [forum:/forumpost/2025-10-07T12:47:25z|forum post 2025-10-07T12:47:25z]. drh 2025-10-10 00:59:28 +00:00
  • 8080411752 Fix the xBestIndex method on carray so that it gives a coherient query plan in a join when some of the arguments to carray() come from other table in the join. drh 2025-10-10 00:26:46 +00:00
  • 97fa2fe414 Fix carrayfault.test so that it works with the new built-in CARRAY. drh 2025-10-09 19:23:01 +00:00
  • 6d4c7920b4 Merge trunk into the cygwin-fixes branch. It merges cleanly and builds fine (in 27m2s) but make test has many failures which look to be Windowsisms, related to locked and/or missing files. stephan 2025-10-09 18:37:49 +00:00
  • b4fdfc2f9a Update c-pp.c and rename it to c-pp-lite.c to match its new upstream name. Adapt the JS files and mkwasmbuilds.c for c-pp syntactic changes. stephan 2025-10-09 15:28:59 +00:00
  • 40d299ae32 Avoid corrupting the fts5 index if a value that was inserted via sqlite3_bind_blob() in a non-utf8 db is deleted. dan 2025-10-09 14:50:27 +00:00
  • 377c4a8bfe Update the result formatter spec such that column width are stored in 16-bit signed integers. resfmt drh 2025-10-09 14:14:14 +00:00
  • 0f5a3f16f3 In the CLI, limit column widths specified by the ".width" command to have an absolute value not more than 30,000. drh 2025-10-09 14:01:52 +00:00
  • 7ebd8a8d85 Add the pRender callback to the query result formatter spec. drh 2025-10-08 20:10:01 +00:00
  • f39a16c595 Merge the latest trunk enhancements into the resfmt branch. drh 2025-10-08 19:34:56 +00:00
  • 3be9a9b984 Move the carray() extension and the percentile extension into the amalgamation. Both are still turned off by default and must be enable using SQLITE_ENABLE_CARRAY and SQLITE_ENABLE_PERCENTILE compile-time options, so there is no increase in object code size. However, these extensions are now more easily available. drh 2025-10-08 19:01:00 +00:00
  • 8f2f5e4963 Add the SQLITE_ prefix to the type constants used by sqlite3_carray_bind(). ext-to-core drh 2025-10-08 18:51:15 +00:00
  • 0df9db4921 Make use of the new SQLITE_ENABLE_PERCENTILE in the wasm build. stephan 2025-10-08 18:17:19 +00:00
  • 01f5e6e757 Add ENABLE compile-time options to enable carray() and median(). Hence there is no new code and no increase in library size without the ENABLE macros. drh 2025-10-08 18:11:37 +00:00
  • ba5cce9f08 This is how the percentile() family of functions might be integrated into the amalgamation, should we elect to do such a thing. drh 2025-10-08 16:29:14 +00:00
  • cdaff852bf Were we to choose to integrate the carray() table-valued function into the amalgamation, that integration might look something like this. drh 2025-10-08 15:32:55 +00:00
  • e15ef5b756 Fix harmless integer overflow in the CLI when arguments to --lookaside are ridiculously large. drh 2025-10-08 12:37:01 +00:00
  • d3973778a1 Fix an uninitialized variable problem in test1.c. dan 2025-10-08 11:00:04 +00:00
  • 55085a2cc2 The ".dbtotxt" command in the CLI should not fail if the database is uninitialized. It should instead be a no-op. drh 2025-10-08 09:52:52 +00:00
  • b8d2ca1513 Function name doc typo fixes for sqlite3_source_id() (sic.). stephan 2025-10-08 02:05:15 +00:00
  • 6147a0f6a1 Add test cases for the carray module. dan 2025-10-07 21:02:37 +00:00
  • c02f8fdfe2 Initial prototype spec for the SQLite Query Result Formatter. drh 2025-10-07 20:11:19 +00:00
  • 308831d1c7 Improve the invariant checker module so that so that it added "+" before "column ISNULL" in queries where the base query contains a GROUP BY, to prevent the ISNULL term from being pushed down into the subquery, since that can cause ambiguities if column is UNIQUE. drh 2025-10-07 18:06:05 +00:00
  • 9b6bc61dbd Fix some integer overflow warnings in the base64 and base85 extensions. dan 2025-10-07 15:14:03 +00:00
  • 7aa5271c72 Fix a minor problem with building sqlite3.c without manifest.tags. dan 2025-10-06 20:11:18 +00:00
  • 9804ed7021 Avoid attempting to delete a file that is still open in sessionnoop2.test. dan 2025-10-06 17:52:52 +00:00
  • 75ef68e385 Avoid using randomblob() in walckptnoop.test, as it produces different results for different test permutations. dan 2025-10-06 17:20:26 +00:00
  • 35299c9076 Change the testrunner.tcl option from "--case" (singular) to "--cases". Allow the argument to be a glob pattern, to pick up multiple cases. drh 2025-10-06 16:57:49 +00:00
  • 87f53152ed Fix typo in the previous check-in that prevented the script from running. testrunner-enhancements drh 2025-10-06 16:56:12 +00:00
  • 6f7c977ed9 Add info from the SQLITE_SCM_... macros to tool/version-info.c's --json output, prompted by [forum:0c513ae3fca7d55c|forum post 0c513ae3fc]. stephan 2025-10-06 16:54:45 +00:00
  • ad7118fa68 Update testrunner.tcl so that the new option is --cases rather than singular --case, and so that it is a glob pattern. drh 2025-10-06 16:50:37 +00:00
  • 0ab87fc9a7 Fix typo in the "testprefix" for walckptnoop.test drh 2025-10-06 16:23:31 +00:00
  • 0611aeeed4 New testrunner.tcl option "--case DISPLAYLNAME" only runs the single case (and its build dependencies) that exactly matches DISPLAYNAME. drh 2025-10-06 15:53:52 +00:00
  • 566348f68b Fix testrunner.tcl so that --help output goes to stdout, not stderr. drh 2025-10-06 14:30:22 +00:00
  • d357d9d1cd Fix a subtle problem with short-circuit evaluation introduced by [cea8bf79e18d55a8] and detected by the dbsqlfuzz fuzzer. Test cases in TH3. drh 2025-10-06 11:50:35 +00:00
  • 833fb1ef59 Another small performance increase in the text format by using strchr() to search for '%'. drh 2025-10-05 22:41:32 +00:00
  • 34775b696b Fix a syntax error in the tcl script part of [199b6567bb41cd]. stephan 2025-10-05 19:56:57 +00:00
  • d310393158 Performance optimization in text formatter by using a hash table to look up the operator character that follows %-subsitutions. drh 2025-10-05 19:30:05 +00:00
  • 5440c09042 Add a test case to ensure that committing a concurrent transaction fails with SQLITE_BUSY, subsequent attempts to commit the transaction also fail. bedrock dan 2025-10-04 17:28:29 +00:00
  • 275d08ad62 Minor clarifications to the JSONB format documentation. drh 2025-10-03 18:17:13 +00:00
  • 1d574d3d71 Remove the memvfs.c extension, to prevent it from being misused. See [forum:/forumpost/91811439aa|forum post 91811439aa] for the complaint that prompted me to take down this demonstration code. I have other things to do rather than argue about posts such as the foregoing, so it is easier to just take the code down. If you need this code, you can downloading older check-ins. The beauty of DAG-based version control systems like Fossil (and Git) is that nothing is ever lost; it is just stops appearing on trunk. drh 2025-10-02 22:48:08 +00:00
  • e2ebc364cd Fix typo in the previous check-in. Remove surplus end-of-line whitespace from the ext/misc/fossildelta.c extension. drh 2025-10-02 19:35:58 +00:00
  • 0d9ec8b2ee Harden the debugging vtab "delta_parse()" which is part of the ext/misc/fossildelta.c extension against malicious inputs. [forum:/forumpost/be139437c3|forum post be139437c3]. drh 2025-10-02 19:19:40 +00:00
  • 4defad2f29 In the ".open" command of the CLI if using the --new option with a URI filename, then decode the URI to extract the actual filename prior to trying to delete that file. drh 2025-10-02 18:31:19 +00:00
  • 064a1aa308 Fix harmless compiler warnings. alter-table-constraints drh 2025-10-02 16:14:25 +00:00
  • 9abd7edaa7 Merge recent trunk fixes and enhancements into the alter-table-constraints branch. drh 2025-10-02 15:30:26 +00:00
  • 7d973ac52f Fix -DSQLITE_OS_OTHER=0 builds. dan 2025-10-02 14:48:27 +00:00
  • b9c23fa541 Correction to [ae303dab2f534e2c] to use the right loop over the solver. drh 2025-10-02 11:28:27 +00:00
  • cbc3cd47f0 Fix a buffer overrun in the zipfile extension that could occur while processing zip archives with extremely long file-names and comment fields. dan 2025-10-02 11:16:22 +00:00
  • fa563eff1d Add the --ifexists option to the CLI and to the ".open" command of the CLI. Also the undocumented and unsupported --exclusive option on the same. drh 2025-10-01 20:41:02 +00:00
  • 65ee59bb26 Prevent embedded 0x00 characters in the output strings from confusing the completion extension and causing it to read past the end of an array. [forum:/forumpost/88a08b3201|Forum post 88a08b3201]. drh 2025-10-01 19:01:19 +00:00
  • d802904c8a Fix some problems with DROP CONSTRAINT and DROP NOT NULL on generated columns. dan 2025-10-01 17:27:23 +00:00
  • a9af4102f1 Fix a buffer overread in demo code in ext/misc/memvfs.c. dan 2025-10-01 14:28:48 +00:00
  • f07e922932 Merge the latest trunk enhancements into the reuse-schema branch. reuse-schema drh 2025-09-30 19:56:38 +00:00
  • e799c0f08b Merge the latest trunk enhancements into the bedrock branch. drh 2025-09-30 19:45:46 +00:00
  • e7b5d785a5 Merge the latest trunk enhancements into the wal2 branch. wal2 drh 2025-09-30 19:35:45 +00:00
  • cddc716d9d Merge the latest trunk enhancements into the begin-concurrent branch. begin-concurrent drh 2025-09-30 19:28:17 +00:00
  • c592b7e01d Fix handling of FK constraints that immediately follow named table constraints in DROP CONSTRAINT. dan 2025-09-30 19:20:53 +00:00
  • 4af7048aeb Enable the CLI to be compiled with SQLITE_OMIT_AUTHORIZATION. drh 2025-09-30 19:11:00 +00:00
  • 0f76b0a4d6 Fix various compiler warnings. drh 2025-09-30 17:37:18 +00:00