- Update to 3.17.0

* Approximately 25% better performance from the R-Tree extension.
  * Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
  * Increase the default lookaside size from 512,125 to 1200,100
    as this provides better performance while only adding 56KB of
    extra memory per connection.
  * Use compiler built-ins __builtin_sub_overflow(), 
    __builtin_add_overflow(), and __builtin_mul_overflow() 
   when available.
  * Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which
    can result in significantly smaller database files for some
    applications, at the risk of being incompatible with older
    versions of SQLite.
  * Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for
    improved performance.
  * Added the SQLITE_UINT64_TYPE compile-time option as an analog
    to SQLITE_INT64_TYPE.
  * Perform some UPDATE operations in a single pass instead of in
    two passes.
  * Enhance the session extension to support WITHOUT ROWID tables.
  * Fixed performance problems and potential stack overflows when
    creating views from multi-row VALUES clauses with hundreds of
    thousands of rows.
  * Added the sha1.c extension.
  * In the command-line shell, enhance the ".mode" command so that
    it restores the default column and row separators for modes 
    "line", "list", "column", and "tcl".
  * Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it
    works in WAL mode as long as the pages being read are not
    in the WAL file.

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

sqlite-autoconf-3160200.tar.gz

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

sqlite-autoconf-3170000.tar.gz

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

sqlite-doc-3160200.zip

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

sqlite-doc-3170000.zip

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

sqlite3.changes

@@ -1,3 +1,49 @@
+-------------------------------------------------------------------
+Tue Feb 14 09:19:28 UTC 2017 - idonmez@suse.com
+
+- Update to 3.17.0
+  * Approximately 25% better performance from the R-Tree extension.
+  * Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
+  * Increase the default lookaside size from 512,125 to 1200,100
+    as this provides better performance while only adding 56KB of
+    extra memory per connection.
+  * Use compiler built-ins __builtin_sub_overflow(), 
+    __builtin_add_overflow(), and __builtin_mul_overflow() 
+   when available.
+  * Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which
+    can result in significantly smaller database files for some
+    applications, at the risk of being incompatible with older
+    versions of SQLite.
+  * Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for
+    improved performance.
+  * Added the SQLITE_UINT64_TYPE compile-time option as an analog
+    to SQLITE_INT64_TYPE.
+  * Perform some UPDATE operations in a single pass instead of in
+    two passes.
+  * Enhance the session extension to support WITHOUT ROWID tables.
+  * Fixed performance problems and potential stack overflows when
+    creating views from multi-row VALUES clauses with hundreds of
+    thousands of rows.
+  * Added the sha1.c extension.
+  * In the command-line shell, enhance the ".mode" command so that
+    it restores the default column and row separators for modes 
+    "line", "list", "column", and "tcl".
+  * Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it
+    works in WAL mode as long as the pages being read are not
+    in the WAL file.
+  * Enhance the LEMON parser generator so that it can store the
+    parser object as a stack variable rather than allocating space
+    from the heap and make use of that enhancement in the amalgamation.
+  * Other performance improvements. Uses about 6.5% fewer CPU cycles.
+  * Throw an error if the ON clause of a LEFT JOIN references
+    tables to the right of the ON clause. This is the same behavior
+    as PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN
+    into an INNER JOIN. Fix for ticket 25e335f802dd.
+  * Use the correct affinity for columns of automatic indexes.
+    Ticket 7ffd1ca1d2ad4ec.
+  * Ensure that the sqlite3_blob_reopen() interface can correctly
+    handle short rows. Fix for ticket e6e962d6b0f06f46e. 
+
 -------------------------------------------------------------------
 Sat Jan  7 16:44:32 UTC 2017 - mpluskal@suse.com
 

sqlite3.spec

@@ -17,9 +17,9 @@
 
 
 %define oname sqlite
-%define tarversion 3160200
+%define tarversion 3170000
 Name:           sqlite3
-Version:        3.16.2
+Version:        3.17.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain