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

10131 Commits

Author SHA1 Message Date
dan
01ec60bb87 Do not run expridx2.test as part of the "journaltest" permutation, as it requires wal mode. 
FossilOrigin-Name: 11cfbae735669776c967522294b1606af90b4bd5379e2e1ed722520887b57757
 2026-04-25 14:32:05 +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
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
dan
4e4962f6b3 Have testrunner.tcl return a non-zero exit status if one or more tests have failed. 
FossilOrigin-Name: 50ddc36d32540b6d98990b5c9a465beb5b68cc31ae3f0ed162f6fe07e7c74e2d
 2026-04-23 15:54:00 +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
dan
68b07ddd41 Add OOM test for the new code on this branch. 
FossilOrigin-Name: 685be705a2a69e79de0d581e5bbe9d942133817342121786a551d95d59a4af6c
 2026-04-22 19:25:12 +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
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
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
93082e5589 Fix a harmless compiler warning in test/speedtest1.c. 
FossilOrigin-Name: 13f0fd1daaf787bff6eded4a01c2cf47c79e52cf8812bb344995e28c015a4ed1
 2026-04-18 21:51:32 +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
8c6a6b85db Fix a test case that started failing due to a change in the help text 
for the ".prompt" command of the CLI.

FossilOrigin-Name: bfe9df1bf4660ce6bdfd11a4f06d32694c93750c7bc0a6432459d9f1089eace4
 2026-04-17 19:12:27 +00:00
dan
9f76fb019e Update interrupt2.test to avoid using Tcl_GetCommandInfo() from within calls to Tcl_DeleteCommand(). 
FossilOrigin-Name: 1979aa0902a43f20d4e396c5f9b9a49aaf0094d8520bf53ce058bb379a7720ab
 2026-04-17 15:09:50 +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
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.

FossilOrigin-Name: a4bf9289c9cdb12b22bfb24e7e2b0243384e9edece12ae3fed14afbfe9b93260
 2026-04-16 19:50:52 +00:00
drh
1696740fdc Improved comments explaining the logic, and improved diagnostic messages 
when testrunner.tcl encounters trouble loading the sqlite3 extension.

FossilOrigin-Name: 8d820b0ccfccff94ed5b7297fa587ac27a74e990f233cfe229da7409ab2e3af8
 2026-04-16 19:33:04 +00:00
drh
2cefd5954a Minor updates to testrunner documentation. 
FossilOrigin-Name: f8507bd5e221783175be2bb7b907c098e0970b1cbcb01817df7217005eab9ab4
 2026-04-16 17:07:23 +00:00
dan
8895c50403 Run C-language tests in tests/c/ as part of release test. 
FossilOrigin-Name: e6929022b71c6bff7aa9cfbdb8a5e80499ca856b8c06d4211c55311b48704a08
 2026-04-16 16:43:32 +00:00
drh
e3dbf75160 Add support for the analyze() extension function to the fuzzcheck test 
program.

FossilOrigin-Name: abd94554d24122f0e0c3b7b36e5846e8c7aa0dddbddd9aae35b3f6ae6ab283c0
 2026-04-15 13:05:43 +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
dan
483f0ef13c Ensure c-tests use the locally built sqlite3.h file, not the system copy. 
FossilOrigin-Name: 2d81ee65ffbed30fd98bdda96dc79c1929c73f806cea3c9e4c244b618980b202
 2026-04-14 18:12:09 +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
dan
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. 
FossilOrigin-Name: 30b597d797e737a2907b755706a37d63c37c6a06c4e037098a6d9c482bcde887
 2026-04-13 11:20:51 +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
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
dan
0523cfda5a Fixes for running C tests on windows. 
FossilOrigin-Name: 1fcacdc41ab1bb66a628acdac29412e66decdc2578dd9d084baaffb74679f984
 2026-04-11 18:05:49 +00:00
dan
bc68ec78de Enhance testrunner.tcl to run individual tests written in C from the test/c/ directory. 
FossilOrigin-Name: 6f140f76f47aadb10d3f35358503d91adb43e0c1802326f6e599effe1b08e7aa
 2026-04-11 17:03:27 +00:00
drh
28456958ca Initial test cases for the CLI prompt enhancements. 
FossilOrigin-Name: b7ecc84735d41e9cdb498020b86d8219efa18ca5b40aef1031a14809f1ac2d38
 2026-04-11 16:12:12 +00:00
drh
b0d9039c8c Updates to testrunner.tcl: Shorten the prefix on created subdirectories from 
"testrunner_bld_" to just "testrun_".  Do not append ".exe" to the names of
created subdirectories.  Add the "clean" command to recursively remove all
subdirectories and files created by a test run.

FossilOrigin-Name: 450c7edf1247024db4b66f38bf9561c5c6b0c4175c4df8de17019aea6cbde5cf
 2026-04-09 16:08:29 +00:00
dan
df3e207501 When generating make.sh for testrunner, correctly quote the value of any options passed via environment variable OPTS. 
FossilOrigin-Name: 0837933b49f5fc5590f2052808bc305aceccafbf5db65aae250c594ce48d4d32
 2026-04-09 06:38:31 +00:00
drh
a7200804eb Fix a buffer overflow bug in a recent check-in, reported by unsolicted 
email from OpenAI/Codex.

FossilOrigin-Name: be891a137af15897691250324e4d3d9c96f0c5fb414bca27d0c3bfdd3012a8a2
 2026-04-08 17:00:33 +00:00
drh
7ff8b558e8 Enhance testrunner.tcl so that a PATTERN argument that begins with "~" is 
an "anti-pattern".  Only run tests that match one or more patterns if there
are any patterns *and* do not match any anti-pattern.

FossilOrigin-Name: c313d91bb67b56be2db46194c3baa5a72b469595de3b2abe249612838dc175e4
 2026-04-03 19:48:01 +00:00
drh
fc19b2ca8a Minor patch to test/json/json-speed-check.sh. That script is not maintained, 
but this fix at least gets it working for now.

FossilOrigin-Name: 9d92e371ca375776d251fe446f17a437823cc96e48a5c45f42cb0768d0a47f65
 2026-04-02 16:21:47 +00:00
drh
5239e69fb1 Remove a harmless unused variable from the fp-speed-2.c benchmark. 
FossilOrigin-Name: ff9008e7615d877e6cc852c60097777006b274971646d368eaa56b99a7acf6c7
 2026-03-28 14:21:53 +00:00
drh
20d93e16d7 Enhancements to the fp-speed-N.c programs, suggested by Andreas Kupries. 
FossilOrigin-Name: 7d81ff4c509d4039ef9e2f1066284ec560131422db0cbffa7e1826d71bb8f8e1
 2026-03-28 14:17:53 +00:00
drh
ff8a0895d6 Fix up the floating-point speed tests so that they only need to be run once 
to get a performance comparision.  Provide the fp-speed-test makefile target
to build and run them both.

FossilOrigin-Name: 09e0e78a8265c2e2bc36fef1fa88bd5bf414f9b776966c1c91a4ed4b7866331d
 2026-03-27 20:18:06 +00:00
drh
a2f78f665c Add a comment to test/fptest01.sql to remind us that failures in that 
script might not be the fault of SQLite.

FossilOrigin-Name: 65efcb0a2ed49fa2fd747b5f034d976ed3cb4a01a185bcada70bf8a5208f3841
 2026-03-27 19:25:25 +00:00
drh
c4cedd7ffe New test cases for text→float conversions. 
FossilOrigin-Name: bbf2d648376a965605d5c641a889ab7ef365bc53788d984c054468e9889deee6
 2026-03-27 18:58:50 +00:00
drh
be2242d2ee Change the print resolution the fp-speed-1.c test to 17 digits. 
FossilOrigin-Name: c687b32a956315ddf4336df42deb4037c37d51b536b8a24c5cef4c5a0bc4c79b
 2026-03-27 14:54:01 +00:00
drh
2dd3b4a646 Update fp-speed-1.c and fp-speed-2.c to include its own timers, so that it 
works on platforms that lack the "time" command.

FossilOrigin-Name: 9b083070de2d782fe1db62652af8f3cd48abe16b55b974f3927b738e3d914887
 2026-03-27 14:19:01 +00:00
drh
4570aeb7bc Add the fp-speed-2.c performance test program. 
FossilOrigin-Name: b788256f1980531e7abb15c5fbcdd40ae166f091aea28f449c0407105ddf1aa4
 2026-03-27 14:03:41 +00:00
drh
f163bfba4e If the argument to REINDEX is EXPRESSIONS (with no schema prefix) then it 
updates both expression indexes, and any indexes named "expressions" or
all indexes of any tables name "expressions".

FossilOrigin-Name: 72650dc152279a6da1937f377b1e16b79f4cd664841e12222dc5459838408d22
 2026-03-20 19:30:58 +00:00
dan
bd580270a5 Ensure that collation sequences on non-PK columns of a WITHOUT ROWID table are used correctly when they are part of a row value comparison. Fix for forum post [forum:7a308e933d | 7a308e933d]. 
FossilOrigin-Name: 078b3162d0d3d3035f4d3ad88664066d99c218a731ac481b9f1172529e26e4eb
 2026-03-20 11:35:15 +00:00
dan
58012b85b0 Do not assume that a recursive CTE emits rows in ORDER BY order. Fix for forum post [forum:deb1eadf4d677bd5 | deb1eadf4d677bd5]. 
FossilOrigin-Name: cadb6cdd32c3c9abd7e063f25acd39dddc9ff764a16019ffd5aa11063175326f
 2026-03-19 10:51:40 +00:00