Accepting request 122063 from server:database

Version 3.7.12.1

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

79a4a3a84f.patch

@@ -1,17 +0,0 @@
-Index: sqlite-autoconf-3071100/sqlite3.c
-===================================================================
---- sqlite-autoconf-3071100.orig/sqlite3.c
-+++ sqlite-autoconf-3071100/sqlite3.c
-@@ -67595,8 +67595,10 @@ case OP_Savepoint: {
-         rc = p->rc;
-       }else{
-         u.ar.iSavepoint = db->nSavepoint - u.ar.iSavepoint - 1;
--        for(u.ar.ii=0; u.ar.ii<db->nDb; u.ar.ii++){
--          sqlite3BtreeTripAllCursors(db->aDb[u.ar.ii].pBt, SQLITE_ABORT);
-+        if( u.ar.p1==SAVEPOINT_ROLLBACK ){
-+            for(u.ar.ii=0; u.ar.ii<db->nDb; u.ar.ii++){
-+                sqlite3BtreeTripAllCursors(db->aDb[u.ar.ii].pBt, SQLITE_ABORT);
-+            }
-         }
-         for(u.ar.ii=0; u.ar.ii<db->nDb; u.ar.ii++){
-           rc = sqlite3BtreeSavepoint(db->aDb[u.ar.ii].pBt, u.ar.p1, u.ar.iSavepoint);

sqlite-autoconf-3071100.tar.gz

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

sqlite-autoconf-3071201.tar.gz

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

sqlite3.changes

@@ -1,3 +1,45 @@
+-------------------------------------------------------------------
+Thu May 24 07:39:26 UTC 2012 - max@suse.com
+
+- New version 3.7.12:
+  * Add the SQLITE_DBSTATUS_CACHE_WRITE option for
+    sqlite3_db_status().
+  * Optimize the typeof() and length() SQL functions so that they
+    avoid unnecessary reading of database content from disk.
+  * Add the FTS4 "merge" command, the FTS4 "automerge" command,
+    and the FTS4 "integrity-check" command.
+  * Report the name of specific CHECK constraints that fail.
+  * In the command-line shell, use popen() instead of fopen() if
+    the first character of the argument to the ".output" command
+    is "|".
+  * Make use of OVERLAPPED in the windows VFS to avoid some system
+    calls and thereby obtain a performance improvement.
+  * More aggressive optimization of the AND operator when one side
+    or the other is always false.
+  * Improved performance of queries with many OR-connected terms
+    in the WHERE clause that can all be indexed.
+  * Add the SQLITE_RTREE_INT_ONLY compile-time option to force the
+    R*Tree Extension Module to use integer instead of floating
+    point values for both storage and computation.
+  * Enhance the PRAGMA integrity_check command to use much less
+    memory when processing multi-gigabyte databases.
+  * New interfaces added to the test_quota.c add-on module.
+  * Added the ".trace" dot-command to the command-line shell.
+  * Allow virtual table constructors to be invoked recursively.
+  * Improved optimization of ORDER BY clauses on compound queries.
+  * Improved optimization of aggregate subqueries contained within
+    an aggregate query.
+  * Bug fix: Fix the RELEASE command so that it does not cancel
+    pending queries. This repairs a problem introduced in 3.7.11.
+  * Bug fix: Do not discard the DISTINCT as superfluous unless a
+    subset of the result set is subject to a UNIQUE constraint and
+    it none of the columns in that subset can be NULL. Ticket
+    385a5b56b9.
+  * Bug fix: Do not optimize away an ORDER BY clause that has the
+    same terms as a UNIQUE index unless those terms are also NOT
+    NULL. Ticket 2a5629202f.
+- 79a4a3a84f.patch isn't needed anymore.
+
 -------------------------------------------------------------------
 Mon May 14 09:53:58 UTC 2012 - idonmez@suse.com
 

sqlite3.spec

@@ -17,9 +17,9 @@
 
 
 Name:           sqlite3
-Version:        3.7.11
+Version:        3.7.12.1
 Release:        0
-%define tarversion 3071100
+%define tarversion 3071201
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
 Group:          Productivity/Databases/Servers
@@ -37,7 +37,6 @@ Provides:       sqlite = %version
 Obsoletes:      sqlite < %version
 Source0:        sqlite-autoconf-%tarversion.tar.gz
 Source1:        baselibs.conf
-Patch1:         79a4a3a84f.patch
 BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 # bug437293
 %ifarch ppc64
@@ -113,7 +112,6 @@ database access without running a separate RDBMS process.
 
 %prep
 %setup -q -n sqlite-autoconf-%tarversion
-%patch1 -p1
 
 %build
 export CFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_USE_URI"