aboutsummaryrefslogtreecommitdiff
path: root/test
Commit message (Collapse)AuthorAge
* speedtest1: in WASM builds, disable the "app" test set by default because ↵stephan39 hours
| | | | | 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.drh2 days
| | | FossilOrigin-Name: a3f96cafdc0e1f2eeccc6509f1f9c26d2c48668953550f299cf2805a0a063014
* Add the estkey column to the jobs table of testrunner.db. The plan is todrh2 days
| | | | | | 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 Macdrh4 days
| | | | | | 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 todrh4 days
|\ | | | | | | | | | | | | 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 ↵drh5 days
| |\ | | | | | | | | | | | | empty-table-optimizations branch. FossilOrigin-Name: f15cdf07573c05276a13885d74bae21a93544766344f19ef939b7a69edd1073b
| * | Improvements to the EXPLAIN QUERY PLAN output for EXISTS-to-JOIN.drh7 days
| | | | | | | | | FossilOrigin-Name: 6b1ecbaa2ee405be040901dceac45d027d35c313622748ba4dbbd404e297a7fa
| * | Enhance the EXISTS-to-JOIN optimization so that it works on EXISTS subqueriesdrh7 days
| | | | | | | | | | | | | | | | | | 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 ↵drh9 days
| |\ \ | | | | | | | | | | | | | | | | empty-table-optimizations branch FossilOrigin-Name: d4f47e04f5880e99a53089e2dd5cde64a7ea44f059d9906b5d11324896546714
| * \ \ Merge in the exists-to-join optimization that has been modifieddrh10 days
| |\ \ \ | | | | | | | | | | | | | | | | | | | | 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 ↵dan5 days
| |_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | enabled in the build. FossilOrigin-Name: 56314b6b53c86ae131f780e20b62bdeabccba6d62dda41becc1c4b2e87cee07b
* | | | | | Rework the fix to the problem described bydrh5 days
|\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [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 querydrh5 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 ↵drh6 days
| | |_|_|_|/ | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 ↵dan6 days
|/ / / / / | | | | | | | | | | | | | | | | | | | | cursor is already invalid. FossilOrigin-Name: 9f335b9a4e9e761a0c6afd6dc69665a24506141bde88530bf59fcbdf957ae881
* | | | | Make the value of an explicit LIMIT clause on a scalar sub-query available ↵dan9 days
| | | | | | | | | | | | | | | | | | | | | | | | | 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 ↵dan9 days
|/ / / / | | | | | | | | | | | | | | | | more efficient. FossilOrigin-Name: 7214cb2a5b35190a06a1040cd4c54f325d347f8d8e36a07fd76c0a421e266522
* | | | When attempting to optimize "expr AND false" to "false" anddrh12 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | "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
| * | | | | If blocking locks are enabled, avoid using the busy handler when blocked by ↵dan2025-05-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | another process running recovery. FossilOrigin-Name: a35236757ab57c4c9b34e47c5dbc10d8f1220f8152955f5303cf9c3902ee169b
| * | | | | Avoid invoking the busy-handler if a blocking lock times out while ↵dan2025-05-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | attempting to open a snapshot transaction. FossilOrigin-Name: fe11f85fd3283bb7002f43bd8b796e9e7b67f6d1a92eb676be06b46d1458fc1d
* | | | | | Improve the accuracy of affinity and collating sequence analysis fordrh2025-06-02
| |/ / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. Initial problem report in [forum:/forumpost/829306db47|forum post 829306db47]. FossilOrigin-Name: f184d1d236e47962658a4639d9533f67a525b74cfe0f06c93e9b85fdcd02a15f
* | | | | Fix VACUUM so that it works even when ATTACH_WRITE is disabled.drh2025-06-01
| | | | | | | | | | | | | | | FossilOrigin-Name: 42494f85acb303919d3f1f2202f8b95fbd657652da4b8dc00451c10ea6c496e0
* | | | | Enhance "box" and "column" mode formatting in the CLI to better deal withdrh2025-05-31
| | | | | | | | | | | | | | | | | | | | | | | | | double-wide characters. FossilOrigin-Name: b0de22ed0abf2ea5d269f191c884d7b2be167a2ed27018c25aaa0ea238cd621a
* | | | | Fix an affinity problem caused by a USING or NATURAL JOIN on the LHS of a ↵dan2025-05-31
| | | | | | | | | | | | | | | | | | | | | | | | | FULL JOIN. [forum:/forumpost/5028c785b6|Forum post 5028c785b6]. FossilOrigin-Name: 8d393ca07fe09f48d77adb517e2e4baaa58a9251422de62a0504999205d3ea1d
* | | | | Relax query flattener constraint (3b) and thereby allow flattening the RHS ofdrh2025-05-31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | a LEFT JOIN even if the RHS contains a virtual table. This was previously disallowed by [9dbae1df75219e2a] as a performance optimization. It turns out that the constraint causes performance issues, and we do not have a record of any performance issue that it solves. FossilOrigin-Name: 1ddaa92057e550ea281d45d9860eafe69399224725548a93dd91c47a34e52152
* | | | | tcl extension: UDFs may now 'break' to return an SQL NULL. Add the (eval ↵stephan2025-05-31
| | | | | | | | | | | | | | | | | | | | | | | | | -asdict) flag to use a dict, instead of an array, for the eval row data. FossilOrigin-Name: 413a626b5c7902c1810142536c36e4ea8ee7c616ea82dfe1114199f9319091f7
* | | | | Follow-up to the previous: The same optimization suppression needs todrh2025-05-30
| | | | | | | | | | | | | | | | | | | | | | | | | happen if the left-hand side is coming from a LEFT JOIN. FossilOrigin-Name: cf5b37b3a39013d8ca9de92da2289346caf52b56daff59e19b140cc586a3421f
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-13 02:18:12 +0000