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:
RevisionActionfile
1.91modifypkgsrc/databases/sqlite3/Makefile.common
1.184modifypkgsrc/databases/sqlite3/distinfo
1.114modifypkgsrc/databases/sqlite3-docs/PLIST
1.117modifypkgsrc/databases/sqlite3-docs/distinfo
1.112modifypkgsrc/databases/sqlite3-tcl/Makefile
1.129modifypkgsrc/databases/sqlite3-tcl/distinfo
1.58modifypkgsrc/devel/lemon/distinfo