*** DRAFT ***
SQLite Release 3.39.0 On 2022-07-99
- Add (long overdue) support for RIGHT and FULL OUTER JOIN.
- Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM
that are equivalent to IS and IS NOT, respective, for compatibility with
PostgreSQL and SQL standards.
- Add a new return code (value "3") from the sqlite3_vtab_distinct()
interface that indicates a query that has both DISTINCT and ORDER BY
clauses.
- Added the sqlite3_db_name() interface.
- The unix os interface resolves all symbolic links in database
filenames to create a canonical name for the database before the
file is opened.
- Defer materializing views until the materialization
is actually needed, thus avoiding unnecessary work if the materialization turns
out to never be used.
- Many microoptimizations collectively reduce CPU cycles by about 2.3%.
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 ***