Hello community, here is the log from the commit of package sqlite3 for openSUSE:Factory checked in at 2016-08-17 12:03:59 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Package is "sqlite3" Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2016-08-05 18:14:19.000000000 +0200 +++ /work/SRC/openSUSE:Factory/.sqlite3.new/sqlite3.changes 2016-08-17 12:04:01.000000000 +0200 @@ -1,0 +2,61 @@ +Sun Aug 14 07:26:23 UTC 2016 - astieger@suse.com + +- SQlite 3.14.1: + * A performance enhancement to the page-cache "truncate" + operation reduces COMMIT time by dozens of milliseconds on + systems with a large page cache + * Fix to the --rbu option of sqldiff. + +------------------------------------------------------------------- +Mon Aug 8 18:06:28 UTC 2016 - idonmez@suse.com + +- SQLite 3.14.0 + * Added support for WITHOUT ROWID virtual tables. + * Improved the query planner so that the OR optimization can be + used on virtual tables even if one or more of the disjuncts use + the LIKE, GLOB, REGEXP, MATCH operators. + * Added the CSV virtual table for reading RFC 4180 formatted + comma-separated value files. + * Added the carray() table-valued function extension. + * Enabled persistent loadable extensions using the new + SQLITE_OK_LOAD_PERMANENTLY return code from the extension + entry point. + * Added the SQLITE_DBSTATUS_CACHE_USED_SHARED option to + sqlite3_db_status(). + * Add the vfsstat.c loadable extension - a VFS shim that measures + I/O together with an eponymous virtual table that provides access + to the measurements. + * Improved algorithm for running queries with both an ORDER BY + and a LIMIT where only the inner-most loop naturally generates + rows in the correct order. + * Enhancements to Lemon parser generator, so that it generates a + faster parser. + * The PRAGMA compile_options command now attempts to show the version + number of the compiler that generated the library. + * Enhance PRAGMA table_info so that it provides information about + eponymous virtual tables. + * The query planner uses a full scan of a partial index instead of + a full scan of the main table, in cases where that makes sense. + * Allow table-valued functions to appear on the right-hand side + of an IN operator. + * Added two new C-language interfaces: sqlite3_expanded_sql() + and sqlite3_trace_v2(). These new interfaces subsume the + functions of sqlite3_trace() and sqlite3_profile() which are + now deprecated. + * Added the json_quote() SQL function to the json1 extension. + * Disable the authorizer callback while reparsing the schema. + * Added the SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option and + turned that option on by default when building the command-line shell. + * Fix the ALTER TABLE command so that it does not corrupt descending + indexes when adding a column to a legacy file format database. + Ticket f68bf68513a1c15f + * Fix a NULL-pointer dereference/crash that could occurs when a + transitive WHERE clause references a non-existent collating + sequence. Ticket e8d439c77685eca6. + * Improved the cost estimation for an index scan which includes a WHERE + clause that can be partially or fully evaluated using columns in the index + and without having to do a table lookup. This fixes a performance regression + that occurred for some obscure queries following the ORDER BY LIMIT optimization + introduced in version 3.12.0. + +------------------------------------------------------------------- @@ -23 +84,2 @@ - both EXPLAIN and EXPLAIN QUERY PLAN on each statement that is evaluated. + both EXPLAIN and EXPLAIN QUERY PLAN on each statement that is + evaluated. @@ -31,2 +93,3 @@ - directories with write and execute permission, but without read permission, - to serve as temporary directories. Apply this same standard to the "." fallback directory. + directories with write and execute permission, but without read + permission, to serve as temporary directories. Apply this same + standard to the "." fallback directory. @@ -39,2 +102,2 @@ - of the indexes reference any table columns other than the INTEGER PRIMARY KEY. - Ticket 16c9801ceba49. + of the indexes reference any table columns other than the + INTEGER PRIMARY KEY. Ticket 16c9801ceba49. Old: ---- sqlite-autoconf-3130000.tar.gz sqlite-doc-3130000.zip New: ---- sqlite-autoconf-3140100.tar.gz sqlite-doc-3140100.zip ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.Of1hNu/_old 2016-08-17 12:04:03.000000000 +0200 +++ /var/tmp/diff_new_pack.Of1hNu/_new 2016-08-17 12:04:03.000000000 +0200 @@ -17,9 +17,9 @@ %define oname sqlite -%define tarversion 3130000 +%define tarversion 3140100 Name: sqlite3 -Version: 3.13.0 +Version: 3.14.1 Release: 0 Summary: Embeddable SQL Database Engine License: SUSE-Public-Domain ++++++ sqlite-autoconf-3130000.tar.gz -> sqlite-autoconf-3140100.tar.gz ++++++ ++++ 11358 lines of diff (skipped)