database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,542 Commits 1,570 Branches 183 Tags
begin-concurrent
Commit Graph

10062 Commits

Author SHA1 Message Date
drh
f96d44e5de Fix a bug in the speedtest.tcl testing script that was introduced by 
[7e9845433ff26bdc]

FossilOrigin-Name: e4ffa86aa6ca82a42933281f6cbfca7bad702797eb8d6e684a1992e68dc1cfb7
 2025-05-26 17:29:13 +00:00
dan
93394ebc27 On OpenBSD, do not test fuzzcheck with ubsan as part of "make devtest". 
FossilOrigin-Name: a3dabd599c3d3143b67258b307d352968e5f5d4ea0456940d16ae678de8c95eb
 2025-05-26 16:17:06 +00:00
drh
a01b7adb13 Change json_group_object() so that it ignores entries where the label 
is NULL.  [forum:/forumpost/e5bd251fb5|Forum post e5bd251fb5].

FossilOrigin-Name: 28215d131cd970a2756338579fb6b6091ab155be8f419505cae8ac918956165c
 2025-05-24 20:20:20 +00:00
drh
c1ea1a6d4d Add the --osmalloc option to the test/speedtest.tcl testing script. 
Adjust ./configure so that it does not check for malloc_usable_size().

FossilOrigin-Name: 7e9845433ff26bdc5fe8654281d584394b77e3b206d09669b4468e0271c6eb37
 2025-05-23 14:52:23 +00:00
drh
7978de38e5 Merge the latest trunk changes into the begin-concurrent branch. 
FossilOrigin-Name: 9fec43d927fdd7d58cca352f7e7414c9d216e11dc6d517e1e1ca70f1d179b27a
 2025-05-19 16:45:11 +00:00
stephan
186fd30436 Adjust the strftime() test in test/date4.test to remove flags not supported in musl libc if that environment is detected. 
FossilOrigin-Name: fc254c1eb784c79a371bf961945a18a680982cdcd3fdcd7e6bb481712fe21cf8
 2025-05-13 18:58:56 +00:00
drh
4b3e9a4903 Merge all the latest trunk enhancements into the begin-concurrent branch. 
FossilOrigin-Name: 55a51ba58f98cbec9b0be444a3d5f839caba32576e8a5f6400b298de56e70006
 2025-05-06 21:26:10 +00:00
dan
f67058367b Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix. 
FossilOrigin-Name: 6eb2939a6093c0796910645172d80c53055559dd57c012f1dc815d89fbf84447
 2025-05-06 17:56:32 +00:00
drh
88ed1806a4 Fix an issue in Bloom filters on RHS subsqueries to IN operators. 
See [forum:/forumpost/792a09cb3df9e69f|forum post 792a09cb3d] for
a description of the problem.  Also improve comments related
to [baa83b460c677c21] which was origin of the problem.

FossilOrigin-Name: cdef486e212fe4b26605065d9cff08f608cb80df48ee64e4be63637769bdfacc
 2025-04-30 12:48:20 +00:00
drh
2ba946b341 Add the "--fuzzdb FILENAME" to testrunner.tcl as an alternative to setting 
the FUZZDB environment variable (as that can be awkward to do on Windows).
Further improvements to the testrunner.tcl documentation.

FossilOrigin-Name: 6fb84156a262ff89d1a2d1df6fbfac4c1a43fb55b9d15205508662e2c9b0894f
 2025-04-29 14:23:21 +00:00
drh
873fc5dff2 Update testrunner.tcl documentation. Fix typo in testrunner.tcl output. 
FossilOrigin-Name: ba8800b4ba0a690c89d9fb96bb9a0d8789d04160ff9c47ea9afb2b403bec7f0b
 2025-04-29 11:35:51 +00:00
drh
c171d7624e Improved --explain display of FUZZDB test plans in testrunner.tcl. 
FossilOrigin-Name: 42bdd7262ec4f8163263e0535c2cc35b526754d77e1f3ccf5b73b0f44d470d9c
 2025-04-29 10:41:16 +00:00
drh
ece7709f18 Do not run FUZZDB on either Windows-Memdebug or Windows-Win32Heap. 
FossilOrigin-Name: 10d8401d59136dda7051af0da398b06a18031560f2734f4fa347d339765d2089
 2025-04-29 10:29:35 +00:00
drh
8a68ab963e Make testrunner.tcl more restrictive about which configurations run 
fuzzcheck-asan and fuzzcheck-ubsan.

FossilOrigin-Name: 785599394dde0fb36ae2e07d611f9523a05a0817dbd8c416582b3b682dbfa4ff
 2025-04-29 01:37:31 +00:00
drh
246dc92354 Testrunner.tcl now runs fuzzcheck-asan and fuzzcheck-ubsan tests. 
FossilOrigin-Name: 3d8f3a255843c063157265702b76d40c38c774d29d658eea2d77efac92ac8789
 2025-04-28 19:15:46 +00:00
drh
d4cc3a42e2 If the FUZZDB environment variable is set when running testrunner.tcl and 
that env-var points to a fuzzcheck database, then suppliment the fuzzcheck
tests with that extra database.

FossilOrigin-Name: c08530dd6a71cb547d164e2313657c917f280e7988211bf199c8776e78a4e2a6
 2025-04-28 17:56:23 +00:00
drh
1365bcffbf Enhance testrunner.tcl so that it does not build testfixture unnecessarily - 
if the pattern does not match any TCL test.

FossilOrigin-Name: 896d767f1cba64bda7b91b0daebd60ebe4457a58d762da443bf61cf5b39ad2d9
 2025-04-28 16:28:00 +00:00
drh
7fec7c96c4 Fix testrunner.tcl so that it honors pattern matches in non-testfixture 
tests, such as fuzzcheck and sessionfuzz.

FossilOrigin-Name: 81857474fe90f50b760c22d61a6ad477642dabe1052390cd1614dcec8adb1376
 2025-04-28 16:17:17 +00:00
drh
738443c523 Remove a stray blank line from the test/testrunner.tcl script. 
FossilOrigin-Name: 7d6005b0d17d86d72757f3578872e82fd12f61ac9160a0277e397df09f6338a9
 2025-04-28 15:00:28 +00:00
drh
06263e5a15 Merge all recent trunk enhancements into the begin-concurrent branch. 
FossilOrigin-Name: 2866119c755a4ebc1f3670709de153fc1abd7bbd77c4467123d2aed478143a92
 2025-04-21 12:41:38 +00:00
drh
0243ca8245 Correctly handle the case of a multi-column UNIQUE constraint that contains 
the ROWID as one of it columns, and then the columns of that UNIQUE are
used in a row-value IN operator as a WHERE clause constraint.  Reported by
[forum:/forumpost/b9647a113b465950|forum post b9647a113b].  Problem
introduced by [723f1be3d4a905a6], part of ticket [da78413751863].

FossilOrigin-Name: d22475b81c4e26ccc50f3b5626d43b32f7a2de34e5a764539554665bdda735d5
 2025-04-15 21:59:38 +00:00
drh
483e1181c5 Improved estimate on the number of output rows in a recursive common table expression 
that uses the UNION operator.  Follow-up to [f911f1c4977fbcae] and it's output row
estimate changes associated with DISTINCT queries.

FossilOrigin-Name: 92513f6bce7ecc778e78af3a77bc66ff65585fffa2e3138f8acb9e617121eeb0
 2025-04-14 19:43:30 +00:00
drh
a863bafba7 Improved detection of run-time errors (ex: OOM errors) in speedtest1. 
FossilOrigin-Name: 0e5e0e2f558a417d57c01a2d62cb2117d2adf6ddbc62e6a0208ae23f19b05347
 2025-04-10 19:54:56 +00:00
drh
f95e964b6b Provide new command-line options --hard-heap-limit and --soft-heap-limit 
for speedtest1.

FossilOrigin-Name: 578e9fedeaaacd152ae1988920e6c9a0c43f664e2f9461c0994ba427ae1688e7
 2025-04-10 19:39:34 +00:00
drh
e4856e86cd Be sure that speedtest1 reports any errors that it encounters while 
running the speed tests.

