sqlite

alter.c

Improve ALTER TABLE DROP CONSTRAINT so that it is better able to deal

2026-10-22 19:55:10 +00:00

analyze.c

Further refinements and uses for sqlite3_result_str().

2026-06-19 20:01:47 +00:00

attach.c

Handle temp triggers attached to databases clobbered by sqlite3_deserialize() in the same way as those attached to DETACHed databases.

2026-10-05 18:07:26 +00:00

auth.c

Minor optimization to the authorizer.

2026-05-02 17:30:33 +00:00

backup.c

Add new assert()s to help static analyzers realize that the code is correct.

2026-06-29 15:11:58 +00:00

bitvec.c

Improved selection of the divisor when subdividing nested Bitvec objects.

2025-06-10 19:52:21 +00:00

btmutex.c

Enable the noSharedCache fast path in SQLITE_THREADSAFE=0 builds.

2026-10-15 23:22:07 +00:00

btree.c

Merge branch-3.54 fixes into trunk

2026-10-20 17:53:47 +00:00

btree.h

Revert the fixes to backup in [1f940357f7] and [e5db80350c] and instead fix the problem reported by forum post [forum:15d82885e2 | 15d82885e2] (that a call to sqlite3_deserialize() after sqlite3_backup_init() but before the first call to sqlite3_backup_step() on the destination db of a backup could cause a crash) by deferring caching the pointer to the destination Btree until after it is locked. This addresses bug [bugs:/info/2026-06-24T08:41:13Z | 2026-06-24T08:41:13Z].

2026-06-24 11:50:08 +00:00

btreeInt.h

Prevent a corrupt database from causing a CPU stack overflow in PRAGMA

2026-08-18 13:07:33 +00:00

build.c

Ensure the internal DBFLAG_SchemaKnownOk flag is always cleared after a database schema is reset. Report [bugs:/info/2026-10-14T01:25:35Z | 2026-10-14T01:25:35Z].

2026-10-14 13:39:28 +00:00

callback.c

A better fix for the issue with RETURNING triggers on eponymous virtual tables and SQLITE_SCHEMA errors first addressed by [45d820ca22].

2025-11-13 20:37:09 +00:00

carray.c

Fix the sqlite3_carray_bind() interface so that it works with

2026-10-20 17:05:30 +00:00

complete.c

Fixes to sqlite3_incomplete() so that it does not appear to presume a

2026-10-05 17:32:25 +00:00

date.c

Fix 24:00:00 rounding of dates with negative years.

2026-10-17 13:23:07 +00:00

dbpage.c

Fix a compiler warning that comes up in gcc 4.0.1 for target powerpc-apple-darwin9

2026-08-05 15:30:43 +00:00

dbstat.c

Fix calculation of the virtual table dbstat.pgoffset field for overflow pages. Report [bugs:/info/2026-09-22T01:43:42Z | 2026-09-22T01:43:42Z].

2026-09-22 10:30:05 +00:00

delete.c

Fix indexes on typeless generated columns that pull from REAL columns so

2026-10-14 18:39:44 +00:00

expr.c

Mark the AND optimization as "not-a-real-0-or-1" so as not to confuse

2026-10-21 17:36:54 +00:00

fault.c

…

fkey.c

Allow composite FKs to use indexes with mismatched affinities as well.

2026-10-21 14:37:51 +00:00

func.c

Limit the size of the second argument of the (testing use only) SQL function

2026-10-18 18:30:00 +00:00

global.c

Put the sqlite3OomStr singleton in "const" space to ensure that it is

2026-06-19 22:17:09 +00:00

hash.c

A better fix for the issue with RETURNING triggers on eponymous virtual tables and SQLITE_SCHEMA errors first addressed by [45d820ca22].

2025-11-13 20:37:09 +00:00

hash.h

A better fix for the issue with RETURNING triggers on eponymous virtual tables and SQLITE_SCHEMA errors first addressed by [45d820ca22].

2025-11-13 20:37:09 +00:00

hwtime.h

Fix builds on i486 CPUs. [forum:/info/2025-01-25T12:58:44Z|Forum 2025-01-25T12:58:44Z].

2026-06-08 18:15:27 +00:00

in-operator.md

…

insert.c

Correctly rollback "OR REPLACE" changes following a "datatype mismatch" error.

2026-10-05 13:27:07 +00:00

json.c

Merge the latest branch-3.54 fixes onto trunk

2026-10-19 18:26:06 +00:00

legacy.c

…

loadext.c

Provide auto-init for the sqlite3_cancel_auto_extension().

2026-10-20 16:40:12 +00:00

main.c

Cap the sleep time for sqlite3_sleep() at 2147483 milliseconds to avoid

2026-10-23 10:57:51 +00:00

malloc.c

Guard against oversized index entries in databases larger than 2GiB.

2026-01-14 13:43:32 +00:00

mem0.c

…

mem1.c

…

mem2.c

…

mem3.c

…

mem5.c

…

memdb.c

Change the sqlite3_serialize() interface to return a NULL pointer if

2026-10-20 20:17:15 +00:00

memjournal.c

…

msvc.h

…

mutex_noop.c

…

mutex_unix.c

Check-in [1786fcd5b4ee6cd9] works great and generates correct code, but it

2026-05-01 16:03:51 +00:00

mutex_w32.c

Cygwin portability fixes contributed by Jan Nijtmans, including the un-exporting of some non-public-APIs which need to be reviewed closely. One test (delete_db.test) is failing but that specific failure has been a recurring theme in this environment.

2026-09-15 08:37:47 +00:00

mutex.c

Add an extra sqlite3MemoryBarrier() call in sqlite3_initialize() to avoid

2026-10-20 12:42:26 +00:00

mutex.h

Cygwin portability patches sent off-list from from Jan Nijtmans.

2026-09-01 16:26:50 +00:00

notify.c

Round one of an audit for SQLITE_ENABLE_API_ARMOR for functions exposed by JNI and those functions missing armor, as [forum:5e3fc453a69b49ca|reported in several forum posts].

2023-10-13 12:48:35 +00:00

os_common.h

…

os_kv.c

Fix a comment in os_kv.c so that it does not match "###" and thus does

2026-06-24 13:46:37 +00:00

os_setup.h

Fix -DSQLITE_OS_OTHER=0 builds.

2025-10-02 14:48:27 +00:00

os_unix.c

Avoid leaking pages when remapping a database file on unix. Forum post [forum:3cfba36128 | 3cfba36128].

2026-10-12 18:20:50 +00:00

os_win.c

Allow windows clients to open and recover a wal mode database even if an old client still has the *-shm file mapped. Forum post [forum:/info/2026-10-05T14:07:31Z | 2026-10-05T14:07:31Z].

2026-10-05 17:11:27 +00:00

os_win.h

Reduce the number of system calls in the os_win.c thunk from 81 down

2026-04-29 16:09:47 +00:00

os.c

Safer conversion from double to 64-bit integer in two places.

2026-06-17 16:57:19 +00:00

os.h

…

pager.c

When -DSQLITE_DEBUG or -DSQLITE_ENABLE_WALSTAT is used, provide the

2026-09-02 12:39:06 +00:00

pager.h

When -DSQLITE_DEBUG or -DSQLITE_ENABLE_WALSTAT is used, provide the

2026-09-02 12:39:06 +00:00

parse.y

Do not allow a simplified constant expression (example: "123 ISNULL" → "1")

2026-10-20 12:07:04 +00:00

pcache1.c

Avoid integer divides in the remaining pcache1 hash-bucket computations, extending check-in [750c37d4044c0957] from the lookup fast path to the other eight sites. Small size reduction.

2026-08-11 21:48:14 +00:00

pcache.c

Add extra assert() statements to the fixes on this branch.

2024-07-17 16:27:36 +00:00

pcache.h

Fix the include guard on pcache.h, as requested by Report

2026-08-18 00:36:18 +00:00

pragma.c

Remove unused per-index counters from integrity checking.

2026-10-22 14:03:32 +00:00

prepare.c

Do not allow surplus SQL text to come after the CREATE statement in the

2026-10-02 19:56:59 +00:00

printf.c

Never let the SQLITE_FP_PRECISION_LIMIT exceed 100 million.

2026-09-26 09:51:41 +00:00

random.c

…

resolve.c

Do not allow a simplified constant expression (example: "123 ISNULL" → "1")

2026-10-20 12:07:04 +00:00

rowset.c

…

select.c

Avoid repeated setup when reusing a materialized CTE.

2026-10-22 14:03:19 +00:00

shell.c.in

Simplify the ".clone" command so that it just makes a copy of the main

2026-10-20 19:30:24 +00:00

sqlite3.rc

Remove unnecessary "www." prefixes on domain names in URLs.

2025-04-10 10:18:07 +00:00

sqlite3ext.h

In the sqlite3ext.h file, the MSVC compiler is unable to figure out

2026-09-18 15:52:53 +00:00

sqlite.h.in

Fix the sqlite3_bind_value() interface so that it does not remove a

2026-10-23 15:30:27 +00:00

sqliteInt.h

Fix the sqlite3_bind_value() interface so that it does not remove a

2026-10-23 15:30:27 +00:00

sqliteLimit.h

Add the SQLITE_LIMIT_CTES option to sqlite3_limit(). The default is 50K.

