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

10101 Commits

Author SHA1 Message Date
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
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
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
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
drh
5a6772eaa5 Comment improvements. Ensure that tests in shellB.test that require 
virtual tables do not run when compiling without virtual table support.

FossilOrigin-Name: a270c6cc0eea8a8a2cf1ce30d724b2f12b11a1c343cd8520bd7843f4e62878f8
 2026-03-18 17:16:18 +00:00
drh
acc213b42f Improve the integrity-check error message when floating point index values 
are off by one or two ULPs.  Change the name of the eiib1.test test module
to expridx1.test.

FossilOrigin-Name: 4e996c183ea8d270b4448b471d4d032e13cef89f537674599d1e7c367cc2d0f8
 2026-03-18 15:51:15 +00:00
dan
345bc91673 Do not assume that a recursive CTE emits rows in ORDER BY order. Forum [forum:deb1eadf4d677bd5 | deb1eadf4d677bd5]. 
FossilOrigin-Name: 971aa34b3fd86ba30fe170886d9f83c17159b1638c4bd4fb6cdef79b1c9a88e2
 2026-03-18 15:40:26 +00:00
dan
3f2d7d4aaa Fix some cases where integrity-check would fail to identify real values in indexed expressions that are with 2 ULPs of each other. 
FossilOrigin-Name: 40c5966f7b784f181365c81fc559aee9463c374ee56677cf6e0aecaed39d2b28
 2026-03-18 11:06:10 +00:00
dan
362b9cecdb Modify integrity-check so that it is only tolerant of very small distortions of real values in indexed expression fields. 
FossilOrigin-Name: 82e6de835bde306778425d18ab1a15ae80fdf01af7f577ead89c09f9d53b5b2f
 2026-03-17 21:17:42 +00:00
dan
ae2820ab28 When integrity-check finds a missing index entry, search a small range (currently 10) of entries around the missing key for an entry that matches all non-virtual and non-expression fields. 
FossilOrigin-Name: 978cedcbd33165dadc7dffc118bde359eff6751ec9842230880cb827d9f7845f
 2026-03-17 17:05:45 +00:00
dan
022f2f96bc Change the sqlite3VdbeFindDeleteKey() routine so that all index fields that are not expressions or virtual columns must match the table for the delete to succeed. 
FossilOrigin-Name: eccd9fcfa7e34ddcdeb671544c6afac7aa0d4665c5e1df7c8e53c41387ed0386
 2026-03-17 11:17:54 +00:00
drh
1c1f7c259e Merge trunk enhancements into the idxdelete-tolerance branch 
FossilOrigin-Name: 5f5ab3eb3618b6a2799355df50bfdf94121161f7cadba6253963036d9f284f08
 2026-03-17 09:53:02 +00:00
dan
f6308e68ff Further tests for the code on this branch. 
FossilOrigin-Name: f928a38091977268aa6a096104797158883ed89b9e026b4e4b98b9b5da967de1
 2026-03-16 16:44:14 +00:00
dan
b2006499c7 Fix a problem with the find-delete-key method on this branch. 
FossilOrigin-Name: 6f49b5ecad5d924999d045a1ade93d95e731182be1781aefa5bc763b6202e9c3
 2026-03-16 15:49:58 +00:00
drh
bf057073c3 Rework the ".indexes" command of the CLI. (1) The PATTERN now matches 
the name of the index itself, not the name of the table containing
the index, thus making the pattern actually useful.  (2)  System-generated
indexes (for UNIQUE constraints and similar) are omitted unless
the -a|-all or --sys options are added.  (3) The --expr option causes
only expression indexes to be shown.

FossilOrigin-Name: 13e2cad810bfd59a9e18eb38bda1241715b76756ffec7d617e9ce99b89f19284
 2026-03-16 15:35:41 +00:00
dan
061459bf76 Properly fix temp triggers created as part of FK processing to their schemas. Otherwise they may become confused by similarly named child tables in other attached databases. Fix for forum post [forum:636bd0180a | 636bd0180a]. 
FossilOrigin-Name: 80bc5bc07e221f837c28066f0a438f11c8ab6be4c8ba93615439eb1667967003
 2026-03-16 11:14:26 +00:00
drh
3bd23b0d78 Fix the behavior dot-commands that appear as command line arguments to the 
CLI so that their effect persists into subsequent commands on the command
line.  This fix also improves error messages caused by command line
arguments. 
[forum:/forumpost/2026-03-10T19:26:06z|Forum post 2026-03-10T19:26:06z].

FossilOrigin-Name: ff084ae341eab5c4ce9403defee03adc448c05f77648a954f0942a38f640080b
 2026-03-10 21:01:59 +00:00
drh
abc82c49c2 Revamp the QRF insert-mode optimization of [659ff6ab55802507]. The 
control value is now nMultiInsert.  Multiple rows are added to each INSERT
statement until the number of bytes in that statement exceeds the
nMultiInsert value.  The CLI uses a default value of 3000, which provides
a good balance between speed and prepare-statement size.  The output
from ".dump" now loads nearly 2x faster in some cases.

FossilOrigin-Name: 55b0ce9f93d68b17a18423f0f751b778573127743a2bac67abfea074ac32d41a
 2026-03-10 18:13:13 +00:00
