bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
31,731 Commits 1,672 Branches 385 Tags
master
Commit Graph

20055 Commits

Author SHA1 Message Date
stephan
6af10b0efd Refactor the uint128 type check to consolidate duplicated rules. 
FossilOrigin-Name: 362ef7bc00eea180fb3458bd8887021aed54e321901483edc00ad6b23a33d8e5
 2026-04-27 06:48:07 +00:00
stephan
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. 
FossilOrigin-Name: c4a2c20839ef75534d71d928a03ad276bdc488b0baa76c1505f48dc1ff0bcdd1
 2026-04-27 05:55:38 +00:00
drh
74006fdcdb Improvements to temp-file cleanup on close in the CLI. 
FossilOrigin-Name: 048c969c34eaaf8c203b996e999a7dbc94c47b4959719af9e6625052520f7135
 2026-04-26 18:35:26 +00:00
drh
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.

FossilOrigin-Name: 4e9ee211ca661fe8978b7f676f33ef962ff5c8177bc7c5ad42b19a2fa4482d90
 2026-04-25 16:17:23 +00:00
drh
39b2fe7e5b Simplify the modePush()/modePop() implementation in the CLI. 
FossilOrigin-Name: 92cad2cd7284d3a969b713336865007da2b0b2a8eef367d4185802174cbd027a
 2026-04-25 15:05:46 +00:00
drh
df7b22790e Minor code simplification in the CLI. 
FossilOrigin-Name: 59795c71e5745e8a27dc596b9f1fc8f137df58a6ec8d8d0dab2b31cf8562796d
 2026-04-25 10:45:17 +00:00
drh
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.

FossilOrigin-Name: 4a5cac1d00e1fa287ab8ce3437c0152a9f362d72bdb9976889c93f6368b3fd66
 2026-04-25 00:29:40 +00:00
drh
d7bf8233ff Fix test cases due to recent CLI default prompt changes. Make sure ANSI 
escape codes are recognized on Windows terminals.

FossilOrigin-Name: 22b791e404f0895b0f343b2ce0e169a7ada8578e46a39a9f4bd3a31f81c9853c
 2026-04-24 20:27:42 +00:00
drh
455486bbc4 Improvements to the default prompt for the CLI. 
FossilOrigin-Name: 9ab0bb487f78ba5a51cd3b4efcee23b11096e90ebf3add4da18aea657e8de0b6
 2026-04-24 09:21:25 +00:00
drh
ba9092e228 Improved default prompt in the CLI. 
FossilOrigin-Name: 78193b60346dba304485241dd65f0eb6e971714397b76191b3bf7a5fdb44916b
 2026-04-23 22:15:18 +00:00
drh
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.

FossilOrigin-Name: 354ce4f5e2a86b621b2058a6372495a5919cf3dc88ce1ed3637642f720c48002
 2026-04-23 20:13:14 +00:00
drh
323b3fc121 Fix a bug in [dbc1d6f0a3452607] that disrupts the display when running 
on a Windows console (not redirecting to a file).

FossilOrigin-Name: 75b5df2b0046827e985712b5725488b59667e2cfd171cde9f1194f2917165205
 2026-04-23 20:06:16 +00:00
drh
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.

FossilOrigin-Name: e5f8840d11c1863cfc5c0b4a3d16c9ec9ab6ca6ecb7ff1a3a9a237715eed5d30
 2026-04-23 16:40:34 +00:00
drh
ed95a9d103 New CLI prompt escape sequences: /r, /A, /v, /V, and /D../D. 
FossilOrigin-Name: e7c7acd1a4e5cb0f8e68f119352480c1aa9dd3c2b289c92f88e9e697a2e440e0
 2026-04-23 15:05:46 +00:00
drh
e791e7c7a0 Fix harmless compiler warning. 
FossilOrigin-Name: 706373dcbe43752cf21604f278f96fb3015a36089ad64f069bb3a64bc526d137
 2026-04-23 14:49:21 +00:00
stephan
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]. 
FossilOrigin-Name: 3fa0500b964869c45f7b49717680b791049f7cd8c47a06a337dd22351d2002f9
 2026-04-23 14:05:36 +00:00
dan
68b07ddd41 Add OOM test for the new code on this branch. 
FossilOrigin-Name: 685be705a2a69e79de0d581e5bbe9d942133817342121786a551d95d59a4af6c
 2026-04-22 19:25:12 +00:00
