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-04-21
13:08
Merge all the latest trunk enhancements into the reuse-schema branch. (Leaf check-in: b3a526a887 user: drh tags: reuse-schema)
13:02
Merge all the latest trunk enhancements into the bedrock branch. (Leaf check-in: 3215186aa9 user: drh tags: bedrock)
12:56
Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: c68d0d3530 user: drh tags: wal2)
12:41
Merge all recent trunk enhancements into the begin-concurrent branch. (Leaf check-in: 2866119c75 user: drh tags: begin-concurrent)
2025-04-16
10:53
Correctly handle the case of a multi-column UNIQUE constraint that contains the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. (Leaf check-in: ba7d5bad32 user: drh tags: branch-3.49)
2025-04-15
21:59
Correctly handle the case of a multi-column UNIQUE constraint that contains the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. Reported by forum post b9647a113b. Problem introduced by [723f1be3d4a905a6], part of ticket [da78413751863]. (check-in: d22475b81c user: drh tags: trunk)
2025-04-14
19:43
Improved estimate on the number of output rows in a recursive common table expression that uses the UNION operator. Follow-up to [f911f1c4977fbcae] and it's output row estimate changes associated with DISTINCT queries. (check-in: 92513f6bce user: drh tags: trunk)
2025-04-10
19:54
Improved detection of run-time errors (ex: OOM errors) in speedtest1. (check-in: 0e5e0e2f55 user: drh tags: trunk)
19:39
Provide new command-line options --hard-heap-limit and --soft-heap-limit for speedtest1. (check-in: 578e9fedea user: drh tags: trunk)
19:03
Be sure that speedtest1 reports any errors that it encounters while running the speed tests. (check-in: 8c8b1a99bc user: drh tags: trunk)
15:01
Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. Forum post 2025-04-08T14:18:45Z. (check-in: 979f384a93 user: dan tags: trunk)
14:53
Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. (Closed-Leaf check-in: d82725dcae user: dan tags: forum-0109bca824)
10:18
Remove unnecessary "www." prefixes on domain names in URLs. (check-in: 20acd630b9 user: drh tags: trunk)
2025-04-04
13:23
The win32lock and win32longpath tests don't work on Cygwin (check-in: 32ef3f26e7 user: jan.nijtmans tags: trunk)
06:47
win32longpath makes no sense on Cygwin. All tests pass now (except delete_db-1.3.0) (check-in: 5cf5d2cedf user: jan.nijtmans tags: cygwin-fixes)
2025-03-31
14:12
Feature-complete. Not all test-cases pass. Merge trunk. (check-in: 6552bfb70a user: jan.nijtmans tags: cygwin-fixes)
11:24
Add the ?ENCODING? parameter to the "db copy" command. If used, it will translate from the given encoding to UTF-8 (Leaf check-in: ac27c2f816 user: jan.nijtmans tags: db-copy-encoding)
2025-03-28
16:31
Correct two tests in shell1.test which were broken by the addition of new output in [0f11087b8475]. (check-in: 909dd0a02a user: stephan tags: trunk)
08:59
Second round of cygwin fixes: this makes the full "unix" vfs usable with Cygwin as well. Not all tests are working yet. WIP! (check-in: 648aca5b47 user: jan.nijtmans tags: cygwin-fixes)
2025-03-27
23:29
Merge cygwin and tclsqlite fixes into trunk. (check-in: 121f4d97f9 user: drh tags: trunk)
17:25
shell1.test: == => eq (check-in: 99fdd19193 user: jan.nijtmans tags: cygwin-fixes)
14:37
More ==/!= => eq/ne fixes (check-in: 2aa6c4fa6c user: jan.nijtmans tags: cygwin-fixes)
14:32
In Tcl, always use eq/ne for comparing strings, not ==/!= (check-in: f96a5346e3 user: jan.nijtmans tags: cygwin-fixes)
14:13
Merge trunk. Some additional test-fixes for Cygwin (check-in: b36adadfa2 user: jan.nijtmans tags: cygwin-fixes)
2025-03-26
00:02
Merge trunk into cygwin-fixes branch. Add .fossil-settings/binary-glob to squelch warnings about *.db files on Cygwin. (check-in: a8328b921c user: stephan tags: cygwin-fixes)
2025-03-22
23:03
Fixes for two problems with the generate_series() table-valued function. (check-in: f5aea14e6e user: drh tags: branch-3.49)
22:55
Fix the generate_series() enhancement from check-in [d50b784807333c54] so that it works even if the number that "value" is being compared against is a non-integer floating point number. Bug reported by forum post 0d5d63257. (check-in: c113e31b81 user: drh tags: trunk)
14:29
Merge the latest trunk changes into the reuse-schema branch. (check-in: e9496b1bbc user: drh tags: reuse-schema)
14:23
Merge the latest trunk enhancements into the bedrock branch. (check-in: 4196efe83c user: drh tags: bedrock)
14:19
Merge the latest trunk enhancements into the wal2 branch. (check-in: 80e6ddd560 user: drh tags: wal2)
14:12
Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: cb5e024b6a user: drh tags: begin-concurrent)
2025-03-21
18:15
Teach the CLI that VT100-escape codes that do things like change font colors have zero-width for the purpose of laying out the columns of a table. (check-in: 2d0a8a6c38 user: drh tags: trunk)
2025-03-20
11:47
Fix a problem in the sqlite_dbpage() table-valued function when it is trying to truncate a file in locking-mode=EXCLUSIVE and the file was obtained via sqlite3_deserialize(). Problem found by dbsqlfuzz. (check-in: 346cf9794c user: drh tags: trunk)
2025-03-19
13:49
Test script patches from Jan Nijtmans: always use -DUSE_TCL_STUBS in buildtclext.tcl and improvements in how TRG is populated in testrunner.tcl. (check-in: aa192203aa user: stephan tags: cygwin-fixes)
13:13
Merge trunk into the cygwin-fixes branch for the shell test improvements on Windows. An MSC build's make test now has zero failures. (check-in: 2de4efe10c user: stephan tags: cygwin-fixes)
11:53
Avoid running test cases involving ANSI control characters or Unicode on Windows in a slave interpreter, as that combination does not work. (check-in: c7fd71c77f user: stephan tags: trunk)
10:14
Merge trunk into the cygwin-fixes branch. (check-in: 34eadd374b user: stephan tags: cygwin-fixes)
2025-03-18
20:28
Fix two obscure logic problems that cause incorrect answers, found by a third-party fuzzer. (check-in: 1a8f763c31 user: drh tags: branch-3.49)
20:15
Change the generate_series() table-valued function so that its rowid is just an alias for its value. This allows it to be used as the RHS operand of a RIGHT JOIN. This fixes the issue raised by forum post 1e17219c88. (check-in: 77db4d85e7 user: drh tags: trunk)
19:21
Fix a problem that could occur when the RHS of an IN operator was a compound SELECT featuring an ORDER BY on a subquery that was flattened into one of the component SELECTs introduced by [baa83b460c677c21]. Forum post /forumpost/1e17219c88. (check-in: 7101ccd533 user: dan tags: trunk)
2025-03-15
23:42
Enhance the fuzzcheck testing tool with new command-line options: --brief, and --slice M N. (check-in: e64132723d user: drh tags: trunk)
20:35
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 271e0373a8 user: drh tags: reuse-schema)
20:32
Merge the latest trunk enhancements into the bedrock branch via the wal2 intermediary. (check-in: b1860b6372 user: drh tags: bedrock)
20:28
Merge the latest trunk enhancements into the wal2 branch. (check-in: c8d8f613ed user: drh tags: wal2)
20:25
Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 624225499c user: drh tags: begin-concurrent)
19:55
Make use of the C99 flexible array feature, when available, so that the -fsanitize=bounds-strict option can be used, when available. Forum thread 311dbf9a1c. (check-in: d4307a0d43 user: drh tags: trunk)
19:00
Work around compilers that do not understand flexible arrays, in the recovery extension and in the fuzzcheck test module. (Closed-Leaf check-in: f101c46cf8 user: drh tags: flex-array)
13:04
Use flexible arrays in the recovery extension and in the fuzzcheck test program. Adjust the unix makefile to use -fsanitize=bounds-strict when building fuzzcheck-asan. (check-in: 6ea6a6b211 user: drh tags: flex-array)
2025-03-14
11:14
Minor doc corrections for the sahpool-digest fix and merge in current trunk. (Closed-Leaf check-in: 500f2e6ec7 user: stephan tags: sahpool-digest)
2025-03-13
18:51
Fix the generate_series extension for the case where the termination value is not an even multiple of the step from the start value and there is also a value=NNN constraint in the WHERE clause. Forum post bf2dc8e9 (check-in: 75e72e3b0d user: drh tags: trunk)