Path to this page:
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: