- Update to 3.19.0

* The SQLITE_READ authorizer callback is invoked once with a
    column name that is an empty string for every table referenced
    in a query from which no columns are extracted.
  * When using an index on an expression, try to use expression
    values already available in the index, rather than loading
    the original columns and recomputing the expression.
  * Enhance the flattening optimization so that it is able to
    flatten views on the right-hand side of a LEFT JOIN.
  * Use replace() instead of char() for escaping newline and
    carriage-return characters embedded in strings in the .dump
    output from the command-line shell.
  * Avoid unnecessary foreign key processing in UPDATE statements
    that do not touch the columns that are constrained by the
    foreign keys.
  * On a DISTINCT query that uses an index, try to skip ahead
    to the next distinct entry using the index rather than
    stepping through rows, when an appropriate index is available.
  * Avoid unnecessary invalidation of sqlite3_blob handles
    when making changes to unrelated tables.
  * Transfer any terms of the HAVING clause that use only
    columns mentioned in the GROUP BY clause over to the
    WHERE clause for faster processing.
  * Reuse the same materialization of a VIEW if that VIEW
    appears more than once in the same query.
  * Enhance PRAGMA integrity_check so that it identifies
    tables that have two or more rows with the same rowid.
  * Enhance the FTS5 query syntax so that column filters
    may be applied to arbitrary expressions.
  * Enhance the json_extract() function to cache and

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

sqlite-autoconf-3180000.tar.gz

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

sqlite-autoconf-3190000.tar.gz

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

sqlite-doc-3180000.zip

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

sqlite-doc-3190000.zip

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

sqlite3.changes

@@ -1,3 +1,54 @@
+-------------------------------------------------------------------
+Mon May 22 18:47:42 UTC 2017 - idonmez@suse.com
+
+- Update to 3.19.0
+  * The SQLITE_READ authorizer callback is invoked once with a
+    column name that is an empty string for every table referenced
+    in a query from which no columns are extracted.
+  * When using an index on an expression, try to use expression
+    values already available in the index, rather than loading
+    the original columns and recomputing the expression.
+  * Enhance the flattening optimization so that it is able to
+    flatten views on the right-hand side of a LEFT JOIN.
+  * Use replace() instead of char() for escaping newline and
+    carriage-return characters embedded in strings in the .dump
+    output from the command-line shell.
+  * Avoid unnecessary foreign key processing in UPDATE statements
+    that do not touch the columns that are constrained by the
+    foreign keys.
+  * On a DISTINCT query that uses an index, try to skip ahead
+    to the next distinct entry using the index rather than
+    stepping through rows, when an appropriate index is available.
+  * Avoid unnecessary invalidation of sqlite3_blob handles
+    when making changes to unrelated tables.
+  * Transfer any terms of the HAVING clause that use only
+    columns mentioned in the GROUP BY clause over to the
+    WHERE clause for faster processing.
+  * Reuse the same materialization of a VIEW if that VIEW
+    appears more than once in the same query.
+  * Enhance PRAGMA integrity_check so that it identifies
+    tables that have two or more rows with the same rowid.
+  * Enhance the FTS5 query syntax so that column filters
+    may be applied to arbitrary expressions.
+  * Enhance the json_extract() function to cache and
+    reuse parses of JSON input text.
+  * Added the anycollseq.c loadable extension that allows a
+    generic SQLite database connection to read a schema that
+    contains unknown and/or application-specific collating sequences.
+  * Fix a problem in REPLACE that can result in a corrupt
+    database containing two ore more rows with the same rowid.
+    Fix for ticket f68dc596c4e6018d.
+  * Fix a problem in PRAGMA integrity_check that was causing a
+    subsequent VACUUM to behave suboptimally.
+    so that it works correctly with foreign keys on WITHOUT ROWID tables.
+  * Disallow leading zeros in numeric constants in JSON.
+    Fix for ticket b93be8729a895a528e2.
+  * Disallow control characters inside of strings in JSON.
+    Fix for ticket 6c9b5514077fed34551.
+  * Limit the depth of recursion for JSON objects and arrays in orde
+    to avoid excess stack usage in the recursive descent parser.
+    Fix for ticket 981329adeef51011052.
+
 -------------------------------------------------------------------
 Fri Mar 31 12:03:54 UTC 2017 - idonmez@suse.com
 

sqlite3.spec

@@ -17,9 +17,9 @@
 
 
 %define oname sqlite
-%define tarversion 3180000
+%define tarversion 3190000
 Name:           sqlite3
-Version:        3.18.0
+Version:        3.19.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain