Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2021-06-25 23:21:31
Message id: 20210625212131.9BEB0FA95@cvs.NetBSD.org

Log Message:
sqlite3: updated to 3.36.0

SQLite Release 3.36.0 On 2021-06-18

Improvement to the EXPLAIN QUERY PLAN output to make it easier to understand.
Byte-order marks at the start of a token are skipped as if they were whitespace.
An error is raised on any attempt to access the rowid of a VIEW or subquery. \ 
Formerly, the rowid of a VIEW would be indeterminate and often would be NULL. \ 
The -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option is available to restore the \ 
legacy behavior for applications that need it.
The sqlite3_deserialize() and sqlite3_serialize() interfaces are now enabled by \ 
default. The -DSQLITE_ENABLE_DESERIALIZE compile-time option is no longer \ 
required. Instead, there is is a new -DSQLITE_OMIT_DESERIALIZE compile-time \ 
option to omit those interfaces.
The "memdb" VFS now allows the same in-memory database to be shared \ 
among multiple database connections in the same process as long as the database \ 
name begins with "/".
Back out the EXISTS-to-IN optimization (item 8b in the SQLite 3.35.0 change log) \ 
as it was found to slow down queries more often than speed them up.
Improve the constant-propagation optimization so that it works on non-join queries.
The REGEXP extension is now included in CLI builds.

Files:
RevisionActionfile
1.141modifypkgsrc/databases/sqlite3/Makefile
1.81modifypkgsrc/databases/sqlite3/Makefile.common
1.171modifypkgsrc/databases/sqlite3/distinfo
1.104modifypkgsrc/databases/sqlite3-docs/PLIST
1.105modifypkgsrc/databases/sqlite3-docs/distinfo
1.107modifypkgsrc/databases/sqlite3-tcl/Makefile
1.117modifypkgsrc/databases/sqlite3-tcl/distinfo
1.46modifypkgsrc/devel/lemon/distinfo