| Version | Change log |
| SQLite3 3.46.0 May 24, 2024 | |
| SQLite3 3.45.2 Mar 12, 2024 | |
| SQLite3 3.45.0 Jan 16, 2024 | |
| SQLite3 3.44.2 Nov 24, 2023 |
Fix a mistake in the CLI that was introduced by the fix (item 15 above) in 3.44.1. Fix a problem in FTS5 that was discovered during internal fuzz testing only minutes after the 3.44.1 release was tagged. Fix incomplete assert() statements that the fuzzer discovered the day after the previous release. Fix a couple of harmless compiler warnings that appeared in debug builds with GCC 16. |
| SQLite3 3.44.1 Nov 22, 2023 |
Change the CLI so that it uses UTF-16 for console I/O on Windows. This enables proper display of unicode text on old Windows7 machines. Other obscure bug fixes. |
| SQLite3 3.44.0 Nov 1, 2023 |
Aggregate functions can now include an ORDER BY clause after their last parameter. The arguments to the function are processed in the order specified. This can be important for functions like string_agg() and json_group_array(). Add support for the concat() and concat_ws() scalar SQL functions, compatible with PostgreSQL, SQLServer, and MySQL. Add support for the string_agg() aggregate SQL function, compatible with PostgreSQL and SQLServer. New conversion letters on the strftime() SQL function: %e %F %I %k %l %p %P %R %T %u Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata(). Many errors associated with CREATE TABLE are now raised when the CREATE TABLE statement itself is run, rather than being deferred until the first time the table is actually used. The PRAGMA integrity_check command now verifies the consistency of the content in various built-in virtual tables using the new xIntegrity method. |
| SQLite3 3.43.2 Oct 10, 2023 |
Fix a couple of obscure UAF errors and an obscure memory leak. Omit the use of the sprintf() function from the standard library in the CLI, as this now generates warnings on some platforms. Avoid conversion of a double into unsigned long long integer, as some platforms do not do such conversions correctly. |
| SQLite3 3.43.1 Sep 11, 2023 |
Fix a regression in the way that the sum(), avg(), and total() aggregate functions handle infinities. Fix a bug in the json_array_length() function that occurs when the argument comes directly from json_remove(). Fix the omit-unused-subquery-columns optimization (introduced in in version 3.42.0) so that it works correctly if the subquery is a compound where one arm is DISTINCT and the other is not. Other minor fixes. |
| SQLite3 3.43.0 Aug 24, 2023 |
Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted. Enhancements to the date and time functions: Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS. Added the timediff() SQL function. Added the octet_length(X) SQL function. Added the sqlite3_stmt_explain() API. Query planner enhancements: Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction. Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives. Enhancements to the decimal extension: New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000. New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end. |
| SQLite3 3.42.0 May 16, 2023 |
Add the FTS5 secure-delete command. This option causes all forensic traces to be removed from the FTS5 inverted index when content is deleted. Enhance the JSON SQL functions to support JSON5 extensions. The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config() are now allowed to occur after sqlite3_initialize(). New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_DBCONFIG_REVERSE_SCANORDER. Query planner improvements: Enable the "count-of-view" optimization by default. Avoid computing unused columns in subqueries. Improvements to the push-down optimization. Enhancements to the CLI: Add the --unsafe-testing command-line option. Without this option, some dot-commands (ex: ".testctrl") are now disabled because those commands that are intended for testing only and can cause malfunctions misused. Allow commands ".log on" and ".log off", even in --safe mode. |
