https://sqlite.org/releaselog/3_39_0.html

SQLite
Small. Fast. Reliable.
Choose any three.

  * Home
  * Menu
  * About
  * Documentation
  * Download
  * License
  * Support
  * Purchase
  * Search

  * About
  * Documentation
  * Download
  * Support
  * Purchase

[Search Documentation] [                    ] [Go]
SQLite Release 3.39.0 On 2022-06-25

 1. Add (long overdue) support for RIGHT and FULL OUTER JOIN.
 2. 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.
 3. 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.
 4. Added the sqlite3_db_name() interface.
 5. The unix os interface resolves all symbolic links in database
    filenames to create a canonical name for the database before the
    file is opened.
 6. Defer materializing views until the materialization is actually
    needed, thus avoiding unnecessary work if the materialization
    turns out to never be used.
 7. The HAVING clause of a SELECT statement is now allowed on any
    aggregate query, even queries that do not have a GROUP BY clause.
 8. Many microoptimizations collectively reduce CPU cycles by about
    2.3%.

    Hashes:
 9. SQLITE_SOURCE_ID: 2022-06-25 14:57:57
    14e166f40dbfa6e055543f8301525f2ca2e96a02a57269818b9e69e162e98918
10. SHA3-256 for sqlite3.c:
    d9c439cacad5e4992d0d25989cfd27a4c4f59a3183c97873bc03f0ad1aa78b7a

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.