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)

Details

Provenance
Pavel Volkov <pavelivolkov@gmail.com>Authored on Jul 5 2022, 5:52 AM
fernapeCommitted on Jul 7 2022, 5:32 AM
Parents
R11:10384bcd7558: graphics/xournalpp: Remove unnecessary latex run-time dependency
Branches
Unknown
Tags
Unknown