2026-10-18 19:10:13 +00:00

status.c

Reestablish APIARMOR for the sqlite3_db_status() interface.

2025-10-14 19:21:46 +00:00

table.c

…

tclsqlite.c

When binding blobs in tclsqlite3, use sqlite3_bind_blob64() because Tcl 9 allows byte arrays larger than 32-bits and the size argument being passed there is of type Tcl_Size. Discrepancy caught and patched by Jan Nijtmans.

2026-09-19 08:28:15 +00:00

tclsqlite.h

Add config as an alias for the reconfigure makefile target. Minor makefile doc tweaks. Random typo fixes in shell.c.in and tclsqlite.h pointed out by the misspell makefile target. No code changes.

2025-08-21 17:59:28 +00:00

test1.c

Fix the sqlite3_carray_bind() interface so that it works with

2026-10-20 17:05:30 +00:00

test2.c

Change the way pointers are passed between C code and Tcl test scripts. This allows tests to be run with Fil-C builds.

2026-07-23 20:04:20 +00:00

test3.c

Create a new varint decoder that does not need to return the size of the

2026-08-12 19:42:02 +00:00

test4.c

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

2025-03-08 06:53:06 +00:00

test5.c

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

2025-03-08 06:53:06 +00:00

test6.c

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

2025-03-08 06:53:06 +00:00

test8.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test9.c

Cygwin-centric fixes from Jan Nijtmans.

2025-03-06 13:38:07 +00:00

test_autoext.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_backup.c

Cygwin-centric fixes from Jan Nijtmans.

2025-03-06 13:38:07 +00:00

test_bestindex.c

Fix a harmless compiler warning in testing code.

2025-11-14 11:02:49 +00:00

test_blob.c

Change the way pointers are passed between C code and Tcl test scripts. This allows tests to be run with Fil-C builds.

2026-07-23 20:04:20 +00:00

test_btree.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_config.c

Add SQLITE_LIMIT_TRIGGER_STEPS and -DSQLITE_MAX_TRIGGER_STEPS=n. Default maximum

2026-08-18 09:17:48 +00:00

test_delete.c

Cygwin portability patches sent off-list from from Jan Nijtmans.

2026-09-01 16:26:50 +00:00

test_demovfs.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_devsym.c

…

test_fs.c

Remove the clunky test_windirent.h and test_windirent.c files from src/

2025-06-05 20:12:41 +00:00

test_func.c

Block deep recursion in test extension functions test_eval() and eval().

2026-07-29 13:00:37 +00:00

test_hexio.c

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

2025-03-08 06:53:06 +00:00

test_init.c

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

2025-03-08 06:53:06 +00:00

test_intarray.c

GCC 13 has become more quite pedantic about the signature of functions matching the

2025-01-13 11:28:34 +00:00

test_intarray.h

…

test_journal.c

…

test_loadext.c

…

test_malloc.c

Change the way pointers are passed between C code and Tcl test scripts. This allows tests to be run with Fil-C builds.

2026-07-23 20:04:20 +00:00

test_md5.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_multiplex.c

Cygwin-centric fixes from Jan Nijtmans.

2025-03-06 13:38:07 +00:00

test_multiplex.h

…

test_mutex.c

Change the way pointers are passed between C code and Tcl test scripts. This allows tests to be run with Fil-C builds.

2026-07-23 20:04:20 +00:00

test_onefile.c

…

test_osinst.c

Cygwin-centric fixes from Jan Nijtmans.

2025-03-06 13:38:07 +00:00

test_pcache.c

Fixes for platforms with 32-bit pointers that require 64-bit values to be aligned.

2024-07-13 16:53:56 +00:00

test_quota.c

Change the way pointers are passed between C code and Tcl test scripts. This allows tests to be run with Fil-C builds.

2026-07-23 20:04:20 +00:00

test_quota.h

…

test_rtree.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_schema.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_sqllog.c

Cygwin-centric fixes from Jan Nijtmans.

2025-03-06 13:38:07 +00:00

test_superlock.c

Cygwin-centric fixes from Jan Nijtmans.

2025-03-06 13:38:07 +00:00

test_syscall.c

The MREMAP_FIXED macro (added by [4d60798b20a560be]) is not available

2026-07-27 11:19:44 +00:00

test_tclsh.c

Omit the antiquated and long-unsupport async extension since it has been

2024-10-28 15:38:53 +00:00

test_tclvar.c

Fix a few minor TCL9 compatibilities issues.

2024-08-09 22:48:11 +00:00

test_thread.c

Cygwin-centric fixes from Jan Nijtmans.

2025-03-06 13:38:07 +00:00

test_vdbecov.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_vfs.c

Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk.

