CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Aug  9 14:54:26 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.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.


To generate a diff of this commit:
cvs rdiff -u -r1.18 -r1.19 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.122 -r1.123 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.56 -r1.57 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.57 -r1.58 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.70 -r1.71 pkgsrc/databases/sqlite3-tcl/distinfo

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

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile.version
diff -u pkgsrc/databases/sqlite3/Makefile.version:1.18 pkgsrc/databases/sqlite3/Makefile.version:1.19
--- pkgsrc/databases/sqlite3/Makefile.version:1.18      Sat May 21 11:19:30 2016
+++ pkgsrc/databases/sqlite3/Makefile.version   Tue Aug  9 14:54:25 2016
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile.version,v 1.18 2016/05/21 11:19:30 adam Exp $
+# $NetBSD: Makefile.version,v 1.19 2016/08/09 14:54:25 adam Exp $
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 
-SQLITE3_DISTVERSION=   3130000
-SQLITE3_VERSION=       3.13.0
+SQLITE3_DISTVERSION=   3140000
+SQLITE3_VERSION=       3.14.0
 
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2016/ \
                http://www.sqlite.org/2016/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.122 pkgsrc/databases/sqlite3/distinfo:1.123
--- pkgsrc/databases/sqlite3/distinfo:1.122     Sat May 21 11:19:30 2016
+++ pkgsrc/databases/sqlite3/distinfo   Tue Aug  9 14:54:25 2016
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.122 2016/05/21 11:19:30 adam Exp $
+$NetBSD: distinfo,v 1.123 2016/08/09 14:54:25 adam Exp $
 
-SHA1 (sqlite-autoconf-3130000.tar.gz) = f6f76e310389e3f510b23826f805850449ae8653
-RMD160 (sqlite-autoconf-3130000.tar.gz) = adb779281ca29c0985aec09d8cda0bbc4bc78e43
-SHA512 (sqlite-autoconf-3130000.tar.gz) = c2547ff9a144c46829344058b4f8dcc5b8c9c823cbc667be2944dc7beecb9cc213858cc9ce302a763200278397d9a0fc6bb35c542028a124ef0980fedd574c2f
-Size (sqlite-autoconf-3130000.tar.gz) = 2459805 bytes
+SHA1 (sqlite-autoconf-3140000.tar.gz) = f0ed10b416c467062c76b899f08c773c713fb8fd
+RMD160 (sqlite-autoconf-3140000.tar.gz) = 825a3ee70973dd2142bf9c90ba3426f4980c3f4a
+SHA512 (sqlite-autoconf-3140000.tar.gz) = 310cf898818d4061c9bfea33ae1a79ec1e7dbf541a5258d0ff90a8061332dcfc086f3718ebe7a9eaaf5a2ad93f5c6920faf38dd752ab5bcc88ed2c1c74f4be9e
+Size (sqlite-autoconf-3140000.tar.gz) = 2473333 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.56 pkgsrc/databases/sqlite3-docs/PLIST:1.57
--- pkgsrc/databases/sqlite3-docs/PLIST:1.56    Sat May 21 11:19:30 2016
+++ pkgsrc/databases/sqlite3-docs/PLIST Tue Aug  9 14:54:25 2016
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.56 2016/05/21 11:19:30 adam Exp $
+@comment $NetBSD: PLIST,v 1.57 2016/08/09 14:54:25 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -12,9 +12,9 @@ share/doc/sqlite3/atomiccommit.html
 share/doc/sqlite3/autoinc.html
 share/doc/sqlite3/backup.html
 share/doc/sqlite3/books.html
-share/doc/sqlite3/btreemodule.html
 share/doc/sqlite3/c3ref/aggregate_context.html
 share/doc/sqlite3/c3ref/aggregate_count.html
+share/doc/sqlite3/c3ref/api_routines.html
 share/doc/sqlite3/c3ref/auto_extension.html
 share/doc/sqlite3/c3ref/backup.html
 share/doc/sqlite3/c3ref/backup_finish.html