FossilOrigin-Name: 8c8b1a99bc888a5db637900aa3c8ef1b8c748c527580c825a25df1008afcf9e0
 2025-04-10 19:03:42 +00:00
dan
2d1c71abeb Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. 
FossilOrigin-Name: d82725dcaec7437f37fc15dfb492b51a4f9dbbbcaea04e387d9471b7d291cde2
 2025-04-10 14:53:32 +00:00
drh
8a6f89c845 Remove unnecessary "www." prefixes on domain names in URLs. 
FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
 2025-04-10 10:18:07 +00:00
jan.nijtmans
82d05b7b54 The win32lock and win32longpath tests don't work on Cygwin 
FossilOrigin-Name: 32ef3f26e7fb34dfdb23617a19bb9baa2e4c3dca564a88850b58a0fbe6446cf8
 2025-04-04 13:23:03 +00:00
stephan
2d49219b1c Correct two tests in shell1.test which were broken by the addition of new output in [0f11087b8475]. 
FossilOrigin-Name: 909dd0a02a967baef46c3efdca42a0ab4e15003e34ce7e9af82fce5f17213d7b
 2025-03-28 16:31:54 +00:00
jan.nijtmans
d07045119d shell1.test: == => eq 
FossilOrigin-Name: 99fdd19193056259d84768f46519328c300976b102f1b1e0b815720df01b28d0
 2025-03-27 17:25:38 +00:00
jan.nijtmans
1588d3de37 More ==/!= => eq/ne fixes 
FossilOrigin-Name: 2aa6c4fa6c9c47c7a8548ac3493bfb9ed4e4dec1b6dc4f3599a0373086b3e917
 2025-03-27 14:37:07 +00:00
jan.nijtmans
87b90921b6 In Tcl, always use eq/ne for comparing strings, not ==/!= 
FossilOrigin-Name: f96a5346e3e890adfdc94a682688c2c15893e50fbaf2a26e5ef39cda8b331ee4
 2025-03-27 14:32:57 +00:00
jan.nijtmans
eb2644024a Merge trunk. Some additional test-fixes for Cygwin 
FossilOrigin-Name: b36adadfa202fb8951149561471c3e01085d31e1837c99806f308f234cd24a8e
 2025-03-27 14:13:12 +00:00
stephan
22d502e33a Merge trunk into cygwin-fixes branch. Add .fossil-settings/binary-glob to squelch warnings about *.db files on Cygwin. 
FossilOrigin-Name: a8328b921c5504eceacade417e16e713999eff63978caf3418fd79501590b1cb
 2025-03-26 00:02:15 +00:00
drh
75484481c7 Fix the generate_series() enhancement from check-in [d50b784807333c54] 
so that it works even if the number that "value" is being compared against
is a non-integer floating point number.  Bug reported by
[forum:/forumpost/0d5d63257e3ff4f6|forum post 0d5d63257].

FossilOrigin-Name: c113e31b818d16770bec1edc980f6833dfb27c4d74178e66a778fbb5671c3a13
 2025-03-22 22:55:33 +00:00
drh
b6cd6220da Merge the latest trunk enhancements into the begin-concurrent branch. 
FossilOrigin-Name: cb5e024b6aed12cb109b481e87d2a5457b5f4f5fc090571e5eef2bd8cf04aaf7
 2025-03-22 14:12:46 +00:00
drh
7f4efdcb65 Teach the CLI that VT100-escape codes that do things like change font 
colors have zero-width for the purpose of laying out the columns of a
table.

FossilOrigin-Name: 2d0a8a6c38981552748ff5fc2eeba86590e0f116abac260a7fc9318de0a0dbda
 2025-03-21 18:15:13 +00:00
drh
4c13878ac2 Fix a problem in the sqlite_dbpage() table-valued function when it is 
trying to truncate a file in locking-mode=EXCLUSIVE and the file was
obtained via sqlite3_deserialize().  Problem found by dbsqlfuzz.

FossilOrigin-Name: 346cf9794c6ce82ac32f7ccabc67240309306626709951593720abd198b103e3
 2025-03-20 11:47:39 +00:00
