bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • 6af10b0efd Refactor the uint128 type check to consolidate duplicated rules. master stephan 2026-04-27 06:48:07 +00:00
  • 70d1e3e75e Feature detection fix for uint128 on RISCV 32-bit, reported in [forum:f8d1417ce8eb2f22|forum post 2026-04-26T11:41:01Z] and validated by the OP. stephan 2026-04-27 05:55:38 +00:00
  • 74006fdcdb Improvements to temp-file cleanup on close in the CLI. drh 2026-04-26 18:35:26 +00:00
  • 4b9f9d6794 In the CLI, eliminate the 2-second delay before getting the prompt back after running a ".www" or ".excel". Instead, remember the name of the temporary file that is to be deleted and delete it later. drh 2026-04-25 16:17:23 +00:00
  • 39b2fe7e5b Simplify the modePush()/modePop() implementation in the CLI. drh 2026-04-25 15:05:46 +00:00
  • 2ba7864bc4 Fix a single-byte OOB read that could occur in the session module when concatenating patchsets. branch-3.53 drh 2026-04-25 15:04:21 +00:00
  • 01ec60bb87 Do not run expridx2.test as part of the "journaltest" permutation, as it requires wal mode. dan 2026-04-25 14:32:05 +00:00
  • e2dbd0a578 Fix a single-byte OOB read that could occur in the session module when concatenating patchsets. dan 2026-04-25 14:00:29 +00:00
  • df7b22790e Minor code simplification in the CLI. drh 2026-04-25 10:45:17 +00:00
  • 50811f74e0 Fix a problem in the CLI in which the ".www" command followed by ".dbstat" does not restore the mode to its original setting afterwards. drh 2026-04-25 00:29:40 +00:00
  • d7bf8233ff Fix test cases due to recent CLI default prompt changes. Make sure ANSI escape codes are recognized on Windows terminals. drh 2026-04-24 20:27:42 +00:00
  • 455486bbc4 Improvements to the default prompt for the CLI. drh 2026-04-24 09:21:25 +00:00
  • ba9092e228 Improved default prompt in the CLI. drh 2026-04-23 22:15:18 +00:00
  • 67d4e0226f Fix harmless compiler warnings. Enhance the CLI prompt mechanism to make it more easily reusable by other projects, and to add the /h, /H, and /u escape sequences. drh 2026-04-23 20:13:14 +00:00
  • 323b3fc121 Fix a bug in [dbc1d6f0a3452607] that disrupts the display when running on a Windows console (not redirecting to a file). drh 2026-04-23 20:06:16 +00:00
  • 78279e2550 Improvements to the #define mechanism in the CLI that allows other programs that incorporate the shell.c source file to customize some of the prompt expansions. drh 2026-04-23 16:40:34 +00:00
  • 4e4962f6b3 Have testrunner.tcl return a non-zero exit status if one or more tests have failed. dan 2026-04-23 15:54:00 +00:00
  • ed95a9d103 New CLI prompt escape sequences: /r, /A, /v, /V, and /D../D. drh 2026-04-23 15:05:46 +00:00
  • e791e7c7a0 Fix harmless compiler warning. drh 2026-04-23 14:49:21 +00:00
  • 2545d9c201 CLI shell: handle the special case of .prompt "" to not incorrectly report that as an OOM. Reported [https://fossil-scm.org/forum/forumpost/ca277be73a|in the Fossil SCM forum]. stephan 2026-04-23 14:05:36 +00:00
  • 2114d8bbd2 Update interrupt2.test to avoid using Tcl_GetCommandInfo() from within calls to Tcl_DeleteCommand(). dan 2026-04-23 11:33:26 +00:00
  • c483232c7a Merge trunk enhancements into the reuse-schema branch. reuse-schema drh 2026-04-22 20:02:56 +00:00
  • f7f7956ff5 Merge recent trunk enhancements into bedrock via wal2. bedrock drh 2026-04-22 19:51:26 +00:00
  • 1768ec5ba7 Merge recent trunk enhancements into the begin-concurrent branch. begin-concurrent drh 2026-04-22 19:50:38 +00:00
  • b23a628422 Merge the latest trunk enhancements into the wal2 branch. wal2 drh 2026-04-22 19:47:59 +00:00
  • 2a07c6de2c When updating indexes on expressions, omit the update if the new indexed values are the same as the old. dan 2026-04-22 19:38:04 +00:00
  • 68b07ddd41 Add OOM test for the new code on this branch. index-detect-noop dan 2026-04-22 19:25:12 +00:00
  • 4b69e7704b Mark branches that are believed to be unreachable. drh 2026-04-22 19:12:48 +00:00
  • e17ab401f0 Instead of adding a branch to OP_IdxInsert, use an extra OP_IfNull when updating indexes on expressions. dan 2026-04-22 18:19:24 +00:00
  • 57ee077c5e Enable the optimization on this branch for indexes on expressions only. dan 2026-04-22 17:50:50 +00:00
  • c7edd22456 Fix P3/P5 confusion in the comment above OP_IdxDelete. dan 2026-04-22 17:31:19 +00:00
  • 8606a52934 Detect and omit cases where an index key is being replaced with an identical key. dan 2026-04-22 16:58:36 +00:00
  • 5c6404aa77 Fix a integer type bug in the previous check-in. drh 2026-04-22 13:41:20 +00:00
  • 429369f4aa QRF and the CLI preserve zero bytes when outputing unformatted BLOB values. drh 2026-04-22 12:22:32 +00:00
  • 928890f18f Various minor bug fixes cherrypicked from trunk. drh 2026-04-21 22:55:44 +00:00
  • 9529894a29 Fix harmless compiler warning in QRF. drh 2026-04-21 22:19:38 +00:00
  • c4c47a49a8 Disable optimization of nested EXIST loops. Possible fix for [forum:/forumpost/077c02e8ed | forum post 77c02e8ed]. dan 2026-04-21 20:40:22 +00:00
  • ee7f6f29fc Fix the BETWEEN operator so that it propagates the EP_Subquery, EP_Collate, and EP_HasFunc flags in the expression tree, as it ought. Fix for the problem reported at [forum:/forumpost/2026-04-21T19:10:55Z|forum post 2026-04-21T19:10:55Z] and probably a bunch of other problems too. This has been incorrect for a long time. drh 2026-04-21 20:28:38 +00:00
  • c3b52dff53 Correctly dequote the constraint name passed to ALTER TABLE DROP CONSTRAINT. This improves upon the partial fix in [7f5afb12f4]. Forum post [forum:/forumpost/a746b08b87 | a746b08b87]. dan 2026-04-21 18:07:04 +00:00
  • 30af54043e Disable optimization of nested EXIST loops. Possible fix for [forum:/forumpost/077c02e8ed | forum post 77c02e8ed]. disable-nested-exist-opt dan 2026-04-21 16:40:08 +00:00
  • 4ebed2a4e5 Fix an off-by-one buffer size calculation in the decimal.c extension. drh 2026-04-21 16:07:15 +00:00
  • 532ed30ab2 Do not unnecessarily delay opening the database file in the CLI. drh 2026-04-21 14:39:23 +00:00
  • 7b3ed290d3 Fix another bug in EXISTS-to-JOIN - this one having to do with an OFFSET clause of a LIMIT. drh 2026-04-21 13:06:15 +00:00
  • 5e99eeb3d8 Fix another bug in [/info/e33da6d5dc964db8|EXISTS-to-JOIN] - this one having to do with an OFFSET clause of a LIMIT. Reported by [forum:/forumpost/2026-04-21T10:57:09Z|forum post 2026-04-21T10:57:09Z]. drh 2026-04-21 12:59:43 +00:00
  • a9b8238b2c Experimental changes to star-query planning heuristics. star-query-experimental drh 2026-04-21 11:01:00 +00:00
  • d3abfd77f5 Reformulate how the OPFS async proxy Worker is loaded for the bundler-friendly builds to work around a bug in Vite in which it incompatibly rewrites the Worker's URL arguments. Addresses the discussion at [https://github.com/sqlite/sqlite-wasm/pull/159|npm package PR 159] and patch validated by Jure Rotar. stephan 2026-04-21 10:19:38 +00:00
  • 002226b549 Reformulate how the OPFS async proxy Worker is loaded for the bundler-friendly builds to work around a bug in Vite in which it incompatibly rewrites the Worker's URL arguments. Addresses the discussion at [https://github.com/sqlite/sqlite-wasm/pull/159|npm package PR 159] and patch validated by Jure Rotar. stephan 2026-04-21 10:15:16 +00:00
  • 63984b6ab7 Fix the fileio extension for Windows builds so that it does not depend on the sqlite3_win32_utf8_to_unicode() and sqlite3_win32_unicode_to_utf() routines that are found in the SQLite core. [forum:/forumpost/2026-04-20T02:02:56Z|Forum post 2026-04-20T02:02:56Z]. drh 2026-04-20 10:28:19 +00:00
  • 93082e5589 Fix a harmless compiler warning in test/speedtest1.c. drh 2026-04-18 21:51:32 +00:00
  • f6b807a022 Performance improvement in the substr() and length() SQL functions. Caution: The new code may give different results for malformed UTF8. I do not consider that to be a problem by the GI/GO principle. drh 2026-04-18 12:31:53 +00:00
  • 8c6a6b85db Fix a test case that started failing due to a change in the help text for the ".prompt" command of the CLI. drh 2026-04-17 19:12:27 +00:00
  • 9f76fb019e Update interrupt2.test to avoid using Tcl_GetCommandInfo() from within calls to Tcl_DeleteCommand(). dan 2026-04-17 15:09:50 +00:00
  • 29997b4731 Help-text and comment fixes in the CLI. Add the output-redir-test.txt testing script. drh 2026-04-17 11:41:33 +00:00
  • 7ad112014b On platforms which support ./configure --with-icu-config, ensure that 'make tclextension' includes the ICU pieces in the tcl extension. Intended to resolve [forum:92a88de4b88929fe|forum post 92a88de4b88929fe]. stephan 2026-04-17 04:59:42 +00:00
  • f9c7f9fb52 Fix parsing of options to the .once command. drh 2026-04-17 01:55:29 +00:00
  • f0c8e27670 Less error-prone parsing of ".once" options. Fix for the problem reported by [forum:/info/2026-04-17T01:26:56Z|forum post 2026-04-17T01:26:56Z]. drh 2026-04-17 01:50:40 +00:00
  • d6c985ad0b Fix testrunner.tcl so that it does not create directories with names ending in "sqlite3.o" or "sqlite3.lo". Use "sqlite3obj" for those directory names instead. Otherwise "make clean" gets confused. drh 2026-04-16 19:50:52 +00:00
  • 1696740fdc Improved comments explaining the logic, and improved diagnostic messages when testrunner.tcl encounters trouble loading the sqlite3 extension. drh 2026-04-16 19:33:04 +00:00
  • 2cefd5954a Minor updates to testrunner documentation. drh 2026-04-16 17:07:23 +00:00
  • 8895c50403 Run C-language tests in tests/c/ as part of release test. dan 2026-04-16 16:43:32 +00:00
  • 3d28ab6698 Tentatively change the name of the new ".dbstat" dot-command to ".inspect" as suggested by [forum:/info/2026-04-15T01:09:41|forum post 2026-04-15T01:09:41] dbstat-to-inspect drh 2026-04-16 13:07:22 +00:00
  • 02bd4aa037 Version number to 3.53.1 drh 2026-04-15 19:09:34 +00:00
  • 8113b83c01 Handle a special case of a corrupt changeset in sqlite3changegroup_add(). dan 2026-04-15 17:13:42 +00:00
  • 4c6c2ed134 Handle the case where the name of the constraint in an "ALTER TABLE DROP CONSTRAINT" command is quoted. [forum:8bfbaec404 | Forum post 8bfbaec404]. dan 2026-04-15 16:22:59 +00:00
  • a2116f86b0 The sqlite3_str_new() interface never returns NULL, even after an OOM. Code that uses that interface should invoke sqlite3_str_errcode() to see if an OOM has occurred. drh 2026-04-15 14:41:25 +00:00
  • df330b6f92 Bug fix in sqlite3_str_free(): Do not crash if called on an sqlite3_str object returned from sqlite3_str_new() following an OOM. drh 2026-04-15 14:22:35 +00:00
  • 1e472f2d32 Bug fix in sqlite3_str_free(): Do not crash if called on an sqlite3_str object returned from sqlite3_str_new() following an OOM. drh 2026-04-15 14:17:58 +00:00
  • e3dbf75160 Add support for the analyze() extension function to the fuzzcheck test program. drh 2026-04-15 13:05:43 +00:00
  • ade9289540 Improve the analyze() extension so that it returns a simple error message as text (it does not throw an error) if the database is empty or is "temp" or does not exist. drh 2026-04-15 12:47:37 +00:00
  • dfba4eb34a Fix harmless compiler warnings seen by MSVC in the previous check-in. Also add ext/misc/analyze.c to the makefile dependencies for the CLI. drh 2026-04-15 12:35:23 +00:00
  • b57d2a5a51 Add the analyze() SQL function implemented the ext/misc/analyze.c extension (but not part of the amalgamation). Make that function available in the CLI and add a new ".dbinfo" command to the CLI using that function. drh 2026-04-15 12:20:11 +00:00
  • 84c1079220 Add a missing open_db() call in the new ".dbstat" command of the CLI. analyze-sql-func drh 2026-04-15 11:58:54 +00:00
  • c8d866294b Add the .dbstat command to the CLI. drh 2026-04-15 11:41:50 +00:00
  • f0baddb205 On platforms which support ./configure --with-icu-config, ensure that 'make tclextension' includes the ICU pieces in the tcl extension. Intended to resolve [forum:92a88de4b88929fe|forum post 92a88de4b88929fe]. stephan 2026-04-15 11:40:13 +00:00
  • ec2ea68d1f Avoid a potentially undefined left-shift in the fts5 porter tokenizer. dan 2026-04-15 11:23:30 +00:00
  • c71e6dd054 Handle the case where the name of the constraint in an "ALTER TABLE DROP CONSTRAINT" command is quoted. [forum:8bfbaec404 | Forum post 8bfbaec404]. dan 2026-04-15 11:07:58 +00:00
  • 9efde40a5d Compute the average fanout for b-trees of depth 2 or more. drh 2026-04-15 10:49:14 +00:00
  • afef1f2923 Minor doc typo fixes contributed by BrickViking. stephan 2026-04-14 23:53:38 +00:00
  • 09f37099a7 Code simplifications. Return NULL is the specified SCHEMA does not exist. drh 2026-04-14 23:19:02 +00:00
  • 846fbd6653 Handle a special case of a corrupt changeset in sqlite3changegroup_add(). dan 2026-04-14 20:18:54 +00:00
  • 1b14a925dc Have the session module detect some corrupt changesets earlier. corrupt-changeset_fix dan 2026-04-14 20:17:41 +00:00
  • 526acc1834 Merge trunk enhancements and fixes into the analyze-sql-func branch. drh 2026-04-14 20:17:03 +00:00
  • d962afef2d Various minor tweaks and refinements to the analyze() function. drh 2026-04-14 20:07:29 +00:00
  • 839433d457 Handle a special case of a corrupt changeset in sqlite3changegroup_add(). dan 2026-04-14 20:02:49 +00:00
  • 395ac6c1bc Implementation of the analyze() SQL function is now mostly complete. drh 2026-04-14 19:36:33 +00:00
  • e9d0bc6b68 Much, but not all, of the report generation is added. An incremental check-in. drh 2026-04-14 19:02:40 +00:00
  • 483f0ef13c Ensure c-tests use the locally built sqlite3.h file, not the system copy. c-tests dan 2026-04-14 18:12:09 +00:00
  • ab6a63ec67 In RBU vacuum commands, do as SQLite does and ignore any trailing SQL statements in the sql column of the sqlite_schema table. dan 2026-04-14 18:08:30 +00:00
  • 57ed7f322f Check-in [495e4851d4296b49] breaks the build for Windows. Fixed here. drh 2026-04-14 18:06:41 +00:00
  • 34c2c8dc47 Further fixes and clarifications. Now ready to start generating the actual report. drh 2026-04-14 13:18:04 +00:00
  • 3f9df1f5fb Further improvements to error messages and robustness. drh 2026-04-14 12:46:12 +00:00
  • 2eeac123c8 Improved error messages and robustness. drh 2026-04-14 12:23:11 +00:00
  • 64a123a216 Initial prototype implementation of a new run-time loadable SQL function to do approximately the same work as sqlite3_analyze. drh 2026-04-14 11:25:22 +00:00
  • a10e79d91a Minor README typo fix reported off-list by BrickViking. stephan 2026-04-14 02:09:43 +00:00
  • 6e93d28950 Pass the ICU-related build flags through the 'tclextension' target, not just 'tclextension-install'. tclextension-icu stephan 2026-04-14 00:48:34 +00:00
  • 008395614a Tweak 'make tclextension' to pass on any --with-icu-config build flags so that it can link with the various ICU libs. This works for me but needs testing on a wider selection of systems before being moved to trunk. Intended to resolve [forum:92a88de4b88929fe|forum post 92a88de4b88929fe]. stephan 2026-04-14 00:11:23 +00:00
  • d20673a95f Fix typos and inaccuracies in comments. No changes to code. drh 2026-04-13 17:33:34 +00:00
  • f02d100e08 ".prompt" command improvements in the CLI: Guard against mistakenly saying ".prompt show" without the "--" before "show". Add the --hard-reset option to .prompt to make it more easily testable. drh 2026-04-13 12:22:16 +00:00
  • 4c8f0621fd Improvements to the prompt_filename() function in the CLI so that it finds the database filename even if the connection is not yet fully open. drh 2026-04-13 11:34:15 +00:00
  • dd1e2c39bc Update test/c/snprintf1.c to test the result of the sqlite3_snprintf() call. Also add an SQLITE_OMIT_AUTOINIT configuration and update C tests to account for it. dan 2026-04-13 11:20:51 +00:00