2025-03-08 06:53:06 +00:00

test_window.c

First attempt at getting the build to work with Tcl 9.0.

2024-07-30 15:49:02 +00:00

test_wsd.c

…

threads.c

Fix harmless compiler warnings on Windows.

2026-03-07 17:50:32 +00:00

tokenize.c

Turn an sqlite3VMPrintf() into an sqlite3DbStrDup().

2026-03-28 13:30:47 +00:00

treeview.c

In the treeview display for Expr, show TK_ASTERISK nodes. Debugging

2026-10-07 10:07:16 +00:00

trigger.c

Fix an adverse interaction between triggers changing a table that uses

2026-10-20 00:14:02 +00:00

update.c

Correct the handling of SQLITE_IGNORE returns from authorizer calls

2026-10-19 18:20:03 +00:00

upsert.c

Fix a problem sometimes causing an UPSERT to incorrectly convert an excluded.* column from type REAL to INT in cases where doing so does not cause data loss. Bug [bugs:/info/2026-06-15T09:08:12Z | 2026-06-15T09:08:12Z].

2026-06-15 15:38:16 +00:00

utf.c

In accordance with

2026-09-24 10:04:45 +00:00

util.c

Limit the size of the second argument of the (testing use only) SQL function

2026-10-18 18:30:00 +00:00

vacuum.c

Revert the fixes to backup in [1f940357f7] and [e5db80350c] and instead fix the problem reported by forum post [forum:15d82885e2 | 15d82885e2] (that a call to sqlite3_deserialize() after sqlite3_backup_init() but before the first call to sqlite3_backup_step() on the destination db of a backup could cause a crash) by deferring caching the pointer to the destination Btree until after it is locked. This addresses bug [bugs:/info/2026-06-24T08:41:13Z | 2026-06-24T08:41:13Z].

2026-06-24 11:50:08 +00:00

vdbe.c

Fix the sqlite3_bind_value() interface so that it does not remove a

2026-10-23 15:30:27 +00:00

vdbe.h

Merge the latest trunk enhancements into the reduce-reprepares branch.

2026-08-20 14:05:49 +00:00

vdbeapi.c

Fix the sqlite3_bind_value() interface so that it does not remove a

2026-10-23 15:30:27 +00:00

vdbeaux.c

Avoid an assert() failure by clearing Vdbe.smimask when Vdbe.expmask is cleared.

2026-10-13 17:08:19 +00:00

vdbeblob.c

Avoid invoking the preupdate hook from within sqlite3_blob_write() if the cursor is already invalid.

2025-07-07 11:37:55 +00:00

vdbeInt.h

Index lookup of an integer column using value -9223372036854775808.0

2026-10-21 23:49:46 +00:00

vdbemem.c

Fix the sqlite3_bind_value() interface so that it does not remove a

2026-10-23 15:30:27 +00:00

vdbesort.c

Replace the EIGHT_BYTE_U64 macro with the in-line function sqlite3Get8byte()

2026-08-10 12:29:43 +00:00

vdbetrace.c

Enhance the tokenizer so that it is able to deal with individual tokens

2025-10-24 13:18:31 +00:00

vdbevtab.c

Avoid 32-bit overflow when calculating ncycle for ".scanstats vm".

2024-04-30 19:34:15 +00:00

vtab.c

If a virtual table is created within a SAVEPOINT, it needs to be undo by

2026-10-21 00:34:39 +00:00

vxworks.h

Add the ability to compile with -DOS_VXWORKS=1 on Linux systems, in an

2025-09-08 17:52:17 +00:00

wal.c

Ensure that all content that is copied into the -shm file during recovery

2026-10-23 09:08:13 +00:00

wal.h

When -DSQLITE_DEBUG or -DSQLITE_ENABLE_WALSTAT is used, provide the

2026-09-02 12:39:06 +00:00

walker.c

Refactor the SrcItem object so that information about subqueries is stored

2024-08-19 22:48:30 +00:00

where.c

Make the NOT INDEXED key phrase work for WITHOUT ROWID tables.

2026-10-21 20:53:42 +00:00

wherecode.c

Fix query planner error in the case of a multi-index OR on a WITHOUT ROWID

2026-10-23 12:14:17 +00:00

whereexpr.c

Remove an ALWAYS() that can sometimes be true when using

2026-10-20 09:00:48 +00:00

whereInt.h

An early attempt to implement the tree-tracker optimization.

2026-09-29 18:49:51 +00:00

window.c

Correctly handle aggregate functions that aggregate over the rows of a window function query, even if they are nested within sub-selects. Report [bugs:/info/2026-10-16T08:07:09Z | 2026-10-16T08:07:09Z].

2026-10-20 14:07:59 +00:00