SQLite

Timeline
Login

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

50 most recent check-ins

2025-12-26
20:13
Work around the Windows "Worst-Fit" bug in the "sqldiff.exe" program. (leaf check-in: f418515873 ... user: drh tags: trunk)
17:23
To ensure that the sqlite3_hard_heap_limit() call it makes is effective, add "sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 1);" to fuzzcheck.c. (check-in: f7736af849 ... user: dan tags: trunk)
2025-12-24
18:12
Doc typo fixes in the configure script pieces. (check-in: 8ab37d9fb9 ... user: stephan tags: trunk)
14:03
Enhance the omit-noop-join optimization so that it is able to omit a chain of noop-joins. Optimization improvement suggested by forum post 11a53f2bad. (check-in: 5a85b83b9f ... user: drh tags: trunk)
2025-12-23
17:24
Additional changes to support the ".schema" command on builds that omit virtual tables. (check-in: 6b5c0374fa ... user: drh tags: trunk)
16:51
Fix the ".schema" command in the CLI so that it works on builds that omit virtual table support. (check-in: b4e3c8170a ... user: drh tags: trunk)
11:13
Harmless typo fixes in shell.c (check-in: 519877cdbd ... user: drh tags: trunk)
2025-12-22
17:06
API documentation enhancements. (check-in: 99ac94cb9a ... user: drh tags: trunk)
15:22
Add the SQLITE_PREPARE_FROM_DDL flag to sqlite3_prepare_v3(). Use this to prevent fts3/4 tables in non-trusted schemas from calling unsafe SQL functions. (check-in: 26f39ac806 ... user: dan tags: trunk)
12:33
Fix spurious error log reports caused by [d25c8a6222d4e3f2]. See forum post d2326687662. (check-in: 403dafc779 ... user: drh tags: trunk)
12:00
Fix a harmless signed integer overflow warning in the ieee754() extension function. (check-in: f43d3339c1 ... user: drh tags: trunk)
11:28
Remove unused thunk cases from os_win.c, so that it will (hopefully) compile again on WinXP. (check-in: eb2c020481 ... user: drh tags: trunk)
2025-12-19
23:47
Fix a memory leak in the fileio extension on windows. Other changes to makefiles and similar to get zipfile testing working on Windows. (leaf check-in: 121b327f1f ... user: drh tags: branch-3.51)
13:17
Add experimental compile-time option SQLITE_ALLOW_TRIGGERS_ON_SYSTEM_TABLES. (check-in: f916bcc865 ... user: drh tags: trunk)
2025-12-18
20:44
Bug fix in the vt02.c test virtual table. (check-in: a7a73d30c5 ... user: drh tags: trunk)
18:47
Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical aprt from ASC/DESC sort-orders to be optimized using a single index. Also allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause. (check-in: fba29a8b56 ... user: dan tags: trunk)
16:14
New options for vt02.c that allow tests to configure it to partially de-duplicate a DISTINCT query. (check-in: 1c65bb6e5d ... user: drh tags: trunk)
16:05
Improve tests in bestindexF.test. No changes to non-test code. (check-in: 347d4d34c1 ... user: dan tags: trunk)
15:35
Better orderByConsumed logic in the vt02.c test virtual table. (check-in: 612c1ece67 ... user: drh tags: trunk)
14:01
Enhance the sqlite3_load_extension() so that when the entry point is not specified, after trying sqlite3_extension_init() and sqlite3_X_init() where X is the alphabetic part of the base filename, if neither or found it tries again with X as the alpha*numeric* part of the base filename. Hence, a shared library named "vt02.so" can be loaded with just ".load vt02" and without having to specify the entry point separately. (check-in: acc95f24cc ... user: drh tags: trunk)
12:49
Enhance the vt02.c test virtual table with the ability to process ORDER BY DESC. (check-in: 35461a8d5a ... user: drh tags: trunk)
2025-12-17
21:00
Fix the return value of sqlite3_vtab_distinct() in cases where a virtual table query has similar GROUP BY and ORDER BY expression lists. (check-in: d017ae8640 ... user: dan tags: trunk)
13:10
Fix a FILE* leak in the CLI (check-in: 7986a35d27 ... user: drh tags: trunk)
2025-12-16
13:43
CLI: The .imposter command matches the index name regardless of case. Minor fixes to .check. (check-in: 989ebba9ad ... user: drh tags: trunk)
13:25
CLI improvements. In the .check command, ignore leading and trailing whitespace unless the --exact option is used. In the .limit command, do not print the new limit when changing the limit, but only when requesting the current value of the limit. (check-in: d72cb66d67 ... user: drh tags: trunk)
13:13
Stricter enforcement of the LIKE_PATTERN_LENGTH for the regexp extension. (check-in: c94b1e9c56 ... user: drh tags: trunk)
2025-12-15
18:45
Fix for optimizing "SELECT DISTINCT ...cols... FROM vtab" in cases where the virtual table implementation is able to deliver results sorted by "...cols...". (check-in: 80c0d92293 ... user: dan tags: trunk)
17:32
Enhance the vtablog extension so that it shows the value of sqlite3_vtab_distinct() in xBestIndex, and so that provides the new consume_order_by option that can cause xBestIndex to set the orderByConsumed flag. (check-in: b158fe9299 ... user: drh tags: trunk)
14:56
Enhance the unixIsSharingShmNode() code (check-in [6385a1962c69c69c]) to avoid possible deadlocks with threads in findResuableFd(). (check-in: f65aa46796 ... user: dan tags: branch-3.51)
13:58
Clarify the affect of nCharLimit, nLineLimit, and nTitleLimit on the xRender output from QRF. (check-in: 881534858d ... user: drh tags: trunk)
13:26
Fix the test/vt100-a.sql script to use .testcase and .check. (check-in: 5cf9e99ff8 ... user: drh tags: trunk)
11:59
Enable an ORDER BY clause to refer to columns in outer queries. (check-in: ef9b4b1e46 ... user: drh tags: trunk)
2025-12-13
23:18
Use the correct wildcard character in sqlite3_strlike() in the previous check-in. (check-in: 87bca1250c ... user: drh tags: trunk)
21:11
In the CLI, if a command-line argument names a file and the filename ends with .sql or .txt, then process that file as an SQL script. Use this feature for better testing. (check-in: 19cc0522e2 ... user: drh tags: trunk)
00:13
Back out the --compat option from the CLI. (check-in: 850d5dbfb0 ... user: drh tags: trunk)
2025-12-12
18:22
Get the .testcase and .check commands working in the CLI. (check-in: 1ca31e1a29 ... user: drh tags: trunk)
12:06
Add new assert() statements designed to detect and prevent the kind of system interface numbering errors that happened in [108691a3cb2f296f] and that were not fixed until [fe49703034bd23fa]. (check-in: 4e6e551c89 ... user: drh tags: trunk)
11:50
Omit unused entries in the aSysCall array for the Windows driver. Fix incorrect numbering in alter entries of that array. (check-in: fe49703034 ... user: drh tags: trunk)
11:02
Remove from os_win.c a reference to unused system call CreateEventExW() left over from the now removed winrt support. (check-in: c68ef69ec9 ... user: dan tags: trunk)
10:21
Fix an inaccuracy in the qrfRelaxable() routine in QRF when the input is an empty string. (check-in: eb8a519571 ... user: drh tags: trunk)
00:21
Include the latest Makefile.msc changes and the new "make.bat" script in the amalgamation tarballs. (check-in: 6deab75874 ... user: drh tags: trunk)
2025-12-11
23:24
Prevent a malicious delta from causing an integer overflow in the fossildelta extension. This code is not used in the SQLite core. (check-in: 01409738af ... user: drh tags: trunk)
18:16
Update build instructions for Windows to explain how to link against ZLIB. (check-in: e785a80e41 ... user: drh tags: trunk)
17:49
Adjust the MSVC Makefile so that when it invokes the zlib makefile, it changes CFLAGS to use the correct -M compiler option to match SQLite. (check-in: ba003c7c74 ... user: drh tags: trunk)
11:05
Fix calls to sqlite3_wal_checkpoint_v2(SQLITE_CHECKPOINT_NOOP) so that they do not return SQLITE_MISUSE. (check-in: 117f4093f0 ... user: dan tags: trunk)
2025-12-10
19:43
Use macros for the default values for QRF limits in the CLI, rather than hard-coded magic numbers. (check-in: 4ef66da15b ... user: drh tags: trunk)
19:04
Various improvements to the .mode command of the CLI, and especially to how it handles the --limits option. (check-in: f883b85497 ... user: drh tags: trunk)
16:20
In fiddle, remove the default .dot-commands it runs, as they do not reflect current shell defaults. (check-in: 27b6aeda5d ... user: stephan tags: trunk)
16:10
Add the --titlelimit option to CLI, defaulting to 20. In "line" mode of the CLI, the default seperator is changed from " = " to ": ". This can be overridden using the --colsep option. (check-in: 291677ebb3 ... user: drh tags: trunk)
15:55
Do not show the --titlelimit setting in ".mode" setting output unless -v is used or unless the current style is tabular or line. (closed check-in: a9b0a3ce04 ... user: drh tags: title-limit)

Follow Lee on X/Twitter - Father, Husband, Serial builder creating AI, crypto, games & web tools. We are friends :) AI Will Come To Life!

Check out: eBank.nz (Art Generator) | Netwrck.com (AI Tools) | Text-Generator.io (AI API) | BitBank.nz (Crypto AI) | ReadingTime (Kids Reading) | RewordGame | BigMultiplayerChess | WebFiddle | How.nz | Helix AI Assistant