Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2017-02-13 18:44:01
Message id: 20170213174402.0CB9BFBE3@cvs.NetBSD.org

Log Message:
SQLite Release 3.17.0 On 2017-02-13
* Approximately 25% better performance from the R-Tree extension.
* Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for \ 
byteswapping when available.
* Uses the sqlite3_blob key/value access object instead of SQL for pulling \ 
content out of R-Tree nodes
* Other miscellaneous enhancements such as loop unrolling.
* Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
* Increase the default lookaside size from 512,125 to 1200,100 as this provides \ 
better performance while only adding 56KB of extra memory per connection. \ 
Memory-sensitive applications can restore the old default at compile-time, \ 
start-time, or run-time.
* Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(), and \ 
__builtin_mul_overflow() when available. (All compiler built-ins can be omitted \ 
with the SQLITE_DISABLE_INTRINSIC compile-time option.)
* Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which can result in \ 
significantly smaller database files for some applications, at the risk of being \ 
incompatible with older versions of SQLite.
* Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for improved performance.
* Added the SQLITE_UINT64_TYPE compile-time option as an analog to SQLITE_INT64_TYPE.
* Perform some UPDATE operations in a single pass instead of in two passes.
* Enhance the session extension to support WITHOUT ROWID tables.
* Fixed performance problems and potential stack overflows when creating views \ 
from multi-row VALUES clauses with hundreds of thousands of rows.
* Added the sha1.c extension.
* In the command-line shell, enhance the ".mode" command so that it \ 
restores the default column and row separators for modes "line", \ 
"list", "column", and "tcl".
* Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it works in WAL mode as \ 
long as the pages being read are not in the WAL file.
* Enhance the LEMON parser generator so that it can store the parser object as a \ 
stack variable rather than allocating space from the heap and make use of that \ 
enhancement in the amalgamation.
* Other performance improvements. Uses about 6.5% fewer CPU cycles.

Bug Fixes:
* Throw an error if the ON clause of a LEFT JOIN references tables to the right \ 
of the ON clause. This is the same behavior as PostgreSQL. Formerly, SQLite \ 
silently converted the LEFT JOIN into an INNER JOIN.
* Use the correct affinity for columns of automatic indexes.
* Ensure that the sqlite3_blob_reopen() interface can correctly handle short rows.

Files:
RevisionActionfile
1.114modifypkgsrc/databases/sqlite3/Makefile
1.51modifypkgsrc/databases/sqlite3/Makefile.common
1.30modifypkgsrc/databases/sqlite3/Makefile.version
1.132modifypkgsrc/databases/sqlite3/distinfo
1.66modifypkgsrc/databases/sqlite3-docs/PLIST
1.67modifypkgsrc/databases/sqlite3-docs/distinfo
1.80modifypkgsrc/databases/sqlite3-tcl/distinfo
1.8modifypkgsrc/devel/lemon/distinfo