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-05-10
17:09
Provide the SQLITE_BUG_COMPATIBLE_20250510 compile-time option that restores the JSON5 bug fixed in the previous check-in, in case some applications need it for legacy compatibility. (Leaf check-in: 491cf31904 user: drh tags: trunk)
15:53
Add enforcement of the obscure JSON5 syntax rule that the \0 escape sequence must not be followed by a digit. Forum post c061e87faf. (check-in: 83c7477f2b user: drh tags: trunk)
2025-05-08
16:18
Fix PRAGMA trusted_schema=OFF and similar so that it restricts the kinds of functions in CHECK constraints that the documentation says it does. It was letting through some function that it ought not have. This is a defect in [5720924cb07766cd]. See forum thread 2025-05-08T08:50Z. Additional test cases will be added separately. (check-in: 25920beebf user: drh tags: trunk)
13:51
Internal doc typo fix. No code changes. (check-in: ac2aa39f7e user: stephan tags: trunk)
2025-05-07
17:13
Fix a harmless warning about and oversize shift operation on malformed JSONB inputs. OSSFuzz 415850463. (check-in: cf8b55b3b6 user: drh tags: trunk)
2025-05-06
23:01
Merge the latest trunk enhancements into the reuse-schema branch. (Leaf check-in: f98aa940b4 user: drh tags: reuse-schema)
21:45
Merge the latest trunk enhancements into the bedrock branch. (Leaf check-in: 9d6517e7cc user: drh tags: bedrock)
21:38
Merge the latest trunk changes into the wal2 branch. (Leaf check-in: b17f5beab8 user: drh tags: wal2)
21:26
Merge all the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 55a51ba58f user: drh tags: begin-concurrent)
18:04
Fix a bug in the NOT NULL/IS NULL optimization that can cause invalid data to be used for a column if that column has a CHECK constraint that includes the NOT NULL or IS NULL operator. (check-in: 9d1f01aac9 user: drh tags: branch-3.49)
17:53
Fix a bug in the NOT NULL/IS NULL optimization of check-in [cb94350185f555c3] that can cause invalid data to be used for a column if that column has a CHECK constraint that includes the NOT NULL or IS NULL operator. Problem discovered by the Chromium fuzzer. Never seen in the wild, as far as anybody knows. (check-in: 2adaee9aa9 user: drh tags: trunk)
16:28
Fix the sqlite3VdbeTypeofColumn() function so that it works correctly even when SQLITE_DEBUG is defined. (check-in: 1d5021533e user: drh tags: trunk)
2025-05-05
23:44
Account for Tcl 8.x's lack of Tcl_BounceRefCount(). (Leaf check-in: 46b0bf5603 user: stephan tags: tcl-cw)
22:56
Part 2 of 2(?) of adding the -asdict flag to the db eval command of the Tcl interface. This needs a critical review from seasoned Tcl C API users before merging can be considered (noting that it's not planned for inclusion until 3.51). (check-in: 5368647a1f user: stephan tags: tcl-cw)
20:44
Part 1 of 2(3?) of adding the -asdict flag to the db eval command of the Tcl interface, as proposed in forum post dce85c5ab9f0bc10. This is the lowest-level part but it does nothing because the higher-level part does not yet exist to activate it, a notable consequence of which is that it's untested. Rename pArray to pTgtName because the former name is now confusingly incorrect. (check-in: 003e2c9bca user: stephan tags: tcl-cw)
16:49
Allow Tcl-defined UDFs to 'break' to result in an SQL NULL, as per suggestion in forum post 585ebac2c48f1411. (check-in: 034211985d user: stephan tags: tcl-cw)
15:12
Merge trunk into cygwin-fixes branch. 'make test' failure count = 1 (delete_db-1.3.0) both before and after the merge, (Leaf check-in: 7471088197 user: stephan tags: cygwin-fixes)
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. (check-in: b3a526a887 user: drh tags: reuse-schema)
13:02
Merge all the latest trunk enhancements into the bedrock branch. (check-in: 3215186aa9 user: drh tags: bedrock)
12:56
Merge the latest trunk enhancements into the wal2 branch. (check-in: c68d0d3530 user: drh tags: wal2)
12:41
Merge all recent trunk enhancements into the begin-concurrent branch. (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. (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 (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)