Sun Oct 19 20:37:48 2014 UTC ()
Changes 3.8.7:

Performance Enhancements:
* Many micro-optimizations result in 20.3% more work for the same number of CPU cycles relative to the previous release. The cumulative performance increase since version 3.8.0 is 61%. (Measured using cachegrind on the speedtest1.c workload on Ubuntu 13.10 x64 with gcc 4.8.1 and -Os. Your performance may vary.)
* The sorter can use auxiliary helper threads to increase real-time response. This feature is off by default and may be enabled using the PRAGMA threads command or the SQLITE_DEFAULT_WORKER_THREADS compile-time option.
* Enhance the skip-scan optimization so that it is able to skip index terms that occur in the middle of the index, not just as the left-hand side of the index.
* Improved optimization of CAST operators.
* Various improvements in how the query planner uses sqlite_stat4 information to estimate plan costs.

New Features:
* Added new interfaces with 64-bit length parameters: sqlite3_malloc64(), sqlite3_realloc64(), sqlite3_bind_blob64(), sqlite3_result_blob64(), sqlite3_bind_text64(), and sqlite3_result_text64().
* Added the new interface sqlite3_msize() that returns the size of a memory allocation obtained from sqlite3_malloc64() and its variants.
* Added the SQLITE_LIMIT_WORKER_THREADS option to sqlite3_limit() and PRAGMA threads command for configuring the number of available worker threads.
* The spellfix1 extension allows the application to optionally specify the rowid for each INSERT.
* Added the User Authentication extension.

Bug Fixes:
* Fix a bug in the partial index implementation that might result in an incorrect answer if a partial index is used in a subquery or in a view.
* Fix a query planner bug that might cause a table to be scanned in the wrong direction (thus reversing the order of output) when a DESC index is used to implement the ORDER BY clause on a query that has an identical GROUP BY clause.
* Fix a bug in sqlite3_trace() that was causing it to sometimes fail to print an SQL statement if that statement needed to be re-prepared.
* Fix a faulty assert() statement.


(adam)
diff -r1.83 -r1.84 pkgsrc/databases/sqlite3/Makefile
diff -r1.92 -r1.93 pkgsrc/databases/sqlite3/distinfo
diff -r1.32 -r1.33 pkgsrc/databases/sqlite3-docs/Makefile
diff -r1.30 -r1.31 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.30 -r1.31 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.63 -r1.64 pkgsrc/databases/sqlite3-tcl/Makefile
diff -r1.43 -r1.44 pkgsrc/databases/sqlite3-tcl/distinfo
cvs diff -r1.83 -r1.84 pkgsrc/databases/sqlite3/Makefile (expand / switch to context diff)
--- pkgsrc/databases/sqlite3/Makefile 2014/10/07 16:47:10 1.83
+++ pkgsrc/databases/sqlite3/Makefile 2014/10/19 20:37:47 1.84
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.83 2014/10/07 16:47:10 adam Exp $
+# $NetBSD: Makefile,v 1.84 2014/10/19 20:37:47 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3080600
-PKGNAME=	sqlite3-3.8.6
-PKGREVISION=	1
+DISTNAME=	sqlite-autoconf-3080700
+PKGNAME=	sqlite3-3.8.7
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2014/ \
 		http://www.sqlite.org/2014/
cvs diff -r1.92 -r1.93 pkgsrc/databases/sqlite3/distinfo (expand / switch to context diff)
--- pkgsrc/databases/sqlite3/distinfo 2014/08/17 08:16:06 1.92
+++ pkgsrc/databases/sqlite3/distinfo 2014/10/19 20:37:47 1.93
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.92 2014/08/17 08:16:06 adam Exp $
+$NetBSD: distinfo,v 1.93 2014/10/19 20:37:47 adam Exp $
 
