Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2016-08-09 16:54:26
Message id: 20160809145426.2EF69FBC3@cvs.NetBSD.org

Log Message:
Changes 3.14.0:
Added support for WITHOUT ROWID virtual tables.
Improved the query planner so that the OR optimization can be used on virtual \ 
tables even if one or more of the disjuncts use the LIKE, GLOB, REGEXP, MATCH \ 
operators.
Added the CSV virtual table for reading RFC 4180 formatted comma-separated value \ 
files.
Added the carray() table-valued function extension.
Enabled persistent loadable extensions using the new SQLITE_OK_LOAD_PERMANENTLY \ 
return code from the extension entry point.
Added the SQLITE_DBSTATUS_CACHE_USED_SHARED option to sqlite3_db_status().
Add the vfsstat.c loadable extension - a VFS shim that measures I/O together \ 
with an eponymous virtual table that provides access to the measurements.
Improved algorithm for running queries with both an ORDER BY and a LIMIT where \ 
only the inner-most loop naturally generates rows in the correct order.
Enhancements to Lemon parser generator, so that it generates a faster parser.
The PRAGMA compile_options command now attempts to show the version number of \ 
the compiler that generated the library.
Enhance PRAGMA table_info so that it provides information about eponymous \ 
virtual tables.
Added the "win32-none" VFS, analogous to the "unix-none" \ 
VFS, that works like the default "win32" VFS except that it ignores \ 
all file locks.
The query planner uses a full scan of a partial index instead of a full scan of \ 
the main table, in cases where that makes sense.
Allow table-valued functions to appear on the right-hand side of an IN operator.
Created the dbhash.exe command-line utility.
Added two new C-language interfaces: sqlite3_expanded_sql() and \ 
sqlite3_trace_v2(). These new interfaces subsume the functions of \ 
sqlite3_trace() and sqlite3_profile() which are now deprecated.
Added the json_quote() SQL function to the json1 extension.
Disable the authorizer callback while reparsing the schema.
Added the SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option and turned that \ 
option on by default when building the command-line shell.

Bug Fixes:
Fix the ALTER TABLE command so that it does not corrupt descending indexes when \ 
adding a column to a legacy file format database.
Fix a NULL-pointer dereference/crash that could occurs when a transitive WHERE \ 
clause references a non-existent collating sequence.
Improved the cost estimation for an index scan which includes a WHERE clause \ 
that can be partially or fully evaluated using columns in the index and without \ 
having to do a table lookup. This fixes a performance regression that occurred \ 
for some obscure queries following the ORDER BY LIMIT optimization introduced in \ 
version 3.12.0.

Files:
RevisionActionfile
1.19modifypkgsrc/databases/sqlite3/Makefile.version
1.123modifypkgsrc/databases/sqlite3/distinfo
1.57modifypkgsrc/databases/sqlite3-docs/PLIST
1.58modifypkgsrc/databases/sqlite3-docs/distinfo
1.71modifypkgsrc/databases/sqlite3-tcl/distinfo