SQLite

Timeline
Login

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

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

2025-04-30
14:37
Fix a harmless problem in the CLI in which SQL errors that occur during the ".schema" command are properly ignored, yes still appear in the ".log" output. Forum post 42fe6520b8 (check-in: 20abf1ec10 user: drh tags: trunk)
12:48
Fix an issue in Bloom filters on RHS subsqueries to IN operators. See forum post 792a09cb3d for a description of the problem. Also improve comments related to [baa83b460c677c21] which was origin of the problem. (check-in: cdef486e21 user: drh tags: trunk)
2025-04-25
12:39
Fix an off-by-one error in an assert(), discovered by oss-fuzz. This is a harmless error in as much as assert()s are disabled in production builds, and because the off-by-one only occurs on nonsensical CREATE INDEX statements. (check-in: 3e627d66eb user: drh tags: trunk)
2025-04-21
23:44
Remove an extra conditional that was inserted earlier today and which is unreachable. (check-in: 5ea56af2d2 user: drh tags: trunk)
20:58
Further improvements to the decision of whether or not a BLOB input is JSONB. (check-in: 6538813cb8 user: drh tags: trunk)
19:53
Do a better job of providing bug compatibility with SQLite 3.44.0. See forum thread 07e206fcd6 for background. (check-in: 614d061b32 user: drh tags: trunk)
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-17
19:01
When logging errors using sqlite3_log() and the error text includes the text of an SQL statement, but the SQL statement text at the end so that if the error message buffer overflows it is the SQL statement text that gets truncated, not the statement of the problem. (check-in: de0968226e user: drh tags: trunk)
17:46
Increase the size of the output buffer for sqlite3_log(). (check-in: a64e8491c9 user: drh tags: trunk)
2025-04-16
17:36
Attempt to provide EBCDIC translations to the tables in the JSON implementation. The SQLite developers do not have access to any computers using EBCDIC and so have no way to test this patch, and cannot vouch for its accuracy. (check-in: 84e698f384 user: drh tags: trunk)
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)
19:53
Fix a minor typo in a code comment. (check-in: 158e8c4fd7 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
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-08
20:00
Remove an incorrect ALWAYS() macro. Forum post 2025-04-08T19:16:42Z. (check-in: 062cca9c63 user: drh tags: trunk)
2025-04-06
10:22
Fix a harmless code typo introduced by [b57e3c3db00a6bc6] and reported by forum post 09957d8b2a. (check-in: f3a6cdb89b user: drh tags: trunk)
2025-04-04
13:25
Merge trunk (Leaf check-in: 436a01e1b1 user: jan.nijtmans tags: cygwin-fixes)
13:23
The win32lock and win32longpath tests don't work on Cygwin (check-in: 32ef3f26e7 user: jan.nijtmans tags: trunk)
06:49
Merge trunk (check-in: 79dfaf05b8 user: jan.nijtmans tags: cygwin-fixes)
2025-04-01
16:32
The json-blob-overwrite optimization seeks to prevent unnecessary I/O and data movement when making small changes to the middle of a large JSONB. (check-in: 4a3d7b0421 user: drh tags: trunk)
16:26
Fix a typo accidently added to the prior check-in. (Closed-Leaf check-in: fb2f283038 user: drh tags: json-opt)
15:17
This is an experimental optimization that attempts to keep a JSONB value the same size (same number of bytes) after doing a replace of an elements with a slightly smaller element, by denormalizing the size field. This can perhaps avoid unnecessary page updates and memmove() operations when making small changes in the middle of a large JSONB value. (check-in: b5de9584b7 user: drh tags: json-opt)
2025-03-31
23:18
Fix a harmless typo in a code comment. (check-in: dd251377bd user: drh tags: trunk)
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-29
11:50
Minor shell-internal doc addition. No functional changes. (check-in: 01b99c8a28 user: stephan tags: trunk)
2025-03-28
15:36
CLI shell: make (.output off) an alias for (.output /dev/null) or (.output nul), depending on the platform. Discussed in forum post 633979ce307f1cc6. (check-in: 0f11087b84 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)
07:09
Merge trunk (check-in: 6a449918c2 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:30
Fix for forum-post b5fde3596c. Also fix encoding issue for non-ASCII characters. Also includes a fix from Stephan Beal, about a missing <stdint.h> include. (Closed-Leaf check-in: e60198001e user: jan.nijtmans tags: tclsqlite-db-copy-fix)
14:13
Merge trunk. Some additional test-fixes for Cygwin (check-in: b36adadfa2 user: jan.nijtmans tags: cygwin-fixes)
10:59
Fix an off-by-one bug in the ".dbtotxt" command from the shell that results in incorrect output. (check-in: 2345094e87 user: drh tags: trunk)
2025-03-26
22:23
Reduce the delay caused by anti-virus retries in Windows when attempting to open a database file with insufficient permission. (check-in: d25c8a6222 user: drh tags: trunk)
17:05
On winOpen(), redo the read-only test on every retry attempt. Just don't retry the winAccess() call. (Closed-Leaf check-in: ccdd67ad9a user: drh tags: winopen-retry)
15:51
Further attempted improvements at fast-fail for an inaccessible database file. (check-in: cdeb21a312 user: drh tags: winopen-retry)
14:45
Attempt to reduce the amount of retry time when trying to open an inaccessible database file on Windows. See forum thread e7991420f5 (check-in: 986e45912c user: drh tags: winopen-retry)
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-24
23:08
Clarify and reduce redundancy in an assert() in walChecksumBytes(). (check-in: 3c53abf5e6 user: drh tags: trunk)
15:09
Replace the general-purpose sqlite3_exec() interface with an optimized version during schema parsing, with the hopes of improving performance. And performance does increase, but by so very little (0.2% or less) that it does not seem worth the extra complication. Changed saved for historical reference. (Closed-Leaf check-in: 455186cad2 user: drh tags: schema-parsing-experiment)
2025-03-22
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)