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-13
11:08
Further improvements to the EQP text for flex-search. (Leaf 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. (Leaf 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. (Leaf 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 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. (Leaf 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. (Leaf check-in: 93740658c8 user: dan tags: bedrock)
14:15
Merge latest trunk changes into this branch. (Leaf 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 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 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 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 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 (Leaf check-in: 4b1a38ff6b user: drh tags: reuse-schema)
14:59
Update the bedrock branch to version 3.50.0 (check-in: 54b8888080 user: drh tags: bedrock)
14:47
Bring the wal2 branch to to version 3.50.0. (check-in: 9f9f81ca9c user: drh tags: wal2)
14:40
Bring the begin-concurrent branch up to version 3.50.0. (Leaf check-in: 436609fdb1 user: drh tags: begin-concurrent)
2025-05-26
17:29
Fix a bug in the speedtest.tcl testing script that was introduced by [7e9845433ff26bdc] (check-in: e4ffa86aa6 user: drh tags: trunk)
16:17
On OpenBSD, do not test fuzzcheck with ubsan as part of "make devtest". (check-in: a3dabd599c user: dan tags: trunk)
2025-05-24
20:20
Change json_group_object() so that it ignores entries where the label is NULL. Forum post e5bd251fb5. (check-in: 28215d131c user: drh tags: trunk)
2025-05-23
14:52
Add the --osmalloc option to the test/speedtest.tcl testing script. Adjust ./configure so that it does not check for malloc_usable_size(). (check-in: 7e9845433f user: drh tags: trunk)
2025-05-19
17:06
Merge the latest trunk changes into the reuse-schema branch. (check-in: fc5edd557e user: drh tags: reuse-schema)
16:58
Merge the latest trunk enhancements into the bedrock branch through the wal2 intermediary. (check-in: e7d6e993df user: drh tags: bedrock)
16:52
Merge recent trunk changes into the wal2 branch. (check-in: 720d175478 user: drh tags: wal2)
16:45
Merge the latest trunk changes into the begin-concurrent branch. (check-in: 9fec43d927 user: drh tags: begin-concurrent)
2025-05-17
17:15
Merge trunk into this branch. (check-in: 58dd6d94e5 user: stephan tags: tcl-cw)
2025-05-13
18:58
Adjust the strftime() test in test/date4.test to remove flags not supported in musl libc if that environment is detected. (check-in: fc254c1eb7 user: stephan tags: trunk)
2025-05-06
23:01
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: f98aa940b4 user: drh tags: reuse-schema)
21:45
Merge the latest trunk enhancements into the bedrock branch. (check-in: 9d6517e7cc user: drh tags: bedrock)