Accepting request 484084 from server:database

- Update to 3.18.0
  * Added the PRAGMA optimize command
  * The SQLite version identifier returned by the sqlite_source_id()
    SQL function and the sqlite3_sourceid() C API and found in the
    SQLITE_SOURCE_ID macro is now a 64-digit SHA3-256 hash instead
    of a 40-digit SHA1 hash.
  * Added the json_patch() SQL function to the JSON1 extension.
  * Enhance the LIKE optimization so that it works for arbitrary
    expressions on the left-hand side as long as the LIKE pattern
    on the right-hand side does not begin with a digit or minus sign.
  * Added the sqlite3_set_last_insert_rowid() interface and use the
    new interface in the FTS3, FTS4, and FTS5 extensions to ensure
    that the sqlite3_last_insert_rowid() interface always returns
    reasonable values.
  * Enhance PRAGMA integrity_check and PRAGMA quick_check so that
    they verify CHECK constraints.
  * Enhance the query plans for joins to detect empty tables early
    and halt without doing unnecessary work.
  * Enhance the sqlite3_mprintf() family of interfaces and the
    printf SQL function to put comma separators at the thousands
    marks for integers, if the "," format modifier is used in
    between the "%" and the "d" (example: "%,d").
  * Added the -DSQLITE_MAX_MEMORY=N compile-time option.
  * Added the .sha3sum dot-command and the .selftest dot-command
    to the command-line shell
  * Begin enforcing SQLITE_LIMIT_VDBE_OP. This can be used, 
    for example, to prevent excessively large prepared statements 
    in systems that accept SQL queries from untrusted users.
  * Various performance improvements.
  * Ensure that indexed expressions with collating sequences are

OBS-URL: https://build.opensuse.org/request/show/484084
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=96

sqlite-autoconf-3170000.tar.gz

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

sqlite-autoconf-3180000.tar.gz

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

sqlite-doc-3170000.zip

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

sqlite-doc-3180000.zip

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

sqlite3.changes

@@ -1,3 +1,47 @@
+-------------------------------------------------------------------
+Fri Mar 31 12:03:54 UTC 2017 - idonmez@suse.com
+
+- Update to 3.18.0
+  * Added the PRAGMA optimize command
+  * The SQLite version identifier returned by the sqlite_source_id()
+    SQL function and the sqlite3_sourceid() C API and found in the
+    SQLITE_SOURCE_ID macro is now a 64-digit SHA3-256 hash instead
+    of a 40-digit SHA1 hash.
+  * Added the json_patch() SQL function to the JSON1 extension.
+  * Enhance the LIKE optimization so that it works for arbitrary
+    expressions on the left-hand side as long as the LIKE pattern
+    on the right-hand side does not begin with a digit or minus sign.
+  * Added the sqlite3_set_last_insert_rowid() interface and use the
+    new interface in the FTS3, FTS4, and FTS5 extensions to ensure
+    that the sqlite3_last_insert_rowid() interface always returns
+    reasonable values.
+  * Enhance PRAGMA integrity_check and PRAGMA quick_check so that
+    they verify CHECK constraints.
+  * Enhance the query plans for joins to detect empty tables early
+    and halt without doing unnecessary work.
+  * Enhance the sqlite3_mprintf() family of interfaces and the
+    printf SQL function to put comma separators at the thousands
+    marks for integers, if the "," format modifier is used in
+    between the "%" and the "d" (example: "%,d").
+  * Added the -DSQLITE_MAX_MEMORY=N compile-time option.
+  * Added the .sha3sum dot-command and the .selftest dot-command
+    to the command-line shell
+  * Begin enforcing SQLITE_LIMIT_VDBE_OP. This can be used, 
+    for example, to prevent excessively large prepared statements 
+    in systems that accept SQL queries from untrusted users.
+  * Various performance improvements.
+  * Ensure that indexed expressions with collating sequences are
+    handled correctly. Fix for ticket eb703ba7b50c1a5.
+  * Fix a bug in the 'start of ...' modifiers for the date and
+    time functions. Ticket 6097cb92745327a1
+  * Fix a potential segfault in complex recursive triggers,
+    resulting from a bug in the OP_Once opcode introduced as part
+    of a performance optimization in version 3.15.0. Ticket 06796225f59c057c
+  * In the RBU extension, add extra sync operations to avoid the
+    possibility of corruption following a power failure.
+  * The sqlite3_trace_v2() output for nested SQL statements should
+    always begin with a "--" comment marker.
+
 -------------------------------------------------------------------
 Wed Feb 15 18:30:53 UTC 2017 - dimstar@opensuse.org
 

sqlite3.spec

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