@@ -61,6 +61,7 @@ share/doc/sqlite3/c3ref/c_status_malloc_
 share/doc/sqlite3/c3ref/c_stmtstatus_counter.html
 share/doc/sqlite3/c3ref/c_sync_dataonly.html
 share/doc/sqlite3/c3ref/c_testctrl_always.html
+share/doc/sqlite3/c3ref/c_trace.html
 share/doc/sqlite3/c3ref/c_vtab_constraint_support.html
 share/doc/sqlite3/c3ref/cancel_auto_extension.html
 share/doc/sqlite3/c3ref/changes.html
@@ -97,6 +98,7 @@ share/doc/sqlite3/c3ref/enable_load_exte
 share/doc/sqlite3/c3ref/enable_shared_cache.html
 share/doc/sqlite3/c3ref/errcode.html
 share/doc/sqlite3/c3ref/exec.html
+share/doc/sqlite3/c3ref/expanded_sql.html
 share/doc/sqlite3/c3ref/experimental.html
 share/doc/sqlite3/c3ref/extended_result_codes.html
 share/doc/sqlite3/c3ref/file.html
@@ -152,7 +154,6 @@ share/doc/sqlite3/c3ref/snapshot_get.htm
 share/doc/sqlite3/c3ref/snapshot_open.html
 share/doc/sqlite3/c3ref/soft_heap_limit.html
 share/doc/sqlite3/c3ref/soft_heap_limit64.html
-share/doc/sqlite3/c3ref/sql.html
 share/doc/sqlite3/c3ref/sqlite3.html
 share/doc/sqlite3/c3ref/status.html
 share/doc/sqlite3/c3ref/step.html
@@ -171,6 +172,7 @@ share/doc/sqlite3/c3ref/temp_directory.h
 share/doc/sqlite3/c3ref/test_control.html
 share/doc/sqlite3/c3ref/threadsafe.html
 share/doc/sqlite3/c3ref/total_changes.html
+share/doc/sqlite3/c3ref/trace_v2.html
 share/doc/sqlite3/c3ref/unlock_notify.html
 share/doc/sqlite3/c3ref/update_hook.html
 share/doc/sqlite3/c3ref/uri_boolean.html
@@ -192,6 +194,7 @@ share/doc/sqlite3/c3ref/wal_hook.html
 share/doc/sqlite3/c_interface.html
 share/doc/sqlite3/capi3.html
 share/doc/sqlite3/capi3ref.html
+share/doc/sqlite3/carray.html
 share/doc/sqlite3/changes.html
 share/doc/sqlite3/chronology.html
 share/doc/sqlite3/cintro.html
@@ -204,10 +207,12 @@ share/doc/sqlite3/copyright-release.html
 share/doc/sqlite3/copyright-release.pdf
 share/doc/sqlite3/copyright.html
 share/doc/sqlite3/crew.html
+share/doc/sqlite3/csv.html
 share/doc/sqlite3/custombuild.html
 share/doc/sqlite3/cvstrac.css
 share/doc/sqlite3/datatype3.html
 share/doc/sqlite3/datatypes.html
+share/doc/sqlite3/dbhash.html
 share/doc/sqlite3/dbstat.html
 share/doc/sqlite3/dev.html
 share/doc/sqlite3/different.html
@@ -269,6 +274,7 @@ share/doc/sqlite3/images/arch.gif
 share/doc/sqlite3/images/arch.png
 share/doc/sqlite3/images/arch2.gif
 share/doc/sqlite3/images/books/aditya.jpg
+share/doc/sqlite3/images/books/darocha2016.jpg
 share/doc/sqlite3/images/books/das.jpg
 share/doc/sqlite3/images/books/droessler.jpg
 share/doc/sqlite3/images/books/haldar.gif
@@ -403,6 +409,7 @@ share/doc/sqlite3/images/shane1.jpg
 share/doc/sqlite3/images/shared.gif
 share/doc/sqlite3/images/sqlite370.jpg
 share/doc/sqlite3/images/sqlite370_banner.gif
