From 344dfca0b5f2a8fd1762ca6831e864ef29e20d9b Mon Sep 17 00:00:00 2001 From: adam Date: Sun, 19 Oct 2014 20:37:47 +0000 Subject: 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. --- databases/sqlite3-docs/Makefile | 6 ++-- databases/sqlite3-docs/PLIST | 66 ++++++++++++++++++++++++++++++++++++++++- databases/sqlite3-docs/distinfo | 8 ++--- 3 files changed, 72 insertions(+), 8 deletions(-) (limited to 'databases/sqlite3-docs') diff --git a/databases/sqlite3-docs/Makefile b/databases/sqlite3-docs/Makefile index 0867cbdcea7..0aeccbea9fb 100644 --- a/databases/sqlite3-docs/Makefile +++ b/databases/sqlite3-docs/Makefile @@ -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/ diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST index 24b3bf0457e..ac404586d92 100644 --- a/databases/sqlite3-docs/PLIST +++ b/databases/sqlite3-docs/PLIST @@ -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/apple-touch-icon.png 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/mingw.html 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_2.html 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/speed.html 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 diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo index aa18a48211e..36aa64796c6 100644 --- a/databases/sqlite3-docs/distinfo +++ b/databases/sqlite3-docs/distinfo @@ -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 -RMD160 (sqlite-doc-3080600.zip) = daf74c6bdb1775eb349220bdab45d236c77e31d0 -Size (sqlite-doc-3080600.zip) = 4736026 bytes +SHA1 (sqlite-doc-3080700.zip) = b091631340c051455e349e651d9c24579e00f669 +RMD160 (sqlite-doc-3080700.zip) = aa480c654d319cbb25ec3fe97b4edbdf0a0e196c +Size (sqlite-doc-3080700.zip) = 4901008 bytes -- cgit v1.2.3