aboutsummaryrefslogtreecommitdiff
path: root/test
Commit message (Collapse)AuthorAge
* Fix a possible printf() of a NULL string in fuzzcheck. (Passing a NULL todrh36 hours
| | | | | | | "%s" in SQLite's internal printf() prints the text "NULL", but it apparently segfaults glibc. Whatever.) [forum:/forumpost/e07d56579b|Forum post e07d56579b]. FossilOrigin-Name: 4ec69baf4f2a75585b92388cbc352836116381dce3f2d44a3b0f7d3360a17cf0
* Fix a bug in the fuzzcheck.c test program introduced by [1cccea0508f5c8b8].drh2 days
| | | FossilOrigin-Name: 90b217e11c988785d19b8efbba435250c120837492f430cf16d6d4524dd55136
* When doing an indexed row-value comparison using an IN operator where thedrh2 days
| | | | | | | | | order of the columns in the row-value need to be rearranged in order to match the index, be sure to make affinity conversions before the rearranging of columns so that the correct affinity is applied. Fix for the bug reported by [forum:/forumpost/eab63506cf|forum post eab63506cf]. This problem goes back almost nine years to [ddb5f0558c445699]. FossilOrigin-Name: 8800c13deca3717c8a9bed42ef5f09752e4ca8a31adfb4ab0545e0e2b5684bd0
* Move the flexarray union members from [527bbc1676a85a9] to the end of their ↵stephan8 days
| | | | | respective objects. FossilOrigin-Name: 3082e07926695863bd5ef51c3c4803fbe267dc0d9b6ac9a717c225459f8988ba
* Apply alignment-related patches suggested in [forum:41cd226375cd49c6 | forum ↵stephan8 days
| | | | | post 41cd226375]. FossilOrigin-Name: 527bbc1676a85a927352cd10a292afe041a72692ec0b1360e5a1ccaa19a32fcb
* Do not apply the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] ifdrh2025-07-23
| | | | | | the subquery contains a LIMIT clause. [forum:/forumpost/2025-07-23T10:59:14z|forum post 2025-07-23T10:59:14z]. FossilOrigin-Name: 314c493f273a34dff7b9f954e7553bc540bbcf5b913f779ef9ce0b9ba11acf7a
* Fix vtabH.test so that it works on windows even if there are files that ↵dan2025-07-16
| | | | | begin with "$" in the root directory. FossilOrigin-Name: 19a79219a7d52272102ff09d19e6b9b87e88e0070592fd7e6040bd8ce66ad238
* Add test case to between.test.dan2025-07-15
| | | FossilOrigin-Name: ffebbb7ae977adc6c729d30b51f2ff29d416e018d82e450d87ccd973472819c8
* Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON ↵dan2025-07-12
| | | | | clauses attached to left joins from being evaluated too early. Possible fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468]. FossilOrigin-Name: 18ba07c152294a96d510a7851a0860f982ff1e0725afeebed9a343f550f6925a
* speedtest1: in WASM builds, disable the "app" test set by default because ↵stephan2025-07-11
| | | | | that one set is triggering file-not-found errors for the db file for reasons not yet understood. FossilOrigin-Name: 9d68971c58261bce72b49c574cf07ad31add62bee814c58840b927fed7eb87b1
* Improve the accuracy of the ETC on both devtest and releasetest.drh2025-07-10
| | | FossilOrigin-Name: a3f96cafdc0e1f2eeccc6509f1f9c26d2c48668953550f299cf2805a0a063014
* Add the estkey column to the jobs table of testrunner.db. The plan is todrh2025-07-10
| | | | | | use this to collect measurements that will help generate improved ETAs for a test run. FossilOrigin-Name: 9eccf5267c6423c9dd4da1d61b62bbb6fbba44fb8089da79f89c84e8b77ff0f0
* Adjustments to test/incrblob4.test so that it works on both Linux and Macdrh2025-07-08
| | | | | | in spite of error message differences between those platforms. Minor change to termIsEquivalent() to provide 100% MC/DC. FossilOrigin-Name: 720387f8604f7cd997f1850ed62ce6ab32608155d7f02a89c695041caafc4067
* New optimizations to detect early when queries return no rows due todrh2025-07-08
|\ | | | | | | | | | | | | tables being empty. This includes the EXISTS-to-JOIN optimization that tries to transform EXISTS constraints into additional terms of the FROM clause. FossilOrigin-Name: e33da6d5dc964db817d1bc63c9083aecd93d49ee14d5198600b47eaf7c5b9331
| * Merge the latest trunk enhancements and fixes into the ↵drh2025-07-07
| |\ | | | | | | | | | | | | empty-table-optimizations branch. FossilOrigin-Name: f15cdf07573c05276a13885d74bae21a93544766344f19ef939b7a69edd1073b
| * | Improvements to the EXPLAIN QUERY PLAN output for EXISTS-to-JOIN.drh2025-07-06
| | | | | | | | | FossilOrigin-Name: 6b1ecbaa2ee405be040901dceac45d027d35c313622748ba4dbbd404e297a7fa
| * | Enhance the EXISTS-to-JOIN optimization so that it works on EXISTS subqueriesdrh2025-07-05
| | | | | | | | | | | | | | | | | | that do not have a WHERE clause, and so that it works on nested EXISTS subqueries. FossilOrigin-Name: c1d5295724f9cf7f49e0786d28016eff2d268a2b670f934d24c76787626089db
| * | Merge the latest trunk fixes and enhancements into the ↵drh2025-07-03
| |\ \ | | | | | | | | | | | | | | | | empty-table-optimizations branch FossilOrigin-Name: d4f47e04f5880e99a53089e2dd5cde64a7ea44f059d9906b5d11324896546714
| * \ \ Merge in the exists-to-join optimization that has been modifieddrh2025-07-02
| |\ \ \ | | | | | | | | | | | | | | | | | | | | to relax the requirement of having an indexed join constraint. FossilOrigin-Name: 1c1aef2b7feae29066d0330699ab634ef41f5b60cdcd479a60cb1a5409553138
| | * \ \ Merge all the latest trunk enhancements into the exists-to-join branch.drh2024-07-31
| | |\ \ \ | | | | | | | | | | | | FossilOrigin-Name: 9084a4c8726a2c7ba1c381886e29c7b86121d531282be0d63d5988d84f6f448d
| | * \ \ \ Merge the latest trunk enhancements into the exists-to-join branch.drh2024-06-27
| | |\ \ \ \ | | | | | | | | | | | | | | FossilOrigin-Name: fc643f8a12e9b7448136b281f798e18dfebe0a3df5115d930b965c8a33933e2d
| | * | | | | Add tests for the change on this branch.dan2024-06-14
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: ae19ff9ba819439fd107e745b6e8e503e5b68bfdb9da58b74035413704ad3caf
| | * | | | | Do not attempt the exists-to-join optimization for expressions from the ON ↵dan2024-06-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | clause of joins. FossilOrigin-Name: 4666433cbd9af21c2e0440b10bcb39878624a39485e2bb514553b276acb8a401
| | * | | | | Add missing calls to sqlite3exprSkipCollateAndLikely() to the enchancement ↵dan2024-06-10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | on this branch. FossilOrigin-Name: 078537d057d638389e3ab3bc04bcac53f342c7bf1d8d75222296ef42d09e9ee7
| | * | | | | Fix a crash that could occur when the SELECT in an EXISTS(SELECT ...) used ↵dan2024-06-10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | an unknown collation sequence. FossilOrigin-Name: f3009a6d7facd1ead520d588c5ad089db76d8641cd3dae076f2405492d7defcd
| | * | | | | Add extra tests for the changes on this branch.dan2024-06-08
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: a6365c778f2a6d6fa78e8520553373898f382ce73bf6496533e26291648ef5d1
| | * | | | | Experimental optimization to rewrite a SELECT with an EXISTS(...) expression ↵dan2024-06-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | in the WHERE clause as a join. FossilOrigin-Name: 972a33db0b0e924b78d5309d222d8ea298bd59c72da14ea2d14e8e2caaad1e0a
* | | | | | | Only run preupdate-hook tests in incrblob4.test if the preupdate-hook is ↵dan2025-07-07
| |_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | enabled in the build. FossilOrigin-Name: 56314b6b53c86ae131f780e20b62bdeabccba6d62dda41becc1c4b2e87cee07b
* | | | | | Rework the fix to the problem described bydrh2025-07-07
|\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [forum:/forumpost/b9647a113b465950|forum post b9647a113b] so that it provides a more complete fix that covers cases that were not resolved by the original fix, and so that it does not cause performance regressions. FossilOrigin-Name: 28db0d152d90fb5e62d03ea5caceabe8901be98522aef3dc2b54564fbc35355d
| * | | | | | Simplifications to the row-value IN operator logic. Do not let the querydrh2025-07-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | planner accept a WhereLoop for a row-value IN operator that uses the same index column more than once. FossilOrigin-Name: d2adf61f21a3ce901a2b08199ad0de191e88ef16e097c5f7a75c95ad958eff12
| * | | | | | Back out the fix at [ba7d5bad32ad6aac] because it does not always work and ↵drh2025-07-07
| | |_|_|_|/ | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | because it causes a performance regression. Add new test cases for row-value lookups of indexes that contain redundant columns, three of which are currently failing. This branch is seeking an improved solution to the redundant index column problem for row-value lookups. FossilOrigin-Name: ad8ddcefab5cc526b1cd77731e00939c672e61ca83350d28961b67635d20da03
* / | | | | Avoid invoking the preupdate hook from within sqlite3_blob_write() if the ↵dan2025-07-07
|/ / / / / | | | | | | | | | | | | | | | | | | | | cursor is already invalid. FossilOrigin-Name: 9f335b9a4e9e761a0c6afd6dc69665a24506141bde88530bf59fcbdf957ae881
* | | | | Make the value of an explicit LIMIT clause on a scalar sub-query available ↵dan2025-07-03
| | | | | | | | | | | | | | | | | | | | | | | | | to xBestIndex for simple "LIMIT 0" and "LIMIT 1" queries. FossilOrigin-Name: 33b6a63caafccc61b3193714911cd8b5dd9b7f1798054b8c7845b23688d531f2
* | | | | Make handling of LIMIT clauses in correlated sub-queries on virtual tables ↵dan2025-07-03
|/ / / / | | | | | | | | | | | | | | | | more efficient. FossilOrigin-Name: 7214cb2a5b35190a06a1040cd4c54f325d347f8d8e36a07fd76c0a421e266522
* | | | When attempting to optimize "expr AND false" to "false" anddrh2025-07-01
| | | | | | | | | | | | | | | | | | | | | | | | | | | | "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. See [forum:/forumpost/f4878de3e7dd4764|forum thread f4878de3e7]. FossilOrigin-Name: 77397bd67d918db57d5ac545d6d963194806fdabcdaa8f822b6b09e4cfe8b715
* | | | Similar fix to the previous check-in, but this time fordrh2025-06-24
| | | | | | | | | | | | | | | | | | | | sqlite3_preupdate_new(). FossilOrigin-Name: 9aaff764d508cbd9823f23cdf0c510255721bc5c09be481ebc60bd8902ceb8c5
* | | | Range check the column index on the sqlite3_preupdate_old() interfacedrh2025-06-24
| | | | | | | | | | | | | | | | | | | | | | | | and return SQLITE_MISUSE if too large. [forum:/forumpost/b617e497287235d0|Forum post b617e49728]. FossilOrigin-Name: 6a5701e6c7be25cba93e55438f950966e1dacb32eb2b23a8acc8ac53da6f0a85
* | | | Extend the pedantic enforcement of type to VIRTUAL columns.drh2025-06-18
| | | | | | | | | | | | FossilOrigin-Name: b734c74e55acb26eb61b60937bef870f4b55b2e2e7560a22362f5f31ba2fcd03
* | | | Enforce judgmental typing on STORED generated columns for STRICTdrh2025-06-18
| | | | | | | | | | | | | | | | | | | | tables. [forum:/forumpost/6caf195248a849e4|Forum post 6caf195248]. FossilOrigin-Name: 5e9279bff0482806f86657ae05ca3e916708d138bc3c3ceb3fbf454818649d44
* | | | Update walcksum.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds.dan2025-06-17
| | | | | | | | | | | | FossilOrigin-Name: 0da16f6c625bff9f2ca5624afa6dce6b5a157f44c1d56b25b92946c13217ab02
* | | | Avoid writing frames with no checksums into the wal file if a savepoint is ↵dan2025-06-17
| | | | | | | | | | | | | | | | | | | | rolled back after dirty pages have already been spilled into the wal file. Possible fix for [forum:/forumpost/b490f726db | forum post b490f726db]. FossilOrigin-Name: 3a3269fe8e925a522d5df9f011220a842fb15a9f56e785884e32d2e15abda5bb
* | | | Fix an issue going back to version 3.39.0 with transitive IS constraintsdrh2025-06-16
| | | | | | | | | | | | | | | | | | | | | | | | in queries that make use of RIGHT JOIN. Problem reported by [forum:/forumpost/68f29a2005|forum post 68f29a2005]. FossilOrigin-Name: 9441fff52cc4e19c44df1a77ffe474f409d519b270c7166ce17f99e6ea48fc1e
* | | | Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an ↵dan2025-06-12
| | | | | | | | | | | | | | | | | | | | assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. FossilOrigin-Name: a95d126e1330e1b83f42b51f97c4c216622cf38062f3b5d72ccb76313187e850
* | | | Fix the concat_ws() SQL function so that it includes empty strings in thedrh2025-06-11
| | | | | | | | | | | | | | | | | | | | concatenation. [forum:/forumpost/52503ac21d|Forum post 52503ac21d]. FossilOrigin-Name: 80a78987da484d435a8242c05c48d546d430920df713b24a9d9d9fff7ba1113d
* | | | Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and ↵dan2025-06-02
|\ \ \ \ | | | | | | | | | | | | | | | | | | | | do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. FossilOrigin-Name: 7f9c0cdd0630a41db359b188b226a1ad6a3bae1663c27169acfe25edc7fb171b
| * | | | Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows.dan2025-06-02
| | | | | | | | | | | | | | | FossilOrigin-Name: 8efb95e0d4670b9c5dbd8cf34512334f47951a8dff8fdadc8645f75076acd91f
| * | | | Updates to new test cases to run with SQLITE_ENABLE_SETLK_TIMEOUT=2 builds.dan2025-06-02
| | | | | | | | | | | | | | | FossilOrigin-Name: c6d3e3542fdf6a3428d3a2ec20c699c169ed53341dc782d81f7fe5944f769748
| * | | | Merge trunk changes into this branch.dan2025-06-02
| |\ \ \ \ | | | | | | | | | | | | FossilOrigin-Name: 7d27451804e525190f8e67da75aaeb3bf2de677021f7566c6681398e60a88c72
| * | | | | Update a few test scripts so that they run on windows.dan2025-05-31
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: 14a18f4e3a3f35e636262a253364ab1e8054ed38c0c7fd482633522cbcf5ffc4
| * | | | | Fix assert() statements in os_unix.c and os_win.c. Allow ↵dan2025-05-31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | walsetlk_recover.test to run in non-SQLITE_ENABLE_SNAPSHOT builds. FossilOrigin-Name: 9f521ecda2b8d2f383cc84e308b3a4adfcf1bd6339eb834c8fa76c8704c861b7
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 11:05:15 +0000