aboutsummaryrefslogtreecommitdiff
path: root/test
Commit message (Collapse)AuthorAge
...
* | | | | When synthesizing an ON constraint from a USING or NATURAL, if the left-handdrh2025-05-30
|/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | side is coming from a RIGHT JOIN, be sure to set the EP_CanBeNull flag so that the optimizer knows to check for NULL even if the column has a NOT NULL constraint. Fix for the problem reported by [forum:/forumpost/4fc70203b61c7e12|forum post 4fc70203b61] FossilOrigin-Name: 60adc78a22956429d34ccc4e2c193c5994c11c3b3cff7901d47fad7d92dba935
* | | | Extend the fix for ticket [623eff57e76d45f6] so that it covers RIGHT JOINdrh2025-05-29
| | | | | | | | | | | | | | | | | | | | | | | | in addition to LEFT JOIN. Problem reported by [forum:/forumpost/7dee41d32506c4ae|forum post 2025-05-29T15:10:14Z]. FossilOrigin-Name: 29b1e1b97619d03a97ef562a5707929e241d019179b4ff1d0bc2a8c008441431
* | | | Fix a bug in the speedtest.tcl testing script that was introduced bydrh2025-05-26
| | | | | | | | | | | | | | | | | | | | [7e9845433ff26bdc] FossilOrigin-Name: e4ffa86aa6ca82a42933281f6cbfca7bad702797eb8d6e684a1992e68dc1cfb7
* | | | On OpenBSD, do not test fuzzcheck with ubsan as part of "make devtest".dan2025-05-26
| | | | | | | | | | | | FossilOrigin-Name: a3dabd599c3d3143b67258b307d352968e5f5d4ea0456940d16ae678de8c95eb
* | | | Change json_group_object() so that it ignores entries where the labeldrh2025-05-24
| | | | | | | | | | | | | | | | | | | | is NULL. [forum:/forumpost/e5bd251fb5|Forum post e5bd251fb5]. FossilOrigin-Name: 28215d131cd970a2756338579fb6b6091ab155be8f419505cae8ac918956165c
* | | | Add the --osmalloc option to the test/speedtest.tcl testing script.drh2025-05-23
| | | | | | | | | | | | | | | | | | | | Adjust ./configure so that it does not check for malloc_usable_size(). FossilOrigin-Name: 7e9845433ff26bdc5fe8654281d584394b77e3b206d09669b4468e0271c6eb37
* | | | Adjust the strftime() test in test/date4.test to remove flags not supported ↵stephan2025-05-13
| | | | | | | | | | | | | | | | | | | | in musl libc if that environment is detected. FossilOrigin-Name: fc254c1eb784c79a371bf961945a18a680982cdcd3fdcd7e6bb481712fe21cf8
* | | | Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix.dan2025-05-06
| | | | | | | | | | | | FossilOrigin-Name: 6eb2939a6093c0796910645172d80c53055559dd57c012f1dc815d89fbf84447
* | | | Fix an issue in Bloom filters on RHS subsqueries to IN operators.drh2025-04-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* | | | Add the "--fuzzdb FILENAME" to testrunner.tcl as an alternative to settingdrh2025-04-29
| | | | | | | | | | | | | | | | | | | | | | | | the FUZZDB environment variable (as that can be awkward to do on Windows). Further improvements to the testrunner.tcl documentation. FossilOrigin-Name: 6fb84156a262ff89d1a2d1df6fbfac4c1a43fb55b9d15205508662e2c9b0894f
* | | | Update testrunner.tcl documentation. Fix typo in testrunner.tcl output.drh2025-04-29
| | | | | | | | | | | | FossilOrigin-Name: ba8800b4ba0a690c89d9fb96bb9a0d8789d04160ff9c47ea9afb2b403bec7f0b
* | | | Improved --explain display of FUZZDB test plans in testrunner.tcl.drh2025-04-29
| | | | | | | | | | | | FossilOrigin-Name: 42bdd7262ec4f8163263e0535c2cc35b526754d77e1f3ccf5b73b0f44d470d9c
* | | | Do not run FUZZDB on either Windows-Memdebug or Windows-Win32Heap.drh2025-04-29
| | | | | | | | | | | | FossilOrigin-Name: 10d8401d59136dda7051af0da398b06a18031560f2734f4fa347d339765d2089
* | | | Make testrunner.tcl more restrictive about which configurations rundrh2025-04-29
| | | | | | | | | | | | | | | | | | | | fuzzcheck-asan and fuzzcheck-ubsan. FossilOrigin-Name: 785599394dde0fb36ae2e07d611f9523a05a0817dbd8c416582b3b682dbfa4ff
* | | | Testrunner.tcl now runs fuzzcheck-asan and fuzzcheck-ubsan tests.drh2025-04-28
| | | | | | | | | | | | FossilOrigin-Name: 3d8f3a255843c063157265702b76d40c38c774d29d658eea2d77efac92ac8789
* | | | If the FUZZDB environment variable is set when running testrunner.tcl anddrh2025-04-28
| | | | | | | | | | | | | | | | | | | | | | | | that env-var points to a fuzzcheck database, then suppliment the fuzzcheck tests with that extra database. FossilOrigin-Name: c08530dd6a71cb547d164e2313657c917f280e7988211bf199c8776e78a4e2a6
* | | | Enhance testrunner.tcl so that it does not build testfixture unnecessarily -drh2025-04-28
| | | | | | | | | | | | | | | | | | | | if the pattern does not match any TCL test. FossilOrigin-Name: 896d767f1cba64bda7b91b0daebd60ebe4457a58d762da443bf61cf5b39ad2d9
* | | | Fix testrunner.tcl so that it honors pattern matches in non-testfixturedrh2025-04-28
| | | | | | | | | | | | | | | | | | | | tests, such as fuzzcheck and sessionfuzz. FossilOrigin-Name: 81857474fe90f50b760c22d61a6ad477642dabe1052390cd1614dcec8adb1376
* | | | Remove a stray blank line from the test/testrunner.tcl script.drh2025-04-28
| | | | | | | | | | | | FossilOrigin-Name: 7d6005b0d17d86d72757f3578872e82fd12f61ac9160a0277e397df09f6338a9
* | | | Correctly handle the case of a multi-column UNIQUE constraint that containsdrh2025-04-15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* | | | Improved estimate on the number of output rows in a recursive common table ↵drh2025-04-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | expression that uses the UNION operator. Follow-up to [f911f1c4977fbcae] and it's output row estimate changes associated with DISTINCT queries. FossilOrigin-Name: 92513f6bce7ecc778e78af3a77bc66ff65585fffa2e3138f8acb9e617121eeb0
* | | | Improved detection of run-time errors (ex: OOM errors) in speedtest1.drh2025-04-10
| | | | | | | | | | | | FossilOrigin-Name: 0e5e0e2f558a417d57c01a2d62cb2117d2adf6ddbc62e6a0208ae23f19b05347
* | | | Provide new command-line options --hard-heap-limit and --soft-heap-limitdrh2025-04-10
| | | | | | | | | | | | | | | | | | | | for speedtest1. FossilOrigin-Name: 578e9fedeaaacd152ae1988920e6c9a0c43f664e2f9461c0994ba427ae1688e7
* | | | Be sure that speedtest1 reports any errors that it encounters whiledrh2025-04-10
| | | | | | | | | | | | | | | | | | | | running the speed tests. FossilOrigin-Name: 8c8b1a99bc888a5db637900aa3c8ef1b8c748c527580c825a25df1008afcf9e0
* | | | Fix an obscure problem allowing the propagate-constants optimization to ↵dan2025-04-10
| | | | | | | | | | | | | | | | | | | | improperly substitute a column of a sub-query with NONE affinity. FossilOrigin-Name: d82725dcaec7437f37fc15dfb492b51a4f9dbbbcaea04e387d9471b7d291cde2
* | | | Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | | | | | | | | | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* | | | The win32lock and win32longpath tests don't work on Cygwinjan.nijtmans2025-04-04
| | | | | | | | | | | | FossilOrigin-Name: 32ef3f26e7fb34dfdb23617a19bb9baa2e4c3dca564a88850b58a0fbe6446cf8
* | | | Correct two tests in shell1.test which were broken by the addition of new ↵stephan2025-03-28
| | | | | | | | | | | | | | | | | | | | output in [0f11087b8475]. FossilOrigin-Name: 909dd0a02a967baef46c3efdca42a0ab4e15003e34ce7e9af82fce5f17213d7b
* | | | shell1.test: == => eqjan.nijtmans2025-03-27
| | | | | | | | | | | | FossilOrigin-Name: 99fdd19193056259d84768f46519328c300976b102f1b1e0b815720df01b28d0
* | | | More ==/!= => eq/ne fixesjan.nijtmans2025-03-27
| | | | | | | | | | | | FossilOrigin-Name: 2aa6c4fa6c9c47c7a8548ac3493bfb9ed4e4dec1b6dc4f3599a0373086b3e917
* | | | In Tcl, always use eq/ne for comparing strings, not ==/!=jan.nijtmans2025-03-27
| | | | | | | | | | | | FossilOrigin-Name: f96a5346e3e890adfdc94a682688c2c15893e50fbaf2a26e5ef39cda8b331ee4
* | | | Merge trunk. Some additional test-fixes for Cygwinjan.nijtmans2025-03-27
|\ \ \ \ | | | | | | | | | | FossilOrigin-Name: b36adadfa202fb8951149561471c3e01085d31e1837c99806f308f234cd24a8e
* | | | | Merge trunk into cygwin-fixes branch. Add .fossil-settings/binary-glob to ↵stephan2025-03-26
|\| | | | | | | | | | | | | | | | | | | | | | | | squelch warnings about *.db files on Cygwin. FossilOrigin-Name: a8328b921c5504eceacade417e16e713999eff63978caf3418fd79501590b1cb
| * | | | Fix the generate_series() enhancement from check-in [d50b784807333c54]drh2025-03-22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
| * | | | Teach the CLI that VT100-escape codes that do things like change fontdrh2025-03-21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | colors have zero-width for the purpose of laying out the columns of a table. FossilOrigin-Name: 2d0a8a6c38981552748ff5fc2eeba86590e0f116abac260a7fc9318de0a0dbda
| * | | | Fix a problem in the sqlite_dbpage() table-valued function when it isdrh2025-03-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | trying to truncate a file in locking-mode=EXCLUSIVE and the file was obtained via sqlite3_deserialize(). Problem found by dbsqlfuzz. FossilOrigin-Name: 346cf9794c6ce82ac32f7ccabc67240309306626709951593720abd198b103e3
* | | | | Test script patches from Jan Nijtmans: always use -DUSE_TCL_STUBS in ↵stephan2025-03-19
| | | | | | | | | | | | | | | | | | | | | | | | | buildtclext.tcl and improvements in how TRG is populated in testrunner.tcl. FossilOrigin-Name: aa192203aa1aa188866fe00a5d40dc7b7c72b4f38b06da8708ed0a6c8b8638a6
* | | | | Merge trunk into the cygwin-fixes branch for the shell test improvements on ↵stephan2025-03-19
|\| | | | | | | | | | | | | | | | | | | | | | | | Windows. An MSC build's make test now has zero failures. FossilOrigin-Name: 2de4efe10c2591192edca3833fc9e2fae10ebc925fb556f5b53ad483b491b5b3
| * | | | Avoid running test cases involving ANSI control characters or Unicode on ↵stephan2025-03-19
| |\ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | Windows in a slave interpreter, as that combination does not work. FossilOrigin-Name: c7fd71c77f1716c9c85d0f41a07ebd7c96f2e9d5e4c1392fefa1fb53f3cbb746
| | * | | | Avoid running test cases involving ANSI control characters or Unicodedrh2025-03-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | on Windows in a slave interpreter, as that combination does not work. FossilOrigin-Name: f6745a7355c62ee64c08e23b795f437dd74add903b55e1255c1d03f9a811170d
* | | | | | Merge trunk into the cygwin-fixes branch.stephan2025-03-19
|\| | | | | | | | | | | | | | | | | FossilOrigin-Name: 34eadd374b3c0a8c9e1f5f4a1c60fda8f16b1c56213b8c4047f96390c676b695
| * | | | | Change the generate_series() table-valued function so that its rowid is just andrh2025-03-18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
| * | | | | Fix a problem that could occur when the RHS of an IN operator was a compound ↵dan2025-03-18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
| * | | | | Enhance the fuzzcheck testing tool with new command-line options:drh2025-03-15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | --brief, and --slice M N. FossilOrigin-Name: e64132723db0c4f2b9a58932a93beb1671e42006eebc1aeaa8f320e717043051
| * | | | | Work around compilers that do not understand flexible arrays, in thedrh2025-03-15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | recovery extension and in the fuzzcheck test module. FossilOrigin-Name: f101c46cf83e532fd33034abccba496bf395ef10c161af003211614d6581d5eb
| * | | | | Use flexible arrays in the recovery extension and in the fuzzcheck test program.drh2025-03-15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Adjust the unix makefile to use -fsanitize=bounds-strict when building fuzzcheck-asan. FossilOrigin-Name: 6ea6a6b211fed1a14d7bec1ab1790dec09e2a00423860498a60b760c4a4561fa
| * | | | | Fix the generate_series extension for the case where the termination valuedrh2025-03-13
| |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* | | | | Teach testrunner.tcl to distinguish Cygwin from Windows. This gets it ↵stephan2025-03-11
| | | | | | | | | | | | | | | | | | | | | | | | | running but then all downstream tests fail, at least in part because of the build target name discrepancies between the platform which requires .exe and those which do not. FossilOrigin-Name: 2861788e479aea12354f2d34d8e6a2706d193642674ef1f4f852f24c877e0140
* | | | | Merge trunk into the cygwin-fixes branch.stephan2025-03-10
|\| | | | | | | | | | | | | | FossilOrigin-Name: f3d14433f24f89558e72a9085c950bc72440e9933d6b4ff59d6e603d25e39422
| * | | | Add an explicit db close to test/walsetlk.test to work around an unjustified ↵stephan2025-03-10
| | | | | | | | | | | | | | | | | | | | | | | | | test failure on Windows when the walsetlk tests are run in the same invocation of testfixture.exe in Windows. FossilOrigin-Name: f418de109335cd7cb29d2b587540c163bbaaa7129c662c2908ef67492139b2d7