Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2021-11-28 21:48:29
Message id: 20211128204829.6893FFAEC@cvs.NetBSD.org

Log Message:
sqlite3: updated to 3.37.0

SQLite Release 3.37.0 On 2021-11-27

STRICT tables provide a prescriptive style of data type management, for \ 
developers who prefer that kind of thing.
When adding columns that contain a CHECK constraint or a generated column \ 
containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new \ 
constraints against preexisting rows in the database and will only proceed if no \ 
constraints are violated.
Added the PRAGMA table_list statement.
CLI enhancements:
Add the .connection command, allowing the CLI to keep multiple database \ 
connections open at the same time.
Add the --safe command-line option that disables dot-commands and SQL statements \ 
that might cause side-effects that extend beyond the single database file named \ 
on the command-line.
Performance improvements when reading SQL statements that span many lines.
Added the sqlite3_autovacuum_pages() interface.
The sqlite3_deserialize() does not and has never worked for the TEMP database. \ 
That limitation is now noted in the documentation.
The query planner now omits ORDER BY clauses on subqueries and views if removing \ 
those clauses does not change the semantics of the query.
The generate_series table-valued function extension is modified so that the \ 
first parameter ("START") is now required. This is done as a way to \ 
demonstrate how to write table-valued functions with required parameters. The \ 
legacy behavior is available using the -DZERO_ARGUMENT_GENERATE_SERIES \ 
compile-time option.
Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces.
Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2().
Use less memory to hold the database schema.

Files:
RevisionActionfile
1.143modifypkgsrc/databases/sqlite3/Makefile
1.82modifypkgsrc/databases/sqlite3/Makefile.common
1.175modifypkgsrc/databases/sqlite3/distinfo
1.105modifypkgsrc/databases/sqlite3-docs/PLIST
1.108modifypkgsrc/databases/sqlite3-docs/distinfo
1.120modifypkgsrc/databases/sqlite3-tcl/distinfo
1.49modifypkgsrc/devel/lemon/distinfo
1.1removepkgsrc/databases/sqlite3/patches/patch-shell.c