Hello community, here is the log from the commit of package sqlite3 for openSUSE:Factory checked in at 2017-06-01 16:29:14 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Package is "sqlite3" Thu Jun 1 16:29:14 2017 rev:97 rq:498338 version:3.19.2 Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2017-04-17 10:20:57.927638830 +0200 +++ /work/SRC/openSUSE:Factory/.sqlite3.new/sqlite3.changes 2017-06-01 16:29:15.624514793 +0200 @@ -1,0 +2,60 @@ +Thu May 25 17:52:39 UTC 2017 - idonmez@suse.com + +- Update to 3.19.2 + * Fix a bug in the LEFT JOIN flattening optimization. + Ticket cad1ab4cb7b0fc. + * Fix more bugs in the LEFT JOIN flattening optimization. + Ticket 7fde638e94287d2c. + +------------------------------------------------------------------- +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. + +------------------------------------------------------------------- Old: ---- sqlite-autoconf-3180000.tar.gz sqlite-doc-3180000.zip New: ---- sqlite-autoconf-3190200.tar.gz sqlite-doc-3190200.zip ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.u9h9Mf/_old 2017-06-01 16:29:16.440399751 +0200 +++ /var/tmp/diff_new_pack.u9h9Mf/_new 2017-06-01 16:29:16.440399751 +0200 @@ -17,9 +17,9 @@ %define oname sqlite -%define tarversion 3180000 +%define tarversion 3190200 Name: sqlite3 -Version: 3.18.0 +Version: 3.19.2 Release: 0 Summary: Embeddable SQL Database Engine License: SUSE-Public-Domain ++++++ sqlite-autoconf-3180000.tar.gz -> sqlite-autoconf-3190200.tar.gz ++++++ ++++ 8013 lines of diff (skipped)