drh
4b69e7704b Mark branches that are believed to be unreachable. 
FossilOrigin-Name: 18ed9736fbbea762e04b8ad156e83e577e60c5234a5e233540ad8664fe3b379c
 2026-04-22 19:12:48 +00:00
dan
e17ab401f0 Instead of adding a branch to OP_IdxInsert, use an extra OP_IfNull when updating indexes on expressions. 
FossilOrigin-Name: 5112f96cb1428693614b91bcca78326fccf7289e395a920339676ceeba871e3f
 2026-04-22 18:19:24 +00:00
dan
57ee077c5e Enable the optimization on this branch for indexes on expressions only. 
FossilOrigin-Name: 3576b6930436b3149c5033476f70518e9b4adeaeec2538a68b7dc599eb854c47
 2026-04-22 17:50:50 +00:00
dan
c7edd22456 Fix P3/P5 confusion in the comment above OP_IdxDelete. 
FossilOrigin-Name: 0fb6ca8e22f355838a02223dd24b34c0669a6cc0b7ac80931c721db72cf5c1c8
 2026-04-22 17:31:19 +00:00
dan
8606a52934 Detect and omit cases where an index key is being replaced with an identical key. 
FossilOrigin-Name: 7a01caf0d0864a462eb81b7643dcf89048f4ae56a29d762f0cfc38066218504f
 2026-04-22 16:58:36 +00:00
drh
429369f4aa QRF and the CLI preserve zero bytes when outputing unformatted BLOB values. 
FossilOrigin-Name: dbc1d6f0a3452607e4e92155df0fdb1c5ea4ea5ad1654664f86383faf6c105ef
 2026-04-22 12:22:32 +00:00
dan
c4c47a49a8 Disable optimization of nested EXIST loops. Possible fix for [forum:/forumpost/077c02e8ed | forum post 77c02e8ed]. 
FossilOrigin-Name: d0d95a39bc211034071746395ee6dbcfbea9d573d27480655391ba9698f7e214
 2026-04-21 20:40:22 +00:00
drh
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.

FossilOrigin-Name: 2d1d2947b28f5dcbf4c66b594e176038c4e71e61948a88db565c1cb1212657ce
 2026-04-21 20:28:38 +00:00
dan
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]. 
FossilOrigin-Name: 9387238cb0bb2651c64ecb229072df039577d71fd91546a2f0c94ca9755bf25d
 2026-04-21 18:07:04 +00:00
dan
30af54043e Disable optimization of nested EXIST loops. Possible fix for [forum:/forumpost/077c02e8ed | forum post 77c02e8ed]. 
FossilOrigin-Name: 64f0d9eb63a351de12bb9643f1f6390a89f6d95dc81c07f1dc409ee31bae6f83
 2026-04-21 16:40:08 +00:00
drh
532ed30ab2 Do not unnecessarily delay opening the database file in the CLI. 
FossilOrigin-Name: ab6ee76c1266b753d0749c63890f40db875536ceb4dd3252cc7a3386e386a0c1
 2026-04-21 14:39:23 +00:00
drh
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].

FossilOrigin-Name: 1dd3c6a5e50ac3f617683678223e42f48636c17e58905506c5c74cc4bf05845c
 2026-04-21 12:59:43 +00:00
drh
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.

FossilOrigin-Name: 6124d27a33f4562f40777c2c6318d61709f7b481f23f9ade45064d8ad0700752
 2026-04-18 12:31:53 +00:00
drh
29997b4731 Help-text and comment fixes in the CLI. Add the output-redir-test.txt 
testing script.

FossilOrigin-Name: ec58a133b4716d4f5a53c38853f8ecdb7a1275b931663ce07c8dc700d845e62e
 2026-04-17 11:41:33 +00:00
drh
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].

FossilOrigin-Name: b235a8093734f457c2731af017c99027510d04e5cd1060f5559afbec5409a472
 2026-04-17 01:50:40 +00:00
drh
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.

FossilOrigin-Name: cb910047edc591102dd4ed0d57c863b366981b8aa1d3085d5f95b1fbbabf6c31
 2026-04-15 14:41:25 +00:00
drh
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.

FossilOrigin-Name: 92d8ac0c4938e43b00111b43630ecfa91c30e5200ca03937a84f4b50bd1a13b3
 2026-04-15 14:17:58 +00:00
drh
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.

FossilOrigin-Name: 4c4988e56df3c668b8891e2a55887a6618f5b84e9111e562b93059ddb9a662dc
 2026-04-15 12:20:11 +00:00