+share/doc/sqlite3/images/sqlitepie.jpg
 share/doc/sqlite3/images/src_logo.gif
 share/doc/sqlite3/images/sw.gif
 share/doc/sqlite3/images/sw.png
@@ -550,6 +557,7 @@ share/doc/sqlite3/releaselog/3_12_0.html
 share/doc/sqlite3/releaselog/3_12_1.html
 share/doc/sqlite3/releaselog/3_12_2.html
 share/doc/sqlite3/releaselog/3_13_0.html
+share/doc/sqlite3/releaselog/3_14.html
 share/doc/sqlite3/releaselog/3_1_0.html
 share/doc/sqlite3/releaselog/3_1_1.html
 share/doc/sqlite3/releaselog/3_1_2.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.57 pkgsrc/databases/sqlite3-docs/distinfo:1.58
--- pkgsrc/databases/sqlite3-docs/distinfo:1.57 Sat May 21 11:19:30 2016
+++ pkgsrc/databases/sqlite3-docs/distinfo      Tue Aug  9 14:54:25 2016
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.57 2016/05/21 11:19:30 adam Exp $
+$NetBSD: distinfo,v 1.58 2016/08/09 14:54:25 adam Exp $
 
-SHA1 (sqlite-doc-3130000.zip) = 1f10c30709c67bdb62d0d86f2b36c0148f64ed21
-RMD160 (sqlite-doc-3130000.zip) = 812b71bc79702d983335f49a293e6b8daa68cc48
-SHA512 (sqlite-doc-3130000.zip) = 0bf4544a07bd92533bc248dc16ed43c4fcad870ab535591618d3006f38c2741a8c0ed1da082444ea1af2f57936575c678bc12b651252426b908660023b36cd39
-Size (sqlite-doc-3130000.zip) = 5550186 bytes
+SHA1 (sqlite-doc-3140000.zip) = a58fe1b26f55cda14271fe0356b5cbdb11e58751
+RMD160 (sqlite-doc-3140000.zip) = 4ce9a6b99ddfd926cb5cffffc4941b7f741d8093
+SHA512 (sqlite-doc-3140000.zip) = 66dc32b8837df0939b394d6abec229cf262be4424ed2d58e347bcd81b8c1d6e389085a7d8eff552cc8725aeab72643c505428c06d6c3e6c2382f4262e67a74a9
+Size (sqlite-doc-3140000.zip) = 5683055 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.70 pkgsrc/databases/sqlite3-tcl/distinfo:1.71
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.70  Sat May 21 11:19:30 2016
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Tue Aug  9 14:54:26 2016
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.70 2016/05/21 11:19:30 adam Exp $
+$NetBSD: distinfo,v 1.71 2016/08/09 14:54:26 adam Exp $
 
-SHA1 (sqlite-autoconf-3130000.tar.gz) = f6f76e310389e3f510b23826f805850449ae8653
-RMD160 (sqlite-autoconf-3130000.tar.gz) = adb779281ca29c0985aec09d8cda0bbc4bc78e43
-SHA512 (sqlite-autoconf-3130000.tar.gz) = c2547ff9a144c46829344058b4f8dcc5b8c9c823cbc667be2944dc7beecb9cc213858cc9ce302a763200278397d9a0fc6bb35c542028a124ef0980fedd574c2f
-Size (sqlite-autoconf-3130000.tar.gz) = 2459805 bytes
+SHA1 (sqlite-autoconf-3140000.tar.gz) = f0ed10b416c467062c76b899f08c773c713fb8fd
+RMD160 (sqlite-autoconf-3140000.tar.gz) = 825a3ee70973dd2142bf9c90ba3426f4980c3f4a
+SHA512 (sqlite-autoconf-3140000.tar.gz) = 310cf898818d4061c9bfea33ae1a79ec1e7dbf541a5258d0ff90a8061332dcfc086f3718ebe7a9eaaf5a2ad93f5c6920faf38dd752ab5bcc88ed2c1c74f4be9e
+Size (sqlite-autoconf-3140000.tar.gz) = 2473333 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d