Accepting request 257487 from home:AndreasStieger:branches:server:database

SQLite 3.8.7

OBS-URL: https://build.opensuse.org/request/show/257487
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=106

sqlite-autoconf-3080600.tar.gz

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:53bab14255bc16c3d73fdbe54b364c1764709d68dda167587f8026c98b9f4e95
-size 1968379

sqlite-autoconf-3080700.tar.gz

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:d0b42377fb59ea8dfe690334af04505e34e60e6875058a01aebd2502ac63d4ae
+size 1998217

sqlite-doc-3080600.zip

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:c187ffe719e35ab03970db4d1fb4a4865ae4f8d943ceaaa79f635a51d982ca6e
-size 4736026

sqlite-doc-3080700.zip

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:79126f7035ae1b32029e8943db492cf82bc617109245fa9a08ec71072122a0eb
+size 4901008

sqlite3.changes

@@ -1,3 +1,63 @@
+-------------------------------------------------------------------
+Fri Oct 17 19:45:26 UTC 2014 - andreas.stieger@gmx.de
+
+- SQLite 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 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()
+      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.
+- Test, Debug, and Analysis Changes:
+  * Show ASCII-art abstract syntax tree diagrams using the
+    ".selecttrace" and ".wheretrace" commands in the command-line
+    shell when compiled with SQLITE_DEBUG,
+    SQLITE_ENABLE_SELECTTRACE, and SQLITE_ENABLE_WHERETRACE.
+    Also provide the sqlite3TreeViewExpr() and
+    sqlite3TreeViewSelect() entry points that can be invoked
+    from with the debugger to show the parse tree when stopped at
+    a breakpoint.
+  * Drop support for SQLITE_ENABLE_TREE_EXPLAIN. The SELECTTRACE
+    mechanism provides more useful diagnostics information.
+  * New options to the command-line shell for configuring auxiliary
+    memory usage: --pagecache, --lookaside, and --scratch.
+
 -------------------------------------------------------------------
 Fri Aug 15 18:13:00 UTC 2014 - andreas.stieger@gmx.de
 

sqlite3.spec

@@ -21,9 +21,9 @@
 %define oname sqlite
 
 Name:           %pname
-Version:        3.8.6
+Version:        3.8.7
 Release:        0
-%define tarversion 3080600
+%define tarversion 3080700
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
 Group:          Productivity/Databases/Servers