Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins that include changes to files matching 'test/*'
2025-07-11
| ||
14:18 | Merge trunk into column-text-blob-v2 branch. (Leaf check-in: a5369e67f7 user: stephan tags: column-text-blob-v2) | |
11:06 | speedtest1: in WASM builds, disable the "app" test set by default because that one set is triggering file-not-found errors for the db file for reasons not yet understood. (check-in: 9d68971c58 user: stephan tags: trunk) | |
2025-07-10
| ||
20:45 | Improve the accuracy of the ETC on both devtest and releasetest. (check-in: a3f96cafdc user: drh tags: trunk) | |
17:19 | Add the estkey column to the jobs table of testrunner.db. The plan is to use this to collect measurements that will help generate improved ETAs for a test run. (check-in: 9eccf5267c user: drh tags: trunk) | |
2025-07-08
| ||
20:28 | Adjustments to test/incrblob4.test so that it works on both Linux and Mac in spite of error message differences between those platforms. Minor change to termIsEquivalent() to provide 100% MC/DC. (check-in: 720387f860 user: drh tags: trunk) | |
19:53 | New optimizations to detect early when queries return no rows due to tables being empty. This includes the EXISTS-to-JOIN optimization that tries to transform EXISTS constraints into additional terms of the FROM clause. (check-in: e33da6d5dc user: drh tags: trunk) | |
2025-07-07
| ||
20:47 | Only run preupdate-hook tests in incrblob4.test if the preupdate-hook is enabled in the build. (check-in: 56314b6b53 user: dan tags: trunk) | |
18:35 | Merge the latest trunk enhancements and fixes into the empty-table-optimizations branch. (check-in: f15cdf0757 user: drh tags: empty-table-optimizations) | |
16:28 | Rework the fix to the problem described by 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. (Leaf check-in: 4084ac20f4 user: drh tags: branch-3.50) | |
16:19 | Rework the fix to the problem described by [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. (check-in: 28db0d152d user: drh tags: trunk) | |
15:40 | Simplifications to the row-value IN operator logic. Do not let the query planner accept a WhereLoop for a row-value IN operator that uses the same index column more than once. (Closed-Leaf check-in: d2adf61f21 user: drh tags: redundant-idx-columns) | |
11:37 | Avoid invoking the preupdate hook from within sqlite3_blob_write() if the cursor is already invalid. (check-in: 9f335b9a4e user: dan tags: trunk) | |
10:54 | Back out the fix at [ba7d5bad32ad6aac] because it does not always work and 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. (check-in: ad8ddcefab user: drh tags: redundant-idx-columns) | |
2025-07-06
| ||
01:19 | Improvements to the EXPLAIN QUERY PLAN output for EXISTS-to-JOIN. (check-in: 6b1ecbaa2e user: drh tags: empty-table-optimizations) | |
2025-07-05
| ||
23:33 | Enhance the EXISTS-to-JOIN optimization so that it works on EXISTS subqueries that do not have a WHERE clause, and so that it works on nested EXISTS subqueries. (check-in: c1d5295724 user: drh tags: empty-table-optimizations) | |
2025-07-04
| ||
10:17 | Merge trunk into column-text-blob-v2 branch. (check-in: f73460d4f0 user: stephan tags: column-text-blob-v2) | |
2025-07-03
| ||
20:51 | Merge the latest trunk fixes and enhancements into the empty-table-optimizations branch (check-in: d4f47e04f5 user: drh tags: empty-table-optimizations) | |
16:05 | Fix a few cases where LIMIT clauses that were part of scalar sub-queries on virtual tables were not being passed to xBestIndex methods correctly. (check-in: 960a8e6fc9 user: dan tags: trunk) | |
15:32 | Make the value of an explicit LIMIT clause on a scalar sub-query available to xBestIndex for simple "LIMIT 0" and "LIMIT 1" queries. (check-in: 33b6a63caa user: dan tags: vtab-limit-fixes) | |
14:28 | Make handling of LIMIT clauses in correlated sub-queries on virtual tables more efficient. (check-in: 7214cb2a5b user: dan tags: vtab-limit-fixes) | |
2025-07-02
| ||
20:46 | Merge in the exists-to-join optimization that has been modified to relax the requirement of having an indexed join constraint. (check-in: 1c1aef2b7f user: drh tags: empty-table-optimizations) | |
07:52 | Add test1.c tcl bindings for sqlite3_column_text/blob_v2(). Replace, essentially randomly, some of the v1 API calls in capi2.test and capi2.test with the v2 calls to ensure identical results. Add a couple new tests comparing results between v1 and v2. (check-in: a3ca0adbaf user: stephan tags: column-text-blob-v2) | |
2025-07-01
| ||
15:13 | Merge trunk fixes into the empty-table-optimizations branch. (Closed-Leaf check-in: 63306e447e user: drh tags: empty-table-optimizations) | |
12:49 | When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. (check-in: 355c7902de user: drh tags: branch-3.50) | |
12:43 | When attempting to optimize "expr AND false" to "false" and "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]. (check-in: 77397bd67d user: drh tags: trunk) | |
2025-06-28
| ||
14:36 | Merge all the latest trunk fixes and enhancements into the reuse-schema branch. (Leaf check-in: 6e1f97d99b user: drh tags: reuse-schema) | |
14:35 | Merge the 3.50.2 changes into the reuse-schema-3.50 branch. (Leaf check-in: b66f853a24 user: drh tags: reuse-schema-3.50) | |
14:30 | Merge the latest trunk fixes and enhancements into the bedrock branch. (Leaf check-in: a6f6fbe617 user: drh tags: bedrock) | |
14:24 | Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: e7867c3992 user: drh tags: wal2) | |
14:16 | Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 1ae8d60237 user: drh tags: begin-concurrent) | |
2025-06-24
| ||
18:27 | Similar fix to the previous check-in, but this time for sqlite3_preupdate_new(). (check-in: 9aaff764d5 user: drh tags: trunk) | |
15:58 | Range check the column index on the sqlite3_preupdate_old() interface and return SQLITE_MISUSE if too large. [forum:/forumpost/b617e497287235d0|Forum post b617e49728]. (check-in: 6a5701e6c7 user: drh tags: trunk) | |
2025-06-18
| ||
19:04 | Extend the pedantic enforcement of type in STRICT tables to cover VIRTUAL columns. (check-in: b734c74e55 user: drh tags: trunk) | |
16:17 | Enforce judgmental typing on STORED generated columns for STRICT tables. [forum:/forumpost/6caf195248a849e4|Forum post 6caf195248]. (check-in: 5e9279bff0 user: drh tags: trunk) | |
2025-06-17
| ||
19:32 | Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Also fix a corner case in the previous check-in on this branch. (check-in: c232fa2bfc user: drh tags: branch-3.50) | |
19:10 | Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. (check-in: 5973f9b9aa user: drh tags: trunk) | |
18:17 | Update walcksum.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (Closed-Leaf check-in: 0da16f6c62 user: dan tags: forum-b490f726db-fix) | |
11:36 | Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Possible fix for [forum:/forumpost/b490f726db | forum post b490f726db]. (check-in: 3a3269fe8e user: dan tags: forum-b490f726db-fix) | |
2025-06-16
| ||
18:04 | Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. (check-in: 6c5f4c8af9 user: drh tags: branch-3.50) | |
17:36 | Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. Problem reported by [forum:/forumpost/68f29a2005|forum post 68f29a2005]. (check-in: 9441fff52c user: drh tags: trunk) | |
2025-06-13
| ||
11:08 | Further improvements to the EQP text for flex-search. (check-in: 40a83da503 user: drh tags: flex-search) | |
00:50 | Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: 680e278c3e user: drh tags: flex-search) | |
2025-06-12
| ||
19:02 | Preliminary code generation for flex-search. Add a no-op IfUseIndex opcode as a placeholder. (check-in: 521948c64f user: drh tags: flex-search) | |
13:40 | Merge latest trunk enhancements and fixes into the experimental flex-search branch. (check-in: 51c89c886f user: drh tags: flex-search) | |
13:27 | Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (check-in: 954efdd30d user: drh tags: branch-3.50) | |
07:35 | Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (check-in: a95d126e13 user: dan tags: trunk) | |
2025-06-11
| ||
00:05 | Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. (check-in: e0ce6dab46 user: drh tags: branch-3.50) | |
00:01 | Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. [forum:/forumpost/52503ac21d|Forum post 52503ac21d]. (check-in: 80a78987da user: drh tags: trunk) | |
2025-06-06
| ||
15:43 | Update the reuse-schema branch to the 3.50.1 patch release. (check-in: b5463d7560 user: drh tags: reuse-schema-3.50) | |
2025-06-05
| ||
11:57 | Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. (check-in: 8ac4525a2e user: drh tags: branch-3.50) | |