- 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.
- Generalize the LEFT JOIN strength reduction optimization so that it works
- 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_pow2(N) returns the N-th power of 2 for integer N
