CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sat Dec 15 18:42:33 UTC 2012

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

Log Message:
Changes 3.7.15:
* Added the sqlite3_errstr() interface.
* Avoid invoking the sqlite3_trace() callback multiple times when a statement 
is automatically reprepared due to SQLITE_SCHEMA errors.
* Added support for Windows Phone 8 platforms
* Enhance IN operator processing to make use of indices with numeric affinities.
* Do full-table scans using covering indices when possible, under the theory 
that an index will be smaller and hence can be scanned with less I/O.
* Enhance the query optimizer so that ORDER BY clauses are more aggressively 
optimized, especially in joins where various terms of the ORDER BY clause come 
from separate tables of the join.
* Add the ability to implement FROM clause subqueries as coroutines rather that 
manifesting the subquery into a temporary table.
* Enhancements the command-line shell:
* Added the ".print" command
* Negative numbers in the ".width" command cause right-alignment
* Add the ".wheretrace" command when compiled with SQLITE_DEBUG
* Added the busy_timeout pragma.
* Added the instr() SQL function.
* Added the SQLITE_FCNTL_BUSYHANDLER file control, used to allow VFS 
implementations to get access to the busy handler callback.
* The xDelete method in the built-in VFSes now return SQLITE_IOERR_DELETE_NOENT 
if the file to be deleted does not exist.
* Enhanced support for QNX.
* Work around an optimizer bug in the MSVC compiler when targeting ARM.
* Bug fix: Avoid various concurrency problems in shared cache mode.
* Bug fix: Avoid a deadlock or crash if the backup API, shared cache, and the 
SQLite Encryption Extension are all used at once.
* Bug fix: SQL functions created using the TCL interface honor the "nullvalue" 
setting.
* Bug fix: Fix a 32-bit overflow problem on CREATE INDEX for databases larger 
than 16GB.
* Bug fix: Avoid segfault when using the COLLATE operator inside of a CHECK 
constraint or view in shared cache mode.


To generate a diff of this commit:
cvs rdiff -u -r1.57 -r1.58 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.72 -r1.73 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/sqlite3-docs/Makefile
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/sqlite3-docs/PLIST \
    pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.39 -r1.40 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.25 -r1.26 pkgsrc/databases/sqlite3-tcl/distinfo

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