drh
84c1079220 Add a missing open_db() call in the new ".dbstat" command of the CLI. 
FossilOrigin-Name: a138e44a243466f8679e9652421f8c893a4a1bc0addc86736588d9aee51cf090
 2026-04-15 11:58:54 +00:00
drh
c8d866294b Add the .dbstat command to the CLI. 
FossilOrigin-Name: fdba76df2b3a5b4d56ba79f80fd8b16d5faebca1fb07a266262be2ea635e6f94
 2026-04-15 11:41:50 +00:00
dan
c71e6dd054 Handle the case where the name of the constraint in an "ALTER TABLE DROP CONSTRAINT" command is quoted. [forum:8bfbaec404 | Forum post 8bfbaec404]. 
FossilOrigin-Name: 7f5afb12f4a5d35cfe6b95f17d85ce85ce62159515bfe26fb9c67d3ce26b6d4a
 2026-04-15 11:07:58 +00:00
stephan
afef1f2923 Minor doc typo fixes contributed by BrickViking. 
FossilOrigin-Name: c4660ce205919ce0d9262e7fd7879375a72ef65d9e5ac97f19caf5dc36e355aa
 2026-04-14 23:53:38 +00:00
drh
57ed7f322f Check-in [495e4851d4296b49] breaks the build for Windows. Fixed here. 
FossilOrigin-Name: 5b004348c3ec15a02dd657b3619502b6f8ba1c6f46918108b3de9534622076a0
 2026-04-14 18:06:41 +00:00
drh
d20673a95f Fix typos and inaccuracies in comments. No changes to code. 
FossilOrigin-Name: a6c2d7ce84f4f5f8a82cc566a27f98f5418f251e87f1f264ae57935fb10399f7
 2026-04-13 17:33:34 +00:00
drh
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.

FossilOrigin-Name: 495e4851d4296b49a37b963edd8410314de1510b2ae0b9dbe9dc0307c466c3b5
 2026-04-13 12:22:16 +00:00
drh
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.

FossilOrigin-Name: efb3e808a0281014512a812920d526a4909467e925ea000956606318bb6f2e65
 2026-04-13 11:34:15 +00:00
stephan
20079bb358 Doc typo fix which broke the docsrc build, reported by BrickViking. 
FossilOrigin-Name: 3c212b5d85338f90a5f1a2d1484e54c0bf699eedef19a16f4c0de76a76dd9d07
 2026-04-12 17:47:57 +00:00
drh
3d6fa49c54 Bug fix in the revised ".prompt" command of the CLI, with test cases. 
FossilOrigin-Name: 7583385593354f90a9818d1820543841109f253dffcec5ca5ed7629336e29fac
 2026-04-12 10:46:35 +00:00
stephan
4df365e5a7 Fix a typo which causes .headers to not show up in the shell's .help. 
FossilOrigin-Name: d379b14a48d331933240fb99ab43c3cc978638d7ad0a8d5975bb211a72eaef2b
 2026-04-12 05:41:28 +00:00
drh
9d8bf6f04a Change the prompt escape design yet again, to use / as the escape character, 
since % and just about every other punctuation character is special to
cmd.exe, batch files, and nmake, on Windows.

FossilOrigin-Name: 79a8d3edf8207d72f0c4650272ee239a1c7783a07f907fbf0cf5a7ad99b27a2a
 2026-04-11 23:58:15 +00:00
drh
c0026ff7a6 CLI prompt design change: The escape character is changed from \ to 
%#37;.  This avoids lots of quoting problems when trying to specify prompt
strings in various programming languages and shells.

FossilOrigin-Name: e7e6ecc45dfe1a163d259be26877bd7e528ce154e73b3ca8ab7edc5aa94d2d02
 2026-04-11 22:58:25 +00:00
drh
1e3f888acf Two C-preprocessor macros SQLITE_PS1 and SQLITE_PS2 can be set to override 
the default prompt strings in the CLI.

FossilOrigin-Name: 6fa0216a19c2f165110121227d3f9b9119369f8cd61f9c6d13eaa1ae42a60d60
 2026-04-11 22:18:05 +00:00
drh
2d4dfbccdc Make sqlite3_incomplete() available to extensions. 
FossilOrigin-Name: 50d81300ba0f021f388aab1e86e97d688ed762cee408c610cf70977f7b488803
 2026-04-11 20:53:53 +00:00