*** DRAFT ***
SQLite Release 3.47.0 On 2024-10-15
- Allow arbitrary expressions in the second argument to the RAISE function.
- If the RHS if the ->> operator is negative, then access array elements counting from the right.
- Fix a problem with rolling back hot journal files in the seldom-used
unix-dotfile VFS.
- FTS5 tables can now be dropped even if they use a non-standard tokenizer that
has not been registered.
- Fix the group_concat() aggregate function so that it returns an empty string,
not a NULL, if receives a single input value which is an empty string.
- Performance optimizations:
- Improved reuse of subqueries associated with the IN operator, especially when
the IN operator has been duplicated due to predicate push-down.
- Use a Bloom filter on subqueries on the right-hand side of the
IN operator, in cases where that seems likely to improve performance.
- Ensure that queries like "SELECT func(a) FROM tab GROUP BY 1" only
invoke the func() function once per row.
- Do not attempt is made to create automatic indexes on a column that is known
to be non-selective because if its use in other indexes that have been analyzed.
- Adjustments to the query planner so that it produces better plans for
star queries with a large number of dimension tables.
- Miscellaneous coding tweaks for faster runtimes.
- Enhancements to SQLite-related command-line programs:
- The sqlite3_analyzer utility now provides a break-out of statistics
for WITHOUT ROWID tables.
- The sqldiff utility avoids creating an empty database if its second argument
does not exist.
Hashes:
- SQLITE_SOURCE_ID: pending
- SHA3-256 for sqlite3.c: pending
A complete list of SQLite releases
in a single page and a chronology are both also available.
A detailed history of every
check-in is available at
SQLite version control site.
*** DRAFT ***