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-09-08
15:15
Add "PRAGMA wal_checkpoint = noop" and SQLITE_CHECKPOINT_NOOP. To request a checkpoint that checkpoints zero frames. (check-in: 4384ad8918 user: dan tags: trunk)
14:40
Merge trunk changes into this branch. (Leaf check-in: 3bac76a86b user: dan tags: wal-checkpoint-noop)
2025-09-05
11:20
Add tests to check that SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER is working. (check-in: beb092d810 user: dan tags: trunk)
2025-09-04
19:33
Add "PRAGMA wal_checkpoint = noop" and SQLITE_CHECKPOINT_NOOP. To request a checkpoint that checkpoints zero frames. (check-in: 48be3d020c user: dan tags: wal-checkpoint-noop)
16:26
Merge latest changes from the wal2 branch into the bedrock branch. (Leaf check-in: 21e4744de2 user: stephan tags: bedrock)
16:02
Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: 8b881fd828 user: stephan tags: wal2)
2025-09-02
14:59
Add test case for pushing WHERE constraints into a UNION sub-query that uses virtual tables. (check-in: 13c80e903e user: dan tags: trunk)
2025-08-29
16:51
Update test script reservebytes.test so that it works with the "prepare" permutation. (check-in: 4ac774364b user: dan tags: trunk)
2025-08-28
12:04
Merge trunk into tcl-init branch. (check-in: 64c802ca10 user: stephan tags: tcl-init)
2025-08-27
11:21
Add test to ensure that changing the number of reserved bytes in a database using VACUUM does not confuse other connections in stock SQLite. (check-in: 6bf54bbc4d user: dan tags: trunk)
2025-08-25
14:27
Check that certain ON clauses do not refer to tables to their right as a separate step after parsing a SELECT statement, instead of as part of the planner stage. Fix for [forum:ccfb3b5052 | forum post ccfb3b5052]. (check-in: e0beda7ffe user: dan tags: trunk)
11:47
Add test case to this branch to show that it handles cases where ON clauses use select-list aliases to refer to columns to their right. (Closed-Leaf check-in: 4d34ab4acf user: dan tags: on-clause-fix-3rd-try)
2025-08-23
16:26
Fix the cases in joinI.test on this branch. (check-in: 23ac237731 user: dan tags: on-clause-fix-3rd-try)
11:09
Fix cksumvfs test case added by [e3bd1feccaee8ff2] so that it works with varying page sizes. Test case change only - no changes to code. (check-in: b6f8f086da user: drh tags: trunk)
2025-08-22
23:06
Minor tweaks to this option, to make it ready to land on trunk, if we decide to do so. (Closed-Leaf check-in: f01ed7316d user: drh tags: on-clause-option-4)
22:02
Disable the query flattener if the subquery is a join and the subquery is anywhere to the right of a RIGHT JOIN and if there is an ON clause on the subquery. (check-in: 7776ab3f5a user: drh tags: on-clause-option-4)
19:30
Steal the test/joinI.test from the on-clause-error-fix branch that demonstrates that this branch does not work. (check-in: d163535ec8 user: drh tags: on-clause-fix-3rd-try)
16:25
Attempt to detect errors cause by ON clauses that refer to tables to the right of themselves while resolving names, instead of later on after query-flattening and other operations have complicated things. (check-in: 4bb527d337 user: dan tags: on-clause-error-fix)
2025-08-20
23:29
The sqlite3_prepare() and similar interfaces should not return SQLITE_ERROR_RETRY. [forum:/forumpost/aa61ab56adb56159|Forum post aa61ab56]. (check-in: 4e473cf0c2 user: drh tags: trunk)
15:42
Avoid returning SQLITE_ERROR_RETRY if collation sequences associated with the table's PK cannot be found when creating an index. Possible fix for [forum:aa61ab56ad | forum post aa61ab56ad]. (check-in: ac649e5b9c user: dan tags: create-index-error-retry-fix)
2025-08-13
19:13
Have cksumvfs write checksums to the database file only, not the wal file. Writing them to the wal file breaks wal file recovery. (check-in: e3bd1fecca user: dan tags: trunk)
18:37
In cksumvfs, do not write checksums to the wal file, as this prevents recovery from working. (Closed-Leaf check-in: 5bf48c7e31 user: dan tags: cksumvfs-wal-fix)
14:40
Fix a problem with the checksum-vfs and direct-overflow-reads. Forum post [forum:350e147cd1 | 350e147cd1]. (check-in: 7b7ce5f17f user: dan tags: trunk)
14:35
Fix a problem with the checksum-vfs and direct-overflow-reads. (Closed-Leaf check-in: 8288edb9f9 user: dan tags: cksum-direct-ovfl-fix)
2025-08-12
19:02
Fix a problem with reading wal mode databases from UNC shares on windows introduced by [e88212b10a7829ff]. (check-in: f341e78129 user: dan tags: trunk)
17:55
On windows, when opening a UNC path, fall back to using a single file handle shared between all connections for locking. (check-in: 5c0202d96c user: dan tags: win-unc-fix)
2025-08-06
19:19
Do not allow the number of terms in an ORDER BY or GROUP BY clause to exceed the maximum number of columns in a table. (check-in: cb41512386 user: drh tags: branch-3.50)
19:12
Do not allow the number of terms in an ORDER BY or GROUP BY clause to exceed the maximum number of columns in a table. (check-in: 139e587c7b user: drh tags: trunk)
2025-08-05
23:01
Fix a possible printf() of a NULL string in fuzzcheck. (Passing a NULL to "%s" in SQLite's internal printf() prints the text "NULL", but it apparently segfaults glibc. Whatever.) [forum:/forumpost/e07d56579b|Forum post e07d56579b]. (check-in: 4ec69baf4f user: drh tags: trunk)
00:13
When doing an indexed row-value comparison using an IN operator where the order of the columns in the row-value need to be rearranged in order to match the index, be sure to make affinity conversions before the rearranging of the row-value columns. (check-in: aba0285ff2 user: drh tags: branch-3.50)
2025-08-04
23:37
Fix a bug in the fuzzcheck.c test program introduced by [1cccea0508f5c8b8]. (check-in: 90b217e11c user: drh tags: trunk)
23:05
When doing an indexed row-value comparison using an IN operator where the order of the columns in the row-value need to be rearranged in order to match the index, be sure to make affinity conversions before the rearranging of columns so that the correct affinity is applied. Fix for the bug reported by [forum:/forumpost/eab63506cf|forum post eab63506cf]. This problem goes back almost nine years to [ddb5f0558c445699]. (check-in: 8800c13dec user: drh tags: trunk)
2025-07-31
12:25
Ensure that stack space allocated for a flexible array has the correct alignment. Fix to [d4307a0d43f42e96] to for some compilers (DeveloperStudio) and platforms (Sparc). (check-in: 1cccea0508 user: drh tags: trunk)
2025-07-30
21:34
Move the flexarray union members from [527bbc1676a85a9] to the end of their respective objects. (check-in: 3082e07926 user: stephan tags: solaris-alignment)
19:48
Apply alignment-related patches suggested in [forum:41cd226375cd49c6 | forum post 41cd226375]. (check-in: 527bbc1676 user: stephan tags: solaris-alignment)
2025-07-23
12:48
Do not apply the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] if the subquery contains a LIMIT clause. [forum:/forumpost/2025-07-23T10:59:14z|forum post 2025-07-23T10:59:14z]. (check-in: 314c493f27 user: drh tags: trunk)
2025-07-17
15:38
Merge the latest trunk enhancments into the reuse-schema branch. (Leaf check-in: 12dbb05b84 user: drh tags: reuse-schema)
15:31
Merge all of the trunk enchancements into the bedrock branch. (check-in: ba2174bdca user: drh tags: bedrock)
15:24
Merge the latest trunk enhancements into the wal2 branch. (check-in: 69794955d8 user: drh tags: wal2)
15:18
Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 0b2979f0c0 user: drh tags: begin-concurrent)
14:02
Merge the 3.50.3 changes into the reuse-schema-3.50 branch (check-in: 5a70ffd63c user: drh tags: reuse-schema-3.50)
2025-07-16
17:24
Fix vtabH.test so that it works on windows even if there are files that begin with "$" in the root directory. (check-in: 19a79219a7 user: dan tags: trunk)
2025-07-15
19:00
Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468]. (check-in: 9f184f8dfa user: dan tags: trunk)
18:51
Add test case to between.test. (Closed-Leaf check-in: ffebbb7ae9 user: dan tags: vtab-leftjoin-fix)
11:27
Fix the date in bestindexE.test. (check-in: f3fdcfa183 user: dan tags: vtab-setup-cost)
2025-07-12
18:14
Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Possible fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468]. (check-in: 18ba07c152 user: dan tags: vtab-leftjoin-fix)
16:35
Experimental change to allow virtual table xBestIndex() methods to specify an initial setup cost for a plan. (check-in: b67babf1ab user: dan tags: vtab-setup-cost)
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)