HomeFreeBSD

databases/sqlite3: Update to 3.39

Description

databases/sqlite3: Update to 3.39

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

  • 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.
  • The HAVING clause of a SELECT statement is now allowed on any aggregate query, even queries that do not have a GROUP BY clause.
  • Many microoptimizations collectively reduce CPU cycles by about 2.3%.

PR: 264974
Reported by: pavelivolkov@gmail.com (maintainer)

(cherry picked from commit 5bf2947fce86388fd612492f980540c07d41f0b2)

Details

Provenance
Pavel Volkov <pavelivolkov@gmail.com>Authored on Jul 5 2022, 5:52 AM
cyCommitted on Aug 30 2022, 11:15 PM
Parents
R11:45181a348dd3: www/trafficserver: Update to 9.1.3
Branches
Unknown
Tags
Unknown

Event Timeline