Path to this page:
Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2022-07-01 19:49:39
Message id: 20220701174939.B579CFB1A@cvs.NetBSD.org
Log Message:
sqlite3: updated to 3.39.0
SQLite Release 3.39.0 On 2022-06-25
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%.
Files: