SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent check-ins that include changes to files matching 'test/*'

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)
11:00
Extend the fix for ticket 623eff57e76d45f6]so that it covers RIGHT JOIN in addition to LEFT JOIN. (check-in: cbd9aabaa5 user: drh tags: branch-3.50)
2025-05-29
18:44
Extend the fix for ticket [623eff57e76d45f6] so that it covers RIGHT JOIN in addition to LEFT JOIN. Problem reported by [forum:/forumpost/7dee41d32506c4ae|forum post 2025-05-29T15:10:14Z]. (check-in: 29b1e1b976 user: drh tags: trunk)
14:59
Update the reuse-schema branch to version 3.50.0 (check-in: 4b1a38ff6b user: drh tags: reuse-schema)