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