-SHA1 (sqlite-autoconf-3080600.tar.gz) = c4b2911bc4a6e1dc2b411aa21d8c4f524113eb64
+SHA1 (sqlite-autoconf-3080700.tar.gz) = 8b773b006db46f3ffcbabe065e927823d13bf5c0
-RMD160 (sqlite-autoconf-3080600.tar.gz) = 31a5c239174e4cf74fd0e9cf4324fa0e6282aaab
+RMD160 (sqlite-autoconf-3080700.tar.gz) = 6a08748fffa7e5e504e250a9dba69c15fefa98da
-Size (sqlite-autoconf-3080600.tar.gz) = 1968379 bytes
+Size (sqlite-autoconf-3080700.tar.gz) = 1998217 bytes
cvs diff -r1.32 -r1.33 pkgsrc/databases/sqlite3-docs/Makefile (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-docs/Makefile 2014/08/17 08:16:06 1.32
+++ pkgsrc/databases/sqlite3-docs/Makefile 2014/10/19 20:37:47 1.33
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.32 2014/08/17 08:16:06 adam Exp $
+# $NetBSD: Makefile,v 1.33 2014/10/19 20:37:47 adam Exp $
 
-DISTNAME=	sqlite-doc-3080600
-PKGNAME=	sqlite3-docs-3.8.6
+DISTNAME=	sqlite-doc-3080700
+PKGNAME=	sqlite3-docs-3.8.7
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2014/ \
 		http://www.sqlite.org/2014/
cvs diff -r1.30 -r1.31 pkgsrc/databases/sqlite3-docs/PLIST (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-docs/PLIST 2014/08/17 08:16:06 1.30
+++ pkgsrc/databases/sqlite3-docs/PLIST 2014/10/19 20:37:47 1.31
@@ -1,7 +1,8 @@
-@comment $NetBSD: PLIST,v 1.30 2014/08/17 08:16:06 adam Exp $
+@comment $NetBSD: PLIST,v 1.31 2014/10/19 20:37:47 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
+share/doc/sqlite3/affcase1.html
 share/doc/sqlite3/amalgamation.html
 share/doc/sqlite3/appfileformat.html
 share/doc/sqlite3/arch.html
@@ -245,6 +246,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/das.jpg
 share/doc/sqlite3/images/books/droessler.jpg
 share/doc/sqlite3/images/books/haldar.gif
@@ -480,6 +482,7 @@
 share/doc/sqlite3/mmap.html
 share/doc/sqlite3/mostdeployed.html
 share/doc/sqlite3/news.html
+share/doc/sqlite3/not-found.html
 share/doc/sqlite3/nulls.html
 share/doc/sqlite3/oldnews.html
 share/doc/sqlite3/omitted.html
@@ -622,6 +625,7 @@
 share/doc/sqlite3/releaselog/3_8_4_3.html
 share/doc/sqlite3/releaselog/3_8_5.html
 share/doc/sqlite3/releaselog/3_8_6.html
+share/doc/sqlite3/releaselog/3_8_7.html
 share/doc/sqlite3/releaselog/current.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/rescode.html
@@ -641,6 +645,66 @@
 share/doc/sqlite3/spellfix1.html
 share/doc/sqlite3/sqlite.html
 share/doc/sqlite3/support.html
+share/doc/sqlite3/syntax.html
+share/doc/sqlite3/syntax/alter-table-stmt.html
+share/doc/sqlite3/syntax/analyze-stmt.html
+share/doc/sqlite3/syntax/attach-stmt.html
+share/doc/sqlite3/syntax/begin-stmt.html
+share/doc/sqlite3/syntax/column-constraint.html
+share/doc/sqlite3/syntax/column-def.html
+share/doc/sqlite3/syntax/comment-syntax.html
+share/doc/sqlite3/syntax/commit-stmt.html
+share/doc/sqlite3/syntax/common-table-expression.html
+share/doc/sqlite3/syntax/compound-operator.html
+share/doc/sqlite3/syntax/compound-select-stmt.html
+share/doc/sqlite3/syntax/conflict-clause.html
+share/doc/sqlite3/syntax/create-index-stmt.html
+share/doc/sqlite3/syntax/create-table-stmt.html
+share/doc/sqlite3/syntax/create-trigger-stmt.html
+share/doc/sqlite3/syntax/create-view-stmt.html
+share/doc/sqlite3/syntax/create-virtual-table-stmt.html
+share/doc/sqlite3/syntax/cte-table-name.html
+share/doc/sqlite3/syntax/delete-stmt-limited.html
+share/doc/sqlite3/syntax/delete-stmt.html
+share/doc/sqlite3/syntax/detach-stmt.html
+share/doc/sqlite3/syntax/drop-index-stmt.html
+share/doc/sqlite3/syntax/drop-table-stmt.html
+share/doc/sqlite3/syntax/drop-trigger-stmt.html
+share/doc/sqlite3/syntax/drop-view-stmt.html
+share/doc/sqlite3/syntax/expr.html
+share/doc/sqlite3/syntax/factored-select-stmt.html
+share/doc/sqlite3/syntax/foreign-key-clause.html
+share/doc/sqlite3/syntax/indexed-column.html
+share/doc/sqlite3/syntax/insert-stmt.html
+share/doc/sqlite3/syntax/join-clause.html
+share/doc/sqlite3/syntax/join-constraint.html
+share/doc/sqlite3/syntax/join-operator.html
+share/doc/sqlite3/syntax/literal-value.html
+share/doc/sqlite3/syntax/numeric-literal.html
+share/doc/sqlite3/syntax/ordering-term.html
+share/doc/sqlite3/syntax/pragma-stmt.html
+share/doc/sqlite3/syntax/pragma-value.html
+share/doc/sqlite3/syntax/qualified-table-name.html
+share/doc/sqlite3/syntax/raise-function.html
+share/doc/sqlite3/syntax/recursive-cte.html
+share/doc/sqlite3/syntax/reindex-stmt.html
+share/doc/sqlite3/syntax/release-stmt.html
+share/doc/sqlite3/syntax/result-column.html
+share/doc/sqlite3/syntax/rollback-stmt.html
+share/doc/sqlite3/syntax/savepoint-stmt.html
+share/doc/sqlite3/syntax/select-core.html
+share/doc/sqlite3/syntax/select-stmt.html
+share/doc/sqlite3/syntax/signed-number.html
+share/doc/sqlite3/syntax/simple-select-stmt.html
+share/doc/sqlite3/syntax/sql-stmt-list.html
+share/doc/sqlite3/syntax/sql-stmt.html
+share/doc/sqlite3/syntax/table-constraint.html
+share/doc/sqlite3/syntax/table-or-subquery.html
+share/doc/sqlite3/syntax/type-name.html
+share/doc/sqlite3/syntax/update-stmt-limited.html
+share/doc/sqlite3/syntax/update-stmt.html
+share/doc/sqlite3/syntax/vacuum-stmt.html
+share/doc/sqlite3/syntax/with-clause.html
 share/doc/sqlite3/syntaxdiagrams.html
 share/doc/sqlite3/tclsqlite.html
 share/doc/sqlite3/tempfiles.html
cvs diff -r1.30 -r1.31 pkgsrc/databases/sqlite3-docs/distinfo (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-docs/distinfo 2014/08/17 08:16:06 1.30
+++ pkgsrc/databases/sqlite3-docs/distinfo 2014/10/19 20:37:47 1.31
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.30 2014/08/17 08:16:06 adam Exp $
+$NetBSD: distinfo,v 1.31 2014/10/19 20:37:47 adam Exp $
 
-SHA1 (sqlite-doc-3080600.zip) = 8c3d3a9f97b10fb43d6fce61079ed1ab93472913
+SHA1 (sqlite-doc-3080700.zip) = b091631340c051455e349e651d9c24579e00f669
-RMD160 (sqlite-doc-3080600.zip) = daf74c6bdb1775eb349220bdab45d236c77e31d0
+RMD160 (sqlite-doc-3080700.zip) = aa480c654d319cbb25ec3fe97b4edbdf0a0e196c
-Size (sqlite-doc-3080600.zip) = 4736026 bytes
+Size (sqlite-doc-3080700.zip) = 4901008 bytes
cvs diff -r1.63 -r1.64 pkgsrc/databases/sqlite3-tcl/Makefile (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-tcl/Makefile 2014/10/07 16:47:21 1.63
+++ pkgsrc/databases/sqlite3-tcl/Makefile 2014/10/19 20:37:47 1.64
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.63 2014/10/07 16:47:21 adam Exp $
+# $NetBSD: Makefile,v 1.64 2014/10/19 20:37:47 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3080600
-PKGNAME=	sqlite3-tcl-3.8.6
-PKGREVISION=	1
+DISTNAME=	sqlite-autoconf-3080700
+PKGNAME=	sqlite3-tcl-3.8.7
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2014/ \
 		http://www.sqlite.org/2014/
cvs diff -r1.43 -r1.44 pkgsrc/databases/sqlite3-tcl/distinfo (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-tcl/distinfo 2014/08/17 08:16:06 1.43
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2014/10/19 20:37:47 1.44
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.43 2014/08/17 08:16:06 adam Exp $
+$NetBSD: distinfo,v 1.44 2014/10/19 20:37:47 adam Exp $
 
-SHA1 (sqlite-autoconf-3080600.tar.gz) = c4b2911bc4a6e1dc2b411aa21d8c4f524113eb64
-RMD160 (sqlite-autoconf-3080600.tar.gz) = 31a5c239174e4cf74fd0e9cf4324fa0e6282aaab
-Size (sqlite-autoconf-3080600.tar.gz) = 1968379 bytes
+SHA1 (sqlite-autoconf-3080700.tar.gz) = 8b773b006db46f3ffcbabe065e927823d13bf5c0
+RMD160 (sqlite-autoconf-3080700.tar.gz) = 6a08748fffa7e5e504e250a9dba69c15fefa98da
+Size (sqlite-autoconf-3080700.tar.gz) = 1998217 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d