Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins that include changes to files matching 'test/*'
|
2025-07-01
| ||
| 15:13 | Merge trunk fixes into the empty-table-optimizations branch. (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) | |
|
2025-06-03
| ||
| 17:46 | Relax query flattener constraint (3b) and thereby allow flattening the RHS of a LEFT JOIN even if the RHS contains a virtual table. This is a performance optimization that would not normally be found on a patch branch, but downstream needs it and does not want to wait on the next full release. (check-in: 916dde1f40 user: drh tags: branch-3.50) | |
| 14:19 | Merge latest changes from the wal2 branch into this branch. (check-in: 93740658c8 user: dan tags: bedrock) | |
| 14:15 | Merge latest trunk changes into this branch. (check-in: d685bc8ce3 user: dan tags: wal2) | |
|
2025-06-02
| ||
| 18:48 | 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: 7f9c0cdd06 user: dan tags: trunk) | |
| 18:42 | Improve the accuracy of affinity and collating sequence analysis for NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. (check-in: d6a8b1ea5c user: drh tags: branch-3.50) | |
| 18:37 | Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows. (Closed-Leaf check-in: 8efb95e0d4 user: dan tags: setlk-snapshot-fix) | |
| 18:34 | Improve the accuracy of affinity and collating sequence analysis for 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]. (check-in: f184d1d236 user: drh tags: trunk) | |
| 18:09 | Updates to new test cases to run with SQLITE_ENABLE_SETLK_TIMEOUT=2 builds. (check-in: c6d3e3542f user: dan tags: setlk-snapshot-fix) | |
| 17:44 | Merge trunk changes into this branch. (check-in: 7d27451804 user: dan tags: setlk-snapshot-fix) | |
|
2025-06-01
| ||
| 16:10 | Fix VACUUM so that it works even when ATTACH_WRITE is disabled. (check-in: 42494f85ac user: drh tags: trunk) | |
|
2025-05-31
| ||
| 20:51 | Enhance "box" and "column" mode formatting in the CLI to better deal with double-wide characters. (check-in: b0de22ed0a user: drh tags: trunk) | |
| 19:55 | Update a few test scripts so that they run on windows. (check-in: 14a18f4e3a user: dan tags: setlk-snapshot-fix) | |
| 18:46 | Cherrypick obscure (fuzzer-generated) RIGHT JOIN bug fixes from trunk. (check-in: a61da8169b user: drh tags: branch-3.50) | |
| 18:16 | Fix an affinity problem caused by a USING or NATURAL JOIN on the LHS of a FULL JOIN. [forum:/forumpost/5028c785b6|Forum post 5028c785b6]. (check-in: 8d393ca07f user: dan tags: trunk) | |
| 16:17 | Relax query flattener constraint (3b) and thereby allow flattening the RHS of 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. (check-in: 1ddaa92057 user: drh tags: trunk) | |
| 15:10 | Fix assert() statements in os_unix.c and os_win.c. Allow walsetlk_recover.test to run in non-SQLITE_ENABLE_SNAPSHOT builds. (check-in: 9f521ecda2 user: dan tags: setlk-snapshot-fix) | |
| 11:02 | tcl extension: UDFs may now 'break' to return an SQL NULL. Add the (eval -asdict) flag to use a dict, instead of an array, for the eval row data. (check-in: 413a626b5c user: stephan tags: trunk) | |
|
2025-05-30
| ||
| 22:58 | Follow-up to the previous: The same optimization suppression needs to happen if the left-hand side is coming from a LEFT JOIN. (check-in: cf5b37b3a3 user: drh tags: trunk) | |
| 20:52 | If blocking locks are enabled, avoid using the busy handler when blocked by another process running recovery. (check-in: a35236757a user: dan tags: setlk-snapshot-fix) | |
| 19:55 | When synthesizing an ON constraint from a USING or NATURAL, if the left-hand 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] (check-in: 60adc78a22 user: drh tags: trunk) | |
| 18:23 | Avoid invoking the busy-handler if a blocking lock times out while attempting to open a snapshot transaction. (check-in: fe11f85fd3 user: dan tags: setlk-snapshot-fix) | |
| 16:22 | Merge trunk into tcl-cw branch. (Leaf check-in: 6747183c90 user: stephan tags: tcl-cw) | |