CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Feb 16 13:46:04 UTC 2016

Modified Files:
        pkgsrc/databases/sqlite3: Makefile.version distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: distinfo

Log Message:
Changes 3.11.0:

General improvements:

Enhanced WAL mode so that it works efficiently with transactions that are larger than the cache_size.
Added the FTS5 detail option.
Added the "EXTRA" option to PRAGMA synchronous that does a sync of the containing directory when a rollback journal is unlinked in DELETE mode, for better durability. The SQLITE_EXTRA_DURABLE 
compile-time option enables PRAGMA synchronous=EXTRA by default.
Enhanced the query planner so that it is able to use a covering index as part of the OR optimization.
Avoid recomputing NOT NULL and CHECK constraints on unchanged columns in UPDATE statement.
Many micro-optimizations, resulting in a library that is faster than the previous release.
Enhancements to the command-line shell:

By default, the shell is now in "auto-explain" mode. The output of EXPLAIN commands is automatically formatted.
Added the ".vfslist" dot-command.
The SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option is now turned on by default in the standard builds.

Enhancements to the TCL Interface:

If a database connection is opened with the "-uri 1" option, then URI filenames are honored by the "backup" and "restore" commands.
Added the "-sourceid" option to the "sqlite3" command.
Makefile improvements:

Improved pthreads detection in configure scripts.
Add the ability to do MSVC Windows builds from the amalgamation tarball.

Bug fixes

Fix an issue with incorrect sharing of VDBE temporary registers between co-routines that could cause incorrect query results in obscure cases. Ticket d06a25c84454a.
Fix a problem in the sqlite3_result_subtype() interface that could cause problems for the json1 extension under obscure circumstances. Fix for ticket f45ac567eaa9f9.
Escape control characters in JSON strings. Fix for ticket ad2559db380abf8.
Reenable the xCurrentTime and xGetLastError methods in the built-in unix VFSes as long as SQLITE_OMIT_DEPRECATED is not defined.

Backwards Compatibility:
Because of continuing security concerns, the two-argument version of of the seldom-used and little-known fts3_tokenizer() function is disabled unless SQLite is compiled with the 
SQLITE_ENABLE_FTS3_TOKENIZER.


To generate a diff of this commit:
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.115 -r1.116 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.50 -r1.51 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.51 -r1.52 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.64 -r1.65 pkgsrc/databases/sqlite3-tcl/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.