drh
efa8633fd8 Enhance QRF with the mxTuple field, which if greater than 1 causes the 
QRF_STYLE_Insert style to group as many as mxTuple adjacent rows into
a single INSERT statement.  The field is accessible using the -mxtuple
option in the TCL interface, and the --mxtuple option in ".mode".  The
output of the ".dump" and ".fullschema" commands responds to the current
--mxtuple setting.

FossilOrigin-Name: 659ff6ab5580250707908af003ecd093bd5313f03f21f0efd000a7aff6638b3c
 2026-03-10 14:02:03 +00:00
drh
e795890d7e In QRF, fix line-wrap indentation for "line" mode when using a 
non-standard column separator.

FossilOrigin-Name: 00c96cca3de709e40207feb9c10a94e38e7857c9bc01938849c6c5daee7148c7
 2026-03-09 13:53:58 +00:00
dan
5ed6e4ccd1 Fix a problem with RIGHT JOIN and expressions on indexes. [forum:e3dba5426a | Forum post e3dba5426a]. 
FossilOrigin-Name: f27d578edac06eb28739f23351ab1cf07531bc7b32f4077e4dc9c8166f551d95
 2026-03-09 11:49:51 +00:00
drh
13a494fddd Give the fuzzcheck test program access to all the same extensions that 
dbsqlfuzz has access to.

FossilOrigin-Name: d9c23b49e355233bbfcdc8305dcae21640e66a0bbf1daed0dd3f9d132c1ef69f
 2026-03-07 21:07:18 +00:00
drh
275e7c7caa Merge fixes that were deferred until after the 3.52.0 release, including: 
(1) Fix handling of DISTINCT with OUTER JOIN, (2) Enhance configure to
auto-detect linenoise, (3) Add recent configuration settings to WASM.

FossilOrigin-Name: 9d51bec1b17925f5cac0d590c0d70bb34e77fdb7253d18007f52711d42f6f5d0
 2026-03-06 18:51:49 +00:00
dan
ea595494e2 Uninstall faultsim at the end of the walrestart.test script. 
FossilOrigin-Name: 798905a1277ecb17245f2a7378fdc8dc608374fde50bdfe44d09195a7c78cb5c
 2026-03-06 11:18:12 +00:00
dan
46686ac681 Fix a long-standing problem with DISTINCT LEFT JOIN queries. 
FossilOrigin-Name: f43294a5582b540a33c584ec8c69b6a5006a4d243ad5cf36125b2b0806e3518b
 2026-03-05 14:39:27 +00:00
drh
bef2a1e33e Add a little flexibility to checkpoint sizes in the walrestart.test script. 
FossilOrigin-Name: e438b564ca84377746464034d770e9c1f5899d935c6a4dffc546acb92afb800e
 2026-03-05 00:30:05 +00:00
drh
76e562e222 Fix a code-generator bug introduced by the UNION/INTERSECT/EXISTS 
optimization of check-in [132ba781b031972c] and reported in
[forum:/forumpost/2026-03-04T05:06:26Z|forum post 2026-03-04T05:06:26Z].

FossilOrigin-Name: 6ba7797cac7dc873b62a12be5712511c9199b379342dac4a1887bfd65227a298
 2026-03-04 13:02:08 +00:00
dan
8ba2a38363 Do not run test script walrestart.test with the "memsubsys1" permutation. 
FossilOrigin-Name: 703cbb0f760515eac1e6f72a5e5cd928258c71378e4a976082b6518c90128135
 2026-03-03 18:34:38 +00:00
drh
bb80d688ac Minor tweaks to the previous, for testability. 
FossilOrigin-Name: decb69015457b4f70cf574aeef87d40f9de60b94965f4a915e8d0cd7559ef2ae
 2026-03-03 18:21:22 +00:00
dan
fe57e14b49 Avoid an obscure race condition between a checkpointer and a writer wrapping around to the start of the wal file. 
FossilOrigin-Name: 053bd3930f827156fd67ea4546a36227cffbb6f8bada3b5d1a7cf5f1867ac624
 2026-03-03 17:34:01 +00:00
drh
f6c8adf3a2 Omit explain_i calls from TCL test scripts. 
FossilOrigin-Name: 204f25c882832058c3291d4d6a0a6ac2711c081cb91b19feb2cf94a25ed61ecf
 2026-03-02 16:40:16 +00:00
drh
ea6b2a87d1 Disable test shell1-5.0 as it is causing a use of initialized deep inside 
of TCL.

FossilOrigin-Name: 440bd6091e3767f0a2f42ffdc92ca5e4736c0a73324fdd15397c3b5dbbc31fb8
 2026-03-02 13:43:08 +00:00
dan
33478099c9 Fix a possible 9-byte buffer overread in the zipfile extension hit when processing a corrupt zip file. Forum post [forum:/forumpost/721a05d2c5 | 721a05d2c5]. 
FossilOrigin-Name: 5db21813d126554d80db903be6d36ab6c1f73f9135a54af6dcfcfce0bcc18e68
 2026-03-02 11:22:28 +00:00
drh
93ad2e083e The intck01.sql test should only be run if virtual tables work. 
FossilOrigin-Name: 641d6f31a7f7b4901061e24d4e624da5ed92282e79771bb019b82a882e5d1ae9
 2026-03-02 00:06:02 +00:00