stephan
52e2a79304 Test script patches from Jan Nijtmans: always use -DUSE_TCL_STUBS in buildtclext.tcl and improvements in how TRG is populated in testrunner.tcl. 
FossilOrigin-Name: aa192203aa1aa188866fe00a5d40dc7b7c72b4f38b06da8708ed0a6c8b8638a6
 2025-03-19 13:49:34 +00:00
stephan
21aeeb06fe Merge trunk into the cygwin-fixes branch for the shell test improvements on Windows. An MSC build's make test now has zero failures. 
FossilOrigin-Name: 2de4efe10c2591192edca3833fc9e2fae10ebc925fb556f5b53ad483b491b5b3
 2025-03-19 13:13:12 +00:00
stephan
178edbaa2f Avoid running test cases involving ANSI control characters or Unicode on Windows in a slave interpreter, as that combination does not work. 
FossilOrigin-Name: c7fd71c77f1716c9c85d0f41a07ebd7c96f2e9d5e4c1392fefa1fb53f3cbb746
 2025-03-19 11:53:46 +00:00
stephan
6e059d9dac Merge trunk into the cygwin-fixes branch. 
FossilOrigin-Name: 34eadd374b3c0a8c9e1f5f4a1c60fda8f16b1c56213b8c4047f96390c676b695
 2025-03-19 10:14:46 +00:00
drh
8db881d055 Change the generate_series() table-valued function so that its rowid is just an 
alias for its value.  This allows it to be used as the RHS operand of a
RIGHT JOIN.  This fixes the issue raised by
[forum:/forumpost/1e17219c88|forum post 1e17219c88].

FossilOrigin-Name: 77db4d85e70fbf358ae2321c2601966666bdb4d971d7c113ce30a3e541458ee8
 2025-03-18 20:15:16 +00:00
dan
31fd886576 Fix a problem that could occur when the RHS of an IN operator was a compound SELECT featuring an ORDER BY on a subquery that was flattened into one of the component SELECTs introduced by [baa83b460c677c21]. Forum post [/forumpost/1e17219c88]. 
FossilOrigin-Name: 7101ccd5331e36fd1a539f540e79ce0ce159be76ec422e1d9436eec6f3908c6e
 2025-03-18 19:21:04 +00:00
drh
42db4d043e Enhance the fuzzcheck testing tool with new command-line options: 
--brief, and --slice M N.

FossilOrigin-Name: e64132723db0c4f2b9a58932a93beb1671e42006eebc1aeaa8f320e717043051
 2025-03-15 23:42:32 +00:00
drh
77d9bf1c26 Merge the latest trunk enhancements into the begin-concurrent branch. 
FossilOrigin-Name: 624225499cdada78aacac65ab419ee33177ef329b4248c971f830eb38af72747
 2025-03-15 20:25:24 +00:00
drh
b7b060401e Work around compilers that do not understand flexible arrays, in the 
recovery extension and in the fuzzcheck test module.

FossilOrigin-Name: f101c46cf83e532fd33034abccba496bf395ef10c161af003211614d6581d5eb
 2025-03-15 19:00:46 +00:00
drh
0a4f10e6e2 Use flexible arrays in the recovery extension and in the fuzzcheck test program. 
Adjust the unix makefile to use -fsanitize=bounds-strict when building
fuzzcheck-asan.

FossilOrigin-Name: 6ea6a6b211fed1a14d7bec1ab1790dec09e2a00423860498a60b760c4a4561fa
 2025-03-15 13:04:16 +00:00
drh
99e8490705 Fix the generate_series extension for the case where the termination value 
is not an even multiple of the step from the start value and there is also
a value=NNN constraint in the WHERE clause.
[forum:/info/bf2dc8e909983511|Forum post bf2dc8e9]

FossilOrigin-Name: 75e72e3b0d0d689d39e00a01dc361dd6ce2649e68d200bf501ddcf04063041b2
 2025-03-13 18:51:18 +00:00
drh
72b5c6db35 Avoid running test cases involving ANSI control characters or Unicode 
on Windows in a slave interpreter, as that combination does not work.

FossilOrigin-Name: f6745a7355c62ee64c08e23b795f437dd74add903b55e1255c1d03f9a811170d
 2025-03-11 15:46:23 +00:00