- New Version 3.7.16:

* Added the PRAGMA foreign_key_check command.
  * Added new extended error codes for all SQLITE_CONSTRAINT
    errors
  * Added the SQLITE_READONLY_ROLLBACK extended error code for
    when a database cannot be opened because it needs rollback
    recovery but is read-only.
  * Added SQL functions unicode(A) and char(X1,...,XN).
  * Performance improvements for PRAGMA incremental_vacuum,
    especially in cases where the number of free pages is greater
    than what will fit on a single trunk page of the freelist.
  * Improved optimization of queries containing aggregate min() or
    max().
  * Enhance virtual tables so that they can potentially use an
    index when the WHERE clause contains the IN operator.
  * Allow indices to be used for sorting even if prior terms of
    the index are constrained by IN operators in the WHERE clause.
  * Enhance the PRAGMA table_info command so that the "pk" column
    is an increasing integer to show the order of columns in the
    primary key.
  * Enhance the query optimizer to exploit transitive join
    constraints.
  * Performance improvements in the query optimizer.
  * Allow the error message from PRAGMA integrity_check to be
    longer than 20000 bytes.
  * Improved name resolution for deeply nested queries.
  * Added the test_regexp.c module as a demonstration of how to
    implement the REGEXP operator.
  * Improved error messages in the RTREE extension.
  * Enhance the command-line shell so that a non-zero argument to

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

sqlite-autoconf-3071502.tar.gz

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

sqlite-autoconf-3071600.tar.gz

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

sqlite3.changes

@@ -1,3 +1,63 @@
+-------------------------------------------------------------------
+Wed Mar 20 12:09:38 UTC 2013 - max@suse.com
+
+- New Version 3.7.16:
+  * Added the PRAGMA foreign_key_check command.
+  * Added new extended error codes for all SQLITE_CONSTRAINT
+    errors
+  * Added the SQLITE_READONLY_ROLLBACK extended error code for
+    when a database cannot be opened because it needs rollback
+    recovery but is read-only.
+  * Added SQL functions unicode(A) and char(X1,...,XN).
+  * Performance improvements for PRAGMA incremental_vacuum,
+    especially in cases where the number of free pages is greater
+    than what will fit on a single trunk page of the freelist.
+  * Improved optimization of queries containing aggregate min() or
+    max().
+  * Enhance virtual tables so that they can potentially use an
+    index when the WHERE clause contains the IN operator.
+  * Allow indices to be used for sorting even if prior terms of
+    the index are constrained by IN operators in the WHERE clause.
+  * Enhance the PRAGMA table_info command so that the "pk" column
+    is an increasing integer to show the order of columns in the
+    primary key.
+  * Enhance the query optimizer to exploit transitive join
+    constraints.
+  * Performance improvements in the query optimizer.
+  * Allow the error message from PRAGMA integrity_check to be
+    longer than 20000 bytes.
+  * Improved name resolution for deeply nested queries.
+  * Added the test_regexp.c module as a demonstration of how to
+    implement the REGEXP operator.
+  * Improved error messages in the RTREE extension.
+  * Enhance the command-line shell so that a non-zero argument to
+    the ".exit" command causes the shell to exit immediately
+    without cleanly shutting down the database connection.
+  * Improved error messages for invalid boolean arguments to
+    dot-commands in the command-line shell.
+  * Improved error messages for "foreign key mismatch" showing the
+    names of the two tables involved.
+  * Remove all uses of umask() in the unix VFS.
+  * Added the PRAGMA vdbe_addoptrace and PRAGMA vdbe_debug
+    commands.
+  * Change to use strncmp() or the equivalent instead of memcmp()
+    when comparing non-zero-terminated strings.
+  * Update cygwin interfaces to omit deprecated API calls.
+  * Enhance the spellfix1 extension so that the edit distance cost
+    table can be changed at runtime by inserting a string like
+    'edit_cost_table=TABLE' into the "command" field.
+  * Bug fix: repair a long-standing problem that could cause
+    incorrect query results in a 3-way or larger join that
+    compared INTEGER fields against TEXT fields in two or more
+    places. Ticket fc7bd6358f
+  * Bug fix: Issue an error message if the 16-bit reference
+    counter on a view overflows due to an overly complex query.
+  * Bug fix: Avoid leaking memory on LIMIT and OFFSET clauses in
+    deeply nested UNION ALL queries.
+  * Bug fix: Make sure the schema is up-to-date prior to running
+    pragmas table_info, index_list, index_info, and
+    foreign_key_list.
+
 -------------------------------------------------------------------
 Thu Jan 24 14:19:25 UTC 2013 - max@suse.com
 

sqlite3.spec

@@ -17,9 +17,9 @@
 
 
 Name:           sqlite3
-Version:        3.7.15.2
+Version:        3.7.16
 Release:        0
-%define tarversion 3071502
+%define tarversion 3071600
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
 Group:          Productivity/Databases/Servers
@@ -35,7 +35,7 @@ BuildRequires:  update-desktop-files
 Requires:       libsqlite3-0 = %version
 Provides:       sqlite = %version
 Obsoletes:      sqlite < %version
-Source0:        sqlite-autoconf-%tarversion.tar.gz
+Source0:        http://www.sqlite.org/2013/sqlite-autoconf-%tarversion.tar.gz
 Source1:        baselibs.conf
 BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 # bug437293